DEX Trades
The dex_trades table contains swaps made on decentralized exchanges for the chain, consolidated into a single table. All DEX trades table follows the schema presented below.
Project Coverage
Currently, we support over 20 DEX projects on Ethereum.
| Protocol | Projects |
|---|---|
| uniswap_v3 | uniswap, kyberswap, pancakeswap |
| uniswap_v2 | original: uniswap forks: sushiswap, bitberryswap, cityswap, convergence, defiswap, dooar, equalizerfinance, fraxswap, gemswap, integralsize, linkswap, luaswap, mintyswap, nomiswap, orionprotocol, pancakeswap, plasmafinance, radioshackswap, safeswap, saitaswap, sakeswap, sashimiswap, shibaswap, sumswap, swapr, swipeswap, unicly, verse, vulcandex, wallstreetbetsdex, whiteswap |
Sample Query
Query DEX trades by block number.
Query DEX trades by transaction hash.
Table Columns
| Column Name | Type | Description | Example |
|---|---|---|---|
| project | varchar | The project (decentralized exchange) of the liquidity pool that the swap occurred from. | uniswap |
| protocol | varchar | Version of the protocol. | uniswap_v2 |
| liquidity_pool_address | varchar(42) | Contract address of the liquidity pool holding the asset. | 0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc |
| sender_address | varchar(42) | The address of the sender emitted on the swap event logs. This can be a router or pool address, which is different from the
transaction initiator | 0x7a250d5630b4cf539739df2c5dacb4c659f2488d |
| to_address | varchar(42) | Address of the recipient emitted on the swap event logs. For example, we use the to_address from the uniswap v2 swap event log and the recipient_address from the uniswap v3 swap event log. | 0xcbb2534c6898655d50fdac79d6e4b23b18a25b97 |
| token_bought_address* | varchar(42) | Token address of the token bought, i.e. the asset acquired from the trade. | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
| token_bought_name* | varchar | Name of the token bought. | USD Coin |
| token_bought_symbol* | varchar | Symbol of the token bought. | USDC |
| token_bought_decimals* | bigint | Decimals of the token bought. | 1 |
| token_bought_amount_raw | numeric(512) | Raw amount of tokens bought (unnormalized). | 3,000,000,000 |
| token_bought_amount* | float | Amount of tokens bought. | 3000000000 |
| token_sold_address* | varchar(42) | Token address of the token sold. | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 |
| token_sold_name* | varchar | Name of the token sold. | Wrapped Ether |
| token_sold_symbol* | varchar | Symbol of the token sold. | WETH |
| token_sold_decimals* | bigint | Decimals of the token sold. | 18 |
| token_sold_amount_raw | numeric(512) | Raw amount of tokens sold (unnormalized). | 2,288,149,153,584,170,000 |
| token_sold_amount* | float | Amount of tokens sold. | 2.28814915358417 |
| transaction_from_address | varchar(42) | Transaction sender address. I.e. the address of the transaction
initiator.
| 0xcbb2534c6898655d50fdac79d6e4b23b18a25b97 |
| transaction_to_address | varchar(42) | Transaction receiver. ( | 0x7a250d5630b4cf539739df2c5dacb4c659f2488d |
| transaction_hash | varchar(66) | Transaction hash that this swap belongs to. | 0x5e2efbb5a7cd468a2bf89b732e42c9c48bd311e0bec50a5de0beead059d1d220 |
| log_index | bigint | The position of the swap event log in the transaction. | 191 |
| block_timestamp | timestamp | Block timestamp of the swap event. | 2021-01-25 22:28:07 |
| block_number | bigint | Block number of the swap event. | 11,727,610 |
| block_hash | varchar(66) | Block hash of the swap event. | 0xff32ce4497bfad832878d069ce956f4eac5a6518c89fe8c4268af5f27c2cc1a5 |
*field is only available via the API, and are not in the underlying table.