PREVIEW / futures_1hour / 2023-05-18
file: by_date/futures_1hour/2023/2023-05-18.parquet size: 68 KB rows: 2,054
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-05-18 00:00:00 | ES | Futures | 4625.7 | 4627.36 | 4624.59 | 4625.98 | 2888.0 |
| 2023-05-18 01:00:00 | ES | Futures | 4625.98 | 4627.09 | 4623.2 | 4624.04 | 5655.0 |
| 2023-05-18 02:00:00 | ES | Futures | 4623.76 | 4625.42 | 4622.09 | 4623.2 | 6598.0 |
| 2023-05-18 03:00:00 | ES | Futures | 4623.2 | 4633.19 | 4622.93 | 4632.36 | 18298.0 |
| 2023-05-18 04:00:00 | ES | Futures | 4632.63 | 4639.01 | 4632.63 | 4634.02 | 21977.0 |
| 2023-05-18 05:00:00 | ES | Futures | 4634.02 | 4637.63 | 4630.97 | 4636.52 | 9268.0 |
| 2023-05-18 06:00:00 | ES | Futures | 4636.52 | 4640.95 | 4635.13 | 4638.18 | 10072.0 |
| 2023-05-18 07:00:00 | ES | Futures | 4638.18 | 4641.51 | 4636.24 | 4636.79 | 13350.0 |
| 2023-05-18 08:00:00 | ES | Futures | 4636.79 | 4637.35 | 4619.6 | 4620.15 | 44781.0 |
| 2023-05-18 09:00:00 | ES | Futures | 4620.15 | 4629.58 | 4616.55 | 4625.98 | 147778.0 |
| 2023-05-18 10:00:00 | ES | Futures | 4625.98 | 4652.88 | 4623.76 | 4649.83 | 247177.0 |
| 2023-05-18 11:00:00 | ES | Futures | 4650.11 | 4658.7 | 4644.28 | 4647.61 | 212296.0 |
| 2023-05-18 12:00:00 | ES | Futures | 4647.89 | 4648.17 | 4632.36 | 4637.63 | 181361.0 |
| 2023-05-18 13:00:00 | ES | Futures | 4637.9 | 4649.27 | 4629.03 | 4631.25 | 157283.0 |
| 2023-05-18 14:00:00 | ES | Futures | 4631.25 | 4648.44 | 4629.58 | 4647.33 | 126949.0 |
| 2023-05-18 15:00:00 | ES | Futures | 4647.61 | 4676.73 | 4644.84 | 4672.02 | 306411.0 |
| 2023-05-18 16:00:00 | ES | Futures | 4671.74 | 4677.01 | 4670.35 | 4676.73 | 118711.0 |
| 2023-05-18 18:00:00 | ES | Futures | 4676.73 | 4687.83 | 4674.51 | 4684.22 | 18701.0 |
| 2023-05-18 19:00:00 | ES | Futures | 4683.94 | 4683.94 | 4678.67 | 4678.95 | 7292.0 |
| 2023-05-18 20:00:00 | ES | Futures | 4678.95 | 4682.0 | 4677.56 | 4679.23 | 8680.0 |
| 2023-05-18 21:00:00 | ES | Futures | 4679.23 | 4680.34 | 4674.51 | 4677.84 | 8101.0 |
| 2023-05-18 22:00:00 | ES | Futures | 4677.84 | 4683.11 | 4676.73 | 4683.11 | 6937.0 |
| 2023-05-18 23:00:00 | ES | Futures | 4683.11 | 4683.94 | 4679.78 | 4680.06 | 6357.0 |
| 2023-05-18 00:00:00 | NQ | Futures | 15366.6 | 15371.67 | 15362.94 | 15367.16 | 1437.0 |
| 2023-05-18 01:00:00 | NQ | Futures | 15366.6 | 15372.51 | 15357.59 | 15360.41 | 2516.0 |
| 2023-05-18 02:00:00 | NQ | Futures | 15360.12 | 15364.35 | 15351.96 | 15353.37 | 2376.0 |
| 2023-05-18 03:00:00 | NQ | Futures | 15353.09 | 15382.09 | 15353.09 | 15376.74 | 8441.0 |
| 2023-05-18 04:00:00 | NQ | Futures | 15376.74 | 15402.08 | 15376.45 | 15389.41 | 9654.0 |
| 2023-05-18 05:00:00 | NQ | Futures | 15388.84 | 15398.98 | 15380.68 | 15390.53 | 3957.0 |
| 2023-05-18 06:00:00 | NQ | Futures | 15390.53 | 15407.71 | 15388.84 | 15395.88 | 5472.0 |
| 2023-05-18 07:00:00 | NQ | Futures | 15395.88 | 15410.24 | 15394.76 | 15404.61 | 6662.0 |
| 2023-05-18 08:00:00 | NQ | Futures | 15404.89 | 15408.27 | 15359.28 | 15359.84 | 20979.0 |
| 2023-05-18 09:00:00 | NQ | Futures | 15360.41 | 15449.38 | 15351.96 | 15443.75 | 96537.0 |
| 2023-05-18 10:00:00 | NQ | Futures | 15443.18 | 15532.15 | 15429.67 | 15523.71 | 133902.0 |
| 2023-05-18 11:00:00 | NQ | Futures | 15524.27 | 15603.95 | 15522.3 | 15568.76 | 93948.0 |
| 2023-05-18 12:00:00 | NQ | Futures | 15569.04 | 15573.54 | 15513.01 | 15531.87 | 76885.0 |
| 2023-05-18 13:00:00 | NQ | Futures | 15532.15 | 15586.21 | 15500.62 | 15507.38 | 68264.0 |
| 2023-05-18 14:00:00 | NQ | Futures | 15506.81 | 15563.12 | 15492.45 | 15558.34 | 58812.0 |
| 2023-05-18 15:00:00 | NQ | Futures | 15558.9 | 15655.76 | 15548.48 | 15642.8 | 108084.0 |
| 2023-05-18 16:00:00 | NQ | Futures | 15643.09 | 15668.99 | 15639.99 | 15668.43 | 24033.0 |
| 2023-05-18 18:00:00 | NQ | Futures | 15663.92 | 15722.2 | 15653.22 | 15705.59 | 12641.0 |
| 2023-05-18 19:00:00 | NQ | Futures | 15706.15 | 15706.15 | 15684.19 | 15687.57 | 3855.0 |
| 2023-05-18 20:00:00 | NQ | Futures | 15687.85 | 15700.8 | 15684.47 | 15690.39 | 4940.0 |
| 2023-05-18 21:00:00 | NQ | Futures | 15690.1 | 15694.05 | 15670.68 | 15684.19 | 4946.0 |
| 2023-05-18 22:00:00 | NQ | Futures | 15683.91 | 15701.65 | 15679.97 | 15699.96 | 3547.0 |
| 2023-05-18 23:00:00 | NQ | Futures | 15699.68 | 15702.49 | 15687.01 | 15687.01 | 3436.0 |
| 2023-05-18 00:00:00 | YM | Futures | 36959.3 | 36968.1 | 36951.6 | 36960.4 | 497.0 |
| 2023-05-18 01:00:00 | YM | Futures | 36959.3 | 36963.7 | 36935.0 | 36941.6 | 908.0 |
| 2023-05-18 02:00:00 | YM | Futures | 36941.6 | 36967.0 | 36933.9 | 36942.7 | 1152.0 |
| 2023-05-18 03:00:00 | YM | Futures | 36943.8 | 37028.9 | 36941.6 | 37025.6 | 3411.0 |
> showing 50 of 2,054 rows — these rows as CSV