blazer2024-02-03 01:23 AM
    Updated 2024-08-03
    --ASSIGNMENT: Using ez-dex-swap table in the ethereum defi database, find top 10 deposit addresses by amount, where platform is uniswap V2.
    SELECT -- * Means all
    block_timestamp,
    tx_hash,
    event_name,
    contract_address,
    symbol_in,
    origin_from_address,
    amount_in_usd,
    platform
    FROM ethereum.defi.ez_dex_swaps --Retrieving data from the ethereum.core.ez_token_transfers table
    WHERE platform = 'uniswap-v2' and amount_in_usd IS NOT NULL
    --GROUP BY amount_usd
    ORDER BY amount_in_usd DESC --DESC means descending order -ASC means ascending order
    LIMIT 10
    QueryRunArchived: QueryRun has been archived