PREVIEW / futures_5min / 2016-07-05
file: by_date/futures_5min/2016/2016-07-05.parquet size: 280 KB rows: 15,163
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 |
|---|---|---|---|---|---|---|---|
| 2016-07-05 00:00:00 | ES | Futures | 2270.1 | 2270.64 | 2269.83 | 2270.37 | 515.0 |
| 2016-07-05 00:05:00 | ES | Futures | 2270.37 | 2270.64 | 2270.37 | 2270.37 | 132.0 |
| 2016-07-05 00:10:00 | ES | Futures | 2270.37 | 2270.37 | 2269.02 | 2269.56 | 1052.0 |
| 2016-07-05 00:15:00 | ES | Futures | 2269.56 | 2269.83 | 2269.29 | 2269.56 | 180.0 |
| 2016-07-05 00:20:00 | ES | Futures | 2269.29 | 2269.83 | 2269.29 | 2269.56 | 89.0 |
| 2016-07-05 00:25:00 | ES | Futures | 2269.56 | 2269.83 | 2269.29 | 2269.29 | 99.0 |
| 2016-07-05 00:30:00 | ES | Futures | 2269.29 | 2269.56 | 2269.02 | 2269.56 | 150.0 |
| 2016-07-05 00:35:00 | ES | Futures | 2269.83 | 2269.83 | 2268.75 | 2269.02 | 268.0 |
| 2016-07-05 00:40:00 | ES | Futures | 2269.02 | 2269.02 | 2268.47 | 2268.75 | 282.0 |
| 2016-07-05 00:45:00 | ES | Futures | 2268.75 | 2269.02 | 2268.47 | 2268.47 | 451.0 |
| 2016-07-05 00:50:00 | ES | Futures | 2268.75 | 2269.02 | 2268.47 | 2268.75 | 51.0 |
| 2016-07-05 00:55:00 | ES | Futures | 2268.47 | 2269.02 | 2268.47 | 2269.02 | 356.0 |
| 2016-07-05 01:00:00 | ES | Futures | 2268.75 | 2269.83 | 2268.75 | 2269.29 | 317.0 |
| 2016-07-05 01:05:00 | ES | Futures | 2269.56 | 2269.83 | 2269.02 | 2269.83 | 259.0 |
| 2016-07-05 01:10:00 | ES | Futures | 2269.56 | 2270.1 | 2269.29 | 2269.29 | 466.0 |
| 2016-07-05 01:15:00 | ES | Futures | 2269.29 | 2270.1 | 2269.29 | 2270.1 | 178.0 |
| 2016-07-05 01:20:00 | ES | Futures | 2270.1 | 2270.37 | 2269.83 | 2270.1 | 113.0 |
| 2016-07-05 01:25:00 | ES | Futures | 2270.1 | 2270.37 | 2269.83 | 2269.83 | 202.0 |
| 2016-07-05 01:30:00 | ES | Futures | 2270.1 | 2270.1 | 2269.56 | 2270.1 | 177.0 |
| 2016-07-05 01:35:00 | ES | Futures | 2270.1 | 2270.37 | 2270.1 | 2270.37 | 465.0 |
| 2016-07-05 01:40:00 | ES | Futures | 2270.37 | 2270.37 | 2270.1 | 2270.1 | 100.0 |
| 2016-07-05 01:45:00 | ES | Futures | 2270.1 | 2270.37 | 2269.83 | 2270.37 | 717.0 |
| 2016-07-05 01:50:00 | ES | Futures | 2270.37 | 2270.64 | 2270.1 | 2270.64 | 306.0 |
| 2016-07-05 01:55:00 | ES | Futures | 2270.64 | 2270.64 | 2270.1 | 2270.1 | 263.0 |
| 2016-07-05 02:00:00 | ES | Futures | 2270.37 | 2270.64 | 2269.83 | 2270.37 | 725.0 |
| 2016-07-05 02:05:00 | ES | Futures | 2270.37 | 2270.37 | 2268.75 | 2269.02 | 802.0 |
| 2016-07-05 02:10:00 | ES | Futures | 2269.29 | 2269.56 | 2268.75 | 2268.75 | 897.0 |
| 2016-07-05 02:15:00 | ES | Futures | 2268.75 | 2269.02 | 2268.75 | 2268.75 | 258.0 |
| 2016-07-05 02:20:00 | ES | Futures | 2269.02 | 2269.02 | 2268.47 | 2268.75 | 588.0 |
| 2016-07-05 02:25:00 | ES | Futures | 2268.75 | 2269.83 | 2268.75 | 2269.29 | 601.0 |
| 2016-07-05 02:30:00 | ES | Futures | 2269.29 | 2269.83 | 2269.02 | 2269.83 | 640.0 |
| 2016-07-05 02:35:00 | ES | Futures | 2269.83 | 2269.83 | 2268.2 | 2268.75 | 1045.0 |
| 2016-07-05 02:40:00 | ES | Futures | 2268.47 | 2268.75 | 2265.76 | 2265.76 | 4761.0 |
| 2016-07-05 02:45:00 | ES | Futures | 2266.03 | 2266.58 | 2264.95 | 2266.03 | 1698.0 |
| 2016-07-05 02:50:00 | ES | Futures | 2266.03 | 2266.3 | 2264.95 | 2265.76 | 1734.0 |
| 2016-07-05 02:55:00 | ES | Futures | 2265.49 | 2266.03 | 2264.68 | 2264.68 | 1978.0 |
| 2016-07-05 03:00:00 | ES | Futures | 2264.95 | 2267.12 | 2264.68 | 2266.58 | 6109.0 |
| 2016-07-05 03:05:00 | ES | Futures | 2266.85 | 2266.85 | 2264.14 | 2264.68 | 5105.0 |
| 2016-07-05 03:10:00 | ES | Futures | 2264.68 | 2264.68 | 2261.97 | 2262.78 | 7132.0 |
| 2016-07-05 03:15:00 | ES | Futures | 2262.78 | 2264.14 | 2261.15 | 2261.42 | 5295.0 |
| 2016-07-05 03:20:00 | ES | Futures | 2261.42 | 2263.32 | 2261.15 | 2263.32 | 4319.0 |
| 2016-07-05 03:25:00 | ES | Futures | 2263.32 | 2264.41 | 2262.24 | 2264.41 | 3205.0 |
| 2016-07-05 03:30:00 | ES | Futures | 2264.14 | 2265.22 | 2263.32 | 2263.86 | 3806.0 |
| 2016-07-05 03:35:00 | ES | Futures | 2263.59 | 2263.86 | 2260.88 | 2262.24 | 4347.0 |
| 2016-07-05 03:40:00 | ES | Futures | 2262.24 | 2263.32 | 2261.69 | 2263.05 | 1930.0 |
| 2016-07-05 03:45:00 | ES | Futures | 2263.32 | 2264.14 | 2262.78 | 2263.32 | 2575.0 |
| 2016-07-05 03:50:00 | ES | Futures | 2263.32 | 2263.32 | 2261.69 | 2262.24 | 2819.0 |
| 2016-07-05 03:55:00 | ES | Futures | 2261.97 | 2262.51 | 2261.15 | 2261.15 | 2054.0 |
| 2016-07-05 04:00:00 | ES | Futures | 2261.42 | 2261.97 | 2260.61 | 2260.88 | 2472.0 |
| 2016-07-05 04:05:00 | ES | Futures | 2260.88 | 2262.51 | 2260.61 | 2261.69 | 2347.0 |
> showing 50 of 15,163 rows — these rows as CSV