Sbhn_NPUntitled Query
    Updated 2023-03-09
    select date_trunc('{{Date}}',block_timestamp) as date,
    symbol,
    count(DISTINCT tx_hash) as borrows,
    count(DISTINCT borrower_address) as unique_borrowers,
    sum(borrowed_usd) as volume_usd
    from ethereum.aave.ez_borrows
    where aave_version = 'Aave V2'
    group by 1,2
    Run a query to Download Data