PREVIEW / futures_1hour / 2008-04-13
file: by_date/futures_1hour/2008/2008-04-13.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-04-13 18:00:00 | ES | Futures | 1243.62 | 1243.85 | 1239.66 | 1240.82 | 7086.0 |
| 2008-04-13 19:00:00 | ES | Futures | 1240.82 | 1242.22 | 1238.03 | 1238.5 | 5497.0 |
| 2008-04-13 20:00:00 | ES | Futures | 1238.5 | 1239.66 | 1237.33 | 1238.96 | 5312.0 |
| 2008-04-13 21:00:00 | ES | Futures | 1239.19 | 1240.13 | 1238.73 | 1239.43 | 2336.0 |
| 2008-04-13 22:00:00 | ES | Futures | 1239.66 | 1241.06 | 1238.96 | 1240.36 | 2549.0 |
| 2008-04-13 23:00:00 | ES | Futures | 1240.36 | 1240.82 | 1238.73 | 1238.73 | 1401.0 |
| 2008-04-13 18:00:00 | NQ | Futures | 2044.29 | 2044.57 | 2036.65 | 2039.48 | 452.0 |
| 2008-04-13 19:00:00 | NQ | Futures | 2039.48 | 2041.17 | 2036.37 | 2036.37 | 109.0 |
| 2008-04-13 20:00:00 | NQ | Futures | 2036.37 | 2037.78 | 2034.39 | 2037.78 | 236.0 |
| 2008-04-13 21:00:00 | NQ | Futures | 2037.21 | 2038.63 | 2037.21 | 2037.5 | 139.0 |
| 2008-04-13 22:00:00 | NQ | Futures | 2037.5 | 2039.76 | 2037.21 | 2039.76 | 119.0 |
| 2008-04-13 23:00:00 | NQ | Futures | 2039.19 | 2039.76 | 2036.37 | 2036.37 | 111.0 |
| 2008-04-13 18:00:00 | YM | Futures | 11207.3 | 11213.7 | 11181.0 | 11190.0 | 439.0 |
| 2008-04-13 19:00:00 | YM | Futures | 11190.0 | 11203.7 | 11167.3 | 11167.3 | 399.0 |
| 2008-04-13 20:00:00 | YM | Futures | 11166.4 | 11180.0 | 11159.1 | 11173.7 | 295.0 |
| 2008-04-13 21:00:00 | YM | Futures | 11174.6 | 11180.0 | 11171.0 | 11177.3 | 163.0 |
| 2008-04-13 22:00:00 | YM | Futures | 11178.2 | 11187.3 | 11170.1 | 11181.9 | 111.0 |
| 2008-04-13 23:00:00 | YM | Futures | 11181.9 | 11183.7 | 11166.4 | 11166.4 | 80.0 |
| 2008-04-13 18:00:00 | CL | Futures | 416.64 | 417.21 | 415.53 | 415.72 | 122.0 |
| 2008-04-13 19:00:00 | CL | Futures | 415.61 | 415.69 | 415.0 | 415.34 | 146.0 |
| 2008-04-13 20:00:00 | CL | Futures | 415.34 | 416.1 | 415.3 | 415.8 | 235.0 |
| 2008-04-13 21:00:00 | CL | Futures | 415.95 | 415.95 | 415.19 | 415.42 | 171.0 |
| 2008-04-13 22:00:00 | CL | Futures | 415.27 | 415.42 | 415.08 | 415.42 | 45.0 |
| 2008-04-13 23:00:00 | CL | Futures | 415.61 | 415.72 | 414.92 | 414.92 | 86.0 |
| 2008-04-13 18:00:00 | GC | Futures | 1339.0 | 1339.7 | 1334.9 | 1338.7 | 1237.0 |
| 2008-04-13 19:00:00 | GC | Futures | 1338.9 | 1340.0 | 1330.0 | 1330.9 | 1611.0 |
| 2008-04-13 20:00:00 | GC | Futures | 1331.0 | 1335.1 | 1329.3 | 1333.2 | 2022.0 |
| 2008-04-13 21:00:00 | GC | Futures | 1333.2 | 1333.8 | 1329.3 | 1329.3 | 1162.0 |
| 2008-04-13 22:00:00 | GC | Futures | 1329.4 | 1337.1 | 1329.4 | 1333.6 | 808.0 |
| 2008-04-13 23:00:00 | GC | Futures | 1334.2 | 1335.2 | 1331.0 | 1331.6 | 345.0 |
| 2008-04-13 18:00:00 | ZN | Futures | 87.523221 | 87.58103 | 87.523221 | 87.557907 | 1545.0 |
| 2008-04-13 19:00:00 | ZN | Futures | 87.557907 | 87.592592 | 87.534783 | 87.569469 | 1518.0 |
| 2008-04-13 20:00:00 | ZN | Futures | 87.557907 | 87.604154 | 87.534783 | 87.534783 | 2413.0 |
| 2008-04-13 21:00:00 | ZN | Futures | 87.534783 | 87.557907 | 87.488536 | 87.511659 | 1800.0 |
| 2008-04-13 22:00:00 | ZN | Futures | 87.511659 | 87.523221 | 87.500097 | 87.511659 | 835.0 |
| 2008-04-13 23:00:00 | ZN | Futures | 87.500097 | 87.523221 | 87.465412 | 87.511659 | 1953.0 |
> showing 36 of 236 rows — these rows as CSV