strawbettystaking percentage
    Updated 2022-05-11
    with cs as (
    select
    date as day,
    sum(balance) as Luna_Circulating_Supply
    from terra.daily_balances
    where date >= CURRENT_DATE - interval '90 days'
    and currency = 'LUNA'
    and address_label_type is NULL
    group by day
    order by day
    ), staking as (
    select
    date as day,
    sum(balance) as Luna_Staked
    from terra.daily_balances
    where date >= CURRENT_DATE - interval '90 days'
    and currency = 'LUNA'
    and address_label_type is NULL
    and BALANCE_TYPE = 'staked'
    group by day
    order by day
    )

    select cs.day, Luna_Circulating_Supply, Luna_Staked, (Luna_Staked/Luna_Circulating_Supply)*100 as prcnt
    from cs left join staking on cs.day = staking.day
    order by day
    Run a query to Download Data