PREVIEW / futures_1hour / 2022-03-06
file: by_date/futures_1hour/2022/2022-03-06.parquet size: 20 KB rows: 440
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-03-06 18:00:00 | ES | Futures | 4874.09 | 4875.51 | 4822.34 | 4829.69 | 38942.0 |
| 2022-03-06 19:00:00 | ES | Futures | 4829.41 | 4837.05 | 4815.55 | 4819.8 | 25139.0 |
| 2022-03-06 20:00:00 | ES | Futures | 4820.36 | 4826.3 | 4811.88 | 4816.4 | 21040.0 |
| 2022-03-06 21:00:00 | ES | Futures | 4816.12 | 4823.47 | 4810.46 | 4814.42 | 15534.0 |
| 2022-03-06 22:00:00 | ES | Futures | 4815.27 | 4835.35 | 4813.57 | 4826.87 | 17007.0 |
| 2022-03-06 23:00:00 | ES | Futures | 4826.87 | 4839.88 | 4825.17 | 4837.33 | 8629.0 |
| 2022-03-06 18:00:00 | NQ | Futures | 15955.59 | 15955.59 | 15723.16 | 15747.22 | 18942.0 |
| 2022-03-06 19:00:00 | NQ | Futures | 15746.93 | 15793.88 | 15705.48 | 15732.14 | 14140.0 |
| 2022-03-06 20:00:00 | NQ | Futures | 15732.43 | 15759.1 | 15696.5 | 15711.28 | 9686.0 |
| 2022-03-06 21:00:00 | NQ | Futures | 15709.25 | 15738.52 | 15682.3 | 15704.9 | 6668.0 |
| 2022-03-06 22:00:00 | NQ | Futures | 15708.09 | 15779.67 | 15693.02 | 15756.49 | 7072.0 |
| 2022-03-06 23:00:00 | NQ | Futures | 15756.49 | 15793.59 | 15754.46 | 15786.63 | 5483.0 |
| 2022-03-06 18:00:00 | YM | Futures | 37592.2 | 37592.2 | 37295.6 | 37384.3 | 8487.0 |
| 2022-03-06 19:00:00 | YM | Futures | 37379.8 | 37409.1 | 37258.5 | 37280.9 | 4281.0 |
| 2022-03-06 20:00:00 | YM | Futures | 37285.4 | 37321.4 | 37210.1 | 37242.7 | 2881.0 |
| 2022-03-06 21:00:00 | YM | Futures | 37237.1 | 37296.7 | 37203.4 | 37242.7 | 1969.0 |
| 2022-03-06 22:00:00 | YM | Futures | 37245.0 | 37381.0 | 37210.1 | 37305.7 | 2163.0 |
| 2022-03-06 23:00:00 | YM | Futures | 37307.9 | 37388.8 | 37288.8 | 37378.7 | 1153.0 |
| 2022-03-06 18:00:00 | CL | Futures | 88.12 | 94.78 | 88.12 | 92.23 | 26599.0 |
| 2022-03-06 19:00:00 | CL | Futures | 92.23 | 92.23 | 90.1 | 90.24 | 11824.0 |
| 2022-03-06 20:00:00 | CL | Futures | 90.27 | 90.73 | 88.68 | 89.87 | 18134.0 |
| 2022-03-06 21:00:00 | CL | Futures | 89.91 | 91.36 | 89.54 | 91.22 | 8027.0 |
| 2022-03-06 22:00:00 | CL | Futures | 91.22 | 91.22 | 89.58 | 90.35 | 10088.0 |
| 2022-03-06 23:00:00 | CL | Futures | 90.34 | 91.78 | 90.13 | 91.57 | 7623.0 |
| 2022-03-06 18:00:00 | GC | Futures | 2375.0 | 2395.8 | 2373.2 | 2391.5 | 13662.0 |
| 2022-03-06 19:00:00 | GC | Futures | 2392.0 | 2393.9 | 2389.3 | 2391.1 | 6392.0 |
| 2022-03-06 20:00:00 | GC | Futures | 2391.2 | 2407.1 | 2390.8 | 2403.4 | 17033.0 |
| 2022-03-06 21:00:00 | GC | Futures | 2403.5 | 2404.0 | 2390.5 | 2390.8 | 10899.0 |
| 2022-03-06 22:00:00 | GC | Futures | 2390.9 | 2395.2 | 2388.5 | 2394.7 | 6999.0 |
| 2022-03-06 23:00:00 | GC | Futures | 2394.6 | 2396.4 | 2391.6 | 2394.1 | 3483.0 |
| 2022-03-06 18:00:00 | ZN | Futures | 132.18181 | 132.518722 | 132.149723 | 132.406418 | 450.0 |
| 2022-03-06 19:00:00 | ZN | Futures | 132.422462 | 132.470592 | 132.197854 | 132.197854 | 24.0 |
| 2022-03-06 20:00:00 | ZN | Futures | 132.294114 | 132.454549 | 132.294114 | 132.438505 | 27.0 |
| 2022-03-06 21:00:00 | ZN | Futures | 132.486636 | 132.518722 | 132.294114 | 132.294114 | 50.0 |
| 2022-03-06 22:00:00 | ZN | Futures | 132.310158 | 132.358288 | 132.165767 | 132.262027 | 141.0 |
| 2022-03-06 23:00:00 | ZN | Futures | 132.294114 | 132.294114 | 132.245984 | 132.262027 | 8.0 |
> showing 36 of 440 rows — these rows as CSV