Abbas_ra21Aave Eth remove
    Updated 2022-09-17
    with withdraw AS (select
    date_trunc('{{Timeframe}}', BLOCK_TIMESTAMP) AS date,
    sum(WITHDRAWN_TOKENS) AS ETH_Amount,
    count(distinct DEPOSITOR_ADDRESS) AS distinct_User_number,
    count(*) AS events_number
    from ethereum.aave.ez_withdraws
    where SYMBOL like '%ETH%' and date between '2022-07-15' and '2022-09-15'
    group by 1),
    borrow AS (select
    date_trunc('{{Timeframe}}', BLOCK_TIMESTAMP) AS date,
    sum(BORROWED_TOKENS) AS ETH_Amount,
    count(distinct BORROWER_ADDRESS) AS distinct_User_number,
    count(*) AS events_number
    from ethereum.aave.ez_borrows
    where SYMBOL like '%ETH%' and date between '2022-07-15' and '2022-09-15'
    group by 1)
    select
    A.date AS date,
    A.ETH_Amount+B.ETH_Amount AS "ETH Amount",
    avg("ETH Amount") over (order by A.date, A.date rows between 6 preceding and current row) as "7 day MA",
    A.distinct_User_number+B.distinct_User_number AS "distinct User number",
    avg("distinct User number") over (order by A.date, A.date rows between 6 preceding and current row) as "7 day distinct user MA",
    A.events_number+B.events_number AS "events number",
    avg("events number") over (order by A.date, A.date rows between 6 preceding and current row) as "7 day events MA"
    from withdraw A inner join borrow B on A.date=B.date





    Run a query to Download Data