0.2. Overview | NFT in Flow Ecosystems

hbd19940.2. Overview | NFT in Flow Ecosystems

Updated 2022-09-25

select

(count(tx_id)/count(distinct block_timestamp::date)) as "Average Sales per Day",

(count(tx_id)/count(distinct buyer)) as "Average Purchases per Buyers",

(count(tx_id)/count(distinct seller)) as "Average Sales per Sellers",

(sum(usd_amount)/count(tx_id)) as "Average USD per Sale",

(sum(usd_amount)/count(distinct buyer)) as "Average USD Amount per Buyer",

(sum(usd_amount)/count(distinct seller)) as "Average USD Amount per Seller",

(sum(usd_amount)/count(distinct block_timestamp::date)) as "Average USD Amount per Day"

from

(with table1 as ((select

tx_id,

block_timestamp,

MARKETPLACE,

NFT_COLLECTION,

NFT_ID,

buyer,

seller,

currency,

price,

(price*1) as usd_amount,

date(block_timestamp) as date0,

hour(block_timestamp) as hour0,

minute(block_timestamp) as min0

from flow.core.ez_nft_sales

where TX_SUCCEEDED = true

and currency != 'A.1654653399040a61.FlowToken')

union

(with tab1 as (select