PREVIEW / futures_1hour / 2021-12-26
file: by_date/futures_1hour/2021/2021-12-26.parquet size: 18 KB rows: 398
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-26 18:00:00 | ES | Futures | 5335.91 | 5344.96 | 5335.63 | 5342.41 | 10268.0 |
| 2021-12-26 19:00:00 | ES | Futures | 5342.7 | 5346.66 | 5339.02 | 5340.15 | 6776.0 |
| 2021-12-26 20:00:00 | ES | Futures | 5340.43 | 5342.13 | 5336.48 | 5339.59 | 5603.0 |
| 2021-12-26 21:00:00 | ES | Futures | 5339.87 | 5342.98 | 5338.46 | 5341.28 | 2783.0 |
| 2021-12-26 22:00:00 | ES | Futures | 5341.28 | 5342.7 | 5339.87 | 5341.57 | 2042.0 |
| 2021-12-26 23:00:00 | ES | Futures | 5341.57 | 5341.57 | 5339.3 | 5339.87 | 1343.0 |
| 2021-12-26 18:00:00 | NQ | Futures | 18901.01 | 18952.88 | 18901.01 | 18945.06 | 5360.0 |
| 2021-12-26 19:00:00 | NQ | Futures | 18944.77 | 18969.11 | 18936.65 | 18942.45 | 4680.0 |
| 2021-12-26 20:00:00 | NQ | Futures | 18943.03 | 18945.35 | 18921.58 | 18937.23 | 3803.0 |
| 2021-12-26 21:00:00 | NQ | Futures | 18937.81 | 18951.72 | 18929.99 | 18946.22 | 2354.0 |
| 2021-12-26 22:00:00 | NQ | Futures | 18945.64 | 18953.75 | 18941.87 | 18945.64 | 1781.0 |
| 2021-12-26 23:00:00 | NQ | Futures | 18945.64 | 18946.8 | 18933.75 | 18937.52 | 1426.0 |
| 2021-12-26 18:00:00 | YM | Futures | 40266.9 | 40327.6 | 40264.6 | 40297.2 | 1694.0 |
| 2021-12-26 19:00:00 | YM | Futures | 40296.1 | 40318.6 | 40274.8 | 40282.6 | 997.0 |
| 2021-12-26 20:00:00 | YM | Futures | 40284.9 | 40293.9 | 40252.3 | 40272.5 | 999.0 |
| 2021-12-26 21:00:00 | YM | Futures | 40273.6 | 40300.6 | 40268.0 | 40283.7 | 553.0 |
| 2021-12-26 22:00:00 | YM | Futures | 40282.6 | 40291.6 | 40270.3 | 40281.5 | 408.0 |
| 2021-12-26 23:00:00 | YM | Futures | 40280.4 | 40286.0 | 40260.1 | 40268.0 | 396.0 |
| 2021-12-26 18:00:00 | CL | Futures | 52.17 | 52.24 | 51.95 | 52.13 | 3707.0 |
| 2021-12-26 19:00:00 | CL | Futures | 52.13 | 52.22 | 52.05 | 52.13 | 1999.0 |
| 2021-12-26 20:00:00 | CL | Futures | 52.15 | 52.15 | 51.81 | 52.06 | 6525.0 |
| 2021-12-26 21:00:00 | CL | Futures | 52.06 | 52.26 | 51.99 | 52.16 | 3484.0 |
| 2021-12-26 22:00:00 | CL | Futures | 52.16 | 52.18 | 52.05 | 52.11 | 1970.0 |
| 2021-12-26 23:00:00 | CL | Futures | 52.11 | 52.13 | 51.96 | 52.03 | 1868.0 |
| 2021-12-26 18:00:00 | GC | Futures | 2176.1 | 2176.1 | 2171.9 | 2173.7 | 1981.0 |
| 2021-12-26 19:00:00 | GC | Futures | 2173.7 | 2174.9 | 2172.8 | 2173.2 | 1310.0 |
| 2021-12-26 20:00:00 | GC | Futures | 2173.2 | 2179.4 | 2173.2 | 2178.0 | 4326.0 |
| 2021-12-26 21:00:00 | GC | Futures | 2178.0 | 2178.6 | 2176.5 | 2176.8 | 1795.0 |
| 2021-12-26 22:00:00 | GC | Futures | 2176.8 | 2178.1 | 2176.5 | 2178.1 | 1376.0 |
| 2021-12-26 23:00:00 | GC | Futures | 2177.9 | 2178.1 | 2175.1 | 2176.1 | 1013.0 |
| 2021-12-26 18:00:00 | ZN | Futures | 133.994718 | 134.074935 | 133.994718 | 134.074935 | 8507.0 |
| 2021-12-26 19:00:00 | ZN | Futures | 134.074935 | 134.074935 | 134.026805 | 134.058892 | 4552.0 |
| 2021-12-26 20:00:00 | ZN | Futures | 134.058892 | 134.090978 | 134.042848 | 134.090978 | 3758.0 |
| 2021-12-26 21:00:00 | ZN | Futures | 134.074935 | 134.090978 | 134.042848 | 134.074935 | 3149.0 |
| 2021-12-26 22:00:00 | ZN | Futures | 134.074935 | 134.090978 | 134.058892 | 134.074935 | 3205.0 |
| 2021-12-26 23:00:00 | ZN | Futures | 134.074935 | 134.074935 | 134.042848 | 134.058892 | 1497.0 |
> showing 36 of 398 rows — these rows as CSV