PREVIEW / futures_1hour / 2023-07-30
file: by_date/futures_1hour/2023/2023-07-30.parquet size: 19 KB rows: 410
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-07-30 18:00:00 | ES | Futures | 5060.62 | 5070.77 | 5059.79 | 5067.75 | 11614.0 |
| 2023-07-30 19:00:00 | ES | Futures | 5068.03 | 5069.13 | 5063.91 | 5064.46 | 5505.0 |
| 2023-07-30 20:00:00 | ES | Futures | 5064.46 | 5064.74 | 5059.79 | 5060.62 | 8392.0 |
| 2023-07-30 21:00:00 | ES | Futures | 5060.62 | 5063.64 | 5052.93 | 5053.75 | 13829.0 |
| 2023-07-30 22:00:00 | ES | Futures | 5053.75 | 5056.23 | 5049.64 | 5051.56 | 11007.0 |
| 2023-07-30 23:00:00 | ES | Futures | 5051.56 | 5051.83 | 5047.17 | 5048.81 | 8594.0 |
| 2023-07-30 18:00:00 | NQ | Futures | 17633.51 | 17708.05 | 17623.5 | 17690.81 | 9502.0 |
| 2023-07-30 19:00:00 | NQ | Futures | 17691.37 | 17694.15 | 17671.06 | 17675.23 | 4244.0 |
| 2023-07-30 20:00:00 | NQ | Futures | 17674.68 | 17676.35 | 17632.68 | 17638.52 | 8167.0 |
| 2023-07-30 21:00:00 | NQ | Futures | 17637.96 | 17647.7 | 17600.69 | 17605.42 | 10808.0 |
| 2023-07-30 22:00:00 | NQ | Futures | 17604.31 | 17614.6 | 17588.74 | 17598.19 | 6633.0 |
| 2023-07-30 23:00:00 | NQ | Futures | 17598.75 | 17598.75 | 17573.16 | 17585.95 | 5461.0 |
| 2023-07-30 18:00:00 | YM | Futures | 38999.2 | 39038.7 | 38999.2 | 39021.1 | 1653.0 |
| 2023-07-30 19:00:00 | YM | Futures | 39023.3 | 39029.9 | 39002.5 | 39003.6 | 689.0 |
| 2023-07-30 20:00:00 | YM | Futures | 39002.5 | 39004.7 | 38986.1 | 38995.9 | 1028.0 |
| 2023-07-30 21:00:00 | YM | Futures | 38994.8 | 39016.7 | 38947.7 | 38952.1 | 1295.0 |
| 2023-07-30 22:00:00 | YM | Futures | 38952.1 | 38971.8 | 38929.1 | 38942.3 | 1085.0 |
| 2023-07-30 23:00:00 | YM | Futures | 38942.3 | 38947.7 | 38913.8 | 38922.5 | 1186.0 |
| 2023-07-30 18:00:00 | CL | Futures | 65.59 | 65.59 | 65.4 | 65.42 | 1824.0 |
| 2023-07-30 19:00:00 | CL | Futures | 65.42 | 65.5 | 65.39 | 65.4 | 1036.0 |
| 2023-07-30 20:00:00 | CL | Futures | 65.39 | 65.44 | 65.32 | 65.33 | 1342.0 |
| 2023-07-30 21:00:00 | CL | Futures | 65.33 | 65.53 | 65.26 | 65.4 | 3056.0 |
| 2023-07-30 22:00:00 | CL | Futures | 65.4 | 65.43 | 65.31 | 65.37 | 1664.0 |
| 2023-07-30 23:00:00 | CL | Futures | 65.37 | 65.37 | 65.18 | 65.21 | 1916.0 |
| 2023-07-30 18:00:00 | GC | Futures | 2231.6 | 2232.6 | 2230.6 | 2232.0 | 968.0 |
| 2023-07-30 19:00:00 | GC | Futures | 2232.2 | 2232.2 | 2229.3 | 2229.9 | 2047.0 |
| 2023-07-30 20:00:00 | GC | Futures | 2229.9 | 2230.7 | 2227.9 | 2229.9 | 1781.0 |
| 2023-07-30 21:00:00 | GC | Futures | 2229.9 | 2230.3 | 2226.8 | 2228.0 | 4457.0 |
| 2023-07-30 22:00:00 | GC | Futures | 2228.0 | 2230.0 | 2227.3 | 2227.9 | 2302.0 |
| 2023-07-30 23:00:00 | GC | Futures | 2227.9 | 2228.9 | 2224.7 | 2225.5 | 2650.0 |
| 2023-07-30 18:00:00 | ZN | Futures | 113.662485 | 113.662485 | 113.598755 | 113.63062 | 6068.0 |
| 2023-07-30 19:00:00 | ZN | Futures | 113.646553 | 113.646553 | 113.56689 | 113.582823 | 7614.0 |
| 2023-07-30 20:00:00 | ZN | Futures | 113.582823 | 113.598755 | 113.43943 | 113.471295 | 15717.0 |
| 2023-07-30 21:00:00 | ZN | Futures | 113.455363 | 113.519093 | 113.407565 | 113.455363 | 21808.0 |
| 2023-07-30 22:00:00 | ZN | Futures | 113.43943 | 113.455363 | 113.423498 | 113.423498 | 6161.0 |
| 2023-07-30 23:00:00 | ZN | Futures | 113.423498 | 113.455363 | 113.3757 | 113.391633 | 12686.0 |
> showing 36 of 410 rows — these rows as CSV