commanderjoseph-761gwXBASE NFT in Last 24h
Updated 2024-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
COUNT(DISTINCT tx_hash) AS total_nft_sale_24h,
COUNT(DISTINCT seller_address) AS total_nft_seller_24h,
COUNT(DISTINCT buyer_address) AS total_nft_buyer_24h,
COUNT(DISTINCT nft_address) AS total_nft_sold_24h,
SUM(price_usd) AS total_nft_volume_24h,
SUM(creator_fee_usd) AS total_creator_fee_24h,
SUM(platform_fee_usd) AS total_platform_fee_24h
FROM
base.nft.ez_nft_sales
WHERE
block_timestamp > current_timestamp - interval '1 day'
QueryRunArchived: QueryRun has been archived