Hessishts - tx all
Updated 2025-05-08Copy 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
›
⌄
with all_tx as (select
BLOCK_TIMESTAMP,
TX_HASH , 'Staking' as action
from ton.core.fact_messages
where BLOCK_TIMESTAMP::date >= '{{Starting_date}}'
and DESTINATION = '0:A45B17F28409229B78360E3290420F13E4FE20F90D7E2BF8C4AC6703259E22FA'
and DIRECTION = 'in'
and VALUE > 0
and source != '0:BDF3FA8098D129B54B4F73B5BAC5D1E1FD91EB054169C3916DFC8CCD536D1000'
and source not like '-%'
and trace_id in (select distinct trace_id from ton.core.fact_jetton_events
where BLOCK_TIMESTAMP::date >= '{{Starting_date}}'
and TYPE = 'mint')
union
select a.BLOCK_TIMESTAMP,
a.tx_hash, 'Unstaking request' as type
from ton.core.fact_messages a
where BLOCK_TIMESTAMP::date >= '{{Starting_date}}'
and DESTINATION = '0:A45B17F28409229B78360E3290420F13E4FE20F90D7E2BF8C4AC6703259E22FA'
and DIRECTION = 'in'
and VALUE > 0
and source = '0:BDF3FA8098D129B54B4F73B5BAC5D1E1FD91EB054169C3916DFC8CCD536D1000'
and source not like '-%'
and trace_id in (select distinct trace_id from ton.core.fact_jetton_events
where BLOCK_TIMESTAMP::date >= '{{Starting_date}}'
and TYPE = 'burn')
union
select a.BLOCK_TIMESTAMP,
QueryRunArchived: QueryRun has been archived