Delamir-6014WC08 purchase
Updated 2022-11-22
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
›
⌄
with list as (
select
date(block_timestamp) as date,
buyer_address,
count (distinct tx_hash) as Number_Purchase,
count (distinct tokenid) as Number_NFTS,
avg (price_usd) as avg_purchase_Volume,
min (price_usd) as min_purchase_Volume,
max (price_usd) as max_purchase_Volume ,
sum (price_usd) as Total_Purchase_Volume
from ethereum.core.ez_nft_sales
where NFT_ADDRESS = lower('0x629A673A8242c2AC4B7B8C5D8735fbeac21A6205')
and PROJECT_NAME = 'sorare'
and PLATFORM_NAME = 'opensea'
group by 1,2
order by 1
)
select
'Sorare Footnal Market' as market,
sum (Number_Purchase) as Num_purchase,
sum(Number_NFTS) as num_NFTs,
avg(avg_purchase_Volume) as avg_purchase_vol,
min(min_purchase_Volume) as min_purchase_vol,
max(max_purchase_Volume) as max_purchase_vol,
sum(Total_Purchase_Volume) as total_purchase_vol
from list
group by 1
Run a query to Download Data