Prices

​
Column
Type
Description
timestamp
TIMESTAMP_NTZ
Timestamp of when the data was recorded from the API or from on-chain data, depending on the source.
token
TEXT
Friendly name of the crypto token, e.g. Blocto Token.
symbol
TEXT
Short-name symbol for the crypto token, e.g. BLT.
token_contract
TEXT
The contract address for a token on the Flow blockchain.
price_usd
FLOAT
Asset price, in USD.
source
TEXT
Data source for the record in question. E.g. for the prices table, this may be an API or derived from swaps. Stableswap indicates the price was calculated from a swap where one of the assets was a stablecoin, while for a flowswap the other token was Flow.
dbt Docs
dbt Docs
Full Documentation for Core Prices

Column	Type	Description
timestamp	TIMESTAMP_NTZ	Timestamp of when the data was recorded from the API or from on-chain data, depending on the source.
token	TEXT	Friendly name of the crypto token, e.g. Blocto Token.
symbol	TEXT	Short-name symbol for the crypto token, e.g. BLT.
token_contract	TEXT	The contract address for a token on the Flow blockchain.
price_usd	FLOAT	Asset price, in USD.
source	TEXT	Data source for the record in question. E.g. for the prices table, this may be an API or derived from swaps. Stableswap indicates the price was calculated from a swap where one of the assets was a stablecoin, while for a flowswap the other token was Flow.

NFT Sales

Swaps

Last modified 8mo ago