DAY | MONTH | TXS_BY_DAY | NEW_USERS_BY_DAY | ACTIVE_USERS_BY_DAY | TOTAL_TXS | TOTAL_NEW_USERS | TOTAL_ACTIVE_USERS | |
|---|---|---|---|---|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | 2024-01-01 00:00:00.000 | 1548589 | 2030 | 2030 | 1548589 | 2030 | 2030 |
2 | 2024-01-02 00:00:00.000 | 2024-01-01 00:00:00.000 | 1546608 | 1538 | 2458 | 3095197 | 3568 | 4488 |
3 | 2024-01-03 00:00:00.000 | 2024-01-01 00:00:00.000 | 1459131 | 1086 | 2369 | 4554328 | 4654 | 6857 |
4 | 2024-01-04 00:00:00.000 | 2024-01-01 00:00:00.000 | 1322808 | 791 | 2156 | 5877136 | 5445 | 9013 |
5 | 2024-01-05 00:00:00.000 | 2024-01-01 00:00:00.000 | 1393382 | 641 | 1903 | 7270518 | 6086 | 10916 |
6 | 2024-01-06 00:00:00.000 | 2024-01-01 00:00:00.000 | 1244270 | 611 | 1844 | 8514788 | 6697 | 12760 |
7 | 2024-01-07 00:00:00.000 | 2024-01-01 00:00:00.000 | 1560761 | 494 | 1746 | 10075549 | 7191 | 14506 |
8 | 2024-01-08 00:00:00.000 | 2024-01-01 00:00:00.000 | 1509053 | 612 | 2185 | 11584602 | 7803 | 16691 |
9 | 2024-01-09 00:00:00.000 | 2024-01-01 00:00:00.000 | 1308620 | 517 | 2189 | 12893222 | 8320 | 18880 |
10 | 2024-01-10 00:00:00.000 | 2024-01-01 00:00:00.000 | 1327338 | 507 | 2199 | 14220560 | 8827 | 21079 |
11 | 2024-01-11 00:00:00.000 | 2024-01-01 00:00:00.000 | 1305472 | 613 | 2626 | 15526032 | 9440 | 23705 |
12 | 2024-01-12 00:00:00.000 | 2024-01-01 00:00:00.000 | 1169848 | 527 | 2424 | 16695880 | 9967 | 26129 |
13 | 2024-01-13 00:00:00.000 | 2024-01-01 00:00:00.000 | 1329461 | 463 | 2284 | 18025341 | 10430 | 28413 |
14 | 2024-01-14 00:00:00.000 | 2024-01-01 00:00:00.000 | 1216440 | 625 | 2499 | 19241781 | 11055 | 30912 |
15 | 2024-01-15 00:00:00.000 | 2024-01-01 00:00:00.000 | 1218347 | 418 | 2460 | 20460128 | 11473 | 33372 |
16 | 2024-01-16 00:00:00.000 | 2024-01-01 00:00:00.000 | 1248365 | 503 | 2672 | 21708493 | 11976 | 36044 |
17 | 2024-01-17 00:00:00.000 | 2024-01-01 00:00:00.000 | 1150505 | 548 | 2872 | 22858998 | 12524 | 38916 |
18 | 2024-01-18 00:00:00.000 | 2024-01-01 00:00:00.000 | 1150063 | 461 | 2757 | 24009061 | 12985 | 41673 |
19 | 2024-01-19 00:00:00.000 | 2024-01-01 00:00:00.000 | 1312767 | 335 | 2420 | 25321828 | 13320 | 44093 |
20 | 2024-01-20 00:00:00.000 | 2024-01-01 00:00:00.000 | 1297919 | 317 | 2054 | 26619747 | 13637 | 46147 |
MetaLightZeta Transactions and Users
Updated 2025-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
activity as (
select block_timestamp, tx_id, signers[0] as wallet_address
from solana.core.fact_events events
where succeeded
and program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'
and block_timestamp >= '2024-01-01'::date
and block_timestamp <= '2024-07-31'::date
),
new_users as (
select wallet_address, min(block_timestamp) as first_seen_date
from activity
group by wallet_address
),
aggregated as (
select
date_trunc('day', a.block_timestamp) as day,
date_trunc('month', a.block_timestamp) as month,
count(distinct a.tx_id) as daily_txs,
count(distinct a.wallet_address) as daily_users,
count(distinct case when a.block_timestamp = nu.first_seen_date then a.wallet_address end) as daily_new_users
from activity a
left join new_users nu on a.wallet_address = nu.wallet_address
group by 1, 2
),
cumulative as (
select
day,
month,
daily_txs,
daily_new_users,
daily_users,
sum(daily_txs) over (order by day) as cumulative_txs,
sum(daily_new_users) over (order by day) as cumulative_new_users,
sum(daily_users) over (order by day) as cumulative_active_users
from aggregated
Last run: 2 months ago
...
213
19KB
114s