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 |
Sbhn_NPdrab-aquamarine
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
...
199
14KB
9s