RayyykVolume Scoring with NBA Top Shot
Updated 2022-06-03
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
›
⌄
select date_trunc('day', block_timestamp) as day,
'Top Shot' as platform,
count(distinct(tx_id)) as ts_sales_count,
count(distinct(buyer)) as ts_wallets
from flow.core.fact_nft_sales
where block_timestamp >= '2022-05-09'
and marketplace = 'A.c1e4f4f4c4257510.TopShotMarketV3'
and tx_succeeded = 'TRUE'
--and price > 0
group by 1
union
select date_trunc('day', block_timestamp) as day,
'Magic Eden',
count(distinct(tx_id)) as me_sales_count,
count(distinct(purchaser)) as me_wallets
from flipside_prod_db.solana.fact_nft_sales
where block_timestamp >= '2022-05-09'
and (marketplace = 'magic eden v1'
or marketplace = 'magic eden v2')
and succeeded = 'TRUE'
--and sales_amount > 0
group by 1
union
select date_trunc('day', block_timestamp) as day,
'OpenSea',
count(distinct(tx_hash)) as os_sales_count,
count(distinct(buyer_address)) as os_wallets
from flipside_prod_db.ethereum_core.ez_nft_sales
where block_timestamp >= '2022-05-09'
and platform_name = 'opensea'
and event_type = 'sale'
--and price_usd > 0
group by 1
Run a query to Download Data