Sbhn_NPdrab-aquamarine
    Updated 2025-03-04
    WITH
    address AS (
    SELECT day, a.OP_SOURCE_ACCOUNT, balance
    FROM (
    SELECT
    closed_at AS day,
    OP_SOURCE_ACCOUNT,
    MAX(closed_at) AS latest_time
    FROM stellar.core.ez_operations
    WHERE asset_issuer = 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'
    AND asset_code = 'BENJI'
    AND type_string = 'change_trust'
    GROUP BY 1,2
    ) a
    LEFT JOIN stellar.core.fact_accounts b
    ON a.OP_SOURCE_ACCOUNT = b.ACCOUNT_ID
    AND a.latest_time = b.closed_at
    AND a.asset_issuer = 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'
    AND a.asset_code = 'BENJI'
    AND a.type_string = 'change_trust'
    ),

    days AS (
    SELECT
    DATEADD(DAY, ROW_NUMBER() OVER (), '2008-01-01') AS day
    FROM TABLE(GENERATOR(ROWCOUNT => 20000)) -- Generate 20,000 rows for enough days
    ),




    raw AS (
    SELECT day, address
    FROM (
    SELECT DISTINCT OP_SOURCE_ACCOUNT AS address FROM address
    ), days
    Last run: 18 days ago
    ACCOUNT_ID
    BALANCE
    1
    1145516829.63298
    2
    GDRAWRXFCGCBNE6KWKGYM2VGXBPMBIZZ2VDARWQV7FLGA3OASBXZRVVJ-0.0028321
    3
    GCSRBQQPOX553BXF5KWMK5SGBOQTP5B5XVDQOFEDIY5FH77ZAACC56HS-0.0028355
    4
    GCHZGQW3F7OXFIXOW5LYDRX3TU526PMLMSR7IEZNOB7Z5KKIKN45D34Z-0.0028371
    5
    GCM3YUM6F776KO6QFRXG3YYQ4W72U4FJDH33422B2PFBSE44XVNMOWQ3-0.0028394
    6
    GDXY4QXYKOBLS5QGPM3WH3GMVKRUF7EIDESP35RQU6NSIOBEMYPN7T3R-0.0028453
    7
    GCONCCFI3N5SHMOXRFAFMENAG4N2DJCEV6VKPMBOJRTM5WTDPYZFWD34-0.0029182
    8
    GBAT3ILHPL2WMKV4BWT3FD6MTLGMEPGHMI5ITFE452ML3ZMPEL7OF3LX-0.0029611
    9
    GALMAU6SEBHUHX7GY43V7XOBZXIZRVMYOJQSZP26DRNBL7TDMJWOYMX6-0.0030228
    10
    GBPFVL36TDVC5FN6QLKLFK3ZZY2J5ROC26S67ZZGJVN72RIVXA7LXQCE-0.0045044
    11
    GAA3MTRGTHYSMMXYFEWJZZEJ7E7EKGMEZXG7MPRSVMXFDQKT5C4AKVCY-0.0056744
    12
    GDLEANAXOBYFJLIYPBAZG5K4FTJVBW654P37WD4QXW5SGFEWTGRVU73T-0.0065227
    13
    GBU6JEF5RCI4EUYN5SAOU36TGGZ6ZBRYGH4M6527CGSQAIL5DD5JIWDG-0.0069011
    14
    GAQ4WO352HJURXU6HRYHRJSR275H6RZVUSOH6Y2ORBZHTG7K6ZOZ3KPN-0.0070829
    15
    GDXHULBVZEMNV7Q4X52PARBFSUVZTBMV6UCWHEV6G2BQIPGRMSFYBC4A-0.0073233
    16
    GARJ4LCJ4GMJ6HSPVNVTAKS7L7UZMSS5LOH3CU5KPQVS6NQOZG2T2AJG-0.0073451
    17
    GDB6N6R2UVW66UFQY2VK4F6SS4IXQVH272UP2ATMMH75Z7WKG7BPAPIN-0.0114285
    18
    GBCHNBB6IPCBCF5XNWABB5OVOGFXUGC7Y5SR7KHC2NMPERN3VNXVNAH2-0.0122201
    19
    GCIMT3GTRTRLEHGW5WJYF4NQIYI36YWFGH3V77SZUI7BJQTC7OPAQAXJ-0.0132063
    20
    GBVIBPPJNFKEVGRORTAWQQMDDNWRLPJ7ND46NB3422MOPYV7M27D427C-0.0136768
    ...
    199
    14KB
    9s