Query editor
-- Tydro on Ink - Top 500 WETH Depositors (Test Query)-- Asset: WETH-- Contract: 0x4200000000000000000000000000000000000006-- Using tydro_ink.l2poolinstance_call_depositWITH deposit_calls AS (SELECTd.onBehalfOf as depositor_address,COUNT(*) as total_deposit_transactions,SUM(d.amount / POWER(10, 18)) as total_deposited_weth,MIN(d.call_block_time) as first_deposit_time,MAX(d.call_block_time) as latest_deposit_timeFROM tydro_ink.l2poolinstance_call_deposit dWHERE d.asset = 0x4200000000000000000000000000000000000006AND d.call_success = TRUEGROUP BY d.onBehalfOf)SELECTdepositor_address,total_deposit_transactions,total_deposited_weth,first_deposit_time,latest_deposit_timeFROM deposit_callsORDER BYtotal_deposited_weth DESCLIMIT 500;