PREVIEW / futures_1hour / 2008-02-17
file: by_date/futures_1hour/2008/2008-02-17.parquet size: 10 KB rows: 145
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-02-17 18:00:00 | ES | Futures | 1259.04 | 1259.74 | 1255.78 | 1257.88 | 6327.0 |
| 2008-02-17 19:00:00 | ES | Futures | 1257.88 | 1258.81 | 1257.88 | 1258.11 | 2187.0 |
| 2008-02-17 20:00:00 | ES | Futures | 1258.34 | 1259.04 | 1257.88 | 1259.04 | 1322.0 |
| 2008-02-17 21:00:00 | ES | Futures | 1259.04 | 1259.04 | 1258.34 | 1258.58 | 1125.0 |
| 2008-02-17 22:00:00 | ES | Futures | 1258.58 | 1259.04 | 1258.11 | 1258.58 | 1272.0 |
| 2008-02-17 23:00:00 | ES | Futures | 1258.58 | 1259.04 | 1256.94 | 1258.34 | 1361.0 |
| 2008-02-17 18:00:00 | NQ | Futures | 2024.09 | 2027.5 | 2020.68 | 2024.66 | 673.0 |
| 2008-02-17 19:00:00 | NQ | Futures | 2024.94 | 2027.21 | 2023.52 | 2024.94 | 72.0 |
| 2008-02-17 20:00:00 | NQ | Futures | 2025.51 | 2027.5 | 2025.51 | 2027.5 | 302.0 |
| 2008-02-17 21:00:00 | NQ | Futures | 2027.78 | 2029.48 | 2027.78 | 2028.63 | 583.0 |
| 2008-02-17 22:00:00 | NQ | Futures | 2028.91 | 2029.48 | 2028.35 | 2028.35 | 78.0 |
| 2008-02-17 23:00:00 | NQ | Futures | 2028.63 | 2028.91 | 2026.08 | 2028.06 | 110.0 |
| 2008-02-17 18:00:00 | YM | Futures | 11217.2 | 11224.5 | 11196.3 | 11201.8 | 239.0 |
| 2008-02-17 19:00:00 | YM | Futures | 11204.5 | 11216.3 | 11200.9 | 11209.0 | 75.0 |
| 2008-02-17 20:00:00 | YM | Futures | 11211.8 | 11219.0 | 11210.9 | 11217.2 | 56.0 |
| 2008-02-17 21:00:00 | YM | Futures | 11217.2 | 11220.0 | 11212.7 | 11215.4 | 39.0 |
| 2008-02-17 22:00:00 | YM | Futures | 11215.4 | 11218.1 | 11210.0 | 11210.9 | 37.0 |
| 2008-02-17 23:00:00 | YM | Futures | 11210.9 | 11214.5 | 11205.4 | 11209.0 | 91.0 |
| 2008-02-17 18:00:00 | CL | Futures | 356.44 | 357.34 | 355.99 | 357.15 | 87.0 |
| 2008-02-17 19:00:00 | CL | Futures | 356.78 | 357.15 | 355.47 | 355.47 | 163.0 |
| 2008-02-17 20:00:00 | CL | Futures | 355.54 | 355.92 | 355.17 | 355.81 | 208.0 |
| 2008-02-17 21:00:00 | CL | Futures | 355.81 | 357.15 | 355.81 | 356.78 | 121.0 |
| 2008-02-17 22:00:00 | CL | Futures | 356.63 | 356.96 | 356.55 | 356.74 | 76.0 |
| 2008-02-17 23:00:00 | CL | Futures | 356.78 | 357.04 | 356.7 | 356.93 | 63.0 |
| 2008-02-17 18:00:00 | GC | Futures | 1317.6 | 1320.9 | 1316.7 | 1318.9 | 342.0 |
| 2008-02-17 19:00:00 | GC | Futures | 1319.5 | 1322.1 | 1319.5 | 1320.6 | 668.0 |
| 2008-02-17 20:00:00 | GC | Futures | 1320.2 | 1325.0 | 1320.2 | 1323.0 | 1070.0 |
| 2008-02-17 21:00:00 | GC | Futures | 1322.8 | 1324.3 | 1321.8 | 1322.7 | 478.0 |
| 2008-02-17 22:00:00 | GC | Futures | 1322.5 | 1323.3 | 1321.2 | 1322.0 | 318.0 |
| 2008-02-17 23:00:00 | GC | Futures | 1321.8 | 1322.7 | 1321.2 | 1322.7 | 286.0 |
| 2008-02-17 18:00:00 | ZN | Futures | 84.770379 | 84.884303 | 84.770379 | 84.850126 | 4798.0 |
| 2008-02-17 19:00:00 | ZN | Futures | 84.850126 | 84.861518 | 84.827341 | 84.838733 | 826.0 |
| 2008-02-17 20:00:00 | ZN | Futures | 84.838733 | 84.850126 | 84.827341 | 84.838733 | 508.0 |
| 2008-02-17 21:00:00 | ZN | Futures | 84.838733 | 84.850126 | 84.838733 | 84.850126 | 511.0 |
| 2008-02-17 22:00:00 | ZN | Futures | 84.838733 | 84.838733 | 84.827341 | 84.838733 | 559.0 |
| 2008-02-17 23:00:00 | ZN | Futures | 84.838733 | 84.838733 | 84.838733 | 84.838733 | 191.0 |
> showing 36 of 145 rows — these rows as CSV