-- forked from Top 10 Collections (sales) @ https://flipsidecrypto.xyz/edit/queries/f1f5cf6f-a7b2-4bce-958e-fc79115bc997 with -- Retreiving $APT Token Price in USD pricet as ( select hour::date as date, avg(price) as apt_price from aptos.price.ez_hourly_token_prices where token_address = '0x1::aptos_coin::aptoscoin' group by 1 ), main as ( select block_number, tx_hash, block_timestamp, 'Wapal' as marketplace, event_data:purchaser as buyer_address, event_data:seller as seller_address, event_data:token_metadata:creator_address as creator_address, event_data:token_metadata:collection_name as collection_name, nvl(split(event_data:token_metadata:token_name, '#')[1], event_data:token_metadata:token_name)::variant as nft_id, nvl(event_data:price, event_data:price:v)/1e8 as price, price * apt_price as price_usd, event_data:royalties/1e8 as royalties, royalties * apt_price as royalties_usd, (gas_used * gas_unit_price)/1e8 as tx_fee, tx_fee * apt_price as tx_fee_usd, event_data:commission/1e8 as platform_fee, platform_fee * apt_price as platform_fee_usd from aptos.core.fact_events a join aptos.core.fact_transactions b using(tx_hash, block_timestamp) left join pricet on date = block_timestamp::date where a.event_address = '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9' and a.event_resource in ('ListingFilledEvent', 'CollectionOfferFilledEvent') and b.success = 1 and b.tx_type = 'user_transaction' and b.payload_function in ( '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::coin_listing::purchase', '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::collection_offer::sell_tokenv2', '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::collection_offer::sell_tokenv1_entry', '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::marketplace_scripts::purchase_many', '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::coin_listing::purchase_many', '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::token_offer::sell_tokenv2', '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::token_offer::sell_tokenv1_entry' ) ) select case when price = 0 then 'a. 0$APT' when price < 0.1 then 'b. 0 - 0.1$APT' when price < 0.2 then 'b. 0.1 - 0.2$APT' when price < 0.5 then 'b. 0.2 - 0.5$APT' when price < 1 then 'b. 0.5 - 1$APT' when price < 2 then 'b. 1 - 2$APT' when price < 5 then 'b. 2 - 5$APT' when price <= 10 then 'c. 5 - 10$APT' when price <= 50 then 'd. 10 - 50 $APT' when price <= 100 then 'e. 50 - 100 $APT' when price <= 500 then 'f. 100 - 500 $APT' end as type, count(distinct tx_hash) as transactions from main group by 1 order by 1

Aptos's Wapal NFT Marketplace Analysis