defi_internMoM Sei User Growth Stats
Updated 2024-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from saeedmzn / [Sei Active Users ] - active users over time @ https://flipsidecrypto.xyz/saeedmzn/q/DEgTi2obSwmQ/sei-active-users---active-users-over-time
select
date_trunc(month,BLOCK_TIMESTAMP)::date monthly ,
count (DISTINCT TX_ID ) num_transactions ,
count (DISTINCT TX_FROM) num_active_users ,
sum (num_transactions) over (order by monthly) cum_transactions ,
COUNT(DISTINCT tx_from) - LAG(COUNT(DISTINCT tx_from)) OVER (ORDER BY monthly) Difference_active_users
from sei.core.fact_transactions
where TX_SUCCEEDED = TRUE
and BLOCK_TIMESTAMP::date >= current_date - 180
and date_trunc(month,BLOCK_TIMESTAMP)::date < trunc(current_date,'month')
group by 1
QueryRunArchived: QueryRun has been archived