mohammadh3) Cryptopunk Sales and Traders
Updated 2022-08-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc('week' , block_timestamp) as block_week,
count(distinct TX_HASH) as tx_count,
count(distinct SELLER_ADDRESS) as seller_count,
count(distinct BUYER_ADDRESS) as buyer_count,
sum(PRICE_USD) as usd_volume ,
sum(PRICE) as eth_volume,
avg(PRICE_USD) as avg_usd_price,
avg(PRICE) as avg_eth_price,
sum(seller_count) over (order by block_week asc) as cum_seller_count,
sum(buyer_count) over (order by block_week asc) as cum_buyer_count,
sum(usd_volume) over (order by block_week asc) as cum_usd_volume,
sum(eth_volume) over (order by block_week asc) as cum_eth_volume,
sum(tx_count) over (order by block_week asc) as cum_tx_count
from ethereum.core.ez_nft_sales
where (PROJECT_NAME = 'cryptopunks' and NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' or NFT_ADDRESS='0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' and PROJECT_NAME='wrapped cryptopunks')
and EVENT_TYPE = 'sale'
and PRICE_USD > 0
and BUYER_ADDRESS !='0x0000000000000000000000000000000000000000'
group by block_week
Run a query to Download Data