SELECT supplier AS supplier_address

, supplied_symbol AS symbol

, supplied_base_asset_usd AS amount

FROM compound.deposits

UNION ALL

SELECT supplier AS supplier_address

, recieved_contract_symbol AS symbol

, -recieved_amount_usd AS amount

FROM compound.redemptions

)

, positive_deposists AS (

SELECT supplier_address

, symbol

, SUM(amount) AS net_deposits

FROM net_deposits

GROUP BY 1,2

HAVING net_deposits > 0

)

SELECT supplier_address

, COUNT(DISTINCT supplier_address) OVER() AS total_suppliers

--, SUM(net_deposits) OVER() AS total_net_deposits

, SUM(net_deposits) AS net_deposits

FROM positive_deposists