PREVIEW / futures_5min / 2013-07-04
file: by_date/futures_5min/2013/2013-07-04.parquet size: 154 KB rows: 9,220
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-04 00:00:00 | ES | Futures | 1665.48 | 1665.48 | 1664.97 | 1665.22 | 90.0 |
| 2013-07-04 00:05:00 | ES | Futures | 1665.22 | 1665.48 | 1665.22 | 1665.22 | 15.0 |
| 2013-07-04 00:10:00 | ES | Futures | 1664.97 | 1665.22 | 1664.71 | 1664.97 | 170.0 |
| 2013-07-04 00:15:00 | ES | Futures | 1665.22 | 1665.48 | 1665.22 | 1665.48 | 43.0 |
| 2013-07-04 00:20:00 | ES | Futures | 1665.48 | 1665.48 | 1665.48 | 1665.48 | 14.0 |
| 2013-07-04 00:25:00 | ES | Futures | 1665.48 | 1665.48 | 1665.22 | 1665.48 | 13.0 |
| 2013-07-04 00:30:00 | ES | Futures | 1665.22 | 1665.22 | 1665.22 | 1665.22 | 3.0 |
| 2013-07-04 00:35:00 | ES | Futures | 1665.48 | 1665.48 | 1665.22 | 1665.22 | 22.0 |
| 2013-07-04 00:40:00 | ES | Futures | 1665.22 | 1665.48 | 1665.22 | 1665.22 | 73.0 |
| 2013-07-04 00:45:00 | ES | Futures | 1665.22 | 1665.48 | 1665.22 | 1665.22 | 52.0 |
| 2013-07-04 00:50:00 | ES | Futures | 1665.22 | 1665.22 | 1664.97 | 1665.22 | 46.0 |
| 2013-07-04 00:55:00 | ES | Futures | 1665.22 | 1666.77 | 1664.97 | 1666.77 | 1003.0 |
| 2013-07-04 01:00:00 | ES | Futures | 1666.77 | 1666.77 | 1665.48 | 1665.74 | 326.0 |
| 2013-07-04 01:05:00 | ES | Futures | 1665.48 | 1666.0 | 1665.48 | 1666.0 | 46.0 |
| 2013-07-04 01:10:00 | ES | Futures | 1666.0 | 1666.0 | 1664.97 | 1664.97 | 278.0 |
| 2013-07-04 01:15:00 | ES | Futures | 1664.97 | 1665.48 | 1664.71 | 1665.22 | 144.0 |
| 2013-07-04 01:20:00 | ES | Futures | 1665.22 | 1666.0 | 1665.22 | 1666.0 | 217.0 |
| 2013-07-04 01:25:00 | ES | Futures | 1666.0 | 1666.77 | 1666.0 | 1666.77 | 220.0 |
| 2013-07-04 01:30:00 | ES | Futures | 1666.77 | 1667.03 | 1666.52 | 1666.77 | 283.0 |
| 2013-07-04 01:35:00 | ES | Futures | 1666.52 | 1666.77 | 1666.52 | 1666.77 | 90.0 |
| 2013-07-04 01:40:00 | ES | Futures | 1666.77 | 1667.29 | 1666.77 | 1667.29 | 211.0 |
| 2013-07-04 01:45:00 | ES | Futures | 1667.03 | 1667.29 | 1666.77 | 1666.77 | 130.0 |
| 2013-07-04 01:50:00 | ES | Futures | 1667.03 | 1667.03 | 1666.77 | 1667.03 | 66.0 |
| 2013-07-04 01:55:00 | ES | Futures | 1666.77 | 1667.29 | 1666.52 | 1667.03 | 194.0 |
| 2013-07-04 02:00:00 | ES | Futures | 1667.03 | 1668.84 | 1667.03 | 1668.33 | 1975.0 |
| 2013-07-04 02:05:00 | ES | Futures | 1668.07 | 1668.58 | 1667.55 | 1667.81 | 610.0 |
| 2013-07-04 02:10:00 | ES | Futures | 1668.07 | 1668.33 | 1667.55 | 1668.33 | 292.0 |
| 2013-07-04 02:15:00 | ES | Futures | 1668.33 | 1668.58 | 1667.55 | 1667.55 | 621.0 |
| 2013-07-04 02:20:00 | ES | Futures | 1667.55 | 1667.81 | 1667.03 | 1667.03 | 696.0 |
| 2013-07-04 02:25:00 | ES | Futures | 1667.29 | 1667.29 | 1666.26 | 1666.26 | 803.0 |
| 2013-07-04 02:30:00 | ES | Futures | 1666.26 | 1667.03 | 1666.0 | 1666.26 | 505.0 |
| 2013-07-04 02:35:00 | ES | Futures | 1666.52 | 1667.03 | 1666.26 | 1666.77 | 337.0 |
| 2013-07-04 02:40:00 | ES | Futures | 1667.03 | 1667.29 | 1666.77 | 1667.03 | 198.0 |
| 2013-07-04 02:45:00 | ES | Futures | 1667.03 | 1667.03 | 1666.77 | 1667.03 | 234.0 |
| 2013-07-04 02:50:00 | ES | Futures | 1667.29 | 1668.07 | 1667.03 | 1667.29 | 713.0 |
| 2013-07-04 02:55:00 | ES | Futures | 1667.55 | 1668.07 | 1667.55 | 1667.55 | 313.0 |
| 2013-07-04 03:00:00 | ES | Futures | 1667.29 | 1667.81 | 1666.26 | 1666.77 | 1155.0 |
| 2013-07-04 03:05:00 | ES | Futures | 1666.52 | 1668.33 | 1666.26 | 1667.55 | 2216.0 |
| 2013-07-04 03:10:00 | ES | Futures | 1667.55 | 1668.58 | 1667.03 | 1667.29 | 2109.0 |
| 2013-07-04 03:15:00 | ES | Futures | 1667.29 | 1667.55 | 1666.52 | 1667.03 | 999.0 |
| 2013-07-04 03:20:00 | ES | Futures | 1667.29 | 1669.1 | 1667.29 | 1669.1 | 3434.0 |
| 2013-07-04 03:25:00 | ES | Futures | 1669.1 | 1669.62 | 1668.33 | 1669.36 | 1896.0 |
| 2013-07-04 03:30:00 | ES | Futures | 1669.36 | 1669.88 | 1669.1 | 1669.1 | 1569.0 |
| 2013-07-04 03:35:00 | ES | Futures | 1669.36 | 1669.36 | 1668.58 | 1668.84 | 1140.0 |
| 2013-07-04 03:40:00 | ES | Futures | 1668.58 | 1669.36 | 1668.58 | 1669.1 | 527.0 |
| 2013-07-04 03:45:00 | ES | Futures | 1668.84 | 1669.62 | 1668.58 | 1668.58 | 1246.0 |
| 2013-07-04 03:50:00 | ES | Futures | 1668.84 | 1669.1 | 1668.58 | 1668.84 | 861.0 |
| 2013-07-04 03:55:00 | ES | Futures | 1668.58 | 1669.36 | 1668.33 | 1668.84 | 679.0 |
| 2013-07-04 04:00:00 | ES | Futures | 1668.84 | 1669.36 | 1668.33 | 1668.84 | 755.0 |
| 2013-07-04 04:05:00 | ES | Futures | 1668.84 | 1669.36 | 1668.58 | 1668.84 | 598.0 |
> showing 50 of 9,220 rows — these rows as CSV