DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",

CASE

WHEN ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c' THEN 'Metamask'

WHEN ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'uniswap-v2' THEN 'Uniswap V2'

WHEN ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'uniswap-v3' THEN 'Uniswap V3'

WHEN ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'sushiswap' THEN 'Sushiswap'

ELSE 'Other'

END AS "Distr.",

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS "Volume",

SUM(CASE

WHEN ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c' THEN COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)*0.0085/100

WHEN ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'uniswap-v2' THEN COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)*0.3/100

WHEN ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'uniswap-v3' THEN COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)*0.3/100

WHEN ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'sushiswap' THEN COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)*0.3/100

ELSE COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)*0

END) AS "Fees",

--SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD))* 0.0085/100 FILTER (WHERE ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c') AS "Metamask Fees",

--SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD))* 0.3/100 FILTER (WHERE ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'uniswap-v2') AS "Uniswap Fees",

--SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD))* 0.3/100 FILTER (WHERE ORIGIN_TO_ADDRESS != '0x881d40237659c251811cec9c364ef91dc08d300c' AND platform = 'sushiswap') AS "Sushiswap Fees",

COUNT(DISTINCT TX_HASH) AS "Transactions",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users"

FROM ethereum.core.ez_dex_swaps

WHERE BLOCK_TIMESTAMP > CURRENT_DATE() - INTERVAL'720 day'

GROUP BY "Date", "Distr."