top_collections as (

select

project_name as "Collection",

count(distinct tx_hash) as "Number of Sales",

sum(price_usd) as "Total Sales ($)"

from

ethereum.core.ez_nft_sales

where

block_timestamp::date >= '2022-10-19' -- blur launch

and project_name is not NULL

group by

project_name

order by

"Total Sales ($)" desc,

"Number of Sales" desc

limit

15

)

BLOCK_TIMESTAMP::date as date,

'{{Collection}}' as collection,

platform_name,

count(distinct tx_hash) as tx_count,

avg(tx_count) OVER (

ORDER BY DATE ROWS BETWEEN 7 PRECEDING AND CURRENT ROW

) as "Rolling Avg 7d: tx_count",

sum(price) as total_sales,

sum(price_usd) as total_sales_usd,

sum(platform_fee) as total_platform_fee,

sum(platform_fee_usd) as total_platform_fee_usd,

sum(creator_fee) as total_creator_fee,