select date_trunc('day', hour) as date, avg(price) as sol_price_

from ethereum.core.fact_hourly_token_prices

where token_address = '0xd31a59c85ae9d8edefec411d448f90841571b89c'

group by 1)

select project_name,

sum (sales_amount*sol_price_) as Volume_usd,

count (distinct tx_id) as Sales

from solana.core.fact_nft_sales t1 join solana.core.dim_nft_metadata t2 on t1.mint = t2.mint

join sol_price b on block_timestamp::date = b.date

where block_timestamp >= '2022-09-22'

and marketplace ilike 'coral cube'

and succeeded = 'TRUE'

group by 1

order by 2 DESC

limit 5