Elprognerd1 - sales
Updated 2022-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
⌄
SELECT
COUNT(DISTINCT TX_HASH) AS "Total number of sales",
COUNT(DISTINCT SELLER_ADDRESS) AS "Total number of sellers",
COUNT(DISTINCT BUYER_ADDRESS) AS "Total number of buyers",
COUNT(DISTINCT NFT_ADDRESS) AS "Total number of NFTs",
COUNT(DISTINCT project_name) AS "Total number of projects",
COUNT(DISTINCT platform_name) as "Total number of platforms",
sum(PRICE) AS "Total volume of NFT sales",
avg(PRICE) AS "Average price of NFTs",
sum(PRICE_USD) AS "Total volume of NFT sales in USD",
avg(PRICE_USD) AS "Average price of NFTs in USD"
/*
sum(TOTAL_FEES) AS "Total volume of purchase fees",
avg(TOTAL_FEES) AS "Average volume of purchase fees",
sum(TOTAL_FEES_USD) AS "Total volume of purchase fees in USD",
avg(TOTAL_FEES_USD) AS "Average volume of purchase fees in USD",
sum(TX_FEE) AS "Total volume of gas fees",
avg(TX_FEE) AS "Average volume of gas fees",
sum(TX_FEE_USD) AS "Total volume of gas fees in USD",
avg(TX_FEE_USD) AS "Average volume of gas fees in USD"
*/
FROM ethereum.core.ez_nft_sales
WHERE origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'
Run a query to Download Data