Table of contents
The eth_mainnet.prices table provides indexed views for cleaned token prices in USD at every point in time when a token was seen in a DEX swap. For tokens that are swapped multiple times in a single block, a per-block VWAP is taken to determine the fair price.
Columns
| Name | Type | Description |
|---|---|---|
| timestamp | integer | The timestamp of the DEX swap (in ISO-8601 format). |
| date | date | The date at which this row was last updated (in ISO-8601 format). |
| price | real | The price of the token in USD. |
| token_address | varchar | The address of the token that is priced in USD. |
| chain | varchar | N/A |
| network | varchar | N/A |