fidamAggregate
Updated 2024-12-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
Select
Count(DISTINCT Tx_hash) as Transactions,
Count(DISTINCT SELLER_ADDRESS) as Sellers,
Count(DISTINCT BUYER_ADDRESS) as Buyers,
Count(Distinct TOKENID) as Nft_sale,
Sum(PRICE_USD) as Volume,
Avg(PRICE_USD) as Avg_volume,
Sum(TOTAL_FEES_USD) as Overall_Fee,
Sum(CREATOR_FEE_USD) as Creator_fee,
Avg(CREATOR_FEE_USD) as Avg_Creator_fee,
Sum(PLATFORM_FEE_USD) as platform_fee,
Avg(PLATFORM_FEE_USD) as Avg_platform_fee,
Sum(TX_FEE_USD) as Transaction_fee,
Avg (TX_FEE_USD) as Avg_Transaction_fee,
Concat(buyers +sellers) as Users
From
base.nft.ez_nft_sales
WHERE
PLATFORM_NAME = 'element'
QueryRunArchived: QueryRun has been archived