CHAIN | Total Trades | Total Trades Volume | Total Traders | |
|---|---|---|---|---|
1 | Ethereum | 51555 | 652095254.93 | 35492 |
2 | Base | 134990 | 117849644.33 | 18369 |
3 | BSC | 88793 | 8069809.17 | 16232 |
datavortextrades
Updated 2025-03-02
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 eth_trades AS (
SELECT
'Ethereum' AS chain,
COUNT(DISTINCT tx_hash) AS "Total Trades",
SUM(amount_in_usd) AS "Total Trades Volume",
COUNT(DISTINCT origin_from_address) AS "Total Traders"
FROM ethereum.defi.ez_dex_swaps
WHERE pool_name IN (
'USD0-LBTC 3000 60 UNI-V3 LP',
'WBTC-LBTC 100 1 UNI-V3 LP',
'eBTC-LBTC 500 10 UNI-V3 LP',
'LBTC-WETH',
'LBTC-cbBTC 500 10 UNI-V3 LP',
'WBTC-LBTC 500 10 UNI-V3 LP'
)
),
base_trades AS (
SELECT
'Base' AS chain,
COUNT(DISTINCT tx_hash) AS "Total Trades",
SUM(amount_in_usd) AS "Total Trades Volume",
COUNT(DISTINCT origin_from_address) AS "Total Traders"
FROM base.defi.ez_dex_swaps
WHERE pool_name IN (
'cbBTC-LBTC 3000 60 UNI-V3 LP',
'cbBTC-0xeca...11c1 0 1 ASLP',
'Balancer LBTC/cbBTC',
'cbBTC-LBTC'
)
),
bsc_trades AS (
SELECT
'BSC' AS chain,
COUNT(DISTINCT tx_hash) AS "Total Trades",
SUM(amount_in_usd) AS "Total Trades Volume",
COUNT(DISTINCT origin_from_address) AS "Total Traders"
Last run: 2 months ago
3
105B
9s