Platform | Total trading volume (USD) | Total unique traders | Total trades | |
---|---|---|---|---|
1 | uniswap-v2 | 10067.09 | 896 | 1186 |
2 | woofi | 52205.58 | 18 | 28 |
3 | uniswap-v3 | 365336381.83 | 41293 | 141958 |
4 | hashflow-v3 | 4245485.27 | 306 | 811 |
MrftiTrading Platforms
Updated 18 hours ago
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
›
⌄
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('0xFe0c30065B384F05761f15d0CC899D4F9F9Cc0eB')
and blockchain = 'ethereum'
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('0xFe0c30065B384F05761f15d0CC899D4F9F9Cc0eB')
and blockchain = 'ethereum')
select
"Platform",
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
GROUP by 1
Last run: about 18 hours agoAuto-refreshes every 12 hours
4
135B
28s