with deposits_base as (

select

block_timestamp,

tx_hash,

from_address as lender,

amount

from ethereum.core.ez_token_transfers

where block_timestamp >= '2021-01-01'

and origin_function_signature = '0x515bc323'

and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- usdc

and to_address = '{{borrower_pool}}' -- variable

)

select

count(distinct lender) as total_lenders,

count(distinct tx_hash) as deposit_transactions,

sum(amount) as total_usdc_deposits

from deposits_base