LTirrellgen3_mints transactions
Updated 2023-09-10
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 gen3_mints @ https://flipsidecrypto.xyz/edit/queries/b0dcc4f4-ceff-40f6-8cf5-03127a13dec8
-- forked from barrel_mints minters @ https://flipsidecrypto.xyz/edit/queries/a9d94fa9-6729-4fe2-85d6-8c561bb91bd2
-- 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' --barrel collection
and instruction:data = 'B2ztApDvp684ifio4s' -- initialize mint
),
all_barrel_mints as (
--barrels from fcfs for Gen2 holders, and raffle winners
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
--barrels minted directly by gen2 holders
Run a query to Download Data