headitmanagerBlocto Total Fee over time
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with Blocto_total_fee as (select sum(TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0]) as fee
from flow.core.fact_transactions
where payer='0x55ad22f01ef568a1')
, Blocto_fee_overtime as (select sum(TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0]) as fee,block_timestamp::date
from flow.core.fact_transactions
where payer='0x55ad22f01ef568a1'
group by block_timestamp::date)
, other_wallet_providers_transactions_count as (select count(*),payer from flow.core.fact_transactions
group by payer
order by count(*) DESC
limit 20)
, other_wallet_providers_fee_amount as (select sum(TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0]) as fee,payer from flow.core.fact_transactions
where TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0] is not null
group by payer
order by fee DESC
limit 20)
select * from Blocto_fee_overtime
Run a query to Download Data