PREVIEW / futures_1hour / 2011-06-26
file: by_date/futures_1hour/2011/2011-06-26.parquet size: 14 KB rows: 260
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-26 18:00:00 | ES | Futures | 1261.99 | 1263.99 | 1254.01 | 1257.75 | 23390.0 |
| 2011-06-26 19:00:00 | ES | Futures | 1257.75 | 1258.25 | 1255.51 | 1257.5 | 7282.0 |
| 2011-06-26 20:00:00 | ES | Futures | 1257.5 | 1257.75 | 1254.51 | 1256.26 | 12374.0 |
| 2011-06-26 21:00:00 | ES | Futures | 1256.01 | 1257.5 | 1255.76 | 1257.25 | 6822.0 |
| 2011-06-26 22:00:00 | ES | Futures | 1257.0 | 1258.75 | 1256.51 | 1257.0 | 6284.0 |
| 2011-06-26 23:00:00 | ES | Futures | 1257.25 | 1259.0 | 1256.51 | 1259.0 | 4858.0 |
| 2011-06-26 18:00:00 | NQ | Futures | 2542.41 | 2549.6 | 2522.55 | 2534.92 | 4451.0 |
| 2011-06-26 19:00:00 | NQ | Futures | 2535.21 | 2535.21 | 2529.74 | 2533.77 | 712.0 |
| 2011-06-26 20:00:00 | NQ | Futures | 2533.77 | 2534.06 | 2528.31 | 2532.05 | 625.0 |
| 2011-06-26 21:00:00 | NQ | Futures | 2532.05 | 2533.2 | 2530.03 | 2532.33 | 1569.0 |
| 2011-06-26 22:00:00 | NQ | Futures | 2532.33 | 2536.36 | 2530.61 | 2532.91 | 684.0 |
| 2011-06-26 23:00:00 | NQ | Futures | 2533.2 | 2536.94 | 2531.76 | 2536.08 | 355.0 |
| 2011-06-26 18:00:00 | YM | Futures | 11506.5 | 11527.8 | 11444.5 | 11475.5 | 792.0 |
| 2011-06-26 19:00:00 | YM | Futures | 11473.6 | 11475.5 | 11456.2 | 11472.6 | 298.0 |
| 2011-06-26 20:00:00 | YM | Futures | 11469.7 | 11473.6 | 11449.4 | 11462.0 | 516.0 |
| 2011-06-26 21:00:00 | YM | Futures | 11462.0 | 11475.5 | 11458.1 | 11472.6 | 569.0 |
| 2011-06-26 22:00:00 | YM | Futures | 11471.7 | 11486.2 | 11467.8 | 11469.7 | 379.0 |
| 2011-06-26 23:00:00 | YM | Futures | 11471.7 | 11488.1 | 11466.8 | 11488.1 | 158.0 |
| 2011-06-26 18:00:00 | CL | Futures | 156.17 | 156.41 | 155.27 | 155.62 | 1708.0 |
| 2011-06-26 19:00:00 | CL | Futures | 155.59 | 155.86 | 155.15 | 155.35 | 694.0 |
| 2011-06-26 20:00:00 | CL | Futures | 155.33 | 155.66 | 154.91 | 155.37 | 1684.0 |
| 2011-06-26 21:00:00 | CL | Futures | 155.3 | 155.39 | 154.97 | 155.06 | 958.0 |
| 2011-06-26 22:00:00 | CL | Futures | 155.06 | 155.3 | 154.87 | 155.03 | 820.0 |
| 2011-06-26 23:00:00 | CL | Futures | 155.01 | 155.47 | 154.89 | 155.4 | 692.0 |
| 2011-06-26 18:00:00 | GC | Futures | 2093.4 | 2095.9 | 2090.0 | 2093.2 | 1831.0 |
| 2011-06-26 19:00:00 | GC | Futures | 2093.5 | 2096.7 | 2092.8 | 2095.1 | 783.0 |
| 2011-06-26 20:00:00 | GC | Futures | 2094.9 | 2095.3 | 2091.2 | 2093.5 | 2158.0 |
| 2011-06-26 21:00:00 | GC | Futures | 2093.7 | 2094.4 | 2090.0 | 2092.8 | 2297.0 |
| 2011-06-26 22:00:00 | GC | Futures | 2092.8 | 2096.5 | 2090.9 | 2095.3 | 1450.0 |
| 2011-06-26 23:00:00 | GC | Futures | 2095.1 | 2099.7 | 2094.6 | 2099.2 | 2107.0 |
| 2011-06-26 18:00:00 | ZN | Futures | 107.463847 | 107.544566 | 107.450394 | 107.504206 | 8559.0 |
| 2011-06-26 19:00:00 | ZN | Futures | 107.504206 | 107.51766 | 107.463847 | 107.4773 | 4349.0 |
| 2011-06-26 20:00:00 | ZN | Futures | 107.4773 | 107.544566 | 107.450394 | 107.51766 | 8258.0 |
| 2011-06-26 21:00:00 | ZN | Futures | 107.531113 | 107.531113 | 107.490753 | 107.51766 | 5272.0 |
| 2011-06-26 22:00:00 | ZN | Futures | 107.51766 | 107.531113 | 107.450394 | 107.490753 | 7065.0 |
| 2011-06-26 23:00:00 | ZN | Futures | 107.490753 | 107.51766 | 107.463847 | 107.490753 | 2846.0 |
> showing 36 of 260 rows — these rows as CSV