PREVIEW / futures_1hour / 2023-06-18
file: by_date/futures_1hour/2023/2023-06-18.parquet size: 17 KB rows: 378
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-06-18 18:00:00 | ES | Futures | 4895.09 | 4899.48 | 4894.81 | 4897.56 | 4495.0 |
| 2023-06-18 19:00:00 | ES | Futures | 4897.56 | 4897.83 | 4893.99 | 4894.54 | 2263.0 |
| 2023-06-18 20:00:00 | ES | Futures | 4894.26 | 4894.54 | 4886.03 | 4888.77 | 6677.0 |
| 2023-06-18 21:00:00 | ES | Futures | 4888.77 | 4889.87 | 4885.48 | 4886.85 | 4680.0 |
| 2023-06-18 22:00:00 | ES | Futures | 4887.13 | 4891.52 | 4886.85 | 4890.7 | 3005.0 |
| 2023-06-18 23:00:00 | ES | Futures | 4890.7 | 4891.24 | 4884.38 | 4885.75 | 4628.0 |
| 2023-06-18 18:00:00 | NQ | Futures | 17025.24 | 17046.66 | 17023.57 | 17040.54 | 3682.0 |
| 2023-06-18 19:00:00 | NQ | Futures | 17040.82 | 17043.6 | 17022.46 | 17025.24 | 1855.0 |
| 2023-06-18 20:00:00 | NQ | Futures | 17024.13 | 17024.69 | 16987.97 | 16998.26 | 4817.0 |
| 2023-06-18 21:00:00 | NQ | Futures | 16998.26 | 17004.94 | 16988.53 | 16991.59 | 2388.0 |
| 2023-06-18 22:00:00 | NQ | Futures | 16992.7 | 17018.57 | 16989.92 | 17013.0 | 2428.0 |
| 2023-06-18 23:00:00 | NQ | Futures | 17013.0 | 17014.95 | 16987.97 | 16989.36 | 2644.0 |
| 2023-06-18 18:00:00 | YM | Futures | 37928.9 | 37959.5 | 37899.3 | 37916.8 | 1072.0 |
| 2023-06-18 19:00:00 | YM | Futures | 37917.9 | 37922.3 | 37884.0 | 37896.0 | 425.0 |
| 2023-06-18 20:00:00 | YM | Futures | 37893.8 | 37896.0 | 37848.9 | 37863.1 | 1068.0 |
| 2023-06-18 21:00:00 | YM | Futures | 37864.2 | 37873.0 | 37837.9 | 37854.4 | 554.0 |
| 2023-06-18 22:00:00 | YM | Futures | 37856.6 | 37879.6 | 37853.3 | 37873.0 | 478.0 |
| 2023-06-18 23:00:00 | YM | Futures | 37874.1 | 37876.3 | 37825.9 | 37841.2 | 746.0 |
| 2023-06-18 18:00:00 | CL | Futures | 58.17 | 58.2 | 58.05 | 58.15 | 1037.0 |
| 2023-06-18 19:00:00 | CL | Futures | 58.14 | 58.15 | 57.95 | 58.0 | 1063.0 |
| 2023-06-18 20:00:00 | CL | Futures | 58.0 | 58.0 | 57.83 | 57.87 | 1495.0 |
| 2023-06-18 21:00:00 | CL | Futures | 57.86 | 57.89 | 57.59 | 57.68 | 4257.0 |
| 2023-06-18 22:00:00 | CL | Futures | 57.68 | 57.71 | 57.47 | 57.5 | 2461.0 |
| 2023-06-18 23:00:00 | CL | Futures | 57.5 | 57.6 | 57.49 | 57.58 | 1494.0 |
| 2023-06-18 18:00:00 | GC | Futures | 2244.9 | 2246.1 | 2243.3 | 2244.4 | 794.0 |
| 2023-06-18 19:00:00 | GC | Futures | 2244.5 | 2244.9 | 2242.5 | 2243.5 | 859.0 |
| 2023-06-18 20:00:00 | GC | Futures | 2243.5 | 2245.1 | 2242.0 | 2242.5 | 1569.0 |
| 2023-06-18 21:00:00 | GC | Futures | 2242.5 | 2244.4 | 2241.5 | 2241.8 | 2602.0 |
| 2023-06-18 22:00:00 | GC | Futures | 2241.9 | 2242.4 | 2239.8 | 2241.1 | 1727.0 |
| 2023-06-18 23:00:00 | GC | Futures | 2241.2 | 2241.7 | 2239.5 | 2241.5 | 1063.0 |
| 2023-06-18 18:00:00 | ZN | Futures | 115.303533 | 115.335398 | 115.271668 | 115.335398 | 2614.0 |
| 2023-06-18 19:00:00 | ZN | Futures | 115.335398 | 115.399128 | 115.319466 | 115.383196 | 3935.0 |
| 2023-06-18 20:00:00 | ZN | Futures | 115.367263 | 115.399128 | 115.351331 | 115.351331 | 3395.0 |
| 2023-06-18 21:00:00 | ZN | Futures | 115.335398 | 115.351331 | 115.335398 | 115.351331 | 696.0 |
| 2023-06-18 22:00:00 | ZN | Futures | 115.335398 | 115.351331 | 115.319466 | 115.335398 | 1882.0 |
| 2023-06-18 23:00:00 | ZN | Futures | 115.335398 | 115.351331 | 115.319466 | 115.351331 | 3374.0 |
> showing 36 of 378 rows — these rows as CSV