adambalaUA33
Updated 2023-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with table1 as (
select SELLER_address as SELLER,
count (distinct tx_hash) as TX_Count,
count (distinct tokenid) as Tokens_Count,
sum (price_usd) as USD_Value,
sum (price) as ETH_Value
FROM ethereum.core.ez_nft_sales
where EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
group by 1)
select avg(TX_Count),
avg (Tokens_Count),
avg (USD_Value),
avg (ETH_Value)
from table1
Run a query to Download Data