select

*,

'arbitrum' as chain

from

arbitrum.price.ez_prices_hourly

union

all

select

*,

'optimism' as chain

from

optimism.price.ez_prices_hourly

union

all

select

*,

'bnb' as chain

from

bsc.price.ez_prices_hourly

union

all

select

*,

'base' as chain

from

base.price.ez_prices_hourly

union

all

select

*,

'ethereum' as chain

from

ethereum.price.ez_prices_hourly

union

all