PREVIEW / futures_30min / 2014-12-29
file: by_date/futures_30min/2014/2014-12-29.parquet size: 75 KB rows: 2,832
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-12-29 00:00:00 | ES | Futures | 2195.74 | 2195.74 | 2194.42 | 2195.48 | 1267.0 |
| 2014-12-29 00:30:00 | ES | Futures | 2195.48 | 2196.27 | 2194.95 | 2195.48 | 885.0 |
| 2014-12-29 01:00:00 | ES | Futures | 2195.48 | 2195.74 | 2194.95 | 2195.48 | 387.0 |
| 2014-12-29 01:30:00 | ES | Futures | 2195.48 | 2196.27 | 2195.48 | 2196.0 | 304.0 |
| 2014-12-29 02:00:00 | ES | Futures | 2196.27 | 2196.53 | 2194.95 | 2194.95 | 2065.0 |
| 2014-12-29 02:30:00 | ES | Futures | 2195.21 | 2195.48 | 2194.42 | 2194.69 | 1013.0 |
| 2014-12-29 03:00:00 | ES | Futures | 2194.69 | 2195.48 | 2193.37 | 2194.69 | 4505.0 |
| 2014-12-29 03:30:00 | ES | Futures | 2194.42 | 2195.21 | 2193.63 | 2193.9 | 4028.0 |
| 2014-12-29 04:00:00 | ES | Futures | 2194.16 | 2194.16 | 2188.63 | 2189.95 | 10464.0 |
| 2014-12-29 04:30:00 | ES | Futures | 2189.95 | 2192.05 | 2189.42 | 2190.74 | 5351.0 |
| 2014-12-29 05:00:00 | ES | Futures | 2190.74 | 2191.53 | 2188.63 | 2188.9 | 4736.0 |
| 2014-12-29 05:30:00 | ES | Futures | 2188.9 | 2191.79 | 2185.21 | 2188.63 | 13160.0 |
| 2014-12-29 06:00:00 | ES | Futures | 2188.9 | 2191.79 | 2188.9 | 2189.95 | 6573.0 |
| 2014-12-29 06:30:00 | ES | Futures | 2190.21 | 2191.53 | 2188.11 | 2191.53 | 5169.0 |
| 2014-12-29 07:00:00 | ES | Futures | 2191.27 | 2192.05 | 2189.69 | 2190.21 | 3486.0 |
| 2014-12-29 07:30:00 | ES | Futures | 2190.21 | 2190.21 | 2187.32 | 2187.84 | 7552.0 |
| 2014-12-29 08:00:00 | ES | Futures | 2187.84 | 2189.16 | 2187.06 | 2187.06 | 7721.0 |
| 2014-12-29 08:30:00 | ES | Futures | 2187.32 | 2191.79 | 2186.79 | 2191.0 | 8690.0 |
| 2014-12-29 09:00:00 | ES | Futures | 2191.27 | 2191.79 | 2189.69 | 2191.27 | 9298.0 |
| 2014-12-29 09:30:00 | ES | Futures | 2191.53 | 2197.32 | 2190.48 | 2196.79 | 99801.0 |
| 2014-12-29 10:00:00 | ES | Futures | 2196.79 | 2198.11 | 2195.74 | 2196.0 | 45719.0 |
| 2014-12-29 10:30:00 | ES | Futures | 2196.0 | 2198.63 | 2196.0 | 2198.11 | 40971.0 |
| 2014-12-29 11:00:00 | ES | Futures | 2197.84 | 2198.63 | 2196.79 | 2197.84 | 38016.0 |
| 2014-12-29 11:30:00 | ES | Futures | 2197.84 | 2198.63 | 2197.32 | 2197.32 | 28076.0 |
| 2014-12-29 12:00:00 | ES | Futures | 2197.32 | 2198.63 | 2195.48 | 2195.74 | 33585.0 |
| 2014-12-29 12:30:00 | ES | Futures | 2195.74 | 2196.79 | 2194.69 | 2194.95 | 21020.0 |
| 2014-12-29 13:00:00 | ES | Futures | 2194.95 | 2197.58 | 2194.16 | 2196.53 | 31551.0 |
| 2014-12-29 13:30:00 | ES | Futures | 2196.79 | 2197.05 | 2194.69 | 2195.74 | 19879.0 |
| 2014-12-29 14:00:00 | ES | Futures | 2195.48 | 2196.79 | 2194.69 | 2196.53 | 24285.0 |
| 2014-12-29 14:30:00 | ES | Futures | 2196.27 | 2196.79 | 2195.48 | 2196.79 | 14819.0 |
| 2014-12-29 15:00:00 | ES | Futures | 2196.53 | 2197.32 | 2196.0 | 2196.27 | 22882.0 |
| 2014-12-29 15:30:00 | ES | Futures | 2196.27 | 2197.32 | 2194.16 | 2195.48 | 63051.0 |
| 2014-12-29 16:00:00 | ES | Futures | 2195.74 | 2196.53 | 2195.21 | 2195.74 | 36121.0 |
| 2014-12-29 16:30:00 | ES | Futures | 2195.74 | 2197.84 | 2195.74 | 2197.84 | 3416.0 |
| 2014-12-29 17:00:00 | ES | Futures | 2197.58 | 2197.58 | 2197.05 | 2197.05 | 898.0 |
| 2014-12-29 18:00:00 | ES | Futures | 2197.32 | 2197.84 | 2196.79 | 2197.32 | 1065.0 |
| 2014-12-29 18:30:00 | ES | Futures | 2197.05 | 2197.58 | 2196.79 | 2197.32 | 573.0 |
| 2014-12-29 19:00:00 | ES | Futures | 2197.32 | 2197.84 | 2197.05 | 2197.58 | 982.0 |
| 2014-12-29 19:30:00 | ES | Futures | 2197.58 | 2198.11 | 2197.32 | 2198.11 | 1072.0 |
| 2014-12-29 20:00:00 | ES | Futures | 2197.84 | 2198.11 | 2197.58 | 2197.84 | 757.0 |
| 2014-12-29 20:30:00 | ES | Futures | 2197.84 | 2197.84 | 2197.05 | 2197.32 | 907.0 |
| 2014-12-29 21:00:00 | ES | Futures | 2197.58 | 2197.84 | 2197.05 | 2197.58 | 616.0 |
| 2014-12-29 21:30:00 | ES | Futures | 2197.58 | 2197.84 | 2197.32 | 2197.58 | 453.0 |
| 2014-12-29 22:00:00 | ES | Futures | 2197.58 | 2198.11 | 2197.32 | 2197.58 | 332.0 |
| 2014-12-29 22:30:00 | ES | Futures | 2197.84 | 2197.84 | 2197.32 | 2197.58 | 620.0 |
| 2014-12-29 23:00:00 | ES | Futures | 2197.32 | 2197.84 | 2197.32 | 2197.58 | 677.0 |
| 2014-12-29 23:30:00 | ES | Futures | 2197.58 | 2198.37 | 2197.32 | 2197.84 | 842.0 |
| 2014-12-29 00:00:00 | NQ | Futures | 5073.76 | 5074.35 | 5071.41 | 5074.35 | 217.0 |
| 2014-12-29 00:30:00 | NQ | Futures | 5074.35 | 5074.94 | 5072.29 | 5072.29 | 210.0 |
| 2014-12-29 01:00:00 | NQ | Futures | 5072.88 | 5073.76 | 5071.7 | 5073.47 | 81.0 |
> showing 50 of 2,832 rows — these rows as CSV