0xPrzOpenSea Buyers Since July 2022
Updated 2022-09-27
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
›
⌄
select 'OpenSea' as platform , sum(price) as volume , count(distinct seller_address) as unique_seller ,count(distinct buyer_address) as unique_buyer
, count(distinct project_name) as projects , count(distinct tx_hash) as sales_count
from ethereum.core.ez_nft_sales
where platform_address in ('0x7f268357a8c2552623316e2562d90e642bb538e5','0x00000000006c3852cbef3e08e8df289169ede581'
,'0x7be8076f4ea4a4ad08075c2508e481d6c946d12b') and currency_address='ETH' and year(block_timestamp::date) =2022 and month(block_timestamp::date) > 6
UNION
select 'Magic Eden' as platform , sum(sales_amount) as volume , count(distinct seller) as unique_seller ,count(distinct purchaser) as unique_buyer
, count(distinct project_name) as projects , count(distinct tx_id) as sales_count
from solana.core.fact_nft_sales
inner join solana.core.dim_nft_metadata on solana.core.dim_nft_metadata.mint=solana.core.fact_nft_sales.mint
where program_id in ('M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K','MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')
and year(block_timestamp::date) =2022 and month(block_timestamp::date) > 6
UNION
select 'Quixotic' as platform , sum(price) as volume , count(distinct seller_address) as unique_seller ,count(distinct buyer_address) as unique_buyer
, count(distinct project_name) as projects , count(distinct tx_hash) as sales_count
from optimism.core.ez_nft_sales inner join optimism.core.dim_labels
on optimism.core.ez_nft_sales.nft_address=optimism.core.dim_labels.address
where platform_address in ('0x3f9da045b0f77d707ea4061110339c4ea8ecfa70','0x829b1c7b9d024a3915215b8abf5244a4bfc28db4',
'0x20975da6eb930d592b9d78f451a9156db5e4c77b','0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6','0xe5c7b4865d7f2b08faadf3f6d392e6d6fa7b903c')
and year(block_timestamp::date) =2022 and month(block_timestamp::date) > 6
Run a query to Download Data