tucker192024-06-26 01:16 PM
    Updated 2024-06-27
    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;
    QueryRunArchived: QueryRun has been archived