block_timestamp::date as day,

nft_address,

project_name,

count(tx_hash) as sales

from ethereum.core.ez_nft_sales

where block_timestamp::date >= current_date - 30

and event_type = 'sale'

group by 1,2,3

qualify row_number() over (partition by day order by sales desc) <= 5),

label as (select

address,

from ethereum.core.dim_labels)

nft.day, nft.sales, label.address_name, nft.nft_address

from nft

left join label

on nft.nft_address=label.address

order by nft.sales desc