Aave V2
Examples
Note
These examples are crafted as a Jupyter notebook. You can download the original notebook file here.
Also note that inside Jupyter notebooks, await
can be used freely outside of asyncio.run()
.
In [1]:
from ctc.protocols import aave_v2_utils
In [2]:
asset = '0x956f47f50a910163d8bf957cf5846d573e7f87ca'
pool_token = '0x683923db55fead99a79fa01a27eec3cb19679cc3'
Get pool token underlying asset¶
In [3]:
await aave_v2_utils.async_get_underlying_asset(pool_token=pool_token)
Out[3]:
'0x956f47f50a910163d8bf957cf5846d573e7f87ca'
Get interest rates¶
In [4]:
await aave_v2_utils.async_get_interest_rates(token=asset)
Out[4]:
{'supply_apr': 0.0, 'supply_apy': 0.0, 'borrow_apr': 0.47432923820762063, 'borrow_apy': 0.606935956588601}
Get interest rates by block¶
In [5]:
blocks = [14000000, 14100000, 14200000]
await aave_v2_utils.async_get_interest_rates_by_block(asset, blocks=blocks)
Out[5]:
{'supply_apr': [0.0809241879131384, 0.13196183128104946, 0.08795041456240905], 'supply_apy': [0.08428868956961622, 0.14106476861269135, 0.09193397621885202], 'borrow_apr': [0.12384794470919762, 0.19833914841251457, 0.13425875687321126], 'borrow_apy': [0.13184375504990453, 0.21937587033094874, 0.14368871521280768]}
Get reserve data information¶
In [6]:
await aave_v2_utils.async_get_reserve_data(asset)
Out[6]:
{'configuration': (184467950252545255676260,), 'liquidity_index': 1053273089721002447096876573, 'variable_borrow_index': 1083371393391169705567951230, 'current_liquidity_rate': 0, 'current_variable_borrow_rate': 474329238207620609074155595, 'current_stable_borrow_rate': 454329238207620609074155595, 'last_update_timestamp': 1664017295, 'atoken_address': '0x683923db55fead99a79fa01a27eec3cb19679cc3', 'stable_debt_token_address': '0xd89cf9e8a858f8b4b31faf793505e112d6c17449', 'variable_debt_token_address': '0xc2e10006accab7b45d9184fcf5b7ec7763f5baae', 'interest_rate_strategy_address': '0xf0ba2a8c12a2354c075b363765eae825619bd490', 'id': 30}
Get reserve data information by block¶
In [7]:
blocks = [14000000, 14100000, 14200000]
await aave_v2_utils.async_get_reserve_data_by_block(asset, blocks=blocks)
Out[7]:
{'configuration': [(36893853501938873663488,), (36893853501938873663488,), (36893853547680668586888,)], 'liquidity_index': [1027093192185602308632850363, 1030957841716431311927096183, 1034590546311825056817675224], 'variable_borrow_index': [1040639071906878639807530852, 1046590959580756373154811807, 1052188787049286042548443674], 'current_liquidity_rate': [80924187913138410537306359, 131961831281049474271358767, 87950414562409055280114949], 'current_variable_borrow_rate': [123847944709197624729861055, 198339148412514578291420400, 134258756873211249157579590], 'current_stable_borrow_rate': [103847944709197624729861055, 178339148412514578291420400, 114258756873211249157579590], 'last_update_timestamp': [1642006170, 1643431118, 1644749395], 'atoken_address': ['0x683923db55fead99a79fa01a27eec3cb19679cc3', '0x683923db55fead99a79fa01a27eec3cb19679cc3', '0x683923db55fead99a79fa01a27eec3cb19679cc3'], 'stable_debt_token_address': ['0xd89cf9e8a858f8b4b31faf793505e112d6c17449', '0xd89cf9e8a858f8b4b31faf793505e112d6c17449', '0xd89cf9e8a858f8b4b31faf793505e112d6c17449'], 'variable_debt_token_address': ['0xc2e10006accab7b45d9184fcf5b7ec7763f5baae', '0xc2e10006accab7b45d9184fcf5b7ec7763f5baae', '0xc2e10006accab7b45d9184fcf5b7ec7763f5baae'], 'interest_rate_strategy_address': ['0xf0ba2a8c12a2354c075b363765eae825619bd490', '0xf0ba2a8c12a2354c075b363765eae825619bd490', '0xf0ba2a8c12a2354c075b363765eae825619bd490'], 'id': [30, 30, 30]}
Get all deposits¶
In [8]:
deposits = await aave_v2_utils.async_get_deposits()
deposits
Out[8]:
address | block_hash | transaction_hash | contract_address | event_name | event_hash | arg__reserve | arg__onBehalfOf | arg__referral | arg__user | arg__amount | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
block_number | transaction_index | log_index | |||||||||||
11363052 | 76 | 126 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x8a1a55c5053a5deab69466e3ee92a2b147dddf62367f... | 0x3081a4ac6666e748fee8bc216b86c47c91c43dfd1172... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xc4a936b003bc223df757b35ee52f6da66b062935 | 0 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 100000000000000 |
11363059 | 168 | 243 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x48787c4adbf0e6cc34395003bbc0b23de154d85e490a... | 0x6d18b83407c28345c8bb09f458b36cb4bbe0146e229d... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xc4a936b003bc223df757b35ee52f6da66b062935 | 0 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 100000000000000 |
11367463 | 173 | 199 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x0432ed7d74339aa4e31420516af5e8b73125b6802093... | 0x7f10004def891a9965e972e57ecb8b93c517b5d4d7e4... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9 | 0xdad4c11e8cc6a5c37808d3b31b3b284809f702d1 | 0 | 0xdad4c11e8cc6a5c37808d3b31b3b284809f702d1 | 100000000000000000 |
11367499 | 87 | 176 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x2037f971a8d3530b4f7aab4fdfefb99f98d535784afb... | 0xdd1d259637c499ff61b0d142e7bb6639f3552b2dab37... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xdad4c11e8cc6a5c37808d3b31b3b284809f702d1 | 0 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 1000000000000000 |
11367752 | 130 | 212 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0xe1ce4b8c2251d3f7a699f4eafe44cd06ee39bc2282f9... | 0x870bf17a6373c10290d626134936230ada5f8ab0eee2... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xbd723fc4f1d737dcfc48a07fe7336766d34cad5f | 0 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 1000000000000000 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
15613442 | 219 | 556 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0xf1fc6712ffebf2a447c88bba3c9e59535cab89071e82... | 0x2171e1c77ce1784b7011d6af7fd1cb8df09165eb6a29... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0x44bf2a060fee65ae23fd48f996dd742cd1c99cde | 0 | 0xeffc18fc3b7eb8e676dac549e0c693ad50d1ce31 | 1300000000000000 |
15613446 | 53 | 210 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x11a8cb74b434c55684c37f6a2bc64ed5dd2eea1ae0d6... | 0x58816da03db45ea9479886e360c17e78fa7d66cbe8eb... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f | 0x0b5a6a15b975fd35f0b301748c8dabd35b50d8c5 | 0 | 0x0b5a6a15b975fd35f0b301748c8dabd35b50d8c5 | 27058755877323540610345 |
15613449 | 158 | 356 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x596fd05e6569e0c3de6a396144cad0f07966578e423e... | 0x56d420bcb1dfaad69e4dffdf50c3355a51d7226c1207... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0x514910771af9ca656af840dff83e8264ecf986ca | 0x72cf204877ed7fc3c31b87052fb4975b2efda940 | 3228 | 0x72cf204877ed7fc3c31b87052fb4975b2efda940 | 110605874591292246906 |
15613454 | 153 | 414 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x85dac8e6245651bf1d58c56609b94f89e18e97e5b384... | 0x5f258542d5936014d593fde265308f78c4758bd926e8... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0x9ef1e5eea13131065d64e53a0595ea487746324a | 0 | 0xeffc18fc3b7eb8e676dac549e0c693ad50d1ce31 | 10000000000000000 |
15613477 | 131 | 239 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0xa2ac32e37c661b1f74edf8c3174f2255ea7f50709092... | 0x65c4a31c653ac2fc3c236d9634061aaa8863a697a39c... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Deposit | 0xde6857219544bb5b7746f48ed30be6386fefc61b2f86... | 0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f | 0xc203f88cc0fcff70cbca89a28a5d1233c2cdbfe5 | 187 | 0xc203f88cc0fcff70cbca89a28a5d1233c2cdbfe5 | 24000000000000000000 |
352005 rows × 11 columns
Get all withdrawals¶
In [9]:
withdrawals = await aave_v2_utils.async_get_withdrawals()
withdrawals
Out[9]:
address | block_hash | transaction_hash | contract_address | event_name | event_hash | arg__reserve | arg__user | arg__to | arg__amount | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|
block_number | transaction_index | log_index | ||||||||||
11367541 | 136 | 174 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0xcb87fe175f68c53964d24fff4c816224b520096ae697... | 0x0c66ade8a26d0bedbc967005a75a00028cebf222ec45... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 1000000000000000 |
11367770 | 247 | 230 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x83dfe27b0b320c18d1b6e4adf476f93f107c8bcc2d68... | 0x25f636e7b49a599c765bcdac00853265ac76a5921953... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 0xdcd33426ba191383f1c9b431a342498fdac73488 | 1000000000000000 |
11367843 | 117 | 126 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x3e856a21671d901986c62b5c901ba34373d87919386e... | 0x17869b1999e221cb74ab4fc8c9f7087097e6e27b50dd... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xbd723fc4f1d737dcfc48a07fe7336766d34cad5f | 0xbd723fc4f1d737dcfc48a07fe7336766d34cad5f | 1000000000000000000 |
11373144 | 23 | 22 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x28f08c556d03b17932612a6497f7b643fe2980ca7a25... | 0xae1083a26ffc90a681fc856b9bb087e37a16c037227a... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2 | 0xbd723fc4f1d737dcfc48a07fe7336766d34cad5f | 0xbd723fc4f1d737dcfc48a07fe7336766d34cad5f | 1000000000000000 |
11373481 | 159 | 279 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x0452e1d1eabafdd24668694d1bd4cb09b6c399fb04b9... | 0xd12cbbad05aa4b7dbcf62ee862bf07c73ddfca58f035... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0x514910771af9ca656af840dff83e8264ecf986ca | 0xff06ed0e20638f1299832b4141bc3adcc82f6207 | 0xff06ed0e20638f1299832b4141bc3adcc82f6207 | 73858303958775353 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
15613399 | 192 | 391 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x829110668a9d166b451a915c015db8f4014f293ab032... | 0xf8aecf2c24286caeb574121135e3fb52ac32d8df0879... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0x514910771af9ca656af840dff83e8264ecf986ca | 0x68b48bca2f5955df6af945bb71814edda5243712 | 0x68b48bca2f5955df6af945bb71814edda5243712 | 369688503364124390545 |
223 | 465 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x829110668a9d166b451a915c015db8f4014f293ab032... | 0xfe53d46dd1564ddc464bb303a0e248d15a9827c69ffb... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0xd533a949740bb3306d119cc777fa900ba034cd52 | 0x166b1948124307729a7ce48c3c336a5910598435 | 0x166b1948124307729a7ce48c3c336a5910598435 | 16816268189066430697221 | |
15613408 | 58 | 200 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x167a50c67364fa82ea4f95366460309d7eddbaee1675... | 0x6988276e3b5b640c3445c15cbd96b4f4c27633b9c066... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 0xa270f988e2dac7be0b1c86ae010e3f823a5a5e92 | 0xa270f988e2dac7be0b1c86ae010e3f823a5a5e92 | 20000000000000000000 |
15613449 | 158 | 336 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x596fd05e6569e0c3de6a396144cad0f07966578e423e... | 0x56d420bcb1dfaad69e4dffdf50c3355a51d7226c1207... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x72cf204877ed7fc3c31b87052fb4975b2efda940 | 0x72cf204877ed7fc3c31b87052fb4975b2efda940 | 865000000 |
15613466 | 576 | 311 | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | 0x6a9c65ba299149b5f2fe71f31b1dcc921228cc599355... | 0x5d2a2244822f396ac9b5dda70bb1d3a08dd6409d7f90... | 0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 | Withdraw | 0x3115d1449a7b732c986cba18244e897a450f61e1bb8d... | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x9ef1e5eea13131065d64e53a0595ea487746324a | 0x9ef1e5eea13131065d64e53a0595ea487746324a | 100000000 |
252266 rows × 10 columns
Reference
- async ctc.protocols.aave_v2_utils.async_get_deposits(*, start_block=None, end_block=None, start_time=None, end_time=None, include_timestamps=False, provider=None)
- async ctc.protocols.aave_v2_utils.async_get_interest_rates(*, token=None, block=None, reserve_data=None)
- async ctc.protocols.aave_v2_utils.async_get_interest_rates_by_block(token, blocks, *, reserve_data_by_block=None)
- async ctc.protocols.aave_v2_utils.async_get_reserve_data(asset, block=None, *, provider=None)
- async ctc.protocols.aave_v2_utils.async_get_reserve_data_by_block(asset, blocks, *, provider=None)
- async ctc.protocols.aave_v2_utils.async_get_underlying_asset(pool_token, provider=None)
- async ctc.protocols.aave_v2_utils.async_get_withdrawals(*, start_block=None, end_block=None, start_time=None, end_time=None, include_timestamps=False, provider=None)