PREVIEW / futures_1hour / 2009-01-04
file: by_date/futures_1hour/2009/2009-01-04.parquet size: 13 KB rows: 231
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-01-04 18:00:00 | ES | Futures | 877.35 | 877.82 | 875.45 | 875.69 | 5332.0 |
| 2009-01-04 19:00:00 | ES | Futures | 875.69 | 877.11 | 873.79 | 876.64 | 4881.0 |
| 2009-01-04 20:00:00 | ES | Futures | 876.64 | 877.82 | 875.69 | 875.93 | 4058.0 |
| 2009-01-04 21:00:00 | ES | Futures | 875.93 | 876.4 | 873.79 | 874.03 | 3883.0 |
| 2009-01-04 22:00:00 | ES | Futures | 874.03 | 874.74 | 872.37 | 874.03 | 2280.0 |
| 2009-01-04 23:00:00 | ES | Futures | 874.03 | 874.74 | 873.08 | 874.5 | 1004.0 |
| 2009-01-04 18:00:00 | NQ | Futures | 1413.88 | 1414.44 | 1410.77 | 1411.9 | 486.0 |
| 2009-01-04 19:00:00 | NQ | Futures | 1411.34 | 1414.44 | 1409.08 | 1412.47 | 174.0 |
| 2009-01-04 20:00:00 | NQ | Futures | 1413.03 | 1415.29 | 1411.62 | 1413.03 | 89.0 |
| 2009-01-04 21:00:00 | NQ | Futures | 1412.19 | 1412.19 | 1407.95 | 1409.36 | 165.0 |
| 2009-01-04 22:00:00 | NQ | Futures | 1409.36 | 1409.64 | 1405.41 | 1409.64 | 96.0 |
| 2009-01-04 23:00:00 | NQ | Futures | 1409.08 | 1409.64 | 1407.39 | 1409.36 | 36.0 |
| 2009-01-04 18:00:00 | YM | Futures | 8146.8 | 8155.9 | 8137.7 | 8140.4 | 186.0 |
| 2009-01-04 19:00:00 | YM | Futures | 8140.4 | 8148.6 | 8128.6 | 8145.9 | 220.0 |
| 2009-01-04 20:00:00 | YM | Futures | 8146.8 | 8156.8 | 8144.1 | 8146.8 | 156.0 |
| 2009-01-04 21:00:00 | YM | Futures | 8145.9 | 8145.9 | 8126.7 | 8126.7 | 275.0 |
| 2009-01-04 22:00:00 | YM | Futures | 8127.7 | 8131.3 | 8115.8 | 8129.5 | 191.0 |
| 2009-01-04 23:00:00 | YM | Futures | 8131.3 | 8133.1 | 8118.5 | 8133.1 | 81.0 |
| 2009-01-04 18:00:00 | CL | Futures | 164.19 | 169.91 | 163.73 | 169.53 | 2086.0 |
| 2009-01-04 19:00:00 | CL | Futures | 169.53 | 169.63 | 165.27 | 165.9 | 1162.0 |
| 2009-01-04 20:00:00 | CL | Futures | 165.9 | 166.67 | 163.59 | 164.47 | 1220.0 |
| 2009-01-04 21:00:00 | CL | Futures | 164.29 | 165.93 | 163.73 | 164.4 | 707.0 |
| 2009-01-04 22:00:00 | CL | Futures | 164.61 | 164.92 | 164.08 | 164.54 | 225.0 |
| 2009-01-04 23:00:00 | CL | Futures | 164.54 | 164.78 | 163.7 | 163.98 | 336.0 |
| 2009-01-04 18:00:00 | GC | Futures | 1255.7 | 1262.6 | 1250.6 | 1261.1 | 2178.0 |
| 2009-01-04 19:00:00 | GC | Futures | 1261.4 | 1262.4 | 1253.0 | 1253.0 | 1046.0 |
| 2009-01-04 20:00:00 | GC | Futures | 1254.0 | 1255.6 | 1248.3 | 1249.2 | 1328.0 |
| 2009-01-04 21:00:00 | GC | Futures | 1249.2 | 1249.4 | 1238.5 | 1239.7 | 1859.0 |
| 2009-01-04 22:00:00 | GC | Futures | 1239.6 | 1243.2 | 1237.9 | 1243.0 | 829.0 |
| 2009-01-04 23:00:00 | GC | Futures | 1243.0 | 1243.3 | 1239.9 | 1240.9 | 501.0 |
| 2009-01-04 18:00:00 | ZN | Futures | 96.064819 | 96.221551 | 96.040706 | 96.113044 | 2050.0 |
| 2009-01-04 19:00:00 | ZN | Futures | 96.137157 | 96.173326 | 96.100988 | 96.137157 | 1640.0 |
| 2009-01-04 20:00:00 | ZN | Futures | 96.149213 | 96.16127 | 96.113044 | 96.125101 | 1191.0 |
| 2009-01-04 21:00:00 | ZN | Futures | 96.125101 | 96.149213 | 96.076875 | 96.088932 | 1863.0 |
| 2009-01-04 22:00:00 | ZN | Futures | 96.088932 | 96.088932 | 96.016594 | 96.02865 | 1060.0 |
| 2009-01-04 23:00:00 | ZN | Futures | 96.02865 | 96.040706 | 95.980425 | 96.004537 | 729.0 |
> showing 36 of 231 rows — these rows as CSV