Flipside Docs
Search
K

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
Last modified 1yr ago