maybeyonasrari_usdc_today
    Updated 2022-05-21
    with
    rari_fuse_pools as (
    select
    distinct contract_address
    from ethereum.events_emitted
    where event_name = 'NewFuseFee'
    )

    select
    user_address,
    balance
    from ethereum.erc20_balances
    where user_address in (select contract_address from rari_fuse_pools)
    and balance_date = current_date
    and symbol = 'USDC'

    -- select
    -- contract_address,
    -- count(distinct tx_id) as txs
    -- from ethereum.events_emitted
    -- -- where tx_id = '0xf2b98cfb0f0457cd7a6d2aa46652fc69ba804628b619fc211e13df78bd9b9b05'
    -- where event_name = 'NewFuseFee'
    -- -- and contract_address = '0x53de5a7b03dc24ff5d25ccf7ad337a0425dfd8d1'
    -- group by 1
    -- order by txs desc
    -- limit 100
    Run a query to Download Data