aPriori0xb2f82D0f38dc453D596Ad40A37799446Cc89274A
Updated 2025-02-28Copy 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
case when TO_ADDRESS='0xb2f82D0f38dc453D596Ad40A37799446Cc89274A' then 'in' else 'out' end as transfer_type
,FROM_ADDRESS
,TO_ADDRESS
,amount
,min_time
,max_time
from
(
select
TO_ADDRESS
,FROM_ADDRESS
,sum(VALUE) as amount
,max(BLOCK_TIMESTAMP) as max_time
,min(BLOCK_TIMESTAMP) as min_time
from monad.testnet.fact_traces
where
(
FROM_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
or
TO_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
)
and VALUE>0
group by 1,2
) a
order by 4 desc
-- TX_HASH='0x2b9689a297a1674c27ad0df4ce7bd431008914660289d416695d1aafc5f8cb1e'
-- where TX_HASH='0x7c87736dee1db46b31dacb3c8c86043ac9ef5b09998408a39a7626b5f84d9e1f'
-- group by 1
-- order by 2 desc
QueryRunArchived: QueryRun has been archived