-- forked from alitaslimi / Sales Overview @ https://flipsidecrypto.xyz/alitaslimi/q/2023-04-22-05-11-am-y59OZp

WITH

sales AS (

SELECT

block_timestamp,

TX_HASH,

PLATFORM_NAME,

BUYER_ADDRESS,

SELLER_ADDRESS,

TOKENID,

PRICE_USD,

PRICE,

CREATOR_FEE

FROM

ethereum.core.ez_nft_sales

where

PROJECT_NAME = 'decentra dragon'

)

block_timestamp::date as "Date",

PLATFORM_NAME as "Marketplace",

COUNT(DISTINCT TX_HASH) AS "Sales",

COUNT(DISTINCT SELLER_ADDRESS) AS "Sellers",

COUNT(DISTINCT BUYER_ADDRESS) AS "Buyers",

COUNT(DISTINCT TOKENID) AS "NFTs",

SUM(PRICE) AS "Volume [ETH]",

SUM(PRICE_USD) AS "Volume [USD]",

Sum(CREATOR_FEE) as "CREATOR FEE",

-- SUM(royalty) AS "Royalties [SOL]",

--SUM(royalty_usd) AS "Royalties [USD]",

AVG(PRICE) AS "Average Price",