dylan_apraPriori Faucet Claim Transactions
Updated 2025-02-25Copy Reference Fork
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
›
⌄
select
stat_date,
daily_claim_tx_count,
SUM(daily_claim_tx_count) OVER (ORDER BY stat_date) AS cumsum_claim_tx_count
from
(
select
TO_CHAR(stat_date, 'YYYY-MM-DD HH24') as stat_date
,count(distinct case when transfer_type='out' then hash else null end ) as daily_claim_tx_count
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,
value,
BLOCK_TIMESTAMP AS stat_date,
TX_HASH as hash
FROM monad.testnet.fact_transactions
WHERE to_address=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')
and BLOCK_TIMESTAMP>='2025-02-19 14:00:00'
QueryRunArchived: QueryRun has been archived