Eman-RazTransactions Analysis
Updated 2023-03-15
9
1
2
3
4
5
6
7
›
⌄
select date_trunc('day',block_timestamp) as date, count(distinct tx_hash) as "Tx Count", count(distinct from_address) as "User Count",
round(count(distinct tx_hash)/count(distinct from_address)) as "Avg Tx Count per User",
count(distinct to_address) as "Destination Addresses Count", sum(XDAI_VALUE) as "Transactions Value", status
from gnosis.core.fact_transactions
where date>=current_date-60
group by 1,7
order by 1
Run a query to Download Data