Query editor
-- ============================================================-- USDT0 Utilization on Mantle Network-- Token: 0x779Ded0c9e1022225f8E0630b35a9b54bE713736-- Full version including Aave V3 aToken tracking-- ============================================================WITHusdt0_transfers AS (SELECT"from" AS sender,"to" AS receiver,value / 1e6 AS amount_usdt0,evt_block_time,evt_tx_hashFROM erc20_mantle.evt_TransferWHERE contract_address = 0x779ded0c9e1022225f8e0630b35a9b54be713736AND evt_block_time >= NOW() - INTERVAL '90' DAY),receivers AS (SELECTreceiver AS address,COUNT(*) AS tx_count,SUM(amount_usdt0) AS total_inflow_usdt0,COUNT(DISTINCT sender) AS unique_senders,MIN(evt_block_time) AS first_seen,MAX(evt_block_time) AS last_seenFROM usdt0_transfersGROUP BY 1),labelled AS (SELECTaddress,tx_count,total_inflow_usdt0,unique_senders,first_seen,last_seen,CASE address-- System / OFT MintWHEN 0x0000000000000000000000000000000000000000 THEN 'Null Address (OFT Mint/Burn)'-- Aave V3 Mantle — aToken holds actual USDT0 collateral-- The "unverified" addresses with 2-3 senders & large balances match this patternWHEN 0x920eefbcf1f5756109952e6ff6da1cab950c64d7 THEN 'Aave V3: aUSDT0 Token (Supply)'WHEN 0xedf894eda3cdeaa8add9403bed2148d3ea1e23c8 THEN 'Aave V3: Pool or Related Contract'WHEN 0x294f3516938875a1f5d67ced1f093b07c5eeb3d8 THEN 'Aave V3: Pool or Related Contract'WHEN 0xb3abe0777aa9685941e54744e704378b4b33eeaa THEN 'Aave V3: Pool or Related Contract'WHEN 0x015cc48cc8bc37d80aaff4e43061dbaf94192308 THEN 'Aave V3: Pool or Related Contract'WHEN 0x502d222e8e4daef69032f55f0c1a999effd78fb3 THEN 'Aave V3: Pool or Related Contract'WHEN 0x3063c5907faa10c01b242181aa689beb23d2bd65 THEN 'Aave V3: Pool or Related Contract'WHEN 0x7053bad224f0c021839f6ac645bdae5f8b585b69 THEN 'Aave V3: Pool or Related Contract'-- CEX / ExchangeWHEN 0xb8734a14fbd4aa2d44e6aa830405ffc861ba313c THEN 'Bybit: Hot Wallet 2'WHEN 0x2570faf7c8a0da87d3f123b35cc722ec3fcc3e08 THEN 'Bybit: Institutional Wallet'WHEN 0xb24692d17babefd97ea2b4ca604a481a7cc2c8ea THEN 'Bybit: Institutional Wallet 2'-- DEX - Agni FinanceWHEN 0x319b69888b0d11cec22caa5034e25fffbdc88421 THEN 'Agni Finance: Swap Router'WHEN 0x470a4ef3844aa3428d6be253ea3230c64e42ba52 THEN 'Agni Finance: USDT0 Pool'