PREVIEW / futures_1hour / 2023-03-05
file: by_date/futures_1hour/2023/2023-03-05.parquet size: 19 KB rows: 417
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-03-05 18:00:00 | ES | Futures | 4528.79 | 4529.07 | 4520.4 | 4523.75 | 12414.0 |
| 2023-03-05 19:00:00 | ES | Futures | 4523.75 | 4527.11 | 4521.8 | 4525.43 | 8626.0 |
| 2023-03-05 20:00:00 | ES | Futures | 4525.15 | 4530.46 | 4522.36 | 4528.79 | 12899.0 |
| 2023-03-05 21:00:00 | ES | Futures | 4528.51 | 4543.61 | 4526.55 | 4538.57 | 23000.0 |
| 2023-03-05 22:00:00 | ES | Futures | 4538.85 | 4540.53 | 4536.9 | 4539.41 | 5779.0 |
| 2023-03-05 23:00:00 | ES | Futures | 4539.41 | 4540.53 | 4534.38 | 4534.94 | 5381.0 |
| 2023-03-05 18:00:00 | NQ | Futures | 14004.22 | 14017.31 | 13970.08 | 13988.0 | 7448.0 |
| 2023-03-05 19:00:00 | NQ | Futures | 13988.0 | 14003.94 | 13978.33 | 13994.26 | 4404.0 |
| 2023-03-05 20:00:00 | NQ | Futures | 13994.26 | 14019.3 | 13981.18 | 14010.76 | 6799.0 |
| 2023-03-05 21:00:00 | NQ | Futures | 14010.76 | 14085.87 | 14001.66 | 14059.7 | 9813.0 |
| 2023-03-05 22:00:00 | NQ | Futures | 14060.55 | 14072.5 | 14057.42 | 14067.09 | 3339.0 |
| 2023-03-05 23:00:00 | NQ | Futures | 14067.38 | 14072.21 | 14041.77 | 14042.91 | 3072.0 |
| 2023-03-05 18:00:00 | YM | Futures | 37212.6 | 37212.6 | 37162.4 | 37182.5 | 1612.0 |
| 2023-03-05 19:00:00 | YM | Futures | 37180.2 | 37200.3 | 37171.3 | 37193.6 | 1007.0 |
| 2023-03-05 20:00:00 | YM | Futures | 37192.5 | 37225.9 | 37175.8 | 37215.9 | 1618.0 |
| 2023-03-05 21:00:00 | YM | Futures | 37212.6 | 37291.7 | 37200.3 | 37269.4 | 2489.0 |
| 2023-03-05 22:00:00 | YM | Futures | 37271.6 | 37276.1 | 37250.4 | 37262.7 | 839.0 |
| 2023-03-05 23:00:00 | YM | Futures | 37262.7 | 37270.5 | 37230.4 | 37236.0 | 584.0 |
| 2023-03-05 18:00:00 | CL | Futures | 64.95 | 64.95 | 64.47 | 64.52 | 3340.0 |
| 2023-03-05 19:00:00 | CL | Futures | 64.52 | 64.57 | 64.5 | 64.5 | 1190.0 |
| 2023-03-05 20:00:00 | CL | Futures | 64.51 | 64.55 | 64.33 | 64.41 | 4290.0 |
| 2023-03-05 21:00:00 | CL | Futures | 64.4 | 64.42 | 64.24 | 64.25 | 2923.0 |
| 2023-03-05 22:00:00 | CL | Futures | 64.25 | 64.32 | 64.19 | 64.26 | 2145.0 |
| 2023-03-05 23:00:00 | CL | Futures | 64.26 | 64.29 | 64.12 | 64.14 | 1622.0 |
| 2023-03-05 18:00:00 | GC | Futures | 2161.0 | 2163.1 | 2157.6 | 2157.8 | 2106.0 |
| 2023-03-05 19:00:00 | GC | Futures | 2157.8 | 2160.1 | 2156.7 | 2157.8 | 2644.0 |
| 2023-03-05 20:00:00 | GC | Futures | 2157.6 | 2159.4 | 2156.0 | 2158.1 | 4042.0 |
| 2023-03-05 21:00:00 | GC | Futures | 2158.1 | 2160.7 | 2156.2 | 2159.5 | 2784.0 |
| 2023-03-05 22:00:00 | GC | Futures | 2159.5 | 2161.8 | 2159.0 | 2160.9 | 2119.0 |
| 2023-03-05 23:00:00 | GC | Futures | 2160.8 | 2162.7 | 2159.4 | 2159.5 | 2154.0 |
| 2023-03-05 18:00:00 | ZN | Futures | 113.974515 | 113.974515 | 113.974515 | 113.974515 | 45.0 |
| 2023-03-05 20:00:00 | ZN | Futures | 114.07109 | 114.07109 | 114.07109 | 114.07109 | 1.0 |
| 2023-03-05 21:00:00 | ZN | Futures | 114.119377 | 114.119377 | 114.087186 | 114.087186 | 200.0 |
| 2023-03-05 22:00:00 | ZN | Futures | 114.119377 | 114.167665 | 114.119377 | 114.167665 | 4.0 |
| 2023-03-05 23:00:00 | ZN | Futures | 114.167665 | 114.167665 | 114.167665 | 114.167665 | 2.0 |
> showing 35 of 417 rows — these rows as CSV