Hessishts - dex tot
Updated 2025-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from ts - dex ovr @ https://flipsidecrypto.xyz/studio/queries/adaa67df-350e-4d5e-bc62-167bae86c6af
select
count(distinct TX_HASH) as swaps,
count(distinct TRADER_ADDRESS) as swappers,
sum(VOLUME_USD) as volume
from ton.defi.fact_dex_trades
where
(TOKEN_SOLD_ADDRESS = '0:BDF3FA8098D129B54B4F73B5BAC5D1E1FD91EB054169C3916DFC8CCD536D1000'
or TOKEN_BOUGHT_ADDRESS = '0:BDF3FA8098D129B54B4F73B5BAC5D1E1FD91EB054169C3916DFC8CCD536D1000')
and
EVENT_TYPe = 'trade'
group by all
QueryRunArchived: QueryRun has been archived