from solana.core.fact_events

where program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'

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

select date(block_timestamp::date) 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(tx_id)) as deposits, count(DISTINCT(tx_from)) as depositers,

sum(amount) as volume, avg(amount) as avg_amount,

max(amount) as max_amount, min(amount) as min_amount,

median(amount) as median_amount

from solana.core.fact_transfers

where tx_id in (select tx_id from program)

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

and tx_to = '6esygvEPnAV3JKzMKP4ainLvENM2tFYzZ1bpA1NhfDyK'

group by 1,2