mattkstewOsmosis One Year Anniversary 5
    Updated 2022-06-23
    with tab1 as (
    SELECT
    receiver
    FROM osmosis.core.fact_airdrop
    WHERE currency LIKE 'uosmo'
    )

    select
    date_trunc('day', block_timestamp),
    count(distinct delegator_address )


    from osmosis.core.fact_staking
    where delegator_address in (select * from tab1)
    group by 1
    Run a query to Download Data