top_collections as (

SELECT

NFT_ADDRESS as address,

sum(price) as volume,

sum(price_usd) as volume_usd,

count(block_timestamp) as num_sales

FROM

ethereum.core.ez_nft_sales

WHERE

block_timestamp >= {{start_date}}

AND block_timestamp <= {{end_date}}

group by

NFT_ADDRESS

order by

volume_usd desc

)

b.name,

b.symbol,

b.address,

b.decimals,

b.contract_metadata,

a.num_sales,

a.volume,

a.volume_usd

top_collections a

JOIN ethereum.core.dim_contracts b

a.address = b.address

AND a.volume_usd IS NOT NULL

ORDER BY

num_sales desc