PREVIEW / futures_30min / 2014-08-27
file: by_date/futures_30min/2014/2014-08-27.parquet size: 69 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-08-27 00:00:00 | ES | Futures | 2083.35 | 2083.61 | 2082.83 | 2082.83 | 1441.0 |
| 2014-08-27 00:30:00 | ES | Futures | 2082.83 | 2083.35 | 2082.83 | 2083.09 | 829.0 |
| 2014-08-27 01:00:00 | ES | Futures | 2083.35 | 2084.13 | 2083.35 | 2084.13 | 1622.0 |
| 2014-08-27 01:30:00 | ES | Futures | 2083.87 | 2084.39 | 2083.87 | 2083.87 | 790.0 |
| 2014-08-27 02:00:00 | ES | Futures | 2083.87 | 2084.13 | 2083.61 | 2083.87 | 1676.0 |
| 2014-08-27 02:30:00 | ES | Futures | 2083.61 | 2084.13 | 2083.35 | 2083.61 | 3285.0 |
| 2014-08-27 03:00:00 | ES | Futures | 2083.61 | 2085.43 | 2083.61 | 2084.13 | 10631.0 |
| 2014-08-27 03:30:00 | ES | Futures | 2084.13 | 2084.39 | 2083.09 | 2083.61 | 5751.0 |
| 2014-08-27 04:00:00 | ES | Futures | 2083.35 | 2084.65 | 2083.09 | 2084.65 | 5849.0 |
| 2014-08-27 04:30:00 | ES | Futures | 2084.65 | 2084.91 | 2084.13 | 2084.39 | 3967.0 |
| 2014-08-27 05:00:00 | ES | Futures | 2084.39 | 2084.91 | 2084.13 | 2084.65 | 4199.0 |
| 2014-08-27 05:30:00 | ES | Futures | 2084.65 | 2085.43 | 2084.39 | 2084.39 | 5038.0 |
| 2014-08-27 06:00:00 | ES | Futures | 2084.39 | 2084.91 | 2084.13 | 2084.65 | 3123.0 |
| 2014-08-27 06:30:00 | ES | Futures | 2084.65 | 2084.91 | 2083.87 | 2084.65 | 5766.0 |
| 2014-08-27 07:00:00 | ES | Futures | 2084.65 | 2085.43 | 2083.87 | 2084.91 | 4598.0 |
| 2014-08-27 07:30:00 | ES | Futures | 2084.91 | 2084.91 | 2083.35 | 2083.35 | 5962.0 |
| 2014-08-27 08:00:00 | ES | Futures | 2083.35 | 2084.39 | 2083.09 | 2083.87 | 5859.0 |
| 2014-08-27 08:30:00 | ES | Futures | 2084.13 | 2084.13 | 2081.78 | 2082.31 | 9850.0 |
| 2014-08-27 09:00:00 | ES | Futures | 2082.31 | 2084.39 | 2082.31 | 2083.61 | 18897.0 |
| 2014-08-27 09:30:00 | ES | Futures | 2083.61 | 2084.91 | 2080.48 | 2081.0 | 114951.0 |
| 2014-08-27 10:00:00 | ES | Futures | 2080.74 | 2082.05 | 2079.44 | 2080.22 | 75607.0 |
| 2014-08-27 10:30:00 | ES | Futures | 2080.48 | 2083.09 | 2079.96 | 2082.83 | 53295.0 |
| 2014-08-27 11:00:00 | ES | Futures | 2082.83 | 2084.39 | 2082.57 | 2082.83 | 54648.0 |
| 2014-08-27 11:30:00 | ES | Futures | 2082.83 | 2083.61 | 2081.78 | 2083.09 | 38225.0 |
| 2014-08-27 12:00:00 | ES | Futures | 2083.09 | 2083.35 | 2081.0 | 2082.05 | 24157.0 |
| 2014-08-27 12:30:00 | ES | Futures | 2082.05 | 2083.09 | 2081.78 | 2082.83 | 14925.0 |
| 2014-08-27 13:00:00 | ES | Futures | 2082.83 | 2082.83 | 2082.31 | 2082.57 | 10445.0 |
| 2014-08-27 13:30:00 | ES | Futures | 2082.83 | 2082.83 | 2082.05 | 2082.57 | 12308.0 |
| 2014-08-27 14:00:00 | ES | Futures | 2082.31 | 2082.83 | 2082.05 | 2082.31 | 16250.0 |
| 2014-08-27 14:30:00 | ES | Futures | 2082.31 | 2082.57 | 2078.92 | 2079.18 | 41654.0 |
| 2014-08-27 15:00:00 | ES | Futures | 2078.92 | 2080.74 | 2078.14 | 2080.48 | 43004.0 |
| 2014-08-27 15:30:00 | ES | Futures | 2080.48 | 2082.31 | 2079.96 | 2081.52 | 74282.0 |
| 2014-08-27 16:00:00 | ES | Futures | 2081.78 | 2082.31 | 2081.52 | 2082.05 | 60174.0 |
| 2014-08-27 16:30:00 | ES | Futures | 2082.05 | 2082.05 | 2081.52 | 2081.78 | 8891.0 |
| 2014-08-27 17:00:00 | ES | Futures | 2081.52 | 2081.78 | 2081.26 | 2081.78 | 2004.0 |
| 2014-08-27 18:00:00 | ES | Futures | 2081.52 | 2081.52 | 2081.0 | 2081.52 | 1352.0 |
| 2014-08-27 18:30:00 | ES | Futures | 2081.26 | 2081.52 | 2081.26 | 2081.26 | 405.0 |
| 2014-08-27 19:00:00 | ES | Futures | 2081.26 | 2081.52 | 2081.0 | 2081.26 | 374.0 |
| 2014-08-27 19:30:00 | ES | Futures | 2081.26 | 2081.78 | 2081.26 | 2081.52 | 614.0 |
| 2014-08-27 20:00:00 | ES | Futures | 2081.52 | 2081.78 | 2081.0 | 2081.0 | 1269.0 |
| 2014-08-27 20:30:00 | ES | Futures | 2081.0 | 2081.26 | 2080.74 | 2081.0 | 1466.0 |
| 2014-08-27 21:00:00 | ES | Futures | 2081.26 | 2082.05 | 2081.26 | 2081.78 | 1601.0 |
| 2014-08-27 21:30:00 | ES | Futures | 2082.05 | 2082.31 | 2081.52 | 2081.78 | 821.0 |
| 2014-08-27 22:00:00 | ES | Futures | 2081.78 | 2082.05 | 2081.52 | 2081.78 | 589.0 |
| 2014-08-27 22:30:00 | ES | Futures | 2081.78 | 2081.78 | 2081.26 | 2081.26 | 285.0 |
| 2014-08-27 23:00:00 | ES | Futures | 2081.52 | 2081.78 | 2081.26 | 2081.26 | 731.0 |
| 2014-08-27 23:30:00 | ES | Futures | 2081.52 | 2081.52 | 2081.0 | 2081.26 | 880.0 |
| 2014-08-27 00:00:00 | NQ | Futures | 4758.09 | 4758.09 | 4756.34 | 4756.34 | 164.0 |
| 2014-08-27 00:30:00 | NQ | Futures | 4756.04 | 4757.5 | 4756.04 | 4757.5 | 68.0 |
| 2014-08-27 01:00:00 | NQ | Futures | 4757.5 | 4759.26 | 4757.5 | 4758.96 | 157.0 |
> showing 50 of 2,777 rows — these rows as CSV