LAUNCHED_TOKENS | |
|---|---|
1 | 16 |
hrst79launched
Updated 2025-04-05
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 all_tokens as (
select
concat('0x', SUBSTRING(topics [1] :: string, 27, 64)) AS token_address
from
ink.core.fact_event_logs
where
ORIGIN_FUNCTION_SIGNATURE in ('0x6e492cdc', '0xa07849e6')
and contract_address = '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
),
launched_tokens as (
SELECT
DISTINCT contract_address
from
ink.core.ez_token_transfers
where
contract_address in (
select
token_address
from
all_tokens
)
and origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
and contract_address not in ('0x09d8944cd15ed1d4076248c116ada6331245706e','0x97f9fe646b85bfadcd7f437dfcd38333d599f473')
)
select
count(contract_address) as launched_tokens
from
launched_tokens
--select * from ink.core.ez_token_transfers where contract_address = '0x1b184de5952d11fe3e821fc58e6ef73d545f733e'
--select * from ink.core.ez_decoded_event_logs where tx_hash = '0x09d8944cd15ed1d4076248c116ada6331245706e'
--select * from ink.core.fact_transactions where contract_Address = '0x09d8944cd15ed1d4076248c116ada6331245706e'
--select * from ink.core.fact_event_logs where contract_Address = '0x09d8944cd15ed1d4076248c116ada6331245706e'
--0x97f9fe646b85bfadcd7f437dfcd38333d599f473
--0x09d8944cd15ed1d4076248c116ada6331245706e
Last run: 2 months ago
1
6B
7s