max(date_trunc('day', block_timestamp)) as day_removed,

sum(amount_usd) as collateral_amount_usd,

CASE

WHEN to_address = lower('0xF04a5cC80B1E94C69B48f5ee68a08CD2F09A7c3E') THEN 'ETH_C'

WHEN to_address = lower('0x2F0b23f53734252Bda2277357e97e1517d6B042A') THEN 'ETH_A'

WHEN to_address = lower('0x08638eF1A205bE6762A8b935F5da9b700Cf7322c') THEN 'ETH_B'

WHEN to_address = lower('0x3D0B1912B66114d4096F48A8CEe3A56C231772cA') THEN 'BAT_A'

WHEN to_address = lower('0xA191e578a6736167326d05c119CE0c90849E84B7') THEN 'USDC_A'

WHEN to_address = lower('0x2600004fd1585f7270756DDc88aD9cfA10dD0428') THEN 'USDC_B'

WHEN to_address = lower('0x0A59649758aa4d66E25f08Dd01271e891fe52199') THEN 'PSM_USDC_A'

WHEN to_address = lower('0xBF72Da2Bd84c5170618Fbe5914B0ECA9638d5eb5') THEN 'WBTC_A'

WHEN to_address = lower('0xfA8c996e158B80D77FbD0082BB437556A65B96E0') THEN 'WBTC_B'

WHEN to_address = lower('0x7f62f9592b823331E012D3c5DdF2A7714CfB9de2') THEN 'WBTC_C'

WHEN to_address = lower('0x4454aF7C8bb9463203b66C816220D41ED7837f44') THEN 'TUSD_A'

WHEN to_address = lower('0xc7e8Cd72BDEe38865b4F5615956eF47ce1a7e5D0') THEN 'ZRX_A'

WHEN to_address = lower('0x475F1a89C1ED844A08E8f6C50A00228b5E59E4A9') THEN 'KNC_A'

WHEN to_address = lower('0xA6EA3b9C04b8a38Ff5e224E7c3D6937ca44C0ef9') THEN 'MANA_A'

WHEN to_address = lower('0x0Ac6A1D74E84C2dF9063bDDc31699FF2a2BB22A2') THEN 'USDT_A'

WHEN to_address = lower('0x7e62B7E279DFC78DEB656E34D6a435cC08a44666') THEN 'PAXUSD_A'

WHEN to_address = lower('0x7bbd8cA5e413bCa521C2c80D8d1908616894Cf21') THEN 'PSM_PAX_A'

WHEN to_address = lower('0xBEa7cDfB4b49EC154Ae1c0D731E4DC773A3265aA') THEN 'COMP_A'

WHEN to_address = lower('0x6C186404A7A238D3d6027C0299D1822c1cf5d8f1') THEN 'LRC_A'

WHEN to_address = lower('0xdFccAf8fDbD2F4805C174f856a317765B49E4a50') THEN 'LINK_A'

WHEN to_address = lower('0x4a03Aa7fb3973d8f0221B466EefB53D0aC195f55') THEN 'BAL_A'

WHEN to_address = lower('0x3ff33d9162aD47660083D7DC4bC02Fb231c81677') THEN 'YFI_A'

WHEN to_address = lower('0xe29A14bcDeA40d83675aa43B72dF07f649738C8b') THEN 'GUSD_A'

WHEN to_address = lower('0xe29A14bcDeA40d83675aa43B72dF07f649738C8b') THEN 'GUSD_A'

WHEN to_address = lower('0x79A0FA989fb7ADf1F8e80C93ee605Ebb94F7c6A5') THEN 'PSM_GUSD_A'

WHEN to_address = lower('0x3BC3A58b4FC1CbE7e98bB4aB7c99535e8bA9b8F1') THEN 'UNI_A'

WHEN to_address = lower('0xFD5608515A47C37afbA68960c1916b79af9491D0') THEN 'RENBTC_A'

WHEN to_address = lower('0x24e459F61cEAa7b1cE70Dbaea938940A7c5aD46e') THEN 'AAVE_A'

WHEN to_address = lower('0x885f16e177d45fC9e7C87e1DA9fd47A9cfcE8E13') THEN 'MATIC_A'

WHEN to_address = lower('0x10CD5fbe1b404B7E19Ef964B63939907bdaf42E2') THEN 'WSTETH_A'

WHEN to_address = lower('0xa13C0c8eB109F5A13c6c90FC26AFb23bEB3Fb04a') THEN 'AAVEV2_DAI'

WHEN to_address = lower('0x2502F65D77cA13f183850b5f9272270454094A08') THEN 'UNIV2DAIETH_A'