PREVIEW / futures_30min / 2014-11-07
file: by_date/futures_30min/2014/2014-11-07.parquet size: 70 KB rows: 2,363
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-07 00:00:00 | ES | Futures | 2128.48 | 2129.01 | 2127.44 | 2128.22 | 2428.0 |
| 2014-11-07 00:30:00 | ES | Futures | 2128.22 | 2128.75 | 2127.96 | 2128.48 | 1409.0 |
| 2014-11-07 01:00:00 | ES | Futures | 2128.48 | 2129.79 | 2128.22 | 2129.53 | 2434.0 |
| 2014-11-07 01:30:00 | ES | Futures | 2129.79 | 2130.06 | 2129.01 | 2130.06 | 2183.0 |
| 2014-11-07 02:00:00 | ES | Futures | 2130.06 | 2130.06 | 2127.96 | 2128.48 | 5315.0 |
| 2014-11-07 02:30:00 | ES | Futures | 2128.48 | 2129.01 | 2127.44 | 2128.22 | 3084.0 |
| 2014-11-07 03:00:00 | ES | Futures | 2128.22 | 2128.48 | 2125.87 | 2126.91 | 12646.0 |
| 2014-11-07 03:30:00 | ES | Futures | 2126.91 | 2129.27 | 2126.39 | 2128.75 | 11298.0 |
| 2014-11-07 04:00:00 | ES | Futures | 2128.75 | 2129.27 | 2127.96 | 2128.22 | 6733.0 |
| 2014-11-07 04:30:00 | ES | Futures | 2128.22 | 2128.48 | 2126.65 | 2127.7 | 6990.0 |
| 2014-11-07 05:00:00 | ES | Futures | 2127.7 | 2128.48 | 2126.91 | 2127.18 | 6753.0 |
| 2014-11-07 05:30:00 | ES | Futures | 2127.18 | 2127.44 | 2123.25 | 2124.03 | 14047.0 |
| 2014-11-07 06:00:00 | ES | Futures | 2124.03 | 2125.08 | 2122.46 | 2123.77 | 10729.0 |
| 2014-11-07 06:30:00 | ES | Futures | 2124.03 | 2125.87 | 2122.98 | 2125.6 | 9833.0 |
| 2014-11-07 07:00:00 | ES | Futures | 2125.87 | 2126.91 | 2124.82 | 2125.87 | 7577.0 |
| 2014-11-07 07:30:00 | ES | Futures | 2125.6 | 2125.87 | 2123.77 | 2125.6 | 11138.0 |
| 2014-11-07 08:00:00 | ES | Futures | 2125.6 | 2126.91 | 2124.03 | 2126.91 | 13163.0 |
| 2014-11-07 08:30:00 | ES | Futures | 2126.65 | 2130.84 | 2123.25 | 2126.91 | 73693.0 |
| 2014-11-07 09:00:00 | ES | Futures | 2126.65 | 2126.91 | 2120.63 | 2123.51 | 54328.0 |
| 2014-11-07 09:30:00 | ES | Futures | 2123.51 | 2124.56 | 2117.74 | 2120.63 | 187848.0 |
| 2014-11-07 10:00:00 | ES | Futures | 2120.63 | 2123.77 | 2119.32 | 2120.1 | 128518.0 |
| 2014-11-07 10:30:00 | ES | Futures | 2120.36 | 2125.87 | 2117.22 | 2125.34 | 119826.0 |
| 2014-11-07 11:00:00 | ES | Futures | 2125.34 | 2127.18 | 2124.29 | 2126.91 | 72836.0 |
| 2014-11-07 11:30:00 | ES | Futures | 2126.91 | 2127.96 | 2124.56 | 2124.82 | 51246.0 |
| 2014-11-07 12:00:00 | ES | Futures | 2124.82 | 2126.91 | 2123.77 | 2126.13 | 47739.0 |
| 2014-11-07 12:30:00 | ES | Futures | 2126.13 | 2126.39 | 2124.29 | 2125.34 | 23973.0 |
| 2014-11-07 13:00:00 | ES | Futures | 2125.34 | 2126.39 | 2124.56 | 2125.87 | 27570.0 |
| 2014-11-07 13:30:00 | ES | Futures | 2125.87 | 2127.18 | 2125.34 | 2125.6 | 31971.0 |
| 2014-11-07 14:00:00 | ES | Futures | 2125.6 | 2126.39 | 2123.25 | 2124.03 | 36456.0 |
| 2014-11-07 14:30:00 | ES | Futures | 2124.03 | 2124.56 | 2120.89 | 2121.94 | 48863.0 |
| 2014-11-07 15:00:00 | ES | Futures | 2121.94 | 2123.77 | 2119.58 | 2119.58 | 50096.0 |
| 2014-11-07 15:30:00 | ES | Futures | 2119.84 | 2125.87 | 2119.05 | 2125.6 | 111003.0 |
| 2014-11-07 16:00:00 | ES | Futures | 2125.6 | 2126.13 | 2122.46 | 2122.72 | 55010.0 |
| 2014-11-07 16:30:00 | ES | Futures | 2122.72 | 2123.77 | 2121.67 | 2122.98 | 7163.0 |
| 2014-11-07 17:00:00 | ES | Futures | 2122.98 | 2123.51 | 2122.46 | 2122.72 | 1535.0 |
| 2014-11-07 00:00:00 | NQ | Futures | 4890.27 | 4892.02 | 4888.51 | 4889.68 | 447.0 |
| 2014-11-07 00:30:00 | NQ | Futures | 4889.97 | 4891.44 | 4889.09 | 4891.14 | 401.0 |
| 2014-11-07 01:00:00 | NQ | Futures | 4891.44 | 4895.25 | 4890.56 | 4895.25 | 502.0 |
| 2014-11-07 01:30:00 | NQ | Futures | 4895.25 | 4897.3 | 4894.07 | 4896.42 | 595.0 |
| 2014-11-07 02:00:00 | NQ | Futures | 4896.42 | 4896.42 | 4891.73 | 4892.32 | 881.0 |
| 2014-11-07 02:30:00 | NQ | Futures | 4892.61 | 4894.07 | 4889.68 | 4890.85 | 803.0 |
| 2014-11-07 03:00:00 | NQ | Futures | 4891.14 | 4891.44 | 4885.87 | 4889.97 | 2317.0 |
| 2014-11-07 03:30:00 | NQ | Futures | 4889.68 | 4894.66 | 4887.92 | 4894.37 | 1638.0 |
| 2014-11-07 04:00:00 | NQ | Futures | 4894.07 | 4895.25 | 4892.61 | 4894.07 | 1740.0 |
| 2014-11-07 04:30:00 | NQ | Futures | 4893.78 | 4894.07 | 4889.09 | 4891.73 | 859.0 |
| 2014-11-07 05:00:00 | NQ | Futures | 4891.44 | 4892.9 | 4889.68 | 4890.56 | 761.0 |
| 2014-11-07 05:30:00 | NQ | Futures | 4890.85 | 4891.14 | 4880.89 | 4882.94 | 2193.0 |
| 2014-11-07 06:00:00 | NQ | Futures | 4882.94 | 4885.87 | 4880.6 | 4882.65 | 1431.0 |
| 2014-11-07 06:30:00 | NQ | Futures | 4882.65 | 4887.63 | 4881.18 | 4887.63 | 1066.0 |
| 2014-11-07 07:00:00 | NQ | Futures | 4887.63 | 4890.27 | 4884.41 | 4887.34 | 972.0 |
> showing 50 of 2,363 rows — these rows as CSV