SELECT supplier

, supplied_symbol as symbol

, SUM(supplied_base_asset_usd) AS deposits

FROM compound.deposits

GROUP BY 1,2

HAVING SUM(supplied_base_asset_usd) > 0

)

, borrows AS (

SELECT borrower

, borrows_contract_symbol as symbol

, SUM(loan_amount_usd) AS loans

FROM compound.borrows

GROUP BY 1,2

)

, ratio as (SELECT supplier

, d.symbol

, ROUND(loans*1.0/deposits,5) AS pct_borrowed

FROM deposits d JOIN borrows b ON d.supplier = b.borrower

)

SELECT symbol, APPROX_PERCENTILE(pct_borrowed,0.5) AS median_pct_borrowed FROM ratio GROUP BY 1