(

select block_timestamp::date as "date",

count(distinct tx_hash) as number_of_transaction,

count(tx_hash) as number_of_nfts_sold,

count(distinct seller_address) as number_of_sellers,

count(distinct buyer_address) as number_of_buyers,

sum(price) as total_eth_amount,

sum(price_usd) as total_usd_amount,

sum(price_usd)*0.025 as platform_fee_usd

-- sum(creator_fee_usd) as royalty_fee_usd

from optimism.core.ez_nft_sales

where platform_name ='quixotic'

and block_timestamp::date >= {{start_date}}

and event_type='sale'

group by"date"

)

select *,platform_fee_usd/number_of_transaction as arpt from nft_data