hour,

token_address,

case when symbol IS NULL then 'ETH' else symbol end as symbol,

price

from ethereum.core.fact_hourly_token_prices feed

where (feed.token_address = '0xbe9895146f7af43049ca1c1ae358b0541ea49704'

or (feed.token_address IS NULL))

and hour > current_date - 31;