mo115NFT sales past 60 days
Updated 2022-07-19Copy Reference Fork
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
›
⌄
( select date_trunc('day',BLOCK_TIMESTAMP) as date,
count(TX_ID) as NFTs,
count(distinct BUYER) as buyers,
count(distinct SELLER) as SELLERs,
(NFTs/buyers) as average_buy,
(NFTs/SELLERs)*-1 as average_sell,
'FLOW' as network
from flow.core.fact_nft_sales
where date > CURRENT_DATE - 60
group by 1)
UNION
(select date_trunc('day',BLOCK_TIMESTAMP) as date,
count(TX_ID) as NFTs,
count(distinct PURCHASER) as buyers,
count(distinct SELLER) as SELLERs,
(NFTs/buyers) as average_buy,
(NFTs/SELLERs)*-1 as average_sell,
'SOLANA' as network
from solana.core.fact_nft_sales
where date > CURRENT_DATE - 60
group by 1)
UNION
( select date_trunc('day',BLOCK_TIMESTAMP) as date,
count(TX_HASH) as NFTs,
count(distinct BUYER_ADDRESS) as buyers,
count(distinct SELLER_ADDRESS) as SELLERs,
(NFTs/buyers) as average_buy,
(NFTs/SELLERs)*-1 as average_sell,
'ETHEREUM' as network
from ethereum.core.ez_nft_sales
where date > CURRENT_DATE - 60
group by 1)
Run a query to Download Data