PREVIEW / futures_5min / 2009-10-23
file: by_date/futures_5min/2009/2009-10-23.parquet size: 175 KB rows: 9,936
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-23 00:00:00 | ES | Futures | 1060.2 | 1060.2 | 1059.96 | 1060.2 | 49.0 |
| 2009-10-23 00:05:00 | ES | Futures | 1060.2 | 1060.45 | 1059.96 | 1060.45 | 130.0 |
| 2009-10-23 00:10:00 | ES | Futures | 1060.45 | 1060.93 | 1060.2 | 1060.45 | 976.0 |
| 2009-10-23 00:15:00 | ES | Futures | 1060.45 | 1060.45 | 1060.2 | 1060.2 | 47.0 |
| 2009-10-23 00:20:00 | ES | Futures | 1060.45 | 1060.45 | 1059.96 | 1059.96 | 111.0 |
| 2009-10-23 00:25:00 | ES | Futures | 1059.96 | 1060.45 | 1059.72 | 1060.2 | 254.0 |
| 2009-10-23 00:30:00 | ES | Futures | 1060.45 | 1060.45 | 1059.72 | 1060.2 | 549.0 |
| 2009-10-23 00:35:00 | ES | Futures | 1060.2 | 1060.69 | 1059.96 | 1060.69 | 373.0 |
| 2009-10-23 00:40:00 | ES | Futures | 1060.45 | 1060.69 | 1060.45 | 1060.45 | 184.0 |
| 2009-10-23 00:45:00 | ES | Futures | 1060.45 | 1060.45 | 1059.96 | 1060.2 | 96.0 |
| 2009-10-23 00:50:00 | ES | Futures | 1060.2 | 1060.69 | 1059.96 | 1060.45 | 322.0 |
| 2009-10-23 00:55:00 | ES | Futures | 1060.45 | 1060.69 | 1060.45 | 1060.45 | 59.0 |
| 2009-10-23 01:00:00 | ES | Futures | 1060.45 | 1060.69 | 1060.45 | 1060.69 | 54.0 |
| 2009-10-23 01:05:00 | ES | Futures | 1060.45 | 1060.45 | 1059.96 | 1059.96 | 97.0 |
| 2009-10-23 01:10:00 | ES | Futures | 1060.2 | 1060.45 | 1059.96 | 1059.96 | 219.0 |
| 2009-10-23 01:15:00 | ES | Futures | 1059.96 | 1060.2 | 1059.48 | 1059.48 | 208.0 |
| 2009-10-23 01:20:00 | ES | Futures | 1059.48 | 1059.72 | 1059.24 | 1059.24 | 171.0 |
| 2009-10-23 01:25:00 | ES | Futures | 1059.24 | 1059.24 | 1058.27 | 1058.51 | 948.0 |
| 2009-10-23 01:30:00 | ES | Futures | 1058.27 | 1058.99 | 1058.27 | 1058.51 | 338.0 |
| 2009-10-23 01:35:00 | ES | Futures | 1058.51 | 1058.99 | 1058.27 | 1058.51 | 310.0 |
| 2009-10-23 01:40:00 | ES | Futures | 1058.51 | 1059.72 | 1058.51 | 1058.75 | 298.0 |
| 2009-10-23 01:45:00 | ES | Futures | 1058.75 | 1059.24 | 1057.78 | 1058.51 | 995.0 |
| 2009-10-23 01:50:00 | ES | Futures | 1058.51 | 1058.51 | 1058.27 | 1058.51 | 131.0 |
| 2009-10-23 01:55:00 | ES | Futures | 1058.51 | 1058.75 | 1058.27 | 1058.51 | 187.0 |
| 2009-10-23 02:00:00 | ES | Futures | 1058.51 | 1058.75 | 1058.02 | 1058.27 | 680.0 |
| 2009-10-23 02:05:00 | ES | Futures | 1058.27 | 1058.99 | 1058.02 | 1058.99 | 749.0 |
| 2009-10-23 02:10:00 | ES | Futures | 1058.99 | 1058.99 | 1058.27 | 1058.51 | 169.0 |
| 2009-10-23 02:15:00 | ES | Futures | 1058.51 | 1058.51 | 1058.02 | 1058.02 | 174.0 |
| 2009-10-23 02:20:00 | ES | Futures | 1058.27 | 1058.27 | 1058.02 | 1058.27 | 256.0 |
| 2009-10-23 02:25:00 | ES | Futures | 1058.51 | 1058.75 | 1058.27 | 1058.75 | 638.0 |
| 2009-10-23 02:30:00 | ES | Futures | 1058.75 | 1058.99 | 1057.54 | 1057.78 | 1822.0 |
| 2009-10-23 02:35:00 | ES | Futures | 1057.78 | 1057.78 | 1057.3 | 1057.78 | 1266.0 |
| 2009-10-23 02:40:00 | ES | Futures | 1057.54 | 1057.78 | 1057.3 | 1057.3 | 547.0 |
| 2009-10-23 02:45:00 | ES | Futures | 1057.54 | 1057.54 | 1057.06 | 1057.54 | 1516.0 |
| 2009-10-23 02:50:00 | ES | Futures | 1057.54 | 1057.54 | 1057.3 | 1057.54 | 299.0 |
| 2009-10-23 02:55:00 | ES | Futures | 1057.54 | 1058.02 | 1057.3 | 1057.54 | 1086.0 |
| 2009-10-23 03:00:00 | ES | Futures | 1057.78 | 1058.27 | 1057.06 | 1057.54 | 3701.0 |
| 2009-10-23 03:05:00 | ES | Futures | 1057.3 | 1058.51 | 1057.06 | 1058.51 | 2645.0 |
| 2009-10-23 03:10:00 | ES | Futures | 1058.51 | 1058.99 | 1057.78 | 1058.51 | 2000.0 |
| 2009-10-23 03:15:00 | ES | Futures | 1058.27 | 1059.72 | 1058.02 | 1059.48 | 2817.0 |
| 2009-10-23 03:20:00 | ES | Futures | 1059.72 | 1060.2 | 1059.48 | 1059.96 | 2299.0 |
| 2009-10-23 03:25:00 | ES | Futures | 1060.2 | 1060.45 | 1059.72 | 1060.2 | 3576.0 |
| 2009-10-23 03:30:00 | ES | Futures | 1060.2 | 1060.69 | 1059.48 | 1059.72 | 2389.0 |
| 2009-10-23 03:35:00 | ES | Futures | 1059.96 | 1060.45 | 1059.48 | 1059.72 | 2056.0 |
| 2009-10-23 03:40:00 | ES | Futures | 1059.72 | 1060.69 | 1059.72 | 1060.2 | 1477.0 |
| 2009-10-23 03:45:00 | ES | Futures | 1060.2 | 1060.45 | 1059.72 | 1060.2 | 1839.0 |
| 2009-10-23 03:50:00 | ES | Futures | 1060.45 | 1060.45 | 1059.72 | 1059.72 | 1545.0 |
| 2009-10-23 03:55:00 | ES | Futures | 1059.72 | 1060.2 | 1059.72 | 1060.2 | 1124.0 |
| 2009-10-23 04:00:00 | ES | Futures | 1059.96 | 1060.45 | 1059.72 | 1059.96 | 2757.0 |
| 2009-10-23 04:05:00 | ES | Futures | 1059.96 | 1060.2 | 1058.75 | 1059.48 | 1550.0 |
> showing 50 of 9,936 rows — these rows as CSV