PREVIEW / futures_1hour / 2023-04-16
file: by_date/futures_1hour/2023/2023-04-16.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 |
|---|---|---|---|---|---|---|---|
| 2023-04-16 18:00:00 | ES | Futures | 4630.97 | 4631.52 | 4626.25 | 4629.86 | 7509.0 |
| 2023-04-16 19:00:00 | ES | Futures | 4629.86 | 4630.41 | 4626.81 | 4628.47 | 4395.0 |
| 2023-04-16 20:00:00 | ES | Futures | 4628.2 | 4630.41 | 4625.42 | 4625.7 | 6792.0 |
| 2023-04-16 21:00:00 | ES | Futures | 4625.42 | 4630.14 | 4624.87 | 4627.36 | 8511.0 |
| 2023-04-16 22:00:00 | ES | Futures | 4627.09 | 4628.75 | 4625.42 | 4627.09 | 5175.0 |
| 2023-04-16 23:00:00 | ES | Futures | 4627.36 | 4627.92 | 4626.25 | 4626.81 | 2551.0 |
| 2023-04-16 18:00:00 | NQ | Futures | 14880.08 | 14882.61 | 14850.23 | 14859.52 | 3938.0 |
| 2023-04-16 19:00:00 | NQ | Futures | 14860.09 | 14861.49 | 14840.38 | 14851.08 | 2766.0 |
| 2023-04-16 20:00:00 | NQ | Futures | 14850.8 | 14861.49 | 14838.69 | 14839.81 | 3388.0 |
| 2023-04-16 21:00:00 | NQ | Futures | 14840.38 | 14856.14 | 14836.72 | 14847.98 | 3894.0 |
| 2023-04-16 22:00:00 | NQ | Futures | 14847.98 | 14852.48 | 14840.66 | 14847.42 | 2367.0 |
| 2023-04-16 23:00:00 | NQ | Futures | 14847.98 | 14849.39 | 14842.91 | 14846.01 | 1277.0 |
| 2023-04-16 18:00:00 | YM | Futures | 37718.6 | 37718.6 | 37666.7 | 37701.0 | 1052.0 |
| 2023-04-16 19:00:00 | YM | Futures | 37703.2 | 37705.4 | 37687.7 | 37698.8 | 903.0 |
| 2023-04-16 20:00:00 | YM | Futures | 37698.8 | 37707.6 | 37678.9 | 37678.9 | 931.0 |
| 2023-04-16 21:00:00 | YM | Futures | 37680.0 | 37708.7 | 37674.4 | 37688.8 | 1063.0 |
| 2023-04-16 22:00:00 | YM | Futures | 37689.9 | 37695.4 | 37677.8 | 37685.5 | 769.0 |
| 2023-04-16 23:00:00 | YM | Futures | 37685.5 | 37693.2 | 37681.1 | 37683.3 | 441.0 |
| 2023-04-16 18:00:00 | CL | Futures | 66.98 | 67.13 | 66.91 | 67.02 | 922.0 |
| 2023-04-16 19:00:00 | CL | Futures | 67.02 | 67.05 | 66.94 | 67.04 | 527.0 |
| 2023-04-16 20:00:00 | CL | Futures | 67.02 | 67.15 | 66.96 | 67.01 | 1026.0 |
| 2023-04-16 21:00:00 | CL | Futures | 67.0 | 67.11 | 66.82 | 67.0 | 1483.0 |
| 2023-04-16 22:00:00 | CL | Futures | 67.0 | 67.12 | 66.91 | 67.04 | 771.0 |
| 2023-04-16 23:00:00 | CL | Futures | 67.04 | 67.09 | 66.98 | 67.02 | 282.0 |
| 2023-04-16 18:00:00 | GC | Futures | 2316.2 | 2321.3 | 2311.5 | 2316.7 | 3744.0 |
| 2023-04-16 19:00:00 | GC | Futures | 2316.4 | 2320.6 | 2316.4 | 2317.9 | 1565.0 |
| 2023-04-16 20:00:00 | GC | Futures | 2318.1 | 2320.2 | 2316.3 | 2317.3 | 2130.0 |
| 2023-04-16 21:00:00 | GC | Futures | 2317.1 | 2320.7 | 2309.4 | 2318.5 | 7803.0 |
| 2023-04-16 22:00:00 | GC | Futures | 2318.4 | 2322.0 | 2318.4 | 2319.2 | 3736.0 |
| 2023-04-16 23:00:00 | GC | Futures | 2319.3 | 2320.6 | 2319.3 | 2319.8 | 1446.0 |
| 2023-04-16 18:00:00 | ZN | Futures | 117.819595 | 117.867678 | 117.771511 | 117.803567 | 6280.0 |
| 2023-04-16 19:00:00 | ZN | Futures | 117.803567 | 117.819595 | 117.739456 | 117.755484 | 6255.0 |
| 2023-04-16 20:00:00 | ZN | Futures | 117.755484 | 117.85165 | 117.739456 | 117.819595 | 12927.0 |
| 2023-04-16 21:00:00 | ZN | Futures | 117.835622 | 117.883705 | 117.803567 | 117.867678 | 8780.0 |
| 2023-04-16 22:00:00 | ZN | Futures | 117.867678 | 117.899733 | 117.85165 | 117.867678 | 7137.0 |
| 2023-04-16 23:00:00 | ZN | Futures | 117.883705 | 117.883705 | 117.85165 | 117.883705 | 5866.0 |
> showing 36 of 424 rows — these rows as CSV