L AS ( select * from (VALUES

('🐋 DWF Labs','0xb0b851bf44499edec30795bef7ac4d5f9dd632d0'),

('🐋 DWF Labs','0xddacad3b1edee8e2f5b2e84f658202534fcb0374'),

('🐋 DWF Labs','0x7420b4b9a0110cdc71fb720908340c03f9bc03ec'),

('🐋 DWF Labs','0x6cd65ee265e99541f2b69600745636617ed3776a'),

('🐋 DWF Labs','0x79394f264f6333ef0e343e7acd198efef4242fea'),

('🐋 DWF Labs','0x4d951bf43318c86510850d66eddb9be753566d70'),

('🐋 DWF Labs','0xc0e59d7b743c2757c8b39b791b5ebaf2bf6e725d'),

('🐋 DWF Labs','0x50be13b54f3eebbe415d20250598d81280e56772'),

('🐋 DWF Labs','0x2b589f2e81ead4be4f8e44b6f90d9c104da0d791'),

('🐋 DWF Labs','0xa5d4aeddf4ffb8f5ded3576c58ef345da2ca375d'),

('🐋 DWF Labs','0x96447f98b2afa028af61a9564f3a52a2dd258210'),

('🐋 DWF Labs','0x834ff5670a72eaa0166c5e494f9c80f0e77f6551'),

('🐋 DWF Labs','0x61bc0cb788cd356b517138a0192539e5375cb66f'),

('🐋 DWF Labs','0xd4b69e8d62c880e9dd55d419d5e07435c3538342'),

('🐋 DWF Labs','0xe7ca625ad0851c9f1878a7872d316f276302095b'),

('🐋 DWF Labs','0x90d789458c40ada07202cbdcf880cff4922ff36b'),

('🐋 DWF Labs','0x073ad33ecd69754e0572fa0d4425525693db851e'),

('🐋 DWF Labs','0x9e4c532018ea2ca06bbf837448a8dee7cc0fea8a'),

('🐋 DWF Labs','0xa6d86d266fd54eed6290b7fc2f27b8c2d0ac96b8'),

('🐋 DWF Labs','0x951e337d7c2fdb9b80f6cf72c0dac9d0568f9890')

) as l1(venture, address) ),

A as (

select 'ethereum' as chain, from_address as user, symbol, 0-amount as amount, amount_usd, 0-amount_usd as value, contract_address, block_timestamp from ethereum.core.ez_token_transfers union all

select 'ethereum' as chain, to_address as user, symbol, amount as amount, amount_usd, amount_usd as value, contract_address, block_timestamp from ethereum.core.ez_token_transfers union all

select 'optimism' as chain, from_address as user, symbol, 0-amount as amount, amount_usd, 0-amount_usd as value, contract_address, block_timestamp from optimism.core.ez_token_transfers union all

select 'optimism' as chain, to_address as user, symbol, amount as amount, amount_usd, amount_usd as value, contract_address, block_timestamp from optimism.core.ez_token_transfers union all

select 'arbitrum' as chain, from_address as user, symbol, 0-amount as amount, amount_usd, 0-amount_usd as value, contract_address, block_timestamp from arbitrum.core.ez_token_transfers union all

select 'arbitrum' as chain, to_address as user, symbol, amount as amount, amount_usd, amount_usd as value, contract_address, block_timestamp from arbitrum.core.ez_token_transfers union all

select 'base' as chain, from_address as user, symbol, 0-amount as amount, amount_usd, 0-amount_usd as value, contract_address, block_timestamp from base.core.ez_token_transfers union all