Query editor
withuser_transactions as (selectdistinct from_hex(CAST(json_extract(transactions, '$[0].hash') AS VARCHAR)) as user_tx-- from_hex(CAST(json_extract(transactions, '$[0].from') AS VARCHAR)) as user_addressfrom mevblocker.raw_bundlesWHERE DATE(from_unixtime(cast(timestamp as double)/cast(1000 as double))) BETWEEN (timestamp '{{StartTime}}') and (timestamp '{{EndTime}}' )),mined_user_transactions as (select hashfrom user_transactionsinner join ethereum.transactionson user_tx = hash)select sum(amount_usd) from query_2507692 where tx_hash in (select hash from mined_user_transactions)