flipside

    Untitled Query
    ValiMohammadiUntitled Query
    Updated 2022-06-30
    select avg(t3.user_balance) as avg_overday,t3.PROGRAM_NAME,t3.max_time_day from (select t1.PROGRAM_NAME,t2.POST_BALANCES[0] as user_balance,max(BLOCK_TIMESTAMP::DATE) as max_time_day from (select PROGRAM_NAME,TX_ID
    from flipside_prod_db.solana.fact_gov_actions
    where SUCCEEDED=TRUE
    ) as t1
    inner join (select * from solana.core.fact_transactions) as t2
    on t1.TX_ID=t2.TX_ID
    group by t1.PROGRAM_NAME,t2.POST_BALANCES[0]
    limit 10) as t3
    group by PROGRAM_NAME,max_time_day
    order by max_time_day,PROGRAM_NAME
    Run a query to Download Data