METRIC | SWAP_COUNT_PERCENTAGE_DIFFERENCE | UNIQUE_SWAPPERS_PERCENTAGE_DIFFERENCE | TOTAL_SWAP_VOLUME_USD_PERCENTAGE_DIFFERENCE | TOTAL_SWAP_FEE_USD_PERCENTAGE_DIFFERENCE | AVERAGE_SWAP_FEE_PERCENTAGE_DIFFERENCE | AVERAGE_SWAP_VOLUME_PERCENTAGE_DIFFERENCE | AVERAGE_SWAP_PER_DAY_PERCENTAGE_DIFFERENCE | AVERAGE_SWAPPERS_PER_DAY_PERCENTAGE_DIFFERENCE | |
|---|---|---|---|---|---|---|---|---|---|
1 | Percentage Difference | 113.6075 | 110.1073 | 188.377110027 | 196.301329928 | 188.765868868 | 163.548617316 | 102.3489072569 | 110.10729227 |
feyikemiUniswap Optimism Perc. Diff. copy
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
1
129B
397s