PREVIEW / futures_1hour / 2009-06-21
file: by_date/futures_1hour/2009/2009-06-21.parquet size: 12 KB rows: 205
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-21 18:00:00 | ES | Futures | 882.18 | 884.11 | 881.7 | 883.39 | 3516.0 |
| 2009-06-21 19:00:00 | ES | Futures | 883.39 | 883.63 | 882.18 | 882.43 | 1694.0 |
| 2009-06-21 20:00:00 | ES | Futures | 882.43 | 883.63 | 881.94 | 883.15 | 3244.0 |
| 2009-06-21 21:00:00 | ES | Futures | 883.39 | 883.63 | 880.98 | 881.7 | 4313.0 |
| 2009-06-21 22:00:00 | ES | Futures | 881.94 | 884.36 | 881.46 | 883.87 | 3428.0 |
| 2009-06-21 23:00:00 | ES | Futures | 883.63 | 884.11 | 882.91 | 883.15 | 1232.0 |
| 2009-06-21 18:00:00 | NQ | Futures | 1667.57 | 1669.27 | 1667.28 | 1668.7 | 223.0 |
| 2009-06-21 19:00:00 | NQ | Futures | 1669.56 | 1670.98 | 1666.14 | 1666.71 | 213.0 |
| 2009-06-21 20:00:00 | NQ | Futures | 1666.71 | 1670.13 | 1666.71 | 1669.56 | 285.0 |
| 2009-06-21 21:00:00 | NQ | Futures | 1670.13 | 1670.13 | 1665.29 | 1666.43 | 194.0 |
| 2009-06-21 22:00:00 | NQ | Futures | 1666.43 | 1671.84 | 1665.86 | 1670.41 | 214.0 |
| 2009-06-21 23:00:00 | NQ | Futures | 1669.84 | 1670.98 | 1668.7 | 1669.56 | 95.0 |
| 2009-06-21 18:00:00 | YM | Futures | 7823.4 | 7838.2 | 7821.5 | 7838.2 | 185.0 |
| 2009-06-21 19:00:00 | YM | Futures | 7839.1 | 7840.0 | 7830.8 | 7831.7 | 66.0 |
| 2009-06-21 20:00:00 | YM | Futures | 7831.7 | 7842.8 | 7829.8 | 7839.1 | 178.0 |
| 2009-06-21 21:00:00 | YM | Futures | 7839.1 | 7842.8 | 7820.6 | 7827.1 | 249.0 |
| 2009-06-21 22:00:00 | YM | Futures | 7826.1 | 7846.5 | 7825.2 | 7845.6 | 280.0 |
| 2009-06-21 23:00:00 | YM | Futures | 7840.9 | 7844.6 | 7837.2 | 7840.0 | 128.0 |
| 2009-06-21 18:00:00 | CL | Futures | 166.234 | 166.471 | 165.855 | 166.376 | 572.0 |
| 2009-06-21 19:00:00 | CL | Futures | 166.258 | 166.353 | 165.903 | 165.997 | 204.0 |
| 2009-06-21 20:00:00 | CL | Futures | 165.95 | 166.045 | 164.6 | 164.766 | 960.0 |
| 2009-06-21 21:00:00 | CL | Futures | 164.719 | 164.956 | 164.482 | 164.932 | 557.0 |
| 2009-06-21 22:00:00 | CL | Futures | 164.884 | 165.666 | 164.742 | 165.216 | 499.0 |
| 2009-06-21 23:00:00 | CL | Futures | 165.216 | 165.311 | 165.05 | 165.169 | 255.0 |
| 2009-06-21 18:00:00 | GC | Futures | 1324.8 | 1325.4 | 1323.4 | 1324.0 | 232.0 |
| 2009-06-21 19:00:00 | GC | Futures | 1324.0 | 1325.5 | 1323.0 | 1325.5 | 325.0 |
| 2009-06-21 20:00:00 | GC | Futures | 1325.5 | 1325.5 | 1323.4 | 1323.4 | 285.0 |
| 2009-06-21 21:00:00 | GC | Futures | 1323.5 | 1324.0 | 1322.4 | 1324.0 | 854.0 |
| 2009-06-21 22:00:00 | GC | Futures | 1323.7 | 1324.1 | 1323.1 | 1323.7 | 188.0 |
| 2009-06-21 23:00:00 | GC | Futures | 1323.8 | 1324.0 | 1322.7 | 1323.4 | 301.0 |
| 2009-06-21 18:00:00 | ZN | Futures | 90.819925 | 90.857126 | 90.770324 | 90.844726 | 560.0 |
| 2009-06-21 19:00:00 | ZN | Futures | 90.857126 | 90.881927 | 90.795124 | 90.807525 | 1202.0 |
| 2009-06-21 20:00:00 | ZN | Futures | 90.795124 | 90.807525 | 90.695922 | 90.708322 | 1879.0 |
| 2009-06-21 21:00:00 | ZN | Futures | 90.708322 | 90.770324 | 90.671121 | 90.745523 | 1778.0 |
| 2009-06-21 22:00:00 | ZN | Futures | 90.757923 | 90.757923 | 90.720722 | 90.745523 | 993.0 |
| 2009-06-21 23:00:00 | ZN | Futures | 90.733123 | 90.795124 | 90.733123 | 90.733123 | 1464.0 |
> showing 36 of 205 rows — these rows as CSV