mondovBiggest ETH depositors in the selected time period
    Updated 2023-05-01
    SELECT
    t.FROM_ADDRESS AS Wallet,
    SUM(t.AMOUNT) AS Total_Deposits_ETH,
    l.label as CEX
    FROM ethereum.core.ez_token_transfers t
    JOIN ethereum.core.dim_labels l
    ON t.FROM_ADDRESS = l.ADDRESS
    WHERE l.LABEL_TYPE = 'cex'
    AND t.block_timestamp >= DATEADD('day', -{{time_period_days}}, CURRENT_TIMESTAMP())
    AND (t.symbol = 'ETH' OR t.symbol = 'eth')
    GROUP BY t.FROM_ADDRESS, l.label, l.label_type
    ORDER BY Total_Deposits_ETH DESC
    LIMIT 100;

    Run a query to Download Data