Date | SUM_AMOUNT | $USDC supply | |
---|---|---|---|
1 | 2024-11-15 00:00:00.000 | 201802000 | 672794727.854435 |
2 | 2024-10-26 00:00:00.000 | 18692745.581501 | 470992727.854435 |
3 | 2024-10-06 00:00:00.000 | 6496817.500513 | 452299982.272934 |
4 | 2024-09-28 00:00:00.000 | 135748355.845244 | 445803164.772421 |
5 | 2024-08-08 00:00:00.000 | 2544936.166049 | 310054808.927177 |
6 | 2024-08-02 00:00:00.000 | 289214992.242896 | 307509872.761128 |
7 | 2024-07-24 00:00:00.000 | 18294349.843352 | 18294880.518232 |
8 | 2024-02-07 00:00:00.000 | 530.67488 | 530.67488 |
crypto_gostAptos Ondo USDY Multisig Mint-Burn copy
Updated 2024-11-29
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
›
⌄
-- forked from whaen / Aptos Ondo USDY Multisig Mint-Burn @ https://flipsidecrypto.xyz/whaen/q/hz1FyeRKDWZX/aptos-ondo-usdy-multisig-mint-burn
with
-- SWAPS START --
usdy_swaps as (
-- swaps on animeswap, auxexchange, batswap, cellana, cetus, hippo, liquidswap, pancake, sushi, thala, and tsunami.
select
block_timestamp,
tx_hash,
platform,
swapper as user_address,
symbol_in::string as symbol_in,
symbol_out::string as symbol_out,
amount_in_unadj,
amount_in,
amount_in_usd,
amount_out_unadj,
amount_out,
amount_out_usd
from aptos.defi.ez_dex_swaps
where token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'
or token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'
),
usdy_related_raw_tx_xswaps as (
select distinct tx_hash
from aptos.core.fact_transfers
where token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'
and tx_hash not in (select distinct tx_hash from aptos.defi.ez_dex_swaps where token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' or token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC')
and success = 'true'
order by tx_hash
),
aggr_swap as (
-- kana router
select
ts.*,
amount_out_unadj/pow(10,coalesce(pr.decimals, 6)) as amount_out,
Last run: 3 months ago
8
469B
88s