scottincryptoAave WETH/STETH Pool Market Data
    Updated 2022-04-02
    select
    block_hour as date
    , lending_pool_add
    , data_provider
    , reserve_name
    , atoken_address
    , stable_debt_token_address
    , variable_debt_token_address
    , reserve_price
    , atoken_price
    , total_liquidity_token
    , total_liquidity_usd
    , total_stable_debt_token
    , total_stable_debt_usd
    , total_variable_debt_token
    , total_variable_debt_usd
    , supply_rate
    , borrow_rate_stable
    , borrow_rate_variable
    , utilization_rate
    from aave.market_stats
    where aave_version = 'Aave V2'
    and block_hour > current_date - 60
    and reserve_name in ('WETH', 'STETH')
    and hour(block_hour) = 0
    order by date desc
    Run a query to Download Data