headitmanagerFee over time
Updated 2022-07-06
9
1
2
3
4
5
6
7
8
9
›
⌄
with fee_overtime as(select sum(fee), block_timestamp::date from algorand.transactions
where block_timestamp::date > '2022-01-01'
group by block_timestamp::date)
, most_transactions as (select count(*),sum(fee), sender from algorand.transactions
group by sender
order by count(*) desc
limit 10)
, total_fee as (select count(*),sum(fee) from algorand.transactions)
select * from fee_overtime
Run a query to Download Data