PREVIEW / futures_1hour / 2022-07-10
file: by_date/futures_1hour/2022/2022-07-10.parquet size: 19 KB rows: 415
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-10 18:00:00 | ES | Futures | 4419.04 | 4419.89 | 4406.29 | 4409.12 | 7623.0 |
| 2022-07-10 19:00:00 | ES | Futures | 4409.4 | 4418.75 | 4407.7 | 4415.35 | 7549.0 |
| 2022-07-10 20:00:00 | ES | Futures | 4415.35 | 4415.92 | 4407.7 | 4412.52 | 9027.0 |
| 2022-07-10 21:00:00 | ES | Futures | 4412.52 | 4412.8 | 4392.97 | 4393.26 | 15459.0 |
| 2022-07-10 22:00:00 | ES | Futures | 4393.26 | 4396.09 | 4390.71 | 4391.27 | 11559.0 |
| 2022-07-10 23:00:00 | ES | Futures | 4391.27 | 4394.39 | 4386.74 | 4393.54 | 8316.0 |
| 2022-07-10 18:00:00 | NQ | Futures | 14056.73 | 14056.73 | 13990.2 | 14005.53 | 5279.0 |
| 2022-07-10 19:00:00 | NQ | Futures | 14006.11 | 14030.99 | 13993.39 | 14019.13 | 4869.0 |
| 2022-07-10 20:00:00 | NQ | Futures | 14019.13 | 14026.65 | 13990.78 | 14019.71 | 4350.0 |
| 2022-07-10 21:00:00 | NQ | Futures | 14019.13 | 14019.42 | 13945.37 | 13947.11 | 7355.0 |
| 2022-07-10 22:00:00 | NQ | Futures | 13946.82 | 13953.18 | 13923.97 | 13928.31 | 6826.0 |
| 2022-07-10 23:00:00 | NQ | Futures | 13928.02 | 13942.48 | 13911.82 | 13941.32 | 4584.0 |
| 2022-07-10 18:00:00 | YM | Futures | 35343.1 | 35343.1 | 35257.4 | 35274.3 | 1305.0 |
| 2022-07-10 19:00:00 | YM | Futures | 35276.5 | 35348.7 | 35266.4 | 35321.7 | 1061.0 |
| 2022-07-10 20:00:00 | YM | Futures | 35325.1 | 35328.4 | 35265.2 | 35298.0 | 1091.0 |
| 2022-07-10 21:00:00 | YM | Futures | 35293.5 | 35293.5 | 35152.4 | 35156.9 | 1960.0 |
| 2022-07-10 22:00:00 | YM | Futures | 35155.8 | 35180.6 | 35138.9 | 35160.3 | 1411.0 |
| 2022-07-10 23:00:00 | YM | Futures | 35155.8 | 35167.1 | 35116.3 | 35161.4 | 1404.0 |
| 2022-07-10 18:00:00 | CL | Futures | 81.12 | 81.12 | 80.29 | 80.65 | 2843.0 |
| 2022-07-10 19:00:00 | CL | Futures | 80.64 | 80.98 | 80.61 | 80.81 | 1385.0 |
| 2022-07-10 20:00:00 | CL | Futures | 80.83 | 81.32 | 80.7 | 81.1 | 4356.0 |
| 2022-07-10 21:00:00 | CL | Futures | 81.1 | 81.2 | 80.13 | 80.48 | 9494.0 |
| 2022-07-10 22:00:00 | CL | Futures | 80.46 | 80.66 | 80.19 | 80.27 | 4076.0 |
| 2022-07-10 23:00:00 | CL | Futures | 80.27 | 80.58 | 80.22 | 80.55 | 2214.0 |
| 2022-07-10 18:00:00 | GC | Futures | 2078.5 | 2080.2 | 2076.1 | 2079.7 | 1588.0 |
| 2022-07-10 19:00:00 | GC | Futures | 2079.5 | 2080.1 | 2077.1 | 2077.4 | 941.0 |
| 2022-07-10 20:00:00 | GC | Futures | 2077.4 | 2078.3 | 2074.5 | 2076.7 | 2524.0 |
| 2022-07-10 21:00:00 | GC | Futures | 2076.8 | 2076.8 | 2072.6 | 2074.5 | 4321.0 |
| 2022-07-10 22:00:00 | GC | Futures | 2074.4 | 2078.7 | 2074.2 | 2076.3 | 3135.0 |
| 2022-07-10 23:00:00 | GC | Futures | 2076.3 | 2078.3 | 2076.2 | 2077.6 | 1152.0 |
| 2022-07-10 18:00:00 | ZN | Futures | 121.399081 | 121.415199 | 121.302374 | 121.33461 | 8263.0 |
| 2022-07-10 19:00:00 | ZN | Futures | 121.33461 | 121.350728 | 121.286257 | 121.350728 | 7974.0 |
| 2022-07-10 20:00:00 | ZN | Futures | 121.33461 | 121.399081 | 121.286257 | 121.382963 | 13323.0 |
| 2022-07-10 21:00:00 | ZN | Futures | 121.366846 | 121.399081 | 121.286257 | 121.350728 | 12298.0 |
| 2022-07-10 22:00:00 | ZN | Futures | 121.33461 | 121.415199 | 121.318492 | 121.382963 | 8825.0 |
| 2022-07-10 23:00:00 | ZN | Futures | 121.366846 | 121.415199 | 121.350728 | 121.382963 | 4008.0 |
> showing 36 of 415 rows — these rows as CSV