flipside

    Hourly Token Transaction Volume (Solana)
    mooolmHourly Token Transaction Volume (Solana)
    Updated 2022-12-09
    SELECT DATE_TRUNC('HOURS', block_timestamp) as hours, COUNT(DISTINCT tx_id) AS token_transactions
    FROM solana.core.fact_transfers
    WHERE block_timestamp >= CURRENT_DATE() - INTERVAL '1 week'
    GROUP BY hours
    ORDER BY hours DESC

    Run a query to Download Data