--where label_subtype = 'marketplace'

SELECT BLOCK_TIMESTAMP::date as date, sum(RAW_AMOUNT)/POW(10,18) as "Volume in $ETH", avg(price) as "ETH Price", "Volume in $ETH"*"ETH Price" as "Volume in $USD"

from polygon.core.fact_token_transfers

join ethereum.core.fact_hourly_token_prices

on BLOCK_TIMESTAMP::date = HOUR::date

WHERE ORIGIN_TO_ADDRESS = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' --opensea

and TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --eth pricing

and CONTRACT_ADDRESS = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' -- matic eth for sales

and BLOCK_TIMESTAMP::date >= CURRENT_DATE - 30

GROUP by 1