flipside

    weusd
    picweweusd
    Updated 2025-04-15

    WITH move_hourly_prices AS (
    SELECT
    hour,
    price AS move_price
    FROM
    ethereum.price.ez_prices_hourly
    WHERE
    token_address = LOWER('0x3073f7aAA4DB83f95e9FFf17424F71D4751a3073')
    AND hour >= '2024-12-09'
    ),

    mint_events AS (
    SELECT
    date_trunc('hour', block_timestamp) AS tx_hour,
    event_data:user::string AS user_address,
    event_data:costMoveAmount::decimal AS move_amount,
    event_data:costStablecoinAmount::decimal AS usdt_amount,
    event_data:weUSDAmount::decimal AS weusd_amount
    FROM movement.core.fact_events
    WHERE event_address = '0xed805e77c40d7e6ac5cd3e67514c485176621a2aa21e860cd515121d44a2f83d'
    AND event_module = 'weusd_operations'
    AND EVENT_RESOURCE = 'MintedWeUSD'
    ),

    redeem_events AS (
    SELECT
    date_trunc('hour', block_timestamp) AS tx_hour,
    event_data:user::string AS user_address,
    event_data:receivedMoveAmount::decimal AS move_amount,
    event_data:receivedStablecoinAmount::decimal AS usdt_amount,
    event_data:weUSDAmount::decimal AS weusd_amount
    FROM movement.core.fact_events
    WHERE event_address = '0xed805e77c40d7e6ac5cd3e67514c485176621a2aa21e860cd515121d44a2f83d'
    AND event_module = 'weusd_operations'
    AND EVENT_RESOURCE = 'BurnedWeUSD'
    Last run: about 2 months ago
    TX_HOUR
    MOVE_PRICE
    MOVE_BALANCE_ACTUAL
    USDT_BALANCE_ACTUAL
    WEUSD_SUPPLY_ACTUAL
    COLLATERAL_VALUE
    WEUSD_PRICE
    COLLATERAL_RATIO_PERCENT
    1
    		2025-04-15 08:00:00.0000.292223108.1835913496.98500514996.6514405258413.72820.960565087196.056508712
    2
    		2025-04-15 07:00:00.0000.2985323108.1835913496.98500514996.6514424877268.54960.961873302996.187330294
    3
    		2025-04-15 06:00:00.0000.2998153108.1835913496.98500514996.6514428865068.09580.962139215696.213921563
    4
    		2025-04-15 05:00:00.0000.304553108.16483413496.98500514996.6514443576605.08810.963120203996.312020385
    5
    		2025-04-15 04:00:00.0000.3095953108.07310913496.98500514996.6514459228899.24590.964163923296.416392323
    6
    		2025-04-15 03:00:00.0000.3019683108.06611413496.98500514996.6514435521513.44220.962583077896.258307778
    7
    		2025-04-15 02:00:00.0000.2939623107.99785413496.98500614996.6514410618271.26930.960922490896.092249077
    8
    		2025-04-15 01:00:00.0000.2981343107.91388913496.98500614996.6514423559805.30260.961785452496.178545244
    9
    		2025-04-15 00:00:00.0000.2983423107.86750513496.98500614996.6514424192413.120.961827635796.182763571
    10
    		2025-04-14 23:00:00.0000.2935393107.80194913496.98500514996.6514409246081.31930.96083099196.083099101
    11
    		2025-04-14 22:00:00.0000.2918773107.70788213496.98500614996.6514404053459.41030.960484738996.048473889
    12
    		2025-04-14 21:00:00.0000.2931423107.56918813496.98500514996.6514407944051.93210.960744169796.074416966
    13
    		2025-04-14 20:00:00.0000.2982063107.48428413496.98500514996.6514423655463.43330.961791831196.179183107
    14
    		2025-04-14 19:00:00.0000.2991233107.33790913496.98500614996.6514426461243.35980.961978924996.197892485
    15
    		2025-04-14 18:00:00.0000.2984123107.26424513496.98500514996.6514424229942.84910.961830138396.183013825
    16
    		2025-04-14 17:00:00.0000.2975573107.2034313496.98500614996.6514421555137.02940.96165177896.165177803
    17
    		2025-04-14 16:00:00.0000.308973107.09354413496.98500714996.6514456983699.28350.964014209896.401420979
    18
    		2025-04-14 15:00:00.0000.3051933106.99485213496.98500714996.6514445218086.96410.963229660496.322966042
    19
    		2025-04-14 14:00:00.0000.3107943106.87620513496.98500614996.6514462583489.35930.964387612596.438761252
    20
    		2025-04-14 13:00:00.0000.3052993106.76587913496.98500614996.6514445477522.16610.9632469696.324695997
    ...
    919
    97KB
    5s