ACTIVITY_DATE | ARBITRAGE_DONE | TRY_DONE | PERCENTAGE | BOT_BALANCE | GAS_BALANCE | TOTAL | |
|---|---|---|---|---|---|---|---|
1 | 2025-03-13 | 123 | 393 | 31.29771 | 19816.55752006 | 5.24863609 | 19821.80615615 |
2 | 2025-03-12 | 393 | 1747 | 22.495707 | 19815.72499575 | 5.32704785 | 19821.0520436 |
3 | 2025-03-11 | 942 | 3798 | 24.802528 | 19791.78861129 | 5.09837507 | 19796.88698636 |
4 | 2025-03-10 | 1203 | 4499 | 26.739275 | 19773.0581253 | 5.09599337 | 19778.15411867 |
5 | 2025-03-09 | 1130 | 8938 | 12.642649 | 19707.26633414 | 5.08853615 | 19712.35487029 |
6 | 2025-03-08 | 661 | 4404 | 15.009083 | 19621.15121282 | 5.09990093 | 19626.25111375 |
7 | 2025-03-07 | 2462 | 27161 | 9.064467 | 19612.90148234 | 4.94371961 | 19617.84520195 |
8 | 2025-03-06 | 1040 | 15023 | 6.922718 | 19581.85013875 | 5.08919609 | 19586.93933484 |
9 | 2025-03-05 | 1460 | 11294 | 12.927218 | 19551.14752729 | 5.09213675 | 19556.23966404 |
10 | 2025-03-04 | 1104 | 5956 | 18.53593 | 19405.71301601 | 5.09560067 | 19410.80861668 |
11 | 2025-03-03 | 657 | 3700 | 17.756757 | 19363.55371484 | 5.09966129 | 19368.65337613 |
12 | 2025-03-02 | 600 | 5253 | 11.422045 | 19336.68969213 | 5.04433649 | 19341.73402862 |
13 | 2025-03-01 | 229 | 1243 | 18.42317 | 19309.57044242 | 5.09864731 | 19314.66908973 |
14 | 2025-02-28 | 1275 | 5921 | 21.533525 | 19304.00630607 | 5.17527685 | 19309.18158292 |
15 | 2025-02-27 | 1098 | 4586 | 23.942433 | 17848.70142834 | 6.33685081 | 17855.03827915 |
16 | 2025-02-26 | 812 | 3113 | 26.084163 | 17506.76227416 | 7.50540259 | 17514.26767675 |
17 | 2025-02-25 | 841 | 4858 | 17.311651 | 17484.60661793 | 8.34673225 | 17492.95335018 |
18 | 2025-02-24 | 514 | 2868 | 17.921897 | 17450.06064832 | 9.41166573 | 17459.47231405 |
19 | 2025-02-23 | 393 | 1126 | 34.902309 | 17434.91418096 | 10.05925557 | 17444.97343653 |
20 | 2025-02-22 | 207 | 649 | 31.895223 | 17425.80092458 | 10.25734503 | 17436.05826961 |
lxv0umAptos-bot balance check daily
Updated 1 day 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
›
⌄
-- forked from Aptos-bot balance check @ https://flipsidecrypto.xyz/studio/queries/77b129af-1368-49c3-8d0a-83601290facf
with bot_balance as (
select to_char(block_timestamp, 'yyyy-MM-dd') as activity_date,
MAX(change_data:"coin":"value" / 100000000) as balance,
COUNT(block_timestamp) as arbitrage_done
from aptos.core.fact_changes
where change_type = 'write_resource'
and change_address = '0x31deb490728ae8e1a89675ee4c1877af8e5849c526d2c9a64238c49d8ece08a0'
and change_resource = 'CoinStore<0x1::aptos_coin::AptosCoin>'
group by activity_date
), gas_balance as (
select to_char(block_timestamp, 'yyyy-MM-dd') as activity_date,
MIN(change_data:"coin":"value" / 100000000) as balance,
COUNT(block_timestamp) as try_done
from aptos.core.fact_changes
where change_type = 'write_resource'
and address = '0x31deb490728ae8e1a89675ee4c1877af8e5849c526d2c9a64238c49d8ece08a0'
and change_address = '0x1'
and change_resource = 'CoinStore<0x1::aptos_coin::AptosCoin>'
group by activity_date
)
select bot.activity_date,
arbitrage_done,
try_done,
arbitrage_done * 100 / try_done as percentage,
bot.balance as bot_balance,
gas.balance as gas_balance,
bot.balance + gas.balance as total
from bot_balance bot
LEFT JOIN gas_balance gas ON bot.activity_date = gas.activity_date
order by bot.activity_date desc
Last run: 1 day ago
...
438
31KB
430s