DATE | TYPE | N_TXNS | N_WALLET | AVUSD_AMOUNT | |
|---|---|---|---|---|---|
1 | 2024-11-15 00:00:00.000 | Mint | 1 | 1 | 99.85 |
2 | 2025-01-05 00:00:00.000 | Mint | 2 | 1 | 54559.002504 |
3 | 2025-03-09 00:00:00.000 | Mint | 2 | 1 | 18279.928642 |
4 | 2025-02-19 00:00:00.000 | Mint | 3 | 1 | 191569.213052 |
5 | 2025-01-17 00:00:00.000 | Mint | 6 | 1 | 47230.560027 |
6 | 2025-02-25 00:00:00.000 | Redeem | 3 | 1 | 39.657729 |
7 | 2025-01-25 00:00:00.000 | Mint | 11 | 1 | 12644.10277 |
8 | 2025-02-21 00:00:00.000 | Redeem | 1 | 1 | 13.48 |
9 | 2025-02-22 00:00:00.000 | Mint | 13 | 1 | 156040.068743 |
10 | 2025-01-21 00:00:00.000 | Mint | 3 | 1 | 896.450787 |
11 | 2025-02-26 00:00:00.000 | Mint | 7 | 1 | 1998009.99 |
12 | 2025-01-03 00:00:00.000 | Mint | 2 | 1 | 701 |
13 | 2025-02-01 00:00:00.000 | Mint | 9 | 1 | 11961.105992 |
14 | 2025-01-22 00:00:00.000 | Mint | 3 | 1 | 1049.421608 |
15 | 2025-02-08 00:00:00.000 | Redeem | 1 | 1 | 20.137275 |
16 | 2025-01-07 00:00:00.000 | Mint | 14 | 1 | 1842457.91621 |
17 | 2025-02-12 00:00:00.000 | Redeem | 4 | 1 | 3397.924461 |
18 | 2024-12-11 00:00:00.000 | Mint | 12 | 1 | 1001099.8 |
19 | 2025-02-10 00:00:00.000 | Redeem | 1 | 1 | 12 |
20 | 2025-01-08 00:00:00.000 | Mint | 8 | 1 | 2013915.30287 |
BlockTrackermint avUSD
Updated 4 days ago
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 avUSD_data as (
select
'Mint' as type,
block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
lower('0x' || substr(topics[1]::string, 27, 40) :: string) as owner,
REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,
lower('0x' || substr(segmented_data[0]::string, 25, 40) :: string) as collateral_asset,
livequery.utils.udf_hex_to_int(segmented_data[1]::string) :: int as collateral_amount,
livequery.utils.udf_hex_to_int(segmented_data[2]::string) :: int as avUSD_amount
from avalanche.core.fact_event_logs
where topics[0] = '0xf114ca9eb82947af39f957fa726280fd3d5d81c3d7635a4aeb5c302962856eba'
and contract_address = '0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51'
and block_timestamp::date >= '2024-11-15'
and TX_STATUS = 'SUCCESS'
union all
select
'Redeem' as type,
block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
lower('0x' || substr(topics[1]::string, 27, 40) :: string) as owner,
REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,
lower('0x' || substr(segmented_data[0]::string, 25, 40) :: string) as collateral_asset,
livequery.utils.udf_hex_to_int(segmented_data[1]::string) :: int as collateral_amount,
livequery.utils.udf_hex_to_int(segmented_data[2]::string) :: int as avUSD_amount
from avalanche.core.fact_event_logs
where topics[0] = '0x18fd144d7dbcbaa6f00fd47a84adc7dc3cc64a326ffa2dc7691a25e3837dba03'
and contract_address = '0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51'
and block_timestamp::date >= '2024-11-15'
and TX_STATUS = 'SUCCESS'
)
, final as (
Last run: 4 days ago
...
101
5KB
9s