Historical price tables - still functional but no new tokens will be added
prices.latest
, prices.day
, prices.hour
, or prices.minute
tables instead.Table | Description |
---|---|
prices.usd | Historical prices with timestamps |
prices.usd_daily | Daily historical prices |
prices.usd_latest | Latest available price per token |
prices.latest
for the most recent priceprices.day
for daily historical pricesprices.hour
for hourly historical dataprices.minute
for granular historical dataColumn name | Data type | Description |
---|---|---|
contract_address | varbinary | The unique identifier of the token |
symbol | varchar | The identifier of the asset (ticker, cashtag) |
price | double | The price of the asset in USD |
timestamp | timestamp | The timestamp for which this price is reported |
blockchain | varchar | The blockchain on which the asset exists |
Column name | Data type | Description |
---|---|---|
contract_address | varbinary | The unique identifier of the token |
symbol | varchar | The identifier of the asset (ticker, cashtag) |
price | double | The latest price of the asset in USD |
blockchain | varchar | The blockchain on which the asset exists |