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