PREVIEW / futures_1hour / 2022-12-05
file: by_date/futures_1hour/2022/2022-12-05.parquet size: 67 KB rows: 2,021
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-12-05 00:00:00 | ES | Futures | 4589.79 | 4590.64 | 4587.82 | 4590.36 | 3367.0 |
| 2022-12-05 01:00:00 | ES | Futures | 4590.36 | 4591.48 | 4585.84 | 4591.2 | 6204.0 |
| 2022-12-05 02:00:00 | ES | Futures | 4591.48 | 4591.48 | 4578.52 | 4580.77 | 12996.0 |
| 2022-12-05 03:00:00 | ES | Futures | 4580.77 | 4583.31 | 4572.6 | 4582.74 | 23320.0 |
| 2022-12-05 04:00:00 | ES | Futures | 4582.74 | 4583.31 | 4570.34 | 4578.8 | 17502.0 |
| 2022-12-05 05:00:00 | ES | Futures | 4578.8 | 4581.62 | 4572.6 | 4574.01 | 12384.0 |
| 2022-12-05 06:00:00 | ES | Futures | 4574.29 | 4582.46 | 4573.44 | 4581.62 | 9915.0 |
| 2022-12-05 07:00:00 | ES | Futures | 4581.62 | 4582.18 | 4569.5 | 4573.44 | 15259.0 |
| 2022-12-05 08:00:00 | ES | Futures | 4573.16 | 4575.41 | 4559.91 | 4562.45 | 35426.0 |
| 2022-12-05 09:00:00 | ES | Futures | 4562.45 | 4572.88 | 4554.27 | 4554.27 | 140737.0 |
| 2022-12-05 10:00:00 | ES | Futures | 4554.27 | 4558.5 | 4535.1 | 4554.84 | 232535.0 |
| 2022-12-05 11:00:00 | ES | Futures | 4554.84 | 4561.88 | 4526.65 | 4527.49 | 164404.0 |
| 2022-12-05 12:00:00 | ES | Futures | 4527.49 | 4537.36 | 4519.6 | 4520.73 | 130823.0 |
| 2022-12-05 13:00:00 | ES | Futures | 4520.73 | 4527.49 | 4506.63 | 4507.76 | 127884.0 |
| 2022-12-05 14:00:00 | ES | Futures | 4507.48 | 4513.4 | 4495.92 | 4504.66 | 149898.0 |
| 2022-12-05 15:00:00 | ES | Futures | 4504.38 | 4516.5 | 4501.0 | 4512.55 | 246667.0 |
| 2022-12-05 16:00:00 | ES | Futures | 4512.83 | 4517.63 | 4511.43 | 4517.34 | 52965.0 |
| 2022-12-05 18:00:00 | ES | Futures | 4516.78 | 4522.14 | 4514.53 | 4519.32 | 7801.0 |
| 2022-12-05 19:00:00 | ES | Futures | 4519.6 | 4523.83 | 4519.32 | 4521.86 | 7503.0 |
| 2022-12-05 20:00:00 | ES | Futures | 4522.14 | 4526.93 | 4521.29 | 4522.7 | 11531.0 |
| 2022-12-05 21:00:00 | ES | Futures | 4522.42 | 4526.65 | 4521.29 | 4521.86 | 7965.0 |
| 2022-12-05 22:00:00 | ES | Futures | 4521.86 | 4524.11 | 4518.47 | 4521.86 | 6610.0 |
| 2022-12-05 23:00:00 | ES | Futures | 4521.86 | 4522.42 | 4516.5 | 4517.63 | 4568.0 |
| 2022-12-05 00:00:00 | NQ | Futures | 13782.74 | 13787.05 | 13775.27 | 13786.47 | 1400.0 |
| 2022-12-05 01:00:00 | NQ | Futures | 13786.47 | 13787.91 | 13765.5 | 13787.05 | 2928.0 |
| 2022-12-05 02:00:00 | NQ | Futures | 13787.05 | 13787.05 | 13743.37 | 13753.43 | 5844.0 |
| 2022-12-05 03:00:00 | NQ | Futures | 13754.0 | 13783.02 | 13725.56 | 13783.02 | 11990.0 |
| 2022-12-05 04:00:00 | NQ | Futures | 13782.74 | 13783.6 | 13737.63 | 13768.66 | 7103.0 |
| 2022-12-05 05:00:00 | NQ | Futures | 13767.79 | 13776.13 | 13747.11 | 13758.31 | 5224.0 |
| 2022-12-05 06:00:00 | NQ | Futures | 13758.6 | 13786.76 | 13756.01 | 13785.03 | 4714.0 |
| 2022-12-05 07:00:00 | NQ | Futures | 13784.17 | 13789.92 | 13735.61 | 13749.12 | 8392.0 |
| 2022-12-05 08:00:00 | NQ | Futures | 13748.83 | 13756.3 | 13700.27 | 13708.32 | 17203.0 |
| 2022-12-05 09:00:00 | NQ | Futures | 13708.61 | 13759.75 | 13690.22 | 13714.64 | 61692.0 |
| 2022-12-05 10:00:00 | NQ | Futures | 13713.49 | 13714.06 | 13632.75 | 13702.57 | 89896.0 |
| 2022-12-05 11:00:00 | NQ | Futures | 13702.86 | 13735.33 | 13610.34 | 13616.09 | 64944.0 |
| 2022-12-05 12:00:00 | NQ | Futures | 13616.66 | 13645.68 | 13579.31 | 13584.48 | 49791.0 |
| 2022-12-05 13:00:00 | NQ | Futures | 13584.77 | 13617.24 | 13539.95 | 13542.53 | 48240.0 |
| 2022-12-05 14:00:00 | NQ | Futures | 13542.24 | 13564.37 | 13499.14 | 13525.58 | 51733.0 |
| 2022-12-05 15:00:00 | NQ | Futures | 13525.0 | 13572.41 | 13508.34 | 13564.94 | 68752.0 |
| 2022-12-05 16:00:00 | NQ | Futures | 13564.94 | 13577.58 | 13551.15 | 13577.3 | 13224.0 |
| 2022-12-05 18:00:00 | NQ | Futures | 13575.57 | 13595.97 | 13558.05 | 13584.77 | 4616.0 |
| 2022-12-05 19:00:00 | NQ | Futures | 13584.77 | 13602.87 | 13584.77 | 13594.82 | 3415.0 |
| 2022-12-05 20:00:00 | NQ | Futures | 13595.69 | 13612.35 | 13593.1 | 13598.85 | 4233.0 |
| 2022-12-05 21:00:00 | NQ | Futures | 13598.56 | 13609.48 | 13585.06 | 13587.64 | 3408.0 |
| 2022-12-05 22:00:00 | NQ | Futures | 13588.22 | 13593.96 | 13575.0 | 13588.22 | 2616.0 |
| 2022-12-05 23:00:00 | NQ | Futures | 13588.22 | 13589.37 | 13565.23 | 13568.1 | 2230.0 |
| 2022-12-05 00:00:00 | YM | Futures | 38643.0 | 38650.8 | 38628.4 | 38650.8 | 580.0 |
| 2022-12-05 01:00:00 | YM | Futures | 38648.6 | 38657.6 | 38623.9 | 38653.1 | 1014.0 |
| 2022-12-05 02:00:00 | YM | Futures | 38654.2 | 38654.2 | 38571.2 | 38582.4 | 2342.0 |
| 2022-12-05 03:00:00 | YM | Futures | 38582.4 | 38593.6 | 38522.9 | 38576.8 | 4605.0 |
> showing 50 of 2,021 rows — these rows as CSV