SELECT

'solana' as chain,

block_timestamp::date as day,

count(distinct TX_ID) as tx_count,

sum(amount) as total_volume,

median(amount) as median_volume,

avg(amount) as avg_volume,

count(DISTINCT TX_FROM) as senders_cnt,

count(DISTINCT TX_TO) as receivers_cnt

FROM solana.core.fact_transfers

where MINT ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'

and amount!=0

GROUP BY 1,2

order by 2