PREVIEW / futures_5min / 2011-01-31
file: by_date/futures_5min/2011/2011-01-31.parquet size: 228 KB rows: 13,505
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-01-31 00:00:00 | ES | Futures | 1261.38 | 1261.38 | 1260.89 | 1260.89 | 174.0 |
| 2011-01-31 00:05:00 | ES | Futures | 1261.14 | 1261.38 | 1260.89 | 1261.14 | 138.0 |
| 2011-01-31 00:10:00 | ES | Futures | 1260.89 | 1260.89 | 1260.39 | 1260.64 | 447.0 |
| 2011-01-31 00:15:00 | ES | Futures | 1260.64 | 1260.89 | 1260.39 | 1260.39 | 264.0 |
| 2011-01-31 00:20:00 | ES | Futures | 1260.39 | 1260.89 | 1260.39 | 1260.89 | 239.0 |
| 2011-01-31 00:25:00 | ES | Futures | 1260.89 | 1260.89 | 1260.64 | 1260.64 | 322.0 |
| 2011-01-31 00:30:00 | ES | Futures | 1260.64 | 1260.89 | 1260.39 | 1260.89 | 107.0 |
| 2011-01-31 00:35:00 | ES | Futures | 1260.89 | 1260.89 | 1260.39 | 1260.39 | 172.0 |
| 2011-01-31 00:40:00 | ES | Futures | 1260.64 | 1260.89 | 1260.64 | 1260.64 | 66.0 |
| 2011-01-31 00:45:00 | ES | Futures | 1260.64 | 1261.88 | 1260.64 | 1261.63 | 841.0 |
| 2011-01-31 00:50:00 | ES | Futures | 1261.38 | 1261.63 | 1261.14 | 1261.14 | 316.0 |
| 2011-01-31 00:55:00 | ES | Futures | 1261.14 | 1261.88 | 1259.65 | 1261.63 | 1928.0 |
| 2011-01-31 01:00:00 | ES | Futures | 1261.38 | 1261.38 | 1260.15 | 1260.15 | 464.0 |
| 2011-01-31 01:05:00 | ES | Futures | 1260.39 | 1260.89 | 1260.15 | 1260.89 | 258.0 |
| 2011-01-31 01:10:00 | ES | Futures | 1260.89 | 1260.89 | 1259.9 | 1259.9 | 443.0 |
| 2011-01-31 01:15:00 | ES | Futures | 1259.9 | 1260.64 | 1259.9 | 1260.15 | 306.0 |
| 2011-01-31 01:20:00 | ES | Futures | 1260.15 | 1260.64 | 1260.15 | 1260.15 | 105.0 |
| 2011-01-31 01:25:00 | ES | Futures | 1260.15 | 1260.39 | 1260.15 | 1260.15 | 116.0 |
| 2011-01-31 01:30:00 | ES | Futures | 1260.15 | 1260.39 | 1259.9 | 1260.15 | 76.0 |
| 2011-01-31 01:35:00 | ES | Futures | 1260.15 | 1260.89 | 1260.15 | 1260.89 | 420.0 |
| 2011-01-31 01:40:00 | ES | Futures | 1260.64 | 1260.89 | 1260.64 | 1260.89 | 148.0 |
| 2011-01-31 01:45:00 | ES | Futures | 1260.89 | 1260.89 | 1260.64 | 1260.64 | 68.0 |
| 2011-01-31 01:50:00 | ES | Futures | 1260.64 | 1260.89 | 1260.39 | 1260.64 | 129.0 |
| 2011-01-31 01:55:00 | ES | Futures | 1260.64 | 1260.64 | 1260.39 | 1260.64 | 150.0 |
| 2011-01-31 02:00:00 | ES | Futures | 1260.39 | 1260.64 | 1260.15 | 1260.39 | 571.0 |
| 2011-01-31 02:05:00 | ES | Futures | 1260.39 | 1260.64 | 1260.15 | 1260.64 | 461.0 |
| 2011-01-31 02:10:00 | ES | Futures | 1260.39 | 1260.39 | 1259.65 | 1260.15 | 1072.0 |
| 2011-01-31 02:15:00 | ES | Futures | 1260.15 | 1260.39 | 1259.4 | 1259.65 | 1557.0 |
| 2011-01-31 02:20:00 | ES | Futures | 1259.9 | 1260.15 | 1259.9 | 1259.9 | 289.0 |
| 2011-01-31 02:25:00 | ES | Futures | 1259.9 | 1260.15 | 1259.65 | 1259.9 | 653.0 |
| 2011-01-31 02:30:00 | ES | Futures | 1259.9 | 1261.14 | 1259.9 | 1261.14 | 1254.0 |
| 2011-01-31 02:35:00 | ES | Futures | 1260.89 | 1261.14 | 1259.9 | 1260.64 | 1138.0 |
| 2011-01-31 02:40:00 | ES | Futures | 1260.64 | 1261.14 | 1260.39 | 1261.14 | 703.0 |
| 2011-01-31 02:45:00 | ES | Futures | 1261.14 | 1261.38 | 1260.39 | 1261.14 | 1084.0 |
| 2011-01-31 02:50:00 | ES | Futures | 1261.14 | 1261.88 | 1261.14 | 1261.63 | 1739.0 |
| 2011-01-31 02:55:00 | ES | Futures | 1261.63 | 1261.63 | 1260.64 | 1260.64 | 2586.0 |
| 2011-01-31 03:00:00 | ES | Futures | 1260.64 | 1261.14 | 1260.15 | 1261.14 | 3289.0 |
| 2011-01-31 03:05:00 | ES | Futures | 1260.89 | 1261.38 | 1259.65 | 1259.65 | 2945.0 |
| 2011-01-31 03:10:00 | ES | Futures | 1259.65 | 1260.15 | 1259.16 | 1259.9 | 2578.0 |
| 2011-01-31 03:15:00 | ES | Futures | 1259.9 | 1260.15 | 1258.41 | 1258.66 | 3068.0 |
| 2011-01-31 03:20:00 | ES | Futures | 1258.66 | 1259.16 | 1258.41 | 1258.91 | 2210.0 |
| 2011-01-31 03:25:00 | ES | Futures | 1258.91 | 1259.4 | 1258.66 | 1259.16 | 2063.0 |
| 2011-01-31 03:30:00 | ES | Futures | 1259.16 | 1259.16 | 1256.93 | 1257.18 | 6510.0 |
| 2011-01-31 03:35:00 | ES | Futures | 1257.18 | 1257.18 | 1255.44 | 1256.43 | 5700.0 |
| 2011-01-31 03:40:00 | ES | Futures | 1256.43 | 1257.18 | 1255.69 | 1255.69 | 3457.0 |
| 2011-01-31 03:45:00 | ES | Futures | 1255.94 | 1256.19 | 1255.2 | 1255.69 | 3588.0 |
| 2011-01-31 03:50:00 | ES | Futures | 1255.69 | 1255.69 | 1254.46 | 1254.7 | 3910.0 |
| 2011-01-31 03:55:00 | ES | Futures | 1254.7 | 1256.19 | 1254.7 | 1255.69 | 2832.0 |
| 2011-01-31 04:00:00 | ES | Futures | 1255.94 | 1257.18 | 1255.69 | 1256.93 | 2737.0 |
| 2011-01-31 04:05:00 | ES | Futures | 1256.93 | 1257.42 | 1256.43 | 1257.18 | 2698.0 |
> showing 50 of 13,505 rows — these rows as CSV