PREVIEW / futures_1hour / 2023-08-03
file: by_date/futures_1hour/2023/2023-08-03.parquet size: 67 KB rows: 2,048
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-03 00:00:00 | ES | Futures | 4987.87 | 4987.87 | 4980.73 | 4981.83 | 5173.0 |
| 2023-08-03 01:00:00 | ES | Futures | 4981.56 | 4986.5 | 4978.26 | 4982.38 | 12143.0 |
| 2023-08-03 02:00:00 | ES | Futures | 4982.11 | 4983.48 | 4968.66 | 4968.93 | 13829.0 |
| 2023-08-03 03:00:00 | ES | Futures | 4968.93 | 4971.4 | 4952.46 | 4953.28 | 56216.0 |
| 2023-08-03 04:00:00 | ES | Futures | 4953.28 | 4966.19 | 4953.28 | 4961.24 | 38179.0 |
| 2023-08-03 05:00:00 | ES | Futures | 4961.24 | 4970.85 | 4961.24 | 4970.03 | 24349.0 |
| 2023-08-03 06:00:00 | ES | Futures | 4970.3 | 4974.97 | 4967.83 | 4970.03 | 15810.0 |
| 2023-08-03 07:00:00 | ES | Futures | 4970.03 | 4977.17 | 4965.36 | 4968.11 | 32172.0 |
| 2023-08-03 08:00:00 | ES | Futures | 4968.38 | 4970.85 | 4959.05 | 4965.09 | 52809.0 |
| 2023-08-03 09:00:00 | ES | Futures | 4964.81 | 4965.91 | 4950.54 | 4960.97 | 222470.0 |
| 2023-08-03 10:00:00 | ES | Futures | 4960.97 | 4969.75 | 4947.52 | 4960.15 | 272559.0 |
| 2023-08-03 11:00:00 | ES | Futures | 4960.15 | 4975.52 | 4958.77 | 4968.93 | 186410.0 |
| 2023-08-03 12:00:00 | ES | Futures | 4968.93 | 4985.13 | 4967.01 | 4983.21 | 123971.0 |
| 2023-08-03 13:00:00 | ES | Futures | 4983.21 | 4985.68 | 4970.58 | 4971.4 | 126086.0 |
| 2023-08-03 14:00:00 | ES | Futures | 4971.4 | 4977.99 | 4968.38 | 4976.34 | 120229.0 |
| 2023-08-03 15:00:00 | ES | Futures | 4976.62 | 4977.17 | 4962.89 | 4963.44 | 224483.0 |
| 2023-08-03 16:00:00 | ES | Futures | 4963.44 | 4990.07 | 4960.42 | 4968.38 | 126254.0 |
| 2023-08-03 18:00:00 | ES | Futures | 4967.01 | 4976.34 | 4965.64 | 4974.97 | 8532.0 |
| 2023-08-03 19:00:00 | ES | Futures | 4975.24 | 4978.81 | 4971.13 | 4974.97 | 6000.0 |
| 2023-08-03 20:00:00 | ES | Futures | 4974.97 | 4981.83 | 4971.4 | 4981.56 | 9893.0 |
| 2023-08-03 21:00:00 | ES | Futures | 4981.56 | 4985.95 | 4979.09 | 4982.11 | 10339.0 |
| 2023-08-03 22:00:00 | ES | Futures | 4981.83 | 4985.4 | 4977.17 | 4980.19 | 9204.0 |
| 2023-08-03 23:00:00 | ES | Futures | 4979.91 | 4984.58 | 4979.64 | 4980.73 | 4036.0 |
| 2023-08-03 00:00:00 | NQ | Futures | 17219.66 | 17223.27 | 17186.84 | 17191.56 | 3738.0 |
| 2023-08-03 01:00:00 | NQ | Futures | 17191.56 | 17218.54 | 17175.71 | 17201.02 | 7135.0 |
| 2023-08-03 02:00:00 | NQ | Futures | 17200.74 | 17209.64 | 17134.83 | 17135.94 | 7284.0 |
| 2023-08-03 03:00:00 | NQ | Futures | 17136.22 | 17144.28 | 17065.57 | 17072.52 | 23142.0 |
| 2023-08-03 04:00:00 | NQ | Futures | 17072.52 | 17135.94 | 17070.86 | 17123.98 | 15869.0 |
| 2023-08-03 05:00:00 | NQ | Futures | 17123.7 | 17163.19 | 17123.14 | 17152.07 | 11006.0 |
| 2023-08-03 06:00:00 | NQ | Futures | 17152.07 | 17175.43 | 17137.88 | 17146.23 | 8934.0 |
| 2023-08-03 07:00:00 | NQ | Futures | 17146.78 | 17183.5 | 17127.04 | 17136.22 | 15928.0 |
| 2023-08-03 08:00:00 | NQ | Futures | 17137.61 | 17143.45 | 17091.16 | 17109.79 | 28723.0 |
| 2023-08-03 09:00:00 | NQ | Futures | 17109.24 | 17197.4 | 17078.36 | 17174.04 | 89015.0 |
| 2023-08-03 10:00:00 | NQ | Futures | 17174.04 | 17207.14 | 17081.15 | 17160.97 | 106719.0 |
| 2023-08-03 11:00:00 | NQ | Futures | 17160.41 | 17228.83 | 17150.96 | 17192.12 | 68508.0 |
| 2023-08-03 12:00:00 | NQ | Futures | 17192.12 | 17270.28 | 17179.33 | 17253.03 | 43147.0 |
| 2023-08-03 13:00:00 | NQ | Futures | 17253.59 | 17261.65 | 17186.28 | 17191.01 | 43816.0 |
| 2023-08-03 14:00:00 | NQ | Futures | 17191.56 | 17222.99 | 17175.71 | 17216.6 | 39967.0 |
| 2023-08-03 15:00:00 | NQ | Futures | 17217.43 | 17218.82 | 17149.84 | 17167.37 | 59487.0 |
| 2023-08-03 16:00:00 | NQ | Futures | 17167.37 | 17301.7 | 17144.84 | 17185.72 | 51397.0 |
| 2023-08-03 18:00:00 | NQ | Futures | 17178.49 | 17226.33 | 17167.37 | 17219.1 | 6559.0 |
| 2023-08-03 19:00:00 | NQ | Futures | 17219.38 | 17242.46 | 17203.8 | 17223.27 | 5379.0 |
| 2023-08-03 20:00:00 | NQ | Futures | 17222.71 | 17254.14 | 17207.14 | 17253.31 | 6381.0 |
| 2023-08-03 21:00:00 | NQ | Futures | 17253.87 | 17283.9 | 17243.3 | 17263.04 | 6845.0 |
| 2023-08-03 22:00:00 | NQ | Futures | 17262.21 | 17279.45 | 17242.18 | 17256.37 | 5825.0 |
| 2023-08-03 23:00:00 | NQ | Futures | 17256.09 | 17273.89 | 17254.42 | 17258.59 | 2934.0 |
| 2023-08-03 00:00:00 | YM | Futures | 38853.5 | 38857.9 | 38810.8 | 38820.6 | 887.0 |
| 2023-08-03 01:00:00 | YM | Futures | 38819.5 | 38843.7 | 38794.4 | 38816.3 | 1503.0 |
| 2023-08-03 02:00:00 | YM | Futures | 38816.3 | 38822.8 | 38733.0 | 38739.6 | 2446.0 |
| 2023-08-03 03:00:00 | YM | Futures | 38739.6 | 38753.8 | 38610.3 | 38620.2 | 9317.0 |
> showing 50 of 2,048 rows — these rows as CSV