from ethereum.core.ez_nft_sales

where price_usd > 0 and platform_name = 'opensea' and year(block_timestamp) = '2023'),

lol as (select date_trunc('month', block_timestamp) as dt, project_name, nft_address, sum(price_usd) as vol_usd, ROW_NUMBER() OVER (PARTITION BY dt ORDER BY vol_usd desc) as rank

from allsale

group by 1,2,3)

select *

from lol

where nft_address = '0x9674739124d69d555712a30e0a44de648f494219'