DAY | CHANGE | CHANGE_CUMULATIVE | |
|---|---|---|---|
1 | 2025-05-30 00:00:00.000 | 1374.018 | 1767289.442668 |
2 | 2025-05-29 00:00:00.000 | 1757.687934 | 1765915.424668 |
3 | 2025-05-28 00:00:00.000 | 2112.02462 | 1764157.736734 |
4 | 2025-05-27 00:00:00.000 | 2043.404579 | 1762045.712114 |
5 | 2025-05-26 00:00:00.000 | 1760.057784 | 1760002.307535 |
6 | 2025-05-25 00:00:00.000 | 1984.352795 | 1758242.249751 |
7 | 2025-05-24 00:00:00.000 | 1664.33474 | 1756257.896956 |
8 | 2025-05-23 00:00:00.000 | 1706.764342 | 1754593.562216 |
9 | 2025-05-22 00:00:00.000 | 4824.45305 | 1752886.797874 |
10 | 2025-05-21 00:00:00.000 | 4616.429703 | 1748062.344824 |
11 | 2025-05-20 00:00:00.000 | 1935.486132 | 1743445.915121 |
12 | 2025-05-19 00:00:00.000 | 3279.703353 | 1741510.428989 |
13 | 2025-05-18 00:00:00.000 | 2111.332159 | 1738230.725636 |
14 | 2025-05-17 00:00:00.000 | 1725.961541 | 1736119.393477 |
15 | 2025-05-16 00:00:00.000 | 1753.846589 | 1734393.431936 |
16 | 2025-05-15 00:00:00.000 | 1449.656694 | 1732639.585347 |
17 | 2025-05-14 00:00:00.000 | 1605.922649 | 1731189.928653 |
18 | 2025-05-13 00:00:00.000 | 2458.51052 | 1729584.006004 |
19 | 2025-05-12 00:00:00.000 | 2754.931111 | 1727125.495484 |
20 | 2025-05-11 00:00:00.000 | 2325.646019 | 1724370.564373 |
pietrektDev Fund Earnings
Updated 12 minutes ago
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
›
⌄
WITH from_transactions_dev_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / 1e8 * (-1) as amount
FROM thorchain.core.fact_transfer_events as c1
WHERE
(c1.from_address = 'thor1d8c0wv4y72kmlytegjmgx825xwumt9qt5xe07k'
or c1.from_address = 'thor1d8c0wv4y72kmlytegjmgx825xwumt9qt5xe07k')
AND c1.asset = 'THOR.RUNE' ORDER BY date),
to_transactions_dev_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / 1e8 as amount
FROM thorchain.core.fact_transfer_events as c1
WHERE
(c1.to_address = 'thor1d8c0wv4y72kmlytegjmgx825xwumt9qt5xe07k'
or c1.to_address = 'thor1d8c0wv4y72kmlytegjmgx825xwumt9qt5xe07k')
AND c1.asset = 'THOR.RUNE' ORDER BY date),
transactions_all_dev_module AS (SELECT * FROM from_transactions_dev_module UNION ALL SELECT *
FROM to_transactions_dev_module),
daily_balance_change_dev_module AS (SELECT date, SUM(amount) as change, ROW_NUMBER() OVER(ORDER BY date) as rownum
FROM transactions_all_dev_module GROUP BY date ORDER BY date)
SELECT date as day,
change,
(SELECT SUM(change) FROM daily_balance_change_dev_module as c2 WHERE c2.rownum <= c1.rownum)
as change_cumulative
FROM daily_balance_change_dev_module as c1 ORDER BY day desc
Last run: 12 minutes agoAuto-refreshes every 24 hours
...
248
13KB
3s