andurilSMB Sales Royalties - Magic Eden
Updated 2023-01-13
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 magic_eden_txs as (
select
distinct tx_id
from solana.core.fact_events
where
date(block_timestamp) >= '2022-10-01'
and succeeded = 'TRUE'
and program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' --magic eden v2
)
select
'SMBs Royalty Txs' as type,
date(block_timestamp) as date,
count(distinct tx_id) as royalty_paid_txs
--sum(amount) as royalty_paid_sol,
--avg(amount) as avg_royalty_paid_sol
from
solana.core.fact_transfers t
inner join magic_eden_txs
using (tx_id)
where
--tx_id = '3UphPZXD8JCZBWzDqJBFZ63n4bYbJVQRahdyKZaVG9dR5gcC2NhcyjNLzsPyi1GP14ma9MroGF5nqB9ZM5mV9Yvh'
tx_to = '9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F' -- smb creator address
and mint = 'So11111111111111111111111111111111111111112'
group by date
union
select
'SMBs Sales' as type,
date(s.block_timestamp) as date,
count(distinct s.tx_id) as txs
from
solana.core.fact_nft_sales s
inner join
Run a query to Download Data