Query editor
withdata as (select"from" as account,'L1' as tx_type,evt_block_timefromerc20_ethereum.evt_Transferwhereto not in (select address from ethereum.creation_traces) andcontains(array[0xd2dF355C19471c8bd7D8A3aa27Ff4e26A21b4076,0xe36E2D3c7c34281FA3bC737950a68571736880A1,0xF48e200EAF9906362BB1442fca31e0835773b8B4,0xfE18be6b3Bd88A2D2A7f928d00292E7a9963CfC6,0x0F83287FF768D1c1e17a42F44d644D7F22e8ee1d,0x1715AC0743102BF5Cd58EfBB6Cf2dC2685d967b6,0x5e74C9036fb86BD7eCdcb084a0673EFc32eA31cb,0x104eDF1da359506548BFc7c25bA1E28C16a70235,0xD71eCFF9342A5Ced620049e616c5035F1dB98620,0x97fe22E7341a0Cd8Db6F6C021A24Dc8f4DAD855F,0xF6b1C627e95BFc3c1b4c9B825a032Ff0fBf3e07d,0x269895a3dF4D73b077Fc823dD6dA1B95f72Aaf9B,0xbBC455cb4F1B9e4bFC4B73970d360c8f032EfEE6,0x57Ab1ec28D129707052df4dF418D58a2D46d5f51,0xaCf5C0101cbBe8476E87c652E0bEF33684Cc94D6, --old sETH0x57Ab1E02fEE23774580C119740129eAC7081e9D3, --old sUSD0x9073Ee83b6CE96C444547DdCAf777b9352163581 --old sBTC],contract_address)unionselect"from" as account,'L2 Spot' as tx_type,evt_block_timefromerc20_optimism.evt_Transferwhereto not in (select address from optimism.creation_traces union values (0x0000000000000000000000000000000000000000)) andcontains(array[0x8c6f28f2F1A3C87F0f938b96d27520d9751ec8d9,0x00B8D5a5e1Ac97Cb4341c4Bc4367443c8776e8d9,0xB2b42B231C68cbb0b4bF2FFEbf57782Fd97D3dA4,0x298B9B95708152ff6968aafd889c6586e9169f1D,0xE405de8F52ba7559f9df3C368500B6E6ae6Cee49,0xFBc4198702E81aE77c06D58f81b629BDf36f0a71,0xa3A538EA5D5838dC32dde15946ccD74bDd5652fF,0xc5Db22719A06418028A40A9B5E9A7c02959D0d08,0x81DDfAc111913d3d5218DEA999216323B7CD6356,0x8b2F7Ae8cA8EE8428B6D76dE88326bB413db2766,0xf5a6115Aa582Fd1BEEa22BC93B7dC7a785F60d03],contract_address)unionselectaccount,