BLOCK_TIMESTAMP | TX_ID | FUNCTION | NAME | SYMBOL | TOKEN_CONTRACT | SIGNER | AMOUNT_RAW | AMOUNT | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-01-17 20:53:52.000 | at1puqevy3jn2slryd3upg80w4gc25f4cyyu3jupnyw3606g0tl7uqqd6xrxm | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo13jwx3ae8epmyupmywcplqxry8qh9sejt0wff5mrpdmz7hhhklvxs9syqx5 | 9359369 | 9.359369 |
2 | 2025-01-17 20:54:56.000 | at1dq0zqm2fnegncesyj08zh0qltp8kgc2c0hakk4dxkaeupyq02uxqkrrdja | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1uyr6fcwhnk92r4prvqv0aw5z5efgd9vs9u6m42hz7nr9usqqvgrqpxfct6 | 92 | 0.000092 |
3 | 2025-01-17 21:33:00.000 | at1ypv4vclj28mtxm54tdjkjdqgwpddx9wexpv90vmrzsfh2p4m4gpsrvnzr3 | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1n550myruuccrx88yhxvz0hjh2q8cefjk4sucvp9untnqscrucgys0kzd5n | 92566 | 0.092566 |
4 | 2025-01-08 02:23:38.000 | at1rkf0vl0lwv6ct32qkfcusr937htca794zku5xcvh5ke47wmhguys9ukpwa | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1dv04t3rtfyttrv9zpjl3gldpmgngzjlnyrgjj8sv86mevrg3qvgsmx04ls | 9383 | 0.009383 |
5 | 2025-01-08 02:12:18.000 | at1efhk2azlxpuxxgccu4uuhtz8fasdtlm8u3hgyn57ezjh9cg5qsrqzfrhey | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1ag7q8yr4mjpwacul9855susemzr5m2ec4hxptcn26hczdpqcl5pscwp6g9 | 92 | 0.000092 |
6 | 2025-01-08 02:58:26.000 | at1gq0f6wmqfr0nzfzv0jhpsvrq3rz7j37gs774pa56ck82asx8vsfq98hewl | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1jwvkknglcd52zgg75drh3ysz82wvsvhenmwxxah2ug0q98zkhu8sxxma7y | 92 | 0.000092 |
7 | 2025-01-08 02:50:32.000 | at1svfut4nvps03hd0hmywvwpggnxhx3eg7ag7pejmuuru29v6qlvxsmkjnm8 | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1ctxkv2dj35jwgsngzds2kfydhwthlsdwkqkudhhrfuh7sxnkec9qkvf93j | 938349 | 0.938349 |
8 | 2025-01-08 03:14:31.000 | at1k5whczp4hv2q8enev5lfycwt6fvaly39qpy23c92aj7q95u5hs8q95zk6w | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1g82v358ttnskgjw7r8q457mupyeprngadd8fhx8482x9h7sg9cqq5e2u9h | 937 | 0.000937 |
9 | 2025-01-08 02:28:45.000 | at1ahz6qnhkzcdf4h0xjn0cazm3w752upe4f3f6yvz2jkdd5407xcrs8rfa6v | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo14g7avf8aq4j22l70fp8e7zcfklgqqgel8y9yqaze5t5lvrfu9cgsnfzrwx | 92 | 0.000092 |
10 | 2025-01-08 02:21:32.000 | at1p9dmqjn87e2uzmdkcfzxuykuxqrwhu7q25sczc3yvv7pxvs3pvzqysep8r | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1yl68dyacv7flqvaau66c5cyd9vqgp5znyhtll5gjzp778q86acgqdya7ps | 938356 | 0.938356 |
11 | 2025-01-08 02:53:03.000 | at12p7e75qh047tda7gq38u5jp0aa57dcwyrv4fkyl5709880uzyspq6xrr3h | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1s0rlmu9y0ung74hevzmaffddjpsz7t8dhnddgzznlt5h0vmd5q8sd6vf88 | 9383 | 0.009383 |
12 | 2025-01-08 03:17:33.000 | at1hqy67ts9v6g5uful6ltznxvafn27lv2gfzfak53gfvvergw995rq3n7x4r | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo18r5awu52js0xfl2aym3yd5yxd4xykdhsy7d0rhld2gjjxhv0dg9s72xra3 | 938345 | 0.938345 |
13 | 2025-01-08 02:37:03.000 | at1k6thx3c0uyrxxxk3px2gaa0zal89jsj0eujju7zxdpjyf6zf3gpq70x82s | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1fflz24a5c2kvjvp29kaqt786hzzc283sdwgmp6srs6jdr86f6upqu4c6ku | 748535 | 0.748535 |
14 | 2025-01-28 02:30:11.000 | at1ek0z7g29vmj32h4kd8a0snr0n2f7h9slgg90jkly84x57n2cav9q9lw5mz | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo10c8vut0mq4rf0es9dg5dwwlhqkf6f3d45wj7u8539spjpk2ac59s24xke7 | 92 | 0.000092 |
15 | 2025-01-28 02:13:58.000 | at1gpazv0wuw3j5geuwaneuf664ramru3kcqf69ycn34tq9wcsvzcxqacjz2z | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1urgtgtu0t052xef6kv98lkwdnhdsjyyz3he05p5c8mjrhyrgfvxssvck3z | 905370 | 0.90537 |
16 | 2025-01-28 02:45:05.000 | at1v0c8eplsc5ehd66mqhjxnr7dna2kpwx7ttyg05ytr80xpdnynspqulf76s | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo106meayqgcqzt5e5frr3lwv6z7gsat3tpjpc23vzxj64atwp935rqsqudre | 23645384 | 23.645384 |
17 | 2025-01-28 01:47:15.000 | at19sc73te4eppkc8r9xmtlxsmevwe0r99kpuupjmek4xgvss238czqsky8uk | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo17q6gd7tpeckx662zg6ww7u77tnahstr2hpn8vqchnhdk67gq4vrqk3qhwc | 933436 | 0.933436 |
18 | 2025-01-28 01:57:52.000 | at1tmm4eerzrjm8dw0uynz0f9ux4y095c2z3nn24yx3h8e8t9n8rcpq2dwq2y | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1fahm0ja48yhvu83z7wazelekmdfjwx7z4emffkttlp8ekqyrrcysjhh4ac | 16100743 | 16.100743 |
19 | 2025-01-28 02:51:23.000 | at16qhul2dngy7pl5jy6fkggg7l5wj3txuezdgt3vwd4qzzgckjmqzqj6z3sn | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1jvm9pulcstn6snxwwx230wllegsfe49c6ggcrtw4lqd3ny5y259sjsp0td | 92 | 0.000092 |
20 | 2025-01-28 02:51:44.000 | at132fv09wadxh7aftw5733r36rh4txwhf7ujs3k20ur20h76lqagqs5txl6c | mint_public | Pondo Aleo LST | pALEO | 1751493913335802797273486270793650302076377624243810059080883537084141842600field | aleo1u7vrlu53t5v02ga43mnhpr7j3ds40pu56pfrrmglmtehdkhvkv8q77936p | 8 | 0.000008 |
AzinDecode
Updated 2025-03-12
999
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 T1 AS
(
SELECT
INPUTS[0]['value'] AS Token_ID,
livequery.utils.udf_hex_to_string(substr(livequery.utils.udf_int_to_hex(split(INPUTS[1]['value'], 'u')[0]::string) ,3)) as Name ,
livequery.utils.udf_hex_to_string(substr(livequery.utils.udf_int_to_hex(split(INPUTS[2]['value'], 'u')[0]::string) ,3)) as symbol ,
SPLIT(INPUTS[3]['value'],'u')[0] AS Decimal
-- SPLIT( INPUTS[4]['value'] , 'u')[0] / POW(10 , Decimal) AS Amount
FROM
aleo.core.fact_transitions
WHERE
PROGRAM_ID = 'token_registry.aleo'
AND
FUNCTION = 'register_token'
AND
SUCCEEDED = 'TRUE'),
Decode AS
( (SELECT
BLOCK_TIMESTAMP
, TX_ID
, FUNCTION
, NAME
, SYMBOL
, INPUTS[0]['value'] AS Token_Contract
, INPUTS[1]['value'] AS Signer
, SPLIT(INPUTS[2]['value'] , 'u')[0] AS Amount_raw
, Amount_raw / pow(10,Decimal) AS Amount
FROM
aleo.core.fact_transitions A LEFT JOIN T1 b on a.INPUTS[0]['value'] = b.Token_ID
WHERE
PROGRAM_ID = 'token_registry.aleo'
AND
FUNCTION = 'mint_public'
AND
SUCCEEDED = 'TRUE'
Last run: 3 months ago
100
29KB
466s