maybeyonasAAVE-dash-market-stats
    Updated 2023-03-27
    with aave_pool_stats as(
    select
    block_hour,
    lending_pool_add,
    reserve_name,
    aave_version,
    reserve_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
    from aave.market_stats
    where total_liquidity_usd > 0
    and block_hour = date(block_hour)
    )

    select * from aave_pool_stats
    Run a query to Download Data