PREVIEW / futures_1hour / 2024-12-17
file: by_date/futures_1hour/2024/2024-12-17.parquet size: 65 KB rows: 2,079
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-12-17 00:00:00 | ES | Futures | 6306.12 | 6306.63 | 6302.79 | 6303.3 | 2634.0 |
| 2024-12-17 01:00:00 | ES | Futures | 6303.3 | 6304.07 | 6297.15 | 6298.94 | 4001.0 |
| 2024-12-17 02:00:00 | ES | Futures | 6298.94 | 6300.48 | 6291.51 | 6292.53 | 7058.0 |
| 2024-12-17 03:00:00 | ES | Futures | 6292.28 | 6293.81 | 6288.94 | 6289.71 | 11185.0 |
| 2024-12-17 04:00:00 | ES | Futures | 6289.46 | 6295.35 | 6289.2 | 6295.35 | 10968.0 |
| 2024-12-17 05:00:00 | ES | Futures | 6295.61 | 6296.38 | 6291.25 | 6295.35 | 6348.0 |
| 2024-12-17 06:00:00 | ES | Futures | 6295.61 | 6299.71 | 6290.74 | 6293.04 | 10983.0 |
| 2024-12-17 07:00:00 | ES | Futures | 6293.3 | 6295.61 | 6287.92 | 6287.92 | 16961.0 |
| 2024-12-17 08:00:00 | ES | Futures | 6288.17 | 6288.94 | 6281.25 | 6288.17 | 34339.0 |
| 2024-12-17 09:00:00 | ES | Futures | 6287.92 | 6291.51 | 6277.66 | 6285.87 | 161161.0 |
| 2024-12-17 10:00:00 | ES | Futures | 6285.87 | 6286.12 | 6273.05 | 6281.51 | 187031.0 |
| 2024-12-17 11:00:00 | ES | Futures | 6281.51 | 6294.84 | 6280.48 | 6292.28 | 155239.0 |
| 2024-12-17 12:00:00 | ES | Futures | 6292.28 | 6292.79 | 6284.84 | 6290.74 | 89326.0 |
| 2024-12-17 13:00:00 | ES | Futures | 6290.74 | 6290.99 | 6282.53 | 6285.35 | 72973.0 |
| 2024-12-17 14:00:00 | ES | Futures | 6285.1 | 6285.87 | 6274.59 | 6275.87 | 89035.0 |
| 2024-12-17 15:00:00 | ES | Futures | 6275.87 | 6289.71 | 6270.23 | 6284.07 | 210879.0 |
| 2024-12-17 16:00:00 | ES | Futures | 6284.07 | 6287.15 | 6278.17 | 6282.02 | 57631.0 |
| 2024-12-17 18:00:00 | ES | Futures | 6283.05 | 6284.07 | 6269.46 | 6279.71 | 10041.0 |
| 2024-12-17 19:00:00 | ES | Futures | 6279.97 | 6284.07 | 6279.2 | 6282.53 | 3521.0 |
| 2024-12-17 20:00:00 | ES | Futures | 6282.53 | 6289.97 | 6282.53 | 6289.71 | 4988.0 |
| 2024-12-17 21:00:00 | ES | Futures | 6289.71 | 6291.76 | 6289.46 | 6290.99 | 3711.0 |
| 2024-12-17 22:00:00 | ES | Futures | 6291.25 | 6291.76 | 6285.61 | 6286.89 | 3703.0 |
| 2024-12-17 23:00:00 | ES | Futures | 6286.89 | 6293.3 | 6286.89 | 6292.79 | 3091.0 |
| 2024-12-17 00:00:00 | NQ | Futures | 23074.22 | 23077.56 | 23059.55 | 23064.18 | 1404.0 |
| 2024-12-17 01:00:00 | NQ | Futures | 23064.44 | 23069.07 | 23043.08 | 23049.26 | 1848.0 |
| 2024-12-17 02:00:00 | NQ | Futures | 23049.51 | 23059.29 | 22992.64 | 22997.27 | 4664.0 |
| 2024-12-17 03:00:00 | NQ | Futures | 22998.04 | 23025.58 | 22982.09 | 22996.24 | 5808.0 |
| 2024-12-17 04:00:00 | NQ | Futures | 22996.76 | 23053.12 | 22992.38 | 23047.71 | 5708.0 |
| 2024-12-17 05:00:00 | NQ | Futures | 23047.97 | 23069.33 | 23031.76 | 23066.75 | 4419.0 |
| 2024-12-17 06:00:00 | NQ | Futures | 23065.73 | 23084.51 | 23032.27 | 23047.45 | 5934.0 |
| 2024-12-17 07:00:00 | NQ | Futures | 23047.71 | 23056.72 | 23005.25 | 23006.54 | 6931.0 |
| 2024-12-17 08:00:00 | NQ | Futures | 23006.79 | 23023.52 | 22979.51 | 23009.62 | 15371.0 |
| 2024-12-17 09:00:00 | NQ | Futures | 23009.37 | 23027.12 | 22934.22 | 22962.53 | 82992.0 |
| 2024-12-17 10:00:00 | NQ | Futures | 22961.5 | 22974.11 | 22897.94 | 22963.82 | 83747.0 |
| 2024-12-17 11:00:00 | NQ | Futures | 22963.82 | 23043.85 | 22938.08 | 22998.3 | 58937.0 |
| 2024-12-17 12:00:00 | NQ | Futures | 22997.53 | 23015.54 | 22953.01 | 22997.27 | 41170.0 |
| 2024-12-17 13:00:00 | NQ | Futures | 22997.27 | 23005.25 | 22959.7 | 22963.82 | 29003.0 |
| 2024-12-17 14:00:00 | NQ | Futures | 22964.07 | 22966.39 | 22921.87 | 22936.02 | 31755.0 |
| 2024-12-17 15:00:00 | NQ | Futures | 22935.77 | 22986.98 | 22907.71 | 22971.02 | 49284.0 |
| 2024-12-17 16:00:00 | NQ | Futures | 22971.02 | 22974.37 | 22940.4 | 22960.21 | 13455.0 |
| 2024-12-17 18:00:00 | NQ | Futures | 22964.85 | 22964.85 | 22858.56 | 22928.82 | 7559.0 |
| 2024-12-17 19:00:00 | NQ | Futures | 22928.82 | 22953.01 | 22925.99 | 22940.66 | 2595.0 |
| 2024-12-17 20:00:00 | NQ | Futures | 22940.91 | 22977.97 | 22940.91 | 22977.46 | 2885.0 |
| 2024-12-17 21:00:00 | NQ | Futures | 22977.46 | 22986.72 | 22976.17 | 22979.77 | 1857.0 |
| 2024-12-17 22:00:00 | NQ | Futures | 22979.51 | 22980.8 | 22954.81 | 22964.59 | 2430.0 |
| 2024-12-17 23:00:00 | NQ | Futures | 22964.07 | 22996.5 | 22964.07 | 22991.87 | 2443.0 |
| 2024-12-17 00:00:00 | YM | Futures | 45511.1 | 45519.3 | 45477.1 | 45481.2 | 644.0 |
| 2024-12-17 01:00:00 | YM | Futures | 45481.2 | 45488.4 | 45433.9 | 45448.3 | 791.0 |
| 2024-12-17 02:00:00 | YM | Futures | 45450.3 | 45454.4 | 45408.1 | 45415.3 | 935.0 |
| 2024-12-17 03:00:00 | YM | Futures | 45414.3 | 45422.5 | 45370.0 | 45377.3 | 1561.0 |
> showing 50 of 2,079 rows — these rows as CSV