PREVIEW / futures_5min / 2010-09-20
file: by_date/futures_5min/2010/2010-09-20.parquet size: 192 KB rows: 12,093
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-20 00:00:00 | ES | Futures | 1104.23 | 1104.47 | 1103.98 | 1104.47 | 98.0 |
| 2010-09-20 00:05:00 | ES | Futures | 1104.23 | 1104.47 | 1103.73 | 1103.73 | 157.0 |
| 2010-09-20 00:10:00 | ES | Futures | 1103.73 | 1104.47 | 1103.73 | 1104.47 | 139.0 |
| 2010-09-20 00:15:00 | ES | Futures | 1104.47 | 1104.47 | 1103.98 | 1103.98 | 107.0 |
| 2010-09-20 00:20:00 | ES | Futures | 1103.98 | 1104.47 | 1103.98 | 1103.98 | 76.0 |
| 2010-09-20 00:25:00 | ES | Futures | 1103.73 | 1104.23 | 1103.24 | 1104.23 | 380.0 |
| 2010-09-20 00:30:00 | ES | Futures | 1103.98 | 1104.47 | 1103.73 | 1104.47 | 160.0 |
| 2010-09-20 00:35:00 | ES | Futures | 1104.23 | 1104.96 | 1104.23 | 1104.23 | 441.0 |
| 2010-09-20 00:40:00 | ES | Futures | 1104.47 | 1104.72 | 1104.23 | 1104.72 | 92.0 |
| 2010-09-20 00:45:00 | ES | Futures | 1104.72 | 1104.96 | 1104.72 | 1104.72 | 162.0 |
| 2010-09-20 00:50:00 | ES | Futures | 1104.47 | 1104.96 | 1104.47 | 1104.72 | 88.0 |
| 2010-09-20 00:55:00 | ES | Futures | 1104.96 | 1104.96 | 1104.23 | 1104.96 | 360.0 |
| 2010-09-20 01:00:00 | ES | Futures | 1104.72 | 1105.46 | 1104.72 | 1104.96 | 273.0 |
| 2010-09-20 01:05:00 | ES | Futures | 1105.21 | 1105.46 | 1104.96 | 1104.96 | 141.0 |
| 2010-09-20 01:10:00 | ES | Futures | 1104.72 | 1104.96 | 1104.23 | 1104.72 | 352.0 |
| 2010-09-20 01:15:00 | ES | Futures | 1104.47 | 1104.96 | 1104.47 | 1104.96 | 101.0 |
| 2010-09-20 01:20:00 | ES | Futures | 1104.96 | 1105.21 | 1104.47 | 1104.47 | 276.0 |
| 2010-09-20 01:25:00 | ES | Futures | 1104.47 | 1104.72 | 1104.23 | 1104.47 | 193.0 |
| 2010-09-20 01:30:00 | ES | Futures | 1104.72 | 1104.72 | 1103.98 | 1103.98 | 531.0 |
| 2010-09-20 01:35:00 | ES | Futures | 1103.98 | 1104.23 | 1103.49 | 1103.98 | 262.0 |
| 2010-09-20 01:40:00 | ES | Futures | 1103.98 | 1104.72 | 1103.98 | 1104.72 | 123.0 |
| 2010-09-20 01:45:00 | ES | Futures | 1104.47 | 1105.21 | 1104.23 | 1105.21 | 307.0 |
| 2010-09-20 01:50:00 | ES | Futures | 1105.21 | 1105.7 | 1104.96 | 1105.21 | 511.0 |
| 2010-09-20 01:55:00 | ES | Futures | 1105.21 | 1106.2 | 1105.21 | 1105.7 | 698.0 |
| 2010-09-20 02:00:00 | ES | Futures | 1105.7 | 1106.44 | 1105.7 | 1106.2 | 2135.0 |
| 2010-09-20 02:05:00 | ES | Futures | 1106.2 | 1106.44 | 1105.7 | 1105.95 | 996.0 |
| 2010-09-20 02:10:00 | ES | Futures | 1105.7 | 1106.44 | 1105.46 | 1106.2 | 474.0 |
| 2010-09-20 02:15:00 | ES | Futures | 1106.2 | 1106.44 | 1105.95 | 1105.95 | 269.0 |
| 2010-09-20 02:20:00 | ES | Futures | 1105.95 | 1105.95 | 1105.7 | 1105.95 | 203.0 |
| 2010-09-20 02:25:00 | ES | Futures | 1105.95 | 1106.2 | 1104.96 | 1105.21 | 488.0 |
| 2010-09-20 02:30:00 | ES | Futures | 1105.21 | 1105.46 | 1104.72 | 1105.21 | 477.0 |
| 2010-09-20 02:35:00 | ES | Futures | 1105.46 | 1105.46 | 1104.96 | 1105.21 | 251.0 |
| 2010-09-20 02:40:00 | ES | Futures | 1105.21 | 1105.46 | 1104.96 | 1105.21 | 418.0 |
| 2010-09-20 02:45:00 | ES | Futures | 1105.21 | 1106.69 | 1105.21 | 1106.2 | 1612.0 |
| 2010-09-20 02:50:00 | ES | Futures | 1106.2 | 1106.69 | 1105.95 | 1106.44 | 537.0 |
| 2010-09-20 02:55:00 | ES | Futures | 1106.44 | 1106.94 | 1105.95 | 1106.44 | 687.0 |
| 2010-09-20 03:00:00 | ES | Futures | 1106.44 | 1107.18 | 1106.44 | 1107.18 | 2149.0 |
| 2010-09-20 03:05:00 | ES | Futures | 1106.94 | 1108.42 | 1106.69 | 1108.42 | 5425.0 |
| 2010-09-20 03:10:00 | ES | Futures | 1108.17 | 1108.66 | 1107.18 | 1107.43 | 2770.0 |
| 2010-09-20 03:15:00 | ES | Futures | 1107.18 | 1107.68 | 1106.69 | 1107.43 | 2199.0 |
| 2010-09-20 03:20:00 | ES | Futures | 1107.68 | 1107.92 | 1105.46 | 1105.95 | 3934.0 |
| 2010-09-20 03:25:00 | ES | Futures | 1105.95 | 1107.18 | 1105.7 | 1106.94 | 2213.0 |
| 2010-09-20 03:30:00 | ES | Futures | 1106.69 | 1108.66 | 1106.69 | 1108.17 | 2923.0 |
| 2010-09-20 03:35:00 | ES | Futures | 1108.17 | 1109.15 | 1107.92 | 1108.66 | 3000.0 |
| 2010-09-20 03:40:00 | ES | Futures | 1108.66 | 1109.15 | 1107.92 | 1108.17 | 1700.0 |
| 2010-09-20 03:45:00 | ES | Futures | 1108.17 | 1108.66 | 1107.68 | 1108.17 | 1220.0 |
| 2010-09-20 03:50:00 | ES | Futures | 1107.92 | 1108.17 | 1107.43 | 1107.68 | 2152.0 |
| 2010-09-20 03:55:00 | ES | Futures | 1107.68 | 1108.17 | 1107.43 | 1107.43 | 2104.0 |
| 2010-09-20 04:00:00 | ES | Futures | 1107.43 | 1107.92 | 1106.69 | 1107.43 | 3581.0 |
| 2010-09-20 04:05:00 | ES | Futures | 1107.43 | 1108.17 | 1106.94 | 1107.92 | 1249.0 |
> showing 50 of 12,093 rows — these rows as CSV