msafadoostdaily amount of USDC users deposit into PoolTogether
    Updated 2022-06-23

    with event as (
    SELECT ORIGIN_TO_ADDRESS as o_a,
    EVENT_NAME,
    TX_HASH as t_h
    FROM ethereum.core.fact_event_logs
    WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - 30
    AND ORIGIN_TO_ADDRESS = lower('0xd89a09084555a7d0abe7b111b1f78dfeddd638be')
    AND EVENT_NAME = 'Deposit'
    )
    SELECT
    DATE(BLOCK_TIMESTAMP) AS dates,
    sum(AMOUNT) AS sum,
    sum(sum)over(order by dates) as cumulative
    FROM ethereum.core.ez_token_transfers JOIN event ON TO_ADDRESS = o_a AND TX_HASH = t_h
    WHERE SYMBOL LIKE 'USDC'
    GROUP by 1
    ORDER by 1

    Run a query to Download Data