MLDZMNhiv3
    Updated 2023-05-05
    select
    date_trunc('week',block_timestamp) as date,
    sum(amount) as volume,
    avg(amount) as avg_volume,
    median(amount) as median_volume,
    count(distinct tx_from) as no_senders,
    count(distinct tx_id) as no_transfers,
    sum(no_senders) over (order by date) as total_senders,
    sum(no_transfers) over (order by date) as total_transfers
    from solana.core.fact_transfers
    where mint in ('4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy' )
    and block_timestamp > '2023-01-01'
    group by 1
    Run a query to Download Data