STAT_DATE | DAILY_CLAIM_ADDRESS_COUNT | CUMSUM_CLAIM_ADDRESS_COUNT | |
|---|---|---|---|
1 | 2025-02-19 14 | 17174 | 45 |
2 | 2025-02-19 15 | 17174 | 672 |
3 | 2025-02-19 16 | 17174 | 1644 |
4 | 2025-02-19 17 | 17174 | 2512 |
5 | 2025-02-19 18 | 17174 | 6162 |
6 | 2025-02-19 19 | 17174 | 12790 |
7 | 2025-02-19 20 | 17174 | 17151 |
8 | 2025-02-20 04 | 20341 | 17331 |
9 | 2025-02-20 05 | 20341 | 22996 |
10 | 2025-02-20 06 | 20341 | 25336 |
11 | 2025-02-20 08 | 20341 | 25773 |
12 | 2025-02-20 09 | 20341 | 26538 |
13 | 2025-02-20 12 | 20341 | 26539 |
14 | 2025-02-20 13 | 20341 | 28097 |
15 | 2025-02-20 14 | 20341 | 36198 |
16 | 2025-02-22 03 | 920 | 36200 |
17 | 2025-02-22 04 | 920 | 36302 |
18 | 2025-02-22 12 | 920 | 36676 |
19 | 2025-02-23 15 | 1908 | 36730 |
20 | 2025-02-23 16 | 1908 | 36843 |
dylan_apraPriori Faucet Claim Addresses
Updated 2025-02-25
999
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 cum_address_dim as
(
select
create_date
,claim_address_count
,SUM(claim_address_count) OVER (ORDER BY create_date) AS cumsum_claim_address_count
from
(
select
TO_CHAR(create_date, 'YYYY-MM-DD HH24') as create_date
,count(distinct other_address) as claim_address_count
from
(
select
other_address
,min(stat_date) as create_date
from
(
SELECT
FROM_ADDRESS AS core_address,
TO_ADDRESS AS other_address,
'out' AS transfer_type,
value,
BLOCK_TIMESTAMP AS stat_date,
TX_HASH as hash
FROM monad.testnet.fact_transactions
WHERE from_address=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')
and BLOCK_TIMESTAMP>='2025-02-19 14:00:00'
UNION ALL
SELECT
TO_ADDRESS AS core_address,
FROM_ADDRESS AS other_address,
'in' AS transfer_type,
Last run: 13 days ago
...
216
6KB
11s