flipside

    rune distribution
    pietrektrune distribution
    Updated 1 hour 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 1 hour agoAuto-refreshes every 24 hours
    DAY
    RICH_COUNT_100K
    RICH_COUNT_10K
    RICH_COUNT_1K
    RICH_COUNT_100
    1
    		2025-04-20 00:00:00.000158978485215716
    2
    		2025-04-19 00:00:00.000159978484715710
    3
    		2025-04-18 00:00:00.000158983484915715
    4
    		2025-04-17 00:00:00.000158984484815714
    5
    		2025-04-16 00:00:00.000158983485515716
    6
    		2025-04-15 00:00:00.000155987486815717
    7
    		2025-04-14 00:00:00.000159979486215705
    8
    		2025-04-13 00:00:00.000157977486115715
    9
    		2025-04-12 00:00:00.000157981485915717
    10
    		2025-04-11 00:00:00.000155978485215706
    11
    		2025-04-10 00:00:00.000155980485315698
    12
    		2025-04-09 00:00:00.000155983485315708
    13
    		2025-04-08 00:00:00.000154985486915727
    14
    		2025-04-07 00:00:00.000154987486615715
    15
    		2025-04-06 00:00:00.000158992488215733
    16
    		2025-04-05 00:00:00.000156991488215730
    17
    		2025-04-04 00:00:00.000158994488315723
    18
    		2025-04-03 00:00:00.000154988486815709
    19
    		2025-04-02 00:00:00.000155992486915710
    20
    		2025-04-01 00:00:00.000154991487615716
    ...
    1449
    66KB
    18s