Query editor
WITH phishing_tx AS (SELECT'1. Phishing via Permit' AS step,block_time,tx_hash,"from" AS victim,"to" AS attacker_received,amount,amount_usd,symbolFROM tokens_ethereum.transfersWHEREtx_hash = 0xcc58adcf9d8410e8e8bf890e70fbc72c91eb5a8840416e4cbcab06f322fe554f), unwrap_tx AS (SELECT'2. Unwrap aEthLBTC to LBTC' AS step,block_time,tx_hash,"from" AS from_address,"to" AS to_address,amount,amount_usd,symbolFROM tokens_ethereum.transfersWHEREtx_hash = 0xf5f5f844da3b94ddb4981999d7c9c608d065697c14bf70322e3e0c116a8651a9AND symbol = 'LBTC'), swap_tx AS (SELECT'3. Swap LBTC to ETH' AS step,block_time,tx_hash,"from" AS from_address,"to" AS to_address,value / 1e18 AS amount,(value / 1e18 * 3500) AS amount_usd, /* Rough ETH price estimate */'ETH' AS symbolFROM ethereum.tracesWHEREtx_hash = 0x52e245e409babb5a52257e5511ce4f1f1c91a37068c27ac11f0f04c9d64017edAND "to" = 0x0385e38457fea1b25e8175837fbe67400e0fe9fdAND value > 100), tornado_deposits AS (SELECT'4. Launder via Tornado Cash' AS step,block_time,hash,"from" AS from_address,"to" AS tornado_cash_router,value / 1e18 AS amount,(value / 1e18 * 3500) AS amount_usd,'ETH' AS symbolFROM ethereum.transactionsWHERE"from" = 0x0385e38457fea1b25e8175837fbe67400e0fe9fdAND "to" = 0xd90e2f925da726b50c4ed8d0fb90ad053324f31b