flipside

    Total Balance by Asset Over Time
    RayyykTotal Balance by Asset Over Time
    Updated 14 hours ago
    with date_range as (select min(date_trunc('week', block_date)) as start_week,
    max(date_trunc('week', block_date)) as end_week
    from thorchain.core.dim_block),

    weeks as (select start_week as week
    from date_range
    union all
    select dateadd(week, 1, week)
    from weeks
    join date_range on weeks.week < date_range.end_week),

    assets AS (select distinct asset
    from thorchain.core.fact_transfer_events
    where to_address in ('thor1crs0y53jfg224mettqeg883e6ume49tllktg2s', --new
    'thor1xmaggkcln5m5fnha2780xrdrulmplvfrz6wj3l') --old
    union
    select asset
    from thorchain.core.fact_transfer_events
    where from_address in ('thor1crs0y53jfg224mettqeg883e6ume49tllktg2s', --new
    'thor1xmaggkcln5m5fnha2780xrdrulmplvfrz6wj3l')), --old

    complete_weeks_assets AS (select week,
    asset
    from weeks b
    cross join assets a),

    inflow_tokens as (select date_trunc('week', block_timestamp) as week,
    asset,
    sum(amount_e8/1e8) as inflow_amount
    from thorchain.core.fact_transfer_events
    where to_address in ('thor1crs0y53jfg224mettqeg883e6ume49tllktg2s', --new
    'thor1xmaggkcln5m5fnha2780xrdrulmplvfrz6wj3l') --old
    group by 1,2),

    outflow_tokens as (select date_trunc('week', block_timestamp) as week,
    asset,
    Last run: about 14 hours agoAuto-refreshes every 24 hours
    DATE
    ASSET
    RUNE_PRICE
    RUNE_AMOUNT
    BALANCE_USD
    PREVIOUS_WEEK_AMOUNT
    RUNE_AMOUNT_CHANGE
    % in Amount Change
    START_DATE
    END_DATE
    1
    		2025-05-05 00:00:00.000THOR.RUNE1.2560781010.9810211.2322389950.9810210001/01/20242025-05-05 00:00:00.000
    2
    		2025-04-28 00:00:00.000THOR.RUNE1.258042980.9810211.2341665830.9810210001/01/20242025-05-05 00:00:00.000
    3
    		2025-04-21 00:00:00.000THOR.RUNE1.3257657380.9810211.300604030.9810210001/01/20242025-05-05 00:00:00.000
    4
    		2025-04-14 00:00:00.000THOR.RUNE1.2073148270.9810211.1844011990.9810210001/01/20242025-05-05 00:00:00.000
    5
    		2025-04-07 00:00:00.000THOR.RUNE1.1392999460.9810211.1176771720.9810210001/01/20242025-05-05 00:00:00.000
    6
    		2025-03-31 00:00:00.000THOR.RUNE1.0400471530.9810211.0203080980.9810210001/01/20242025-05-05 00:00:00.000
    7
    		2025-03-24 00:00:00.000THOR.RUNE1.1268366560.9810211.1054504230.9810210001/01/20242025-05-05 00:00:00.000
    8
    		2025-03-17 00:00:00.000THOR.RUNE1.2810456970.9810211.2567327310.9810210001/01/20242025-05-05 00:00:00.000
    9
    		2025-03-10 00:00:00.000THOR.RUNE1.1488988710.9810211.12709391979831.791241-79830.81022-99.998771139901/01/20242025-05-05 00:00:00.000
    10
    		2025-03-03 00:00:00.000THOR.RUNE1.21532338179831.79124197021.44247258668575.03470711256.75653416.415240009901/01/20242025-05-05 00:00:00.000
    11
    		2025-02-24 00:00:00.000THOR.RUNE1.39890165668575.03470795929.72959267940163.05219228411.98251570.741591996501/01/20242025-05-05 00:00:00.000
    12
    		2025-02-17 00:00:00.000THOR.RUNE1.40698219540163.05219256508.69933726444786.138312-4623.08612-10.322582598601/01/20242025-05-05 00:00:00.000
    13
    		2025-02-10 00:00:00.000THOR.RUNE1.25670400244786.13831256282.91926720431503.99694913282.14136342.160178546601/01/20242025-05-05 00:00:00.000
    14
    		2025-02-03 00:00:00.000THOR.RUNE1.25252413931503.99694939459.51666466527319.4327954184.56415415.317170694601/01/20242025-05-05 00:00:00.000
    15
    		2025-01-27 00:00:00.000THOR.RUNE1.33627337127319.43279536506.230544078112646.424191-85326.991396-75.747625376301/01/20242025-05-05 00:00:00.000
    16
    		2025-01-20 00:00:00.000THOR.RUNE2.517210456112646.424191283554.756812466107793.0725254853.3516664.502470847401/01/20242025-05-05 00:00:00.000
    17
    		2025-01-13 00:00:00.000THOR.RUNE3.288901107107793.072525354520.755558576112171.402456-4378.329931-3.90324970101/01/20242025-05-05 00:00:00.000
    18
    		2025-01-06 00:00:00.000THOR.RUNE3.37058657112171.402456378083.422659681105139.7081387031.6943186.687953050801/01/20242025-05-05 00:00:00.000
    19
    		2024-12-30 00:00:00.000THOR.RUNE4.931535358105139.708138518500.188184777104328.987947810.7201910.777080471101/01/20242025-05-05 00:00:00.000
    20
    		2024-12-23 00:00:00.000THOR.RUNE4.577299908104328.987947477545.066917273104550.823523-221.835576-0.212179654401/01/20242025-05-05 00:00:00.000
    71
    11KB
    75s