Mrfti2023-11-27 08:56 PM
    Updated 2023-12-15
    SELECT
    date_trunc('hour',block_timestamp) as "Date",
    count(distinct tx_id) as "Transfers",
    sum(amount) as "Ponk volume"
    FROM solana.core.fact_transfers
    WHERE mint = 'HeqCcMjmuV5s25J49YiJyT6bD5qWLkP88YPajBySniaV'
    GROUP by 1



    Run a query to Download Data