chillNew users of past 90 days : Daily staking activity
    Updated 2022-03-06
    with old_address as (
    select distinct tx_from[0] as address from terra.transactions
    where date(block_timestamp) < CURRENT_DATE() - interval '90 day' and tx_from !=''
    )
    ,nintydaysago_address as (
    select distinct tx_from[0] as new_address from terra.transactions where
    date(block_timestamp) > CURRENT_DATE() - interval '90 day'
    and tx_from !=''
    and tx_from[0] not in (select address from old_address)
    )
    ,final_result as (
    select count(*) as c,date(block_timestamp) as date
    from terra.staking
    where delegator_address in(select new_address from nintydaysago_address)
    group by date
    )

    select * from final_result
    Run a query to Download Data