Total trading volume (USD) | Total unique traders | Total trades | |
|---|---|---|---|
1 | 231685272.79 | 38763 | 322086 |
Mrfti2024-03-23 03:58 PM copy
Updated 2025-01-03
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
32
33
34
35
36
›
⌄
-- forked from 2024-03-23 03:58 PM @ https://flipsidecrypto.xyz/studio/queries/02b30087-a01a-4c97-893a-0d66d6028da9
with tbl AS (
select
Block_timestamp as "Date",
'Buy' as "Buy/Sell",
TX_HASH as "Transaction hash",
trader as "Trader address",
PLATFORM as "Platform",
AMOUNT_Out_USD as "Trade volume (USD)"
from
crosschain.defi.ez_dex_swaps
where
token_in = lower('0x184ff13B3EBCB25Be44e860163A5D8391Dd568c1')
and blockchain = 'avalanche'
UNION ALL
select
Block_timestamp as "Date",
'Sell' as "Buy/Sell",
TX_HASH as "Transaction hash",
trader as "Trader address",
PLATFORM as "Platform",
AMOUNT_In_USD as "Trade volume (USD)"
from
crosschain.defi.ez_dex_swaps
where
token_out = lower('0x184ff13B3EBCB25Be44e860163A5D8391Dd568c1')
and blockchain = 'avalanche')
select
sum ("Trade volume (USD)") as "Total trading volume (USD)",
count (DISTINCT "Trader address") as "Total unique traders",
count (DISTINCT "Transaction hash") as "Total trades"
from tbl
Last run: 2 months agoAuto-refreshes every 12 hours
1
29B
28s