top_collections as (

SELECT

nft_address as address,

count(block_timestamp) as num_sales,

max(price) as max_price,

max(price_usd) as max_price_usd,

min(price) as min_price,

min(price_usd) as min_price_usd,

sum(price) as volume,

sum(price_usd) as volume_usd,

rank() over (

order by

volume_usd desc

) as rank

FROM

ethereum.core.ez_nft_sales

WHERE

block_timestamp > CURRENT_DATE - {{volume_range}}

GROUP BY

nft_address

ORDER BY

volume_usd desc

LIMIT

{{top_rank}}

),

nft_mints as (

SELECT

a.tx_hash,

a.block_timestamp,

a.block_number,

'nft_mints' as source,

a.event_type,

CONCAT(a.nft_address, '_', a.tokenid) as nft_id,

a.project_name,

a.nft_address,