PREVIEW / futures_1hour / 2022-01-23
file: by_date/futures_1hour/2022/2022-01-23.parquet size: 19 KB rows: 422
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-23 18:00:00 | ES | Futures | 4964.87 | 4994.29 | 4961.48 | 4994.0 | 51323.0 |
| 2022-01-23 19:00:00 | ES | Futures | 4993.72 | 4996.55 | 4984.67 | 4993.15 | 22499.0 |
| 2022-01-23 20:00:00 | ES | Futures | 4993.15 | 5008.14 | 4990.04 | 5005.31 | 26632.0 |
| 2022-01-23 21:00:00 | ES | Futures | 5005.31 | 5008.43 | 4995.7 | 4997.96 | 11587.0 |
| 2022-01-23 22:00:00 | ES | Futures | 4997.96 | 5005.6 | 4996.26 | 5002.2 | 9094.0 |
| 2022-01-23 23:00:00 | ES | Futures | 5002.2 | 5005.6 | 4999.38 | 5001.36 | 5132.0 |
| 2022-01-23 18:00:00 | NQ | Futures | 16705.06 | 16882.72 | 16668.83 | 16867.07 | 28655.0 |
| 2022-01-23 19:00:00 | NQ | Futures | 16867.36 | 16878.95 | 16825.05 | 16850.84 | 13784.0 |
| 2022-01-23 20:00:00 | NQ | Futures | 16851.13 | 16904.45 | 16837.8 | 16881.56 | 13957.0 |
| 2022-01-23 21:00:00 | NQ | Futures | 16882.43 | 16896.63 | 16841.27 | 16843.59 | 8485.0 |
| 2022-01-23 22:00:00 | NQ | Futures | 16844.17 | 16878.95 | 16841.56 | 16859.82 | 5559.0 |
| 2022-01-23 23:00:00 | NQ | Futures | 16860.98 | 16873.44 | 16842.72 | 16851.71 | 4120.0 |
| 2022-01-23 18:00:00 | YM | Futures | 38369.9 | 38549.7 | 38366.5 | 38546.3 | 5623.0 |
| 2022-01-23 19:00:00 | YM | Futures | 38547.5 | 38580.1 | 38481.2 | 38552.0 | 4547.0 |
| 2022-01-23 20:00:00 | YM | Futures | 38553.1 | 38670.0 | 38535.1 | 38644.1 | 5604.0 |
| 2022-01-23 21:00:00 | YM | Futures | 38646.4 | 38667.7 | 38584.6 | 38602.5 | 3112.0 |
| 2022-01-23 22:00:00 | YM | Futures | 38604.8 | 38664.3 | 38587.9 | 38636.3 | 1606.0 |
| 2022-01-23 23:00:00 | YM | Futures | 38636.3 | 38666.6 | 38620.5 | 38634.0 | 760.0 |
| 2022-01-23 18:00:00 | CL | Futures | 60.7 | 61.39 | 60.59 | 61.37 | 8990.0 |
| 2022-01-23 19:00:00 | CL | Futures | 61.37 | 61.44 | 61.25 | 61.37 | 5322.0 |
| 2022-01-23 20:00:00 | CL | Futures | 61.37 | 61.54 | 61.32 | 61.49 | 6038.0 |
| 2022-01-23 21:00:00 | CL | Futures | 61.5 | 61.55 | 61.29 | 61.35 | 4068.0 |
| 2022-01-23 22:00:00 | CL | Futures | 61.35 | 61.39 | 61.26 | 61.34 | 3177.0 |
| 2022-01-23 23:00:00 | CL | Futures | 61.34 | 61.43 | 61.29 | 61.36 | 1875.0 |
| 2022-01-23 18:00:00 | GC | Futures | 2206.1 | 2208.9 | 2202.5 | 2206.0 | 3651.0 |
| 2022-01-23 19:00:00 | GC | Futures | 2206.2 | 2206.4 | 2204.1 | 2204.2 | 1846.0 |
| 2022-01-23 20:00:00 | GC | Futures | 2204.2 | 2207.7 | 2202.9 | 2207.3 | 3633.0 |
| 2022-01-23 21:00:00 | GC | Futures | 2207.3 | 2208.9 | 2206.2 | 2207.8 | 2253.0 |
| 2022-01-23 22:00:00 | GC | Futures | 2207.9 | 2208.9 | 2206.5 | 2207.7 | 1487.0 |
| 2022-01-23 23:00:00 | GC | Futures | 2207.7 | 2209.4 | 2207.3 | 2209.2 | 735.0 |
| 2022-01-23 18:00:00 | ZN | Futures | 131.652377 | 131.684464 | 131.411726 | 131.556117 | 44381.0 |
| 2022-01-23 19:00:00 | ZN | Futures | 131.556117 | 131.588203 | 131.507986 | 131.540073 | 14776.0 |
| 2022-01-23 20:00:00 | ZN | Futures | 131.556117 | 131.556117 | 131.427769 | 131.491943 | 24841.0 |
| 2022-01-23 21:00:00 | ZN | Futures | 131.475899 | 131.556117 | 131.459856 | 131.52403 | 8596.0 |
| 2022-01-23 22:00:00 | ZN | Futures | 131.52403 | 131.556117 | 131.491943 | 131.52403 | 13535.0 |
| 2022-01-23 23:00:00 | ZN | Futures | 131.52403 | 131.540073 | 131.491943 | 131.507986 | 8661.0 |
> showing 36 of 422 rows — these rows as CSV