SELECT

(EXTRACT(HOUR FROM block_timestamp)) as time_hour,

COUNT(DISTINCT tx_from) as sender,

count(DISTINCT tx_id) as sale,

SUM(amount) as volume,

median(amount) as avg_volume

FROM solana.core.fact_transfers

WHERE mint LIKE 'So11111111111111111111111111111111111111112'

GROUP BY 1