from solana.core.fact_events

where program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'

and block_timestamp::date >= '2023-04-17')

select date(block_timestamp) as date, case when block_timestamp < '2023-04-26 19:00:00' then 'Before Trails'

when block_timestamp < '2023-05-03 18:00:00' then 'First Trails Round'

else 'Second Trails Round' end as type,count(DISTINCT(user)) as total_user,

count(DISTINCT(a.tx_id)) as total_tx, sum(total_tx) over (order by date asc) as cum_tx

from solana.core.fact_transfers a join program b on a.tx_id = b.tx_id

where tx_from = 'AVNMK6wiGfppdQNg9WKfMRBXefDPGZFh2f3o1fRbgN8n'

and block_timestamp::date >= '2023-04-17'

group by 1,2