with base as( SELECT tr.tx_hash as h, date_trunc('month', ez.BLOCK_TIMESTAMP) as d, tr.from_Address as ua, 'ethereum to ' || TO_VARIANT( SUBSTR(ethereum.public.udf_hex_to_int(data:value), -4) ) as pair, AMOUNT_USD as v FROM ethereum.core.fact_traces tr inner join ethereum.core.ez_eth_transfers ez on ez.tx_hash = tr.tx_hash where ez.block_number >= 13964277 and origin_to_address in ( '0x80c67432656d59144ceff962e8faf8926599bcf8', '0xe4edb277e41dc89ab076a1f049f4a3efa700bce8', '0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc', '0xee73323912a4e3772b74ed0ca1595a152b0ef282' ) and ez.eth_to_address in ( '0x80c67432656d59144ceff962e8faf8926599bcf8', '0xe4edb277e41dc89ab076a1f049f4a3efa700bce8', '0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc', '0xee73323912a4e3772b74ed0ca1595a152b0ef282' ) and tr.from_address != '0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc' and ez.eth_from_Address != '0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc' and AMOUNT_USD > 0 UNION all SELECT ez.tx_hash as h, date_trunc('month', ez.BLOCK_TIMESTAMP) as d, tr.from_Address as ua, CASE when DECODED_LOG:wad is null then 'ethereum to ' || TO_VARIANT(SUBSTR(DECODED_LOG:value, -4)) when DECODED_LOG:value is null then 'ethereum to ' || TO_VARIANT(SUBSTR(DECODED_LOG:wad, -4)) end as pair, amount_usd as v FROM ethereum.core.ez_token_transfers tr inner join ethereum.core.fact_decoded_event_logs ez on ez.tx_hash = tr.tx_hash WHERE ez.block_number >= 13479383 and tr.contract_address in ( '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0xdac17f958d2ee523a2206206994597c13d831ec7', '0x6b175474e89094c44da98b954eedeac495271d0f' ) and to_Address in ( '0x41d3d33156ae7c62c094aae2995003ae63f587b3', '0xd7aa9ba6caac7b0436c91396f22ca5a7f31664fc', '0x095d2918b03b2e86d68551dcf11302121fb626c9' ) and event_name = 'Transfer' and tr.from_address != '0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc' and AMOUNT_USD > 0 UNION all SELECT tr.tx_hash as h, date_trunc('month', ez.BLOCK_TIMESTAMP) as d, tr.from_Address as ua, 'Arbitrum to ' || TO_VARIANT(SUBSTR(ETH_VALUE_PRECISE_RAW, -4)) as pair, AMOUNT_USD as v FROM arbitrum.core.fact_traces tr inner join arbitrum.core.ez_eth_transfers ez on ez.tx_hash = tr.tx_hash where ez.block_number >= 44782