barbodsale
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tx_ids as (
select
TX_HASH,
BLOCK_TIMESTAMP::date as date ,
EVENT_TYPE ,
SELLER_ADDRESS,
BUYER_ADDRESS,
sum (zeroifnull(PRICE_USD)) as volume
from flipside_prod_db.ethereum_core.ez_nft_sales
WHERe platform_name = 'nftx'
group by 1,2,3,4,5
)
select date as date , count (TX_HASH) as num_sales ,
count (DISTINCT SELLER_ADDRESS) as num_sellers,
count (DISTINCT BUYER_ADDRESS ) as num_buyers,
sum (volume) as sale_volume
from tx_ids
where date >=CURRENT_DATE -60
group by 1
Run a query to Download Data