Hessishts - dex tk
Updated 2025-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with tokens as
(select 'TON' as symbol, '0:0000000000000000000000000000000000000000000000000000000000000000' as address
union
select symbol, address
from ton.core.fact_jetton_metadata)
select TOKEN_SOLD_ADDRESS, symbol,
count(distinct TX_HASH) as swaps,
sum(VOLUME_USD) as volume
from ton.defi.fact_dex_trades
left join tokens on TOKEN_SOLD_ADDRESS = ADDRESS
where
block_timestamp::date >= '{{Starting_date}}'
and TOKEN_BOUGHT_ADDRESS = '0:BDF3FA8098D129B54B4F73B5BAC5D1E1FD91EB054169C3916DFC8CCD536D1000'
and EVENT_TYPe = 'trade'
group by all
order by 3 desc
limit 6
QueryRunArchived: QueryRun has been archived