PREVIEW / futures_1hour / 2023-10-15
file: by_date/futures_1hour/2023/2023-10-15.parquet size: 19 KB rows: 423
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-10-15 18:00:00 | ES | Futures | 4732.45 | 4742.5 | 4732.45 | 4740.05 | 13183.0 |
| 2023-10-15 19:00:00 | ES | Futures | 4740.32 | 4745.48 | 4738.97 | 4744.67 | 5408.0 |
| 2023-10-15 20:00:00 | ES | Futures | 4744.67 | 4750.1 | 4743.31 | 4744.94 | 12789.0 |
| 2023-10-15 21:00:00 | ES | Futures | 4744.94 | 4749.28 | 4743.58 | 4744.12 | 8455.0 |
| 2023-10-15 22:00:00 | ES | Futures | 4744.12 | 4748.74 | 4741.68 | 4742.77 | 5660.0 |
| 2023-10-15 23:00:00 | ES | Futures | 4742.77 | 4744.12 | 4740.59 | 4743.31 | 3637.0 |
| 2023-10-15 18:00:00 | NQ | Futures | 16611.69 | 16656.74 | 16611.69 | 16642.73 | 7099.0 |
| 2023-10-15 19:00:00 | NQ | Futures | 16643.55 | 16662.78 | 16635.86 | 16662.5 | 3420.0 |
| 2023-10-15 20:00:00 | NQ | Futures | 16662.5 | 16685.58 | 16658.93 | 16665.8 | 6172.0 |
| 2023-10-15 21:00:00 | NQ | Futures | 16666.07 | 16685.85 | 16659.76 | 16662.78 | 4490.0 |
| 2023-10-15 22:00:00 | NQ | Futures | 16662.78 | 16677.34 | 16652.89 | 16655.64 | 3704.0 |
| 2023-10-15 23:00:00 | NQ | Futures | 16655.64 | 16662.23 | 16646.3 | 16660.03 | 2766.0 |
| 2023-10-15 18:00:00 | YM | Futures | 36676.9 | 36757.1 | 36676.9 | 36742.0 | 1927.0 |
| 2023-10-15 19:00:00 | YM | Futures | 36742.0 | 36777.8 | 36738.7 | 36765.8 | 1429.0 |
| 2023-10-15 20:00:00 | YM | Futures | 36765.8 | 36787.5 | 36738.7 | 36743.0 | 3048.0 |
| 2023-10-15 21:00:00 | YM | Futures | 36744.1 | 36770.2 | 36733.3 | 36736.5 | 2087.0 |
| 2023-10-15 22:00:00 | YM | Futures | 36736.5 | 36769.1 | 36719.2 | 36739.8 | 1227.0 |
| 2023-10-15 23:00:00 | YM | Futures | 36739.8 | 36742.0 | 36714.8 | 36734.4 | 839.0 |
| 2023-10-15 18:00:00 | CL | Futures | 72.48 | 72.74 | 71.97 | 72.38 | 3694.0 |
| 2023-10-15 19:00:00 | CL | Futures | 72.39 | 72.63 | 72.37 | 72.41 | 1413.0 |
| 2023-10-15 20:00:00 | CL | Futures | 72.42 | 72.42 | 72.07 | 72.28 | 2996.0 |
| 2023-10-15 21:00:00 | CL | Futures | 72.32 | 72.48 | 72.1 | 72.44 | 2594.0 |
| 2023-10-15 22:00:00 | CL | Futures | 72.46 | 72.63 | 72.38 | 72.51 | 916.0 |
| 2023-10-15 23:00:00 | CL | Futures | 72.52 | 72.63 | 72.37 | 72.55 | 799.0 |
| 2023-10-15 18:00:00 | GC | Futures | 2168.4 | 2170.3 | 2160.1 | 2164.0 | 6894.0 |
| 2023-10-15 19:00:00 | GC | Futures | 2164.0 | 2166.2 | 2160.5 | 2165.2 | 6801.0 |
| 2023-10-15 20:00:00 | GC | Futures | 2165.1 | 2165.3 | 2160.2 | 2160.5 | 4441.0 |
| 2023-10-15 21:00:00 | GC | Futures | 2160.5 | 2162.8 | 2159.3 | 2159.5 | 4466.0 |
| 2023-10-15 22:00:00 | GC | Futures | 2159.6 | 2160.9 | 2157.3 | 2159.4 | 4275.0 |
| 2023-10-15 23:00:00 | GC | Futures | 2159.4 | 2159.5 | 2156.7 | 2159.2 | 4260.0 |
| 2023-10-15 18:00:00 | ZN | Futures | 109.355085 | 109.386823 | 109.180523 | 109.228131 | 14777.0 |
| 2023-10-15 19:00:00 | ZN | Futures | 109.228131 | 109.291608 | 109.180523 | 109.259869 | 9461.0 |
| 2023-10-15 20:00:00 | ZN | Futures | 109.244 | 109.291608 | 109.117046 | 109.164654 | 25178.0 |
| 2023-10-15 21:00:00 | ZN | Futures | 109.148784 | 109.212261 | 109.132915 | 109.164654 | 14220.0 |
| 2023-10-15 22:00:00 | ZN | Futures | 109.180523 | 109.228131 | 109.164654 | 109.180523 | 7008.0 |
| 2023-10-15 23:00:00 | ZN | Futures | 109.180523 | 109.212261 | 109.117046 | 109.164654 | 9197.0 |
> showing 36 of 423 rows — these rows as CSV