SELECT

date_trunc('day', hour) as day,

avg(price) as price

FROM

ethereum.price.ez_hourly_token_prices

WHERE

token_address = '0xd31a59c85ae9d8edefec411d448f90841571b89c'

AND HOUR > '2023-10-01'

GROUP BY

day

),

bridge AS (

SELECT

date_trunc('day', block_timestamp) as date,

sum(amount_usd) as usd_bridged

FROM

ethereum.defi.ez_bridge_activity

WHERE

block_timestamp > '2023-10-01'

AND Destination_chain = 'solana'

GROUP BY

date

SELECT day, usd_bridged, price

FROM bridge

LEFT JOIN prices ON bridge.date = prices.day