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