kumbayaa2024-04-08 07:26 PM
    Updated 2024-04-10
    SELECT
    date_trunc('day',block_timestamp) AS date,
    --COUNT(DISTINCT a.tx_hash) AS No_of_Transaction,
    a.to_address AS receiver,
    b.label_type
    FROM arbitrum.core.fact_token_transfers a
    JOIN arbitrum.core.dim_labels b
    on a.contract_address = b.address
    WHERE label_type = 'cex'
    GROUP BY 1,2,3
    LIMIT 10
    QueryRunArchived: QueryRun has been archived