select hour::date as "date", avg(price) as sol_price

from ethereum.core.fact_hourly_token_prices

where token_address=lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

group by "date"

),

nft_sale_data as

select s.*, m.project_name,s.sales_amount*p.sol_price as sale_in_usd

from solana.core.fact_nft_sales s

inner join solana.core.dim_nft_metadata m on m.mint=s.mint

inner join price p on s.block_timestamp::date=p."date")

select project_name, sum(sale_in_usd) as sum from nft_sale_data

where block_timestamp::date >= {{start_date}}

and project_name is not null

group by 1

having sum > 0

order by 2 desc

limit 5