PREVIEW / futures_1hour / 2022-03-01
file: by_date/futures_1hour/2022/2022-03-01.parquet size: 72 KB rows: 2,100
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-01 00:00:00 | ES | Futures | 4943.95 | 4944.23 | 4933.2 | 4941.12 | 6331.0 |
| 2022-03-01 01:00:00 | ES | Futures | 4941.12 | 4955.54 | 4940.27 | 4954.13 | 7743.0 |
| 2022-03-01 02:00:00 | ES | Futures | 4954.13 | 4976.19 | 4952.15 | 4962.61 | 19297.0 |
| 2022-03-01 03:00:00 | ES | Futures | 4962.33 | 4973.64 | 4935.46 | 4942.82 | 36074.0 |
| 2022-03-01 04:00:00 | ES | Futures | 4942.53 | 4947.06 | 4910.29 | 4913.4 | 40667.0 |
| 2022-03-01 05:00:00 | ES | Futures | 4913.12 | 4918.21 | 4895.87 | 4916.8 | 32280.0 |
| 2022-03-01 06:00:00 | ES | Futures | 4916.51 | 4919.91 | 4889.65 | 4898.13 | 31664.0 |
| 2022-03-01 07:00:00 | ES | Futures | 4898.13 | 4917.08 | 4897.28 | 4905.2 | 32283.0 |
| 2022-03-01 08:00:00 | ES | Futures | 4905.2 | 4938.01 | 4897.28 | 4930.09 | 54941.0 |
| 2022-03-01 09:00:00 | ES | Futures | 4930.09 | 4948.47 | 4917.08 | 4922.45 | 187163.0 |
| 2022-03-01 10:00:00 | ES | Futures | 4922.74 | 4938.86 | 4893.61 | 4897.57 | 241254.0 |
| 2022-03-01 11:00:00 | ES | Futures | 4897.85 | 4913.97 | 4857.69 | 4864.2 | 215274.0 |
| 2022-03-01 12:00:00 | ES | Futures | 4863.91 | 4885.69 | 4850.06 | 4882.3 | 148811.0 |
| 2022-03-01 13:00:00 | ES | Futures | 4882.01 | 4890.78 | 4846.1 | 4856.84 | 136609.0 |
| 2022-03-01 14:00:00 | ES | Futures | 4856.84 | 4882.86 | 4843.27 | 4864.2 | 158121.0 |
| 2022-03-01 15:00:00 | ES | Futures | 4863.91 | 4893.89 | 4835.92 | 4867.87 | 328342.0 |
| 2022-03-01 16:00:00 | ES | Futures | 4868.16 | 4881.73 | 4867.59 | 4875.79 | 64324.0 |
| 2022-03-01 18:00:00 | ES | Futures | 4874.09 | 4883.99 | 4869.57 | 4883.71 | 8403.0 |
| 2022-03-01 19:00:00 | ES | Futures | 4883.71 | 4890.21 | 4878.9 | 4885.41 | 12141.0 |
| 2022-03-01 20:00:00 | ES | Futures | 4885.12 | 4889.93 | 4873.81 | 4877.77 | 14060.0 |
| 2022-03-01 21:00:00 | ES | Futures | 4877.49 | 4879.18 | 4865.61 | 4876.36 | 14904.0 |
| 2022-03-01 22:00:00 | ES | Futures | 4876.07 | 4885.12 | 4872.11 | 4880.03 | 9489.0 |
| 2022-03-01 23:00:00 | ES | Futures | 4880.03 | 4886.25 | 4874.38 | 4885.97 | 6178.0 |
| 2022-03-01 00:00:00 | NQ | Futures | 16487.12 | 16487.7 | 16450.02 | 16475.24 | 4486.0 |
| 2022-03-01 01:00:00 | NQ | Futures | 16474.95 | 16527.98 | 16468.57 | 16519.58 | 5327.0 |
| 2022-03-01 02:00:00 | NQ | Futures | 16519.87 | 16609.71 | 16514.07 | 16548.27 | 11687.0 |
| 2022-03-01 03:00:00 | NQ | Futures | 16548.56 | 16585.95 | 16425.1 | 16460.17 | 16295.0 |
| 2022-03-01 04:00:00 | NQ | Futures | 16459.59 | 16473.21 | 16353.51 | 16362.5 | 14279.0 |
| 2022-03-01 05:00:00 | NQ | Futures | 16361.92 | 16410.03 | 16322.79 | 16406.55 | 15468.0 |
| 2022-03-01 06:00:00 | NQ | Futures | 16405.68 | 16421.04 | 16311.2 | 16340.47 | 13885.0 |
| 2022-03-01 07:00:00 | NQ | Futures | 16341.05 | 16408.29 | 16336.7 | 16368.29 | 14319.0 |
| 2022-03-01 08:00:00 | NQ | Futures | 16367.42 | 16473.21 | 16340.18 | 16440.75 | 24373.0 |
| 2022-03-01 09:00:00 | NQ | Futures | 16440.46 | 16523.35 | 16408.0 | 16462.19 | 76092.0 |
| 2022-03-01 10:00:00 | NQ | Futures | 16467.12 | 16546.24 | 16383.07 | 16405.1 | 105071.0 |
| 2022-03-01 11:00:00 | NQ | Futures | 16405.68 | 16474.95 | 16249.76 | 16270.34 | 76906.0 |
| 2022-03-01 12:00:00 | NQ | Futures | 16270.34 | 16350.61 | 16227.73 | 16334.38 | 46830.0 |
| 2022-03-01 13:00:00 | NQ | Futures | 16332.36 | 16368.0 | 16197.88 | 16242.51 | 47671.0 |
| 2022-03-01 14:00:00 | NQ | Futures | 16242.51 | 16307.72 | 16188.32 | 16230.63 | 46003.0 |
| 2022-03-01 15:00:00 | NQ | Futures | 16230.92 | 16345.11 | 16113.83 | 16235.27 | 69199.0 |
| 2022-03-01 16:00:00 | NQ | Futures | 16234.98 | 16282.8 | 16217.88 | 16262.8 | 14656.0 |
| 2022-03-01 18:00:00 | NQ | Futures | 16260.19 | 16290.91 | 16239.03 | 16290.62 | 5046.0 |
| 2022-03-01 19:00:00 | NQ | Futures | 16290.91 | 16307.43 | 16265.7 | 16284.54 | 5777.0 |
| 2022-03-01 20:00:00 | NQ | Futures | 16283.38 | 16301.64 | 16237.01 | 16249.47 | 6389.0 |
| 2022-03-01 21:00:00 | NQ | Futures | 16247.73 | 16261.35 | 16197.59 | 16255.84 | 9999.0 |
| 2022-03-01 22:00:00 | NQ | Futures | 16254.97 | 16287.14 | 16250.05 | 16281.35 | 5369.0 |
| 2022-03-01 23:00:00 | NQ | Futures | 16281.35 | 16311.78 | 16264.54 | 16309.75 | 3107.0 |
| 2022-03-01 00:00:00 | YM | Futures | 38064.2 | 38076.6 | 37991.2 | 38048.5 | 1157.0 |
| 2022-03-01 01:00:00 | YM | Futures | 38048.5 | 38155.3 | 38047.4 | 38141.8 | 1850.0 |
| 2022-03-01 02:00:00 | YM | Futures | 38140.7 | 38282.3 | 38124.9 | 38183.4 | 4241.0 |
| 2022-03-01 03:00:00 | YM | Futures | 38183.4 | 38257.5 | 38013.7 | 38066.5 | 9219.0 |
> showing 50 of 2,100 rows — these rows as CSV