itsxenuxTrades count of Magic Eden
Updated 2022-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with query_table1 as
(select solana.fact_events.instruction:parsed:info:mint
as mint
from solana.fact_events
join solana.fact_transfers
on solana.fact_transfers.tx_id = solana.fact_events.tx_id
where solana.fact_events.instruction:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
and solana.fact_transfers.index = 1
and solana.fact_events.index = 3
and solana.fact_transfers.mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
and solana.fact_events.block_timestamp::date >= '2022-04-04')
select count(distinct tx_id)
as total_sales,
block_timestamp::date
as date_time
from solana.fact_nft_sales
join query_table1
where fact_nft_sales.block_timestamp >= '2022-04-04'
and fact_nft_sales.mint = query_table1.mint
and fact_nft_sales.succeeded = 'true'
and fact_nft_sales.marketplace like 'magic%'
group by date_time
order by date_time
Run a query to Download Data