PREVIEW / futures_5min / 2014-11-20
file: by_date/futures_5min/2014/2014-11-20.parquet size: 228 KB rows: 14,091
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-11-20 00:00:00 | ES | Futures | 2141.32 | 2141.58 | 2141.32 | 2141.58 | 128.0 |
| 2014-11-20 00:05:00 | ES | Futures | 2141.58 | 2142.11 | 2141.58 | 2141.85 | 127.0 |
| 2014-11-20 00:10:00 | ES | Futures | 2141.85 | 2142.11 | 2141.85 | 2142.11 | 165.0 |
| 2014-11-20 00:15:00 | ES | Futures | 2141.85 | 2141.85 | 2141.06 | 2141.32 | 213.0 |
| 2014-11-20 00:20:00 | ES | Futures | 2141.32 | 2141.58 | 2141.06 | 2141.58 | 99.0 |
| 2014-11-20 00:25:00 | ES | Futures | 2141.58 | 2141.58 | 2141.06 | 2141.06 | 260.0 |
| 2014-11-20 00:30:00 | ES | Futures | 2141.06 | 2141.58 | 2141.06 | 2141.32 | 191.0 |
| 2014-11-20 00:35:00 | ES | Futures | 2141.32 | 2141.58 | 2141.32 | 2141.32 | 153.0 |
| 2014-11-20 00:40:00 | ES | Futures | 2141.32 | 2141.32 | 2141.06 | 2141.32 | 137.0 |
| 2014-11-20 00:45:00 | ES | Futures | 2141.06 | 2141.58 | 2141.06 | 2141.58 | 96.0 |
| 2014-11-20 00:50:00 | ES | Futures | 2141.32 | 2141.58 | 2141.06 | 2141.58 | 188.0 |
| 2014-11-20 00:55:00 | ES | Futures | 2141.58 | 2141.58 | 2141.06 | 2141.32 | 109.0 |
| 2014-11-20 01:00:00 | ES | Futures | 2141.32 | 2141.85 | 2141.32 | 2141.32 | 131.0 |
| 2014-11-20 01:05:00 | ES | Futures | 2141.58 | 2141.85 | 2141.32 | 2141.58 | 111.0 |
| 2014-11-20 01:10:00 | ES | Futures | 2141.85 | 2141.85 | 2141.32 | 2141.58 | 145.0 |
| 2014-11-20 01:15:00 | ES | Futures | 2141.58 | 2141.58 | 2141.32 | 2141.58 | 313.0 |
| 2014-11-20 01:20:00 | ES | Futures | 2141.58 | 2141.58 | 2141.06 | 2141.32 | 199.0 |
| 2014-11-20 01:25:00 | ES | Futures | 2141.32 | 2141.58 | 2141.32 | 2141.58 | 132.0 |
| 2014-11-20 01:30:00 | ES | Futures | 2141.58 | 2141.85 | 2141.32 | 2141.32 | 74.0 |
| 2014-11-20 01:35:00 | ES | Futures | 2141.32 | 2142.11 | 2141.32 | 2141.85 | 105.0 |
| 2014-11-20 01:40:00 | ES | Futures | 2141.85 | 2142.11 | 2141.32 | 2141.32 | 87.0 |
| 2014-11-20 01:45:00 | ES | Futures | 2141.58 | 2141.85 | 2141.06 | 2141.85 | 162.0 |
| 2014-11-20 01:50:00 | ES | Futures | 2141.58 | 2142.37 | 2141.58 | 2142.37 | 244.0 |
| 2014-11-20 01:55:00 | ES | Futures | 2142.37 | 2143.42 | 2142.11 | 2143.16 | 943.0 |
| 2014-11-20 02:00:00 | ES | Futures | 2143.16 | 2143.16 | 2142.37 | 2142.63 | 625.0 |
| 2014-11-20 02:05:00 | ES | Futures | 2142.63 | 2143.16 | 2142.37 | 2142.89 | 407.0 |
| 2014-11-20 02:10:00 | ES | Futures | 2143.16 | 2143.42 | 2143.16 | 2143.42 | 216.0 |
| 2014-11-20 02:15:00 | ES | Futures | 2143.42 | 2143.94 | 2143.16 | 2143.68 | 590.0 |
| 2014-11-20 02:20:00 | ES | Futures | 2143.68 | 2143.94 | 2143.68 | 2143.68 | 244.0 |
| 2014-11-20 02:25:00 | ES | Futures | 2143.68 | 2143.94 | 2143.16 | 2143.42 | 207.0 |
| 2014-11-20 02:30:00 | ES | Futures | 2143.16 | 2143.42 | 2142.11 | 2142.11 | 634.0 |
| 2014-11-20 02:35:00 | ES | Futures | 2142.11 | 2142.63 | 2141.85 | 2141.85 | 554.0 |
| 2014-11-20 02:40:00 | ES | Futures | 2141.85 | 2142.37 | 2141.58 | 2142.11 | 407.0 |
| 2014-11-20 02:45:00 | ES | Futures | 2142.11 | 2142.11 | 2141.32 | 2141.58 | 1121.0 |
| 2014-11-20 02:50:00 | ES | Futures | 2141.32 | 2141.58 | 2140.8 | 2141.06 | 660.0 |
| 2014-11-20 02:55:00 | ES | Futures | 2141.06 | 2141.85 | 2141.06 | 2141.85 | 458.0 |
| 2014-11-20 03:00:00 | ES | Futures | 2141.85 | 2142.11 | 2140.54 | 2141.06 | 2472.0 |
| 2014-11-20 03:05:00 | ES | Futures | 2141.06 | 2141.85 | 2141.06 | 2141.32 | 1203.0 |
| 2014-11-20 03:10:00 | ES | Futures | 2141.32 | 2141.85 | 2140.54 | 2140.8 | 3171.0 |
| 2014-11-20 03:15:00 | ES | Futures | 2140.8 | 2141.32 | 2140.54 | 2141.06 | 955.0 |
| 2014-11-20 03:20:00 | ES | Futures | 2140.8 | 2141.06 | 2140.01 | 2140.8 | 1769.0 |
| 2014-11-20 03:25:00 | ES | Futures | 2141.06 | 2141.32 | 2140.27 | 2140.54 | 651.0 |
| 2014-11-20 03:30:00 | ES | Futures | 2140.27 | 2140.27 | 2137.65 | 2137.92 | 9108.0 |
| 2014-11-20 03:35:00 | ES | Futures | 2138.18 | 2138.44 | 2137.39 | 2137.92 | 4331.0 |
| 2014-11-20 03:40:00 | ES | Futures | 2138.18 | 2138.7 | 2137.92 | 2138.7 | 1425.0 |
| 2014-11-20 03:45:00 | ES | Futures | 2138.44 | 2138.44 | 2137.92 | 2138.18 | 1090.0 |
| 2014-11-20 03:50:00 | ES | Futures | 2138.18 | 2138.7 | 2137.92 | 2138.18 | 1000.0 |
| 2014-11-20 03:55:00 | ES | Futures | 2138.18 | 2138.18 | 2137.39 | 2137.65 | 1624.0 |
| 2014-11-20 04:00:00 | ES | Futures | 2137.39 | 2138.18 | 2136.87 | 2138.18 | 2883.0 |
| 2014-11-20 04:05:00 | ES | Futures | 2138.18 | 2138.7 | 2137.65 | 2137.65 | 1585.0 |
> showing 50 of 14,091 rows — these rows as CSV