PREVIEW / futures_1hour / 2022-11-24
file: by_date/futures_1hour/2022/2022-11-24.parquet size: 51 KB rows: 1,559
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-11-24 00:00:00 | ES | Futures | 4557.66 | 4557.94 | 4554.84 | 4555.4 | 3159.0 |
| 2022-11-24 01:00:00 | ES | Futures | 4555.4 | 4556.25 | 4553.15 | 4555.12 | 2619.0 |
| 2022-11-24 02:00:00 | ES | Futures | 4555.12 | 4560.47 | 4553.71 | 4554.55 | 5150.0 |
| 2022-11-24 03:00:00 | ES | Futures | 4554.55 | 4561.6 | 4552.3 | 4559.63 | 9228.0 |
| 2022-11-24 04:00:00 | ES | Futures | 4559.91 | 4563.86 | 4559.91 | 4560.47 | 8997.0 |
| 2022-11-24 05:00:00 | ES | Futures | 4560.47 | 4565.27 | 4559.63 | 4565.27 | 8101.0 |
| 2022-11-24 06:00:00 | ES | Futures | 4565.27 | 4565.55 | 4561.32 | 4564.7 | 4931.0 |
| 2022-11-24 07:00:00 | ES | Futures | 4564.7 | 4565.83 | 4556.25 | 4557.66 | 8179.0 |
| 2022-11-24 08:00:00 | ES | Futures | 4557.66 | 4559.91 | 4553.71 | 4559.91 | 8208.0 |
| 2022-11-24 09:00:00 | ES | Futures | 4559.91 | 4561.04 | 4554.84 | 4559.91 | 9982.0 |
| 2022-11-24 10:00:00 | ES | Futures | 4559.91 | 4563.01 | 4559.63 | 4563.01 | 6340.0 |
| 2022-11-24 11:00:00 | ES | Futures | 4562.73 | 4563.86 | 4558.78 | 4561.32 | 7423.0 |
| 2022-11-24 12:00:00 | ES | Futures | 4561.32 | 4561.6 | 4557.94 | 4559.35 | 3409.0 |
| 2022-11-24 18:00:00 | ES | Futures | 4559.63 | 4562.17 | 4557.94 | 4559.91 | 3206.0 |
| 2022-11-24 19:00:00 | ES | Futures | 4559.91 | 4560.19 | 4554.55 | 4557.94 | 3835.0 |
| 2022-11-24 20:00:00 | ES | Futures | 4557.94 | 4559.91 | 4555.96 | 4557.94 | 3864.0 |
| 2022-11-24 21:00:00 | ES | Futures | 4557.66 | 4559.35 | 4555.4 | 4557.09 | 2864.0 |
| 2022-11-24 22:00:00 | ES | Futures | 4557.09 | 4557.94 | 4555.68 | 4557.94 | 2501.0 |
| 2022-11-24 23:00:00 | ES | Futures | 4557.94 | 4559.91 | 4557.66 | 4558.78 | 2165.0 |
| 2022-11-24 00:00:00 | NQ | Futures | 13671.83 | 13673.55 | 13660.62 | 13661.2 | 1363.0 |
| 2022-11-24 01:00:00 | NQ | Futures | 13661.48 | 13665.22 | 13652.0 | 13660.91 | 1501.0 |
| 2022-11-24 02:00:00 | NQ | Futures | 13661.2 | 13686.48 | 13658.9 | 13661.48 | 3247.0 |
| 2022-11-24 03:00:00 | NQ | Futures | 13661.2 | 13687.63 | 13646.83 | 13682.17 | 5464.0 |
| 2022-11-24 04:00:00 | NQ | Futures | 13682.75 | 13704.58 | 13681.02 | 13693.95 | 6402.0 |
| 2022-11-24 05:00:00 | NQ | Futures | 13693.95 | 13709.47 | 13691.37 | 13708.89 | 3554.0 |
| 2022-11-24 06:00:00 | NQ | Futures | 13708.61 | 13710.62 | 13696.54 | 13706.31 | 2937.0 |
| 2022-11-24 07:00:00 | NQ | Futures | 13706.02 | 13714.64 | 13683.61 | 13690.5 | 3719.0 |
| 2022-11-24 08:00:00 | NQ | Futures | 13690.22 | 13701.42 | 13677.86 | 13699.7 | 3362.0 |
| 2022-11-24 09:00:00 | NQ | Futures | 13699.7 | 13702.57 | 13675.28 | 13687.63 | 5829.0 |
| 2022-11-24 10:00:00 | NQ | Futures | 13687.63 | 13700.56 | 13682.46 | 13699.99 | 3784.0 |
| 2022-11-24 11:00:00 | NQ | Futures | 13699.41 | 13705.16 | 13692.8 | 13703.72 | 3225.0 |
| 2022-11-24 12:00:00 | NQ | Futures | 13704.01 | 13705.44 | 13689.07 | 13689.07 | 2052.0 |
| 2022-11-24 18:00:00 | NQ | Futures | 13693.09 | 13704.3 | 13691.65 | 13696.83 | 1658.0 |
| 2022-11-24 19:00:00 | NQ | Futures | 13697.4 | 13699.7 | 13678.44 | 13690.5 | 2386.0 |
| 2022-11-24 20:00:00 | NQ | Futures | 13690.79 | 13698.84 | 13680.73 | 13686.77 | 1998.0 |
| 2022-11-24 21:00:00 | NQ | Futures | 13685.62 | 13692.8 | 13679.59 | 13686.48 | 1226.0 |
| 2022-11-24 22:00:00 | NQ | Futures | 13687.06 | 13692.52 | 13681.88 | 13688.49 | 1151.0 |
| 2022-11-24 23:00:00 | NQ | Futures | 13687.92 | 13696.54 | 13687.92 | 13693.09 | 1094.0 |
| 2022-11-24 00:00:00 | YM | Futures | 38446.6 | 38450.0 | 38429.8 | 38433.1 | 540.0 |
| 2022-11-24 01:00:00 | YM | Futures | 38434.3 | 38441.0 | 38417.4 | 38426.4 | 474.0 |
| 2022-11-24 02:00:00 | YM | Futures | 38427.5 | 38465.7 | 38421.9 | 38423.0 | 1246.0 |
| 2022-11-24 03:00:00 | YM | Futures | 38423.0 | 38472.4 | 38408.4 | 38457.8 | 1803.0 |
| 2022-11-24 04:00:00 | YM | Futures | 38460.1 | 38485.9 | 38460.1 | 38461.2 | 2041.0 |
| 2022-11-24 05:00:00 | YM | Futures | 38460.1 | 38494.9 | 38454.5 | 38493.7 | 1679.0 |
| 2022-11-24 06:00:00 | YM | Futures | 38492.6 | 38494.9 | 38458.9 | 38491.5 | 1073.0 |
| 2022-11-24 07:00:00 | YM | Futures | 38490.4 | 38493.7 | 38432.0 | 38439.9 | 1779.0 |
| 2022-11-24 08:00:00 | YM | Futures | 38438.7 | 38450.0 | 38415.2 | 38446.6 | 1726.0 |
| 2022-11-24 09:00:00 | YM | Futures | 38448.8 | 38466.8 | 38424.2 | 38454.5 | 2393.0 |
| 2022-11-24 10:00:00 | YM | Futures | 38453.3 | 38487.0 | 38450.0 | 38482.5 | 1932.0 |
| 2022-11-24 11:00:00 | YM | Futures | 38482.5 | 38483.6 | 38454.5 | 38462.3 | 1865.0 |
> showing 50 of 1,559 rows — these rows as CSV