(select

PRICE as volume ,

NFT_ADDRESS ,

SELLER_ADDRESS as sellers ,

BUYER_ADDRESS as buyers ,

TX_HASH as sale_tx ,

date_trunc('hour',BLOCK_TIMESTAMP) as date ,

TOKENID ,

PRICE_USD

from

optimism.core.ez_nft_sales where EVENT_TYPE='sale' and

lower(NFT_ADDRESS)=lower('0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2')

, optimism_quests as (

select

date ,

count (distinct TOKENID) as "Number of TOKENID",

count (distinct sellers) as "seller",

count (distinct buyers) as "buyer",

count (distinct sale_tx) as "sale_txs",

sum(volume) as "volumes" ,

sum(PRICE_USD) as PRICE_USDs ,

sum("seller") over (order by date) as "cum sellers" ,

sum("buyer") over (order by date) as "cum buyer" ,

sum("sale_txs") over (order by date) as "cum sale_txs" ,

sum("volumes") over (order by date) as "cum volumes" ,

sum(PRICE_USDs) over (order by date) as "cum PRICE_USDs"

from optimism_quest group by 1)

select DATE,

-"seller" as "seller" ,

"buyer" ,

"Number of TOKENID" ,