PREVIEW / futures_1hour / 2011-11-06
file: by_date/futures_1hour/2011/2011-11-06.parquet size: 14 KB rows: 280
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-11-06 18:00:00 | ES | Futures | 1257.05 | 1263.32 | 1255.29 | 1257.55 | 19609.0 |
| 2011-11-06 19:00:00 | ES | Futures | 1257.55 | 1258.3 | 1255.04 | 1256.05 | 7428.0 |
| 2011-11-06 20:00:00 | ES | Futures | 1256.3 | 1258.05 | 1250.28 | 1252.54 | 9062.0 |
| 2011-11-06 21:00:00 | ES | Futures | 1252.29 | 1255.55 | 1250.28 | 1253.04 | 5655.0 |
| 2011-11-06 22:00:00 | ES | Futures | 1252.79 | 1254.04 | 1251.53 | 1252.79 | 3824.0 |
| 2011-11-06 23:00:00 | ES | Futures | 1253.04 | 1253.79 | 1251.28 | 1253.54 | 1884.0 |
| 2011-11-06 18:00:00 | NQ | Futures | 2717.73 | 2728.68 | 2714.84 | 2718.59 | 1043.0 |
| 2011-11-06 19:00:00 | NQ | Futures | 2718.59 | 2721.48 | 2716.0 | 2717.73 | 556.0 |
| 2011-11-06 20:00:00 | NQ | Futures | 2718.3 | 2721.19 | 2705.33 | 2708.79 | 930.0 |
| 2011-11-06 21:00:00 | NQ | Futures | 2707.92 | 2714.27 | 2705.62 | 2710.23 | 383.0 |
| 2011-11-06 22:00:00 | NQ | Futures | 2710.23 | 2712.83 | 2706.19 | 2711.1 | 377.0 |
| 2011-11-06 23:00:00 | NQ | Futures | 2710.52 | 2712.25 | 2707.35 | 2711.67 | 198.0 |
| 2011-11-06 18:00:00 | YM | Futures | 11773.4 | 11832.4 | 11767.5 | 11783.2 | 737.0 |
| 2011-11-06 19:00:00 | YM | Futures | 11783.2 | 11790.1 | 11764.5 | 11771.4 | 487.0 |
| 2011-11-06 20:00:00 | YM | Futures | 11771.4 | 11784.2 | 11721.2 | 11741.9 | 767.0 |
| 2011-11-06 21:00:00 | YM | Futures | 11740.9 | 11765.5 | 11725.1 | 11746.8 | 426.0 |
| 2011-11-06 22:00:00 | YM | Futures | 11746.8 | 11754.7 | 11733.0 | 11744.8 | 489.0 |
| 2011-11-06 23:00:00 | YM | Futures | 11745.8 | 11753.7 | 11735.0 | 11752.7 | 338.0 |
| 2011-11-06 18:00:00 | CL | Futures | 159.25 | 159.75 | 159.21 | 159.65 | 1412.0 |
| 2011-11-06 19:00:00 | CL | Futures | 159.67 | 160.06 | 159.5 | 159.85 | 990.0 |
| 2011-11-06 20:00:00 | CL | Futures | 159.84 | 159.92 | 159.08 | 159.4 | 1143.0 |
| 2011-11-06 21:00:00 | CL | Futures | 159.4 | 160.19 | 159.4 | 159.97 | 1446.0 |
| 2011-11-06 22:00:00 | CL | Futures | 159.96 | 160.09 | 159.69 | 159.75 | 667.0 |
| 2011-11-06 23:00:00 | CL | Futures | 159.75 | 159.84 | 159.45 | 159.7 | 462.0 |
| 2011-11-06 18:00:00 | GC | Futures | 2444.3 | 2452.8 | 2442.6 | 2448.0 | 1477.0 |
| 2011-11-06 19:00:00 | GC | Futures | 2447.6 | 2453.3 | 2444.8 | 2452.4 | 1129.0 |
| 2011-11-06 20:00:00 | GC | Futures | 2452.2 | 2462.7 | 2451.9 | 2459.2 | 3277.0 |
| 2011-11-06 21:00:00 | GC | Futures | 2459.2 | 2468.4 | 2457.5 | 2466.1 | 3012.0 |
| 2011-11-06 22:00:00 | GC | Futures | 2466.1 | 2469.5 | 2460.7 | 2466.6 | 2671.0 |
| 2011-11-06 23:00:00 | GC | Futures | 2467.0 | 2470.3 | 2466.0 | 2467.8 | 1510.0 |
| 2011-11-06 18:00:00 | ZN | Futures | 112.912672 | 112.953332 | 112.750032 | 112.872012 | 9500.0 |
| 2011-11-06 19:00:00 | ZN | Futures | 112.858458 | 112.926225 | 112.804245 | 112.912672 | 4400.0 |
| 2011-11-06 20:00:00 | ZN | Futures | 112.899118 | 113.021098 | 112.858458 | 112.939778 | 5014.0 |
| 2011-11-06 21:00:00 | ZN | Futures | 112.939778 | 112.980438 | 112.912672 | 112.966885 | 2065.0 |
| 2011-11-06 22:00:00 | ZN | Futures | 112.966885 | 113.021098 | 112.926225 | 112.980438 | 3069.0 |
| 2011-11-06 23:00:00 | ZN | Futures | 112.966885 | 112.980438 | 112.926225 | 112.980438 | 1049.0 |
> showing 36 of 280 rows — these rows as CSV