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)