PREVIEW / futures_30min / 2015-06-30
file: by_date/futures_30min/2015/2015-06-30.parquet size: 79 KB rows: 2,755
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-30 00:00:00 | ES | Futures | 2188.83 | 2189.09 | 2188.29 | 2188.83 | 1674.0 |
| 2015-06-30 00:30:00 | ES | Futures | 2188.56 | 2189.36 | 2188.29 | 2188.56 | 2419.0 |
| 2015-06-30 01:00:00 | ES | Futures | 2188.56 | 2189.09 | 2188.29 | 2188.83 | 1566.0 |
| 2015-06-30 01:30:00 | ES | Futures | 2188.83 | 2189.89 | 2188.56 | 2189.09 | 4719.0 |
| 2015-06-30 02:00:00 | ES | Futures | 2189.09 | 2191.22 | 2188.03 | 2190.42 | 11204.0 |
| 2015-06-30 02:30:00 | ES | Futures | 2190.69 | 2191.76 | 2189.63 | 2190.42 | 9165.0 |
| 2015-06-30 03:00:00 | ES | Futures | 2190.42 | 2190.96 | 2186.96 | 2189.36 | 21348.0 |
| 2015-06-30 03:30:00 | ES | Futures | 2189.09 | 2192.55 | 2187.23 | 2192.02 | 14348.0 |
| 2015-06-30 04:00:00 | ES | Futures | 2192.02 | 2192.29 | 2188.83 | 2189.63 | 12572.0 |
| 2015-06-30 04:30:00 | ES | Futures | 2189.63 | 2191.22 | 2186.43 | 2190.96 | 22196.0 |
| 2015-06-30 05:00:00 | ES | Futures | 2190.96 | 2203.47 | 2190.16 | 2200.81 | 59748.0 |
| 2015-06-30 05:30:00 | ES | Futures | 2200.81 | 2202.14 | 2196.55 | 2198.68 | 17452.0 |
| 2015-06-30 06:00:00 | ES | Futures | 2198.41 | 2201.61 | 2196.28 | 2196.55 | 26495.0 |
| 2015-06-30 06:30:00 | ES | Futures | 2196.55 | 2199.48 | 2193.09 | 2195.75 | 25622.0 |
| 2015-06-30 07:00:00 | ES | Futures | 2196.02 | 2197.08 | 2193.35 | 2193.89 | 16818.0 |
| 2015-06-30 07:30:00 | ES | Futures | 2194.15 | 2198.41 | 2193.62 | 2197.08 | 18090.0 |
| 2015-06-30 08:00:00 | ES | Futures | 2197.35 | 2201.87 | 2197.35 | 2198.15 | 35098.0 |
| 2015-06-30 08:30:00 | ES | Futures | 2198.15 | 2200.54 | 2197.08 | 2200.01 | 20490.0 |
| 2015-06-30 09:00:00 | ES | Futures | 2200.01 | 2202.94 | 2197.08 | 2201.34 | 49770.0 |
| 2015-06-30 09:30:00 | ES | Futures | 2201.34 | 2201.87 | 2189.36 | 2189.36 | 213376.0 |
| 2015-06-30 10:00:00 | ES | Futures | 2189.36 | 2192.55 | 2186.7 | 2192.02 | 150352.0 |
| 2015-06-30 10:30:00 | ES | Futures | 2191.76 | 2192.02 | 2184.03 | 2189.63 | 136890.0 |
| 2015-06-30 11:00:00 | ES | Futures | 2189.63 | 2193.35 | 2188.03 | 2188.03 | 123348.0 |
| 2015-06-30 11:30:00 | ES | Futures | 2188.03 | 2189.63 | 2184.83 | 2185.37 | 116670.0 |
| 2015-06-30 12:00:00 | ES | Futures | 2185.1 | 2188.56 | 2180.84 | 2181.64 | 103120.0 |
| 2015-06-30 12:30:00 | ES | Futures | 2181.64 | 2185.37 | 2179.77 | 2185.1 | 106702.0 |
| 2015-06-30 13:00:00 | ES | Futures | 2185.1 | 2188.56 | 2183.77 | 2188.03 | 78637.0 |
| 2015-06-30 13:30:00 | ES | Futures | 2188.03 | 2195.48 | 2187.23 | 2192.82 | 120093.0 |
| 2015-06-30 14:00:00 | ES | Futures | 2192.55 | 2200.28 | 2192.29 | 2194.95 | 134154.0 |
| 2015-06-30 14:30:00 | ES | Futures | 2194.68 | 2197.08 | 2189.89 | 2190.16 | 93132.0 |
| 2015-06-30 15:00:00 | ES | Futures | 2190.16 | 2192.55 | 2186.16 | 2188.03 | 110172.0 |
| 2015-06-30 15:30:00 | ES | Futures | 2188.03 | 2193.62 | 2185.9 | 2186.7 | 292829.0 |
| 2015-06-30 16:00:00 | ES | Futures | 2186.7 | 2188.56 | 2182.97 | 2188.03 | 148403.0 |
| 2015-06-30 16:30:00 | ES | Futures | 2188.03 | 2190.69 | 2187.76 | 2190.42 | 16445.0 |
| 2015-06-30 17:00:00 | ES | Futures | 2190.42 | 2190.42 | 2187.76 | 2188.56 | 4201.0 |
| 2015-06-30 20:30:00 | ES | Futures | 2188.03 | 2191.76 | 2188.03 | 2190.16 | 6312.0 |
| 2015-06-30 21:00:00 | ES | Futures | 2190.16 | 2192.55 | 2189.89 | 2191.76 | 4254.0 |
| 2015-06-30 21:30:00 | ES | Futures | 2192.02 | 2196.55 | 2191.76 | 2194.68 | 7473.0 |
| 2015-06-30 22:00:00 | ES | Futures | 2194.68 | 2197.35 | 2194.42 | 2196.28 | 4755.0 |
| 2015-06-30 22:30:00 | ES | Futures | 2196.55 | 2196.55 | 2194.95 | 2195.48 | 1097.0 |
| 2015-06-30 23:00:00 | ES | Futures | 2195.48 | 2195.48 | 2194.42 | 2194.68 | 1260.0 |
| 2015-06-30 23:30:00 | ES | Futures | 2194.42 | 2196.28 | 2194.15 | 2195.22 | 1497.0 |
| 2015-06-30 00:00:00 | NQ | Futures | 5193.47 | 5194.06 | 5191.99 | 5193.47 | 304.0 |
| 2015-06-30 00:30:00 | NQ | Futures | 5193.47 | 5194.06 | 5192.29 | 5192.29 | 214.0 |
| 2015-06-30 01:00:00 | NQ | Futures | 5191.99 | 5193.17 | 5191.1 | 5191.99 | 277.0 |
| 2015-06-30 01:30:00 | NQ | Futures | 5191.99 | 5193.47 | 5191.4 | 5192.58 | 277.0 |
| 2015-06-30 02:00:00 | NQ | Futures | 5191.99 | 5195.84 | 5189.92 | 5193.47 | 929.0 |
| 2015-06-30 02:30:00 | NQ | Futures | 5194.06 | 5196.13 | 5191.1 | 5191.99 | 835.0 |
| 2015-06-30 03:00:00 | NQ | Futures | 5192.29 | 5193.77 | 5186.08 | 5191.1 | 2327.0 |
| 2015-06-30 03:30:00 | NQ | Futures | 5191.1 | 5195.54 | 5184.89 | 5194.65 | 2066.0 |
> showing 50 of 2,755 rows — these rows as CSV