WITH slnd_swaps AS (

SELECT

swaps.block_timestamp,

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

swaps.tx_id,

prices.close,

prices.close * swaps.swap_from_amount AS amount_usd,

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 = 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp'

WHERE

'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp' = swaps.swap_from_mint

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

AND swaps.succeeded = TRUE

),

slnd_tobek_VoV_inter_1 AS (

SELECT

day,

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

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

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

close,

rank

FROM slnd_swaps

WHERE amount_usd > 0

),