Zanyar_98Ethereum DEXs deep dive
Updated 2023-04-13Copy Reference Fork
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 GET_INPUT_Timespan AS (
SELECT '{{Timespan}}' AS INPUT_Timespan,
CASE
WHEN INPUT_Timespan = 'Last 30 days' THEN CURRENT_DATE - 30
WHEN INPUT_Timespan = 'Last 60 days' THEN CURRENT_DATE - 60
WHEN INPUT_Timespan = 'Last 90 days' THEN CURRENT_DATE - 90
WHEN INPUT_Timespan = 'Last 180 days' THEN CURRENT_DATE - 180
--WHEN INPUT_Timespan = 'Last year' THEN CURRENT_DATE - 365
ELSE '2014-01-01'
END AS Timespan
),
GET_DEXs AS (
SELECT '{{Compare_DEXs}}' AS Input_DEXs,
CASE
WHEN Input_DEXs = 'Sushiswap VS Balancer' THEN 'sushiswap,balancer'
WHEN Input_DEXs = 'Sushiswap VS Uniswap-v2' THEN 'sushiswap,uniswap-v2'
WHEN Input_DEXs = 'Sushiswap VS Uniswap-v3' THEN 'sushiswap,uniswap-v3'
WHEN Input_DEXs = 'Sushiswap VS Curve' THEN 'sushiswap,curve'
WHEN Input_DEXs = 'Balancer VS Uniswap-v2' THEN 'balancer,uniswap-v2'
WHEN Input_DEXs = 'Balancer VS Uniswap-v3' THEN 'balancer,uniswap-v3'
WHEN Input_DEXs = 'Balancer VS Curve' THEN 'balancer,curve'
WHEN Input_DEXs = 'Uniswap-v2 VS Uniswap-v3' THEN 'uniswap-v2,uniswap-v3'
WHEN Input_DEXs = 'Uniswap-v2 VS Curve' THEN 'uniswap-v2,curve'
WHEN Input_DEXs = 'All DEXs' THEN 'sushiswap,balancer,uniswap-v2,uniswap-v3,curve'
ELSE 'sushiswap,balancer,uniswap-v2,uniswap-v3,curve'
END AS DEXs_To_Compare,
SPLIT(DEXs_To_Compare, ',') AS DEXs_ARRAY
),
STABLECOINS_ON_Ethereum AS (
SELECT '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AS ADDRESS, 'USDC' AS NAME
Run a query to Download Data