h4wkPoolTogether USDC Daily Deposit
    Updated 2022-06-21
    -- Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)?
    -- What’s the average deposit amount per user?

    -- DEPOSIT USDC
    select date_trunc(day, block_timestamp) as date,
    count(tx_hash) as tx_count,
    count(distinct from_address) as unique_user,
    sum(raw_amount/pow(10,6)) as deposit_volume,
    sum(deposit_volume) over (order by date) as cumulative_volume
    from ethereum.core.fact_token_transfers
    where contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' and to_address = '0xd89a09084555a7d0abe7b111b1f78dfeddd638be'
    and block_timestamp::date < CURRENT_DATE and block_timestamp::date >= CURRENT_DATE - 31
    group by date order by date
    -- and tx_status = 'SUCCESS'

    Run a query to Download Data