Ethereum Base Tables Explained
What exactly are the Ethereum base tables?
First transaction:
The first transaction is a financial deposit in Ribbon. Ribbon Finance is a crypto structured products protocol on Ethereum. It has been checked using ethereum.core.ez_token_transfers
database.
SELECT * FROM ethereum.core.ez_token_transfers WHERE tx_hash = '0x56cf02194da2afc277ab20852a4287890f7ea8d8c42691fe0b2e0f5a5aa273c3'
The approximate amount of 82.5 k is deposited, the transaction information is as follows.
Second Transaction:
The second transaction is a swap on SushiSwap platform. It has been checked using ethereum.core.ez_dex_swaps
database.
SELECT tx_hash, BLOCK_TIMESTAMP, POOL_NAME, EVENT_NAME, AMOUNT_IN, AMOUNT_IN_USD, AMOUNT_OUT, AMOUNT_OUT_USD, ORIGIN_FROM_ADDRESS, platform, SYMBOL_IN, SYMBOL_OUT from ethereum.core.ez_dex_swaps WHERE TX_HASH = '0x5647099add0ce24708cc25757d265d17b822e35191942e1711efe68e9c4ede00'
4.58047178 CVX has been swapped to 0.01525406591 WETH SLP in the CVX-WETH SLP pool. For more information please check the following table.
Second table is checked using ethereum.sushi.ez_swaps
Third transaction:
The third transaction is a NFT sale on Blur marketplace. It has been checked using ethereum.core.ez_nft_sales
database.
SELECT * FROM ethereum.core.ez_nft_sales WHERE tx_hash = '0x9da99cd244b8d55648843567c2298dfeab65b42f9b8ee412e4c8babac76cf753'
This NFT sale details has been showed in following table, then you can easily check it!