PREVIEW / futures_1hour / 2023-08-29
file: by_date/futures_1hour/2023/2023-08-29.parquet size: 66 KB rows: 2,030
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-29 00:00:00 | ES | Futures | 4880.54 | 4882.19 | 4879.71 | 4880.26 | 2080.0 |
| 2023-08-29 01:00:00 | ES | Futures | 4880.26 | 4885.2 | 4879.99 | 4884.66 | 5295.0 |
| 2023-08-29 02:00:00 | ES | Futures | 4884.66 | 4887.13 | 4881.91 | 4882.73 | 7811.0 |
| 2023-08-29 03:00:00 | ES | Futures | 4883.01 | 4890.97 | 4874.77 | 4875.87 | 22086.0 |
| 2023-08-29 04:00:00 | ES | Futures | 4875.6 | 4880.81 | 4873.13 | 4873.95 | 18563.0 |
| 2023-08-29 05:00:00 | ES | Futures | 4874.22 | 4884.93 | 4872.85 | 4884.38 | 11988.0 |
| 2023-08-29 06:00:00 | ES | Futures | 4884.38 | 4885.48 | 4876.15 | 4876.42 | 11905.0 |
| 2023-08-29 07:00:00 | ES | Futures | 4876.15 | 4879.44 | 4871.75 | 4873.4 | 14081.0 |
| 2023-08-29 08:00:00 | ES | Futures | 4873.4 | 4877.79 | 4868.19 | 4874.77 | 28105.0 |
| 2023-08-29 09:00:00 | ES | Futures | 4875.05 | 4893.71 | 4870.66 | 4888.77 | 130282.0 |
| 2023-08-29 10:00:00 | ES | Futures | 4889.32 | 4921.71 | 4888.77 | 4911.01 | 279629.0 |
| 2023-08-29 11:00:00 | ES | Futures | 4911.01 | 4934.89 | 4910.19 | 4931.32 | 167354.0 |
| 2023-08-29 12:00:00 | ES | Futures | 4931.32 | 4940.38 | 4929.68 | 4935.99 | 106418.0 |
| 2023-08-29 13:00:00 | ES | Futures | 4935.99 | 4943.95 | 4931.6 | 4936.26 | 122865.0 |
| 2023-08-29 14:00:00 | ES | Futures | 4935.99 | 4944.77 | 4934.62 | 4940.93 | 101992.0 |
| 2023-08-29 15:00:00 | ES | Futures | 4941.21 | 4951.09 | 4936.26 | 4947.79 | 230899.0 |
| 2023-08-29 16:00:00 | ES | Futures | 4947.52 | 4951.64 | 4946.97 | 4949.99 | 87013.0 |
| 2023-08-29 18:00:00 | ES | Futures | 4950.81 | 4953.83 | 4949.44 | 4951.36 | 5196.0 |
| 2023-08-29 19:00:00 | ES | Futures | 4951.64 | 4952.73 | 4950.26 | 4950.81 | 3084.0 |
| 2023-08-29 20:00:00 | ES | Futures | 4950.81 | 4954.11 | 4949.99 | 4953.01 | 6315.0 |
| 2023-08-29 21:00:00 | ES | Futures | 4953.01 | 4956.58 | 4951.36 | 4955.75 | 8053.0 |
| 2023-08-29 22:00:00 | ES | Futures | 4956.03 | 4959.05 | 4955.48 | 4955.75 | 7312.0 |
| 2023-08-29 23:00:00 | ES | Futures | 4955.48 | 4957.4 | 4955.48 | 4956.58 | 3904.0 |
| 2023-08-29 00:00:00 | NQ | Futures | 16812.47 | 16818.03 | 16807.74 | 16811.91 | 1503.0 |
| 2023-08-29 01:00:00 | NQ | Futures | 16811.91 | 16835.28 | 16811.08 | 16831.11 | 4068.0 |
| 2023-08-29 02:00:00 | NQ | Futures | 16831.38 | 16841.12 | 16816.37 | 16819.98 | 4755.0 |
| 2023-08-29 03:00:00 | NQ | Futures | 16820.26 | 16851.69 | 16778.26 | 16784.66 | 10873.0 |
| 2023-08-29 04:00:00 | NQ | Futures | 16783.82 | 16796.9 | 16765.19 | 16771.03 | 12157.0 |
| 2023-08-29 05:00:00 | NQ | Futures | 16772.14 | 16810.52 | 16763.8 | 16809.69 | 7146.0 |
| 2023-08-29 06:00:00 | NQ | Futures | 16809.41 | 16814.97 | 16780.49 | 16781.32 | 7859.0 |
| 2023-08-29 07:00:00 | NQ | Futures | 16781.6 | 16793.56 | 16763.24 | 16769.08 | 7813.0 |
| 2023-08-29 08:00:00 | NQ | Futures | 16769.08 | 16786.88 | 16743.22 | 16769.36 | 14342.0 |
| 2023-08-29 09:00:00 | NQ | Futures | 16769.64 | 16882.56 | 16754.62 | 16861.98 | 79462.0 |
| 2023-08-29 10:00:00 | NQ | Futures | 16863.09 | 17052.78 | 16860.31 | 17023.57 | 142658.0 |
| 2023-08-29 11:00:00 | NQ | Futures | 17023.57 | 17117.58 | 17021.63 | 17097.0 | 71243.0 |
| 2023-08-29 12:00:00 | NQ | Futures | 17097.28 | 17122.87 | 17080.87 | 17109.52 | 44163.0 |
| 2023-08-29 13:00:00 | NQ | Futures | 17109.79 | 17133.71 | 17085.87 | 17101.73 | 42918.0 |
| 2023-08-29 14:00:00 | NQ | Futures | 17101.45 | 17147.62 | 17096.72 | 17137.61 | 44402.0 |
| 2023-08-29 15:00:00 | NQ | Futures | 17137.61 | 17166.81 | 17120.64 | 17147.9 | 75626.0 |
| 2023-08-29 16:00:00 | NQ | Futures | 17147.62 | 17165.42 | 17144.28 | 17162.08 | 15918.0 |
| 2023-08-29 18:00:00 | NQ | Futures | 17163.47 | 17181.55 | 17158.47 | 17171.54 | 3993.0 |
| 2023-08-29 19:00:00 | NQ | Futures | 17172.09 | 17178.21 | 17166.25 | 17171.26 | 1983.0 |
| 2023-08-29 20:00:00 | NQ | Futures | 17171.26 | 17189.62 | 17165.14 | 17181.55 | 4861.0 |
| 2023-08-29 21:00:00 | NQ | Futures | 17182.11 | 17199.07 | 17174.6 | 17195.18 | 5205.0 |
| 2023-08-29 22:00:00 | NQ | Futures | 17196.29 | 17208.53 | 17192.12 | 17193.51 | 4448.0 |
| 2023-08-29 23:00:00 | NQ | Futures | 17192.95 | 17203.25 | 17192.4 | 17194.62 | 1993.0 |
| 2023-08-29 00:00:00 | YM | Futures | 37913.5 | 37921.2 | 37907.0 | 37910.2 | 352.0 |
| 2023-08-29 01:00:00 | YM | Futures | 37910.2 | 37939.8 | 37909.2 | 37937.6 | 755.0 |
| 2023-08-29 02:00:00 | YM | Futures | 37937.6 | 37955.2 | 37916.8 | 37924.5 | 1841.0 |
| 2023-08-29 03:00:00 | YM | Futures | 37925.6 | 37984.7 | 37874.1 | 37886.1 | 5566.0 |
> showing 50 of 2,030 rows — these rows as CSV