adambaladoodless-Sale’s activities
Updated 2023-04-13
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with eth as
(select
PRICE as volume ,
NFT_ADDRESS ,
SELLER_ADDRESS as sellers ,
BUYER_ADDRESS as buyers ,
TX_HASH as sale_tx ,
BLOCK_TIMESTAMP ::date as date ,
TOKENID ,
PRICE_USD ,
TOTAL_FEES,
PLATFORM_FEE ,
CREATOR_FEE ,
TOTAL_FEES_USD ,
PLATFORM_FEE_USD ,
CREATOR_FEE_USD,
TX_FEE,
TX_FEE_USD
from
ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and
lower(NFT_ADDRESS)=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
)
, ethh as (select
count (distinct TOKENID) as "Number of TOKENID",
count (distinct sellers) as "seller",
count (distinct buyers) as "buyer",
count (distinct sale_tx) as "sale_txs",
sum(volume) as "volumes" ,
sum(PRICE_USD) as PRICE_USDs ,
sum(TOTAL_FEES) as TOTAL_FEESs ,
sum(PLATFORM_FEE) as PLATFORM_FEEs ,
sum(CREATOR_FEE) as CREATOR_FEEs ,
sum(TOTAL_FEES_USD) as TOTAL_FEES_USDs ,
sum(PLATFORM_FEE_USD) as PLATFORM_FEE_USDs ,
sum(CREATOR_FEE_USD) as CREATOR_FEE_USDs ,
Run a query to Download Data