Aave

-- Pull fundamental lending data for Aave
SELECT
    date,
    lending_deposits,
    lending_loans,
    tvl,
    price
FROM
    art_share.aave.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze Aave revenue streams
SELECT
    date,
    fees,
    interest_rate_fees,
    flashloan_fees,
    gho_fees,
    service_fee_allocation,
    liquidator_fee_allocation,
    treasury_fee_allocation
FROM
    art_share.aave.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze how Aave's revenue is distributed
SELECT
    date,
    fees,
    service_fee_allocation,
    liquidator_fee_allocation,
    treasury_fee_allocation,
    service_fee_allocation / fees * 100 as lp_percentage,
    liquidator_fee_allocation / fees * 100 as liquidator_percentage,
    treasury_fee_allocation / fees * 100 as treasury_percentage
FROM
    art_share.aave.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Track Aave treasury composition
SELECT
    date,
    treasury,
    treasury_native,
    net_treasury,
    treasury_native / treasury * 100 as aave_token_percentage,
    token_incentives,
    protocol_earnings
FROM
    art_share.aave.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Compare Aave metrics across different blockchains
SELECT
    date,
    chain,
    lending_deposits,
    lending_loans,
    tvl,
    fees
FROM
    art_share.aave.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    chain, date ASC

-- Analyze the performance of specific tokens on Aave
SELECT
    date,
    chain,
    token_address,
    lending_deposits,
    lending_loans,
    fees,
    service_fee_allocation
FROM
    art_share.aave.ez_metrics_by_token
WHERE
    date = DATEADD(day, -1, CURRENT_DATE())
    AND token_address IN (
        '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
        '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', -- WETH
        '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'  -- AAVE
    )
ORDER BY
    fees DESC

-- Track Aave's GHO stablecoin revenue
SELECT
    date,
    gho_fees,
    gho_treasury_fee_allocation,
    gho_fees / fees * 100 as gho_revenue_percentage
FROM
    art_share.aave.ez_metrics
WHERE
    date >= '2023-07-01'  -- Approximate GHO launch date
    AND date <= CURRENT_DATE()
ORDER BY
    date ASC

-- Analyze Aave protocol economics
SELECT
    date,
    lending_deposits,
    lending_loans,
    lending_loans / lending_deposits * 100 as utilization_rate,
    fees,
    fees / lending_loans * 365 * 100 as annualized_revenue_rate,
    token_incentives,
    protocol_earnings,
    price
FROM
    art_share.aave.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC