mondov2023-05-01 12:54 PM
    Updated 2023-05-01
    SELECT
    l.label AS CEX,
    COUNT(*) AS Number_of_Deposits
    FROM ethereum.core.ez_token_transfers t
    JOIN ethereum.core.dim_labels l
    ON t.TO_ADDRESS = l.ADDRESS
    WHERE l.LABEL_TYPE = 'cex'
    AND t.block_timestamp >= DATEADD('day', -{{time_period_days}}, CURRENT_TIMESTAMP())
    GROUP BY l.label
    ORDER BY Number_of_Deposits DESC;

    Run a query to Download Data