PREVIEW / futures_5min / 2011-08-25
file: by_date/futures_5min/2011/2011-08-25.parquet size: 226 KB rows: 12,413
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-25 00:00:00 | ES | Futures | 1167.47 | 1168.46 | 1167.22 | 1168.46 | 256.0 |
| 2011-08-25 00:05:00 | ES | Futures | 1168.46 | 1168.71 | 1167.97 | 1168.22 | 205.0 |
| 2011-08-25 00:10:00 | ES | Futures | 1168.22 | 1168.22 | 1166.97 | 1166.97 | 245.0 |
| 2011-08-25 00:15:00 | ES | Futures | 1166.97 | 1166.97 | 1166.47 | 1166.47 | 209.0 |
| 2011-08-25 00:20:00 | ES | Futures | 1166.47 | 1167.22 | 1166.22 | 1166.97 | 295.0 |
| 2011-08-25 00:25:00 | ES | Futures | 1166.97 | 1166.97 | 1166.22 | 1166.22 | 153.0 |
| 2011-08-25 00:30:00 | ES | Futures | 1165.97 | 1166.47 | 1165.97 | 1165.97 | 98.0 |
| 2011-08-25 00:35:00 | ES | Futures | 1165.97 | 1166.72 | 1165.72 | 1166.47 | 208.0 |
| 2011-08-25 00:40:00 | ES | Futures | 1166.47 | 1166.72 | 1166.22 | 1166.72 | 103.0 |
| 2011-08-25 00:45:00 | ES | Futures | 1166.47 | 1166.97 | 1166.22 | 1166.47 | 338.0 |
| 2011-08-25 00:50:00 | ES | Futures | 1166.72 | 1166.72 | 1166.47 | 1166.47 | 11.0 |
| 2011-08-25 00:55:00 | ES | Futures | 1166.72 | 1166.72 | 1165.72 | 1165.72 | 225.0 |
| 2011-08-25 01:00:00 | ES | Futures | 1165.47 | 1165.97 | 1165.22 | 1165.22 | 309.0 |
| 2011-08-25 01:05:00 | ES | Futures | 1165.22 | 1165.47 | 1164.72 | 1165.22 | 507.0 |
| 2011-08-25 01:10:00 | ES | Futures | 1165.22 | 1166.22 | 1165.22 | 1166.22 | 311.0 |
| 2011-08-25 01:15:00 | ES | Futures | 1165.97 | 1166.47 | 1165.72 | 1166.47 | 175.0 |
| 2011-08-25 01:20:00 | ES | Futures | 1166.22 | 1166.47 | 1165.72 | 1165.97 | 149.0 |
| 2011-08-25 01:25:00 | ES | Futures | 1165.72 | 1165.97 | 1165.22 | 1165.47 | 623.0 |
| 2011-08-25 01:30:00 | ES | Futures | 1165.47 | 1165.47 | 1164.72 | 1164.97 | 388.0 |
| 2011-08-25 01:35:00 | ES | Futures | 1165.22 | 1165.22 | 1164.47 | 1164.72 | 443.0 |
| 2011-08-25 01:40:00 | ES | Futures | 1164.72 | 1164.97 | 1164.47 | 1164.72 | 343.0 |
| 2011-08-25 01:45:00 | ES | Futures | 1164.72 | 1164.97 | 1164.23 | 1164.47 | 731.0 |
| 2011-08-25 01:50:00 | ES | Futures | 1164.47 | 1164.72 | 1164.23 | 1164.47 | 420.0 |
| 2011-08-25 01:55:00 | ES | Futures | 1164.23 | 1164.47 | 1163.73 | 1163.98 | 599.0 |
| 2011-08-25 02:00:00 | ES | Futures | 1164.23 | 1165.22 | 1163.98 | 1164.47 | 2366.0 |
| 2011-08-25 02:05:00 | ES | Futures | 1164.72 | 1165.97 | 1164.47 | 1165.72 | 1031.0 |
| 2011-08-25 02:10:00 | ES | Futures | 1165.72 | 1166.22 | 1165.72 | 1165.97 | 1171.0 |
| 2011-08-25 02:15:00 | ES | Futures | 1165.97 | 1166.47 | 1165.72 | 1166.47 | 1155.0 |
| 2011-08-25 02:20:00 | ES | Futures | 1166.47 | 1166.97 | 1166.22 | 1166.22 | 1353.0 |
| 2011-08-25 02:25:00 | ES | Futures | 1166.22 | 1168.22 | 1166.22 | 1167.97 | 1614.0 |
| 2011-08-25 02:30:00 | ES | Futures | 1167.72 | 1168.71 | 1167.72 | 1168.46 | 851.0 |
| 2011-08-25 02:35:00 | ES | Futures | 1168.46 | 1169.96 | 1167.97 | 1169.96 | 2892.0 |
| 2011-08-25 02:40:00 | ES | Futures | 1169.96 | 1170.21 | 1169.46 | 1169.96 | 1022.0 |
| 2011-08-25 02:45:00 | ES | Futures | 1169.96 | 1169.96 | 1168.96 | 1169.71 | 1505.0 |
| 2011-08-25 02:50:00 | ES | Futures | 1169.71 | 1169.96 | 1169.21 | 1169.71 | 1625.0 |
| 2011-08-25 02:55:00 | ES | Futures | 1169.46 | 1170.21 | 1169.21 | 1169.71 | 2181.0 |
| 2011-08-25 03:00:00 | ES | Futures | 1169.46 | 1170.71 | 1168.96 | 1170.21 | 3723.0 |
| 2011-08-25 03:05:00 | ES | Futures | 1170.21 | 1172.21 | 1169.71 | 1171.96 | 6920.0 |
| 2011-08-25 03:10:00 | ES | Futures | 1171.96 | 1173.45 | 1170.96 | 1171.21 | 8459.0 |
| 2011-08-25 03:15:00 | ES | Futures | 1171.21 | 1171.71 | 1170.71 | 1171.21 | 2759.0 |
| 2011-08-25 03:20:00 | ES | Futures | 1171.46 | 1173.2 | 1171.21 | 1171.71 | 4071.0 |
| 2011-08-25 03:25:00 | ES | Futures | 1171.71 | 1172.7 | 1171.46 | 1171.96 | 3646.0 |
| 2011-08-25 03:30:00 | ES | Futures | 1172.21 | 1173.45 | 1171.96 | 1172.95 | 4425.0 |
| 2011-08-25 03:35:00 | ES | Futures | 1173.2 | 1173.2 | 1171.71 | 1171.96 | 3360.0 |
| 2011-08-25 03:40:00 | ES | Futures | 1171.96 | 1172.46 | 1171.21 | 1171.96 | 3069.0 |
| 2011-08-25 03:45:00 | ES | Futures | 1171.96 | 1171.96 | 1169.46 | 1170.71 | 5140.0 |
| 2011-08-25 03:50:00 | ES | Futures | 1170.71 | 1172.21 | 1169.71 | 1170.46 | 5643.0 |
| 2011-08-25 03:55:00 | ES | Futures | 1170.46 | 1171.71 | 1169.71 | 1169.96 | 5125.0 |
| 2011-08-25 04:00:00 | ES | Futures | 1169.96 | 1171.21 | 1169.96 | 1170.46 | 3084.0 |
| 2011-08-25 04:05:00 | ES | Futures | 1170.71 | 1171.96 | 1169.96 | 1170.46 | 1962.0 |
> showing 50 of 12,413 rows — these rows as CSV