Updated 2022-11-22
    select
    count (distinct TX_ID) as TXN,
    count (distinct SENDER) as Users
    FROM flow.core.ez_token_transfers S
    JOIN flow.core.fact_prices P ON P.TOKEN_CONTRACT = S.TOKEN_CONTRACT and P.TIMESTAMP::DATE = S.BLOCK_TIMESTAMP::DATE
    JOIN crosschain.core.address_labels L ON L.ADDRESS = S.RECIPIENT

    WHERE AMOUNT > 0 and LABEL_TYPE = 'cex' and TX_SUCCEEDED = 'TRUE'
    and S.BLOCK_TIMESTAMP < CURRENT_DATE

    Run a query to Download Data