CREATION_TIME | TX_HASH | CREATOR | TOKEN_ADDRESS | launched? | |
|---|---|---|---|---|---|
1 | 2025-03-22 13:43:11.000 | 0x49e7867c5c7035053facaf4ba5564bce5e9751f83056bc493555f3c790551722 | 0xf68cca2acb3c59371c28db60c6cec55119d03c34 | 0xba69d858bd38c056afb725eba89bfcf830557463 | |
2 | 2025-03-23 09:40:38.000 | 0x0065d9ba56dda3bd59e605e79cc871b1f93ecba8e6ad1dc41685806c3e0e2835 | 0x9dc4b6fb385743a8e610d74ee9d481af4c5daa52 | 0x86e32582bda7ad6abb15d3463ca26eecd64df662 | |
3 | 2025-01-04 11:34:20.000 | 0xa0b77d025a7fa1d524c3d5c5c719701f323dac6239fa190d786574c289dc2d42 | 0xd50097aab15b8874ae1072898ca16de1e3b7a6f6 | 0x2de7530237f3ebe49144ecd8a469ea88afa4cb03 | |
4 | 2025-02-16 17:01:32.000 | 0xaab542017f4716f079e557036cca5ab2fb4af2cb22f682eae3d33a55aa339d4d | 0x5459108f3de3a30e2aa159f15d457358797aa5e9 | 0xcc3966df216e5d13b97448ecda13e6a1bddd95fc | |
5 | 2025-02-16 16:36:19.000 | 0x80b9f9b004f106a6b800b7b4f10941b50a39963dd04027455258ff616ee91d5d | 0x2957c2968ebcb91f5683768a9bdc468d08c2a2c2 | 0x863381a39cb39b5294f4adb4f74c3e40608dbc63 | |
6 | 2025-02-16 16:47:53.000 | 0x29f171e91d0696be128f614829c8ad0818af6f568bfdfefbf2b0d1963de689e0 | 0xa0d863f0ab5498678040675b879b0911ba3c595e | 0xee5502bed8f40e7e272892c393df23d9fad238eb | |
7 | 2025-03-11 18:14:18.000 | 0x6660ad8cb7eff38540bae10656c6814cd2e50c1bc1d4d0be869c7ab7f77cc33b | 0x9debadcaae4820092c8ff7dc741c9ec7d9e95027 | 0x40a6ee5f11ae7ed2cf02216f6fd4993051494ff5 | |
8 | 2025-03-28 11:57:16.000 | 0x545c2b9c2b724907e1a874791a0ce3365fbcc3403d85bf3f057e50e6a0be954c | 0x095e12ad1786a47d70bbea6730dddef3c52a1384 | 0x1e03237a9cad2ac6f84c66f8c83279bb5f2d1966 | |
9 | 2025-03-02 12:06:46.000 | 0x7729fb9ea4b004baaa38a171338dbb6852d461a359e7b2474ee7d2d6c8c88bd2 | 0x6259d7bc56b814474bfc7b083a5bdb19ca1acf4b | 0x5bf676778c954241c6db18e32ad4b6ad204ef644 | |
10 | 2025-03-14 19:22:30.000 | 0x83342a8a128195d242a6ace7e55299f8298721e0021682c7537287ae965cd1fe | 0xc97ed6b8ccd5dcae5816dc1347ac2ca414fd31ac | 0xae00a39dff2226a6e5598f1c892ce9ed966de9be | |
11 | 2025-03-20 10:23:36.000 | 0x482759dda0a5d75dc1cf074f7d6dc4ed5401006510e7046915b6f980fa57730d | 0x3e46de6fde4565e999fba1eb72e027e2894823b8 | 0x67e670c245eafae3b9c09f61b9186988806d7a63 | |
12 | 2025-02-05 09:09:16.000 | 0x24a20bccc580a874ac09c4b4908ce5eb8dca0388af14f194e71ec9e7f9f5cdf6 | 0x6f1c53ecfdad9641dfa4eab8eb317dc005cd4cf1 | 0x485e1936b6b96ba55f68c4bfb0e6cf17d101f20b | |
13 | 2025-02-10 23:16:20.000 | 0xd492bbab5d6df6b4c9bec35c56039c912265cfd2f709b2f001d54cfdb86ca404 | 0x09b76d2645eb68c03693a5a013c45967f9c7dcb5 | 0xcd42733855dc940694bca79400ccea7ad5e0557d | |
14 | 2025-02-23 20:28:07.000 | 0x92e47b0b43ab51be821e92d330136cf6af0fb7592f4f1b880fffabcc21c10a5b | 0x242646d6d3ac60b242a06e2a006aeeafa60bbd30 | 0xf20578ca1c5f6d43a50d13bb2bf32faafe34fbc4 | |
15 | 2025-02-16 08:16:10.000 | 0x8c67d27cd419d76fb89f5e7b8dc236b9f3552536920a2b94b43295524be97ecf | 0x89bc72e58ce47ec5f8f9339f65925b0550d1d36a | 0x3b18ac63a392914a6ae337af2a44759b909602e8 | |
16 | 2025-02-16 08:57:27.000 | 0x9fe92da1fd8339681b254143666e6059a9df731c8ef5632d8ed1afc1876aef57 | 0xf89e83472e197e9ac72593fb12dc8a1e7c9c0c5d | 0xbc635edde571ffb00a946e0d1f1c377115442cc8 | |
17 | 2025-03-08 23:05:03.000 | 0xc63ab4b789f4a4f35564cbfb023d7297eed29db8a56f40e99242d1f7071f68e7 | 0xb24a71246eacde716ea5ea32f5a056933b7d309c | 0x66ea6e5b4038f02bfb8b471e6373c65d8324534d | |
18 | 2025-03-16 09:26:57.000 | 0x97bcb245bd767215289547ff549d4d32fe2689f923d6368a5ad005d72f8e6e71 | 0x585a003aa0b446c0f9bad7b3b0bac5a809988588 | 0x01e505044dd7e21d7ac27b808fd8920cc6257cec | |
19 | 2025-04-03 04:57:09.000 | 0x60d66fb75e38cefb56270017636456f3d175fab3be078b59c32d446f2a3e34f3 | 0x1e567b7683dd09f976da27c67d5853bb522a53de | 0x7882a4eac440630ec2dea16fa9c246947395086c | |
20 | 2025-02-11 03:04:48.000 | 0x733ea966be1457ebe0c9dfef717431e692b8dfd627f960895095a0eb58cf1242 | 0xd1d23a2fcb3d5c20fb90b0a5b5b481aed0333e89 | 0xee5d94261218c5bd45f30d7d7e91bbb88111f9d5 |
hrst79tokens list
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
›
⌄
-- forked from launched @ https://flipsidecrypto.xyz/studio/queries/e4b7546a-c76f-45f5-9a2b-52967f50d064
with all_tokens as (
select
a.block_timestamp,
a.tx_hash,
b.from_Address,
concat('0x', SUBSTRING(topics [1] :: string, 27, 64)) AS token_address
from
ink.core.fact_event_logs a join ink.core.fact_transactions b on a.tx_hash = b.tx_hash
where
a.ORIGIN_FUNCTION_SIGNATURE in ('0x6e492cdc', '0xa07849e6')
and a.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
block_timestamp as creation_time ,
tx_hash,
from_address as creator,
token_address,
case when token_address in (SELECT * from launched_tokens ) then '☑️'
Last run: 19 days ago
...
10384
2MB
5s