LTirrellbarrel_mints minters
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
›
⌄
-- forked from barrel_mints @ https://flipsidecrypto.xyz/edit/queries/b5c36594-6872-461c-969e-675862b52439
with
init_barrel_mints as (
select
instruction:accounts[6] as mint,
null as minter,
'initialized' as mint_type
from
solana.core.fact_events
WHERE
succeeded
and block_timestamp > '2023-06-26'
and program_id = 'CSGrdwbJ5z58tLGKjjcmiNMj8bG1Zazthk3cXMrbSZoX'
and instruction:accounts[13] = 'Ce92PLCQrz2gLNAE5DFovvmpoeLBLtpTzqqeD4Px76hp'
and instruction:data = 'B2ztApDvp684ifio4s' -- initialize mint
),
all_barrel_mints as (
select
mint,
tx_to as minter
FROM
solana.core.fact_transfers
where
mint in (
SELECT
mint
from
init_barrel_mints
)
and block_timestamp > '2023-06-26'
and tx_from = 'smbRrq8tmAXn5ycy7qQooadtBADVduiAygmNb2VHk5u'
union
select
instruction:accounts[6] as mint,
instruction:accounts[5] as minter
Run a query to Download Data