PREVIEW / futures_1hour / 2024-07-05
file: by_date/futures_1hour/2024/2024-07-05.parquet size: 54 KB rows: 1,592
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-05 00:00:00 | ES | Futures | 5865.13 | 5867.23 | 5864.35 | 5865.66 | 2532.0 |
| 2024-07-05 01:00:00 | ES | Futures | 5865.92 | 5868.54 | 5864.87 | 5868.02 | 4439.0 |
| 2024-07-05 02:00:00 | ES | Futures | 5867.75 | 5871.16 | 5867.49 | 5869.06 | 7583.0 |
| 2024-07-05 03:00:00 | ES | Futures | 5869.06 | 5870.9 | 5865.13 | 5867.49 | 16174.0 |
| 2024-07-05 04:00:00 | ES | Futures | 5867.23 | 5868.54 | 5862.51 | 5863.3 | 11945.0 |
| 2024-07-05 05:00:00 | ES | Futures | 5863.56 | 5866.18 | 5862.51 | 5863.82 | 7998.0 |
| 2024-07-05 06:00:00 | ES | Futures | 5864.08 | 5866.18 | 5862.51 | 5863.03 | 9992.0 |
| 2024-07-05 07:00:00 | ES | Futures | 5863.03 | 5865.13 | 5860.41 | 5861.99 | 15006.0 |
| 2024-07-05 08:00:00 | ES | Futures | 5861.99 | 5877.72 | 5856.74 | 5863.03 | 61393.0 |
| 2024-07-05 09:00:00 | ES | Futures | 5863.3 | 5872.73 | 5860.15 | 5872.73 | 147879.0 |
| 2024-07-05 10:00:00 | ES | Futures | 5872.73 | 5875.88 | 5857.27 | 5870.9 | 189988.0 |
| 2024-07-05 11:00:00 | ES | Futures | 5870.9 | 5885.58 | 5867.75 | 5883.75 | 106112.0 |
| 2024-07-05 12:00:00 | ES | Futures | 5883.75 | 5885.84 | 5879.03 | 5883.48 | 73876.0 |
| 2024-07-05 13:00:00 | ES | Futures | 5883.48 | 5894.49 | 5881.12 | 5891.35 | 79932.0 |
| 2024-07-05 14:00:00 | ES | Futures | 5891.61 | 5892.92 | 5886.63 | 5892.13 | 66450.0 |
| 2024-07-05 15:00:00 | ES | Futures | 5891.87 | 5899.74 | 5890.82 | 5895.54 | 174761.0 |
| 2024-07-05 16:00:00 | ES | Futures | 5895.54 | 5895.81 | 5888.2 | 5888.2 | 71504.0 |
| 2024-07-05 00:00:00 | NQ | Futures | 21555.76 | 21569.48 | 21553.91 | 21564.99 | 2087.0 |
| 2024-07-05 01:00:00 | NQ | Futures | 21564.99 | 21574.76 | 21559.45 | 21571.86 | 2502.0 |
| 2024-07-05 02:00:00 | NQ | Futures | 21571.59 | 21604.59 | 21568.95 | 21587.7 | 6267.0 |
| 2024-07-05 03:00:00 | NQ | Futures | 21588.49 | 21599.05 | 21568.43 | 21585.06 | 6819.0 |
| 2024-07-05 04:00:00 | NQ | Futures | 21584.79 | 21602.22 | 21567.9 | 21571.59 | 6658.0 |
| 2024-07-05 05:00:00 | NQ | Futures | 21571.86 | 21589.28 | 21568.69 | 21575.03 | 3825.0 |
| 2024-07-05 06:00:00 | NQ | Futures | 21574.76 | 21593.24 | 21570.01 | 21584.0 | 3652.0 |
| 2024-07-05 07:00:00 | NQ | Futures | 21584.79 | 21591.66 | 21569.48 | 21576.08 | 5367.0 |
| 2024-07-05 08:00:00 | NQ | Futures | 21576.08 | 21642.34 | 21512.46 | 21568.16 | 25801.0 |
| 2024-07-05 09:00:00 | NQ | Futures | 21567.9 | 21664.52 | 21552.85 | 21661.08 | 99901.0 |
| 2024-07-05 10:00:00 | NQ | Futures | 21661.88 | 21701.47 | 21606.7 | 21671.91 | 101839.0 |
| 2024-07-05 11:00:00 | NQ | Futures | 21671.38 | 21759.55 | 21657.12 | 21748.2 | 64246.0 |
| 2024-07-05 12:00:00 | NQ | Futures | 21747.93 | 21770.11 | 21727.87 | 21740.54 | 45505.0 |
| 2024-07-05 13:00:00 | NQ | Futures | 21740.81 | 21792.81 | 21726.55 | 21777.76 | 42498.0 |
| 2024-07-05 14:00:00 | NQ | Futures | 21778.29 | 21783.31 | 21746.09 | 21766.94 | 36132.0 |
| 2024-07-05 15:00:00 | NQ | Futures | 21766.68 | 21793.87 | 21760.87 | 21775.12 | 58547.0 |
| 2024-07-05 16:00:00 | NQ | Futures | 21775.12 | 21775.65 | 21741.86 | 21743.18 | 15218.0 |
| 2024-07-05 00:00:00 | YM | Futures | 41688.7 | 41699.2 | 41684.5 | 41695.0 | 247.0 |
| 2024-07-05 01:00:00 | YM | Futures | 41695.0 | 41716.0 | 41687.6 | 41710.7 | 458.0 |
| 2024-07-05 02:00:00 | YM | Futures | 41709.7 | 41720.2 | 41702.3 | 41710.7 | 1215.0 |
| 2024-07-05 03:00:00 | YM | Futures | 41711.8 | 41718.1 | 41679.2 | 41699.2 | 1763.0 |
| 2024-07-05 04:00:00 | YM | Futures | 41699.2 | 41708.6 | 41647.7 | 41666.6 | 2465.0 |
| 2024-07-05 05:00:00 | YM | Futures | 41667.7 | 41681.3 | 41656.1 | 41670.8 | 1230.0 |
| 2024-07-05 06:00:00 | YM | Futures | 41670.8 | 41674.0 | 41636.1 | 41641.4 | 1282.0 |
| 2024-07-05 07:00:00 | YM | Futures | 41640.3 | 41655.1 | 41617.2 | 41621.4 | 1851.0 |
| 2024-07-05 08:00:00 | YM | Futures | 41623.5 | 41732.8 | 41578.4 | 41669.8 | 5997.0 |
| 2024-07-05 09:00:00 | YM | Futures | 41669.8 | 41686.6 | 41546.8 | 41623.5 | 21207.0 |
| 2024-07-05 10:00:00 | YM | Futures | 41624.6 | 41629.8 | 41491.1 | 41625.6 | 19187.0 |
| 2024-07-05 11:00:00 | YM | Futures | 41624.6 | 41695.0 | 41602.5 | 41664.5 | 9971.0 |
| 2024-07-05 12:00:00 | YM | Futures | 41665.6 | 41668.7 | 41552.1 | 41595.2 | 7167.0 |
| 2024-07-05 13:00:00 | YM | Futures | 41595.2 | 41686.6 | 41575.2 | 41663.5 | 6359.0 |
| 2024-07-05 14:00:00 | YM | Futures | 41665.6 | 41731.8 | 41639.3 | 41713.9 | 6781.0 |
| 2024-07-05 15:00:00 | YM | Futures | 41712.8 | 41745.4 | 41678.2 | 41710.7 | 10148.0 |
> showing 50 of 1,592 rows — these rows as CSV