flipside

    Exchange balance change
    pietrektExchange balance change
    Updated 6 hours ago
    -- bybit
    WITH from_transactions_bybit AS (
    SELECT
    to_date(block_timestamp) as date,
    amount_e8 * (-1) as amount
    FROM
    thorchain.core.fact_transfer_events as c1
    WHERE
    c1.from_address = 'thor1mtqtupwgjwn397w3dx9fqmqgzrfzq3240frash'
    AND c1.asset = 'THOR.RUNE'
    ORDER BY
    date
    ),
    to_transactions_bybit AS (
    SELECT
    to_date(block_timestamp) as date,
    amount_e8 as amount
    FROM
    thorchain.core.fact_transfer_events as c1
    WHERE
    c1.to_address = 'thor1mtqtupwgjwn397w3dx9fqmqgzrfzq3240frash'
    AND c1.asset = 'THOR.RUNE'
    ORDER BY
    date
    ),
    transactions_all_bybit AS (
    SELECT
    *
    FROM
    from_transactions_bybit
    UNION
    ALL
    SELECT
    *
    FROM
    to_transactions_bybit
    Last run: about 6 hours agoAuto-refreshes every 24 hours
    DAY
    BYBIT_BALANCE
    BINANCE_BALANCE
    KUCOIN_BALANCE
    KRAKEN_BALANCE
    TOTAL_BALANCE
    1
    		2025-06-12 00:00:00.0006527042.18162458800071.2106422318413.1172342663890.67105170309417.180551
    2
    		2025-06-11 00:00:00.0006528239.18444459275206.1575262318413.1172342643435.88336170765294.342565
    3
    		2025-06-10 00:00:00.0006526059.40146859695025.7316612318413.1172342641305.49339671180803.743759
    4
    		2025-06-09 00:00:00.0006511289.25757859128588.9578282318413.1172342640683.2390370598974.57167
    5
    		2025-06-08 00:00:00.0006508869.44554258626217.5567732318413.1172342620753.07229770074253.191846
    6
    		2025-06-07 00:00:00.0006510960.38672258884362.4782772318413.1172342628768.30511470342504.287347
    7
    		2025-06-06 00:00:00.0006515764.4281759155996.1680252318413.1172342623924.83714270614098.550571
    8
    		2025-06-05 00:00:00.0006522768.59106658582183.1461022318413.1172342571120.53767269994485.392074
    9
    		2025-06-04 00:00:00.0006611371.41658559135684.915892318413.1172342659347.01198970724816.461698
    10
    		2025-06-03 00:00:00.0006644967.15655459820690.7663432318413.1172342606439.71945571390510.759586
    11
    		2025-06-02 00:00:00.0006646639.44043859779330.0713422618413.1352342654181.03632771698563.683341
    12
    		2025-06-01 00:00:00.0006641573.50863659635546.6777682618413.1352342537088.36709671432621.688734
    13
    		2025-05-31 00:00:00.0006656766.55049659637082.9922462618413.1352342551915.10138171464177.779357
    14
    		2025-05-30 00:00:00.0006778575.43545959615679.1067472618413.1352342523174.34840371535842.025843
    15
    		2025-05-29 00:00:00.0006803205.93687160992016.7426172618413.1352342580202.16850872993837.98323
    16
    		2025-05-28 00:00:00.0006855634.07258961293509.0894272618413.1352342552424.98165673319981.278906
    17
    		2025-05-27 00:00:00.0006877764.7975161937191.8547282618413.1352342678036.529574111406.316972
    18
    		2025-05-26 00:00:00.0006880815.56552961455981.8030012618413.1352342712201.67689673667412.18066
    19
    		2025-05-25 00:00:00.0006813387.86314661837226.4384442618413.1352342701404.15394973970431.590773
    20
    		2025-05-24 00:00:00.0006758217.39831761426374.8855422618413.1352342661737.56838473464742.987477
    ...
    1104
    104KB
    8s