saeedmzn[New accounts on SEI] Total NEw users
Updated 2025-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from [New accounts on SEI] Total @ https://flipsidecrypto.xyz/edit/queries/eb9e4c94-5da9-488b-966c-f735b197272c
with New_users as (
select TX_FROM ,
min (BLOCK_TIMESTAMP) ::date min_date
from sei.core.fact_transactions
group by 1 having min_date >= current_date - 30
),
transactions as (
select TX_ID , TX_FROM
from sei.core.fact_transactions
where TX_FROM in (select TX_FROM from New_users )
)
select
count (DISTINCT tx_id) num_transactions ,
count (DISTINCT tx_from ) num_users
from transactions
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived