dep.tx_hash AS deposit_transaction_hash,

dep.user_address AS depositor,

dep.token_symbol AS deposit_collateral_token,

dep.amount_usd AS deposit_amount_usd,

dep.block_timestamp AS deposit_timestamp,

bor.tx_hash AS borrow_transaction_hash,

bor.user_address AS borrower,

bor.token_symbol AS borrowed_token,

bor.amount_usd AS borrow_amount_usd,

bor.block_timestamp AS borrow_timestamp

compound__ez_deposits dep

LEFT JOIN compound__ez_borrows bor ON dep.user_address = bor.user_address

dep.block_timestamp >= current_date - interval '730 days'

AND dep.amount_usd > 0

ORDER BY

dep.amount_usd DESC

100000;