SUM(Volume * price) AS "txns volume in USD"

FROM

(

SELECT

DATE_TRUNC('day', block_timestamp) AS date,

SUM(output_value) AS Volume

FROM bitcoin.core.fact_transactions

WHERE block_timestamp >= current_date() - 90

AND output_value IS NOT NULL

GROUP BY 1

) vol

LEFT JOIN (

SELECT DATE_TRUNC('day', hour) AS date,

AVG(price) AS price

FROM ethereum.price.ez_hourly_token_prices

where hour >= current_date() - 90

AND

symbol = 'WBTC'

GROUP BY 1

) price

ON vol.date = price.date

;