L AS ( select * from (VALUES

( 'Ethereum', 'Circle','USDC', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','0x0000000000000000000000000000000000000000'),

( 'Avalanche' , 'Circle','USDC', '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','0x0000000000000000000000000000000000000000'),

( 'Arbitrum' , 'Circle','USDC', '0xaf88d065e77c8cc2239327c5edb3a432268e5831','0x0000000000000000000000000000000000000000'),

( 'Optimism' , 'Circle','USDC', '0x0b2C639c533813f4Aa9D7837CAf62653d097Ff85','0x0000000000000000000000000000000000000000'),

( 'Base' , 'Circle','USDC', '0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913','0x0000000000000000000000000000000000000000'),

( 'Polygon' , 'Circle','USDC', '0x3c499c542cef5e3811e1192ce70d8cc03d5c3359','0x0000000000000000000000000000000000000000'),

( 'Avalanche' , 'Tether','USDT', '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','0x0000000000000000000000000000000000000000'),

( 'Polygon' , 'Tether','USDT', '0x170a18b9190669cda08965562745a323c907e5ec','0x0000000000000000000000000000000000000000'),

( 'Arbitrum' , 'Tether','USDT', '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9','0x0000000000000000000000000000000000000000')

) as l1(chain, tag, symbol, contract, mint) ),

A as(

select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from ethereum.core.fact_token_transfers union all

select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from ethereum.core.fact_token_transfers union all

select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from base.core.fact_token_transfers union all

select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from base.core.fact_token_transfers union all

select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from avalanche.core.fact_token_transfers union all

select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from avalanche.core.fact_token_transfers union all

select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from polygon.core.fact_token_transfers union all

select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from polygon.core.fact_token_transfers union all

select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from optimism.core.fact_token_transfers union all

select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from optimism.core.fact_token_transfers union all

select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from arbitrum.core.fact_token_transfers union all

select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from arbitrum.core.fact_token_transfers

),

AB as( select block_timestamp, symbol, chain, contract_address, action, amount/1e6 as amount