PREVIEW / futures_5min / 2013-10-31
file: by_date/futures_5min/2013/2013-10-31.parquet size: 231 KB rows: 14,382
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-31 00:00:00 | ES | Futures | 1810.37 | 1810.37 | 1809.85 | 1810.11 | 213.0 |
| 2013-10-31 00:05:00 | ES | Futures | 1810.11 | 1810.11 | 1809.85 | 1809.85 | 22.0 |
| 2013-10-31 00:10:00 | ES | Futures | 1809.85 | 1810.11 | 1809.85 | 1809.85 | 87.0 |
| 2013-10-31 00:15:00 | ES | Futures | 1809.85 | 1809.85 | 1809.33 | 1809.33 | 261.0 |
| 2013-10-31 00:20:00 | ES | Futures | 1809.59 | 1809.59 | 1809.33 | 1809.59 | 92.0 |
| 2013-10-31 00:25:00 | ES | Futures | 1809.33 | 1809.59 | 1809.33 | 1809.59 | 38.0 |
| 2013-10-31 00:30:00 | ES | Futures | 1809.59 | 1810.62 | 1809.59 | 1810.62 | 629.0 |
| 2013-10-31 00:35:00 | ES | Futures | 1810.62 | 1810.62 | 1810.11 | 1810.11 | 350.0 |
| 2013-10-31 00:40:00 | ES | Futures | 1809.85 | 1810.11 | 1809.85 | 1810.11 | 16.0 |
| 2013-10-31 00:45:00 | ES | Futures | 1809.85 | 1809.85 | 1809.59 | 1809.59 | 187.0 |
| 2013-10-31 00:50:00 | ES | Futures | 1809.59 | 1809.59 | 1809.08 | 1809.33 | 244.0 |
| 2013-10-31 00:55:00 | ES | Futures | 1809.33 | 1809.33 | 1809.08 | 1809.33 | 28.0 |
| 2013-10-31 01:00:00 | ES | Futures | 1809.33 | 1809.59 | 1809.08 | 1809.59 | 348.0 |
| 2013-10-31 01:05:00 | ES | Futures | 1809.59 | 1809.59 | 1809.08 | 1809.08 | 91.0 |
| 2013-10-31 01:10:00 | ES | Futures | 1809.33 | 1809.33 | 1809.08 | 1809.08 | 309.0 |
| 2013-10-31 01:15:00 | ES | Futures | 1809.33 | 1809.33 | 1808.82 | 1809.08 | 156.0 |
| 2013-10-31 01:20:00 | ES | Futures | 1809.08 | 1809.08 | 1808.82 | 1809.08 | 136.0 |
| 2013-10-31 01:25:00 | ES | Futures | 1808.82 | 1809.08 | 1808.56 | 1809.08 | 413.0 |
| 2013-10-31 01:30:00 | ES | Futures | 1808.82 | 1809.08 | 1808.56 | 1808.56 | 458.0 |
| 2013-10-31 01:35:00 | ES | Futures | 1808.82 | 1808.82 | 1808.56 | 1808.82 | 438.0 |
| 2013-10-31 01:40:00 | ES | Futures | 1808.82 | 1808.82 | 1807.79 | 1807.79 | 619.0 |
| 2013-10-31 01:45:00 | ES | Futures | 1807.79 | 1808.04 | 1807.53 | 1807.79 | 615.0 |
| 2013-10-31 01:50:00 | ES | Futures | 1807.79 | 1808.04 | 1807.53 | 1807.79 | 449.0 |
| 2013-10-31 01:55:00 | ES | Futures | 1807.79 | 1808.82 | 1807.79 | 1808.3 | 680.0 |
| 2013-10-31 02:00:00 | ES | Futures | 1808.3 | 1809.08 | 1808.04 | 1809.08 | 466.0 |
| 2013-10-31 02:05:00 | ES | Futures | 1809.08 | 1809.33 | 1808.82 | 1809.08 | 263.0 |
| 2013-10-31 02:10:00 | ES | Futures | 1809.33 | 1809.33 | 1809.08 | 1809.33 | 98.0 |
| 2013-10-31 02:15:00 | ES | Futures | 1809.33 | 1809.33 | 1808.82 | 1809.08 | 269.0 |
| 2013-10-31 02:20:00 | ES | Futures | 1808.82 | 1809.08 | 1808.3 | 1808.56 | 962.0 |
| 2013-10-31 02:25:00 | ES | Futures | 1808.3 | 1808.56 | 1808.3 | 1808.56 | 110.0 |
| 2013-10-31 02:30:00 | ES | Futures | 1808.56 | 1808.82 | 1808.3 | 1808.56 | 157.0 |
| 2013-10-31 02:35:00 | ES | Futures | 1808.82 | 1809.33 | 1808.56 | 1809.08 | 332.0 |
| 2013-10-31 02:40:00 | ES | Futures | 1809.33 | 1809.59 | 1809.08 | 1809.59 | 236.0 |
| 2013-10-31 02:45:00 | ES | Futures | 1809.59 | 1810.11 | 1809.33 | 1810.11 | 362.0 |
| 2013-10-31 02:50:00 | ES | Futures | 1810.11 | 1810.62 | 1809.85 | 1810.37 | 644.0 |
| 2013-10-31 02:55:00 | ES | Futures | 1810.37 | 1810.62 | 1810.37 | 1810.37 | 286.0 |
| 2013-10-31 03:00:00 | ES | Futures | 1810.37 | 1811.14 | 1810.11 | 1810.62 | 1390.0 |
| 2013-10-31 03:05:00 | ES | Futures | 1810.37 | 1810.88 | 1810.37 | 1810.62 | 362.0 |
| 2013-10-31 03:10:00 | ES | Futures | 1810.62 | 1810.62 | 1810.11 | 1810.37 | 365.0 |
| 2013-10-31 03:15:00 | ES | Futures | 1810.37 | 1810.62 | 1810.37 | 1810.37 | 93.0 |
| 2013-10-31 03:20:00 | ES | Futures | 1810.37 | 1810.62 | 1810.11 | 1810.11 | 202.0 |
| 2013-10-31 03:25:00 | ES | Futures | 1810.11 | 1810.37 | 1809.85 | 1809.85 | 322.0 |
| 2013-10-31 03:30:00 | ES | Futures | 1809.85 | 1810.37 | 1809.85 | 1810.11 | 334.0 |
| 2013-10-31 03:35:00 | ES | Futures | 1809.85 | 1810.37 | 1809.85 | 1810.37 | 293.0 |
| 2013-10-31 03:40:00 | ES | Futures | 1810.11 | 1810.11 | 1809.85 | 1810.11 | 198.0 |
| 2013-10-31 03:45:00 | ES | Futures | 1810.11 | 1810.11 | 1809.85 | 1810.11 | 461.0 |
| 2013-10-31 03:50:00 | ES | Futures | 1810.11 | 1810.11 | 1809.33 | 1809.33 | 1055.0 |
| 2013-10-31 03:55:00 | ES | Futures | 1809.59 | 1809.85 | 1809.33 | 1809.59 | 1306.0 |
| 2013-10-31 04:00:00 | ES | Futures | 1809.85 | 1811.14 | 1809.33 | 1810.88 | 4940.0 |
| 2013-10-31 04:05:00 | ES | Futures | 1810.88 | 1811.14 | 1809.85 | 1810.37 | 2754.0 |
> showing 50 of 14,382 rows — these rows as CSV