with calls as

(select distinct trace_id

from ton.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2025-04-02'

and ACCOUNT = '0:1EB2BBEA3D8C0D42FF7FD60F0264C866C934BBFF727526CA759E7374CAE0C166'),

flow as

(select b.BLOCK_TIMESTAMP::date as date ,

b.TX_HASH,

a.trace_id,

case when b.DESTINATION = '0:086FA2A675F74347B08DD4606A549B8FDB98829CB282BC1949D3B12FBAED9DCC'

then -1*b.AMOUNT/1e6 else b.AMOUNT/1e6 end as amount,

from ton.core.fact_transactions a

join ton.core.fact_jetton_events b on a.tx_hash = b.tx_hash

where a.BLOCK_TIMESTAMP::date >= '2025-04-02'

and b.JETTON_MASTER = upper('0:086fa2a675f74347b08dd4606a549b8fdb98829cb282bc1949d3b12fbaed9dcc')

and b.TX_SUCCEEDED = 'TRUE'

and a.trace_id in (select trace_id from calls))

select date, sum(amount) as volume,

sum(volume) over (order by date) as net_total

from flow

group by all

order by 1 desc