flipside

    Top 1000 Users With Highest $XLM Balance
    Sbhn_NPTop 1000 Users With Highest $XLM Balance
    Updated 2025-02-18
    WITH price as (
    select hour::date as datee,
    avg(price) as usdprice
    from stellar.price.ez_prices_hourly
    where symbol = 'XLM'
    group by 1
    ),

    RankedBalances AS (
    SELECT
    account_id,
    balance,
    balance*usdprice as usd_balance,
    block_timestamp,
    ROW_NUMBER() OVER (PARTITION BY account_id ORDER BY block_timestamp DESC) AS rn
    FROM stellar.core.fact_accounts
    join price on block_timestamp::date=datee
    )
    SELECT
    account_id,
    balance,
    usd_balance
    FROM RankedBalances
    WHERE rn = 1
    ORDER BY balance DESC
    limit 1000


    Last run: 26 days ago
    ACCOUNT_ID
    BALANCE
    USD_BALANCE
    1
    		GALAXYVOIDAOPZTDLHILAJQKCVVFMD4IKLXLSZV5YHO7VY74IWZILUTO55442115192.897117671146228.5168
    2
    		GDUY7J7A33TQWOSOQGDO776GGLM3UQERL4J3SPT56F6YS4ID7MLDERI47309532748.866542329778032.78149
    3
    		GDKIJJIKXLOM2NRMPNQZUUYK24ZPVFC6426GZAEP3KUK6KEJLACCWNMX3856599180.301461229219480.94462
    4
    		GBFZPAHO24P7ZVZCMI5SXZR53UYD325OWSSWWHHVLBNN56LU5YZJJFNP3345950709.717831066459749.21982
    5
    		GB6NVEN5HSUBKMYCE5ZOWSK5K23TBWRUQLZY3KNMXUZ3AQ2ESC4MY4AQ3113552385.11714992387092.305614
    6
    		GAGL7APMF7BZT6AVGNLBXKCMEHHLKPOL6PADWSLWFVYULGHPQQSIUU2W1999177101.65455692268882.631541
    7
    		GBEVKAYIPWC5AQT6D4N7FC3XGKRRBMPCAMTO3QZWMHHACLHTMAHAM2TP1958019296.62517624082345.858148
    8
    		GCPWKVQNLDPD4RNP5CAXME4BEDTKSSYRR4MMEL4KG65NEGCOGNJW7QI21495439564.90263476643633.370781
    9
    		GBAIA5U6E3FSRUW55AXACIVGX2QR5JYAS74OWLED3S22EGXVYEHPLGPA1001331930.59355354258136.284573
    10
    		GAMGGUQKKJ637ILVDOSCT5X7HYSZDUPGXSUW67B2UKMG2HEN5TPWN3LQ821356793.53494261792248.615382
    11
    		GBXFFJFT56YW4FPAM5JUEK3ZAYWIZGN6PL3TVGDIPLQJILMQJTPJTXI6638000232.976956203350744.673752
    12
    		GDQAEJOEWOAPJA4B2VORRQ6MC6BD3445O6OM3VM4JPGTXU7UADH6DR6V563578510.558023184327744.853177
    13
    		GDJDCYPOWF75J4TCPM7UABMWKEAZKZO2FI64TWBRSWPB5SVLRGNRRZVE478333359.552317152459889.259593
    14
    		GAFT45PM2ZLFVP5HPHBTCSN5BSDL6ZIWMJOPCCM3NXDUQWN2M2XLX2TB392638897.291277125146368.332041
    15
    		GDPJ75JUE7IMHRZMLJDENEN2QC7X256Y2GHS362I3464UGRHELAZVFAN370956908.47431118235636.416842
    16
    		GCVJDBALC2RQFLD2HYGQGWNFZBCOD2CPOTN3LE7FWRZ44H2WRAVZLFCU340379812.133801108489753.908632
    17
    		GA6D2S6XDBT7WZIZNDGUBLXUGDAGLZGZ2SYT2JLXD4BB2W76XS66FZ2S325000002.039484103587724.608381
    18
    		GDTSI6M3ULRW5EJZSJYRUIHDO3JQXC7HPMXCK5J4NMJLVW7GBABSU33Y308562468.358201101418929.22491
    19
    		GDS3PIPVJCJAJSFSDQDY2BT66ISU6JHXFTBPKFEPO37F5EGT4M6ZNGYE299682711.56158495518307.6933114
    20
    		GC7WKJQQJBKKBFP5YVRWW4KJSNCCLV3DDYOZZ5TLDLEGNSQGXSORJZQG264111940.27966186382211.9341345
    ...
    1000
    92KB
    99s