PREVIEW / futures_1hour / 2022-03-24
file: by_date/futures_1hour/2022/2022-03-24.parquet size: 67 KB rows: 2,036
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-24 00:00:00 | ES | Futures | 5056.86 | 5059.97 | 5055.16 | 5056.29 | 4001.0 |
| 2022-03-24 01:00:00 | ES | Futures | 5056.57 | 5067.91 | 5056.57 | 5066.78 | 7041.0 |
| 2022-03-24 02:00:00 | ES | Futures | 5066.78 | 5069.61 | 5057.99 | 5058.84 | 5547.0 |
| 2022-03-24 03:00:00 | ES | Futures | 5058.56 | 5067.63 | 5057.99 | 5059.41 | 7516.0 |
| 2022-03-24 04:00:00 | ES | Futures | 5059.69 | 5078.11 | 5059.12 | 5073.3 | 20517.0 |
| 2022-03-24 05:00:00 | ES | Futures | 5073.58 | 5077.26 | 5070.18 | 5070.46 | 11838.0 |
| 2022-03-24 06:00:00 | ES | Futures | 5070.75 | 5070.75 | 5061.39 | 5065.08 | 15644.0 |
| 2022-03-24 07:00:00 | ES | Futures | 5064.79 | 5080.67 | 5059.41 | 5066.21 | 30301.0 |
| 2022-03-24 08:00:00 | ES | Futures | 5066.49 | 5070.18 | 5059.41 | 5066.78 | 19000.0 |
| 2022-03-24 09:00:00 | ES | Futures | 5066.78 | 5070.18 | 5052.04 | 5061.11 | 136839.0 |
| 2022-03-24 10:00:00 | ES | Futures | 5061.11 | 5077.26 | 5057.42 | 5070.75 | 175916.0 |
| 2022-03-24 11:00:00 | ES | Futures | 5070.46 | 5100.22 | 5069.04 | 5094.27 | 166049.0 |
| 2022-03-24 12:00:00 | ES | Futures | 5093.99 | 5095.97 | 5075.28 | 5086.33 | 100737.0 |
| 2022-03-24 13:00:00 | ES | Futures | 5086.05 | 5095.4 | 5082.08 | 5092.0 | 72929.0 |
| 2022-03-24 14:00:00 | ES | Futures | 5092.0 | 5099.09 | 5082.65 | 5090.87 | 84569.0 |
| 2022-03-24 15:00:00 | ES | Futures | 5090.87 | 5117.23 | 5086.33 | 5116.95 | 217916.0 |
| 2022-03-24 16:00:00 | ES | Futures | 5116.66 | 5121.76 | 5114.11 | 5120.35 | 70819.0 |
| 2022-03-24 18:00:00 | ES | Futures | 5120.35 | 5121.48 | 5113.54 | 5113.54 | 4789.0 |
| 2022-03-24 19:00:00 | ES | Futures | 5113.54 | 5116.66 | 5111.28 | 5113.26 | 6416.0 |
| 2022-03-24 20:00:00 | ES | Futures | 5113.26 | 5114.11 | 5105.61 | 5108.16 | 7777.0 |
| 2022-03-24 21:00:00 | ES | Futures | 5107.88 | 5128.0 | 5106.46 | 5123.75 | 11658.0 |
| 2022-03-24 22:00:00 | ES | Futures | 5124.03 | 5124.03 | 5116.1 | 5120.63 | 7422.0 |
| 2022-03-24 23:00:00 | ES | Futures | 5120.63 | 5122.61 | 5113.54 | 5116.95 | 5199.0 |
| 2022-03-24 00:00:00 | NQ | Futures | 16840.3 | 16846.39 | 16831.31 | 16834.79 | 2262.0 |
| 2022-03-24 01:00:00 | NQ | Futures | 16836.24 | 16870.46 | 16831.02 | 16862.34 | 3295.0 |
| 2022-03-24 02:00:00 | NQ | Futures | 16862.34 | 16875.39 | 16828.41 | 16833.05 | 2998.0 |
| 2022-03-24 03:00:00 | NQ | Futures | 16832.76 | 16874.23 | 16821.74 | 16828.12 | 5220.0 |
| 2022-03-24 04:00:00 | NQ | Futures | 16828.7 | 16899.46 | 16824.35 | 16883.51 | 9792.0 |
| 2022-03-24 05:00:00 | NQ | Futures | 16884.96 | 16900.04 | 16865.53 | 16867.56 | 5039.0 |
| 2022-03-24 06:00:00 | NQ | Futures | 16866.69 | 16867.85 | 16822.9 | 16834.79 | 7151.0 |
| 2022-03-24 07:00:00 | NQ | Futures | 16835.08 | 16901.2 | 16821.16 | 16849.29 | 13300.0 |
| 2022-03-24 08:00:00 | NQ | Futures | 16849.87 | 16869.88 | 16823.48 | 16855.67 | 10906.0 |
| 2022-03-24 09:00:00 | NQ | Futures | 16855.67 | 16877.71 | 16782.02 | 16797.38 | 74787.0 |
| 2022-03-24 10:00:00 | NQ | Futures | 16796.51 | 16883.51 | 16741.42 | 16843.78 | 93951.0 |
| 2022-03-24 11:00:00 | NQ | Futures | 16843.49 | 17008.78 | 16829.86 | 16974.56 | 73019.0 |
| 2022-03-24 12:00:00 | NQ | Futures | 16974.27 | 16981.81 | 16914.82 | 16971.95 | 42111.0 |
| 2022-03-24 13:00:00 | NQ | Futures | 16972.24 | 17012.55 | 16949.62 | 16999.21 | 36710.0 |
| 2022-03-24 14:00:00 | NQ | Futures | 16998.92 | 17035.74 | 16970.79 | 17014.58 | 39335.0 |
| 2022-03-24 15:00:00 | NQ | Futures | 17014.87 | 17130.28 | 16991.09 | 17127.67 | 57380.0 |
| 2022-03-24 16:00:00 | NQ | Futures | 17128.25 | 17131.44 | 17113.75 | 17123.61 | 12915.0 |
| 2022-03-24 18:00:00 | NQ | Futures | 17125.93 | 17138.4 | 17102.73 | 17103.02 | 3156.0 |
| 2022-03-24 19:00:00 | NQ | Futures | 17103.02 | 17118.68 | 17094.61 | 17108.24 | 3008.0 |
| 2022-03-24 20:00:00 | NQ | Futures | 17109.11 | 17110.27 | 17072.86 | 17083.01 | 3817.0 |
| 2022-03-24 21:00:00 | NQ | Futures | 17083.3 | 17153.18 | 17075.76 | 17134.05 | 5613.0 |
| 2022-03-24 22:00:00 | NQ | Futures | 17134.05 | 17134.05 | 17106.21 | 17129.12 | 3943.0 |
| 2022-03-24 23:00:00 | NQ | Futures | 17129.12 | 17131.73 | 17100.99 | 17107.95 | 3001.0 |
| 2022-03-24 00:00:00 | YM | Futures | 38678.7 | 38699.0 | 38669.7 | 38679.8 | 807.0 |
| 2022-03-24 01:00:00 | YM | Futures | 38682.1 | 38755.4 | 38677.6 | 38749.7 | 1531.0 |
| 2022-03-24 02:00:00 | YM | Futures | 38749.7 | 38767.8 | 38690.0 | 38692.2 | 1284.0 |
| 2022-03-24 03:00:00 | YM | Futures | 38691.1 | 38754.2 | 38691.1 | 38705.8 | 1906.0 |
> showing 50 of 2,036 rows — these rows as CSV