SELECT

DATE_TRUNC('day', hour) AS trading_date,

token_address,

AVG(price) AS daily_avg_price

FROM ink.price.ez_prices_hourly

WHERE NOT is_deprecated

AND token_address IS NOT NULL

GROUP BY 1, 2

),

swap_activity AS (

SELECT

DATE_TRUNC('day', el.block_timestamp) AS trading_date,

el.block_timestamp,

tt.contract_address AS token_contract,

tt.symbol AS token_symbol,

tt.decimals AS token_precision,

tt.raw_amount_precise AS token_amount,

el.origin_from_address AS trader_address,

el.tx_hash

FROM ink.core.fact_event_logs el

INNER JOIN ink.core.ez_token_transfers tt

ON el.tx_hash = tt.tx_hash

WHERE el.topic_0 = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'

AND SUBSTR(el.topics[1], -40) = '9b17690de96fcfa80a3acaefe11d936629cd7a77'

AND el.contract_address IN (

'0x73a09cd53871b2ac4f5e08b89eb2e25e1959d92a',

'0x7e16bb931c222e47597fa745abcc03098e1ebcf6'

)

AND el.block_timestamp < current_date

--AND el.block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 days' -- Added back the time filter

SELECT

sa.trading_date,