flipside

    Price Trend
    feyikemiPrice Trend
    Updated 2025-03-26
    SELECT *
    FROM ronin.price.fact_prices_ohlc_hourly
    WHERE ASSET_ID = 'ronke'

    Last run: about 2 months ago
    ASSET_ID
    HOUR
    OPEN
    HIGH
    LOW
    CLOSE
    PROVIDER
    FACT_PRICES_OHLC_HOURLY_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		ronke2025-03-26 11:00:00.0000.003143340.003151910.003143340.00315137coingecko33719e3a27f378847a627ce3852c30e62025-03-26 12:30:26.6802025-03-26 12:30:26.680
    2
    		ronke2025-03-26 05:00:00.0000.003250060.003253760.003246630.00324663coingeckoe5a7b3eb5b520b44968279e207b426292025-03-26 12:30:26.6802025-03-26 12:30:26.680
    3
    		ronke2025-03-12 23:00:00.0000.005153130.005180520.005122490.00512571coingeckoe0b0c8ab3cc75890184c8fb8a3f77d9a2025-03-13 23:30:24.3452025-03-13 23:30:24.345
    4
    		ronke2025-03-12 18:00:00.0000.005107280.005107280.005051910.00509867coingecko4789212ba77fa1eaa6baa89ec9e462b32025-03-13 19:30:45.5112025-03-13 19:30:45.511
    5
    		ronke2025-03-12 20:00:00.0000.005052160.005052160.004985370.00498537coingecko3bde9543344d9a194512738b96bee1292025-03-13 20:30:18.8422025-03-13 20:30:18.842
    6
    		ronke2025-03-12 22:00:00.0000.005093940.005118550.005024510.00502451coingecko8dec8689257e3ad8c298ec7a9597ffd32025-03-13 22:30:16.1082025-03-13 22:30:16.108
    7
    		ronke2025-03-12 19:00:00.0000.005060510.005074070.005060510.00506457coingecko84d87ba75ad9756a10e5bdcbb4f14f092025-03-13 19:30:45.5112025-03-13 19:30:45.511
    8
    		ronke2025-03-12 21:00:00.0000.005072060.005072060.005020080.00504667coingeckob9cba7884248710af32c93356d692af82025-03-13 21:31:09.5212025-03-13 21:31:09.521
    9
    		ronke2025-03-13 01:00:00.0000.005032220.005032220.005002190.00502099coingecko70045a215d630ada81d8176e03ff77d82025-03-13 23:30:24.3452025-03-13 23:30:24.345
    10
    		ronke2025-03-13 12:00:00.0000.005043010.005043010.004930590.00493059coingecko69ea66a7e4396eb8ae5db717e71b3e512025-03-14 12:30:43.6982025-03-14 12:30:43.698
    11
    		ronke2025-03-13 05:00:00.0000.00482390.004825830.004739110.00479448coingecko906e2f44060db4a7f9fca9d0ff1d8b6f2025-03-14 06:30:26.8722025-03-14 06:30:26.872
    12
    		ronke2025-03-13 17:00:00.0000.00506870.005073160.005035530.00504198coingeckod037f121203850d8f6287d8a761b18742025-03-14 17:30:46.7392025-03-14 17:30:46.739
    13
    		ronke2025-03-13 18:00:00.0000.00503740.00503740.004827950.00484577coingeckoe03d8ff19b989d386fc1dd93dc46d9222025-03-14 19:30:31.1692025-03-14 19:30:31.169
    14
    		ronke2025-03-13 20:00:00.0000.004925140.004934530.00488520.00489696coingecko76615b338f99f9b8dcf648744df65ad52025-03-14 19:30:31.1692025-03-14 19:30:31.169
    15
    		ronke2025-03-13 08:00:00.0000.005025640.00503570.00498040.0049804coingecko8370346eb125a739a70e5692433d15b02025-03-14 09:30:19.1192025-03-14 09:30:19.119
    16
    		ronke2025-03-13 11:00:00.0000.00506650.00506650.004984130.00500664coingecko30bc64c7187c99cc11c8da9e1f76187f2025-03-14 12:30:43.6982025-03-14 12:30:43.698
    17
    		ronke2025-03-13 13:00:00.0000.00497220.00497220.004858860.00485886coingeckoe27693667d695e2a4991e383a926f3d12025-03-14 13:30:36.8042025-03-14 13:30:36.804
    18
    		ronke2025-03-13 04:00:00.0000.004955360.004987280.004898120.00489812coingeckoa103579b9d5870f83841b3d0499a00012025-03-14 04:30:38.7312025-03-14 04:30:38.731
    19
    		ronke2025-03-13 00:00:00.0000.005110870.005139980.005094810.00513998coingecko4446e8616a5feb4bea94535f4e9c41582025-03-13 23:30:24.3452025-03-13 23:30:24.345
    20
    		ronke2025-03-13 16:00:00.0000.005153140.005153140.005086560.00509344coingeckoea7b58ca1a55d49aa16bcf03a6693a712025-03-14 16:30:22.4832025-03-14 16:30:22.483
    ...
    772
    135KB
    2s