PREVIEW / futures_5min / 2011-12-13
file: by_date/futures_5min/2011/2011-12-13.parquet size: 223 KB rows: 12,631
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-13 00:00:00 | ES | Futures | 1241.5 | 1241.75 | 1239.0 | 1239.0 | 348.0 |
| 2011-12-13 00:05:00 | ES | Futures | 1239.25 | 1239.5 | 1238.74 | 1239.5 | 51.0 |
| 2011-12-13 00:10:00 | ES | Futures | 1239.5 | 1240.0 | 1238.74 | 1238.74 | 180.0 |
| 2011-12-13 00:15:00 | ES | Futures | 1239.0 | 1239.0 | 1238.74 | 1239.0 | 35.0 |
| 2011-12-13 00:20:00 | ES | Futures | 1239.0 | 1239.0 | 1238.74 | 1239.0 | 81.0 |
| 2011-12-13 00:25:00 | ES | Futures | 1239.0 | 1239.0 | 1237.99 | 1238.24 | 250.0 |
| 2011-12-13 00:30:00 | ES | Futures | 1237.99 | 1239.0 | 1237.99 | 1238.74 | 205.0 |
| 2011-12-13 00:35:00 | ES | Futures | 1238.74 | 1239.25 | 1238.74 | 1239.25 | 44.0 |
| 2011-12-13 00:40:00 | ES | Futures | 1239.5 | 1239.5 | 1239.25 | 1239.25 | 16.0 |
| 2011-12-13 00:45:00 | ES | Futures | 1239.5 | 1239.5 | 1239.25 | 1239.25 | 26.0 |
| 2011-12-13 00:50:00 | ES | Futures | 1239.25 | 1239.5 | 1238.74 | 1238.74 | 99.0 |
| 2011-12-13 00:55:00 | ES | Futures | 1239.0 | 1239.75 | 1239.0 | 1239.75 | 55.0 |
| 2011-12-13 01:00:00 | ES | Futures | 1239.75 | 1239.75 | 1238.74 | 1238.74 | 164.0 |
| 2011-12-13 01:05:00 | ES | Futures | 1238.74 | 1238.74 | 1238.24 | 1238.74 | 143.0 |
| 2011-12-13 01:10:00 | ES | Futures | 1238.74 | 1238.74 | 1238.49 | 1238.74 | 65.0 |
| 2011-12-13 01:15:00 | ES | Futures | 1239.0 | 1239.5 | 1239.0 | 1239.25 | 110.0 |
| 2011-12-13 01:20:00 | ES | Futures | 1239.25 | 1239.5 | 1239.25 | 1239.5 | 5.0 |
| 2011-12-13 01:25:00 | ES | Futures | 1239.25 | 1239.75 | 1239.0 | 1239.75 | 26.0 |
| 2011-12-13 01:30:00 | ES | Futures | 1239.75 | 1240.0 | 1239.75 | 1240.0 | 120.0 |
| 2011-12-13 01:35:00 | ES | Futures | 1239.75 | 1240.0 | 1239.75 | 1240.0 | 38.0 |
| 2011-12-13 01:40:00 | ES | Futures | 1240.0 | 1240.5 | 1239.75 | 1240.0 | 179.0 |
| 2011-12-13 01:45:00 | ES | Futures | 1240.25 | 1240.25 | 1239.75 | 1239.75 | 28.0 |
| 2011-12-13 01:50:00 | ES | Futures | 1240.0 | 1241.25 | 1239.75 | 1241.0 | 125.0 |
| 2011-12-13 01:55:00 | ES | Futures | 1241.0 | 1241.25 | 1241.0 | 1241.25 | 33.0 |
| 2011-12-13 02:00:00 | ES | Futures | 1241.25 | 1241.5 | 1240.75 | 1241.25 | 207.0 |
| 2011-12-13 02:05:00 | ES | Futures | 1241.25 | 1241.5 | 1240.75 | 1241.0 | 46.0 |
| 2011-12-13 02:10:00 | ES | Futures | 1241.0 | 1241.0 | 1240.0 | 1240.75 | 416.0 |
| 2011-12-13 02:15:00 | ES | Futures | 1240.75 | 1240.75 | 1240.0 | 1240.25 | 192.0 |
| 2011-12-13 02:20:00 | ES | Futures | 1240.5 | 1240.5 | 1239.75 | 1240.25 | 190.0 |
| 2011-12-13 02:25:00 | ES | Futures | 1240.25 | 1240.25 | 1238.49 | 1238.74 | 185.0 |
| 2011-12-13 02:30:00 | ES | Futures | 1238.74 | 1239.0 | 1238.24 | 1239.0 | 154.0 |
| 2011-12-13 02:35:00 | ES | Futures | 1239.0 | 1239.5 | 1238.74 | 1239.25 | 144.0 |
| 2011-12-13 02:40:00 | ES | Futures | 1239.5 | 1240.0 | 1239.25 | 1239.75 | 442.0 |
| 2011-12-13 02:45:00 | ES | Futures | 1239.5 | 1241.25 | 1239.5 | 1241.0 | 379.0 |
| 2011-12-13 02:50:00 | ES | Futures | 1241.0 | 1241.75 | 1240.5 | 1241.5 | 264.0 |
| 2011-12-13 02:55:00 | ES | Futures | 1241.5 | 1242.26 | 1241.5 | 1241.75 | 661.0 |
| 2011-12-13 03:00:00 | ES | Futures | 1241.75 | 1243.26 | 1240.5 | 1242.51 | 902.0 |
| 2011-12-13 03:05:00 | ES | Futures | 1242.26 | 1242.26 | 1240.25 | 1240.25 | 1406.0 |
| 2011-12-13 03:10:00 | ES | Futures | 1240.5 | 1243.26 | 1239.75 | 1243.26 | 970.0 |
| 2011-12-13 03:15:00 | ES | Futures | 1243.26 | 1245.26 | 1243.26 | 1244.51 | 1389.0 |
| 2011-12-13 03:20:00 | ES | Futures | 1244.26 | 1244.76 | 1243.76 | 1244.26 | 816.0 |
| 2011-12-13 03:25:00 | ES | Futures | 1244.26 | 1244.51 | 1241.75 | 1242.0 | 899.0 |
| 2011-12-13 03:30:00 | ES | Futures | 1242.0 | 1243.01 | 1241.75 | 1242.51 | 874.0 |
| 2011-12-13 03:35:00 | ES | Futures | 1242.51 | 1243.51 | 1242.51 | 1243.26 | 293.0 |
| 2011-12-13 03:40:00 | ES | Futures | 1243.01 | 1243.01 | 1241.5 | 1241.5 | 1466.0 |
| 2011-12-13 03:45:00 | ES | Futures | 1241.25 | 1242.0 | 1240.5 | 1241.25 | 723.0 |
| 2011-12-13 03:50:00 | ES | Futures | 1241.25 | 1241.75 | 1240.75 | 1241.5 | 649.0 |
| 2011-12-13 03:55:00 | ES | Futures | 1241.0 | 1241.0 | 1237.49 | 1240.0 | 1943.0 |
| 2011-12-13 04:00:00 | ES | Futures | 1240.0 | 1240.0 | 1237.99 | 1237.99 | 630.0 |
| 2011-12-13 04:05:00 | ES | Futures | 1238.24 | 1240.25 | 1237.99 | 1238.49 | 726.0 |
> showing 50 of 12,631 rows — these rows as CSV