CODXIII2023-04-14 12:39 PM
    Updated 2023-04-14
    SELECT
    RIGHT(TOKEN_CONTRACT, CHARINDEX('.', (REVERSE(TOKEN_CONTRACT))) - 1) AS TOKEN,
    count (DISTINCT SENDER) AS Token_transfer_user
    FROM flow.core.ez_token_transfers
    WHERE DATE(BLOCK_TIMESTAMP) = '2023-03-31'
    GROUP BY 1
    Run a query to Download Data