commanderjoseph-761gwXPudgy Penguin Total 1
Updated 2024-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
COUNT(DISTINCT buyer_address) AS total_buyer,
COUNT(DISTINCT seller_address) AS total_seller,
COUNT(DISTINCT tokenid) AS total_nft_sold,
COUNT(DISTINCT tx_hash) AS total_nft_sale,
--SUM(price) AS total_volume_in_eth,
SUM(price_usd) AS total_volume_in_usd,
SUM(creator_fee_usd) AS total_creator_fee_usd,
SUM(platform_fee_usd) AS total_platform_fee_usd
FROM
ethereum.nft.ez_nft_sales
WHERE
nft_address = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8') --PUDGY PENGUIN
--AND
--currency_symbol LIKE '%ETH'
QueryRunArchived: QueryRun has been archived