PER_CLAIM_AMOUNT | CLAIM_TX_COUNT | |
|---|---|---|
1 | 0.02 | 10990 |
2 | 0.05 | 4168 |
3 | 1 | 14842 |
4 | 2 | 56861 |
aPrioriPer Claim MON Distribution
Updated 2025-03-04
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
claim_amount as Per_Claim_Amount
,count(*) as Claim_tx_Count
from
(
select
other_address as wallet
,value as claim_amount
,stat_date as claim_time
,hash as tx_hash
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'
Last run: 14 days ago
4
46B
8s