afonsoWeekly burn USN
Updated 2023-04-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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