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