SELECT LOWER('0x05c9C6417F246600f8f5f49fcA9Ee991bfF73D13') as address, 'Main Pool' as vault_name UNION ALL

SELECT LOWER('0x079f84161642D81aaFb67966123C9949F9284bf5'), 'ionezETH' UNION ALL

SELECT LOWER('0x9D62e30c6cB7964C99314DCf5F847e36Fcb29ca9'), 'ionwstETH' UNION ALL

SELECT LOWER('0x9c201024A62466F9157b2dAaDda9326207ADDd29'), 'ioncbETH' UNION ALL

SELECT LOWER('0x014e08F05ac11BB532BE62774A4C548368f59779'), 'ionAERO' UNION ALL

SELECT LOWER('0xa900A17a49Bc4D442bA7F72c39FA2108865671f0'), 'ionUSDC' UNION ALL

SELECT LOWER('0x49420311B518f3d0c94e897592014de53831cfA3'), 'ionWETH' UNION ALL

SELECT LOWER('0x84341B650598002d427570298564d6701733c805'), 'ionweETH' UNION ALL

SELECT LOWER('0x9c2A4f9c5471fd36bE3BBd8437A33935107215A1'), 'ioneUSD' UNION ALL

SELECT LOWER('0x3D9669DE9E3E98DB41A1CbF6dC23446109945E3C'), 'ionbsdETH' UNION ALL

SELECT LOWER('0x751911bDa88eFcF412326ABE649B7A3b28c4dEDe'), 'ionhyUSD' UNION ALL

SELECT LOWER('0xfc6b82668E10AFF62f208C492fc95ef1fa9C0426'), 'ionRSR' UNION ALL

SELECT LOWER('0xC462eb5587062e2f2391990b8609D2428d8Cf598'), 'ionwsuperOETHb' UNION ALL

SELECT LOWER('0xe30965Acd0Ee1CE2e0Cd0AcBFB3596bD6fC78A51'), 'ionwUSDM' UNION ALL

SELECT LOWER('0x1De166df671AE6DB4C4C98903df88E8007593748'), 'ioncbBTC' UNION ALL

SELECT LOWER('0x0E5A87047F871050c0D713321Deb0F008a41C495'), 'ionEURC' UNION ALL

SELECT LOWER('0xE00B2B2ca7ac347bc7Ca82fE5CfF0f76222FF375'), 'ionOGN' UNION ALL

SELECT LOWER('0x74109171033F662D5b898A7a2FcAB2f1EF80c201'), 'ionUSD+' UNION ALL

SELECT LOWER('0xa4442b665d4c6DBC6ea43137B336e3089f05626C'), 'ionUSDz' UNION ALL

SELECT LOWER('0xF1bbECD6aCF648540eb79588Df692c6b2F0fbc09'), 'ionwUSD+' UNION ALL

SELECT LOWER('0xf64bfd19DdCB2Bb54e6f976a233d0A9400ed84eA'), 'ionsUSDz' UNION ALL

SELECT LOWER('0xbd06905590b6E1b6Ac979Fc477A0AebB58d52371'), 'ionuSOL' UNION ALL

SELECT LOWER('0xAa255Cf8e294BD7fcAB21897C0791e50C99BAc69'), 'ionuSUI'

),

lending_daily AS (

SELECT

DATE_TRUNC('day', l.block_timestamp) as day,

v.vault_name,

l.platform,

l.protocol_market,

-- Deposits

SUM(CASE WHEN l.event_name = 'Deposit' THEN l.amount_usd ELSE 0 END) as deposit_usd,

COUNT(DISTINCT CASE WHEN l.event_name = 'Deposit' THEN l.tx_hash END) as deposit_tx_count,

-- Withdraws

SUM(CASE WHEN l.event_name = 'Withdraw' THEN l.amount_usd ELSE 0 END) as withdraw_usd,