PREVIEW / futures_1hour / 2022-01-09
file: by_date/futures_1hour/2022/2022-01-09.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 |
|---|---|---|---|---|---|---|---|
| 2022-01-09 18:00:00 | ES | Futures | 5284.16 | 5286.99 | 5260.12 | 5268.6 | 25942.0 |
| 2022-01-09 19:00:00 | ES | Futures | 5268.89 | 5275.96 | 5264.93 | 5272.85 | 12096.0 |
| 2022-01-09 20:00:00 | ES | Futures | 5272.56 | 5279.35 | 5264.08 | 5277.94 | 13946.0 |
| 2022-01-09 21:00:00 | ES | Futures | 5277.94 | 5281.61 | 5274.82 | 5278.22 | 7564.0 |
| 2022-01-09 22:00:00 | ES | Futures | 5277.94 | 5280.76 | 5275.39 | 5279.92 | 3725.0 |
| 2022-01-09 23:00:00 | ES | Futures | 5279.92 | 5288.68 | 5279.63 | 5287.83 | 7306.0 |
| 2022-01-09 18:00:00 | NQ | Futures | 18073.0 | 18097.05 | 17986.05 | 18036.77 | 13350.0 |
| 2022-01-09 19:00:00 | NQ | Futures | 18038.51 | 18077.92 | 18015.32 | 18065.75 | 6270.0 |
| 2022-01-09 20:00:00 | NQ | Futures | 18066.33 | 18093.86 | 18019.67 | 18087.49 | 7160.0 |
| 2022-01-09 21:00:00 | NQ | Futures | 18087.78 | 18111.83 | 18079.95 | 18086.62 | 5524.0 |
| 2022-01-09 22:00:00 | NQ | Futures | 18086.62 | 18106.04 | 18068.36 | 18102.27 | 3526.0 |
| 2022-01-09 23:00:00 | NQ | Futures | 18102.56 | 18136.18 | 18100.82 | 18131.54 | 3955.0 |
| 2022-01-09 18:00:00 | YM | Futures | 40592.8 | 40631.0 | 40411.9 | 40479.3 | 5113.0 |
| 2022-01-09 19:00:00 | YM | Futures | 40478.2 | 40522.0 | 40451.2 | 40488.3 | 2206.0 |
| 2022-01-09 20:00:00 | YM | Futures | 40488.3 | 40538.8 | 40441.1 | 40525.4 | 2038.0 |
| 2022-01-09 21:00:00 | YM | Futures | 40529.9 | 40545.6 | 40505.1 | 40529.9 | 1335.0 |
| 2022-01-09 22:00:00 | YM | Futures | 40528.7 | 40538.8 | 40510.7 | 40529.9 | 856.0 |
| 2022-01-09 23:00:00 | YM | Futures | 40534.3 | 40611.9 | 40532.1 | 40579.3 | 3356.0 |
| 2022-01-09 18:00:00 | CL | Futures | 56.08 | 56.24 | 55.71 | 55.85 | 4934.0 |
| 2022-01-09 19:00:00 | CL | Futures | 55.86 | 55.95 | 55.77 | 55.91 | 2260.0 |
| 2022-01-09 20:00:00 | CL | Futures | 55.91 | 56.06 | 55.79 | 56.02 | 6203.0 |
| 2022-01-09 21:00:00 | CL | Futures | 56.02 | 56.39 | 55.98 | 56.22 | 7086.0 |
| 2022-01-09 22:00:00 | CL | Futures | 56.21 | 56.26 | 56.12 | 56.21 | 3283.0 |
| 2022-01-09 23:00:00 | CL | Futures | 56.2 | 56.23 | 56.14 | 56.2 | 1270.0 |
| 2022-01-09 18:00:00 | GC | Futures | 2159.5 | 2159.5 | 2156.6 | 2157.5 | 1593.0 |
| 2022-01-09 19:00:00 | GC | Futures | 2157.5 | 2157.5 | 2151.2 | 2156.3 | 2247.0 |
| 2022-01-09 20:00:00 | GC | Futures | 2156.5 | 2159.4 | 2154.9 | 2156.9 | 3927.0 |
| 2022-01-09 21:00:00 | GC | Futures | 2156.8 | 2158.5 | 2155.3 | 2156.1 | 2489.0 |
| 2022-01-09 22:00:00 | GC | Futures | 2156.0 | 2156.0 | 2152.6 | 2153.1 | 2917.0 |
| 2022-01-09 23:00:00 | GC | Futures | 2153.1 | 2154.7 | 2153.0 | 2153.6 | 1053.0 |
| 2022-01-09 18:00:00 | ZN | Futures | 131.764681 | 131.780725 | 131.556117 | 131.636334 | 28007.0 |
| 2022-01-09 19:00:00 | ZN | Futures | 131.636334 | 131.716551 | 131.57216 | 131.700507 | 12207.0 |
| 2022-01-09 20:00:00 | ZN | Futures | 131.716551 | 131.732594 | 131.588203 | 131.604247 | 12625.0 |
| 2022-01-09 21:00:00 | ZN | Futures | 131.604247 | 131.62029 | 131.491943 | 131.52403 | 13501.0 |
| 2022-01-09 22:00:00 | ZN | Futures | 131.52403 | 131.540073 | 131.443813 | 131.491943 | 14713.0 |
| 2022-01-09 23:00:00 | ZN | Futures | 131.507986 | 131.507986 | 131.459856 | 131.491943 | 8328.0 |
> showing 36 of 423 rows — these rows as CSV