PREVIEW / futures_1hour / 2008-09-28
file: by_date/futures_1hour/2008/2008-09-28.parquet size: 13 KB rows: 236
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-28 18:00:00 | ES | Futures | 1154.85 | 1156.03 | 1144.67 | 1152.01 | 36309.0 |
| 2008-09-28 19:00:00 | ES | Futures | 1151.77 | 1154.14 | 1147.75 | 1147.75 | 7486.0 |
| 2008-09-28 20:00:00 | ES | Futures | 1147.75 | 1153.67 | 1147.28 | 1152.25 | 11090.0 |
| 2008-09-28 21:00:00 | ES | Futures | 1152.25 | 1152.72 | 1146.33 | 1146.57 | 5934.0 |
| 2008-09-28 22:00:00 | ES | Futures | 1146.33 | 1146.57 | 1139.23 | 1141.12 | 10063.0 |
| 2008-09-28 23:00:00 | ES | Futures | 1141.36 | 1142.78 | 1140.18 | 1140.41 | 2840.0 |
| 2008-09-28 18:00:00 | NQ | Futures | 1902.36 | 1910.57 | 1891.04 | 1904.06 | 1087.0 |
| 2008-09-28 19:00:00 | NQ | Futures | 1903.21 | 1905.76 | 1892.46 | 1893.59 | 372.0 |
| 2008-09-28 20:00:00 | NQ | Futures | 1893.59 | 1904.34 | 1893.59 | 1900.95 | 354.0 |
| 2008-09-28 21:00:00 | NQ | Futures | 1900.95 | 1901.8 | 1889.06 | 1890.2 | 301.0 |
| 2008-09-28 22:00:00 | NQ | Futures | 1889.06 | 1889.06 | 1880.01 | 1882.27 | 618.0 |
| 2008-09-28 23:00:00 | NQ | Futures | 1882.27 | 1883.97 | 1881.42 | 1881.42 | 81.0 |
| 2008-09-28 18:00:00 | YM | Futures | 10169.3 | 10185.7 | 10106.6 | 10163.0 | 1616.0 |
| 2008-09-28 19:00:00 | YM | Futures | 10162.1 | 10181.2 | 10129.3 | 10130.2 | 665.0 |
| 2008-09-28 20:00:00 | YM | Futures | 10130.2 | 10170.2 | 10124.8 | 10168.4 | 702.0 |
| 2008-09-28 21:00:00 | YM | Futures | 10166.6 | 10169.3 | 10122.0 | 10122.0 | 473.0 |
| 2008-09-28 22:00:00 | YM | Futures | 10122.9 | 10122.9 | 10056.5 | 10073.8 | 1324.0 |
| 2008-09-28 23:00:00 | YM | Futures | 10071.1 | 10092.0 | 10069.3 | 10072.0 | 240.0 |
| 2008-09-28 18:00:00 | CL | Futures | 403.15 | 403.22 | 399.41 | 400.43 | 879.0 |
| 2008-09-28 19:00:00 | CL | Futures | 400.43 | 401.45 | 400.39 | 401.38 | 226.0 |
| 2008-09-28 20:00:00 | CL | Futures | 401.38 | 402.24 | 400.17 | 400.32 | 363.0 |
| 2008-09-28 21:00:00 | CL | Futures | 400.21 | 400.85 | 399.79 | 400.21 | 261.0 |
| 2008-09-28 22:00:00 | CL | Futures | 400.06 | 400.21 | 398.36 | 399.15 | 419.0 |
| 2008-09-28 23:00:00 | CL | Futures | 399.23 | 399.53 | 398.81 | 398.81 | 152.0 |
| 2008-09-28 18:00:00 | GC | Futures | 1253.1 | 1263.1 | 1250.4 | 1251.8 | 1801.0 |
| 2008-09-28 19:00:00 | GC | Futures | 1252.0 | 1262.8 | 1251.2 | 1258.0 | 944.0 |
| 2008-09-28 20:00:00 | GC | Futures | 1257.7 | 1258.9 | 1248.1 | 1251.1 | 2161.0 |
| 2008-09-28 21:00:00 | GC | Futures | 1251.0 | 1255.5 | 1249.5 | 1254.0 | 773.0 |
| 2008-09-28 22:00:00 | GC | Futures | 1254.0 | 1259.5 | 1253.5 | 1257.1 | 592.0 |
| 2008-09-28 23:00:00 | GC | Futures | 1256.8 | 1261.4 | 1256.2 | 1258.9 | 545.0 |
| 2008-09-28 18:00:00 | ZN | Futures | 86.56082 | 86.56082 | 86.395447 | 86.489946 | 6388.0 |
| 2008-09-28 19:00:00 | ZN | Futures | 86.501758 | 86.608069 | 86.489946 | 86.56082 | 1899.0 |
| 2008-09-28 20:00:00 | ZN | Futures | 86.56082 | 86.619882 | 86.525383 | 86.56082 | 2207.0 |
| 2008-09-28 21:00:00 | ZN | Futures | 86.56082 | 86.572632 | 86.513571 | 86.525383 | 2163.0 |
| 2008-09-28 22:00:00 | ZN | Futures | 86.537195 | 86.643506 | 86.525383 | 86.631694 | 2609.0 |
| 2008-09-28 23:00:00 | ZN | Futures | 86.643506 | 86.667131 | 86.608069 | 86.643506 | 924.0 |
> showing 36 of 236 rows — these rows as CSV