connorhAAVE Market Stats
Updated 2021-08-09
999
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
›
⌄
WITH aave_reads AS (
SELECT
DISTINCT
date_trunc('hour',block_timestamp) AS blockhour,
contract_address AS lending_pool_add,
CASE
WHEN contract_address IN (LOWER('0x057835Ad21a177dbdd3090bB1CAE03EaCF78Fc6d'),LOWER('0xc443AD9DDE3cecfB9dfC5736578f447aFE3590ba')) THEN 'DataProvider'
ELSE 'LendingPool' END AS
lending_pool_type,
function_name,
CASE
WHEN contract_address IN (LOWER('0xB53C1a33016B2DC2fF3653530bfF1848a515c8c5'),LOWER('0x057835Ad21a177dbdd3090bB1CAE03EaCF78Fc6d')) THEN 'AAVE V2'
WHEN contract_address IN (LOWER('0x7937d4799803fbbe595ed57278bc4ca21f3bffcb'),LOWER('0xc443AD9DDE3cecfB9dfC5736578f447aFE3590ba')) THEN 'AAVE AMM'
ELSE 'AAVE V1'
END AS aave_version,
inputs,
(SPLIT(LOWER(VALUE_STR),'^')) AS coins
FROM SILVER.ETHEREUM_READS
WHERE
contract_address IN (
LOWER('0xB53C1a33016B2DC2fF3653530bfF1848a515c8c5'),
LOWER('0x057835Ad21a177dbdd3090bB1CAE03EaCF78Fc6d'), -- AAVE V2
LOWER('0x7937d4799803fbbe595ed57278bc4ca21f3bffcb'),
LOWER('0xc443AD9DDE3cecfB9dfC5736578f447aFE3590ba'), -- AAVE AMM
LOWER('0x398eC7346DcD622eDc5ae82352F02bE94C62d119') -- AAVE V1
)
AND block_timestamp >= CURRENT_DATE - 60
), long_format AS (
SELECT
DISTINCT
blockhour,
aave_version,
lending_pool_add,
lending_pool_type,
CASE WHEN LOWER(COALESCE(inputs:address,inputs:_reserve)) = '0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' THEN '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
ELSE LOWER(COALESCE(inputs:address,inputs:_reserve)) END AS reserve_token,
Run a query to Download Data