-- forked from Distribution of Buyers By #Trades (FLOW NFT Tracker) @ https://flipsidecrypto.xyz/edit/queries/59af8ef2-c771-4dce-a21f-40435631c262 with flowpricet as ( select hour::date as day, avg(price) as flowprice from flow.price.ez_prices_hourly where symbol ='FLOW' group by 1), userst as ( select buyer, count (Distinct tx_id) as Sales, count (distinct NFT_ID) as Traded_NFTs, count (distinct buyer) as Buyers, count (Distinct seller) as Sellers, sum (case when currency in ('A.ead892083b3e2c6c.FlowUtilityToken','A.1654653399040a61.FlowToken') then price*flowprice else price end) as Sales_Volume, avg (case when currency in ('A.ead892083b3e2c6c.FlowUtilityToken','A.1654653399040a61.FlowToken') then price*flowprice else price end) as Average_Sales_Volume, min (case when currency in ('A.ead892083b3e2c6c.FlowUtilityToken','A.1654653399040a61.FlowToken') then price*flowprice else price end) as Floor_Price, max (case when currency in ('A.ead892083b3e2c6c.FlowUtilityToken','A.1654653399040a61.FlowToken') then price*flowprice else price end) as Price_Ceiling from flow.nft.ez_nft_sales t1 join flowpricet t2 on t1.block_timestamp::Date = t2.day where tx_succeeded ilike 'TRUE' and block_timestamp >= '{{Start_Date}}' and block_timestamp <= '{{End_Date}}' and substr(nft_collection,20) ilike '%{{NFT_Collection}}%' group by 1) select case when Sales_Volume < 1 then '< $1' when Sales_Volume >= 1 and Sales_Volume < 5 then '$1 - $5' when Sales_Volume >= 5 and Sales_Volume < 10 then '$5 - $10' when Sales_Volume >= 10 and Sales_Volume < 25 then '$10 - $25' when Sales_Volume >= 25 and Sales_Volume < 50 then '$25 - $50' when Sales_Volume >= 50 and Sales_Volume < 100 then '$50 - $100' when Sales_Volume >= 100 and Sales_Volume < 500 then '$100 - $500' when Sales_Volume >= 500 and Sales_Volume < 1000 then '$500 - $1000' else '> $1000' end as type, count (distinct buyer) as Buyers from userst group by 1 order by 2 desc

Flow NFT Tracker