Vertex Aave ARB

Pine AnalyticsVertex Aave ARB

Updated 2024-02-11

-- forked from Vertex Aave OP copy @ https://flipsidecrypto.xyz/edit/queries/c5515121-b82c-4110-968f-15cdb2c8d186

-- forked from Vertex Aave Eth @ https://flipsidecrypto.xyz/edit/queries/098434e8-0818-498a-aef1-382391112b25

SELECT

BORROWER as user,

'Arbitrum' as chain,

'Aave' as platform,

sum(AMOUNT_USD) as amt

FROM arbitrum.defi.ez_lending_borrows

where platform like '%Aave%'

GROUP BY 1,2,3

HAVING amt > 5000

Last run: about 1 year ago

	USER	CHAIN	PLATFORM	AMT
1	0xd7c9fa90edb7b40c34d6de1d09c750146ba2e8eb	Arbitrum	Aave	11888.5
2	0xf28570694a6c9cd0494955966ae75af61abf5a07	Arbitrum	Aave	610648.49
3	0xe3c551d2f2637263a1a0e887b2e26f88629f30be	Arbitrum	Aave	32605749.91
4	0x308048bed0306d3f1471863ee08464184a2e63de	Arbitrum	Aave	273300.4
5	0xb0a3d37dd5f6960a060a0db56d3d7fdef8b706fb	Arbitrum	Aave	28542.95
6	0x20651c62afedcce649844fdd9f8fa8d7dee3616c	Arbitrum	Aave	8077.57
7	0x1acb1140e001c82be0833e436eb70db92f4d2657	Arbitrum	Aave	7993.62
8	0x0fbeabcafcf817d47e10a7bcfc15ba194dbd4eef	Arbitrum	Aave	19060.91
9	0xac3855a7dc69d3f33026a00a483bdb82e5f2cfcc	Arbitrum	Aave	148566.4
10	0x80eba6761f3fc3359131439fa359b5b44b912d4f	Arbitrum	Aave	56120.93
11	0x02673159818c1fa34194e17a0ce8ce0d8254b861	Arbitrum	Aave	8053
12	0xff94a4c17cc1007166072e209a9c30d30403b04a	Arbitrum	Aave	6317.55
13	0xbe364f1c539d4a1b2c76ac4c96a0d018d4bfadc7	Arbitrum	Aave	115976.21
14	0x91ef5035a5d86a422c0cee2a76aa021bd93dcfb2	Arbitrum	Aave	8075.9
15	0x5a7854b12ee7b1e734dc4f645a2555d75a48f05e	Arbitrum	Aave	398533.35
16	0x29fd7d23dd61775d564c7598b6948bf16b272641	Arbitrum	Aave	53713.79
17	0x4b1796a1d7218d7f4df2946348498bb42cbea597	Arbitrum	Aave	50046.7
18	0x252dc8969bd5615014b4937ca8312e2abb9449b3	Arbitrum	Aave	121527.63
19	0x8d29f20860fbb3d2fa4c19f138836b62d5e69fd4	Arbitrum	Aave	30059.21
20	0x91d6e260a5965a3c33d5bc4bf4adcf96c449ed2e	Arbitrum	Aave	152112.05

...

9953

715KB