hypergladeborrows all time gfinch copy
Updated 2024-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
-- forked from sam / borrows all time gfinch @ https://flipsidecrypto.xyz/sam/q/VmdkFAF6yEtE/borrows-all-time-gfinch
with withdraw_base as (
select
block_timestamp,
tx_hash,
to_address as borrower,
amount
from ethereum.core.ez_token_transfers
where block_timestamp >= '2021-01-01'
and origin_function_signature in (
'0x441a3e70'
,'0x9d110530'
)
and from_address = '{{borrower_pool}}'
and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
)
select
count(distinct borrower) as total_borrower,
count(distinct tx_hash) as borrow_transactions,
sum(amount) as total_usdc_borrowed
from withdraw_base
QueryRunArchived: QueryRun has been archived