PREVIEW / futures_5min / 2011-12-09
file: by_date/futures_5min/2011/2011-12-09.parquet size: 210 KB rows: 10,968
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-09 00:00:00 | ES | Futures | 1241.5 | 1241.5 | 1240.0 | 1240.25 | 186.0 |
| 2011-12-09 00:05:00 | ES | Futures | 1240.25 | 1240.5 | 1238.74 | 1239.5 | 657.0 |
| 2011-12-09 00:10:00 | ES | Futures | 1239.75 | 1240.0 | 1239.0 | 1239.0 | 269.0 |
| 2011-12-09 00:15:00 | ES | Futures | 1239.0 | 1239.75 | 1239.0 | 1239.5 | 200.0 |
| 2011-12-09 00:20:00 | ES | Futures | 1239.75 | 1239.75 | 1236.24 | 1237.49 | 726.0 |
| 2011-12-09 00:25:00 | ES | Futures | 1237.49 | 1237.74 | 1236.74 | 1237.49 | 272.0 |
| 2011-12-09 00:30:00 | ES | Futures | 1237.24 | 1237.49 | 1236.99 | 1237.24 | 197.0 |
| 2011-12-09 00:35:00 | ES | Futures | 1237.49 | 1238.74 | 1237.49 | 1238.49 | 204.0 |
| 2011-12-09 00:40:00 | ES | Futures | 1238.49 | 1239.25 | 1238.49 | 1238.74 | 467.0 |
| 2011-12-09 00:45:00 | ES | Futures | 1238.49 | 1239.25 | 1238.24 | 1238.74 | 226.0 |
| 2011-12-09 00:50:00 | ES | Futures | 1238.74 | 1239.0 | 1237.24 | 1237.24 | 533.0 |
| 2011-12-09 00:55:00 | ES | Futures | 1237.24 | 1237.74 | 1236.49 | 1237.49 | 303.0 |
| 2011-12-09 01:00:00 | ES | Futures | 1237.49 | 1237.99 | 1237.24 | 1237.24 | 459.0 |
| 2011-12-09 01:05:00 | ES | Futures | 1237.24 | 1237.99 | 1236.99 | 1236.99 | 177.0 |
| 2011-12-09 01:10:00 | ES | Futures | 1236.99 | 1237.49 | 1236.74 | 1236.99 | 119.0 |
| 2011-12-09 01:15:00 | ES | Futures | 1236.74 | 1237.49 | 1235.99 | 1237.49 | 650.0 |
| 2011-12-09 01:20:00 | ES | Futures | 1237.49 | 1238.74 | 1237.24 | 1237.74 | 1029.0 |
| 2011-12-09 01:25:00 | ES | Futures | 1237.74 | 1239.75 | 1237.24 | 1239.75 | 725.0 |
| 2011-12-09 01:30:00 | ES | Futures | 1240.0 | 1240.0 | 1238.49 | 1238.49 | 210.0 |
| 2011-12-09 01:35:00 | ES | Futures | 1238.74 | 1238.74 | 1237.24 | 1237.99 | 259.0 |
| 2011-12-09 01:40:00 | ES | Futures | 1237.99 | 1238.24 | 1236.49 | 1236.49 | 482.0 |
| 2011-12-09 01:45:00 | ES | Futures | 1236.49 | 1236.49 | 1235.99 | 1236.24 | 241.0 |
| 2011-12-09 01:50:00 | ES | Futures | 1236.24 | 1236.99 | 1235.74 | 1236.99 | 442.0 |
| 2011-12-09 01:55:00 | ES | Futures | 1236.99 | 1236.99 | 1236.24 | 1236.74 | 592.0 |
| 2011-12-09 02:00:00 | ES | Futures | 1236.74 | 1236.99 | 1234.73 | 1234.73 | 1603.0 |
| 2011-12-09 02:05:00 | ES | Futures | 1234.73 | 1234.98 | 1232.23 | 1234.23 | 3823.0 |
| 2011-12-09 02:10:00 | ES | Futures | 1233.98 | 1234.23 | 1232.23 | 1234.23 | 2558.0 |
| 2011-12-09 02:15:00 | ES | Futures | 1234.23 | 1235.74 | 1233.98 | 1234.73 | 1612.0 |
| 2011-12-09 02:20:00 | ES | Futures | 1234.98 | 1235.23 | 1233.23 | 1233.98 | 2444.0 |
| 2011-12-09 02:25:00 | ES | Futures | 1233.73 | 1234.73 | 1233.48 | 1234.23 | 608.0 |
| 2011-12-09 02:30:00 | ES | Futures | 1233.98 | 1235.74 | 1233.48 | 1235.23 | 1255.0 |
| 2011-12-09 02:35:00 | ES | Futures | 1235.23 | 1235.74 | 1234.73 | 1234.73 | 939.0 |
| 2011-12-09 02:40:00 | ES | Futures | 1234.98 | 1234.98 | 1232.98 | 1233.23 | 1243.0 |
| 2011-12-09 02:45:00 | ES | Futures | 1232.98 | 1233.73 | 1232.98 | 1233.73 | 795.0 |
| 2011-12-09 02:50:00 | ES | Futures | 1233.98 | 1234.73 | 1233.73 | 1233.98 | 830.0 |
| 2011-12-09 02:55:00 | ES | Futures | 1233.98 | 1234.98 | 1233.98 | 1234.73 | 1189.0 |
| 2011-12-09 03:00:00 | ES | Futures | 1234.98 | 1236.49 | 1234.73 | 1236.24 | 3458.0 |
| 2011-12-09 03:05:00 | ES | Futures | 1236.24 | 1238.24 | 1236.24 | 1237.74 | 5404.0 |
| 2011-12-09 03:10:00 | ES | Futures | 1237.74 | 1238.74 | 1236.99 | 1237.24 | 3173.0 |
| 2011-12-09 03:15:00 | ES | Futures | 1237.24 | 1239.5 | 1236.99 | 1239.5 | 2034.0 |
| 2011-12-09 03:20:00 | ES | Futures | 1239.5 | 1243.76 | 1239.25 | 1242.51 | 4644.0 |
| 2011-12-09 03:25:00 | ES | Futures | 1242.26 | 1243.01 | 1240.0 | 1242.51 | 3442.0 |
| 2011-12-09 03:30:00 | ES | Futures | 1242.51 | 1244.51 | 1242.26 | 1243.76 | 3117.0 |
| 2011-12-09 03:35:00 | ES | Futures | 1243.76 | 1244.01 | 1241.5 | 1242.51 | 1958.0 |
| 2011-12-09 03:40:00 | ES | Futures | 1242.76 | 1243.76 | 1242.51 | 1243.51 | 1226.0 |
| 2011-12-09 03:45:00 | ES | Futures | 1243.51 | 1244.51 | 1243.01 | 1244.51 | 1845.0 |
| 2011-12-09 03:50:00 | ES | Futures | 1244.26 | 1245.01 | 1242.26 | 1243.01 | 1981.0 |
| 2011-12-09 03:55:00 | ES | Futures | 1243.01 | 1246.27 | 1243.01 | 1245.77 | 2498.0 |
| 2011-12-09 04:00:00 | ES | Futures | 1245.52 | 1246.52 | 1243.26 | 1243.51 | 2248.0 |
| 2011-12-09 04:05:00 | ES | Futures | 1243.26 | 1243.76 | 1242.51 | 1242.51 | 2304.0 |
> showing 50 of 10,968 rows — these rows as CSV