PREVIEW / futures_1hour / 2022-04-24
file: by_date/futures_1hour/2022/2022-04-24.parquet size: 20 KB rows: 430
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-04-24 18:00:00 | ES | Futures | 4828.69 | 4836.91 | 4817.92 | 4830.67 | 20465.0 |
| 2022-04-24 19:00:00 | ES | Futures | 4830.67 | 4838.04 | 4823.87 | 4828.12 | 11134.0 |
| 2022-04-24 20:00:00 | ES | Futures | 4827.84 | 4831.52 | 4804.59 | 4814.52 | 24736.0 |
| 2022-04-24 21:00:00 | ES | Futures | 4814.52 | 4818.2 | 4796.09 | 4799.49 | 19936.0 |
| 2022-04-24 22:00:00 | ES | Futures | 4799.49 | 4808.0 | 4797.51 | 4805.73 | 13477.0 |
| 2022-04-24 23:00:00 | ES | Futures | 4806.01 | 4819.62 | 4805.73 | 4813.95 | 10486.0 |
| 2022-04-24 18:00:00 | NQ | Futures | 15466.4 | 15490.47 | 15414.2 | 15465.53 | 10695.0 |
| 2022-04-24 19:00:00 | NQ | Futures | 15465.24 | 15496.27 | 15445.52 | 15458.57 | 5713.0 |
| 2022-04-24 20:00:00 | NQ | Futures | 15459.15 | 15473.65 | 15378.25 | 15416.52 | 11029.0 |
| 2022-04-24 21:00:00 | NQ | Futures | 15420.0 | 15435.37 | 15351.86 | 15365.49 | 8954.0 |
| 2022-04-24 22:00:00 | NQ | Futures | 15365.78 | 15400.28 | 15358.82 | 15390.14 | 6109.0 |
| 2022-04-24 23:00:00 | NQ | Futures | 15392.46 | 15451.32 | 15386.08 | 15433.05 | 6385.0 |
| 2022-04-24 18:00:00 | YM | Futures | 37927.9 | 38033.9 | 37893.0 | 37983.2 | 3884.0 |
| 2022-04-24 19:00:00 | YM | Futures | 37983.2 | 38028.2 | 37927.9 | 37964.0 | 2005.0 |
| 2022-04-24 20:00:00 | YM | Futures | 37960.6 | 37985.4 | 37763.3 | 37840.0 | 6313.0 |
| 2022-04-24 21:00:00 | YM | Futures | 37842.2 | 37863.7 | 37700.2 | 37729.5 | 4628.0 |
| 2022-04-24 22:00:00 | YM | Futures | 37728.4 | 37784.7 | 37713.7 | 37772.3 | 2344.0 |
| 2022-04-24 23:00:00 | YM | Futures | 37771.2 | 37854.6 | 37771.2 | 37816.3 | 1937.0 |
| 2022-04-24 18:00:00 | CL | Futures | 75.99 | 76.12 | 74.98 | 75.38 | 3768.0 |
| 2022-04-24 19:00:00 | CL | Futures | 75.38 | 75.54 | 75.23 | 75.35 | 1095.0 |
| 2022-04-24 20:00:00 | CL | Futures | 75.35 | 75.62 | 74.96 | 75.15 | 3576.0 |
| 2022-04-24 21:00:00 | CL | Futures | 75.17 | 75.17 | 74.27 | 74.42 | 9249.0 |
| 2022-04-24 22:00:00 | CL | Futures | 74.42 | 74.54 | 74.21 | 74.32 | 4258.0 |
| 2022-04-24 23:00:00 | CL | Futures | 74.33 | 74.47 | 74.15 | 74.33 | 4759.0 |
| 2022-04-24 18:00:00 | GC | Futures | 2313.3 | 2317.6 | 2309.6 | 2312.5 | 2402.0 |
| 2022-04-24 19:00:00 | GC | Futures | 2312.6 | 2315.9 | 2312.0 | 2315.6 | 1194.0 |
| 2022-04-24 20:00:00 | GC | Futures | 2315.7 | 2315.7 | 2307.7 | 2310.0 | 3387.0 |
| 2022-04-24 21:00:00 | GC | Futures | 2309.8 | 2310.1 | 2305.5 | 2306.8 | 5110.0 |
| 2022-04-24 22:00:00 | GC | Futures | 2306.7 | 2308.0 | 2302.4 | 2305.4 | 6848.0 |
| 2022-04-24 23:00:00 | GC | Futures | 2305.3 | 2306.1 | 2302.4 | 2305.4 | 4091.0 |
| 2022-04-24 18:00:00 | ZN | Futures | 122.123688 | 122.268061 | 121.995356 | 122.25202 | 17654.0 |
| 2022-04-24 19:00:00 | ZN | Futures | 122.25202 | 122.316186 | 122.219937 | 122.268061 | 7438.0 |
| 2022-04-24 20:00:00 | ZN | Futures | 122.25202 | 122.332227 | 122.203895 | 122.268061 | 17527.0 |
| 2022-04-24 21:00:00 | ZN | Futures | 122.268061 | 122.604932 | 122.25202 | 122.588891 | 29164.0 |
| 2022-04-24 22:00:00 | ZN | Futures | 122.588891 | 122.68514 | 122.492642 | 122.620974 | 32252.0 |
| 2022-04-24 23:00:00 | ZN | Futures | 122.637015 | 122.637015 | 122.556808 | 122.620974 | 6817.0 |
> showing 36 of 430 rows — these rows as CSV