Query editor
withvolumes_by_sender as (SELECTsender,SUM(cast(amount as double) * cast(price as double) / 1e18) AS volumeFROMlido_ethereum.steth_evt_Submitted oiINNER JOIN prices.usd ON symbol = 'WETH'AND minute = date_trunc('minute', evt_block_time)whereblockchain = 'ethereum'GROUP BY1),cumulative_volume as (SELECT-- users count by logarithmically increasing volumeFLOOR(POWER(2.0, FLOOR(LOG(2.0, (1 + volume))))) as volume,COUNT(*) as stakersFROMvolumes_by_senderGROUP BY1ORDER BY1)SELECT-- users distribution by volume_from & volume_toROW_NUMBER() OVER (ORDER BYvolume) as idx,volume as volume_from,FLOOR(POWER(2.0, LOG(2.0, volume) + 1)) - 1 as volume_to,stakers as "unique stakers #"FROMcumulative_volumewherevolume > 0/*SELECTROW_NUMBER() OVER () as idx,volume as volume_from,FLOOR(POWER(2.0, LOG(2.0, cast(volume AS numeric)) + 1)) - 1 as volume_to,usersFROM (SELECTFLOOR(POWER(2.0, FLOOR(LOG(2.0, cast(1 + volume AS numeric))))) as volume,COUNT(*) as usersFROM (SELECTsender,SUM(amount*price/1e18) AS volumeFROM lido."steth_evt_Submitted" oiINNER JOIN prices.layer1_usd ON symbol = 'ETH' AND minute = date_trunc('minute', evt_block_time)GROUP BY 1) ttGROUP BY 1ORDER BY 1) ttt