PREVIEW / futures_1hour / 2022-06-05
file: by_date/futures_1hour/2022/2022-06-05.parquet size: 18 KB rows: 406
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-06-05 18:00:00 | ES | Futures | 4660.32 | 4667.69 | 4653.52 | 4658.06 | 8321.0 |
| 2022-06-05 19:00:00 | ES | Futures | 4658.34 | 4663.16 | 4654.09 | 4658.34 | 6032.0 |
| 2022-06-05 20:00:00 | ES | Futures | 4658.06 | 4666.56 | 4653.52 | 4665.14 | 8540.0 |
| 2022-06-05 21:00:00 | ES | Futures | 4665.14 | 4673.08 | 4662.02 | 4672.51 | 14007.0 |
| 2022-06-05 22:00:00 | ES | Futures | 4672.51 | 4677.9 | 4670.81 | 4677.05 | 10149.0 |
| 2022-06-05 23:00:00 | ES | Futures | 4677.33 | 4681.87 | 4675.35 | 4679.31 | 8208.0 |
| 2022-06-05 18:00:00 | NQ | Futures | 14556.46 | 14602.56 | 14530.07 | 14559.36 | 5230.0 |
| 2022-06-05 19:00:00 | NQ | Futures | 14559.36 | 14579.95 | 14542.83 | 14557.33 | 2973.0 |
| 2022-06-05 20:00:00 | NQ | Futures | 14555.88 | 14596.18 | 14534.71 | 14590.09 | 4402.0 |
| 2022-06-05 21:00:00 | NQ | Futures | 14590.38 | 14624.6 | 14579.66 | 14616.19 | 6082.0 |
| 2022-06-05 22:00:00 | NQ | Futures | 14615.9 | 14656.21 | 14611.55 | 14650.12 | 5630.0 |
| 2022-06-05 23:00:00 | NQ | Futures | 14650.7 | 14665.2 | 14642.29 | 14652.15 | 4504.0 |
| 2022-06-05 18:00:00 | YM | Futures | 37164.7 | 37167.0 | 37076.8 | 37100.5 | 1677.0 |
| 2022-06-05 19:00:00 | YM | Futures | 37101.6 | 37129.8 | 37073.4 | 37097.1 | 1003.0 |
| 2022-06-05 20:00:00 | YM | Futures | 37092.6 | 37159.1 | 37065.5 | 37139.9 | 1653.0 |
| 2022-06-05 21:00:00 | YM | Futures | 37142.2 | 37186.1 | 37118.5 | 37182.8 | 2291.0 |
| 2022-06-05 22:00:00 | YM | Futures | 37182.8 | 37214.3 | 37173.7 | 37190.6 | 1536.0 |
| 2022-06-05 23:00:00 | YM | Futures | 37191.8 | 37234.6 | 37179.4 | 37217.7 | 1136.0 |
| 2022-06-05 18:00:00 | CL | Futures | 91.53 | 91.65 | 91.09 | 91.21 | 3234.0 |
| 2022-06-05 19:00:00 | CL | Futures | 91.23 | 91.33 | 91.1 | 91.1 | 939.0 |
| 2022-06-05 20:00:00 | CL | Futures | 91.12 | 91.28 | 90.82 | 90.84 | 2537.0 |
| 2022-06-05 21:00:00 | CL | Futures | 90.84 | 90.86 | 90.12 | 90.6 | 8675.0 |
| 2022-06-05 22:00:00 | CL | Futures | 90.59 | 90.87 | 90.59 | 90.8 | 2737.0 |
| 2022-06-05 23:00:00 | CL | Futures | 90.8 | 91.07 | 90.63 | 90.74 | 2586.0 |
| 2022-06-05 18:00:00 | GC | Futures | 2212.4 | 2214.2 | 2210.8 | 2213.9 | 1032.0 |
| 2022-06-05 19:00:00 | GC | Futures | 2213.8 | 2215.3 | 2213.0 | 2213.1 | 775.0 |
| 2022-06-05 20:00:00 | GC | Futures | 2213.2 | 2215.7 | 2211.7 | 2212.1 | 1564.0 |
| 2022-06-05 21:00:00 | GC | Futures | 2212.1 | 2216.1 | 2211.9 | 2214.9 | 2930.0 |
| 2022-06-05 22:00:00 | GC | Futures | 2214.9 | 2216.7 | 2214.8 | 2216.2 | 1595.0 |
| 2022-06-05 23:00:00 | GC | Futures | 2216.2 | 2218.5 | 2215.9 | 2218.3 | 1734.0 |
| 2022-06-05 18:00:00 | ZN | Futures | 122.300144 | 122.300144 | 122.300144 | 122.300144 | 25.0 |
| 2022-06-05 19:00:00 | ZN | Futures | 122.332227 | 122.332227 | 122.332227 | 122.332227 | 1.0 |
| 2022-06-05 20:00:00 | ZN | Futures | 122.412435 | 122.412435 | 122.412435 | 122.412435 | 4.0 |
| 2022-06-05 21:00:00 | ZN | Futures | 122.316186 | 122.332227 | 122.300144 | 122.316186 | 5.0 |
| 2022-06-05 22:00:00 | ZN | Futures | 122.316186 | 122.348269 | 122.316186 | 122.348269 | 14.0 |
| 2022-06-05 23:00:00 | ZN | Futures | 122.348269 | 122.348269 | 122.348269 | 122.348269 | 38.0 |
> showing 36 of 406 rows — these rows as CSV