Dev Fund Earnings

pietrektDev Fund Earnings

Updated 8 hours ago

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: about 8 hours agoAuto-refreshes every 24 hours

...

256

14KB

flipside