PREVIEW / futures_30min / 2017-03-13
file: by_date/futures_30min/2017/2017-03-13.parquet size: 77 KB rows: 3,012
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-13 00:00:00 | ES | Futures | 2586.12 | 2586.4 | 2585.85 | 2586.12 | 202.0 |
| 2017-03-13 00:30:00 | ES | Futures | 2585.85 | 2586.12 | 2585.85 | 2585.85 | 315.0 |
| 2017-03-13 01:00:00 | ES | Futures | 2585.85 | 2586.4 | 2585.85 | 2586.4 | 323.0 |
| 2017-03-13 01:30:00 | ES | Futures | 2586.4 | 2586.67 | 2586.12 | 2586.4 | 439.0 |
| 2017-03-13 02:00:00 | ES | Futures | 2586.4 | 2586.67 | 2586.12 | 2586.67 | 357.0 |
| 2017-03-13 02:30:00 | ES | Futures | 2586.94 | 2588.03 | 2586.67 | 2587.49 | 487.0 |
| 2017-03-13 03:00:00 | ES | Futures | 2587.49 | 2588.03 | 2586.4 | 2586.94 | 1565.0 |
| 2017-03-13 03:30:00 | ES | Futures | 2586.94 | 2587.76 | 2586.67 | 2586.94 | 834.0 |
| 2017-03-13 04:00:00 | ES | Futures | 2586.94 | 2587.49 | 2585.3 | 2585.58 | 1669.0 |
| 2017-03-13 04:30:00 | ES | Futures | 2585.58 | 2588.03 | 2585.58 | 2586.94 | 1962.0 |
| 2017-03-13 05:00:00 | ES | Futures | 2586.94 | 2587.49 | 2585.3 | 2585.85 | 1442.0 |
| 2017-03-13 05:30:00 | ES | Futures | 2585.85 | 2586.12 | 2584.76 | 2585.58 | 992.0 |
| 2017-03-13 06:00:00 | ES | Futures | 2585.58 | 2586.12 | 2584.49 | 2585.58 | 1580.0 |
| 2017-03-13 06:30:00 | ES | Futures | 2585.58 | 2585.85 | 2585.03 | 2585.3 | 724.0 |
| 2017-03-13 07:00:00 | ES | Futures | 2585.58 | 2586.12 | 2584.21 | 2585.85 | 1228.0 |
| 2017-03-13 07:30:00 | ES | Futures | 2585.58 | 2587.49 | 2585.58 | 2586.67 | 3741.0 |
| 2017-03-13 08:00:00 | ES | Futures | 2586.67 | 2589.67 | 2586.4 | 2588.58 | 3939.0 |
| 2017-03-13 08:30:00 | ES | Futures | 2588.58 | 2590.21 | 2587.49 | 2588.58 | 4572.0 |
| 2017-03-13 09:00:00 | ES | Futures | 2588.58 | 2589.12 | 2587.49 | 2588.58 | 5106.0 |
| 2017-03-13 09:30:00 | ES | Futures | 2588.85 | 2591.3 | 2586.67 | 2586.67 | 19206.0 |
| 2017-03-13 10:00:00 | ES | Futures | 2586.94 | 2589.4 | 2586.12 | 2587.76 | 19178.0 |
| 2017-03-13 10:30:00 | ES | Futures | 2588.03 | 2588.85 | 2586.12 | 2587.21 | 15305.0 |
| 2017-03-13 11:00:00 | ES | Futures | 2587.49 | 2587.49 | 2584.76 | 2585.58 | 11524.0 |
| 2017-03-13 11:30:00 | ES | Futures | 2585.58 | 2588.85 | 2584.76 | 2588.85 | 12926.0 |
| 2017-03-13 12:00:00 | ES | Futures | 2588.85 | 2589.4 | 2585.85 | 2586.4 | 12270.0 |
| 2017-03-13 12:30:00 | ES | Futures | 2586.4 | 2588.03 | 2585.85 | 2587.49 | 7539.0 |
| 2017-03-13 13:00:00 | ES | Futures | 2587.76 | 2588.3 | 2586.4 | 2586.94 | 8554.0 |
| 2017-03-13 13:30:00 | ES | Futures | 2586.94 | 2587.21 | 2585.58 | 2586.94 | 4861.0 |
| 2017-03-13 14:00:00 | ES | Futures | 2587.21 | 2588.58 | 2586.12 | 2587.76 | 6071.0 |
| 2017-03-13 14:30:00 | ES | Futures | 2588.03 | 2589.12 | 2587.49 | 2589.12 | 6095.0 |
| 2017-03-13 15:00:00 | ES | Futures | 2589.12 | 2589.94 | 2588.03 | 2588.85 | 8237.0 |
| 2017-03-13 15:30:00 | ES | Futures | 2588.85 | 2591.3 | 2588.3 | 2590.21 | 30128.0 |
| 2017-03-13 16:00:00 | ES | Futures | 2590.21 | 2591.58 | 2589.67 | 2591.58 | 12022.0 |
| 2017-03-13 16:30:00 | ES | Futures | 2591.03 | 2591.3 | 2589.94 | 2590.76 | 2623.0 |
| 2017-03-13 18:00:00 | ES | Futures | 2590.21 | 2591.03 | 2589.67 | 2590.76 | 644.0 |
| 2017-03-13 18:30:00 | ES | Futures | 2590.49 | 2590.76 | 2590.21 | 2590.21 | 140.0 |
| 2017-03-13 19:00:00 | ES | Futures | 2590.21 | 2590.49 | 2589.94 | 2589.94 | 131.0 |
| 2017-03-13 19:30:00 | ES | Futures | 2589.94 | 2590.21 | 2589.67 | 2589.94 | 246.0 |
| 2017-03-13 20:00:00 | ES | Futures | 2589.94 | 2589.94 | 2588.85 | 2589.12 | 463.0 |
| 2017-03-13 20:30:00 | ES | Futures | 2589.4 | 2589.67 | 2588.58 | 2589.12 | 366.0 |
| 2017-03-13 21:00:00 | ES | Futures | 2589.12 | 2589.4 | 2588.3 | 2588.58 | 538.0 |
| 2017-03-13 21:30:00 | ES | Futures | 2588.58 | 2589.12 | 2587.76 | 2588.85 | 768.0 |
| 2017-03-13 22:00:00 | ES | Futures | 2588.58 | 2588.85 | 2588.3 | 2588.85 | 62.0 |
| 2017-03-13 22:30:00 | ES | Futures | 2588.85 | 2589.12 | 2588.58 | 2588.85 | 178.0 |
| 2017-03-13 23:00:00 | ES | Futures | 2588.85 | 2589.67 | 2588.85 | 2589.4 | 383.0 |
| 2017-03-13 23:30:00 | ES | Futures | 2589.4 | 2589.67 | 2589.12 | 2589.4 | 285.0 |
| 2017-03-13 00:00:00 | NQ | Futures | 6419.54 | 6420.44 | 6419.25 | 6419.54 | 64.0 |
| 2017-03-13 00:30:00 | NQ | Futures | 6419.25 | 6419.54 | 6418.35 | 6418.95 | 75.0 |
| 2017-03-13 01:00:00 | NQ | Futures | 6419.25 | 6420.44 | 6419.25 | 6420.44 | 34.0 |
| 2017-03-13 01:30:00 | NQ | Futures | 6420.44 | 6420.74 | 6419.54 | 6420.14 | 36.0 |
> showing 50 of 3,012 rows — these rows as CSV