PREVIEW / futures_1hour / 2021-03-28
file: by_date/futures_1hour/2021/2021-03-28.parquet size: 18 KB rows: 376
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-03-28 18:00:00 | ES | Futures | 4453.08 | 4455.05 | 4444.37 | 4447.18 | 13551.0 |
| 2021-03-28 19:00:00 | ES | Futures | 4447.18 | 4448.03 | 4440.44 | 4440.44 | 9610.0 |
| 2021-03-28 20:00:00 | ES | Futures | 4440.72 | 4441.56 | 4430.04 | 4432.01 | 22703.0 |
| 2021-03-28 21:00:00 | ES | Futures | 4432.01 | 4434.26 | 4427.51 | 4433.13 | 18801.0 |
| 2021-03-28 22:00:00 | ES | Futures | 4433.13 | 4437.91 | 4431.17 | 4433.7 | 12995.0 |
| 2021-03-28 23:00:00 | ES | Futures | 4433.7 | 4435.38 | 4429.2 | 4435.1 | 9106.0 |
| 2021-03-28 18:00:00 | NQ | Futures | 15025.67 | 15025.67 | 14970.67 | 14989.49 | 5552.0 |
| 2021-03-28 19:00:00 | NQ | Futures | 14990.07 | 14995.86 | 14955.62 | 14961.7 | 4015.0 |
| 2021-03-28 20:00:00 | NQ | Futures | 14961.98 | 14965.17 | 14905.24 | 14915.09 | 9499.0 |
| 2021-03-28 21:00:00 | NQ | Futures | 14915.09 | 14926.38 | 14875.43 | 14915.95 | 10595.0 |
| 2021-03-28 22:00:00 | NQ | Futures | 14915.09 | 14943.75 | 14904.38 | 14933.32 | 6197.0 |
| 2021-03-28 23:00:00 | NQ | Futures | 14933.61 | 14935.35 | 14906.69 | 14929.85 | 4160.0 |
| 2021-03-28 18:00:00 | YM | Futures | 36701.4 | 36705.9 | 36645.7 | 36656.9 | 2310.0 |
| 2021-03-28 19:00:00 | YM | Futures | 36654.6 | 36661.3 | 36621.2 | 36622.3 | 1619.0 |
| 2021-03-28 20:00:00 | YM | Futures | 36623.5 | 36633.5 | 36557.7 | 36567.8 | 3496.0 |
| 2021-03-28 21:00:00 | YM | Futures | 36566.7 | 36599.0 | 36549.9 | 36593.4 | 2780.0 |
| 2021-03-28 22:00:00 | YM | Futures | 36592.3 | 36622.3 | 36563.3 | 36578.9 | 2161.0 |
| 2021-03-28 23:00:00 | YM | Futures | 36578.9 | 36600.1 | 36546.6 | 36597.8 | 1410.0 |
| 2021-03-28 18:00:00 | CL | Futures | 41.32 | 41.34 | 40.96 | 41.17 | 4698.0 |
| 2021-03-28 19:00:00 | CL | Futures | 41.17 | 41.27 | 41.11 | 41.2 | 2587.0 |
| 2021-03-28 20:00:00 | CL | Futures | 41.2 | 41.5 | 41.17 | 41.43 | 6478.0 |
| 2021-03-28 21:00:00 | CL | Futures | 41.43 | 41.45 | 41.14 | 41.21 | 7518.0 |
| 2021-03-28 22:00:00 | CL | Futures | 41.21 | 41.37 | 41.04 | 41.08 | 6752.0 |
| 2021-03-28 23:00:00 | CL | Futures | 41.08 | 41.09 | 40.58 | 40.63 | 14761.0 |
| 2021-03-28 18:00:00 | GC | Futures | 2092.8 | 2095.7 | 2092.7 | 2092.8 | 942.0 |
| 2021-03-28 19:00:00 | GC | Futures | 2092.9 | 2093.9 | 2092.3 | 2092.9 | 662.0 |
| 2021-03-28 20:00:00 | GC | Futures | 2092.8 | 2094.6 | 2091.4 | 2092.6 | 1719.0 |
| 2021-03-28 21:00:00 | GC | Futures | 2092.3 | 2093.0 | 2086.4 | 2092.7 | 3639.0 |
| 2021-03-28 22:00:00 | GC | Futures | 2092.8 | 2094.5 | 2091.1 | 2093.0 | 2305.0 |
| 2021-03-28 23:00:00 | GC | Futures | 2093.0 | 2093.5 | 2089.8 | 2090.0 | 1764.0 |
| 2021-03-28 18:00:00 | ZN | Futures | 132.980337 | 133.138177 | 132.980337 | 133.106609 | 18571.0 |
| 2021-03-28 19:00:00 | ZN | Futures | 133.106609 | 133.122393 | 133.043473 | 133.043473 | 8618.0 |
| 2021-03-28 20:00:00 | ZN | Futures | 133.059257 | 133.169745 | 133.043473 | 133.153961 | 20292.0 |
| 2021-03-28 21:00:00 | ZN | Futures | 133.153961 | 133.169745 | 133.106609 | 133.106609 | 12617.0 |
| 2021-03-28 22:00:00 | ZN | Futures | 133.122393 | 133.138177 | 133.090825 | 133.122393 | 8742.0 |
| 2021-03-28 23:00:00 | ZN | Futures | 133.122393 | 133.138177 | 133.090825 | 133.122393 | 10031.0 |
> showing 36 of 376 rows — these rows as CSV