Ethereum Base Tables Explained

    What exactly are the Ethereum base tables?

    Three transactions have been selected for review, which are as follows:

    •  (A deposit into Ribbon’s R-Earn Vault) 
    •  (A swap on Sushiswap using the 0x Exchange contract
    •  (NFT Sales on Blur marketplace) 

    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_transfersdatabase.

    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.

    Loading...

    Second Transaction:

    The second transaction is a swap on SushiSwap platform. It has been checked using ethereum.core.ez_dex_swapsdatabase.

    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

    Loading...
    Loading...

    Third transaction:

    The third transaction is a NFT sale on Blur marketplace. It has been checked using ethereum.core.ez_nft_salesdatabase.

    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!

    Loading...