SELECT * FROM (VALUES

('ethereum', '0x35a79f2cb4fd02187c5c3a6cd8f77e3c63fcf733', 'Active Treasury Wallet'),

('arbitrum', '0xbF70734E9E1da98149E4550025B1055Facd60583', 'Arbitrum Referral Fee'),

('arbitrum', '0x1D1454D2016Cf6cCdE3687159a0d202e91825d60', 'Arbitrum Treasury (Old)'),

('ethereum', '0x45DAD754897ef0b2780349AD7c7000c72717b24E', 'Enzyme Kiln System Admin Wallet'),

('ethereum', '0xb270FE91e8E4b80452fBF1b4704208792A350f53', 'Enzyme Technical Committee Wallet'),

('ethereum', '0x48143538590587df4de00a77c2dd52f689088335', 'Enzyme Treasury Management Vault'),

('arbitrum', '0x372a620bA672424296E51EE4788e21b245AD8063', 'LP Wallet'),

('ethereum', '0xfC60416885f38aDb121C6bd090D94CF9f0448f53', 'Operating Wallet'),

('arbitrum', '0xfC60416885f38aDb121C6bd090D94CF9f0448f53', 'Operating Wallet (ARB)'),

('optimism', '0xfC60416885f38aDb121C6bd090D94CF9f0448f53', 'Operating Wallet (OP)'),

('polygon', '0xfC60416885f38aDb121C6bd090D94CF9f0448f53', 'Operating Wallet (Polygon)'),

('polygon', '0x85118a829ec34700E5De889d8CC914D930475729', 'Polygon Operations (Old)'),

('polygon', '0xF5Ac3C711b016d517A280C8aD38Be7c2FF460f17', 'Polygon Technical Wallet'),

('ethereum', '0x9C659caF50c3d29ab3B0744a533CffCb5241B2da', 'Raincard Collateral'),

('ethereum', '0x1ad1fc9964c551f456238dd88d6a38344b5319d7', 'Referral Fee Wallet'),

('ethereum', '0x5904a70316eB658a2fD6D41d723E7B592Ffda504', 'Revenue Wallet'),

('ethereum', '0xfECA27229A3801b34591582B66C46c82a9bC9994', 'Treasury Wallet')

) as v(chain, address, wallet_name)

),

eth_balances AS (

SELECT

'ethereum' as chain,

LOWER(user_address) as wallet_address,

contract_address,

symbol,

current_bal as balance,

usd_value_now as usd_value

FROM ethereum.core.ez_current_balances

WHERE LOWER(user_address) IN (SELECT LOWER(address) FROM wallet_labels WHERE chain = 'ethereum')

AND current_bal > 0

),

arb_balances AS (