rackhaelTOTAL UNISWAP MARKETSHARE
Updated 2024-01-22
999
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 ETHEREUM AS(
SELECT
CASE
WHEN platform ILIKE 'uniswap%' THEN 'Uniswap'
WHEN platform ILIKE 'dodo%' THEN 'Dodo'
WHEN platform ILIKE 'hashflow%' THEN 'Hashflow'
WHEN platform ILIKE 'kyberswap%' THEN 'KyberSwap'
WHEN platform ILIKE 'pancakeswap%' THEN 'PancakeSwap'
WHEN platform ILIKE 'trader-joe%' THEN 'Trader-joe'
ELSE platform -- Keep other platforms as is
END AS platform,
COUNT(DISTINCT tx_hash) AS transactions,
COUNT(tx_to) AS addresses,
SUM(amount_in_usd) AS transacted_volume_usd
FROM ethereum.defi.ez_dex_swaps
WHERE block_timestamp::date >= current_date - 180
GROUP BY 1
ORDER BY 1
),
ARBITRUM AS (
SELECT
CASE
WHEN platform ILIKE 'uniswap%' THEN 'Uniswap'
WHEN platform ILIKE 'dodo%' THEN 'Dodo'
WHEN platform ILIKE 'hashflow%' THEN 'Hashflow'
WHEN platform ILIKE 'kyberswap%' THEN 'KyberSwap'
WHEN platform ILIKE 'camelot%' THEN 'Camelot'
WHEN platform ILIKE 'trader-joe%' THEN 'Trader-joe'
WHEN platform ILIKE 'zyberswap%' THEN 'Zyberswap'
ELSE platform -- Keep other platforms as is
END AS platform,
COUNT(DISTINCT tx_hash) AS transactions,
COUNT(tx_to) AS addresses,
SUM(amount_in_usd) AS transacted_volume_usd
FROM arbitrum.defi.ez_dex_swaps
QueryRunArchived: QueryRun has been archived