SocioCryptoHighly active users
Updated 2024-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from Users categorized by activities @ https://flipsidecrypto.xyz/edit/queries/5542ff9b-0456-48e1-97dd-76917a2ed0e9
with activities as (
SELECT
tx_from,
datediff(day,'2023-08-15',current_date) as days,
count(DISTINCT tx_id) as n_txs
FROM sei.core.fact_transactions
WHERE block_timestamp >= '2023-08-15'
GROUP BY 1
)
SELECT
count(DISTINCT CASE when n_txs > days*5 then tx_from end) as count_user
FROM activities
QueryRunArchived: QueryRun has been archived