csp88gBD Trading volume
Updated 2024-12-28
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
›
⌄
with trades as(
select
case
when TOKEN_OUT_CONTRACT = 'blackdragon.tkn.near' then AMOUNT_OUT_USD
when TOKEN_IN_CONTRACT = 'blackdragon.tkn.near' then AMOUNT_IN_USD
end as tv,
*
from
near.defi.ez_dex_swaps
where
BLOCK_TIMESTAMP >= '2024-12-23 16:00:00.000'
and BLOCK_TIMESTAMP <= '2024-12-28 17:00:00.000'
and TOKEN_OUT_CONTRACT = 'blackdragon.tkn.near'
or BLOCK_TIMESTAMP >= '2024-12-23 16:00:00.000'
and BLOCK_TIMESTAMP <= '2024-12-28 17:00:00.000'
and TOKEN_IN_CONTRACT = 'blackdragon.tkn.near'
)
select
TRADER,
sum(tv) as volume
from
trades
where
TRADER not in (
'deltabot_blackdragonusdc.near',
'deltatrade_dcaoperator.near'
)
group by
TRADER
order by
volume desc
QueryRunArchived: QueryRun has been archived