PREVIEW / futures_30min / 2014-09-08
file: by_date/futures_30min/2014/2014-09-08.parquet size: 76 KB rows: 2,777
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-09-08 00:00:00 | ES | Futures | 2089.08 | 2089.6 | 2088.82 | 2089.34 | 987.0 |
| 2014-09-08 00:30:00 | ES | Futures | 2089.08 | 2089.34 | 2089.08 | 2089.34 | 165.0 |
| 2014-09-08 01:00:00 | ES | Futures | 2089.34 | 2089.6 | 2089.08 | 2089.08 | 685.0 |
| 2014-09-08 01:30:00 | ES | Futures | 2089.08 | 2089.6 | 2088.82 | 2089.08 | 528.0 |
| 2014-09-08 02:00:00 | ES | Futures | 2089.08 | 2089.34 | 2087.78 | 2087.78 | 3459.0 |
| 2014-09-08 02:30:00 | ES | Futures | 2088.04 | 2088.56 | 2087.78 | 2088.3 | 3189.0 |
| 2014-09-08 03:00:00 | ES | Futures | 2088.3 | 2088.56 | 2087.26 | 2088.3 | 12719.0 |
| 2014-09-08 03:30:00 | ES | Futures | 2088.56 | 2089.34 | 2087.78 | 2089.08 | 4715.0 |
| 2014-09-08 04:00:00 | ES | Futures | 2089.34 | 2089.6 | 2087.52 | 2088.56 | 6763.0 |
| 2014-09-08 04:30:00 | ES | Futures | 2088.56 | 2088.82 | 2087.26 | 2088.04 | 4836.0 |
| 2014-09-08 05:00:00 | ES | Futures | 2088.04 | 2088.82 | 2087.52 | 2088.3 | 3922.0 |
| 2014-09-08 05:30:00 | ES | Futures | 2088.3 | 2088.3 | 2087.0 | 2087.26 | 6534.0 |
| 2014-09-08 06:00:00 | ES | Futures | 2087.52 | 2088.82 | 2087.26 | 2087.52 | 7499.0 |
| 2014-09-08 06:30:00 | ES | Futures | 2087.78 | 2088.3 | 2087.0 | 2087.52 | 6640.0 |
| 2014-09-08 07:00:00 | ES | Futures | 2087.78 | 2088.56 | 2086.74 | 2088.56 | 6170.0 |
| 2014-09-08 07:30:00 | ES | Futures | 2088.56 | 2088.82 | 2087.26 | 2088.3 | 6973.0 |
| 2014-09-08 08:00:00 | ES | Futures | 2088.56 | 2089.08 | 2087.52 | 2087.52 | 12452.0 |
| 2014-09-08 08:30:00 | ES | Futures | 2087.52 | 2088.56 | 2086.74 | 2087.26 | 12190.0 |
| 2014-09-08 09:00:00 | ES | Futures | 2087.26 | 2089.08 | 2087.0 | 2088.3 | 13796.0 |
| 2014-09-08 09:30:00 | ES | Futures | 2088.56 | 2091.17 | 2087.78 | 2089.86 | 109659.0 |
| 2014-09-08 10:00:00 | ES | Futures | 2089.86 | 2091.43 | 2085.43 | 2086.48 | 106860.0 |
| 2014-09-08 10:30:00 | ES | Futures | 2086.48 | 2088.3 | 2084.13 | 2087.78 | 102802.0 |
| 2014-09-08 11:00:00 | ES | Futures | 2087.78 | 2089.86 | 2086.74 | 2088.56 | 82862.0 |
| 2014-09-08 11:30:00 | ES | Futures | 2088.82 | 2089.6 | 2085.17 | 2085.69 | 62883.0 |
| 2014-09-08 12:00:00 | ES | Futures | 2085.95 | 2086.48 | 2084.91 | 2086.21 | 34384.0 |
| 2014-09-08 12:30:00 | ES | Futures | 2086.48 | 2087.52 | 2085.95 | 2086.48 | 29614.0 |
| 2014-09-08 13:00:00 | ES | Futures | 2086.74 | 2087.26 | 2080.74 | 2081.0 | 103071.0 |
| 2014-09-08 13:30:00 | ES | Futures | 2081.0 | 2081.78 | 2078.66 | 2079.96 | 97621.0 |
| 2014-09-08 14:00:00 | ES | Futures | 2080.22 | 2082.83 | 2079.7 | 2081.52 | 61483.0 |
| 2014-09-08 14:30:00 | ES | Futures | 2081.78 | 2083.09 | 2081.26 | 2082.31 | 26749.0 |
| 2014-09-08 15:00:00 | ES | Futures | 2082.57 | 2085.17 | 2082.31 | 2084.91 | 45823.0 |
| 2014-09-08 15:30:00 | ES | Futures | 2084.91 | 2086.74 | 2084.39 | 2085.17 | 112146.0 |
| 2014-09-08 16:00:00 | ES | Futures | 2085.17 | 2085.69 | 2084.65 | 2085.43 | 53539.0 |
| 2014-09-08 16:30:00 | ES | Futures | 2085.43 | 2086.48 | 2085.17 | 2086.48 | 4213.0 |
| 2014-09-08 17:00:00 | ES | Futures | 2086.48 | 2086.48 | 2085.43 | 2085.69 | 1286.0 |
| 2014-09-08 18:00:00 | ES | Futures | 2085.17 | 2085.69 | 2084.65 | 2084.65 | 2485.0 |
| 2014-09-08 18:30:00 | ES | Futures | 2084.91 | 2084.91 | 2084.39 | 2084.65 | 775.0 |
| 2014-09-08 19:00:00 | ES | Futures | 2084.91 | 2085.17 | 2084.65 | 2084.91 | 413.0 |
| 2014-09-08 19:30:00 | ES | Futures | 2084.65 | 2085.17 | 2084.39 | 2084.91 | 620.0 |
| 2014-09-08 20:00:00 | ES | Futures | 2084.91 | 2085.17 | 2084.65 | 2085.17 | 747.0 |
| 2014-09-08 20:30:00 | ES | Futures | 2084.91 | 2085.43 | 2084.13 | 2084.39 | 2073.0 |
| 2014-09-08 21:00:00 | ES | Futures | 2084.39 | 2084.65 | 2083.87 | 2084.39 | 1206.0 |
| 2014-09-08 21:30:00 | ES | Futures | 2084.13 | 2084.39 | 2083.35 | 2083.61 | 1648.0 |
| 2014-09-08 22:00:00 | ES | Futures | 2083.61 | 2084.65 | 2083.35 | 2084.39 | 1864.0 |
| 2014-09-08 22:30:00 | ES | Futures | 2084.13 | 2084.65 | 2083.09 | 2083.61 | 1593.0 |
| 2014-09-08 23:00:00 | ES | Futures | 2083.61 | 2084.39 | 2083.35 | 2084.13 | 1372.0 |
| 2014-09-08 23:30:00 | ES | Futures | 2083.87 | 2084.13 | 2082.05 | 2082.05 | 2937.0 |
| 2014-09-08 00:00:00 | NQ | Futures | 4770.35 | 4771.23 | 4769.48 | 4769.77 | 254.0 |
| 2014-09-08 00:30:00 | NQ | Futures | 4770.06 | 4770.35 | 4769.48 | 4770.06 | 67.0 |
| 2014-09-08 01:00:00 | NQ | Futures | 4770.35 | 4770.64 | 4770.06 | 4770.35 | 56.0 |
> showing 50 of 2,777 rows — these rows as CSV