afonsoWeekly burn USN
    Updated 2023-04-12
    select
    date_trunc('week', block_timestamp)::date as week,
    count(distinct tx_hash) as txn_count,
    count(distinct from_address) as senders_count,
    count(distinct to_address) as receivers_count,
    sum(amount) as total_amount,
    avg(amount) as average_amount,
    median(amount) as median_amount,
    sum(txn_count) over (order by week) as cumulative_txn_count,
    sum(total_amount) over (order by week) as cumulative_amount,
    sum(receivers_count) over (order by week) as cumulative_receivers_count
    from near.core.ez_usn_supply
    where status = 'Success'
    and year(block_timestamp) = 2022
    and event = 'ft_burn'
    group by week
    order by week asc
    Run a query to Download Data