PREVIEW / futures_1hour / 2022-01-30
file: by_date/futures_1hour/2022/2022-01-30.parquet size: 19 KB rows: 424
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-30 18:00:00 | ES | Futures | 5003.9 | 5008.71 | 4980.43 | 4991.46 | 22901.0 |
| 2022-01-30 19:00:00 | ES | Futures | 4991.46 | 5000.79 | 4983.26 | 4988.06 | 14929.0 |
| 2022-01-30 20:00:00 | ES | Futures | 4988.35 | 4997.96 | 4985.52 | 4995.42 | 11037.0 |
| 2022-01-30 21:00:00 | ES | Futures | 4995.42 | 5012.67 | 4994.29 | 5009.84 | 13807.0 |
| 2022-01-30 22:00:00 | ES | Futures | 5009.84 | 5017.76 | 5007.86 | 5016.91 | 9458.0 |
| 2022-01-30 23:00:00 | ES | Futures | 5017.19 | 5018.04 | 5012.38 | 5013.8 | 5505.0 |
| 2022-01-30 18:00:00 | NQ | Futures | 16756.07 | 16781.28 | 16639.27 | 16689.99 | 14820.0 |
| 2022-01-30 19:00:00 | NQ | Futures | 16690.86 | 16728.25 | 16654.92 | 16673.47 | 12045.0 |
| 2022-01-30 20:00:00 | NQ | Futures | 16674.63 | 16721.29 | 16666.23 | 16702.16 | 9381.0 |
| 2022-01-30 21:00:00 | NQ | Futures | 16703.32 | 16793.17 | 16693.76 | 16780.7 | 10202.0 |
| 2022-01-30 22:00:00 | NQ | Futures | 16780.12 | 16810.26 | 16772.59 | 16802.44 | 6287.0 |
| 2022-01-30 23:00:00 | NQ | Futures | 16800.99 | 16809.68 | 16785.05 | 16787.95 | 3793.0 |
| 2022-01-30 18:00:00 | YM | Futures | 38856.5 | 38901.5 | 38722.8 | 38793.6 | 3772.0 |
| 2022-01-30 19:00:00 | YM | Futures | 38797.0 | 38864.4 | 38741.9 | 38773.4 | 2757.0 |
| 2022-01-30 20:00:00 | YM | Futures | 38774.5 | 38849.8 | 38757.6 | 38839.7 | 2314.0 |
| 2022-01-30 21:00:00 | YM | Futures | 38841.9 | 38940.8 | 38835.2 | 38918.3 | 3288.0 |
| 2022-01-30 22:00:00 | YM | Futures | 38921.7 | 38968.9 | 38894.7 | 38967.8 | 1546.0 |
| 2022-01-30 23:00:00 | YM | Futures | 38967.8 | 38972.3 | 38930.7 | 38945.3 | 979.0 |
| 2022-01-30 18:00:00 | CL | Futures | 62.52 | 62.79 | 62.51 | 62.74 | 3968.0 |
| 2022-01-30 19:00:00 | CL | Futures | 62.75 | 62.88 | 62.65 | 62.84 | 2843.0 |
| 2022-01-30 20:00:00 | CL | Futures | 62.84 | 63.02 | 62.83 | 62.93 | 3818.0 |
| 2022-01-30 21:00:00 | CL | Futures | 62.93 | 63.01 | 62.87 | 62.93 | 2350.0 |
| 2022-01-30 22:00:00 | CL | Futures | 62.93 | 62.93 | 62.77 | 62.84 | 2565.0 |
| 2022-01-30 23:00:00 | CL | Futures | 62.84 | 62.93 | 62.76 | 62.77 | 3483.0 |
| 2022-01-30 18:00:00 | GC | Futures | 2152.1 | 2152.1 | 2147.3 | 2148.9 | 2535.0 |
| 2022-01-30 19:00:00 | GC | Futures | 2148.9 | 2149.6 | 2145.9 | 2146.0 | 1813.0 |
| 2022-01-30 20:00:00 | GC | Futures | 2146.1 | 2149.6 | 2144.7 | 2149.4 | 2860.0 |
| 2022-01-30 21:00:00 | GC | Futures | 2149.4 | 2149.4 | 2146.5 | 2147.4 | 1788.0 |
| 2022-01-30 22:00:00 | GC | Futures | 2147.4 | 2147.7 | 2145.0 | 2145.5 | 1613.0 |
| 2022-01-30 23:00:00 | GC | Futures | 2145.5 | 2146.2 | 2143.7 | 2146.0 | 1521.0 |
| 2022-01-30 18:00:00 | ZN | Futures | 131.331509 | 131.347552 | 131.187118 | 131.299422 | 42390.0 |
| 2022-01-30 19:00:00 | ZN | Futures | 131.299422 | 131.331509 | 131.235248 | 131.267335 | 10888.0 |
| 2022-01-30 20:00:00 | ZN | Futures | 131.267335 | 131.283378 | 131.219205 | 131.251291 | 9718.0 |
| 2022-01-30 21:00:00 | ZN | Futures | 131.251291 | 131.283378 | 131.235248 | 131.267335 | 6600.0 |
| 2022-01-30 22:00:00 | ZN | Futures | 131.267335 | 131.315465 | 131.251291 | 131.267335 | 6893.0 |
| 2022-01-30 23:00:00 | ZN | Futures | 131.267335 | 131.299422 | 131.251291 | 131.283378 | 3887.0 |
> showing 36 of 424 rows — these rows as CSV