connorhAAVE Market Stats
    Updated 2021-08-09
    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