PREVIEW / futures_1hour / 2008-06-29
file: by_date/futures_1hour/2008/2008-06-29.parquet size: 12 KB rows: 214
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-06-29 18:00:00 | ES | Futures | 1191.59 | 1191.59 | 1189.97 | 1190.2 | 3667.0 |
| 2008-06-29 19:00:00 | ES | Futures | 1190.2 | 1192.06 | 1190.2 | 1191.83 | 2631.0 |
| 2008-06-29 20:00:00 | ES | Futures | 1191.83 | 1192.76 | 1190.9 | 1192.29 | 2918.0 |
| 2008-06-29 21:00:00 | ES | Futures | 1192.29 | 1194.15 | 1191.83 | 1194.15 | 3455.0 |
| 2008-06-29 22:00:00 | ES | Futures | 1194.15 | 1194.15 | 1191.83 | 1192.06 | 2051.0 |
| 2008-06-29 23:00:00 | ES | Futures | 1192.06 | 1192.29 | 1191.36 | 1192.06 | 2459.0 |
| 2008-06-29 18:00:00 | NQ | Futures | 2100.38 | 2104.32 | 2100.38 | 2101.79 | 375.0 |
| 2008-06-29 19:00:00 | NQ | Futures | 2101.23 | 2103.76 | 2099.54 | 2100.1 | 636.0 |
| 2008-06-29 20:00:00 | NQ | Futures | 2100.95 | 2103.76 | 2100.1 | 2102.07 | 220.0 |
| 2008-06-29 21:00:00 | NQ | Futures | 2103.48 | 2104.88 | 2102.07 | 2104.88 | 173.0 |
| 2008-06-29 22:00:00 | NQ | Futures | 2104.88 | 2104.88 | 2100.38 | 2100.95 | 101.0 |
| 2008-06-29 23:00:00 | NQ | Futures | 2100.66 | 2100.95 | 2100.66 | 2100.66 | 13.0 |
| 2008-06-29 18:00:00 | YM | Futures | 10329.4 | 10332.1 | 10319.4 | 10323.0 | 137.0 |
| 2008-06-29 19:00:00 | YM | Futures | 10323.0 | 10335.7 | 10321.2 | 10334.8 | 170.0 |
| 2008-06-29 20:00:00 | YM | Futures | 10335.7 | 10340.3 | 10326.6 | 10336.6 | 119.0 |
| 2008-06-29 21:00:00 | YM | Futures | 10338.4 | 10351.2 | 10330.3 | 10351.2 | 173.0 |
| 2008-06-29 22:00:00 | YM | Futures | 10350.3 | 10351.2 | 10331.2 | 10331.2 | 176.0 |
| 2008-06-29 23:00:00 | YM | Futures | 10330.3 | 10342.1 | 10329.4 | 10334.8 | 179.0 |
| 2008-06-29 18:00:00 | CL | Futures | 533.58 | 535.93 | 533.58 | 535.52 | 687.0 |
| 2008-06-29 19:00:00 | CL | Futures | 535.67 | 537.38 | 534.57 | 536.88 | 563.0 |
| 2008-06-29 20:00:00 | CL | Futures | 536.88 | 537.83 | 536.81 | 537.72 | 496.0 |
| 2008-06-29 21:00:00 | CL | Futures | 537.64 | 538.63 | 537.03 | 537.6 | 429.0 |
| 2008-06-29 22:00:00 | CL | Futures | 537.64 | 538.4 | 536.92 | 537.03 | 247.0 |
| 2008-06-29 23:00:00 | CL | Futures | 537.19 | 538.29 | 537.19 | 538.02 | 239.0 |
| 2008-06-29 18:00:00 | GC | Futures | 1341.9 | 1343.2 | 1339.3 | 1342.6 | 593.0 |
| 2008-06-29 19:00:00 | GC | Futures | 1342.6 | 1343.0 | 1340.9 | 1342.9 | 640.0 |
| 2008-06-29 20:00:00 | GC | Futures | 1342.5 | 1342.9 | 1337.0 | 1339.3 | 1116.0 |
| 2008-06-29 21:00:00 | GC | Futures | 1339.4 | 1340.6 | 1337.7 | 1338.3 | 1081.0 |
| 2008-06-29 22:00:00 | GC | Futures | 1338.3 | 1339.2 | 1337.1 | 1337.7 | 357.0 |
| 2008-06-29 23:00:00 | GC | Futures | 1337.7 | 1339.0 | 1337.6 | 1338.1 | 625.0 |
| 2008-06-29 18:00:00 | ZN | Futures | 85.300561 | 85.347365 | 85.28886 | 85.323963 | 966.0 |
| 2008-06-29 19:00:00 | ZN | Futures | 85.323963 | 85.39417 | 85.312262 | 85.370767 | 2448.0 |
| 2008-06-29 20:00:00 | ZN | Futures | 85.370767 | 85.370767 | 85.300561 | 85.312262 | 2418.0 |
| 2008-06-29 21:00:00 | ZN | Futures | 85.312262 | 85.347365 | 85.28886 | 85.323963 | 3226.0 |
| 2008-06-29 22:00:00 | ZN | Futures | 85.323963 | 85.382469 | 85.312262 | 85.370767 | 4375.0 |
| 2008-06-29 23:00:00 | ZN | Futures | 85.370767 | 85.487778 | 85.359066 | 85.417572 | 5797.0 |
> showing 36 of 214 rows — these rows as CSV