PREVIEW / futures_1hour / 2024-01-23
file: by_date/futures_1hour/2024/2024-01-23.parquet size: 68 KB rows: 2,093
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-01-23 00:00:00 | ES | Futures | 5244.5 | 5246.11 | 5243.69 | 5244.5 | 2954.0 |
| 2024-01-23 01:00:00 | ES | Futures | 5244.23 | 5246.65 | 5243.96 | 5245.84 | 3473.0 |
| 2024-01-23 02:00:00 | ES | Futures | 5245.84 | 5248.8 | 5245.84 | 5247.72 | 6349.0 |
| 2024-01-23 03:00:00 | ES | Futures | 5247.45 | 5249.07 | 5239.93 | 5241.28 | 24168.0 |
| 2024-01-23 04:00:00 | ES | Futures | 5241.28 | 5246.11 | 5241.01 | 5244.77 | 11384.0 |
| 2024-01-23 05:00:00 | ES | Futures | 5244.77 | 5244.77 | 5241.01 | 5242.89 | 11213.0 |
| 2024-01-23 06:00:00 | ES | Futures | 5243.16 | 5245.84 | 5242.08 | 5245.31 | 13848.0 |
| 2024-01-23 07:00:00 | ES | Futures | 5245.31 | 5247.99 | 5244.77 | 5247.99 | 12489.0 |
| 2024-01-23 08:00:00 | ES | Futures | 5247.72 | 5255.51 | 5246.92 | 5251.75 | 29094.0 |
| 2024-01-23 09:00:00 | ES | Futures | 5251.75 | 5252.83 | 5243.43 | 5248.26 | 139969.0 |
| 2024-01-23 10:00:00 | ES | Futures | 5247.99 | 5250.95 | 5238.59 | 5240.74 | 170585.0 |
| 2024-01-23 11:00:00 | ES | Futures | 5240.47 | 5245.31 | 5236.71 | 5243.16 | 130594.0 |
| 2024-01-23 12:00:00 | ES | Futures | 5243.16 | 5248.53 | 5238.59 | 5247.45 | 69387.0 |
| 2024-01-23 13:00:00 | ES | Futures | 5247.72 | 5249.33 | 5243.96 | 5248.26 | 67430.0 |
| 2024-01-23 14:00:00 | ES | Futures | 5248.53 | 5254.17 | 5244.77 | 5252.29 | 72954.0 |
| 2024-01-23 15:00:00 | ES | Futures | 5252.56 | 5261.15 | 5250.95 | 5258.74 | 198671.0 |
| 2024-01-23 16:00:00 | ES | Futures | 5258.74 | 5266.52 | 5257.12 | 5265.45 | 83277.0 |
| 2024-01-23 18:00:00 | ES | Futures | 5264.64 | 5270.28 | 5264.64 | 5269.21 | 6954.0 |
| 2024-01-23 19:00:00 | ES | Futures | 5269.21 | 5271.09 | 5267.6 | 5270.28 | 5257.0 |
| 2024-01-23 20:00:00 | ES | Futures | 5270.02 | 5270.28 | 5267.6 | 5268.14 | 5595.0 |
| 2024-01-23 21:00:00 | ES | Futures | 5268.4 | 5269.21 | 5267.06 | 5269.21 | 4147.0 |
| 2024-01-23 22:00:00 | ES | Futures | 5269.48 | 5271.36 | 5268.94 | 5270.02 | 4916.0 |
| 2024-01-23 23:00:00 | ES | Futures | 5270.28 | 5270.82 | 5269.48 | 5270.28 | 2140.0 |
| 2024-01-23 00:00:00 | NQ | Futures | 18956.73 | 18962.7 | 18949.14 | 18953.2 | 1932.0 |
| 2024-01-23 01:00:00 | NQ | Futures | 18952.12 | 18963.51 | 18950.49 | 18959.17 | 1826.0 |
| 2024-01-23 02:00:00 | NQ | Futures | 18959.44 | 18970.56 | 18954.56 | 18962.43 | 3926.0 |
| 2024-01-23 03:00:00 | NQ | Futures | 18962.97 | 18965.41 | 18898.15 | 18916.59 | 10827.0 |
| 2024-01-23 04:00:00 | NQ | Futures | 18916.05 | 18948.32 | 18912.25 | 18944.53 | 7584.0 |
| 2024-01-23 05:00:00 | NQ | Futures | 18944.25 | 18944.8 | 18915.24 | 18928.52 | 6576.0 |
| 2024-01-23 06:00:00 | NQ | Futures | 18928.52 | 18960.53 | 18928.52 | 18956.46 | 7827.0 |
| 2024-01-23 07:00:00 | NQ | Futures | 18956.19 | 18971.1 | 18947.78 | 18964.32 | 8026.0 |
| 2024-01-23 08:00:00 | NQ | Futures | 18964.6 | 19012.06 | 18963.51 | 18984.39 | 18617.0 |
| 2024-01-23 09:00:00 | NQ | Futures | 18983.85 | 18985.48 | 18886.22 | 18955.92 | 83188.0 |
| 2024-01-23 10:00:00 | NQ | Futures | 18955.92 | 18967.58 | 18906.29 | 18932.86 | 81980.0 |
| 2024-01-23 11:00:00 | NQ | Futures | 18933.14 | 18961.61 | 18905.74 | 18948.59 | 56177.0 |
| 2024-01-23 12:00:00 | NQ | Futures | 18948.32 | 18977.88 | 18921.2 | 18973.0 | 32387.0 |
| 2024-01-23 13:00:00 | NQ | Futures | 18973.27 | 18976.8 | 18941.0 | 18964.6 | 35253.0 |
| 2024-01-23 14:00:00 | NQ | Futures | 18964.6 | 18985.21 | 18945.88 | 18978.43 | 33275.0 |
| 2024-01-23 15:00:00 | NQ | Futures | 18978.43 | 19026.7 | 18973.27 | 19016.4 | 63345.0 |
| 2024-01-23 16:00:00 | NQ | Futures | 19016.4 | 19047.58 | 18995.51 | 19041.35 | 24858.0 |
| 2024-01-23 18:00:00 | NQ | Futures | 19042.97 | 19068.74 | 19041.08 | 19067.11 | 5110.0 |
| 2024-01-23 19:00:00 | NQ | Futures | 19066.57 | 19080.4 | 19060.87 | 19076.87 | 4029.0 |
| 2024-01-23 20:00:00 | NQ | Futures | 19076.33 | 19076.6 | 19058.97 | 19073.89 | 4858.0 |
| 2024-01-23 21:00:00 | NQ | Futures | 19073.62 | 19079.04 | 19066.03 | 19077.96 | 3022.0 |
| 2024-01-23 22:00:00 | NQ | Futures | 19077.69 | 19089.89 | 19076.06 | 19085.82 | 4171.0 |
| 2024-01-23 23:00:00 | NQ | Futures | 19086.1 | 19089.08 | 19080.13 | 19086.91 | 1770.0 |
| 2024-01-23 00:00:00 | YM | Futures | 41009.4 | 41015.8 | 41001.8 | 41007.2 | 356.0 |
| 2024-01-23 01:00:00 | YM | Futures | 41006.1 | 41021.2 | 41004.0 | 41014.7 | 517.0 |
| 2024-01-23 02:00:00 | YM | Futures | 41018.0 | 41034.1 | 41012.6 | 41025.5 | 1123.0 |
| 2024-01-23 03:00:00 | YM | Futures | 41025.5 | 41039.4 | 40980.4 | 40986.8 | 2927.0 |
> showing 50 of 2,093 rows — these rows as CSV