flipside

    rune distribution
    pietrektrune distribution
    Updated 22 hours ago
    WITH transactions AS (SELECT to_address as address, amount_e8 as amount, to_date(block_timestamp) as date FROM thorchain.core.fact_transfer_events as c1 WHERE c1.asset = 'THOR.RUNE' UNION ALL SELECT from_address as address, amount_e8*(-1) as amount, to_date(block_timestamp) as date FROM thorchain.core.fact_transfer_events as c2 WHERE c2.asset = 'THOR.RUNE'),

    daily_change AS (SELECT SUM(amount) as change, date, address FROM transactions GROUP BY date, address ORDER BY date),

    daily_change_indexed AS (SELECT date, address, change, ROW_NUMBER() OVER(PARTITION BY address ORDER BY date) AS rownum FROM daily_change ORDER BY date),

    daily_change_balance AS (SELECT date, address, change, (SELECT SUM(change) FROM daily_change_indexed AS c2 WHERE c2.address = c1.address AND c2.rownum <= c1.rownum) AS balance FROM daily_change_indexed AS c1 ORDER BY date),

    dates AS (SELECT DISTINCT date, 0 as C FROM daily_change_balance ORDER BY date),

    rich_increase AS (SELECT date, COUNT(*) as C FROM daily_change_balance as c1 WHERE c1.balance >= 10000000000 AND c1.balance - c1.change < 10000000000 GROUP BY date ORDER BY date),

    rich_decrease AS (SELECT date, COUNT(*) * (-1) as C FROM daily_change_balance as c1 WHERE c1.balance < 10000000000 AND c1.balance - c1.change >= 10000000000 GROUP BY date ORDER BY date),

    combination AS (SELECT * FROM dates UNION ALL SELECT * FROM rich_increase UNION ALL SELECT * FROM rich_decrease),

    rich_change_indexed AS (SELECT date, SUM(C) AS change, ROW_NUMBER() OVER(ORDER BY date) as rownum FROM combination GROUP BY date ORDER BY date),

    rich_change_100 AS (SELECT date as day, (SELECT SUM(change) FROM rich_change_indexed AS c2 WHERE c2.rownum <= c1.rownum) as rich_count_100 FROM rich_change_indexed c1),
    ----------------------------------
    transactions2 AS (SELECT to_address as address, amount_e8 as amount, to_date(block_timestamp) as date FROM thorchain.core.fact_transfer_events as c1 WHERE c1.asset = 'THOR.RUNE' UNION ALL SELECT from_address as address, amount_e8*(-1) as amount, to_date(block_timestamp) as date FROM thorchain.core.fact_transfer_events as c2 WHERE c2.asset = 'THOR.RUNE'),

    daily_change2 AS (SELECT SUM(amount) as change, date, address FROM transactions2 GROUP BY date, address ORDER BY date),

    daily_change_indexed2 AS (SELECT date, address, change, ROW_NUMBER() OVER(PARTITION BY address ORDER BY date) AS rownum FROM daily_change2 ORDER BY date),

    daily_change_balance2 AS (SELECT date, address, change, (SELECT SUM(change) FROM daily_change_indexed2 AS c2 WHERE c2.address = c1.address AND c2.rownum <= c1.rownum) AS balance FROM daily_change_indexed2 AS c1 ORDER BY date),

    dates2 AS (SELECT DISTINCT date, 0 as C FROM daily_change_balance2 ORDER BY date),

    rich_increase2 AS (SELECT date, COUNT(*) as C FROM daily_change_balance2 as c1 WHERE c1.balance >= 100000000000 AND c1.balance - c1.change < 100000000000 GROUP BY date ORDER BY date),

    rich_decrease2 AS (SELECT date, COUNT(*) * (-1) as C FROM daily_change_balance2 as c1 WHERE c1.balance < 100000000000 AND c1.balance - c1.change >= 100000000000 GROUP BY date ORDER BY date),

    combination2 AS (SELECT * FROM dates2 UNION ALL SELECT * FROM rich_increase2 UNION ALL SELECT * FROM rich_decrease2),
    Last run: about 22 hours agoAuto-refreshes every 24 hours
    DAY
    RICH_COUNT_100K
    RICH_COUNT_10K
    RICH_COUNT_1K
    RICH_COUNT_100
    1
    		2025-06-09 00:00:00.0001591006494015818
    2
    		2025-06-08 00:00:00.0001611016494615835
    3
    		2025-06-07 00:00:00.0001591009493815819
    4
    		2025-06-06 00:00:00.0001581003493015825
    5
    		2025-06-05 00:00:00.0001601005493315840
    6
    		2025-06-04 00:00:00.000157999492515826
    7
    		2025-06-03 00:00:00.0001571003493315833
    8
    		2025-06-02 00:00:00.0001541004493915842
    9
    		2025-06-01 00:00:00.0001581012493915836
    10
    		2025-05-31 00:00:00.0001571008493615815
    11
    		2025-05-30 00:00:00.0001561005492715809
    12
    		2025-05-29 00:00:00.0001581009494315829
    13
    		2025-05-28 00:00:00.0001611015494515821
    14
    		2025-05-27 00:00:00.0001631021495515825
    15
    		2025-05-26 00:00:00.0001581018495915841
    16
    		2025-05-25 00:00:00.0001631022496115842
    17
    		2025-05-24 00:00:00.0001641022496215849
    18
    		2025-05-23 00:00:00.0001621021496115846
    19
    		2025-05-22 00:00:00.0001691017495515836
    20
    		2025-05-21 00:00:00.0001651017495515852
    ...
    1499
    69KB
    34s