PREVIEW / futures_1hour / 2023-06-29
file: by_date/futures_1hour/2023/2023-06-29.parquet size: 65 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 |
|---|---|---|---|---|---|---|---|
| 2023-06-29 00:00:00 | ES | Futures | 4853.91 | 4855.01 | 4852.54 | 4853.36 | 4336.0 |
| 2023-06-29 01:00:00 | ES | Futures | 4853.36 | 4856.66 | 4850.34 | 4853.09 | 8135.0 |
| 2023-06-29 02:00:00 | ES | Futures | 4853.09 | 4853.36 | 4849.52 | 4850.34 | 8152.0 |
| 2023-06-29 03:00:00 | ES | Futures | 4850.07 | 4853.09 | 4847.32 | 4850.07 | 19699.0 |
| 2023-06-29 04:00:00 | ES | Futures | 4850.34 | 4858.03 | 4849.52 | 4857.2 | 17725.0 |
| 2023-06-29 05:00:00 | ES | Futures | 4857.2 | 4861.87 | 4854.73 | 4861.32 | 11233.0 |
| 2023-06-29 06:00:00 | ES | Futures | 4861.6 | 4867.64 | 4859.68 | 4864.62 | 17409.0 |
| 2023-06-29 07:00:00 | ES | Futures | 4864.34 | 4867.36 | 4862.69 | 4864.34 | 15447.0 |
| 2023-06-29 08:00:00 | ES | Futures | 4864.34 | 4871.75 | 4853.91 | 4855.56 | 69149.0 |
| 2023-06-29 09:00:00 | ES | Futures | 4855.56 | 4857.75 | 4842.11 | 4854.73 | 229738.0 |
| 2023-06-29 10:00:00 | ES | Futures | 4854.46 | 4862.15 | 4845.68 | 4851.17 | 289834.0 |
| 2023-06-29 11:00:00 | ES | Futures | 4851.17 | 4867.91 | 4850.34 | 4866.26 | 166650.0 |
| 2023-06-29 12:00:00 | ES | Futures | 4866.26 | 4872.85 | 4861.05 | 4865.71 | 127671.0 |
| 2023-06-29 13:00:00 | ES | Futures | 4865.71 | 4866.81 | 4857.2 | 4859.13 | 138015.0 |
| 2023-06-29 14:00:00 | ES | Futures | 4859.13 | 4862.69 | 4851.17 | 4862.69 | 139361.0 |
| 2023-06-29 15:00:00 | ES | Futures | 4862.69 | 4871.75 | 4859.68 | 4871.48 | 215120.0 |
| 2023-06-29 16:00:00 | ES | Futures | 4871.2 | 4873.13 | 4869.56 | 4870.66 | 61319.0 |
| 2023-06-29 18:00:00 | ES | Futures | 4870.11 | 4871.48 | 4868.73 | 4870.66 | 3179.0 |
| 2023-06-29 19:00:00 | ES | Futures | 4870.66 | 4874.22 | 4870.38 | 4872.3 | 3602.0 |
| 2023-06-29 20:00:00 | ES | Futures | 4872.3 | 4873.13 | 4867.64 | 4870.11 | 7635.0 |
| 2023-06-29 21:00:00 | ES | Futures | 4870.11 | 4876.15 | 4870.11 | 4874.77 | 8177.0 |
| 2023-06-29 22:00:00 | ES | Futures | 4874.77 | 4877.79 | 4874.22 | 4874.22 | 5439.0 |
| 2023-06-29 23:00:00 | ES | Futures | 4874.5 | 4875.6 | 4870.93 | 4872.03 | 5303.0 |
| 2023-06-29 00:00:00 | NQ | Futures | 16851.69 | 16860.87 | 16850.02 | 16851.97 | 2003.0 |
| 2023-06-29 01:00:00 | NQ | Futures | 16852.52 | 16870.88 | 16842.51 | 16853.63 | 3824.0 |
| 2023-06-29 02:00:00 | NQ | Futures | 16852.8 | 16854.19 | 16837.78 | 16840.01 | 2846.0 |
| 2023-06-29 03:00:00 | NQ | Futures | 16838.89 | 16847.24 | 16815.53 | 16834.72 | 7229.0 |
| 2023-06-29 04:00:00 | NQ | Futures | 16834.72 | 16870.88 | 16833.05 | 16863.93 | 7903.0 |
| 2023-06-29 05:00:00 | NQ | Futures | 16864.2 | 16885.34 | 16851.97 | 16882.56 | 4558.0 |
| 2023-06-29 06:00:00 | NQ | Futures | 16882.84 | 16907.04 | 16874.22 | 16892.57 | 7317.0 |
| 2023-06-29 07:00:00 | NQ | Futures | 16892.85 | 16903.14 | 16877.83 | 16890.63 | 6994.0 |
| 2023-06-29 08:00:00 | NQ | Futures | 16889.79 | 16913.43 | 16829.72 | 16841.95 | 24853.0 |
| 2023-06-29 09:00:00 | NQ | Futures | 16842.51 | 16850.02 | 16774.65 | 16797.17 | 101730.0 |
| 2023-06-29 10:00:00 | NQ | Futures | 16797.45 | 16835.28 | 16719.58 | 16764.91 | 122621.0 |
| 2023-06-29 11:00:00 | NQ | Futures | 16765.47 | 16839.17 | 16758.79 | 16825.27 | 65499.0 |
| 2023-06-29 12:00:00 | NQ | Futures | 16825.27 | 16843.34 | 16773.25 | 16787.44 | 48797.0 |
| 2023-06-29 13:00:00 | NQ | Futures | 16787.72 | 16803.85 | 16750.73 | 16756.84 | 45735.0 |
| 2023-06-29 14:00:00 | NQ | Futures | 16756.84 | 16776.59 | 16729.03 | 16775.2 | 46525.0 |
| 2023-06-29 15:00:00 | NQ | Futures | 16775.76 | 16806.91 | 16753.51 | 16802.74 | 56798.0 |
| 2023-06-29 16:00:00 | NQ | Futures | 16803.01 | 16818.31 | 16797.73 | 16808.3 | 12985.0 |
| 2023-06-29 18:00:00 | NQ | Futures | 16805.8 | 16811.91 | 16798.01 | 16806.91 | 1886.0 |
| 2023-06-29 19:00:00 | NQ | Futures | 16806.91 | 16827.21 | 16806.63 | 16818.03 | 2259.0 |
| 2023-06-29 20:00:00 | NQ | Futures | 16817.76 | 16822.21 | 16798.29 | 16809.69 | 3505.0 |
| 2023-06-29 21:00:00 | NQ | Futures | 16809.69 | 16839.73 | 16809.13 | 16830.55 | 4797.0 |
| 2023-06-29 22:00:00 | NQ | Futures | 16830.27 | 16846.96 | 16829.99 | 16830.27 | 3061.0 |
| 2023-06-29 23:00:00 | NQ | Futures | 16830.27 | 16836.11 | 16820.26 | 16824.43 | 2458.0 |
| 2023-06-29 00:00:00 | YM | Futures | 37387.7 | 37393.1 | 37381.1 | 37385.5 | 413.0 |
| 2023-06-29 01:00:00 | YM | Futures | 37385.5 | 37400.8 | 37355.9 | 37377.8 | 1174.0 |
| 2023-06-29 02:00:00 | YM | Futures | 37376.7 | 37378.9 | 37353.7 | 37357.0 | 1200.0 |
| 2023-06-29 03:00:00 | YM | Futures | 37357.0 | 37384.4 | 37352.6 | 37365.8 | 2464.0 |
> showing 50 of 2,021 rows — these rows as CSV