shadilSolport vs. Magic Eden - Taiyo Robotics
Updated 2022-04-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
34
35
36
›
⌄
with ogs as (
select contract_address from solana.dim_nft_metadata
where project_name = 'Taiyo Robotics'
),
magic_eden AS (
SELECT
date(block_timestamp) as date,
sum(sales_amount) as total_sales,
COUNT(DISTINCT purchaser) as total_purchasers,
'Magic Eden' as type
FROM solana.fact_nft_sales
WHERE date(block_timestamp) BETWEEN '2022-03-12' and CURRENT_DATE - 2
and(program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
or program_id = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')
and succeeded = 'TRUE'
and mint::string in (SELECT * from ogs)
GROUP by date
),
solport AS (
SELECT
date(block_timestamp) as date,
sum(sales_amount) as total_sales,
COUNT(DISTINCT purchaser) as total_purchasers,
'Solport' as type
FROM solana.fact_nft_sales
WHERE date(block_timestamp) BETWEEN '2022-03-12' and CURRENT_DATE - 2
and program_id = 'SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj'
and succeeded = 'TRUE'
and mint::string in (SELECT * from ogs)
GROUP by date
)
SELECT * FROM magic_eden
Run a query to Download Data