block_timestamp::date as date,

PLATFORM_NAME,

count(DISTINCT tx_hash) as "Sales cnt",

count(distinct buyer_address) as "Buyer Cnt",

count(distinct SELLER_ADDRESS) as "Seller Cnt",

count(distinct NFT_ADDRESS) as "Collection Cnt",

count(distinct TOKENID) as "NFT Token Cnt",

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

sum(price) as "Total Sales volume(ETH)",

avg(price_usd) as "Avg Sales volume($)",

sum(tx_fee_usd) as "Total Tx fee($)",

avg(tx_fee_usd) as "Avg Tx fee($)",

sum("Sales cnt") over (partition by PLATFORM_NAME order by date) as "Cum Sales cnt",

sum("Total Sales volume($)") over (partition by PLATFORM_NAME order by date) as "Cum Sales volume($)",

sum("Total Tx fee($)") over (partition by PLATFORM_NAME order by date) as "Cum Total Tx fee($)"

from ethereum.core.ez_nft_sales

where ORIGIN_TO_ADDRESS = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'

group by 1,2