DATE | ASSET | SUPPLY | |
|---|---|---|---|
1 | 2025-01-18 00:00:00.000 | USDC | 6637954.2 |
2 | 2025-01-17 00:00:00.000 | USDT | 110688.041 |
3 | 2025-01-17 00:00:00.000 | USDC | 6639278.47 |
4 | 2025-01-16 00:00:00.000 | USDT | 110688.041 |
5 | 2025-01-16 00:00:00.000 | zUSDC | 6180980.665 |
6 | 2025-01-15 00:00:00.000 | whUSDC | 9284.78 |
7 | 2025-01-15 00:00:00.000 | zUSDC | 6000137.755 |
8 | 2025-01-15 00:00:00.000 | zUSDT | 3774417.02 |
9 | 2025-01-14 00:00:00.000 | whUSDC | 9212.82 |
10 | 2025-01-14 00:00:00.000 | zUSDC | 6045133.64 |
11 | 2025-01-14 00:00:00.000 | zUSDT | 3791395.82 |
12 | 2025-01-13 00:00:00.000 | zUSDT | 3675320.16 |
13 | 2025-01-13 00:00:00.000 | zUSDC | 5518352.8 |
14 | 2025-01-26 00:00:00.000 | zUSDT | 0 |
15 | 2024-08-13 00:00:00.000 | whUSDC | 1080957.06 |
16 | 2024-10-24 00:00:00.000 | zUSDC | 4533995.87 |
17 | 2024-08-25 00:00:00.000 | zUSDC | 3443277.285 |
18 | 2025-01-28 00:00:00.000 | zUSDC | 10199027.99 |
19 | 2024-11-09 00:00:00.000 | zUSDC | 17368162.42 |
20 | 2024-11-07 00:00:00.000 | MOD | 5124333.25 |
tkvresearchspare-violet
Updated 2025-01-31
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 Total Over Time @ https://flipsidecrypto.xyz/studio/queries/178e9e54-d60d-4e65-9b9c-00827268c24c
WITH RECURSIVE rec_cte AS (
-- start date
SELECT '2024-10-16'::DATE as dt
UNION ALL
SELECT DATEADD('day',1,dt) as dt
FROM rec_cte
-- end date (inclusive)
WHERE dt <= current_date()
),
ariesEventTb AS (
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
split(split(EVENT_TYPE, '<')[1],'>')[0]::string as TOKEN_CONTRACT,
CASE
WHEN TOKEN_CONTRACT = '0xdd89c0e695df0692205912fb69fc290418bed0dbe6e4573d744a6d5e6bab6c13::coin::T' THEN 'SOL'
WHEN TOKEN_CONTRACT = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WBTC' THEN 'zWBTC'
WHEN TOKEN_CONTRACT = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 'USDY'
WHEN TOKEN_CONTRACT = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 'tAPT'
WHEN TOKEN_CONTRACT = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'zUSDC'
WHEN TOKEN_CONTRACT = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 'WETH'
WHEN TOKEN_CONTRACT = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt' THEN 'amAPT'
WHEN TOKEN_CONTRACT = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'zUSDT'
WHEN TOKEN_CONTRACT = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 'zWETH'
WHEN TOKEN_CONTRACT = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 'CAKE'
WHEN TOKEN_CONTRACT = '0x1::aptos_coin::AptosCoin' THEN 'APT'
WHEN TOKEN_CONTRACT = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'USDC'
WHEN TOKEN_CONTRACT = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::stapt_token::StakedApt' THEN 'stAPT'
WHEN TOKEN_CONTRACT = '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3::fa_to_coin_wrapper::WrappedUSDT' THEN 'USDT'
END AS asset,
EVENT_DATA:amount AS amount,
EVENT_DATA:total_cash_available AS total_cash_available,
EVENT_DATA:total_borrowed_decimal AS total_borrowed_decimal,
Last run: 2 months ago
...
6079
276KB
275s