select date_trunc('minute', INSERTED_TIMESTAMP) as minute, count(*) AS transfer_count, sum(amount) as total_amount
from solana.core.fact_transfers
where date_trunc('hour', INSERTED_TIMESTAMP) = date_trunc('hour', (CURRENT_TIMESTAMP() - INTERVAL '1 hour'))
group by minute
order by minute;