zaaqde-5092C. Arbitrum USDC, USDT, DAI Segm.
    Updated 2024-05-12
    /*
    On ARBITRUM:
    '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' -- USDT
    '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' -- USDC
    '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' -- DAI
    */

    WITH
    USDT_token AS (
    SELECT
    BLOCK_TIMESTAMP::date AS day,
    sum(RAW_AMOUNT/pow(10, 6)) AS Amount,
    SUM(Amount) OVER(ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS USDT
    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,
    sum(RAW_AMOUNT/pow(10, 6)) AS Amount,
    SUM(Amount) OVER(ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS USDC
    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,
    sum(RAW_AMOUNT/pow(10, 18)) AS Amount,
    SUM(Amount) OVER(ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS DAI
    FROM ARBITRUM.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'
    GROUP BY 1
    QueryRunArchived: QueryRun has been archived