DATE | MINT_TXNS | UNIQUE_MINTERS | |
|---|---|---|---|
1 | 2022-12-29 00:00:00.000 | 50 | 1 |
2 | 2022-12-26 00:00:00.000 | 39 | 1 |
3 | 2022-12-23 00:00:00.000 | 335 | 2 |
4 | 2022-12-21 00:00:00.000 | 444 | 1 |
5 | 2022-12-20 00:00:00.000 | 1131 | 4 |
6 | 2022-12-19 00:00:00.000 | 207 | 1 |
7 | 2022-12-16 00:00:00.000 | 550 | 3 |
8 | 2022-12-15 00:00:00.000 | 12 | 2 |
9 | 2022-12-13 00:00:00.000 | 16 | 1 |
10 | 2022-12-12 00:00:00.000 | 9823 | 2 |
11 | 2022-12-11 00:00:00.000 | 2 | 1 |
12 | 2022-12-10 00:00:00.000 | 486 | 1 |
13 | 2022-12-06 00:00:00.000 | 102 | 1 |
14 | 2022-11-30 00:00:00.000 | 276 | 1 |
15 | 2022-11-28 00:00:00.000 | 4 | 1 |
16 | 2022-11-27 00:00:00.000 | 3818 | 1 |
17 | 2022-11-26 00:00:00.000 | 2959 | 2 |
18 | 2022-11-25 00:00:00.000 | 5468 | 1 |
19 | 2022-11-23 00:00:00.000 | 237 | 1 |
20 | 2022-11-22 00:00:00.000 | 55 | 1 |
messariCandyV3 Mints
Updated 2025-02-11
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
base as ( -- get successful candyv3 transactions
select
t.block_timestamp,
t.tx_id,
t.signers[0] as wallet,
t.instructions[0]:parsed:info:owner as owner,
t.instructions,
t.log_messages
from
solana.core.fact_events e
inner join solana.core.fact_transactions t on e.tx_id = t.tx_id
where
date(t.block_timestamp) >= date('2022-10-01') -- CandyV3 went live in october
and date(t.block_timestamp) < date('2023-01-01')
and e.program_id = 'CndyV3LdqHUfDLmE5naZjVN8rBZz4tqhdefbAnjHG3JR'
and t.succeeded = 'TRUE'
),
raw as ( -- get mints
select
date(block_timestamp) as date,
--tx_id,
wallet
--instructions[1]:parsed:info:mint as mint
from
base
where
owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
and log_messages::string like '%Program log: Instruction: Mint%'
)
select
date,
count(wallet) as mint_txns,
count(distinct wallet) as unique_minters
--count(distinct mint) as unique_mints
from
Last run: about 2 months ago
38
1KB
198s