LTirrellCopy of SMB Royalties on ME
Updated 2022-12-06
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
›
⌄
/*
tx_id = '3UphPZXD8JCZBWzDqJBFZ63n4bYbJVQRahdyKZaVG9dR5gcC2NhcyjNLzsPyi1GP14ma9MroGF5nqB9ZM5mV9Yvh'
select
*
from
solana.core.fact_transactions
where tx_id = '3UphPZXD8JCZBWzDqJBFZ63n4bYbJVQRahdyKZaVG9dR5gcC2NhcyjNLzsPyi1GP14ma9MroGF5nqB9ZM5mV9Yvh'
*/
-- with magic_eden_txs as (
-- select
-- distinct tx_id
-- from solana.core.fact_events
-- where
-- date(block_timestamp) >= '2022-01-01' and
-- program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' --magic eden v2
-- )
-- select
-- 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
Run a query to Download Data