Query editor
withdepositors AS (SELECTDATE_TRUNC('day', evt_block_time) AS block_date,evt_block_time AS block_time,evt_tx_hash AS tx_hash,"from" AS users,value/1e6 AS amount_USDCFROM erc20_arbitrum.evt_transferWHERE contract_address = 0xaf88d065e77c8cC2239327C5EDb3A432268e5831AND "to" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7),withdrawors AS (SELECTDATE_TRUNC('day', evt_block_time) AS block_date,evt_block_time AS block_time,evt_tx_hash AS tx_hash,"to" AS users,-value/1e6 AS amount_USDCFROM erc20_arbitrum.evt_transferWHERE contract_address = 0xaf88d065e77c8cC2239327C5EDb3A432268e5831AND "from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7),aggr AS (SELECT 'Deposit Evt' AS event, *FROM depositorsUNION ALLSELECT 'Withdraw Evt' AS event, *FROM withdrawors)SELECT event, block_date, users, amount_USDCFROM aggrORDER BY block_date DESC