PREVIEW / futures_1hour / 2012-02-26
file: by_date/futures_1hour/2012/2012-02-26.parquet size: 13 KB rows: 264
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-26 18:00:00 | ES | Futures | 1374.09 | 1375.85 | 1374.09 | 1374.59 | 7921.0 |
| 2012-02-26 19:00:00 | ES | Futures | 1374.85 | 1375.1 | 1372.07 | 1372.83 | 8967.0 |
| 2012-02-26 20:00:00 | ES | Futures | 1372.58 | 1374.34 | 1371.82 | 1373.59 | 5084.0 |
| 2012-02-26 21:00:00 | ES | Futures | 1373.59 | 1373.84 | 1372.58 | 1372.58 | 3007.0 |
| 2012-02-26 22:00:00 | ES | Futures | 1372.58 | 1373.08 | 1372.07 | 1373.08 | 2165.0 |
| 2012-02-26 23:00:00 | ES | Futures | 1372.83 | 1373.59 | 1371.82 | 1372.07 | 2040.0 |
| 2012-02-26 18:00:00 | NQ | Futures | 3006.39 | 3010.15 | 3005.24 | 3007.83 | 409.0 |
| 2012-02-26 19:00:00 | NQ | Futures | 3007.55 | 3008.41 | 3001.19 | 3002.64 | 938.0 |
| 2012-02-26 20:00:00 | NQ | Futures | 3002.35 | 3005.81 | 3001.19 | 3003.79 | 312.0 |
| 2012-02-26 21:00:00 | NQ | Futures | 3004.08 | 3004.95 | 3002.35 | 3002.93 | 237.0 |
| 2012-02-26 22:00:00 | NQ | Futures | 3002.93 | 3003.5 | 3001.77 | 3003.5 | 115.0 |
| 2012-02-26 23:00:00 | NQ | Futures | 3003.5 | 3004.66 | 3001.77 | 3002.06 | 124.0 |
| 2012-02-26 18:00:00 | YM | Futures | 12844.1 | 12858.0 | 12841.1 | 12850.1 | 362.0 |
| 2012-02-26 19:00:00 | YM | Futures | 12849.1 | 12852.1 | 12828.3 | 12834.2 | 378.0 |
| 2012-02-26 20:00:00 | YM | Futures | 12833.2 | 12847.1 | 12827.3 | 12839.2 | 255.0 |
| 2012-02-26 21:00:00 | YM | Futures | 12839.2 | 12845.1 | 12833.2 | 12834.2 | 212.0 |
| 2012-02-26 22:00:00 | YM | Futures | 12835.2 | 12839.2 | 12832.2 | 12839.2 | 146.0 |
| 2012-02-26 23:00:00 | YM | Futures | 12837.2 | 12842.1 | 12830.2 | 12831.2 | 149.0 |
| 2012-02-26 18:00:00 | CL | Futures | 184.01 | 184.17 | 183.65 | 183.86 | 1202.0 |
| 2012-02-26 19:00:00 | CL | Futures | 183.84 | 183.89 | 183.39 | 183.45 | 1499.0 |
| 2012-02-26 20:00:00 | CL | Futures | 183.47 | 183.99 | 183.4 | 183.72 | 1229.0 |
| 2012-02-26 21:00:00 | CL | Futures | 183.76 | 183.91 | 183.64 | 183.69 | 424.0 |
| 2012-02-26 22:00:00 | CL | Futures | 183.7 | 183.79 | 183.59 | 183.64 | 407.0 |
| 2012-02-26 23:00:00 | CL | Futures | 183.64 | 183.77 | 183.47 | 183.52 | 593.0 |
| 2012-02-26 00:00:00 | GC | Futures | 2467.2 | 2467.2 | 2467.2 | 2467.2 | 2.0 |
| 2012-02-26 18:00:00 | GC | Futures | 2466.1 | 2466.9 | 2462.1 | 2462.9 | 1572.0 |
| 2012-02-26 19:00:00 | GC | Futures | 2462.6 | 2464.6 | 2460.8 | 2462.5 | 1899.0 |
| 2012-02-26 20:00:00 | GC | Futures | 2462.5 | 2470.3 | 2462.5 | 2469.6 | 3299.0 |
| 2012-02-26 21:00:00 | GC | Futures | 2469.6 | 2470.3 | 2466.9 | 2467.4 | 1601.0 |
| 2012-02-26 22:00:00 | GC | Futures | 2467.2 | 2467.6 | 2465.1 | 2465.1 | 870.0 |
| 2012-02-26 23:00:00 | GC | Futures | 2465.3 | 2467.9 | 2465.0 | 2467.6 | 971.0 |
| 2012-02-26 18:00:00 | ZN | Futures | 114.53339 | 114.547029 | 114.49247 | 114.51975 | 4953.0 |
| 2012-02-26 19:00:00 | ZN | Futures | 114.50611 | 114.560669 | 114.49247 | 114.547029 | 4176.0 |
| 2012-02-26 20:00:00 | ZN | Futures | 114.547029 | 114.574309 | 114.53339 | 114.547029 | 3425.0 |
| 2012-02-26 21:00:00 | ZN | Futures | 114.560669 | 114.587949 | 114.547029 | 114.574309 | 2904.0 |
| 2012-02-26 22:00:00 | ZN | Futures | 114.587949 | 114.587949 | 114.560669 | 114.574309 | 3490.0 |
| 2012-02-26 23:00:00 | ZN | Futures | 114.574309 | 114.574309 | 114.53339 | 114.560669 | 3722.0 |
> showing 37 of 264 rows — these rows as CSV