WITH prices as (

SELECT

hour,

price,

decimals,

symbol,

iff(

is_native,

'0x0000000000000000000000000000000000000000',

token_address

) as token_address,

'ethereum' AS chain

FROM

ethereum.price.ez_prices_hourly

UNION

SELECT

hour,

price,

decimals,

symbol,

iff(

is_native AND (symbol = 'XDAI'),

'0x0000000000000000000000000000000000000000',

token_address

) as token_address,

'gnosis' AS chain

FROM

gnosis.price.ez_prices_hourly

),

ethereum_txns AS (

SELECT

date_trunc('d', a.block_timestamp) AS date,