kasadeghUntitled Query
    Updated 2022-11-22

    SELECT
    'solana' as chain,
    DAYNAME(block_timestamp) as day,
    hour(block_timestamp) as hour,
    count(distinct TX_ID) as tx_count,
    sum(amount) as total_volume,
    median(amount) as median_volume,
    avg(amount) as avg_volume,
    count(DISTINCT TX_FROM) as senders_cnt,
    count(DISTINCT TX_TO) as receivers_cnt

    FROM solana.core.fact_transfers
    where MINT ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and amount!=0
    GROUP BY 1,2,3
    order by 2
    Run a query to Download Data