Hessishts - tx all
    Updated 2025-05-08
    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