PREVIEW / futures_30min / 2012-11-18
file: by_date/futures_30min/2012/2012-11-18.parquet size: 19 KB rows: 497
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-11-18 18:00:00 | ES | Futures | 1390.49 | 1393.3 | 1389.98 | 1393.04 | 14632.0 |
| 2012-11-18 18:30:00 | ES | Futures | 1393.04 | 1394.32 | 1392.53 | 1394.07 | 4771.0 |
| 2012-11-18 19:00:00 | ES | Futures | 1394.32 | 1395.34 | 1393.04 | 1393.81 | 8823.0 |
| 2012-11-18 19:30:00 | ES | Futures | 1393.81 | 1394.07 | 1392.53 | 1393.04 | 3851.0 |
| 2012-11-18 20:00:00 | ES | Futures | 1393.04 | 1393.81 | 1392.02 | 1393.3 | 3910.0 |
| 2012-11-18 20:30:00 | ES | Futures | 1393.3 | 1394.58 | 1393.04 | 1394.07 | 2920.0 |
| 2012-11-18 21:00:00 | ES | Futures | 1393.81 | 1394.58 | 1393.55 | 1393.81 | 2221.0 |
| 2012-11-18 21:30:00 | ES | Futures | 1393.81 | 1394.83 | 1393.55 | 1394.07 | 2475.0 |
| 2012-11-18 22:00:00 | ES | Futures | 1394.07 | 1394.83 | 1393.81 | 1394.58 | 1915.0 |
| 2012-11-18 22:30:00 | ES | Futures | 1394.32 | 1394.83 | 1393.81 | 1394.07 | 2073.0 |
| 2012-11-18 23:00:00 | ES | Futures | 1393.81 | 1394.32 | 1392.53 | 1392.79 | 1897.0 |
| 2012-11-18 23:30:00 | ES | Futures | 1392.79 | 1393.55 | 1392.53 | 1393.04 | 1908.0 |
| 2012-11-18 18:00:00 | NQ | Futures | 2946.44 | 2954.58 | 2945.86 | 2954.29 | 1372.0 |
| 2012-11-18 18:30:00 | NQ | Futures | 2954.29 | 2955.74 | 2952.84 | 2955.45 | 436.0 |
| 2012-11-18 19:00:00 | NQ | Futures | 2955.74 | 2957.49 | 2953.13 | 2954.29 | 1036.0 |
| 2012-11-18 19:30:00 | NQ | Futures | 2954.0 | 2954.58 | 2952.26 | 2953.13 | 367.0 |
| 2012-11-18 20:00:00 | NQ | Futures | 2953.13 | 2954.58 | 2950.8 | 2954.0 | 429.0 |
| 2012-11-18 20:30:00 | NQ | Futures | 2953.71 | 2956.32 | 2953.13 | 2954.58 | 385.0 |
| 2012-11-18 21:00:00 | NQ | Futures | 2954.87 | 2956.03 | 2954.0 | 2954.0 | 251.0 |
| 2012-11-18 21:30:00 | NQ | Futures | 2954.29 | 2956.32 | 2954.0 | 2954.87 | 215.0 |
| 2012-11-18 22:00:00 | NQ | Futures | 2955.74 | 2956.03 | 2954.29 | 2955.74 | 174.0 |
| 2012-11-18 22:30:00 | NQ | Futures | 2955.16 | 2956.32 | 2954.58 | 2954.58 | 144.0 |
| 2012-11-18 23:00:00 | NQ | Futures | 2954.58 | 2954.87 | 2951.97 | 2951.97 | 141.0 |
| 2012-11-18 23:30:00 | NQ | Futures | 2951.67 | 2953.71 | 2951.67 | 2952.84 | 151.0 |
| 2012-11-18 18:00:00 | YM | Futures | 12585.5 | 12606.5 | 12579.5 | 12603.5 | 523.0 |
| 2012-11-18 18:30:00 | YM | Futures | 12604.5 | 12613.5 | 12601.5 | 12611.5 | 259.0 |
| 2012-11-18 19:00:00 | YM | Futures | 12611.5 | 12619.5 | 12607.5 | 12611.5 | 656.0 |
| 2012-11-18 19:30:00 | YM | Futures | 12611.5 | 12611.5 | 12596.5 | 12602.5 | 666.0 |
| 2012-11-18 20:00:00 | YM | Futures | 12602.5 | 12608.5 | 12594.5 | 12606.5 | 635.0 |
| 2012-11-18 20:30:00 | YM | Futures | 12605.5 | 12614.5 | 12602.5 | 12608.5 | 323.0 |
| 2012-11-18 21:00:00 | YM | Futures | 12608.5 | 12614.5 | 12605.5 | 12607.5 | 257.0 |
| 2012-11-18 21:30:00 | YM | Futures | 12606.5 | 12617.5 | 12606.5 | 12610.5 | 177.0 |
| 2012-11-18 22:00:00 | YM | Futures | 12609.5 | 12615.5 | 12607.5 | 12611.5 | 194.0 |
| 2012-11-18 22:30:00 | YM | Futures | 12610.5 | 12615.5 | 12607.5 | 12609.5 | 368.0 |
| 2012-11-18 23:00:00 | YM | Futures | 12609.5 | 12611.5 | 12599.5 | 12599.5 | 235.0 |
| 2012-11-18 23:30:00 | YM | Futures | 12599.5 | 12608.5 | 12599.5 | 12604.5 | 154.0 |
| 2012-11-18 18:00:00 | CL | Futures | 141.03 | 141.64 | 140.72 | 141.53 | 1830.0 |
| 2012-11-18 18:30:00 | CL | Futures | 141.55 | 141.58 | 141.19 | 141.48 | 818.0 |
| 2012-11-18 19:00:00 | CL | Futures | 141.53 | 141.64 | 141.32 | 141.42 | 656.0 |
| 2012-11-18 19:30:00 | CL | Futures | 141.42 | 141.56 | 141.27 | 141.42 | 896.0 |
| 2012-11-18 20:00:00 | CL | Futures | 141.42 | 141.56 | 141.35 | 141.5 | 499.0 |
| 2012-11-18 20:30:00 | CL | Futures | 141.51 | 141.56 | 141.45 | 141.48 | 208.0 |
| 2012-11-18 21:00:00 | CL | Futures | 141.48 | 141.51 | 141.42 | 141.47 | 489.0 |
| 2012-11-18 21:30:00 | CL | Futures | 141.47 | 141.5 | 141.37 | 141.43 | 311.0 |
| 2012-11-18 22:00:00 | CL | Futures | 141.43 | 141.5 | 141.37 | 141.5 | 306.0 |
| 2012-11-18 22:30:00 | CL | Futures | 141.47 | 141.53 | 141.45 | 141.47 | 138.0 |
| 2012-11-18 23:00:00 | CL | Futures | 141.45 | 141.48 | 141.42 | 141.42 | 85.0 |
| 2012-11-18 23:30:00 | CL | Futures | 141.42 | 141.76 | 141.42 | 141.71 | 824.0 |
| 2012-11-18 18:00:00 | GC | Futures | 2365.1 | 2367.3 | 2363.7 | 2367.1 | 954.0 |
| 2012-11-18 18:30:00 | GC | Futures | 2367.1 | 2370.6 | 2366.7 | 2369.1 | 971.0 |
> showing 50 of 497 rows — these rows as CSV