yasmin-n-d-r-hUNISWAP TOTAL
Updated 2023-08-23Copy Reference Fork
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
›
⌄
SELECT
COUNT(DISTINCT TX_HASH) AS tx,
count(distinct(project_name)) as projects_count,
count (DISTINCT BUYER_ADDRESS) AS buyer,
count (DISTINCT SELLER_ADDRESS) as seller ,
count(distinct nft_address) as collections,
count(distinct tokenid) as nfts,
sum(PRICE) as volume,
sum(PRICE_USD) as volume_usd,
SUM(TOTAL_FEES_USD) as fee,
SUM(PLATFORM_FEE_USD) as Platform_Fees,
SUM(CREATOR_FEE_USD) as Royalty,
Avg(price_usd) as avg_volume,
AVG(TOTAL_FEES_USD) as Average_Total_Fees,
AVG(PLATFORM_FEE_USD) as Average_Platform_Fees,
AVG(CREATOR_FEE_USD) as Average_Royalty
FROM
ethereum.core.ez_nft_sales
where
ORIGIN_TO_ADDRESS = lower(
'0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b' )
Run a query to Download Data