Lordkingxdai
Updated 2022-08-05
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
count(DISTINCT from_address) as total_addresses,
count(DISTINCT TX_HASH) as transactions ,
STATUS,
sum(TX_FEE) as total_fee ,
avg(TX_FEE) as avrage_fee
from gnosis.core.fact_transactions
WHERE block_timestamp >= '2022-01-01'
group by STATUS
order by 1
Run a query to Download Data