-- forked from transactions @ https://flipsidecrypto.xyz/edit/queries/bf80d1a1-23f7-495a-8fbd-19c2ac3108a5 -- forked from age @ https://flipsidecrypto.xyz/edit/queries/fde3395d-e379-47ad-9044-792174c8482a -- forked from 04 - token used @ https://flipsidecrypto.xyz/edit/queries/84c11d31-61ee-4dee-a9b5-8c39f29bb8e3 -- forked from 04 - sale number @ https://flipsidecrypto.xyz/edit/queries/372421dc-d7c5-43b2-9887-58692bf649f9 -- forked from 03 - sale over view @ https://flipsidecrypto.xyz/edit/queries/0d8d18b5-5645-4ff6-9e89-de549a8dc2e9 with price_token AS ( SELECT date_trunc( 'day' , a.recorded_hour ) AS day , avg( a.close ) AS price , a.id AS id_token , a.token AS token FROM flow.core.fact_hourly_prices a GROUP BY 1 , 3 , 4 ORDER BY 1 ) , min1 AS ( SELECT a.buyer AS new_user , min( a.block_timestamp ) AS min_date FROM flow.core.ez_nft_sales a JOIN price_token b ON a.block_timestamp::date = b.day AND a.currency = b.id_token JOIN flow.core.dim_contract_labels c ON a.nft_collection = c.event_contract JOIN flow.core.dim_contract_labels d ON a.marketplace = d.event_contract WHERE a.nft_collection LIKE '%HWGarageCard%' AND a.block_timestamp::date >= '2023-03-01' AND a.tx_succeeded = 'true' GROUP BY 1 ORDER BY 2 DESC ) , usd_volume AS ( SELECT a.buyer AS user , sum( a.price * b.price ) AS usd_volume FROM flow.core.ez_nft_sales a JOIN price_token b ON a.block_timestamp::date = b.day AND a.currency = b.id_token JOIN flow.core.dim_contract_labels c ON a.nft_collection = c.event_contract JOIN flow.core.dim_contract_labels d ON a.marketplace = d.event_contract JOIN min1 e ON a.buyer = e.new_user WHERE a.nft_collection LIKE '%HWGarageCard%' AND a.block_timestamp::date >= '2023-03-01' AND a.tx_succeeded = 'true' GROUP BY 1 ORDER BY 2 DESC ) SELECT case when usd_volume <= 1 then 'a : < $1' when usd_volume < 10 then 'b : < $10 ' when usd_volume < 50 then 'c : < $50 ' when usd_volume < 150 then 'd : < $150 ' when usd_volume < 500 then 'e : < $500 ' else 'f : > $500 ' end AS "created" , count( DISTINCT user ) AS "users" , sum( "users" ) over ( ORDER BY "created" ASC ) AS "total users" FROM usd_volume GROUP BY 1 ORDER BY len( 1 ) , 1

Explore Hot Wheels NFT collections on Flow Blockchain