Trades

Bitcoin NFT Trades

The Bitcoin NFT landscape comprises multiple marketplaces. The table below shows the Bitcoin NFT marketplaces indexed by Allium.

Sample Query

Get the market overview of Bitcoin NFTs, in 10 lines of SQL.

SELECT 
    date(block_timestamp) as date, 
    marketplace,
    count(*) as "Count",
    count(distinct collection_name) as "Collections",
    count(distinct buyer_address) as "Buyers",
    sum(usd_price) as "USD Volume"
FROM bitcoin.nfts.trades 
group by 1,2
order by 1 desc

Table Columns