h4wktx_per_user
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from network @ https://flipsidecrypto.xyz/edit/queries/867bec6a-14a0-4912-a558-3f4c62fc6cc9
with base as (
select tx_from,
count(tx_id) as tx_count
from sei.core.fact_transactions
where tx_succeeded = TRUE
and block_timestamp >= '2023-08-16'
group by 1
)
select case when tx_count > 5 then 'More than 5 TXs'
else tx_count || ' TX(s)' end as type,
count(tx_from) as user_count
from base
group by 1
QueryRunArchived: QueryRun has been archived