PREVIEW / futures_1hour / 2023-10-08
file: by_date/futures_1hour/2023/2023-10-08.parquet size: 20 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 |
|---|---|---|---|---|---|---|---|
| 2023-10-08 18:00:00 | ES | Futures | 4687.1 | 4691.44 | 4673.25 | 4678.68 | 38097.0 |
| 2023-10-08 19:00:00 | ES | Futures | 4678.95 | 4685.2 | 4676.78 | 4684.65 | 10844.0 |
| 2023-10-08 20:00:00 | ES | Futures | 4684.38 | 4685.47 | 4676.51 | 4683.3 | 15739.0 |
| 2023-10-08 21:00:00 | ES | Futures | 4683.3 | 4683.3 | 4677.05 | 4681.39 | 9041.0 |
| 2023-10-08 22:00:00 | ES | Futures | 4681.67 | 4683.84 | 4680.04 | 4682.21 | 5510.0 |
| 2023-10-08 23:00:00 | ES | Futures | 4682.21 | 4682.48 | 4674.88 | 4675.69 | 5085.0 |
| 2023-10-08 18:00:00 | NQ | Futures | 16524.07 | 16524.35 | 16470.79 | 16496.61 | 17174.0 |
| 2023-10-08 19:00:00 | NQ | Futures | 16497.16 | 16513.64 | 16485.89 | 16510.34 | 5276.0 |
| 2023-10-08 20:00:00 | NQ | Futures | 16510.61 | 16515.01 | 16467.77 | 16499.08 | 7497.0 |
| 2023-10-08 21:00:00 | NQ | Futures | 16499.63 | 16499.63 | 16468.86 | 16487.27 | 6602.0 |
| 2023-10-08 22:00:00 | NQ | Futures | 16488.09 | 16497.16 | 16478.2 | 16484.8 | 3786.0 |
| 2023-10-08 23:00:00 | NQ | Futures | 16485.34 | 16485.62 | 16456.51 | 16459.25 | 3588.0 |
| 2023-10-08 18:00:00 | YM | Futures | 36315.6 | 36315.6 | 36159.4 | 36218.0 | 7229.0 |
| 2023-10-08 19:00:00 | YM | Futures | 36219.1 | 36261.4 | 36211.5 | 36258.1 | 1605.0 |
| 2023-10-08 20:00:00 | YM | Futures | 36257.1 | 36265.7 | 36206.1 | 36238.6 | 2377.0 |
| 2023-10-08 21:00:00 | YM | Futures | 36239.7 | 36241.9 | 36200.6 | 36227.8 | 1281.0 |
| 2023-10-08 22:00:00 | YM | Futures | 36228.8 | 36241.9 | 36222.3 | 36233.2 | 983.0 |
| 2023-10-08 23:00:00 | YM | Futures | 36232.1 | 36234.3 | 36184.4 | 36187.6 | 674.0 |
| 2023-10-08 18:00:00 | CL | Futures | 70.44 | 71.45 | 69.96 | 71.34 | 22431.0 |
| 2023-10-08 19:00:00 | CL | Futures | 71.34 | 71.46 | 70.72 | 70.85 | 7908.0 |
| 2023-10-08 20:00:00 | CL | Futures | 70.86 | 71.44 | 70.81 | 71.4 | 6938.0 |
| 2023-10-08 21:00:00 | CL | Futures | 71.39 | 72.09 | 71.35 | 71.38 | 15741.0 |
| 2023-10-08 22:00:00 | CL | Futures | 71.39 | 71.45 | 71.08 | 71.16 | 6231.0 |
| 2023-10-08 23:00:00 | CL | Futures | 71.17 | 71.29 | 71.01 | 71.12 | 3668.0 |
| 2023-10-08 18:00:00 | GC | Futures | 2078.7 | 2088.2 | 2076.9 | 2081.6 | 14631.0 |
| 2023-10-08 19:00:00 | GC | Futures | 2081.6 | 2082.0 | 2078.2 | 2079.9 | 4507.0 |
| 2023-10-08 20:00:00 | GC | Futures | 2080.0 | 2085.0 | 2077.9 | 2084.9 | 4570.0 |
| 2023-10-08 21:00:00 | GC | Futures | 2084.9 | 2085.5 | 2079.1 | 2081.0 | 6296.0 |
| 2023-10-08 22:00:00 | GC | Futures | 2081.0 | 2085.3 | 2080.9 | 2082.4 | 3781.0 |
| 2023-10-08 23:00:00 | GC | Futures | 2082.5 | 2083.6 | 2080.5 | 2083.1 | 2436.0 |
| 2023-10-08 18:00:00 | ZN | Futures | 108.799661 | 109.323346 | 108.752053 | 109.101177 | 72570.0 |
| 2023-10-08 19:00:00 | ZN | Futures | 109.101177 | 109.117046 | 108.942484 | 108.990092 | 23061.0 |
| 2023-10-08 20:00:00 | ZN | Futures | 108.990092 | 108.990092 | 108.783791 | 108.894876 | 22388.0 |
| 2023-10-08 21:00:00 | ZN | Futures | 108.879007 | 108.942484 | 108.81553 | 108.910745 | 9339.0 |
| 2023-10-08 22:00:00 | ZN | Futures | 108.894876 | 108.958353 | 108.879007 | 108.910745 | 6197.0 |
| 2023-10-08 23:00:00 | ZN | Futures | 108.894876 | 108.926615 | 108.847268 | 108.910745 | 3958.0 |
> showing 36 of 422 rows — these rows as CSV