flipside

    Ronin Price
    SandeshRonin Price
    Updated 2025-03-10
    select * from ronin.price.fact_prices_ohlc_hourly
    where asset_id='ronin'
    and date_trunc('month',hour)='2025-02-01'

    Last run: 11 days ago
    ASSET_ID
    HOUR
    OPEN
    HIGH
    LOW
    CLOSE
    PROVIDER
    FACT_PRICES_OHLC_HOURLY_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		ronin2025-02-05 23:00:00.0001.0121.0121.0061.006coingecko9ab3dc5525b4b81abebad8ec982df3192025-02-06 23:30:15.2212025-02-06 23:30:15.221
    2
    		ronin2025-02-06 09:00:00.0001.0451.0461.0431.043coingecko8f1122dcd9c2b9b182041834f7efd8e02025-02-07 10:30:36.4352025-02-07 10:30:36.435
    3
    		ronin2025-02-06 08:00:00.0001.0471.0471.0451.045coingeckoc1e7eeafb4e1144ae7155a35bd7ea8d22025-02-07 08:30:43.2822025-02-07 08:30:43.282
    4
    		ronin2025-02-06 11:00:00.0001.0441.0441.0421.043coingecko54d9042791484e8d96b07a39f83988792025-02-07 11:30:45.7502025-02-07 11:30:45.750
    5
    		ronin2025-02-06 15:00:00.0001.0331.0371.0271.028coingeckofbccf4896d21243b86a1bc44b9828c6e2025-02-07 15:30:45.0692025-02-07 15:30:45.069
    6
    		ronin2025-02-06 16:00:00.0001.0291.0291.0121.012coingecko1e5282e0e20fb9255b3654ba1fc536c72025-02-07 16:30:26.6212025-02-07 16:30:26.621
    7
    		ronin2025-02-06 04:00:00.0001.0471.061.0471.057coingeckofb7731efa0651bf6bceb15772a28b9122025-02-07 03:30:12.4682025-02-07 03:30:12.468
    8
    		ronin2025-02-06 00:00:00.0001.0081.0171.0061.017coingecko91bcf88b9bbf3db38837978d413bcd532025-02-07 00:30:43.1632025-02-07 00:30:43.163
    9
    		ronin2025-02-06 20:00:00.0001.0361.0381.0341.036coingeckof5acca873ed4dc3662a6d1d37e0ca4ce2025-02-07 20:30:17.2082025-02-07 20:30:17.208
    10
    		ronin2025-02-06 02:00:00.0001.0241.0261.0231.026coingecko899408d9cbc89a16e0e846c9e61e04662025-02-07 02:30:17.7322025-02-07 02:30:17.732
    11
    		ronin2025-02-06 07:00:00.0001.0531.0581.0521.052coingeckoe687a34d3c1ce03601a267b86465b4012025-02-07 07:30:30.3532025-02-07 07:30:30.353
    12
    		ronin2025-02-06 14:00:00.0001.0331.0411.0331.039coingecko5a966a6c989ea1b404b3dfdbaf71c14a2025-02-07 14:30:19.5732025-02-07 14:30:19.573
    13
    		ronin2025-02-06 01:00:00.0001.021.021.0181.018coingecko733d0c76ac43ce096884b6ea1a119ad82025-02-07 01:30:32.8192025-02-07 01:30:32.819
    14
    		ronin2025-02-06 12:00:00.0001.0381.0381.0311.031coingeckof1008e5c4df39b4d91d28d239a16f1d62025-02-07 13:30:25.0962025-02-07 13:30:25.096
    15
    		ronin2025-02-06 22:00:00.0001.0321.0341.0311.031coingeckoe74d64ddcd395e9d377234ec736217ba2025-02-07 22:33:43.1182025-02-07 22:33:43.118
    16
    		ronin2025-02-06 23:00:00.0001.0271.0351.0271.035coingecko5afc4f834797238f4bb4870e0648bf252025-02-07 23:30:42.4072025-02-07 23:30:42.407
    17
    		ronin2025-02-06 10:00:00.0001.0431.0481.0431.048coingecko262e23063c46d00d6ef7c15ef91b76212025-02-07 11:30:45.7502025-02-07 11:30:45.750
    18
    		ronin2025-02-06 05:00:00.0001.0641.0641.0591.059coingecko6c7d4bcc33d2d89be9221cb9853ab7f82025-02-07 03:30:12.4682025-02-07 03:30:12.468
    19
    		ronin2025-02-06 18:00:00.0001.0241.031.0221.024coingecko1a0cc238148a9dda49940bacbfcda7e82025-02-07 19:30:43.7022025-02-07 19:30:43.702
    20
    		ronin2025-02-06 03:00:00.0001.0381.0441.0381.044coingeckoe1db66ddfe0fce14b3f191bf8d29110f2025-02-07 03:30:12.4682025-02-07 03:30:12.468
    ...
    672
    103KB
    2s