PREVIEW / futures_5min / 2008-06-20
file: by_date/futures_5min/2008/2008-06-20.parquet size: 168 KB rows: 8,688
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-20 00:00:00 | ES | Futures | 1244.82 | 1245.28 | 1244.58 | 1245.28 | 113.0 |
| 2008-06-20 00:05:00 | ES | Futures | 1245.28 | 1245.75 | 1245.28 | 1245.28 | 55.0 |
| 2008-06-20 00:10:00 | ES | Futures | 1245.28 | 1245.51 | 1244.82 | 1245.05 | 30.0 |
| 2008-06-20 00:15:00 | ES | Futures | 1245.05 | 1245.05 | 1244.82 | 1244.82 | 9.0 |
| 2008-06-20 00:20:00 | ES | Futures | 1244.82 | 1245.05 | 1244.58 | 1244.82 | 99.0 |
| 2008-06-20 00:25:00 | ES | Futures | 1244.82 | 1245.05 | 1244.35 | 1244.35 | 87.0 |
| 2008-06-20 00:30:00 | ES | Futures | 1244.35 | 1244.58 | 1244.12 | 1244.58 | 129.0 |
| 2008-06-20 00:35:00 | ES | Futures | 1244.58 | 1244.58 | 1244.35 | 1244.35 | 71.0 |
| 2008-06-20 00:40:00 | ES | Futures | 1244.35 | 1244.58 | 1244.12 | 1244.58 | 63.0 |
| 2008-06-20 00:45:00 | ES | Futures | 1244.35 | 1244.82 | 1244.35 | 1244.58 | 62.0 |
| 2008-06-20 00:50:00 | ES | Futures | 1244.58 | 1244.82 | 1244.58 | 1244.82 | 20.0 |
| 2008-06-20 00:55:00 | ES | Futures | 1244.82 | 1245.51 | 1244.82 | 1244.82 | 121.0 |
| 2008-06-20 01:00:00 | ES | Futures | 1245.05 | 1245.05 | 1244.82 | 1245.05 | 104.0 |
| 2008-06-20 01:05:00 | ES | Futures | 1245.05 | 1245.51 | 1245.05 | 1245.05 | 46.0 |
| 2008-06-20 01:10:00 | ES | Futures | 1245.05 | 1245.28 | 1245.05 | 1245.28 | 9.0 |
| 2008-06-20 01:15:00 | ES | Futures | 1245.05 | 1245.05 | 1244.82 | 1244.82 | 17.0 |
| 2008-06-20 01:20:00 | ES | Futures | 1245.05 | 1245.05 | 1243.89 | 1243.89 | 188.0 |
| 2008-06-20 01:25:00 | ES | Futures | 1243.89 | 1244.12 | 1243.89 | 1244.12 | 89.0 |
| 2008-06-20 01:30:00 | ES | Futures | 1243.89 | 1244.35 | 1243.89 | 1244.35 | 46.0 |
| 2008-06-20 01:35:00 | ES | Futures | 1244.35 | 1244.35 | 1244.12 | 1244.35 | 18.0 |
| 2008-06-20 01:40:00 | ES | Futures | 1244.12 | 1244.12 | 1243.65 | 1243.89 | 204.0 |
| 2008-06-20 01:45:00 | ES | Futures | 1243.89 | 1243.89 | 1243.65 | 1243.65 | 55.0 |
| 2008-06-20 01:50:00 | ES | Futures | 1243.89 | 1243.89 | 1243.65 | 1243.89 | 8.0 |
| 2008-06-20 01:55:00 | ES | Futures | 1243.89 | 1244.58 | 1243.89 | 1244.35 | 207.0 |
| 2008-06-20 02:00:00 | ES | Futures | 1244.12 | 1246.21 | 1244.12 | 1245.28 | 597.0 |
| 2008-06-20 02:05:00 | ES | Futures | 1245.51 | 1245.51 | 1244.12 | 1244.12 | 579.0 |
| 2008-06-20 02:10:00 | ES | Futures | 1243.89 | 1244.35 | 1243.89 | 1244.35 | 318.0 |
| 2008-06-20 02:15:00 | ES | Futures | 1244.35 | 1244.58 | 1243.89 | 1244.35 | 271.0 |
| 2008-06-20 02:20:00 | ES | Futures | 1244.35 | 1244.58 | 1244.12 | 1244.58 | 274.0 |
| 2008-06-20 02:25:00 | ES | Futures | 1244.82 | 1245.28 | 1244.58 | 1244.82 | 210.0 |
| 2008-06-20 02:30:00 | ES | Futures | 1244.82 | 1244.82 | 1244.12 | 1244.58 | 167.0 |
| 2008-06-20 02:35:00 | ES | Futures | 1244.82 | 1244.82 | 1244.12 | 1244.35 | 278.0 |
| 2008-06-20 02:40:00 | ES | Futures | 1244.12 | 1244.58 | 1243.89 | 1243.89 | 748.0 |
| 2008-06-20 02:45:00 | ES | Futures | 1243.89 | 1244.12 | 1243.65 | 1244.12 | 266.0 |
| 2008-06-20 02:50:00 | ES | Futures | 1244.12 | 1244.35 | 1244.12 | 1244.12 | 396.0 |
| 2008-06-20 02:55:00 | ES | Futures | 1244.35 | 1244.58 | 1244.35 | 1244.58 | 208.0 |
| 2008-06-20 03:00:00 | ES | Futures | 1244.58 | 1244.58 | 1243.89 | 1244.35 | 1422.0 |
| 2008-06-20 03:05:00 | ES | Futures | 1244.35 | 1244.58 | 1244.12 | 1244.12 | 489.0 |
| 2008-06-20 03:10:00 | ES | Futures | 1244.35 | 1244.35 | 1244.12 | 1244.35 | 629.0 |
| 2008-06-20 03:15:00 | ES | Futures | 1244.12 | 1246.68 | 1244.12 | 1246.44 | 2681.0 |
| 2008-06-20 03:20:00 | ES | Futures | 1246.44 | 1247.14 | 1246.44 | 1246.91 | 2410.0 |
| 2008-06-20 03:25:00 | ES | Futures | 1246.91 | 1247.14 | 1245.51 | 1246.21 | 1581.0 |
| 2008-06-20 03:30:00 | ES | Futures | 1245.98 | 1245.98 | 1244.58 | 1245.51 | 2183.0 |
| 2008-06-20 03:35:00 | ES | Futures | 1245.28 | 1245.51 | 1244.58 | 1244.82 | 603.0 |
| 2008-06-20 03:40:00 | ES | Futures | 1244.58 | 1245.28 | 1244.58 | 1244.82 | 977.0 |
| 2008-06-20 03:45:00 | ES | Futures | 1244.58 | 1244.82 | 1244.35 | 1244.35 | 611.0 |
| 2008-06-20 03:50:00 | ES | Futures | 1244.35 | 1244.35 | 1243.89 | 1244.12 | 515.0 |
| 2008-06-20 03:55:00 | ES | Futures | 1244.12 | 1244.12 | 1243.65 | 1243.89 | 311.0 |
| 2008-06-20 04:00:00 | ES | Futures | 1243.65 | 1244.12 | 1243.19 | 1243.89 | 2058.0 |
| 2008-06-20 04:05:00 | ES | Futures | 1243.89 | 1244.35 | 1243.42 | 1243.65 | 715.0 |
> showing 50 of 8,688 rows — these rows as CSV