PREVIEW / futures_1hour / 2012-11-18
file: by_date/futures_1hour/2012/2012-11-18.parquet size: 13 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 |
|---|---|---|---|---|---|---|---|
| 2012-11-18 18:00:00 | ES | Futures | 1390.49 | 1394.32 | 1389.98 | 1394.07 | 19403.0 |
| 2012-11-18 19:00:00 | ES | Futures | 1394.32 | 1395.34 | 1392.53 | 1393.04 | 12674.0 |
| 2012-11-18 20:00:00 | ES | Futures | 1393.04 | 1394.58 | 1392.02 | 1394.07 | 6830.0 |
| 2012-11-18 21:00:00 | ES | Futures | 1393.81 | 1394.83 | 1393.55 | 1394.07 | 4696.0 |
| 2012-11-18 22:00:00 | ES | Futures | 1394.07 | 1394.83 | 1393.81 | 1394.07 | 3988.0 |
| 2012-11-18 23:00:00 | ES | Futures | 1393.81 | 1394.32 | 1392.53 | 1393.04 | 3805.0 |
| 2012-11-18 18:00:00 | NQ | Futures | 2946.44 | 2955.74 | 2945.86 | 2955.45 | 1808.0 |
| 2012-11-18 19:00:00 | NQ | Futures | 2955.74 | 2957.49 | 2952.26 | 2953.13 | 1403.0 |
| 2012-11-18 20:00:00 | NQ | Futures | 2953.13 | 2956.32 | 2950.8 | 2954.58 | 814.0 |
| 2012-11-18 21:00:00 | NQ | Futures | 2954.87 | 2956.32 | 2954.0 | 2954.87 | 466.0 |
| 2012-11-18 22:00:00 | NQ | Futures | 2955.74 | 2956.32 | 2954.29 | 2954.58 | 318.0 |
| 2012-11-18 23:00:00 | NQ | Futures | 2954.58 | 2954.87 | 2951.67 | 2952.84 | 292.0 |
| 2012-11-18 18:00:00 | YM | Futures | 12585.5 | 12613.5 | 12579.5 | 12611.5 | 782.0 |
| 2012-11-18 19:00:00 | YM | Futures | 12611.5 | 12619.5 | 12596.5 | 12602.5 | 1322.0 |
| 2012-11-18 20:00:00 | YM | Futures | 12602.5 | 12614.5 | 12594.5 | 12608.5 | 958.0 |
| 2012-11-18 21:00:00 | YM | Futures | 12608.5 | 12617.5 | 12605.5 | 12610.5 | 434.0 |
| 2012-11-18 22:00:00 | YM | Futures | 12609.5 | 12615.5 | 12607.5 | 12609.5 | 562.0 |
| 2012-11-18 23:00:00 | YM | Futures | 12609.5 | 12611.5 | 12599.5 | 12604.5 | 389.0 |
| 2012-11-18 18:00:00 | CL | Futures | 141.03 | 141.64 | 140.72 | 141.48 | 2648.0 |
| 2012-11-18 19:00:00 | CL | Futures | 141.53 | 141.64 | 141.27 | 141.42 | 1552.0 |
| 2012-11-18 20:00:00 | CL | Futures | 141.42 | 141.56 | 141.35 | 141.48 | 707.0 |
| 2012-11-18 21:00:00 | CL | Futures | 141.48 | 141.51 | 141.37 | 141.43 | 800.0 |
| 2012-11-18 22:00:00 | CL | Futures | 141.43 | 141.53 | 141.37 | 141.47 | 444.0 |
| 2012-11-18 23:00:00 | CL | Futures | 141.45 | 141.76 | 141.42 | 141.71 | 909.0 |
| 2012-11-18 18:00:00 | GC | Futures | 2365.1 | 2370.6 | 2363.7 | 2369.1 | 1925.0 |
| 2012-11-18 19:00:00 | GC | Futures | 2369.2 | 2370.6 | 2366.9 | 2368.5 | 1598.0 |
| 2012-11-18 20:00:00 | GC | Futures | 2368.5 | 2375.4 | 2368.5 | 2374.3 | 4992.0 |
| 2012-11-18 21:00:00 | GC | Futures | 2374.6 | 2377.8 | 2374.3 | 2375.6 | 2280.0 |
| 2012-11-18 22:00:00 | GC | Futures | 2375.6 | 2376.9 | 2374.9 | 2376.0 | 1276.0 |
| 2012-11-18 23:00:00 | GC | Futures | 2375.8 | 2376.7 | 2374.7 | 2376.0 | 1026.0 |
| 2012-11-18 18:00:00 | ZN | Futures | 119.005289 | 119.019153 | 118.89438 | 118.908244 | 7899.0 |
| 2012-11-18 19:00:00 | ZN | Futures | 118.89438 | 118.935971 | 118.89438 | 118.922107 | 7614.0 |
| 2012-11-18 20:00:00 | ZN | Futures | 118.922107 | 118.935971 | 118.880516 | 118.908244 | 7687.0 |
| 2012-11-18 21:00:00 | ZN | Futures | 118.89438 | 118.908244 | 118.852789 | 118.852789 | 6086.0 |
| 2012-11-18 22:00:00 | ZN | Futures | 118.852789 | 118.866653 | 118.811198 | 118.838926 | 7169.0 |
| 2012-11-18 23:00:00 | ZN | Futures | 118.838926 | 118.880516 | 118.825062 | 118.866653 | 2871.0 |
> showing 36 of 260 rows — these rows as CSV