COUNT(DISTINCT HOLDER) | |
|---|---|
1 | 8036 |
HessishASC - curr
Updated 9 days ago
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 minting_events as (
select
INSTRUCTION:parsed:info:mint::string as mint_tk,
tx_id,
signers[0]::string as minter_address,
BLOCK_TIMESTAMP
from eclipse.core.fact_events_inner
where INSTRUCTION:parsed:info:mintAuthority = '3x6Gqc2qFTgwq87LEe1wmybPJLFZPiE8QnSXxDkrAC9E'
and INSTRUCTION_PROGRAM_ID in (
'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE',
'5hEa5j38yNJRM9vQA44Q6gXVj4Db8y3mWxkDtQeofKKs'
)
and EVENT_TYPE = 'mintTo'
),
all_transfers as (
select
mint::string as mint,
TX_TO::string as holder,
BLOCK_TIMESTAMP
from eclipse.core.fact_transfers
where mint in (select mint_tk from minting_events)
),
all_ownership_changes as (
select
mint_tk::string as mint,
minter_address::string as holder,
BLOCK_TIMESTAMP
from minting_events
union all
select
mint::string,
holder::string,
Last run: 9 days ago
1
8B
2s