dylan_apraPriori Faucet Claim Addresses
Updated 2025-02-25Copy Reference Fork
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,
QueryRunArchived: QueryRun has been archived