PREVIEW / futures_1hour / 2023-08-14
file: by_date/futures_1hour/2023/2023-08-14.parquet size: 65 KB rows: 2,022
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-14 00:00:00 | ES | Futures | 4908.81 | 4911.28 | 4907.17 | 4907.44 | 7937.0 |
| 2023-08-14 01:00:00 | ES | Futures | 4907.44 | 4915.13 | 4907.44 | 4913.75 | 8217.0 |
| 2023-08-14 02:00:00 | ES | Futures | 4913.75 | 4918.42 | 4911.01 | 4916.77 | 9362.0 |
| 2023-08-14 03:00:00 | ES | Futures | 4916.77 | 4942.58 | 4914.3 | 4937.64 | 29779.0 |
| 2023-08-14 04:00:00 | ES | Futures | 4937.36 | 4940.38 | 4928.03 | 4929.4 | 25232.0 |
| 2023-08-14 05:00:00 | ES | Futures | 4929.68 | 4933.24 | 4926.38 | 4929.95 | 10839.0 |
| 2023-08-14 06:00:00 | ES | Futures | 4930.22 | 4935.99 | 4928.03 | 4932.7 | 10398.0 |
| 2023-08-14 07:00:00 | ES | Futures | 4932.7 | 4934.34 | 4924.73 | 4927.75 | 13733.0 |
| 2023-08-14 08:00:00 | ES | Futures | 4928.03 | 4928.3 | 4907.71 | 4914.58 | 41976.0 |
| 2023-08-14 09:00:00 | ES | Futures | 4914.58 | 4917.6 | 4907.17 | 4915.95 | 171568.0 |
| 2023-08-14 10:00:00 | ES | Futures | 4916.22 | 4942.85 | 4913.21 | 4938.73 | 218325.0 |
| 2023-08-14 11:00:00 | ES | Futures | 4938.46 | 4944.77 | 4931.32 | 4937.64 | 127801.0 |
| 2023-08-14 12:00:00 | ES | Futures | 4937.64 | 4941.48 | 4929.13 | 4938.73 | 104631.0 |
| 2023-08-14 13:00:00 | ES | Futures | 4938.73 | 4943.68 | 4933.24 | 4937.64 | 76919.0 |
| 2023-08-14 14:00:00 | ES | Futures | 4937.64 | 4938.46 | 4928.3 | 4933.52 | 96191.0 |
| 2023-08-14 15:00:00 | ES | Futures | 4933.79 | 4948.89 | 4930.5 | 4948.62 | 174768.0 |
| 2023-08-14 16:00:00 | ES | Futures | 4948.62 | 4949.72 | 4947.24 | 4948.34 | 47993.0 |
| 2023-08-14 18:00:00 | ES | Futures | 4947.52 | 4957.13 | 4946.42 | 4956.03 | 8397.0 |
| 2023-08-14 19:00:00 | ES | Futures | 4956.03 | 4956.58 | 4951.91 | 4953.28 | 4389.0 |
| 2023-08-14 20:00:00 | ES | Futures | 4953.01 | 4954.66 | 4951.36 | 4952.46 | 6088.0 |
| 2023-08-14 21:00:00 | ES | Futures | 4952.46 | 4960.7 | 4951.09 | 4957.4 | 13795.0 |
| 2023-08-14 22:00:00 | ES | Futures | 4957.4 | 4957.68 | 4952.46 | 4954.38 | 7541.0 |
| 2023-08-14 23:00:00 | ES | Futures | 4954.38 | 4957.68 | 4954.11 | 4957.68 | 3613.0 |
| 2023-08-14 00:00:00 | NQ | Futures | 16743.77 | 16767.41 | 16736.82 | 16744.05 | 5600.0 |
| 2023-08-14 01:00:00 | NQ | Futures | 16743.22 | 16781.32 | 16743.22 | 16770.47 | 5567.0 |
| 2023-08-14 02:00:00 | NQ | Futures | 16771.31 | 16789.66 | 16757.12 | 16780.21 | 5356.0 |
| 2023-08-14 03:00:00 | NQ | Futures | 16779.65 | 16938.19 | 16769.08 | 16908.43 | 17660.0 |
| 2023-08-14 04:00:00 | NQ | Futures | 16908.7 | 16916.49 | 16850.02 | 16851.97 | 13898.0 |
| 2023-08-14 05:00:00 | NQ | Futures | 16853.63 | 16865.87 | 16837.5 | 16847.52 | 5926.0 |
| 2023-08-14 06:00:00 | NQ | Futures | 16848.35 | 16874.22 | 16838.89 | 16860.03 | 5845.0 |
| 2023-08-14 07:00:00 | NQ | Futures | 16859.75 | 16861.14 | 16819.98 | 16832.5 | 7738.0 |
| 2023-08-14 08:00:00 | NQ | Futures | 16832.77 | 16835.28 | 16749.89 | 16781.32 | 19213.0 |
| 2023-08-14 09:00:00 | NQ | Futures | 16780.21 | 16828.32 | 16726.81 | 16817.48 | 80524.0 |
| 2023-08-14 10:00:00 | NQ | Futures | 16817.76 | 16963.77 | 16800.23 | 16943.75 | 92334.0 |
| 2023-08-14 11:00:00 | NQ | Futures | 16943.75 | 16962.38 | 16905.09 | 16924.28 | 59627.0 |
| 2023-08-14 12:00:00 | NQ | Futures | 16924.28 | 16942.91 | 16879.5 | 16927.62 | 42713.0 |
| 2023-08-14 13:00:00 | NQ | Futures | 16927.9 | 16961.55 | 16915.66 | 16935.96 | 34463.0 |
| 2023-08-14 14:00:00 | NQ | Futures | 16936.8 | 16940.97 | 16897.02 | 16927.06 | 37948.0 |
| 2023-08-14 15:00:00 | NQ | Futures | 16926.78 | 16992.14 | 16915.94 | 16991.03 | 61295.0 |
| 2023-08-14 16:00:00 | NQ | Futures | 16990.48 | 17001.6 | 16981.85 | 16999.38 | 14194.0 |
| 2023-08-14 18:00:00 | NQ | Futures | 16998.26 | 17039.7 | 16992.7 | 17036.09 | 7932.0 |
| 2023-08-14 19:00:00 | NQ | Futures | 17036.09 | 17039.43 | 17016.06 | 17022.46 | 4980.0 |
| 2023-08-14 20:00:00 | NQ | Futures | 17022.46 | 17032.19 | 17014.95 | 17017.73 | 3501.0 |
| 2023-08-14 21:00:00 | NQ | Futures | 17018.29 | 17060.56 | 17012.17 | 17041.09 | 7978.0 |
| 2023-08-14 22:00:00 | NQ | Futures | 17041.37 | 17041.93 | 17021.35 | 17027.74 | 4842.0 |
| 2023-08-14 23:00:00 | NQ | Futures | 17028.02 | 17045.82 | 17026.08 | 17043.88 | 2932.0 |
| 2023-08-14 00:00:00 | YM | Futures | 38646.5 | 38657.4 | 38620.2 | 38625.6 | 1545.0 |
| 2023-08-14 01:00:00 | YM | Futures | 38625.6 | 38673.8 | 38624.5 | 38661.8 | 1207.0 |
| 2023-08-14 02:00:00 | YM | Futures | 38661.8 | 38693.6 | 38641.0 | 38690.3 | 2065.0 |
| 2023-08-14 03:00:00 | YM | Futures | 38689.2 | 38828.3 | 38671.7 | 38802.0 | 4669.0 |
> showing 50 of 2,022 rows — these rows as CSV