Date | Daily Active Users | New Users | Cumulative Unique Users | Daily Transactions | Cumulative Transactions | |
|---|---|---|---|---|---|---|
1 | 2025-04-15 00:00:00.000 | 16018 | 5115 | 938915 | 34373 | 4558861 |
2 | 2025-04-14 00:00:00.000 | 23922 | 8998 | 933800 | 57299 | 4524488 |
3 | 2025-04-13 00:00:00.000 | 23655 | 7788 | 924802 | 62141 | 4467189 |
4 | 2025-04-12 00:00:00.000 | 21695 | 9390 | 917014 | 57538 | 4405048 |
5 | 2025-04-11 00:00:00.000 | 26047 | 9337 | 907624 | 68074 | 4347510 |
6 | 2025-04-10 00:00:00.000 | 8037 | 718 | 898287 | 21963 | 4279436 |
7 | 2025-04-09 00:00:00.000 | 9814 | 1240 | 897569 | 22707 | 4257473 |
8 | 2025-04-08 00:00:00.000 | 15973 | 4617 | 896329 | 42446 | 4234766 |
9 | 2025-04-07 00:00:00.000 | 23711 | 6585 | 891712 | 63275 | 4192320 |
10 | 2025-04-06 00:00:00.000 | 26821 | 7842 | 885127 | 79170 | 4129045 |
11 | 2025-04-05 00:00:00.000 | 25990 | 6411 | 877285 | 76417 | 4049875 |
12 | 2025-04-04 00:00:00.000 | 29962 | 7581 | 870874 | 83010 | 3973458 |
13 | 2025-04-03 00:00:00.000 | 20086 | 7062 | 863293 | 55230 | 3890448 |
14 | 2025-04-02 00:00:00.000 | 11949 | 2329 | 856231 | 33014 | 3835218 |
15 | 2025-04-01 00:00:00.000 | 17796 | 5864 | 853902 | 44913 | 3802204 |
16 | 2025-03-31 00:00:00.000 | 41754 | 9850 | 848038 | 105058 | 3757291 |
17 | 2025-03-30 00:00:00.000 | 35426 | 5825 | 838188 | 100746 | 3652233 |
18 | 2025-03-29 00:00:00.000 | 15188 | 1074 | 832363 | 40630 | 3551487 |
19 | 2025-03-28 00:00:00.000 | 42833 | 3695 | 831289 | 121407 | 3510857 |
20 | 2025-03-27 00:00:00.000 | 32755 | 15535 | 827594 | 80415 | 3389450 |
permaryDaily Fantasy Top users
Updated 6 days ago
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 daily_stats AS (
SELECT
date_trunc('day', block_timestamp) as "Date",
origin_from_address as user_address,
tx_hash
FROM monad.testnet.fact_event_logs
WHERE contract_address IN (
LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e'),
LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),
LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')
)
),
daily_active_users AS (
SELECT
"Date",
COUNT(DISTINCT user_address) as active_users,
COUNT(DISTINCT tx_hash) as daily_transactions
FROM daily_stats
GROUP BY "Date"
),
user_first_seen AS (
SELECT
user_address,
MIN("Date") as first_date
FROM daily_stats
GROUP BY user_address
),
daily_new_users AS (
SELECT
first_date as "Date",
COUNT(*) as new_users
FROM user_first_seen
GROUP BY first_date
)
SELECT
Last run: 6 days ago
69
4KB
89s