PREVIEW / futures_5min / 2010-03-31
file: by_date/futures_5min/2010/2010-03-31.parquet size: 199 KB rows: 12,434
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-03-31 00:00:00 | ES | Futures | 1142.45 | 1142.69 | 1142.2 | 1142.2 | 250.0 |
| 2010-03-31 00:05:00 | ES | Futures | 1142.2 | 1142.69 | 1142.2 | 1142.45 | 113.0 |
| 2010-03-31 00:10:00 | ES | Futures | 1142.69 | 1142.69 | 1142.2 | 1142.45 | 102.0 |
| 2010-03-31 00:15:00 | ES | Futures | 1142.45 | 1142.45 | 1142.2 | 1142.45 | 21.0 |
| 2010-03-31 00:20:00 | ES | Futures | 1142.45 | 1142.45 | 1141.96 | 1142.2 | 235.0 |
| 2010-03-31 00:25:00 | ES | Futures | 1141.96 | 1142.2 | 1141.96 | 1142.2 | 81.0 |
| 2010-03-31 00:30:00 | ES | Futures | 1142.45 | 1142.45 | 1142.2 | 1142.2 | 135.0 |
| 2010-03-31 00:35:00 | ES | Futures | 1142.2 | 1142.2 | 1142.2 | 1142.2 | 25.0 |
| 2010-03-31 00:40:00 | ES | Futures | 1142.2 | 1142.45 | 1142.2 | 1142.2 | 24.0 |
| 2010-03-31 00:45:00 | ES | Futures | 1142.2 | 1142.2 | 1141.96 | 1141.96 | 73.0 |
| 2010-03-31 00:50:00 | ES | Futures | 1141.96 | 1142.2 | 1141.96 | 1141.96 | 41.0 |
| 2010-03-31 00:55:00 | ES | Futures | 1141.96 | 1142.2 | 1141.72 | 1141.96 | 477.0 |
| 2010-03-31 01:00:00 | ES | Futures | 1142.2 | 1142.2 | 1141.72 | 1141.96 | 319.0 |
| 2010-03-31 01:05:00 | ES | Futures | 1141.96 | 1142.2 | 1141.72 | 1141.72 | 212.0 |
| 2010-03-31 01:10:00 | ES | Futures | 1141.72 | 1141.96 | 1141.47 | 1141.47 | 233.0 |
| 2010-03-31 01:15:00 | ES | Futures | 1141.47 | 1141.72 | 1141.23 | 1141.47 | 594.0 |
| 2010-03-31 01:20:00 | ES | Futures | 1141.47 | 1141.47 | 1140.74 | 1140.98 | 1049.0 |
| 2010-03-31 01:25:00 | ES | Futures | 1140.74 | 1140.98 | 1140.49 | 1140.49 | 648.0 |
| 2010-03-31 01:30:00 | ES | Futures | 1140.49 | 1140.74 | 1140.25 | 1140.49 | 612.0 |
| 2010-03-31 01:35:00 | ES | Futures | 1140.25 | 1140.49 | 1140.0 | 1140.49 | 703.0 |
| 2010-03-31 01:40:00 | ES | Futures | 1140.49 | 1140.49 | 1140.25 | 1140.49 | 305.0 |
| 2010-03-31 01:45:00 | ES | Futures | 1140.49 | 1140.74 | 1140.25 | 1140.49 | 245.0 |
| 2010-03-31 01:50:00 | ES | Futures | 1140.74 | 1140.74 | 1140.25 | 1140.74 | 196.0 |
| 2010-03-31 01:55:00 | ES | Futures | 1140.74 | 1140.74 | 1140.25 | 1140.49 | 271.0 |
| 2010-03-31 02:00:00 | ES | Futures | 1140.49 | 1140.98 | 1140.0 | 1140.25 | 948.0 |
| 2010-03-31 02:05:00 | ES | Futures | 1140.25 | 1140.74 | 1140.25 | 1140.49 | 278.0 |
| 2010-03-31 02:10:00 | ES | Futures | 1140.25 | 1140.49 | 1140.25 | 1140.25 | 268.0 |
| 2010-03-31 02:15:00 | ES | Futures | 1140.25 | 1140.25 | 1139.52 | 1139.76 | 1878.0 |
| 2010-03-31 02:20:00 | ES | Futures | 1139.76 | 1140.0 | 1139.27 | 1139.76 | 1116.0 |
| 2010-03-31 02:25:00 | ES | Futures | 1139.52 | 1140.49 | 1139.52 | 1140.25 | 698.0 |
| 2010-03-31 02:30:00 | ES | Futures | 1140.0 | 1140.25 | 1140.0 | 1140.25 | 298.0 |
| 2010-03-31 02:35:00 | ES | Futures | 1140.25 | 1140.49 | 1140.0 | 1140.25 | 215.0 |
| 2010-03-31 02:40:00 | ES | Futures | 1140.49 | 1140.74 | 1140.25 | 1140.25 | 392.0 |
| 2010-03-31 02:45:00 | ES | Futures | 1140.25 | 1140.49 | 1139.76 | 1140.0 | 692.0 |
| 2010-03-31 02:50:00 | ES | Futures | 1139.76 | 1140.0 | 1139.03 | 1139.52 | 1236.0 |
| 2010-03-31 02:55:00 | ES | Futures | 1139.52 | 1139.76 | 1139.27 | 1139.52 | 189.0 |
| 2010-03-31 03:00:00 | ES | Futures | 1139.76 | 1140.98 | 1139.52 | 1140.49 | 1907.0 |
| 2010-03-31 03:05:00 | ES | Futures | 1140.49 | 1141.47 | 1140.25 | 1141.23 | 2250.0 |
| 2010-03-31 03:10:00 | ES | Futures | 1141.47 | 1141.96 | 1140.98 | 1141.47 | 1696.0 |
| 2010-03-31 03:15:00 | ES | Futures | 1141.72 | 1141.96 | 1141.23 | 1141.72 | 1197.0 |
| 2010-03-31 03:20:00 | ES | Futures | 1141.72 | 1142.2 | 1141.47 | 1141.96 | 1373.0 |
| 2010-03-31 03:25:00 | ES | Futures | 1141.96 | 1141.96 | 1141.23 | 1141.23 | 1053.0 |
| 2010-03-31 03:30:00 | ES | Futures | 1141.47 | 1141.72 | 1141.23 | 1141.72 | 1187.0 |
| 2010-03-31 03:35:00 | ES | Futures | 1141.72 | 1142.45 | 1141.72 | 1141.96 | 1587.0 |
| 2010-03-31 03:40:00 | ES | Futures | 1142.2 | 1142.2 | 1141.72 | 1141.96 | 282.0 |
| 2010-03-31 03:45:00 | ES | Futures | 1142.2 | 1142.69 | 1141.96 | 1142.69 | 1385.0 |
| 2010-03-31 03:50:00 | ES | Futures | 1142.69 | 1142.69 | 1142.2 | 1142.45 | 849.0 |
| 2010-03-31 03:55:00 | ES | Futures | 1142.45 | 1142.45 | 1141.72 | 1141.72 | 1250.0 |
| 2010-03-31 04:00:00 | ES | Futures | 1141.96 | 1141.96 | 1141.72 | 1141.72 | 443.0 |
| 2010-03-31 04:05:00 | ES | Futures | 1141.96 | 1142.69 | 1141.72 | 1142.2 | 1705.0 |
> showing 50 of 12,434 rows — these rows as CSV