PREVIEW / futures_5min / 2011-12-30
file: by_date/futures_5min/2011/2011-12-30.parquet size: 166 KB rows: 9,599
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-12-30 00:00:00 | ES | Futures | 1264.48 | 1264.73 | 1264.22 | 1264.48 | 94.0 |
| 2011-12-30 00:05:00 | ES | Futures | 1264.48 | 1264.48 | 1263.97 | 1264.48 | 112.0 |
| 2011-12-30 00:10:00 | ES | Futures | 1264.48 | 1264.48 | 1264.22 | 1264.48 | 37.0 |
| 2011-12-30 00:15:00 | ES | Futures | 1264.48 | 1264.48 | 1264.22 | 1264.48 | 41.0 |
| 2011-12-30 00:20:00 | ES | Futures | 1264.48 | 1264.73 | 1264.22 | 1264.48 | 64.0 |
| 2011-12-30 00:25:00 | ES | Futures | 1264.73 | 1264.73 | 1264.22 | 1264.48 | 47.0 |
| 2011-12-30 00:30:00 | ES | Futures | 1264.22 | 1264.73 | 1263.97 | 1264.73 | 224.0 |
| 2011-12-30 00:35:00 | ES | Futures | 1264.48 | 1264.98 | 1264.22 | 1264.22 | 100.0 |
| 2011-12-30 00:40:00 | ES | Futures | 1264.22 | 1264.73 | 1264.22 | 1264.48 | 109.0 |
| 2011-12-30 00:45:00 | ES | Futures | 1264.22 | 1264.98 | 1263.97 | 1264.48 | 320.0 |
| 2011-12-30 00:50:00 | ES | Futures | 1264.48 | 1264.73 | 1264.48 | 1264.73 | 98.0 |
| 2011-12-30 00:55:00 | ES | Futures | 1264.48 | 1264.98 | 1264.48 | 1264.48 | 106.0 |
| 2011-12-30 01:00:00 | ES | Futures | 1264.48 | 1264.98 | 1264.48 | 1264.98 | 172.0 |
| 2011-12-30 01:05:00 | ES | Futures | 1264.98 | 1264.98 | 1264.73 | 1264.73 | 64.0 |
| 2011-12-30 01:10:00 | ES | Futures | 1264.73 | 1264.73 | 1264.48 | 1264.73 | 84.0 |
| 2011-12-30 01:15:00 | ES | Futures | 1264.73 | 1264.73 | 1264.48 | 1264.48 | 24.0 |
| 2011-12-30 01:20:00 | ES | Futures | 1264.73 | 1264.73 | 1264.73 | 1264.73 | 39.0 |
| 2011-12-30 01:25:00 | ES | Futures | 1264.48 | 1264.98 | 1264.48 | 1264.98 | 246.0 |
| 2011-12-30 01:30:00 | ES | Futures | 1264.98 | 1265.99 | 1264.73 | 1265.99 | 953.0 |
| 2011-12-30 01:35:00 | ES | Futures | 1265.74 | 1266.24 | 1265.74 | 1265.99 | 92.0 |
| 2011-12-30 01:40:00 | ES | Futures | 1265.99 | 1266.74 | 1265.99 | 1266.74 | 254.0 |
| 2011-12-30 01:45:00 | ES | Futures | 1266.74 | 1267.25 | 1266.74 | 1267.0 | 313.0 |
| 2011-12-30 01:50:00 | ES | Futures | 1267.25 | 1267.5 | 1267.25 | 1267.25 | 228.0 |
| 2011-12-30 01:55:00 | ES | Futures | 1267.25 | 1267.5 | 1267.25 | 1267.25 | 246.0 |
| 2011-12-30 02:00:00 | ES | Futures | 1267.25 | 1269.01 | 1267.25 | 1269.01 | 1489.0 |
| 2011-12-30 02:05:00 | ES | Futures | 1268.76 | 1269.52 | 1268.76 | 1269.01 | 482.0 |
| 2011-12-30 02:10:00 | ES | Futures | 1268.76 | 1269.01 | 1268.51 | 1268.76 | 248.0 |
| 2011-12-30 02:15:00 | ES | Futures | 1268.76 | 1268.76 | 1267.75 | 1267.75 | 909.0 |
| 2011-12-30 02:20:00 | ES | Futures | 1268.0 | 1268.26 | 1267.75 | 1268.26 | 117.0 |
| 2011-12-30 02:25:00 | ES | Futures | 1268.26 | 1268.26 | 1267.75 | 1268.0 | 297.0 |
| 2011-12-30 02:30:00 | ES | Futures | 1267.75 | 1268.26 | 1267.5 | 1267.75 | 227.0 |
| 2011-12-30 02:35:00 | ES | Futures | 1267.75 | 1268.26 | 1267.75 | 1267.75 | 192.0 |
| 2011-12-30 02:40:00 | ES | Futures | 1268.0 | 1268.0 | 1267.25 | 1267.5 | 377.0 |
| 2011-12-30 02:45:00 | ES | Futures | 1267.25 | 1267.75 | 1267.25 | 1267.5 | 142.0 |
| 2011-12-30 02:50:00 | ES | Futures | 1267.5 | 1267.75 | 1267.0 | 1267.0 | 517.0 |
| 2011-12-30 02:55:00 | ES | Futures | 1267.0 | 1267.5 | 1266.74 | 1267.5 | 503.0 |
| 2011-12-30 03:00:00 | ES | Futures | 1267.5 | 1269.01 | 1267.25 | 1268.0 | 2146.0 |
| 2011-12-30 03:05:00 | ES | Futures | 1268.0 | 1268.26 | 1267.0 | 1267.5 | 2102.0 |
| 2011-12-30 03:10:00 | ES | Futures | 1267.5 | 1267.5 | 1266.24 | 1266.74 | 1378.0 |
| 2011-12-30 03:15:00 | ES | Futures | 1266.74 | 1267.5 | 1266.49 | 1266.74 | 761.0 |
| 2011-12-30 03:20:00 | ES | Futures | 1266.74 | 1266.74 | 1265.23 | 1266.74 | 2200.0 |
| 2011-12-30 03:25:00 | ES | Futures | 1266.49 | 1266.74 | 1265.23 | 1265.48 | 2058.0 |
| 2011-12-30 03:30:00 | ES | Futures | 1265.23 | 1266.24 | 1264.48 | 1265.74 | 2715.0 |
| 2011-12-30 03:35:00 | ES | Futures | 1265.74 | 1266.49 | 1265.23 | 1266.49 | 1902.0 |
| 2011-12-30 03:40:00 | ES | Futures | 1266.49 | 1266.74 | 1265.23 | 1265.74 | 2660.0 |
| 2011-12-30 03:45:00 | ES | Futures | 1265.74 | 1265.74 | 1264.98 | 1265.48 | 1219.0 |
| 2011-12-30 03:50:00 | ES | Futures | 1265.48 | 1265.74 | 1264.98 | 1265.23 | 1212.0 |
| 2011-12-30 03:55:00 | ES | Futures | 1265.48 | 1266.49 | 1264.98 | 1265.99 | 789.0 |
| 2011-12-30 04:00:00 | ES | Futures | 1265.99 | 1267.5 | 1265.74 | 1266.74 | 1952.0 |
| 2011-12-30 04:05:00 | ES | Futures | 1266.74 | 1266.74 | 1265.74 | 1266.24 | 1255.0 |
> showing 50 of 9,599 rows — these rows as CSV