PREVIEW / futures_1hour / 2011-07-17
file: by_date/futures_1hour/2011/2011-07-17.parquet size: 14 KB rows: 270
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-07-17 18:00:00 | ES | Futures | 1311.37 | 1311.62 | 1308.13 | 1309.88 | 12059.0 |
| 2011-07-17 19:00:00 | ES | Futures | 1309.88 | 1310.13 | 1307.88 | 1308.38 | 4024.0 |
| 2011-07-17 20:00:00 | ES | Futures | 1308.63 | 1308.63 | 1301.9 | 1303.39 | 22252.0 |
| 2011-07-17 21:00:00 | ES | Futures | 1303.14 | 1304.64 | 1301.4 | 1303.39 | 11724.0 |
| 2011-07-17 22:00:00 | ES | Futures | 1303.39 | 1306.64 | 1303.14 | 1305.89 | 7780.0 |
| 2011-07-17 23:00:00 | ES | Futures | 1305.89 | 1306.39 | 1304.64 | 1304.89 | 2553.0 |
| 2011-07-17 18:00:00 | NQ | Futures | 2710.17 | 2710.75 | 2705.28 | 2708.16 | 1063.0 |
| 2011-07-17 19:00:00 | NQ | Futures | 2708.16 | 2709.02 | 2704.42 | 2705.86 | 257.0 |
| 2011-07-17 20:00:00 | NQ | Futures | 2706.43 | 2706.43 | 2691.76 | 2694.92 | 1632.0 |
| 2011-07-17 21:00:00 | NQ | Futures | 2694.92 | 2697.8 | 2690.03 | 2695.21 | 1105.0 |
| 2011-07-17 22:00:00 | NQ | Futures | 2695.5 | 2702.69 | 2694.63 | 2699.53 | 631.0 |
| 2011-07-17 23:00:00 | NQ | Futures | 2699.53 | 2700.68 | 2697.51 | 2697.51 | 390.0 |
| 2011-07-17 18:00:00 | YM | Futures | 12059.5 | 12059.5 | 12028.5 | 12043.0 | 323.0 |
| 2011-07-17 19:00:00 | YM | Futures | 12041.1 | 12043.0 | 12024.6 | 12030.4 | 106.0 |
| 2011-07-17 20:00:00 | YM | Futures | 12030.4 | 12030.4 | 11974.3 | 11983.0 | 805.0 |
| 2011-07-17 21:00:00 | YM | Futures | 11981.0 | 11993.6 | 11961.7 | 11983.9 | 761.0 |
| 2011-07-17 22:00:00 | YM | Futures | 11983.9 | 12015.9 | 11982.0 | 12005.2 | 722.0 |
| 2011-07-17 23:00:00 | YM | Futures | 12005.2 | 12010.1 | 11996.5 | 11997.5 | 102.0 |
| 2011-07-17 18:00:00 | CL | Futures | 166.92 | 167.29 | 166.61 | 167.07 | 606.0 |
| 2011-07-17 19:00:00 | CL | Futures | 167.07 | 167.17 | 166.95 | 167.09 | 210.0 |
| 2011-07-17 20:00:00 | CL | Futures | 166.98 | 167.04 | 166.39 | 166.56 | 917.0 |
| 2011-07-17 21:00:00 | CL | Futures | 166.56 | 166.59 | 166.1 | 166.13 | 646.0 |
| 2011-07-17 22:00:00 | CL | Futures | 166.13 | 166.63 | 166.06 | 166.46 | 460.0 |
| 2011-07-17 23:00:00 | CL | Futures | 166.46 | 166.56 | 166.1 | 166.11 | 124.0 |
| 2011-07-17 18:00:00 | GC | Futures | 2223.7 | 2230.5 | 2223.5 | 2227.6 | 4610.0 |
| 2011-07-17 19:00:00 | GC | Futures | 2227.7 | 2228.1 | 2224.8 | 2227.4 | 821.0 |
| 2011-07-17 20:00:00 | GC | Futures | 2227.3 | 2228.3 | 2225.5 | 2226.3 | 1468.0 |
| 2011-07-17 21:00:00 | GC | Futures | 2226.2 | 2226.6 | 2221.8 | 2223.7 | 1577.0 |
| 2011-07-17 22:00:00 | GC | Futures | 2223.7 | 2225.3 | 2219.6 | 2224.6 | 1811.0 |
| 2011-07-17 23:00:00 | GC | Futures | 2224.6 | 2226.7 | 2223.7 | 2225.6 | 1173.0 |
| 2011-07-17 18:00:00 | ZN | Futures | 107.51766 | 107.531113 | 107.450394 | 107.450394 | 1749.0 |
| 2011-07-17 19:00:00 | ZN | Futures | 107.450394 | 107.4773 | 107.423487 | 107.423487 | 1720.0 |
| 2011-07-17 20:00:00 | ZN | Futures | 107.423487 | 107.598378 | 107.423487 | 107.571472 | 7352.0 |
| 2011-07-17 21:00:00 | ZN | Futures | 107.584925 | 107.625285 | 107.544566 | 107.558019 | 6158.0 |
| 2011-07-17 22:00:00 | ZN | Futures | 107.571472 | 107.571472 | 107.490753 | 107.504206 | 3520.0 |
| 2011-07-17 23:00:00 | ZN | Futures | 107.490753 | 107.544566 | 107.4773 | 107.544566 | 2056.0 |
> showing 36 of 270 rows — these rows as CSV