PLATFORM | SWAP_COUNT | UNIQUE_SWAPPERS | TOTAL_SWAP_VOLUME_USD | TOTAL_SWAP_FEE_USD | AVERAGE_SWAP_FEE | AVERAGE_SWAP_VOLUME | AVERAGE_SWAP_PER_DAY | AVERAGE_SWAPPERS_PER_DAY | |
|---|---|---|---|---|---|---|---|---|---|
1 | Uniswap on Ethereum | 145021765 | 8288526 | 879564669616.01 | 2999173670.28921 | 17.582164072 | 6147.784784808 | 192336.558355 | 10992.740053 |
2 | Uniswap on Optimism | 39950533 | 2402646 | 26322569263.93 | 27991210.3705176 | 0.5080701589 | 616.410694963 | 52984.791777 | 3186.533156 |
feyikemiUniswap Optimism 2
Updated 2025-01-23
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 Prices AS (
SELECT
date_trunc('day', hour) AS Date,
avg(price) AS price
FROM
optimism.price.ez_prices_hourly
WHERE
symbol ILIKE 'weth'
GROUP BY
Date
),
DexSwapsWithPrice AS (
SELECT
block_timestamp,
tx_hash,
origin_from_address,
amount_in_usd,
tx_fee * price AS tx_fee_usd,
'Uniswap on Ethereum' as Platform
FROM ethereum.defi.ez_dex_swaps
JOIN
ethereum.core.fact_transactions USING (tx_hash)
JOIN
Prices P ON date_trunc('day', block_timestamp) = P.Date
where platform ilike 'uniswap%'
union
SELECT
block_timestamp,
tx_hash,
origin_from_address,
amount_in_usd,
tx_fee * price AS tx_fee_usd,
'Uniswap on Optimism' AS Platform
Last run: about 2 months ago
2
256B
405s