SELECT date_trunc(DAY, HOUR::date) AS DAY, AVG(PRICE) AS price, 'SOL' AS Label

FROM ethereum.core.fact_hourly_token_prices

WHERE TOKEN_ADDRESS = LOWER('0xD31a59c85aE9D8edEFeC411D448f90841571b89c') -- SOL Contract

AND HOUR::date BETWEEN CURRENT_DATE - 60 AND CURRENT_DATE -1

GROUP BY 1

),

transfers AS (

SELECT date_trunc(DAY, BLOCK_TIMESTAMP::date) AS DAY, SUM(AMOUNT) AS "Transfred Volume", COUNT(*) AS "Number of Transfers"

FROM solana.core.fact_transfers

WHERE MINT = 'So11111111111111111111111111111111111111112'

AND BLOCK_TIMESTAMP::date BETWEEN CURRENT_DATE - 60 AND CURRENT_DATE -1

GROUP BY 1

ORDER BY 1

SELECT sol_price.DAY AS DAY, price AS "SOL Price", "Number of Transfers", "Transfred Volume"

FROM sol_price

INNER JOIN transfers ON transfers.DAY = sol_price.DAY