SELECT

date_trunc('day', hour) as day,

avg(price) as price

FROM

ethereum.price.ez_hourly_token_prices

WHERE

token_address = '0xd31a59c85ae9d8edefec411d448f90841571b89c'

AND HOUR > '{{starting_date}}'

GROUP BY

day

),

bridge AS (

SELECT

date_trunc('day', block_timestamp) as date,

COUNT(DISTINCT TX_HASH) as total_txs

FROM

ethereum.defi.ez_bridge_activity

WHERE

block_timestamp > '{{starting_date}}'

AND Destination_chain = 'solana'

GROUP BY

date

SELECT day, total_txs, price

FROM bridge

LEFT JOIN prices ON bridge.date = prices.day