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 '{{DEX_For_Deeper_Dive}}' AS Input_DEXs,

CASE

WHEN Input_DEXs = 'Sushiswap' THEN 'sushiswap'

WHEN Input_DEXs = 'Uniswap-v2' THEN 'uniswap-v2'

WHEN Input_DEXs = 'Uniswap-v3' THEN 'uniswap-v3'

WHEN Input_DEXs = 'Curve' THEN 'curve'

WHEN Input_DEXs = 'Balancer' THEN 'balancer'

ELSE 'sushiswap'

END AS DEXs_To_Compare,

SPLIT(DEXs_To_Compare, ',') AS DEXs_ARRAY

),

STABLECOINS_ON_Ethereum AS (

SELECT '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AS ADDRESS, 'USDC' AS NAME

UNION ALL

SELECT '0x8e870d67f660d95d5be530380d0ec0bd388289e1' AS ADDRESS, 'USDP' AS NAME

UNION ALL

SELECT '0xdac17f958d2ee523a2206206994597c13d831ec7' AS ADDRESS, 'USDT' AS NAME

UNION ALL

SELECT '0x056fd409e1d7a124bd7017459dfea2f387b6d5cd' AS ADDRESS, 'GUSD' AS NAME

UNION ALL

SELECT '0x0000000000085d4780b73119b644ae5ecd22b376' AS ADDRESS, 'TUSD' AS NAME