L AS ( select * from (VALUES

('🐋 Blockchain Capital','0x8fcbb7b257454c477bc2eb939db03e032c76b94e'),

('🐋 Blockchain Capital','0x9e3421274fb4053a83917d62bd368332e9e71fe0'),

('🐋 Blockchain Capital','0x60ac32d416507c844b43e29b2e12dd23f5277420'),

('🐋 Blockchain Capital','0x87c0444bb3100d8f00e76c1f750d6f213847d60c'),

('🐋 Blockchain Capital','0x598dbe6738e0aca4eabc22fed2ac737dbd13fb8f'),

('🐋 Blockchain Capital','0x702cacafa54b88e9c54449563fb2e496e85c78b7'),

('🐋 Blockchain Capital','0x3744da57184575064838bbc87a0fc791f5e39ea2'),

('🐋 Blockchain Capital','0xf9706224f8b7275ee159866c35f26e1f43682e20')

) 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

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

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

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

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

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

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

select 'bnbchain' as chain, to_address as user, symbol, amount as amount, amount_usd, amount_usd as value, contract_address, block_timestamp from bsc.core.ez_token_transfers ),

A as( select amount, amount_usd as value, amount_usd, eth_to_address as user, BLOCK_TIMESTAMP from ethereum.core.ez_eth_transfers union all

select 0-amount, 0-amount_usd as value, amount_usd, eth_from_address as user, BLOCK_TIMESTAMP from ethereum.core.ez_eth_transfers)