PREVIEW / futures_5min / 2012-11-23
file: by_date/futures_5min/2012/2012-11-23.parquet size: 147 KB rows: 8,542
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-23 00:00:00 | ES | Futures | 1421.14 | 1421.66 | 1420.89 | 1421.4 | 300.0 |
| 2012-11-23 00:05:00 | ES | Futures | 1421.4 | 1421.66 | 1421.4 | 1421.66 | 3.0 |
| 2012-11-23 00:10:00 | ES | Futures | 1421.4 | 1421.66 | 1421.4 | 1421.66 | 47.0 |
| 2012-11-23 00:15:00 | ES | Futures | 1421.66 | 1421.66 | 1421.4 | 1421.66 | 42.0 |
| 2012-11-23 00:20:00 | ES | Futures | 1421.66 | 1422.17 | 1421.4 | 1421.66 | 293.0 |
| 2012-11-23 00:25:00 | ES | Futures | 1421.91 | 1421.91 | 1421.66 | 1421.66 | 60.0 |
| 2012-11-23 00:30:00 | ES | Futures | 1421.91 | 1421.91 | 1421.66 | 1421.66 | 76.0 |
| 2012-11-23 00:35:00 | ES | Futures | 1421.66 | 1421.91 | 1421.66 | 1421.91 | 49.0 |
| 2012-11-23 00:40:00 | ES | Futures | 1421.91 | 1422.17 | 1421.91 | 1422.17 | 113.0 |
| 2012-11-23 00:45:00 | ES | Futures | 1422.42 | 1422.93 | 1422.42 | 1422.42 | 655.0 |
| 2012-11-23 00:50:00 | ES | Futures | 1422.42 | 1422.93 | 1422.42 | 1422.93 | 434.0 |
| 2012-11-23 00:55:00 | ES | Futures | 1422.93 | 1423.19 | 1422.68 | 1423.19 | 113.0 |
| 2012-11-23 01:00:00 | ES | Futures | 1422.93 | 1423.19 | 1422.93 | 1423.19 | 164.0 |
| 2012-11-23 01:05:00 | ES | Futures | 1423.19 | 1423.19 | 1422.68 | 1422.68 | 126.0 |
| 2012-11-23 01:10:00 | ES | Futures | 1422.68 | 1423.19 | 1422.68 | 1422.93 | 219.0 |
| 2012-11-23 01:15:00 | ES | Futures | 1422.93 | 1423.19 | 1422.68 | 1422.93 | 290.0 |
| 2012-11-23 01:20:00 | ES | Futures | 1422.93 | 1423.19 | 1422.93 | 1423.19 | 189.0 |
| 2012-11-23 01:25:00 | ES | Futures | 1423.19 | 1423.19 | 1422.93 | 1423.19 | 249.0 |
| 2012-11-23 01:30:00 | ES | Futures | 1423.19 | 1423.19 | 1422.93 | 1423.19 | 38.0 |
| 2012-11-23 01:35:00 | ES | Futures | 1423.19 | 1423.44 | 1423.19 | 1423.19 | 74.0 |
| 2012-11-23 01:40:00 | ES | Futures | 1423.19 | 1423.19 | 1422.68 | 1422.93 | 181.0 |
| 2012-11-23 01:45:00 | ES | Futures | 1422.93 | 1422.93 | 1422.68 | 1422.93 | 42.0 |
| 2012-11-23 01:50:00 | ES | Futures | 1422.68 | 1422.68 | 1422.42 | 1422.68 | 127.0 |
| 2012-11-23 01:55:00 | ES | Futures | 1422.68 | 1422.68 | 1422.42 | 1422.42 | 38.0 |
| 2012-11-23 02:00:00 | ES | Futures | 1422.68 | 1423.19 | 1422.42 | 1422.68 | 352.0 |
| 2012-11-23 02:05:00 | ES | Futures | 1422.42 | 1423.44 | 1422.42 | 1422.93 | 634.0 |
| 2012-11-23 02:10:00 | ES | Futures | 1423.19 | 1423.19 | 1422.93 | 1422.93 | 62.0 |
| 2012-11-23 02:15:00 | ES | Futures | 1423.19 | 1423.19 | 1422.93 | 1422.93 | 88.0 |
| 2012-11-23 02:20:00 | ES | Futures | 1423.19 | 1423.44 | 1423.19 | 1423.44 | 371.0 |
| 2012-11-23 02:25:00 | ES | Futures | 1423.44 | 1423.44 | 1422.93 | 1423.19 | 222.0 |
| 2012-11-23 02:30:00 | ES | Futures | 1423.19 | 1423.7 | 1422.93 | 1423.44 | 606.0 |
| 2012-11-23 02:35:00 | ES | Futures | 1423.19 | 1423.44 | 1423.19 | 1423.44 | 170.0 |
| 2012-11-23 02:40:00 | ES | Futures | 1423.19 | 1423.44 | 1422.93 | 1423.19 | 141.0 |
| 2012-11-23 02:45:00 | ES | Futures | 1422.93 | 1423.19 | 1422.93 | 1423.19 | 67.0 |
| 2012-11-23 02:50:00 | ES | Futures | 1422.93 | 1423.19 | 1422.68 | 1422.93 | 99.0 |
| 2012-11-23 02:55:00 | ES | Futures | 1422.93 | 1423.7 | 1422.93 | 1423.44 | 647.0 |
| 2012-11-23 03:00:00 | ES | Futures | 1423.19 | 1423.7 | 1422.68 | 1422.93 | 1104.0 |
| 2012-11-23 03:05:00 | ES | Futures | 1422.93 | 1422.93 | 1422.42 | 1422.93 | 1851.0 |
| 2012-11-23 03:10:00 | ES | Futures | 1422.93 | 1422.93 | 1422.17 | 1422.42 | 1273.0 |
| 2012-11-23 03:15:00 | ES | Futures | 1422.17 | 1422.68 | 1421.91 | 1422.17 | 1309.0 |
| 2012-11-23 03:20:00 | ES | Futures | 1422.42 | 1422.42 | 1421.91 | 1421.91 | 793.0 |
| 2012-11-23 03:25:00 | ES | Futures | 1421.91 | 1422.17 | 1420.89 | 1421.14 | 3634.0 |
| 2012-11-23 03:30:00 | ES | Futures | 1421.14 | 1421.14 | 1420.12 | 1420.12 | 3791.0 |
| 2012-11-23 03:35:00 | ES | Futures | 1420.12 | 1420.12 | 1418.85 | 1419.1 | 4051.0 |
| 2012-11-23 03:40:00 | ES | Futures | 1418.85 | 1420.38 | 1418.85 | 1419.61 | 2202.0 |
| 2012-11-23 03:45:00 | ES | Futures | 1419.61 | 1419.87 | 1418.85 | 1419.36 | 1675.0 |
| 2012-11-23 03:50:00 | ES | Futures | 1419.36 | 1419.61 | 1418.85 | 1419.1 | 1055.0 |
| 2012-11-23 03:55:00 | ES | Futures | 1419.1 | 1419.1 | 1417.57 | 1418.08 | 2898.0 |
| 2012-11-23 04:00:00 | ES | Futures | 1418.33 | 1419.87 | 1418.08 | 1419.1 | 2811.0 |
| 2012-11-23 04:05:00 | ES | Futures | 1419.1 | 1419.87 | 1419.1 | 1419.61 | 1822.0 |
> showing 50 of 8,542 rows — these rows as CSV