Getstan2024-04-12 01:33 PM
Updated 2024-04-12
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 nft_minted as (
select
distinct
event_data:token as nft_id
from aptos.core.fact_events
where event_type = '0x4::collection::MintEvent'
and account_address in (
'0x89ec88201ecc9e3d1604b09f3c599353357284188d5a71f8953e660a14f17475'
,'0xbdead289e28d12e4819bc17f45d979c0cf2753a28f3cd425322e1caa48e9d159'
,'0x2bed7aeca079697ec1700cc48bee658b2331d80996b05e56dfcb39fae22cbb63'
,'0x778adb39026a14009cf5aa93eb53d81299e40c7a8dbcdbf7b490cbc29749d259'
,'0xfceefe7c83abbe577f606a7fa5b98cfed37d941f38721dede6ca601b61ddc59c'
)
and success = 'TRUE'
)
select
address as active_wallets
from
(
select
distinct event_data:from as address
from aptos.core.fact_events
where event_type = '0x1::object::TransferEvent'
and success = 'TRUE'
and EVENT_DATA:object in
(select nft_id from nft_minted)
union all
select
distinct event_data:to as address
from aptos.core.fact_events
where event_type = '0x1::object::TransferEvent'
and success = 'TRUE'
QueryRunArchived: QueryRun has been archived