PREVIEW / futures_30min / 2015-12-03
file: by_date/futures_30min/2015/2015-12-03.parquet size: 89 KB rows: 3,054
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-12-03 00:00:00 | ES | Futures | 2231.86 | 2231.86 | 2229.98 | 2231.05 | 2621.0 |
| 2015-12-03 00:30:00 | ES | Futures | 2231.32 | 2232.12 | 2230.52 | 2231.59 | 1806.0 |
| 2015-12-03 01:00:00 | ES | Futures | 2231.59 | 2232.12 | 2230.52 | 2231.05 | 1395.0 |
| 2015-12-03 01:30:00 | ES | Futures | 2231.05 | 2231.59 | 2229.98 | 2230.52 | 1274.0 |
| 2015-12-03 02:00:00 | ES | Futures | 2230.25 | 2231.32 | 2228.91 | 2229.72 | 4839.0 |
| 2015-12-03 02:30:00 | ES | Futures | 2229.45 | 2231.05 | 2228.11 | 2231.05 | 4238.0 |
| 2015-12-03 03:00:00 | ES | Futures | 2231.32 | 2236.67 | 2231.05 | 2236.41 | 13553.0 |
| 2015-12-03 03:30:00 | ES | Futures | 2236.67 | 2237.21 | 2235.07 | 2236.41 | 10110.0 |
| 2015-12-03 04:00:00 | ES | Futures | 2236.14 | 2236.67 | 2233.46 | 2234.8 | 9136.0 |
| 2015-12-03 04:30:00 | ES | Futures | 2234.8 | 2240.42 | 2234.53 | 2239.08 | 13481.0 |
| 2015-12-03 05:00:00 | ES | Futures | 2239.35 | 2242.56 | 2238.28 | 2242.02 | 11759.0 |
| 2015-12-03 05:30:00 | ES | Futures | 2242.02 | 2242.56 | 2241.22 | 2242.29 | 7435.0 |
| 2015-12-03 06:00:00 | ES | Futures | 2242.29 | 2242.29 | 2239.88 | 2240.95 | 7237.0 |
| 2015-12-03 06:30:00 | ES | Futures | 2240.95 | 2241.49 | 2239.88 | 2240.15 | 6038.0 |
| 2015-12-03 07:00:00 | ES | Futures | 2240.15 | 2240.42 | 2237.48 | 2238.81 | 8461.0 |
| 2015-12-03 07:30:00 | ES | Futures | 2239.08 | 2240.42 | 2230.25 | 2234.8 | 55929.0 |
| 2015-12-03 08:00:00 | ES | Futures | 2235.07 | 2235.34 | 2230.79 | 2234.0 | 33297.0 |
| 2015-12-03 08:30:00 | ES | Futures | 2234.53 | 2237.48 | 2217.68 | 2228.38 | 143777.0 |
| 2015-12-03 09:00:00 | ES | Futures | 2228.38 | 2234.26 | 2227.31 | 2227.58 | 71166.0 |
| 2015-12-03 09:30:00 | ES | Futures | 2227.84 | 2231.05 | 2217.94 | 2219.82 | 237776.0 |
| 2015-12-03 10:00:00 | ES | Futures | 2219.55 | 2219.82 | 2210.45 | 2213.66 | 206591.0 |
| 2015-12-03 10:30:00 | ES | Futures | 2213.39 | 2218.75 | 2210.72 | 2215.8 | 161761.0 |
| 2015-12-03 11:00:00 | ES | Futures | 2215.8 | 2222.49 | 2214.73 | 2220.35 | 126414.0 |
| 2015-12-03 11:30:00 | ES | Futures | 2220.35 | 2220.89 | 2213.13 | 2215.53 | 101597.0 |
| 2015-12-03 12:00:00 | ES | Futures | 2215.53 | 2216.34 | 2201.62 | 2204.03 | 148861.0 |
| 2015-12-03 12:30:00 | ES | Futures | 2204.03 | 2208.31 | 2201.89 | 2203.23 | 122891.0 |
| 2015-12-03 13:00:00 | ES | Futures | 2203.23 | 2208.31 | 2200.55 | 2206.7 | 102920.0 |
| 2015-12-03 13:30:00 | ES | Futures | 2206.7 | 2207.24 | 2195.2 | 2195.47 | 107622.0 |
| 2015-12-03 14:00:00 | ES | Futures | 2195.47 | 2196.27 | 2189.31 | 2190.11 | 147314.0 |
| 2015-12-03 14:30:00 | ES | Futures | 2190.11 | 2192.26 | 2183.43 | 2191.99 | 184278.0 |
| 2015-12-03 15:00:00 | ES | Futures | 2191.99 | 2193.33 | 2185.3 | 2186.9 | 143926.0 |
| 2015-12-03 15:30:00 | ES | Futures | 2186.9 | 2194.4 | 2183.96 | 2192.79 | 263889.0 |
| 2015-12-03 16:00:00 | ES | Futures | 2192.79 | 2197.61 | 2191.72 | 2195.47 | 102338.0 |
| 2015-12-03 16:30:00 | ES | Futures | 2196.0 | 2198.94 | 2195.73 | 2197.87 | 9416.0 |
| 2015-12-03 17:00:00 | ES | Futures | 2198.14 | 2198.14 | 2197.87 | 2197.87 | 14.0 |
| 2015-12-03 18:00:00 | ES | Futures | 2197.61 | 2201.35 | 2197.61 | 2199.48 | 5154.0 |
| 2015-12-03 18:30:00 | ES | Futures | 2199.48 | 2202.42 | 2196.8 | 2197.34 | 5055.0 |
| 2015-12-03 19:00:00 | ES | Futures | 2197.34 | 2200.82 | 2197.34 | 2200.02 | 4858.0 |
| 2015-12-03 19:30:00 | ES | Futures | 2199.75 | 2201.62 | 2198.14 | 2201.35 | 3692.0 |
| 2015-12-03 20:00:00 | ES | Futures | 2201.35 | 2202.16 | 2200.55 | 2201.09 | 3646.0 |
| 2015-12-03 20:30:00 | ES | Futures | 2201.09 | 2202.16 | 2198.94 | 2200.28 | 2717.0 |
| 2015-12-03 21:00:00 | ES | Futures | 2200.02 | 2200.82 | 2198.94 | 2200.02 | 1461.0 |
| 2015-12-03 21:30:00 | ES | Futures | 2200.02 | 2200.55 | 2198.14 | 2198.68 | 1867.0 |
| 2015-12-03 22:00:00 | ES | Futures | 2198.68 | 2200.28 | 2198.14 | 2200.02 | 1718.0 |
| 2015-12-03 22:30:00 | ES | Futures | 2200.02 | 2201.62 | 2198.94 | 2199.21 | 2332.0 |
| 2015-12-03 23:00:00 | ES | Futures | 2199.21 | 2199.75 | 2197.87 | 2199.48 | 1765.0 |
| 2015-12-03 23:30:00 | ES | Futures | 2199.75 | 2200.82 | 2199.48 | 2200.55 | 1389.0 |
| 2015-12-03 00:00:00 | NQ | Futures | 5580.26 | 5580.55 | 5576.11 | 5579.07 | 547.0 |
| 2015-12-03 00:30:00 | NQ | Futures | 5579.37 | 5581.44 | 5577.29 | 5580.26 | 251.0 |
| 2015-12-03 01:00:00 | NQ | Futures | 5580.55 | 5581.15 | 5577.29 | 5578.78 | 187.0 |
> showing 50 of 3,054 rows — these rows as CSV