Query editor
-- Q8: Fluid ETH Lite — top iETH holders (current)-- Balance per address from full Transfer aggregation of iETHv2 (0xa0d3707c...be78).-- Top 20 rows + one "Others" aggregate row (so column sums = total supply, and pie gets its bucket).-- pie_label groups top 10 individually, everything else "Others". Dust = 1e12 wei.-- total_holders = count of all addresses with balance > dust (validation vs Q7 latest).with transfers as (select evt_block_time, "from" as addr_from, "to" as addr_to, valuefrom erc20_ethereum.evt_transferwhere contract_address = 0xa0d3707c569ff8c87fa923d3823ec5d81c98be78),flows as (select addr_to as address, cast(value as double) as amtfrom transferswhere addr_to <> 0x0000000000000000000000000000000000000000union allselect addr_from as address, -cast(value as double) as amtfrom transferswhere addr_from <> 0x0000000000000000000000000000000000000000),balances as (select address, sum(amt) as bal_weifrom flowsgroup by 1having sum(amt) > 1e12),totals as (select sum(bal_wei) as tot, count(*) as n_holders from balances),ranked as (selectrow_number() over (order by bal_wei desc) as rnk,address,bal_wei / 1e18 as balance_ieth,100.0 * bal_wei / tot as share_pct,n_holdersfrom balances cross join totals)selectrnk as rank,get_href(concat('https://etherscan.io/address/', cast(address as varchar)), cast(address as varchar)) as holder,balance_ieth,share_pct,case when rnk <= 10 then concat('#', cast(rnk as varchar), ' ', substr(cast(address as varchar), 1, 10)) else 'Others' end as pie_label,n_holders as total_holdersfrom rankedwhere rnk <= 20union allselectnull as rank,concat('Others (', cast(count(*) as varchar), ' holders)') as holder,sum(balance_ieth) as balance_ieth,sum(share_pct) as share_pct,'Others' as pie_label,max(n_holders) as total_holdersfrom rankedwhere rnk > 20order by 1 asc