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


    */
    SELECT
    BLOCK_TIMESTAMP::date AS day,
    CASE
    WHEN CONTRACT_ADDRESS = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9'
    THEN 'USDT'
    WHEN CONTRACT_ADDRESS = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'
    THEN 'USDC'
    ELSE 'DAI'
    END AS Token,
    CASE
    WHEN ORIGIN_FUNCTION_SIGNATURE != '0x'
    THEN 'Contarct interaction'
    ELSE 'Simple transfer (0x)'
    END AS TX_TYPE,
    CASE WHEN TOKEN = 'DAI'
    THEN sum(RAW_AMOUNT/pow(10, 18))
    ELSE sum(RAW_AMOUNT/pow(10, 6))
    END AS Amount,
    SUM(Amount) OVER(ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Cumulative
    FROM ARBITRUM.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' -- USDT
    OR CONTRACT_ADDRESS = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' -- USDC
    OR CONTRACT_ADDRESS = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' -- DAI
    GROUP BY 1, 2, 3
    ORDER BY 1 DESC
    QueryRunArchived: QueryRun has been archived