| integrator | Name of the integrator/frontend used for the trade (e.g., matcha, 1inch) inferred from the integrator tag. This will be null if there are no integrator | |
| integrator_tag | Contract address, event log field or other relevant field that is used to indicate the frontend integrator | |
| project | Name of the project. Includes dodo, paraswap, zeroex, cow_protocol, kyberswap_aggregator, tokenlon, openocean. | cow_protocol |
| protocol | DEX protocol or project contract which executed the aggregator trade. | cow_protocol |
| event_name | This field will be null for majority of DEX aggregator trades. Unless the event specifies the pools that the trade was routed through. | Trade |
| contract_address | The name of the event (or the function call) for this trade. | 0x9008d19f58aabd9ed0d60971565aa8510560ab41 |
| liquidity_pool_address | The contract address of the aggregator. | null |
| sender_address | Address of the sender of the swap event log, which can be the Router. | 0x2fb4aa67cc48c9dd126dc2f6a437c5c995b2732d |
| to_address | Address of the recipient of the swap event. | 0x2fb4aa67cc48c9dd126dc2f6a437c5c995b2732d |
| token_sold_address | Address of the token sold. | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
| token_sold_name | Name of the token sold. | USD Coin |
| token_sold_symbol | Symbol of the token sold. | USDC |
| token_sold_amount_raw_str | Amount of token sold (not divided by the number of decimals) in string. | 6250000000 |
| token_sold_amount_raw | Amount of token sold (not divided by the number of decimals). | 6250000000 |
| token_sold_amount_str | token_sold_amount_raw divided by the number of decimals of the token in string. | 6250 |
| token_sold_amount | token_sold_amount_raw divided by the number of decimals of the token. | 6250 |
| usd_sold_amount | USD value of tokens sold. | 6245 |
| token_bought_address | Token address of the token bought, i.e. the asset acquired from the trade. | 0xccccb68e1a848cbdb5b60a974e07aae143ed40c3 |
| token_bought_name | Name of the token bought. | TOPIA |
| token_bought_symbol | Symbol of the token bought. | TOPIA |
| token_bought_amount_raw_str | Amount of token bought (not divided by the number of decimals) in string. | 64632249553876898925672 |
| token_bought_amount_raw | Amount of token bought (not divided by the number of decimals). | 6.46322E+22 |
| token_bought_amount_str | token_bought_amount_raw divided by the number of decimals of the token in string. | 64632.24955 |
| token_bought_amount | token_bought_amount_raw divided by the number of decimals of the token. | 64632.24955 |
| usd_bought_amount | USD value of tokens bought. | 6048.867603 |
| usd_amount | USD value of the swap. Note that this preferentially selects the price and value of the more reputable token. | 6245 |
| extra_fields | This field contains all the extra columns emitted from the event/function call that were not part of the convetional DEX trades columns. | { "fee_amount": "0", "order_uid": "0E839EC0B7F089F2337620489748E70BA616417C506B3C6BCC7749CAEFE2F3C32FB4AA67CC48C9DD126DC2F6A437C5C995B2732D65EF27BA" } |
| transaction_from_address | The address of the sending party of this transaction. | 0xbf54079c9bc879ae4dd6bc79bce11d3988fd9c2b |
| transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | 0x9008d19f58aabd9ed0d60971565aa8510560ab41 |
| transaction_hash | Transaction hash of this trade. | 0x7a3be25e6fffa9fd29ef9aa9eafdfd0d8ee4a24aedb074ebb6c1a473ce750fce |
| transaction_index | Transaction index of this trade in the block. | 17 |
| transaction_fees | Fees paid at the transaction level. | 0.02354155877 |
| transaction_fees_usd | Fees paid in USD. | 95.02173534 |
| fee_details | Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction. | { "base_fee_per_gas": 88733305846, "block_gas_limit": 30000000, "block_gas_used": 12073153, "gas": 502304, "gas_price": 93734307405, "max_fee_per_gas": 358721698469, "max_priority_fee_per_gas": 5001001559, "priority_fees": "0.001256011543545968", "priority_fees_usd": 5.069689633676332e+00, "priority_gas_fee": "5001001559", "receipt_effective_gas_price": 93734307405, "receipt_gas_used": 251152 } |
| calldata_selector | The call data selector of the transaction. | 0x13d79a0b |
| selector | The 4-byte function selector of the aggregator method invoked for this trade. | 0x13d79a0b |
| log_index | Log index of this trade. | 42 |
| block_timestamp | Block timestamp of this trade. | 2024-03-11 12:48:59 |
| block_number | Block number of this trade. | 19411959 |
| block_hash | Block hash of this trade. | 0xe1944bbf513fa729bc78f34bee665dfafebede27cb73fd99d86ed4265c2b0852 |
| unique_id | Unique ID of each trade. | txn-0x7a3be25e6fffa9fd29ef9aa9eafdfd0d8ee4a24aedb074ebb6c1a473ce750fce_log_index-42 |
| _created_at | Timestamp of the entry creation. | 2024-04-16 11:46:12 |
| _updated_at | Timestamp of the entry update. | 2024-04-16 11:46:12 |
| _changed_since_full_refresh | Whether the entry was recreated. | FALSE |
