binhachonAAVE: Top 10 leaderboard
Updated 2021-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT * FROM
(
SELECT 'LENDING_BORROWING' AS SYMBOL, ORIGIN_ADDRESS, SUM(AMOUNT) as AAVE_AMOUNT FROM ethereum.udm_events
WHERE FROM_ADDRESS = '0xd784927ff2f95ba542bfc824c8a8a98f3495f6b5'
AND ORIGIN_FUNCTION_SIGNATURE = '0x3111e7b3'
AND CONTRACT_ADDRESS = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'
GROUP BY SYMBOL, ORIGIN_ADDRESS
ORDER BY AAVE_AMOUNT DESC
LIMIT 10
) UNION ALL
(SELECT 'stkAAVE_stkABPT' as SYMBOL, ORIGIN_ADDRESS, SUM(AMOUNT) AS AAVE_AMOUNT FROM ethereum.udm_events
WHERE FROM_ADDRESS = '0x25f2226b597e8f9514b3f68f00f494cf4f286491'
AND ORIGIN_FUNCTION_SIGNATURE = '0x9a99b4f0'
GROUP BY SYMBOL, ORIGIN_ADDRESS
ORDER BY AAVE_AMOUNT DESC
LIMIT 10
)
ORDER BY AAVE_AMOUNT DESC
Run a query to Download Data