jackguyEthereum Cex Activity 2
    Updated 2022-10-20
    SELECT
    label,
    count(DISTINCT tx_hash) as events,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users

    FROM ethereum.core.ez_token_transfers
    LEFT outer JOIN ethereum.core.dim_labels
    ON address = to_address
    WHERE label_type LIKE 'cex'
    and block_timestamp > '2022-01-01'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 30
    --LIMIT 100
    Run a query to Download Data