PREVIEW / futures_1hour / 2022-08-08
file: by_date/futures_1hour/2022/2022-08-08.parquet size: 66 KB rows: 2,045
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-08-08 00:00:00 | ES | Futures | 4690.41 | 4695.79 | 4690.13 | 4694.94 | 2685.0 |
| 2022-08-08 01:00:00 | ES | Futures | 4694.94 | 4701.46 | 4694.38 | 4700.04 | 5267.0 |
| 2022-08-08 02:00:00 | ES | Futures | 4700.04 | 4709.39 | 4698.91 | 4707.97 | 10219.0 |
| 2022-08-08 03:00:00 | ES | Futures | 4708.26 | 4719.02 | 4707.41 | 4712.79 | 20339.0 |
| 2022-08-08 04:00:00 | ES | Futures | 4712.79 | 4717.04 | 4706.56 | 4709.67 | 10996.0 |
| 2022-08-08 05:00:00 | ES | Futures | 4709.67 | 4713.64 | 4705.99 | 4709.96 | 8012.0 |
| 2022-08-08 06:00:00 | ES | Futures | 4709.96 | 4724.4 | 4709.11 | 4724.12 | 14207.0 |
| 2022-08-08 07:00:00 | ES | Futures | 4724.12 | 4727.52 | 4716.47 | 4724.97 | 15095.0 |
| 2022-08-08 08:00:00 | ES | Futures | 4724.97 | 4733.47 | 4722.99 | 4733.18 | 27625.0 |
| 2022-08-08 09:00:00 | ES | Futures | 4733.47 | 4745.08 | 4713.64 | 4740.27 | 243361.0 |
| 2022-08-08 10:00:00 | ES | Futures | 4740.27 | 4745.36 | 4729.22 | 4732.62 | 205723.0 |
| 2022-08-08 11:00:00 | ES | Futures | 4732.9 | 4739.42 | 4698.62 | 4713.64 | 248514.0 |
| 2022-08-08 12:00:00 | ES | Futures | 4713.64 | 4715.62 | 4685.31 | 4696.36 | 178634.0 |
| 2022-08-08 13:00:00 | ES | Futures | 4696.36 | 4706.27 | 4691.54 | 4702.87 | 104144.0 |
| 2022-08-08 14:00:00 | ES | Futures | 4702.87 | 4703.16 | 4678.8 | 4686.44 | 141771.0 |
| 2022-08-08 15:00:00 | ES | Futures | 4686.73 | 4696.92 | 4681.91 | 4692.68 | 173084.0 |
| 2022-08-08 16:00:00 | ES | Futures | 4692.68 | 4704.01 | 4691.54 | 4703.16 | 40358.0 |
| 2022-08-08 18:00:00 | ES | Futures | 4700.61 | 4701.46 | 4697.21 | 4698.34 | 4100.0 |
| 2022-08-08 19:00:00 | ES | Futures | 4698.06 | 4707.97 | 4696.07 | 4705.42 | 8668.0 |
| 2022-08-08 20:00:00 | ES | Futures | 4705.14 | 4707.41 | 4698.91 | 4698.91 | 7263.0 |
| 2022-08-08 21:00:00 | ES | Futures | 4699.19 | 4699.47 | 4690.98 | 4692.11 | 7653.0 |
| 2022-08-08 22:00:00 | ES | Futures | 4692.11 | 4698.91 | 4692.11 | 4698.34 | 3901.0 |
| 2022-08-08 23:00:00 | ES | Futures | 4698.62 | 4706.84 | 4698.06 | 4705.99 | 5761.0 |
| 2022-08-08 00:00:00 | NQ | Futures | 15287.15 | 15310.0 | 15287.15 | 15307.69 | 1752.0 |
| 2022-08-08 01:00:00 | NQ | Futures | 15307.11 | 15347.02 | 15304.51 | 15330.83 | 4434.0 |
| 2022-08-08 02:00:00 | NQ | Futures | 15330.54 | 15354.83 | 15326.2 | 15349.34 | 4842.0 |
| 2022-08-08 03:00:00 | NQ | Futures | 15349.92 | 15391.28 | 15346.16 | 15376.24 | 9151.0 |
| 2022-08-08 04:00:00 | NQ | Futures | 15376.82 | 15395.04 | 15351.94 | 15370.16 | 6733.0 |
| 2022-08-08 05:00:00 | NQ | Futures | 15370.45 | 15384.62 | 15345.87 | 15359.75 | 4499.0 |
| 2022-08-08 06:00:00 | NQ | Futures | 15360.62 | 15414.42 | 15355.41 | 15413.84 | 6950.0 |
| 2022-08-08 07:00:00 | NQ | Futures | 15413.84 | 15421.94 | 15379.71 | 15413.26 | 7808.0 |
| 2022-08-08 08:00:00 | NQ | Futures | 15413.26 | 15444.21 | 15405.45 | 15441.89 | 12664.0 |
| 2022-08-08 09:00:00 | NQ | Futures | 15442.76 | 15517.67 | 15308.84 | 15494.25 | 106403.0 |
| 2022-08-08 10:00:00 | NQ | Futures | 15494.54 | 15525.48 | 15402.85 | 15417.31 | 80769.0 |
| 2022-08-08 11:00:00 | NQ | Futures | 15418.47 | 15453.17 | 15268.35 | 15331.69 | 88461.0 |
| 2022-08-08 12:00:00 | NQ | Futures | 15331.98 | 15342.11 | 15222.94 | 15267.48 | 71316.0 |
| 2022-08-08 13:00:00 | NQ | Futures | 15267.48 | 15308.84 | 15237.98 | 15283.97 | 45018.0 |
| 2022-08-08 14:00:00 | NQ | Futures | 15285.13 | 15285.71 | 15179.84 | 15209.92 | 55185.0 |
| 2022-08-08 15:00:00 | NQ | Futures | 15211.08 | 15258.23 | 15193.73 | 15250.42 | 55808.0 |
| 2022-08-08 16:00:00 | NQ | Futures | 15250.71 | 15287.73 | 15246.37 | 15286.86 | 11114.0 |
| 2022-08-08 18:00:00 | NQ | Futures | 15279.05 | 15282.81 | 15266.04 | 15269.51 | 2089.0 |
| 2022-08-08 19:00:00 | NQ | Futures | 15269.51 | 15310.87 | 15260.83 | 15295.83 | 3886.0 |
| 2022-08-08 20:00:00 | NQ | Futures | 15294.67 | 15302.48 | 15272.98 | 15274.14 | 3857.0 |
| 2022-08-08 21:00:00 | NQ | Futures | 15275.0 | 15275.58 | 15234.51 | 15240.87 | 4200.0 |
| 2022-08-08 22:00:00 | NQ | Futures | 15240.58 | 15269.8 | 15240.29 | 15267.77 | 2523.0 |
| 2022-08-08 23:00:00 | NQ | Futures | 15268.64 | 15301.03 | 15265.46 | 15296.7 | 3144.0 |
| 2022-08-08 00:00:00 | YM | Futures | 36920.5 | 36948.7 | 36920.5 | 36944.2 | 598.0 |
| 2022-08-08 01:00:00 | YM | Futures | 36944.2 | 36983.7 | 36943.1 | 36975.8 | 1225.0 |
| 2022-08-08 02:00:00 | YM | Futures | 36975.8 | 37048.0 | 36966.8 | 37040.1 | 2217.0 |
| 2022-08-08 03:00:00 | YM | Futures | 37041.3 | 37110.1 | 37036.7 | 37068.3 | 5339.0 |
> showing 50 of 2,045 rows — these rows as CSV