date_trunc(day,hour) as date,

avg(price) as sol_price

from ethereum.core.fact_hourly_token_prices

where token_address=lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

group by 1

sum(sales_amount*sol_price) as volume,

purchaser as buyer

from solana.core.fact_nft_sales x join solprice b on x.block_timestamp::date=b.date

where succeeded='true'

and marketplace='hyperspace'

group by 2

order by 1 desc

limit 10