CHAIN | DATE | TOKEN_TYPE | SYMBOL | TOKEN_CONTRACT | SUPPLY_TOKENS | |
|---|---|---|---|---|---|---|
1 | aleo | 2024-09-04 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
2 | aleo | 2024-09-05 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
3 | aleo | 2024-09-06 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
4 | aleo | 2024-09-07 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
5 | aleo | 2024-09-08 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
6 | aleo | 2024-09-09 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
7 | aleo | 2024-09-10 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
8 | aleo | 2024-09-11 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
9 | aleo | 2024-09-12 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | |
10 | aleo | 2024-09-13 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 0.5 |
11 | aleo | 2024-09-14 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 0.5 |
12 | aleo | 2024-09-15 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 0.5 |
13 | aleo | 2024-09-16 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 7.5 |
14 | aleo | 2024-09-17 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 7.5 |
15 | aleo | 2024-09-18 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 16.5 |
16 | aleo | 2024-09-19 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 16.5 |
17 | aleo | 2024-09-20 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 16.5 |
18 | aleo | 2024-09-21 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 47.09 |
19 | aleo | 2024-09-22 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 47.09 |
20 | aleo | 2024-09-23 00:00:00.000 | stablecoin | vUSDC | 6088188135219746443092391282916151282477828391085949070550825603498725268775field | 62.09 |
AzinTokens supply
Updated 2025-05-14
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: 19 days ago
...
1012
132KB
8s