WITH eul_swaps AS (

SELECT

block_timestamp,

DATE_TRUNC('day', block_timestamp) AS day,

CASE

WHEN token_in = '0xd9fcd98c322942075a5c3860693e9f4f03aae07b' THEN DIV0(amount_out_usd , amount_in)

ELSE DIV0(amount_in_usd , amount_out)

END AS price,

MAX(price) OVER (PARTITION BY day ORDER BY block_timestamp) AS high,

MIN(price) OVER (PARTITION BY day ORDER BY block_timestamp) AS low,

CASE

WHEN token_in = '0xd9fcd98c322942075a5c3860693e9f4f03aae07b' THEN amount_out_usd

ELSE amount_in_usd

END AS amount_usd,

SUM(amount_usd) OVER (PARTITION BY day ORDER BY block_timestamp) AS volume,

COUNT(block_timestamp) OVER (PARTITION BY day ORDER BY block_timestamp) AS trade_count,

ROW_NUMBER() OVER (PARTITION BY day ORDER BY block_timestamp DESC) AS rank

FROM ethereum.defi.ez_dex_swaps

WHERE

(token_in = '0xd9fcd98c322942075a5c3860693e9f4f03aae07b'

OR token_out = '0xd9fcd98c322942075a5c3860693e9f4f03aae07b')

AND block_timestamp > DATE('2021-12-31 00:00')

),

eul_mec_VoV_LIX_inter AS (

SELECT

day,

volume,

high,

low,

price AS close,

CASE

WHEN (high - low) = 0

THEN 0