AndyCoolBorrow Single Stats
Updated 2022-09-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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