PREVIEW / futures_1hour / 2022-06-26
file: by_date/futures_1hour/2022/2022-06-26.parquet size: 19 KB rows: 418
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-26 18:00:00 | ES | Futures | 4436.03 | 4444.53 | 4420.17 | 4424.98 | 13658.0 |
| 2022-06-26 19:00:00 | ES | Futures | 4424.98 | 4434.9 | 4418.19 | 4419.04 | 9708.0 |
| 2022-06-26 20:00:00 | ES | Futures | 4418.75 | 4423.28 | 4413.94 | 4415.64 | 13003.0 |
| 2022-06-26 21:00:00 | ES | Futures | 4415.35 | 4429.8 | 4415.35 | 4429.52 | 13092.0 |
| 2022-06-26 22:00:00 | ES | Futures | 4429.52 | 4460.68 | 4426.97 | 4445.38 | 20331.0 |
| 2022-06-26 23:00:00 | ES | Futures | 4445.1 | 4449.91 | 4444.25 | 4449.35 | 5402.0 |
| 2022-06-26 18:00:00 | NQ | Futures | 14042.56 | 14073.79 | 13988.76 | 14009.0 | 7133.0 |
| 2022-06-26 19:00:00 | NQ | Futures | 14010.16 | 14042.56 | 13989.91 | 13992.52 | 4386.0 |
| 2022-06-26 20:00:00 | NQ | Futures | 13991.07 | 14004.67 | 13967.35 | 13977.48 | 6332.0 |
| 2022-06-26 21:00:00 | NQ | Futures | 13976.32 | 14037.64 | 13976.03 | 14031.28 | 6547.0 |
| 2022-06-26 22:00:00 | NQ | Futures | 14030.41 | 14150.15 | 14024.91 | 14100.11 | 10580.0 |
| 2022-06-26 23:00:00 | NQ | Futures | 14100.11 | 14127.01 | 14095.49 | 14122.96 | 4104.0 |
| 2022-06-26 18:00:00 | YM | Futures | 35504.5 | 35588.0 | 35389.4 | 35425.5 | 2930.0 |
| 2022-06-26 19:00:00 | YM | Futures | 35426.6 | 35488.7 | 35380.3 | 35386.0 | 1856.0 |
| 2022-06-26 20:00:00 | YM | Futures | 35382.6 | 35415.3 | 35356.6 | 35365.7 | 2242.0 |
| 2022-06-26 21:00:00 | YM | Futures | 35363.4 | 35457.1 | 35362.3 | 35454.8 | 1818.0 |
| 2022-06-26 22:00:00 | YM | Futures | 35457.1 | 35651.1 | 35430.0 | 35562.0 | 4535.0 |
| 2022-06-26 23:00:00 | YM | Futures | 35560.9 | 35577.8 | 35546.2 | 35576.7 | 1122.0 |
| 2022-06-26 18:00:00 | CL | Futures | 83.0 | 83.13 | 81.95 | 82.4 | 4567.0 |
| 2022-06-26 19:00:00 | CL | Futures | 82.42 | 82.56 | 82.22 | 82.42 | 1645.0 |
| 2022-06-26 20:00:00 | CL | Futures | 82.45 | 82.69 | 81.75 | 81.97 | 4178.0 |
| 2022-06-26 21:00:00 | CL | Futures | 81.95 | 83.38 | 81.92 | 83.23 | 9106.0 |
| 2022-06-26 22:00:00 | CL | Futures | 83.23 | 83.88 | 83.11 | 83.68 | 5364.0 |
| 2022-06-26 23:00:00 | CL | Futures | 83.69 | 83.7 | 83.24 | 83.34 | 2710.0 |
| 2022-06-26 18:00:00 | GC | Futures | 2195.5 | 2199.1 | 2189.1 | 2191.1 | 5855.0 |
| 2022-06-26 19:00:00 | GC | Futures | 2191.1 | 2191.8 | 2186.8 | 2188.0 | 1881.0 |
| 2022-06-26 20:00:00 | GC | Futures | 2187.9 | 2189.0 | 2184.2 | 2185.3 | 1696.0 |
| 2022-06-26 21:00:00 | GC | Futures | 2185.3 | 2194.3 | 2184.6 | 2191.7 | 4528.0 |
| 2022-06-26 22:00:00 | GC | Futures | 2191.7 | 2194.6 | 2191.4 | 2193.2 | 2461.0 |
| 2022-06-26 23:00:00 | GC | Futures | 2193.2 | 2193.3 | 2191.5 | 2192.3 | 1725.0 |
| 2022-06-26 18:00:00 | ZN | Futures | 120.963901 | 121.108961 | 120.963901 | 121.012255 | 6906.0 |
| 2022-06-26 19:00:00 | ZN | Futures | 121.028372 | 121.028372 | 120.947783 | 120.980019 | 6841.0 |
| 2022-06-26 20:00:00 | ZN | Futures | 120.980019 | 121.092843 | 120.947783 | 121.092843 | 9310.0 |
| 2022-06-26 21:00:00 | ZN | Futures | 121.076726 | 121.108961 | 120.915548 | 120.947783 | 11649.0 |
| 2022-06-26 22:00:00 | ZN | Futures | 120.963901 | 120.996137 | 120.770488 | 120.818841 | 13264.0 |
| 2022-06-26 23:00:00 | ZN | Futures | 120.818841 | 120.883312 | 120.818841 | 120.883312 | 6759.0 |
> showing 36 of 418 rows — these rows as CSV