PREVIEW / futures_30min / 2015-07-07
file: by_date/futures_30min/2015/2015-07-07.parquet size: 89 KB rows: 2,969
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-07-07 00:00:00 | ES | Futures | 2204.54 | 2205.07 | 2204.27 | 2205.07 | 1098.0 |
| 2015-07-07 00:30:00 | ES | Futures | 2205.07 | 2206.4 | 2204.8 | 2206.13 | 2181.0 |
| 2015-07-07 01:00:00 | ES | Futures | 2205.87 | 2210.66 | 2205.6 | 2210.66 | 7308.0 |
| 2015-07-07 01:30:00 | ES | Futures | 2210.66 | 2211.99 | 2208.53 | 2208.53 | 5776.0 |
| 2015-07-07 02:00:00 | ES | Futures | 2208.53 | 2211.46 | 2207.2 | 2210.13 | 8761.0 |
| 2015-07-07 02:30:00 | ES | Futures | 2210.39 | 2210.66 | 2208.8 | 2210.13 | 4226.0 |
| 2015-07-07 03:00:00 | ES | Futures | 2210.13 | 2213.06 | 2208.26 | 2212.52 | 15515.0 |
| 2015-07-07 03:30:00 | ES | Futures | 2212.52 | 2212.52 | 2210.13 | 2211.46 | 10281.0 |
| 2015-07-07 04:00:00 | ES | Futures | 2211.46 | 2211.99 | 2210.39 | 2211.46 | 8648.0 |
| 2015-07-07 04:30:00 | ES | Futures | 2211.46 | 2211.99 | 2208.0 | 2209.59 | 18230.0 |
| 2015-07-07 05:00:00 | ES | Futures | 2209.59 | 2210.93 | 2208.0 | 2208.26 | 7695.0 |
| 2015-07-07 05:30:00 | ES | Futures | 2208.26 | 2209.86 | 2207.2 | 2208.8 | 7511.0 |
| 2015-07-07 06:00:00 | ES | Futures | 2208.53 | 2208.8 | 2206.4 | 2207.46 | 8962.0 |
| 2015-07-07 06:30:00 | ES | Futures | 2207.2 | 2207.46 | 2204.8 | 2204.8 | 9187.0 |
| 2015-07-07 07:00:00 | ES | Futures | 2205.07 | 2205.07 | 2201.07 | 2203.74 | 32223.0 |
| 2015-07-07 07:30:00 | ES | Futures | 2203.74 | 2205.33 | 2200.81 | 2203.2 | 22455.0 |
| 2015-07-07 08:00:00 | ES | Futures | 2202.94 | 2204.54 | 2200.54 | 2202.41 | 18744.0 |
| 2015-07-07 08:30:00 | ES | Futures | 2202.41 | 2203.47 | 2201.07 | 2201.34 | 15876.0 |
| 2015-07-07 09:00:00 | ES | Futures | 2201.61 | 2201.61 | 2196.28 | 2197.61 | 35778.0 |
| 2015-07-07 09:30:00 | ES | Futures | 2197.61 | 2198.15 | 2185.9 | 2186.96 | 209138.0 |
| 2015-07-07 10:00:00 | ES | Futures | 2186.96 | 2187.23 | 2177.64 | 2178.71 | 269356.0 |
| 2015-07-07 10:30:00 | ES | Futures | 2178.98 | 2178.98 | 2169.66 | 2175.78 | 295353.0 |
| 2015-07-07 11:00:00 | ES | Futures | 2175.78 | 2177.38 | 2169.92 | 2171.25 | 173053.0 |
| 2015-07-07 11:30:00 | ES | Futures | 2171.52 | 2183.77 | 2167.26 | 2181.37 | 199763.0 |
| 2015-07-07 12:00:00 | ES | Futures | 2181.37 | 2182.7 | 2178.71 | 2181.11 | 97242.0 |
| 2015-07-07 12:30:00 | ES | Futures | 2180.84 | 2193.35 | 2180.57 | 2191.49 | 117300.0 |
| 2015-07-07 13:00:00 | ES | Futures | 2191.49 | 2197.08 | 2187.76 | 2193.62 | 142027.0 |
| 2015-07-07 13:30:00 | ES | Futures | 2193.62 | 2195.48 | 2190.96 | 2192.82 | 77075.0 |
| 2015-07-07 14:00:00 | ES | Futures | 2192.82 | 2194.15 | 2187.23 | 2189.89 | 81180.0 |
| 2015-07-07 14:30:00 | ES | Futures | 2190.16 | 2207.73 | 2189.36 | 2206.93 | 169544.0 |
| 2015-07-07 15:00:00 | ES | Futures | 2206.93 | 2210.13 | 2202.94 | 2208.0 | 164899.0 |
| 2015-07-07 15:30:00 | ES | Futures | 2208.0 | 2210.93 | 2204.0 | 2209.06 | 166391.0 |
| 2015-07-07 16:00:00 | ES | Futures | 2209.33 | 2211.19 | 2207.2 | 2208.0 | 83791.0 |
| 2015-07-07 16:30:00 | ES | Futures | 2208.8 | 2209.59 | 2207.46 | 2208.0 | 9131.0 |
| 2015-07-07 17:00:00 | ES | Futures | 2208.26 | 2209.06 | 2207.46 | 2208.53 | 2748.0 |
| 2015-07-07 18:00:00 | ES | Futures | 2207.73 | 2208.0 | 2204.27 | 2205.33 | 5798.0 |
| 2015-07-07 18:30:00 | ES | Futures | 2205.33 | 2205.87 | 2204.8 | 2205.6 | 1616.0 |
| 2015-07-07 19:00:00 | ES | Futures | 2205.87 | 2205.87 | 2203.2 | 2204.0 | 2642.0 |
| 2015-07-07 19:30:00 | ES | Futures | 2204.0 | 2204.54 | 2203.47 | 2204.0 | 1122.0 |
| 2015-07-07 20:00:00 | ES | Futures | 2204.27 | 2204.54 | 2202.67 | 2203.47 | 2927.0 |
| 2015-07-07 20:30:00 | ES | Futures | 2203.74 | 2204.54 | 2202.94 | 2203.2 | 2475.0 |
| 2015-07-07 21:00:00 | ES | Futures | 2203.2 | 2203.47 | 2196.02 | 2197.35 | 11238.0 |
| 2015-07-07 21:30:00 | ES | Futures | 2197.08 | 2198.15 | 2192.55 | 2195.22 | 13082.0 |
| 2015-07-07 22:00:00 | ES | Futures | 2195.48 | 2198.15 | 2194.42 | 2195.22 | 7371.0 |
| 2015-07-07 22:30:00 | ES | Futures | 2195.22 | 2195.48 | 2190.96 | 2191.76 | 6871.0 |
| 2015-07-07 23:00:00 | ES | Futures | 2191.76 | 2192.82 | 2190.42 | 2192.82 | 4170.0 |
| 2015-07-07 23:30:00 | ES | Futures | 2192.82 | 2192.82 | 2190.42 | 2192.29 | 3939.0 |
| 2015-07-07 00:00:00 | NQ | Futures | 5243.75 | 5244.35 | 5242.57 | 5244.35 | 87.0 |
| 2015-07-07 00:30:00 | NQ | Futures | 5243.75 | 5246.12 | 5243.46 | 5246.12 | 235.0 |
| 2015-07-07 01:00:00 | NQ | Futures | 5245.53 | 5256.47 | 5244.64 | 5256.47 | 1404.0 |
> showing 50 of 2,969 rows — these rows as CSV