Query editor
-- Tydro on Ink - Top 500 WETH Depositors via aToken Transfers-- aInkWlWETH Token: 0x2B35eF056728BaFFaC103e3b81cB029788006EF9-- When users deposit WETH, they receive aInkWlWETH tokensWITH atoken_mints AS (SELECT"to" as depositor_address,value / POWER(10, 18) as amount_weth,evt_block_time,evt_tx_hashFROM erc20_ink.evt_TransferWHERE contract_address = 0x2B35eF056728BaFFaC103e3b81cB029788006EF9AND "from" = 0x0000000000000000000000000000000000000000 -- Minted from zero address)SELECTdepositor_address,COUNT(*) as total_deposits,SUM(amount_weth) as total_deposited_weth,MIN(evt_block_time) as first_deposit,MAX(evt_block_time) as latest_depositFROM atoken_mintsGROUP BY depositor_addressORDER BY total_deposited_weth DESCLIMIT 500;