WITH slnd_prices AS (

SELECT

swaps.block_timestamp,

DATE_TRUNC('day', swaps.block_timestamp) AS day,

swaps.tx_id,

prices.close,

ROW_NUMBER() OVER (

PARTITION BY DATE_TRUNC('day', swaps.block_timestamp) ORDER BY swaps.block_timestamp DESC

) AS rank,

FROM

solana.defi.fact_swaps AS swaps

INNER JOIN solana.price.ez_token_prices_hourly AS prices

ON

DATE_TRUNC('hour', swaps.block_timestamp) = prices.recorded_hour

AND prices.token_address = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R'

WHERE

'4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' = swaps.swap_from_mint

AND swaps.block_timestamp > DATE('2022-11-27')

AND swaps.succeeded = TRUE

),

slnd_hlc_prices_inter AS (

SELECT

day,

rank,

MAX(close) OVER (PARTITION BY DATE_TRUNC('day', block_timestamp) ORDER BY block_timestamp) AS high,

MIN(close) OVER (PARTITION BY DATE_TRUNC('day', block_timestamp) ORDER BY block_timestamp) AS low,

close

FROM slnd_prices

),

slnd_hlc_prices AS (

SELECT

day,