PREVIEW / futures_1hour / 2008-10-05
file: by_date/futures_1hour/2008/2008-10-05.parquet size: 14 KB rows: 247
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-10-05 18:00:00 | ES | Futures | 1044.81 | 1045.04 | 1032.03 | 1037.24 | 29439.0 |
| 2008-10-05 19:00:00 | ES | Futures | 1037.0 | 1037.24 | 1029.66 | 1030.85 | 13366.0 |
| 2008-10-05 20:00:00 | ES | Futures | 1031.08 | 1036.05 | 1031.08 | 1031.56 | 10021.0 |
| 2008-10-05 21:00:00 | ES | Futures | 1031.79 | 1033.45 | 1030.37 | 1031.32 | 8458.0 |
| 2008-10-05 22:00:00 | ES | Futures | 1031.08 | 1033.92 | 1029.9 | 1033.69 | 5523.0 |
| 2008-10-05 23:00:00 | ES | Futures | 1033.92 | 1034.63 | 1032.27 | 1033.21 | 2729.0 |
| 2008-10-05 18:00:00 | NQ | Futures | 1672.88 | 1675.14 | 1651.94 | 1656.47 | 2224.0 |
| 2008-10-05 19:00:00 | NQ | Futures | 1656.18 | 1657.88 | 1647.7 | 1649.68 | 787.0 |
| 2008-10-05 20:00:00 | NQ | Futures | 1651.37 | 1657.88 | 1650.81 | 1653.35 | 485.0 |
| 2008-10-05 21:00:00 | NQ | Futures | 1651.94 | 1654.2 | 1647.7 | 1648.54 | 484.0 |
| 2008-10-05 22:00:00 | NQ | Futures | 1648.54 | 1649.96 | 1642.89 | 1649.68 | 480.0 |
| 2008-10-05 23:00:00 | NQ | Futures | 1649.96 | 1652.22 | 1648.26 | 1648.83 | 373.0 |
| 2008-10-05 18:00:00 | YM | Futures | 9402.6 | 9402.6 | 9277.1 | 9319.8 | 1653.0 |
| 2008-10-05 19:00:00 | YM | Futures | 9320.7 | 9322.6 | 9258.9 | 9266.2 | 1277.0 |
| 2008-10-05 20:00:00 | YM | Futures | 9268.9 | 9309.8 | 9268.9 | 9273.5 | 754.0 |
| 2008-10-05 21:00:00 | YM | Futures | 9274.4 | 9285.3 | 9261.6 | 9272.5 | 556.0 |
| 2008-10-05 22:00:00 | YM | Futures | 9268.9 | 9293.5 | 9260.7 | 9291.6 | 376.0 |
| 2008-10-05 23:00:00 | YM | Futures | 9292.6 | 9298.0 | 9282.5 | 9288.9 | 215.0 |
| 2008-10-05 18:00:00 | CL | Futures | 348.87 | 349.55 | 345.48 | 346.5 | 810.0 |
| 2008-10-05 19:00:00 | CL | Futures | 346.46 | 347.06 | 346.31 | 346.69 | 444.0 |
| 2008-10-05 20:00:00 | CL | Futures | 346.69 | 348.42 | 346.05 | 346.54 | 438.0 |
| 2008-10-05 21:00:00 | CL | Futures | 346.54 | 348.23 | 346.2 | 347.03 | 220.0 |
| 2008-10-05 22:00:00 | CL | Futures | 347.59 | 347.59 | 346.8 | 346.99 | 109.0 |
| 2008-10-05 23:00:00 | CL | Futures | 346.88 | 348.01 | 346.84 | 347.44 | 220.0 |
| 2008-10-05 18:00:00 | GC | Futures | 1193.2 | 1194.9 | 1189.9 | 1190.9 | 1461.0 |
| 2008-10-05 19:00:00 | GC | Futures | 1190.7 | 1191.7 | 1182.3 | 1184.4 | 1059.0 |
| 2008-10-05 20:00:00 | GC | Futures | 1185.6 | 1191.4 | 1184.9 | 1187.6 | 1172.0 |
| 2008-10-05 21:00:00 | GC | Futures | 1187.2 | 1191.7 | 1186.9 | 1191.7 | 770.0 |
| 2008-10-05 22:00:00 | GC | Futures | 1191.3 | 1191.7 | 1189.9 | 1191.4 | 859.0 |
| 2008-10-05 23:00:00 | GC | Futures | 1191.6 | 1193.2 | 1190.0 | 1192.7 | 1068.0 |
| 2008-10-05 18:00:00 | ZN | Futures | 88.02555 | 88.155486 | 87.978301 | 88.072799 | 3208.0 |
| 2008-10-05 19:00:00 | ZN | Futures | 88.072799 | 88.438982 | 88.072799 | 88.344483 | 9403.0 |
| 2008-10-05 20:00:00 | ZN | Futures | 88.344483 | 88.344483 | 88.143673 | 88.190923 | 6161.0 |
| 2008-10-05 21:00:00 | ZN | Futures | 88.190923 | 88.249984 | 88.167298 | 88.238172 | 1821.0 |
| 2008-10-05 22:00:00 | ZN | Futures | 88.22636 | 88.344483 | 88.22636 | 88.332671 | 3323.0 |
| 2008-10-05 23:00:00 | ZN | Futures | 88.344483 | 88.344483 | 88.261797 | 88.273609 | 2083.0 |
> showing 36 of 247 rows — these rows as CSV