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'

),

raw_events AS (

SELECT

el.block_timestamp,

DATE_TRUNC('day', el.block_timestamp) as date,

el.tx_hash,

el.contract_address,

vl.vault_name,

el.origin_from_address as user,

dc.decimals as token_decimals,

CASE