SELECT hour::DATE AS date

, AVG(price) AS sol_price

FROM ethereum.core.fact_hourly_token_prices

WHERE token_address = '0xd31a59c85ae9d8edefec411d448f90841571b89c'

AND hour >= '2022-01-01'

GROUP BY date

),

tx AS (

SELECT block_timestamp::DATE AS date

, COUNT(tx_id) AS tx_num

FROM solana.core.fact_transactions

WHERE date >= '2022-01-01'

GROUP BY date

SELECT sol.date, sol_price, tx_num

FROM sol JOIN tx ON sol.date = tx.date