Query editor
-- Tydro on Ink - kBTC Depositors via aToken Transfers (Test)-- aInkWlKBTC Token: 0xC712C3a5624de08EA593FB23270804B47942564e-- When users deposit kBTC, they receive aInkWlKBTC tokensWITH atoken_mints AS (SELECT"to" as depositor_address,value / POWER(10, 8) as amount_kbtc,evt_block_time,evt_tx_hashFROM erc20_ink.evt_TransferWHERE contract_address = 0xC712C3a5624de08EA593FB23270804B47942564eAND "from" = 0x0000000000000000000000000000000000000000 -- Minted from zero address)SELECTdepositor_address,COUNT(*) as total_deposits,SUM(amount_kbtc) as total_deposited_kbtc,MIN(evt_block_time) as first_deposit,MAX(evt_block_time) as latest_depositFROM atoken_mintsGROUP BY depositor_addressORDER BY total_deposited_kbtc DESCLIMIT 500;