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

    select
    balance_date,
    user_address,
    balance
    from ethereum.erc20_balances
    where user_address in (select contract_address from rari_fuse_pools)
    and balance_date >= current_date - interval '90 days'
    and symbol = 'DAI'
    order by balance desc

    Run a query to Download Data