flipside

    THORchain Module Balances
    pietrektTHORchain Module Balances
    Updated 10 hours ago
    -- RESERVE MODULE
    WITH from_transactions_reserve_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / POWER(10, 8) * (-1) as amount FROM thorchain.core.fact_transfer_events as c1 WHERE
    (c1.from_address = 'thor1dheycdevq39qlkxs2a6wuuzyn4aqxhve4qxtxt' or c1.from_address = 'thor1lj62pg6ryxv2htekqx04nv7wd3g98qf9gfvamy') AND c1.asset = 'THOR.RUNE' ORDER BY date),

    to_transactions_reserve_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / POWER(10, 8) as amount FROM thorchain.core.fact_transfer_events as c1 WHERE
    (c1.to_address = 'thor1dheycdevq39qlkxs2a6wuuzyn4aqxhve4qxtxt' or c1.to_address = 'thor1lj62pg6ryxv2htekqx04nv7wd3g98qf9gfvamy') AND c1.asset = 'THOR.RUNE' ORDER BY date),

    transactions_all_reserve_module AS (SELECT * FROM from_transactions_reserve_module UNION ALL SELECT * FROM to_transactions_reserve_module),

    daily_balance_change_reserve_module AS (SELECT date, SUM(amount) as change, ROW_NUMBER() OVER(ORDER BY date) as rownum FROM transactions_all_reserve_module GROUP BY date ORDER BY date),

    balance_reserve_module AS (SELECT date, (SELECT SUM(change) FROM daily_balance_change_reserve_module as c2 WHERE c2.rownum <= c1.rownum) as balance FROM daily_balance_change_reserve_module as c1 ORDER BY date),

    -- BOND MODULE
    from_transactions_bond_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / POWER(10, 8) * (-1) as amount FROM thorchain.core.fact_transfer_events as c1 WHERE c1.from_address = 'thor17gw75axcnr8747pkanye45pnrwk7p9c3cqncsv' AND c1.asset = 'THOR.RUNE' ORDER BY date),

    to_transactions_bond_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / POWER(10, 8) as amount FROM thorchain.core.fact_transfer_events c1 WHERE c1.to_address = 'thor17gw75axcnr8747pkanye45pnrwk7p9c3cqncsv' AND c1.asset = 'THOR.RUNE' ORDER BY date),

    transactions_all_bond_module AS (SELECT * FROM from_transactions_bond_module UNION ALL SELECT * FROM to_transactions_bond_module),

    daily_balance_change_bond_module AS (SELECT date, SUM(amount) as change, ROW_NUMBER() OVER(ORDER BY date) as rownum FROM transactions_all_bond_module GROUP BY date ORDER BY date),

    balance_bond_module AS (SELECT date, (SELECT SUM(change) FROM daily_balance_change_bond_module as c2 WHERE c2.rownum <= c1.rownum) as balance FROM daily_balance_change_bond_module as c1 ORDER BY date),

    -- POOL MODULE
    from_transactions_pool_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / POWER(10, 8) * (-1) as amount FROM thorchain.core.fact_transfer_events as c1 WHERE c1.from_address = 'thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0' AND c1.asset = 'THOR.RUNE' ORDER BY date),

    to_transactions_pool_module AS (SELECT to_date(block_timestamp) as date, amount_e8 / POWER(10, 8) as amount FROM thorchain.core.fact_transfer_events as c1 WHERE c1.to_address = 'thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0' AND c1.asset = 'THOR.RUNE' ORDER BY date),

    transactions_all_pool_module AS (SELECT * FROM from_transactions_pool_module UNION ALL SELECT * FROM to_transactions_pool_module),

    daily_balance_change_pool_module AS (SELECT date, SUM(amount) as change, ROW_NUMBER() OVER(ORDER BY date) as rownum FROM transactions_all_pool_module GROUP BY date ORDER BY date),

    balance_pool_module AS (SELECT date, (SELECT SUM(change) FROM daily_balance_change_pool_module as c2 WHERE c2.rownum <= c1.rownum) as balance FROM daily_balance_change_pool_module as c1 ORDER BY date),

    Last run: about 10 hours agoAuto-refreshes every 24 hours
    DAY
    RESERVE_MODULE_BALANCE
    BOND_MODULE_BALANCE
    POOL_MODULE_BALANCE
    RESERVE_MODULE_BALANCE_USD
    BOND_MODULE_BALANCE_USD
    POOL_MODULE_BALANCE_USD
    1
    		2025-06-13 00:00:00.00074216310.0348303115107867.01861248218121.933917
    2
    		2025-06-12 00:00:00.00074215656.0149955115092920.26917847767340.6410196
    3
    		2025-06-11 00:00:00.00074215132.972242115178072.32634446814675.4619296
    4
    		2025-06-10 00:00:00.00074213163.0130529115462737.06690646154106.2652063
    5
    		2025-06-09 00:00:00.00074208651.1910276115310366.53060446214335.5488639
    6
    		2025-06-08 00:00:00.00074207144.8349254115037063.33026446831066.4103561
    7
    		2025-06-07 00:00:00.00074206195.8358005115117596.46937346823194.2745328
    8
    		2025-06-06 00:00:00.00074203459.5597943114715075.4563747306209.6319682
    9
    		2025-06-05 00:00:00.00074206648.3945276115233182.97735547330413.6106284121055779.080939187983732.49705977211681.4034719
    10
    		2025-06-04 00:00:00.00074205035.2784557115537908.77459746924875.2380392124231596.562015193429715.60680478560061.9610172
    11
    		2025-06-03 00:00:00.00074203718.648142115422293.53759746284935.8568582126981113.536633197516399.81621379205096.4850487
    12
    		2025-06-02 00:00:00.00074201810.9138209115649020.01781145844553.2658914123917024.226081193133863.42974476560403.9540385
    13
    		2025-06-01 00:00:00.00074199641.0705658114539367.02293845812790.7304018123109571.142914190039899.78555776011055.2868583
    14
    		2025-05-31 00:00:00.00074197801.0025031114497763.32344946345713.5234536121498899.141599187490087.44214875891105.8946552
    15
    		2025-05-30 00:00:00.00074193830.9196921114433582.58521646357299.4609713130581142.418658201403105.34998181588847.0513095
    16
    		2025-05-29 00:00:00.00074192036.9413896113707753.44152644536682.3649115140593910.003933215476192.77169184397013.0815073
    17
    		2025-05-28 00:00:00.00074190526.2900896112194575.20248643936239.2514583144300573.634224218218448.76883685455985.3440865
    18
    		2025-05-27 00:00:00.00074195210.0324526111411984.44178543677198.7945914144031451.475499216278514.79761584788362.1600005
    19
    		2025-05-26 00:00:00.00074193153.2157137112058936.00492643991709.6980034146438736.159515221176324.93972386828637.0164342
    20
    		2025-05-25 00:00:00.00074191186.9020842111996697.58035643197121.5073557138459302.556015209013836.85933980616628.0131025
    ...
    1503
    189KB
    17s