PREVIEW / futures_1hour / 2023-12-03
file: by_date/futures_1hour/2023/2023-12-03.parquet size: 19 KB rows: 436
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-12-03 18:00:00 | ES | Futures | 5000.2 | 5001.56 | 4993.96 | 4994.23 | 17155.0 |
| 2023-12-03 19:00:00 | ES | Futures | 4994.5 | 4994.77 | 4989.61 | 4991.79 | 13233.0 |
| 2023-12-03 20:00:00 | ES | Futures | 4991.79 | 4992.87 | 4989.88 | 4991.51 | 10085.0 |
| 2023-12-03 21:00:00 | ES | Futures | 4991.51 | 4991.79 | 4989.07 | 4990.16 | 6802.0 |
| 2023-12-03 22:00:00 | ES | Futures | 4989.88 | 4990.43 | 4988.53 | 4990.16 | 6087.0 |
| 2023-12-03 23:00:00 | ES | Futures | 4990.16 | 4993.14 | 4989.61 | 4991.79 | 6075.0 |
| 2023-12-03 18:00:00 | NQ | Futures | 17602.68 | 17607.07 | 17565.6 | 17569.44 | 8294.0 |
| 2023-12-03 19:00:00 | NQ | Futures | 17569.72 | 17570.54 | 17548.57 | 17552.14 | 5909.0 |
| 2023-12-03 20:00:00 | NQ | Futures | 17552.14 | 17564.5 | 17551.32 | 17562.03 | 4234.0 |
| 2023-12-03 21:00:00 | NQ | Futures | 17561.48 | 17562.3 | 17549.39 | 17552.69 | 3085.0 |
| 2023-12-03 22:00:00 | NQ | Futures | 17552.96 | 17554.61 | 17541.7 | 17547.47 | 3045.0 |
| 2023-12-03 23:00:00 | NQ | Futures | 17546.92 | 17562.03 | 17545.82 | 17557.91 | 2933.0 |
| 2023-12-03 18:00:00 | YM | Futures | 39397.5 | 39412.7 | 39360.6 | 39363.9 | 2225.0 |
| 2023-12-03 19:00:00 | YM | Futures | 39365.0 | 39392.1 | 39341.1 | 39380.2 | 2159.0 |
| 2023-12-03 20:00:00 | YM | Futures | 39379.1 | 39383.4 | 39362.8 | 39373.7 | 1931.0 |
| 2023-12-03 21:00:00 | YM | Futures | 39374.8 | 39380.2 | 39363.9 | 39373.7 | 670.0 |
| 2023-12-03 22:00:00 | YM | Futures | 39373.7 | 39380.2 | 39366.1 | 39379.1 | 750.0 |
| 2023-12-03 23:00:00 | YM | Futures | 39379.1 | 39391.0 | 39373.7 | 39383.4 | 663.0 |
| 2023-12-03 18:00:00 | CL | Futures | 62.61 | 62.99 | 62.43 | 62.82 | 5654.0 |
| 2023-12-03 19:00:00 | CL | Futures | 62.82 | 62.83 | 62.64 | 62.68 | 1725.0 |
| 2023-12-03 20:00:00 | CL | Futures | 62.67 | 62.69 | 62.0 | 62.01 | 8546.0 |
| 2023-12-03 21:00:00 | CL | Futures | 62.01 | 62.03 | 61.76 | 61.96 | 6370.0 |
| 2023-12-03 22:00:00 | CL | Futures | 61.96 | 61.98 | 61.77 | 61.87 | 2678.0 |
| 2023-12-03 23:00:00 | CL | Futures | 61.87 | 61.87 | 61.73 | 61.75 | 1410.0 |
| 2023-12-03 18:00:00 | GC | Futures | 2317.0 | 2381.1 | 2314.3 | 2363.6 | 47803.0 |
| 2023-12-03 19:00:00 | GC | Futures | 2363.6 | 2365.7 | 2334.7 | 2340.5 | 21308.0 |
| 2023-12-03 20:00:00 | GC | Futures | 2340.6 | 2343.5 | 2326.2 | 2331.8 | 15058.0 |
| 2023-12-03 21:00:00 | GC | Futures | 2331.9 | 2333.0 | 2327.7 | 2332.3 | 4583.0 |
| 2023-12-03 22:00:00 | GC | Futures | 2332.0 | 2333.5 | 2327.9 | 2329.3 | 3280.0 |
| 2023-12-03 23:00:00 | GC | Futures | 2329.4 | 2329.5 | 2324.9 | 2329.1 | 3666.0 |
| 2023-12-03 18:00:00 | ZN | Futures | 112.148075 | 112.163944 | 112.068729 | 112.068729 | 63.0 |
| 2023-12-03 19:00:00 | ZN | Futures | 112.100467 | 112.100467 | 111.973513 | 111.989382 | 31.0 |
| 2023-12-03 20:00:00 | ZN | Futures | 111.910036 | 111.910036 | 111.894167 | 111.910036 | 22.0 |
| 2023-12-03 21:00:00 | ZN | Futures | 111.894167 | 111.894167 | 111.894167 | 111.894167 | 75.0 |
| 2023-12-03 22:00:00 | ZN | Futures | 111.894167 | 111.910036 | 111.894167 | 111.910036 | 7.0 |
| 2023-12-03 23:00:00 | ZN | Futures | 111.878297 | 111.878297 | 111.878297 | 111.878297 | 40.0 |
> showing 36 of 436 rows — these rows as CSV