zaaqde-5092D. Arbitrum Stablecoins Daily Transactions Count
    Updated 2024-05-12
    /*
    On ARBITRUM:
    '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' -- USDT
    '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' -- USDC
    '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' -- DAI
    */

    WITH
    USDT_token AS (
    SELECT
    BLOCK_TIMESTAMP::date AS day,
    COUNT(*) AS count
    FROM ARBITRUM.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9'
    GROUP BY 1
    ORDER BY 1 DESC
    ),
    USDC_token AS (
    SELECT
    BLOCK_TIMESTAMP::date AS day,
    COUNT(*) AS count
    FROM ARBITRUM.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'
    GROUP BY 1
    ORDER BY 1 DESC
    ),
    DAI_token AS (
    SELECT
    BLOCK_TIMESTAMP::date AS day,
    COUNT(*) AS count
    FROM ARBITRUM.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'
    GROUP BY 1
    ORDER BY 1 DESC
    )

    QueryRunArchived: QueryRun has been archived