drone-mostafaSol Open total
Updated 2023-04-23
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
›
⌄
select
count (DISTINCT TX_HASH ) as TXN,
count (DISTINCT BUYER_ADDRESS ) as BUYER,
count (DISTINCT SELLER_ADDRESS ) as Seller,
count (distinct TOKENID) as NFT_IDs,
SUM (PRICE_USD) AS USD,
Median (PRICE_USD) AS avg_USD,
'Ethereum' as chain
FROM ethereum.core.ez_nft_sales
WHERE BLOCK_TIMESTAMP >= '2021-01-01'
UNION
SELECT
COUNT (DISTINCT TX_ID) AS TXN,
COUNT (DISTINCT PURCHASER) AS BUYERS,
COUNT (DISTINCT SELLER) AS SELLERS,
COUNT (DISTINCT s.MINT) AS NFT_IDs,
SUM (SALES_AMOUNT * price) AS USD,
Median (SALES_AMOUNT * price) AS avg_USD,
'Solana' as chain
from solana.core.fact_nft_sales s
--JOIN solana.core.dim_nft_metadata m on s.MINT=m.MINT
left join (select date_trunc ('day',RECORDED_HOUR) as TIME, median (CLOSE) as price from solana.core.fact_token_prices_hourly WHERE SYMBOL = 'SOL' GROUP by 1) on block_timestamp::DATE = TIME
WHERE BLOCK_TIMESTAMP >= '2021-01-01'
UNION
select
count (DISTINCT TX_ID ) as TXN,
count (DISTINCT BUYER ) as BUYER,
count (DISTINCT SELLER ) as Seller,
count (distinct NFT_ID) as NFT_IDs,
Run a query to Download Data