Query editor
/* Query to find all executeWithdrawal calls and the USDC amounts withdrawn from Wintermute USDC market */WITH withdrawal_txs AS (SELECThash AS transaction_hash,"from" AS caller_address,block_timeFROM ethereum.transactionsWHERE"to" = 0xc9499006a149c553d18171747ed19aa7c6dd19e2 /* Wintermute USDC market */AND BYTEARRAY_SUBSTRING(data, 1, 4) = 0x34bca29c /* Function signature for executeWithdrawal */)SELECTwt.block_time,wt.caller_address,wt.transaction_hash,tr."to" AS recipient_address,tr.value / 1e6 AS amount_usdc_withdrawn,TO_HEX(t.data) AS input_dataFROM withdrawal_txs wtJOIN ethereum.transactions t ON wt.transaction_hash = t.hashJOIN erc20_ethereum.evt_Transfer tr ON wt.transaction_hash = tr.evt_tx_hashWHEREtr."from" = 0xc9499006a149c553d18171747ed19aa7c6dd19e2 /* USDC transfers from the Wintermute market */AND tr.contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 /* USDC token */ORDER BYwt.block_time DESC