PREVIEW / futures_5min / 2011-08-03
file: by_date/futures_5min/2011/2011-08-03.parquet size: 250 KB rows: 13,576
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-08-03 00:00:00 | ES | Futures | 1245.28 | 1245.53 | 1244.53 | 1244.78 | 845.0 |
| 2011-08-03 00:05:00 | ES | Futures | 1245.03 | 1245.53 | 1244.53 | 1245.28 | 461.0 |
| 2011-08-03 00:10:00 | ES | Futures | 1245.53 | 1245.78 | 1245.28 | 1245.53 | 101.0 |
| 2011-08-03 00:15:00 | ES | Futures | 1245.53 | 1246.28 | 1245.53 | 1246.03 | 372.0 |
| 2011-08-03 00:20:00 | ES | Futures | 1246.03 | 1246.28 | 1245.78 | 1246.03 | 240.0 |
| 2011-08-03 00:25:00 | ES | Futures | 1246.03 | 1246.03 | 1245.78 | 1245.78 | 64.0 |
| 2011-08-03 00:30:00 | ES | Futures | 1246.03 | 1246.03 | 1245.53 | 1245.78 | 151.0 |
| 2011-08-03 00:35:00 | ES | Futures | 1245.78 | 1246.28 | 1245.78 | 1246.03 | 310.0 |
| 2011-08-03 00:40:00 | ES | Futures | 1246.03 | 1246.28 | 1246.03 | 1246.28 | 114.0 |
| 2011-08-03 00:45:00 | ES | Futures | 1246.28 | 1246.28 | 1246.03 | 1246.28 | 306.0 |
| 2011-08-03 00:50:00 | ES | Futures | 1246.28 | 1246.28 | 1246.03 | 1246.03 | 264.0 |
| 2011-08-03 00:55:00 | ES | Futures | 1245.78 | 1245.78 | 1245.28 | 1245.53 | 249.0 |
| 2011-08-03 01:00:00 | ES | Futures | 1245.78 | 1245.78 | 1245.53 | 1245.78 | 108.0 |
| 2011-08-03 01:05:00 | ES | Futures | 1245.53 | 1245.78 | 1245.53 | 1245.78 | 185.0 |
| 2011-08-03 01:10:00 | ES | Futures | 1245.78 | 1245.78 | 1245.28 | 1245.53 | 111.0 |
| 2011-08-03 01:15:00 | ES | Futures | 1245.53 | 1245.53 | 1245.28 | 1245.53 | 104.0 |
| 2011-08-03 01:20:00 | ES | Futures | 1245.28 | 1245.53 | 1245.28 | 1245.28 | 180.0 |
| 2011-08-03 01:25:00 | ES | Futures | 1245.28 | 1245.28 | 1245.03 | 1245.03 | 294.0 |
| 2011-08-03 01:30:00 | ES | Futures | 1245.03 | 1245.03 | 1244.53 | 1244.53 | 356.0 |
| 2011-08-03 01:35:00 | ES | Futures | 1244.78 | 1245.03 | 1244.53 | 1244.53 | 263.0 |
| 2011-08-03 01:40:00 | ES | Futures | 1244.53 | 1244.78 | 1244.28 | 1244.53 | 238.0 |
| 2011-08-03 01:45:00 | ES | Futures | 1244.28 | 1244.78 | 1244.28 | 1244.78 | 244.0 |
| 2011-08-03 01:50:00 | ES | Futures | 1245.03 | 1245.53 | 1245.03 | 1245.28 | 1162.0 |
| 2011-08-03 01:55:00 | ES | Futures | 1245.53 | 1245.78 | 1245.28 | 1245.28 | 565.0 |
| 2011-08-03 02:00:00 | ES | Futures | 1245.53 | 1246.53 | 1245.28 | 1246.53 | 3041.0 |
| 2011-08-03 02:05:00 | ES | Futures | 1246.28 | 1246.78 | 1246.03 | 1246.28 | 1959.0 |
| 2011-08-03 02:10:00 | ES | Futures | 1246.03 | 1247.03 | 1245.78 | 1246.53 | 3448.0 |
| 2011-08-03 02:15:00 | ES | Futures | 1246.53 | 1246.78 | 1246.28 | 1246.28 | 1486.0 |
| 2011-08-03 02:20:00 | ES | Futures | 1246.28 | 1246.78 | 1245.03 | 1245.53 | 4898.0 |
| 2011-08-03 02:25:00 | ES | Futures | 1245.53 | 1246.03 | 1245.28 | 1245.53 | 1467.0 |
| 2011-08-03 02:30:00 | ES | Futures | 1245.53 | 1246.03 | 1245.28 | 1245.78 | 1104.0 |
| 2011-08-03 02:35:00 | ES | Futures | 1245.78 | 1246.03 | 1244.53 | 1244.78 | 1994.0 |
| 2011-08-03 02:40:00 | ES | Futures | 1244.78 | 1245.28 | 1244.28 | 1245.03 | 2096.0 |
| 2011-08-03 02:45:00 | ES | Futures | 1245.28 | 1245.28 | 1243.04 | 1243.29 | 4367.0 |
| 2011-08-03 02:50:00 | ES | Futures | 1243.29 | 1243.29 | 1241.29 | 1241.54 | 5610.0 |
| 2011-08-03 02:55:00 | ES | Futures | 1241.54 | 1244.28 | 1241.54 | 1244.03 | 4400.0 |
| 2011-08-03 03:00:00 | ES | Futures | 1244.03 | 1246.78 | 1243.79 | 1245.78 | 11908.0 |
| 2011-08-03 03:05:00 | ES | Futures | 1245.78 | 1248.27 | 1245.78 | 1247.28 | 12724.0 |
| 2011-08-03 03:10:00 | ES | Futures | 1247.28 | 1247.53 | 1244.53 | 1244.78 | 8826.0 |
| 2011-08-03 03:15:00 | ES | Futures | 1244.78 | 1244.78 | 1242.54 | 1243.54 | 9278.0 |
| 2011-08-03 03:20:00 | ES | Futures | 1243.54 | 1245.28 | 1243.29 | 1245.03 | 4411.0 |
| 2011-08-03 03:25:00 | ES | Futures | 1244.78 | 1247.53 | 1244.78 | 1246.03 | 7406.0 |
| 2011-08-03 03:30:00 | ES | Futures | 1246.03 | 1248.77 | 1246.03 | 1248.03 | 8829.0 |
| 2011-08-03 03:35:00 | ES | Futures | 1248.27 | 1251.52 | 1248.03 | 1251.02 | 16623.0 |
| 2011-08-03 03:40:00 | ES | Futures | 1251.02 | 1252.51 | 1250.52 | 1252.51 | 12213.0 |
| 2011-08-03 03:45:00 | ES | Futures | 1252.27 | 1253.76 | 1251.77 | 1252.51 | 8044.0 |
| 2011-08-03 03:50:00 | ES | Futures | 1252.51 | 1252.76 | 1250.77 | 1251.52 | 4454.0 |
| 2011-08-03 03:55:00 | ES | Futures | 1251.27 | 1251.52 | 1250.27 | 1250.77 | 4120.0 |
| 2011-08-03 04:00:00 | ES | Futures | 1251.02 | 1252.02 | 1250.52 | 1251.77 | 4758.0 |
| 2011-08-03 04:05:00 | ES | Futures | 1251.77 | 1253.01 | 1251.77 | 1252.51 | 3638.0 |
> showing 50 of 13,576 rows — these rows as CSV