MLDZMNneon2.1
    Updated 2023-09-21
    -- forked from neon2 @ https://flipsidecrypto.xyz/edit/queries/d407dddd-eb87-4cc8-887f-9874b7a56957

    select
    date_trunc('hour',block_timestamp)as date,
    count(distinct tx_id) as no_transfer,
    count(distinct tx_from) as no_sender,
    count(distinct tx_to) as no_receiver,
    sum(AMOUNT) as volume,
    avg(AMOUNT) as avg_volume,
    median(amount) as med_volume,
    sum(no_transfer)over (order by date) as total_transfers,
    sum(no_sender)over (order by date) as total_senders,
    sum(no_receiver)over (order by date) as total_receivers,
    sum(volume)over (order by date) as total_volume
    from solana.core.fact_transfers
    where mint = 'NeonTjSjsuo3rexg9o6vHuMXw62f9V7zvmu8M8Zut44'
    and block_timestamp>='2023-07-17'
    group by 1
    order by 1


    Run a query to Download Data