AndyCoolBorrow Single Stats
    Updated 2022-09-03
    select
    count(distinct ORIGIN_FROM_ADDRESS) as Borrower,
    sum(event_inputs:wad)/pow(10,18) as Total_ETH_Borrowed,
    count (distinct tx_hash) as Number_of_Borrows
    from ethereum.core.fact_event_logs
    where block_timestamp >= '2022-08-01'
    and block_timestamp < CURRENT_DATE
    and event_name = 'Withdrawal'
    and origin_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88' -- WETH Gateway
    and contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    and ORIGIN_FUNCTION_SIGNATURE = '0x35611f7e'
    Run a query to Download Data