PREVIEW / futures_1hour / 2008-05-04
file: by_date/futures_1hour/2008/2008-05-04.parquet size: 13 KB rows: 234
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-05-04 18:00:00 | ES | Futures | 1316.5 | 1316.96 | 1315.33 | 1315.57 | 3222.0 |
| 2008-05-04 19:00:00 | ES | Futures | 1315.8 | 1317.2 | 1315.8 | 1316.27 | 1029.0 |
| 2008-05-04 20:00:00 | ES | Futures | 1316.27 | 1317.2 | 1316.03 | 1316.73 | 540.0 |
| 2008-05-04 21:00:00 | ES | Futures | 1316.5 | 1319.99 | 1304.62 | 1313.01 | 21658.0 |
| 2008-05-04 22:00:00 | ES | Futures | 1313.01 | 1314.17 | 1312.07 | 1312.77 | 2009.0 |
| 2008-05-04 23:00:00 | ES | Futures | 1312.54 | 1313.24 | 1309.75 | 1310.68 | 1899.0 |
| 2008-05-04 18:00:00 | NQ | Futures | 2247.92 | 2247.92 | 2244.25 | 2245.09 | 702.0 |
| 2008-05-04 19:00:00 | NQ | Futures | 2245.38 | 2248.77 | 2245.38 | 2248.2 | 76.0 |
| 2008-05-04 20:00:00 | NQ | Futures | 2247.64 | 2247.64 | 2246.22 | 2247.64 | 128.0 |
| 2008-05-04 21:00:00 | NQ | Futures | 2247.36 | 2253.01 | 2227.56 | 2242.55 | 3353.0 |
| 2008-05-04 22:00:00 | NQ | Futures | 2243.96 | 2243.96 | 2240.85 | 2241.98 | 140.0 |
| 2008-05-04 23:00:00 | NQ | Futures | 2241.98 | 2242.27 | 2236.89 | 2237.46 | 256.0 |
| 2008-05-04 18:00:00 | YM | Futures | 11851.5 | 11862.4 | 11839.7 | 11847.9 | 269.0 |
| 2008-05-04 19:00:00 | YM | Futures | 11847.9 | 11857.0 | 11846.1 | 11852.5 | 86.0 |
| 2008-05-04 20:00:00 | YM | Futures | 11851.5 | 11857.0 | 11848.8 | 11854.3 | 53.0 |
| 2008-05-04 21:00:00 | YM | Futures | 11856.1 | 11867.0 | 11786.1 | 11830.6 | 975.0 |
| 2008-05-04 22:00:00 | YM | Futures | 11828.8 | 11837.0 | 11822.5 | 11826.1 | 207.0 |
| 2008-05-04 23:00:00 | YM | Futures | 11826.1 | 11828.8 | 11803.4 | 11808.8 | 330.0 |
| 2008-05-04 18:00:00 | CL | Futures | 443.11 | 443.53 | 441.4 | 441.93 | 608.0 |
| 2008-05-04 19:00:00 | CL | Futures | 441.93 | 441.97 | 441.4 | 441.7 | 213.0 |
| 2008-05-04 20:00:00 | CL | Futures | 441.78 | 442.5 | 441.66 | 442.5 | 169.0 |
| 2008-05-04 21:00:00 | CL | Futures | 442.5 | 444.17 | 441.4 | 442.84 | 1393.0 |
| 2008-05-04 22:00:00 | CL | Futures | 442.96 | 443.07 | 441.93 | 442.35 | 610.0 |
| 2008-05-04 23:00:00 | CL | Futures | 442.54 | 442.61 | 441.85 | 442.04 | 102.0 |
| 2008-05-04 18:00:00 | GC | Futures | 1244.8 | 1250.2 | 1244.1 | 1249.7 | 1324.0 |
| 2008-05-04 19:00:00 | GC | Futures | 1250.2 | 1251.3 | 1249.0 | 1250.5 | 384.0 |
| 2008-05-04 20:00:00 | GC | Futures | 1250.5 | 1252.8 | 1249.9 | 1252.1 | 1166.0 |
| 2008-05-04 21:00:00 | GC | Futures | 1252.1 | 1254.7 | 1247.7 | 1249.9 | 2403.0 |
| 2008-05-04 22:00:00 | GC | Futures | 1249.7 | 1253.9 | 1248.7 | 1253.9 | 415.0 |
| 2008-05-04 23:00:00 | GC | Futures | 1253.9 | 1254.4 | 1251.2 | 1252.1 | 266.0 |
| 2008-05-04 18:00:00 | ZN | Futures | 85.037423 | 85.048985 | 84.968052 | 84.991176 | 889.0 |
| 2008-05-04 19:00:00 | ZN | Futures | 84.979614 | 85.002737 | 84.944928 | 84.968052 | 744.0 |
| 2008-05-04 20:00:00 | ZN | Futures | 84.968052 | 85.025861 | 84.968052 | 84.991176 | 908.0 |
| 2008-05-04 21:00:00 | ZN | Futures | 84.979614 | 85.418964 | 84.979614 | 85.129918 | 25760.0 |
| 2008-05-04 22:00:00 | ZN | Futures | 85.129918 | 85.187727 | 85.118356 | 85.176165 | 1099.0 |
| 2008-05-04 23:00:00 | ZN | Futures | 85.164603 | 85.280222 | 85.164603 | 85.280222 | 3568.0 |
> showing 36 of 234 rows — these rows as CSV