PREVIEW / futures_5min / 2010-06-24
file: by_date/futures_5min/2010/2010-06-24.parquet size: 199 KB rows: 11,803
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-06-24 00:00:00 | ES | Futures | 1069.61 | 1069.61 | 1069.12 | 1069.36 | 229.0 |
| 2010-06-24 00:05:00 | ES | Futures | 1069.12 | 1069.61 | 1069.12 | 1069.36 | 203.0 |
| 2010-06-24 00:10:00 | ES | Futures | 1069.12 | 1069.61 | 1069.12 | 1069.61 | 141.0 |
| 2010-06-24 00:15:00 | ES | Futures | 1069.61 | 1069.85 | 1069.61 | 1069.61 | 399.0 |
| 2010-06-24 00:20:00 | ES | Futures | 1069.61 | 1069.85 | 1069.36 | 1069.61 | 569.0 |
| 2010-06-24 00:25:00 | ES | Futures | 1069.36 | 1069.61 | 1069.36 | 1069.61 | 51.0 |
| 2010-06-24 00:30:00 | ES | Futures | 1069.61 | 1069.61 | 1068.87 | 1069.12 | 352.0 |
| 2010-06-24 00:35:00 | ES | Futures | 1069.12 | 1069.36 | 1068.63 | 1068.87 | 276.0 |
| 2010-06-24 00:40:00 | ES | Futures | 1068.87 | 1068.87 | 1068.38 | 1068.87 | 118.0 |
| 2010-06-24 00:45:00 | ES | Futures | 1068.63 | 1069.36 | 1068.63 | 1069.12 | 367.0 |
| 2010-06-24 00:50:00 | ES | Futures | 1069.12 | 1069.61 | 1069.12 | 1069.61 | 54.0 |
| 2010-06-24 00:55:00 | ES | Futures | 1069.36 | 1069.61 | 1069.12 | 1069.36 | 244.0 |
| 2010-06-24 01:00:00 | ES | Futures | 1069.12 | 1069.85 | 1068.38 | 1068.87 | 352.0 |
| 2010-06-24 01:05:00 | ES | Futures | 1068.87 | 1069.12 | 1068.38 | 1068.87 | 466.0 |
| 2010-06-24 01:10:00 | ES | Futures | 1068.63 | 1068.87 | 1068.14 | 1068.63 | 1020.0 |
| 2010-06-24 01:15:00 | ES | Futures | 1068.63 | 1070.35 | 1068.14 | 1070.1 | 986.0 |
| 2010-06-24 01:20:00 | ES | Futures | 1069.85 | 1070.35 | 1069.36 | 1069.61 | 677.0 |
| 2010-06-24 01:25:00 | ES | Futures | 1069.61 | 1070.1 | 1069.61 | 1069.61 | 908.0 |
| 2010-06-24 01:30:00 | ES | Futures | 1069.85 | 1070.1 | 1069.36 | 1069.36 | 435.0 |
| 2010-06-24 01:35:00 | ES | Futures | 1069.36 | 1069.36 | 1067.89 | 1068.38 | 1388.0 |
| 2010-06-24 01:40:00 | ES | Futures | 1068.63 | 1068.87 | 1068.38 | 1068.63 | 427.0 |
| 2010-06-24 01:45:00 | ES | Futures | 1068.63 | 1069.36 | 1068.63 | 1069.12 | 385.0 |
| 2010-06-24 01:50:00 | ES | Futures | 1068.87 | 1068.87 | 1067.89 | 1068.63 | 627.0 |
| 2010-06-24 01:55:00 | ES | Futures | 1068.63 | 1068.63 | 1067.4 | 1067.4 | 603.0 |
| 2010-06-24 02:00:00 | ES | Futures | 1067.89 | 1069.36 | 1067.65 | 1069.36 | 1160.0 |
| 2010-06-24 02:05:00 | ES | Futures | 1069.12 | 1069.61 | 1069.12 | 1069.36 | 267.0 |
| 2010-06-24 02:10:00 | ES | Futures | 1069.12 | 1069.61 | 1069.12 | 1069.12 | 389.0 |
| 2010-06-24 02:15:00 | ES | Futures | 1069.36 | 1069.61 | 1069.12 | 1069.61 | 144.0 |
| 2010-06-24 02:20:00 | ES | Futures | 1069.61 | 1069.61 | 1069.12 | 1069.36 | 75.0 |
| 2010-06-24 02:25:00 | ES | Futures | 1069.36 | 1070.84 | 1069.12 | 1070.35 | 1511.0 |
| 2010-06-24 02:30:00 | ES | Futures | 1070.35 | 1070.59 | 1069.85 | 1069.85 | 1266.0 |
| 2010-06-24 02:35:00 | ES | Futures | 1069.85 | 1069.85 | 1069.36 | 1069.36 | 137.0 |
| 2010-06-24 02:40:00 | ES | Futures | 1069.61 | 1069.61 | 1069.12 | 1069.36 | 391.0 |
| 2010-06-24 02:45:00 | ES | Futures | 1069.61 | 1069.85 | 1069.36 | 1069.36 | 570.0 |
| 2010-06-24 02:50:00 | ES | Futures | 1069.36 | 1069.61 | 1069.36 | 1069.36 | 426.0 |
| 2010-06-24 02:55:00 | ES | Futures | 1069.36 | 1069.36 | 1067.89 | 1068.38 | 1788.0 |
| 2010-06-24 03:00:00 | ES | Futures | 1068.14 | 1068.63 | 1067.65 | 1068.14 | 2777.0 |
| 2010-06-24 03:05:00 | ES | Futures | 1068.14 | 1068.14 | 1066.91 | 1067.16 | 2408.0 |
| 2010-06-24 03:10:00 | ES | Futures | 1067.4 | 1067.89 | 1066.42 | 1066.42 | 2369.0 |
| 2010-06-24 03:15:00 | ES | Futures | 1066.66 | 1066.91 | 1065.93 | 1065.93 | 2223.0 |
| 2010-06-24 03:20:00 | ES | Futures | 1065.93 | 1066.91 | 1065.19 | 1065.44 | 2328.0 |
| 2010-06-24 03:25:00 | ES | Futures | 1065.68 | 1066.17 | 1064.95 | 1065.19 | 3091.0 |
| 2010-06-24 03:30:00 | ES | Futures | 1064.95 | 1065.44 | 1063.97 | 1064.95 | 5693.0 |
| 2010-06-24 03:35:00 | ES | Futures | 1064.95 | 1065.19 | 1063.23 | 1063.97 | 6899.0 |
| 2010-06-24 03:40:00 | ES | Futures | 1064.21 | 1064.46 | 1063.47 | 1064.21 | 2479.0 |
| 2010-06-24 03:45:00 | ES | Futures | 1064.46 | 1064.46 | 1061.27 | 1062.25 | 6687.0 |
| 2010-06-24 03:50:00 | ES | Futures | 1062.25 | 1063.23 | 1060.78 | 1062.98 | 8170.0 |
| 2010-06-24 03:55:00 | ES | Futures | 1063.23 | 1063.23 | 1061.51 | 1061.76 | 4477.0 |
| 2010-06-24 04:00:00 | ES | Futures | 1061.76 | 1062.25 | 1060.78 | 1060.78 | 5539.0 |
| 2010-06-24 04:05:00 | ES | Futures | 1060.78 | 1061.76 | 1060.28 | 1061.51 | 4098.0 |
> showing 50 of 11,803 rows — these rows as CSV