FUNCTION | ASSET_SYMBOL | AMOUNT | |
|---|---|---|---|
1 | repay | stAPT | 1571.20052245 |
2 | repay | USDC | 207648.34874 |
3 | borrow | USDT | 69638.331863 |
4 | borrow | Cake | 453.87188258 |
5 | repay | tAPT | 156.41622783 |
6 | borrow | WETH | 46.94092479 |
7 | repay | APT | 4339.45140881 |
8 | borrow | USDC | 346087.241362 |
9 | borrow | stAPT | 24780.31331544 |
10 | repay | WETH | 46.70589291 |
11 | borrow | APT | 8539.0661972 |
12 | repay | USDT | 36491.990751 |
13 | repay | Cake | 100.51438357 |
14 | borrow | tAPT | 329.35362038 |
freemartianApti
Updated 2024-01-26
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 txs AS (
SELECT
block_timestamp,
tx_hash,
tx_type,
sender,
payload,
split_part(payload:function,'::',1) AS contract_address,
split_part(payload:function,'::',3) AS function,
payload:type_arguments[0] AS asset_address,
tokens.symbol AS asset_symbol,
payload:arguments[0]/pow(10,decimals) AS amount,
decimals
FROM aptos.core.fact_transactions
INNER JOIN aptos.core.dim_tokens tokens ON (token_address = asset_address)
WHERE success
-- AND block_timestamp::date >= current_date - 1
AND contract_address = '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183'
-- AND function IN ('supply','withdraw','borrow','repay')
),
prices AS(
SELECT hour, symbol, AVG(price) AS price
FROM crosschain.price.ez_hourly_token_prices
WHERE symbol IN (SELECT asset_symbol FROM txs)
AND hour::date >= '2023-10-20'
GROUP BY 1,2
)
SELECT
-- block_timestamp,
-- tx_hash,
-- tx_type,
Last run: over 1 year ago
14
431B
24s