PREVIEW / futures_5min / 2011-11-09
file: by_date/futures_5min/2011/2011-11-09.parquet size: 266 KB rows: 13,735
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-09 00:00:00 | ES | Futures | 1273.6 | 1273.85 | 1273.1 | 1273.35 | 193.0 |
| 2011-11-09 00:05:00 | ES | Futures | 1273.35 | 1273.35 | 1272.85 | 1273.1 | 520.0 |
| 2011-11-09 00:10:00 | ES | Futures | 1273.1 | 1273.35 | 1272.85 | 1273.35 | 224.0 |
| 2011-11-09 00:15:00 | ES | Futures | 1273.1 | 1273.35 | 1272.35 | 1273.1 | 1013.0 |
| 2011-11-09 00:20:00 | ES | Futures | 1273.1 | 1273.1 | 1272.85 | 1272.85 | 476.0 |
| 2011-11-09 00:25:00 | ES | Futures | 1272.85 | 1272.85 | 1272.35 | 1272.6 | 292.0 |
| 2011-11-09 00:30:00 | ES | Futures | 1272.35 | 1272.85 | 1272.35 | 1272.85 | 168.0 |
| 2011-11-09 00:35:00 | ES | Futures | 1272.85 | 1273.35 | 1272.85 | 1273.35 | 492.0 |
| 2011-11-09 00:40:00 | ES | Futures | 1273.35 | 1273.35 | 1272.85 | 1273.1 | 127.0 |
| 2011-11-09 00:45:00 | ES | Futures | 1273.35 | 1273.6 | 1273.1 | 1273.6 | 224.0 |
| 2011-11-09 00:50:00 | ES | Futures | 1273.6 | 1274.35 | 1273.6 | 1274.35 | 501.0 |
| 2011-11-09 00:55:00 | ES | Futures | 1274.35 | 1274.35 | 1273.85 | 1274.1 | 619.0 |
| 2011-11-09 01:00:00 | ES | Futures | 1274.1 | 1274.6 | 1274.1 | 1274.6 | 412.0 |
| 2011-11-09 01:05:00 | ES | Futures | 1274.6 | 1274.85 | 1274.6 | 1274.85 | 307.0 |
| 2011-11-09 01:10:00 | ES | Futures | 1274.85 | 1275.1 | 1274.1 | 1274.1 | 347.0 |
| 2011-11-09 01:15:00 | ES | Futures | 1273.85 | 1274.35 | 1273.6 | 1273.85 | 254.0 |
| 2011-11-09 01:20:00 | ES | Futures | 1273.85 | 1274.85 | 1273.6 | 1274.6 | 265.0 |
| 2011-11-09 01:25:00 | ES | Futures | 1274.6 | 1274.85 | 1274.1 | 1274.1 | 235.0 |
| 2011-11-09 01:30:00 | ES | Futures | 1274.1 | 1274.6 | 1274.1 | 1274.35 | 168.0 |
| 2011-11-09 01:35:00 | ES | Futures | 1274.1 | 1274.6 | 1274.1 | 1274.6 | 63.0 |
| 2011-11-09 01:40:00 | ES | Futures | 1274.6 | 1274.85 | 1274.1 | 1274.6 | 177.0 |
| 2011-11-09 01:45:00 | ES | Futures | 1274.35 | 1274.85 | 1273.85 | 1274.85 | 387.0 |
| 2011-11-09 01:50:00 | ES | Futures | 1274.6 | 1275.36 | 1274.6 | 1275.36 | 291.0 |
| 2011-11-09 01:55:00 | ES | Futures | 1275.1 | 1275.36 | 1274.85 | 1275.1 | 209.0 |
| 2011-11-09 02:00:00 | ES | Futures | 1275.36 | 1276.11 | 1274.6 | 1274.6 | 1394.0 |
| 2011-11-09 02:05:00 | ES | Futures | 1274.6 | 1274.85 | 1273.35 | 1273.35 | 759.0 |
| 2011-11-09 02:10:00 | ES | Futures | 1273.35 | 1273.35 | 1271.34 | 1272.6 | 2438.0 |
| 2011-11-09 02:15:00 | ES | Futures | 1272.35 | 1272.6 | 1271.34 | 1271.59 | 1343.0 |
| 2011-11-09 02:20:00 | ES | Futures | 1271.84 | 1272.35 | 1271.59 | 1271.84 | 614.0 |
| 2011-11-09 02:25:00 | ES | Futures | 1271.84 | 1272.35 | 1269.84 | 1270.84 | 3427.0 |
| 2011-11-09 02:30:00 | ES | Futures | 1270.84 | 1271.59 | 1270.59 | 1271.09 | 1103.0 |
| 2011-11-09 02:35:00 | ES | Futures | 1271.09 | 1271.34 | 1270.84 | 1271.34 | 512.0 |
| 2011-11-09 02:40:00 | ES | Futures | 1271.09 | 1271.34 | 1269.84 | 1270.34 | 1486.0 |
| 2011-11-09 02:45:00 | ES | Futures | 1270.34 | 1271.34 | 1270.34 | 1270.59 | 1671.0 |
| 2011-11-09 02:50:00 | ES | Futures | 1270.59 | 1271.34 | 1270.09 | 1271.09 | 1418.0 |
| 2011-11-09 02:55:00 | ES | Futures | 1270.84 | 1271.59 | 1270.84 | 1271.09 | 1121.0 |
| 2011-11-09 03:00:00 | ES | Futures | 1271.09 | 1272.1 | 1269.84 | 1269.84 | 4019.0 |
| 2011-11-09 03:05:00 | ES | Futures | 1269.84 | 1269.84 | 1267.58 | 1269.59 | 7871.0 |
| 2011-11-09 03:10:00 | ES | Futures | 1269.84 | 1270.59 | 1268.58 | 1270.34 | 3359.0 |
| 2011-11-09 03:15:00 | ES | Futures | 1270.34 | 1270.59 | 1269.34 | 1270.34 | 4008.0 |
| 2011-11-09 03:20:00 | ES | Futures | 1270.09 | 1270.34 | 1269.09 | 1270.09 | 1625.0 |
| 2011-11-09 03:25:00 | ES | Futures | 1270.09 | 1270.09 | 1268.08 | 1269.34 | 1999.0 |
| 2011-11-09 03:30:00 | ES | Futures | 1269.34 | 1269.59 | 1267.58 | 1267.83 | 3937.0 |
| 2011-11-09 03:35:00 | ES | Futures | 1267.83 | 1269.09 | 1267.33 | 1267.83 | 3912.0 |
| 2011-11-09 03:40:00 | ES | Futures | 1268.08 | 1269.09 | 1267.83 | 1268.58 | 2312.0 |
| 2011-11-09 03:45:00 | ES | Futures | 1268.33 | 1269.09 | 1267.58 | 1268.84 | 2600.0 |
| 2011-11-09 03:50:00 | ES | Futures | 1268.84 | 1270.84 | 1268.84 | 1269.84 | 3188.0 |
| 2011-11-09 03:55:00 | ES | Futures | 1270.09 | 1270.59 | 1268.58 | 1269.09 | 2272.0 |
| 2011-11-09 04:00:00 | ES | Futures | 1269.09 | 1269.09 | 1265.83 | 1266.08 | 7595.0 |
| 2011-11-09 04:05:00 | ES | Futures | 1265.83 | 1266.08 | 1259.81 | 1261.56 | 20487.0 |
> showing 50 of 13,735 rows — these rows as CSV