Zanyar_98Ethereum DEXs deep dive
    Updated 2023-04-13
    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