PREVIEW / futures_1hour / 2021-12-05
file: by_date/futures_1hour/2021/2021-12-05.parquet size: 18 KB rows: 395
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-05 18:00:00 | ES | Futures | 5127.52 | 5146.71 | 5119.33 | 5144.17 | 28618.0 |
| 2021-12-05 19:00:00 | ES | Futures | 5144.17 | 5145.86 | 5125.26 | 5142.19 | 21008.0 |
| 2021-12-05 20:00:00 | ES | Futures | 5141.91 | 5150.38 | 5137.68 | 5144.73 | 16475.0 |
| 2021-12-05 21:00:00 | ES | Futures | 5144.73 | 5148.12 | 5141.06 | 5144.73 | 8118.0 |
| 2021-12-05 22:00:00 | ES | Futures | 5144.73 | 5147.55 | 5142.19 | 5146.99 | 5245.0 |
| 2021-12-05 23:00:00 | ES | Futures | 5146.71 | 5150.09 | 5145.01 | 5146.43 | 5526.0 |
| 2021-12-05 18:00:00 | NQ | Futures | 18219.36 | 18261.09 | 18178.2 | 18245.73 | 15375.0 |
| 2021-12-05 19:00:00 | NQ | Futures | 18245.73 | 18255.29 | 18168.93 | 18223.12 | 13583.0 |
| 2021-12-05 20:00:00 | NQ | Futures | 18222.25 | 18241.67 | 18202.84 | 18221.67 | 10957.0 |
| 2021-12-05 21:00:00 | NQ | Futures | 18221.96 | 18254.71 | 18214.14 | 18245.73 | 7268.0 |
| 2021-12-05 22:00:00 | NQ | Futures | 18246.31 | 18256.16 | 18226.02 | 18237.9 | 5358.0 |
| 2021-12-05 23:00:00 | NQ | Futures | 18237.61 | 18254.71 | 18232.69 | 18242.54 | 3863.0 |
| 2021-12-05 18:00:00 | YM | Futures | 38772.2 | 38980.7 | 38762.1 | 38963.9 | 6810.0 |
| 2021-12-05 19:00:00 | YM | Futures | 38965.0 | 38975.1 | 38835.0 | 38968.3 | 6485.0 |
| 2021-12-05 20:00:00 | YM | Futures | 38967.2 | 39040.1 | 38942.6 | 39005.3 | 6549.0 |
| 2021-12-05 21:00:00 | YM | Futures | 39003.1 | 39023.3 | 38965.0 | 38980.7 | 2776.0 |
| 2021-12-05 22:00:00 | YM | Futures | 38981.8 | 39013.2 | 38977.3 | 39004.2 | 1849.0 |
| 2021-12-05 23:00:00 | YM | Futures | 39003.1 | 39024.4 | 38989.6 | 38998.6 | 1931.0 |
| 2021-12-05 18:00:00 | CL | Futures | 47.49 | 47.94 | 47.27 | 47.86 | 7885.0 |
| 2021-12-05 19:00:00 | CL | Futures | 47.87 | 48.29 | 47.84 | 48.28 | 4931.0 |
| 2021-12-05 20:00:00 | CL | Futures | 48.29 | 48.35 | 47.85 | 47.99 | 10870.0 |
| 2021-12-05 21:00:00 | CL | Futures | 48.0 | 48.21 | 47.98 | 48.09 | 3852.0 |
| 2021-12-05 22:00:00 | CL | Futures | 48.08 | 48.1 | 47.84 | 47.94 | 3127.0 |
| 2021-12-05 23:00:00 | CL | Futures | 47.94 | 48.03 | 47.9 | 47.95 | 1697.0 |
| 2021-12-05 18:00:00 | GC | Futures | 2149.0 | 2150.6 | 2141.6 | 2144.4 | 2200.0 |
| 2021-12-05 19:00:00 | GC | Futures | 2144.3 | 2147.1 | 2144.2 | 2144.6 | 1711.0 |
| 2021-12-05 20:00:00 | GC | Futures | 2144.8 | 2149.0 | 2143.4 | 2148.1 | 3535.0 |
| 2021-12-05 21:00:00 | GC | Futures | 2148.1 | 2149.9 | 2147.7 | 2148.9 | 1958.0 |
| 2021-12-05 22:00:00 | GC | Futures | 2148.9 | 2149.5 | 2144.3 | 2145.0 | 2438.0 |
| 2021-12-05 23:00:00 | GC | Futures | 2145.0 | 2145.5 | 2141.3 | 2142.4 | 2694.0 |
| 2021-12-05 18:00:00 | ZN | Futures | 134.776909 | 134.776909 | 134.601314 | 134.601314 | 43.0 |
| 2021-12-05 19:00:00 | ZN | Futures | 134.665167 | 134.665167 | 134.665167 | 134.665167 | 30.0 |
| 2021-12-05 20:00:00 | ZN | Futures | 134.585351 | 134.601314 | 134.585351 | 134.601314 | 2.0 |
| 2021-12-05 21:00:00 | ZN | Futures | 134.601314 | 134.601314 | 134.601314 | 134.601314 | 9.0 |
| 2021-12-05 22:00:00 | ZN | Futures | 134.601314 | 134.601314 | 134.601314 | 134.601314 | 1.0 |
| 2021-12-05 23:00:00 | ZN | Futures | 134.585351 | 134.585351 | 134.585351 | 134.585351 | 50.0 |
> showing 36 of 395 rows — these rows as CSV