fieldlnwza007Transactions + Active user I Sei copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- forked from tkvresearch / Transactions + Active user I Sei @ https://flipsidecrypto.xyz/tkvresearch/q/tIxzucGFUgqs/transactions-active-user-i-sei
select date_trunc(week, block_timestamp) as time,
count(distinct tx_from) as "Active users",
count(distinct tx_id) as "Transactions",
sum("Active users") over (order by time) as "Total Active Users",
sum("Transactions") over (order by time) as "Total Transactions"
from sei.core.fact_transactions
where tx_succeeded = TRUE
group by 1
order by 1 desc
Run a query to Download Data