PREVIEW / futures_5min / 2013-09-01
file: by_date/futures_5min/2013/2013-09-01.parquet size: 40 KB rows: 1,897
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-09-01 18:00:00 | ES | Futures | 1695.98 | 1696.76 | 1694.69 | 1696.5 | 6172.0 |
| 2013-09-01 18:05:00 | ES | Futures | 1696.5 | 1697.79 | 1695.73 | 1697.28 | 2203.0 |
| 2013-09-01 18:10:00 | ES | Futures | 1697.28 | 1697.54 | 1695.73 | 1695.98 | 2418.0 |
| 2013-09-01 18:15:00 | ES | Futures | 1695.98 | 1696.5 | 1695.21 | 1695.98 | 1591.0 |
| 2013-09-01 18:20:00 | ES | Futures | 1695.73 | 1697.02 | 1695.73 | 1695.98 | 1105.0 |
| 2013-09-01 18:25:00 | ES | Futures | 1695.98 | 1696.76 | 1695.47 | 1696.24 | 1100.0 |
| 2013-09-01 18:30:00 | ES | Futures | 1695.98 | 1697.79 | 1695.73 | 1697.54 | 1400.0 |
| 2013-09-01 18:35:00 | ES | Futures | 1697.28 | 1697.79 | 1696.24 | 1696.5 | 901.0 |
| 2013-09-01 18:40:00 | ES | Futures | 1696.5 | 1697.54 | 1696.5 | 1697.28 | 1584.0 |
| 2013-09-01 18:45:00 | ES | Futures | 1697.54 | 1697.79 | 1697.28 | 1697.28 | 726.0 |
| 2013-09-01 18:50:00 | ES | Futures | 1697.28 | 1697.28 | 1696.76 | 1697.02 | 195.0 |
| 2013-09-01 18:55:00 | ES | Futures | 1697.02 | 1697.79 | 1697.02 | 1697.54 | 397.0 |
| 2013-09-01 19:00:00 | ES | Futures | 1697.28 | 1697.54 | 1697.02 | 1697.02 | 146.0 |
| 2013-09-01 19:05:00 | ES | Futures | 1697.28 | 1697.54 | 1696.5 | 1696.76 | 970.0 |
| 2013-09-01 19:10:00 | ES | Futures | 1696.76 | 1696.76 | 1696.24 | 1696.5 | 538.0 |
| 2013-09-01 19:15:00 | ES | Futures | 1696.5 | 1697.02 | 1696.24 | 1696.76 | 495.0 |
| 2013-09-01 19:20:00 | ES | Futures | 1697.02 | 1697.02 | 1696.5 | 1696.76 | 112.0 |
| 2013-09-01 19:25:00 | ES | Futures | 1696.5 | 1696.76 | 1696.5 | 1696.76 | 44.0 |
| 2013-09-01 19:30:00 | ES | Futures | 1696.5 | 1696.76 | 1696.5 | 1696.5 | 38.0 |
| 2013-09-01 19:35:00 | ES | Futures | 1696.5 | 1697.02 | 1696.24 | 1696.5 | 167.0 |
| 2013-09-01 19:40:00 | ES | Futures | 1696.5 | 1696.5 | 1696.24 | 1696.5 | 70.0 |
| 2013-09-01 19:45:00 | ES | Futures | 1696.5 | 1696.5 | 1695.73 | 1696.24 | 450.0 |
| 2013-09-01 19:50:00 | ES | Futures | 1695.98 | 1696.5 | 1695.73 | 1696.5 | 494.0 |
| 2013-09-01 19:55:00 | ES | Futures | 1696.5 | 1696.5 | 1695.98 | 1696.24 | 171.0 |
| 2013-09-01 20:00:00 | ES | Futures | 1695.98 | 1696.24 | 1695.47 | 1695.73 | 438.0 |
| 2013-09-01 20:05:00 | ES | Futures | 1695.73 | 1696.5 | 1695.73 | 1696.5 | 908.0 |
| 2013-09-01 20:10:00 | ES | Futures | 1696.76 | 1697.28 | 1696.5 | 1697.28 | 616.0 |
| 2013-09-01 20:15:00 | ES | Futures | 1697.28 | 1697.54 | 1696.76 | 1697.54 | 662.0 |
| 2013-09-01 20:20:00 | ES | Futures | 1697.54 | 1697.79 | 1697.28 | 1697.54 | 579.0 |
| 2013-09-01 20:25:00 | ES | Futures | 1697.28 | 1697.54 | 1697.02 | 1697.28 | 1115.0 |
| 2013-09-01 20:30:00 | ES | Futures | 1697.54 | 1697.79 | 1697.28 | 1697.28 | 389.0 |
| 2013-09-01 20:35:00 | ES | Futures | 1697.54 | 1697.54 | 1697.28 | 1697.54 | 143.0 |
| 2013-09-01 20:40:00 | ES | Futures | 1697.28 | 1697.79 | 1697.28 | 1697.79 | 590.0 |
| 2013-09-01 20:45:00 | ES | Futures | 1697.79 | 1698.57 | 1697.28 | 1698.05 | 1774.0 |
| 2013-09-01 20:50:00 | ES | Futures | 1698.05 | 1698.57 | 1698.05 | 1698.05 | 1447.0 |
| 2013-09-01 20:55:00 | ES | Futures | 1698.31 | 1699.34 | 1698.31 | 1698.31 | 2044.0 |
| 2013-09-01 21:00:00 | ES | Futures | 1698.31 | 1698.57 | 1697.54 | 1697.79 | 1156.0 |
| 2013-09-01 21:05:00 | ES | Futures | 1697.54 | 1698.31 | 1697.54 | 1698.05 | 571.0 |
| 2013-09-01 21:10:00 | ES | Futures | 1698.05 | 1698.05 | 1697.54 | 1697.79 | 296.0 |
| 2013-09-01 21:15:00 | ES | Futures | 1697.79 | 1698.31 | 1697.79 | 1697.79 | 494.0 |
| 2013-09-01 21:20:00 | ES | Futures | 1697.79 | 1698.31 | 1697.79 | 1698.05 | 435.0 |
| 2013-09-01 21:25:00 | ES | Futures | 1698.05 | 1698.31 | 1697.79 | 1698.05 | 347.0 |
| 2013-09-01 21:30:00 | ES | Futures | 1698.05 | 1698.57 | 1698.05 | 1698.05 | 537.0 |
| 2013-09-01 21:35:00 | ES | Futures | 1698.05 | 1698.31 | 1698.05 | 1698.05 | 325.0 |
| 2013-09-01 21:40:00 | ES | Futures | 1698.05 | 1698.31 | 1697.79 | 1698.31 | 131.0 |
| 2013-09-01 21:45:00 | ES | Futures | 1698.05 | 1698.57 | 1697.79 | 1698.57 | 671.0 |
| 2013-09-01 21:50:00 | ES | Futures | 1698.57 | 1698.57 | 1698.31 | 1698.57 | 217.0 |
| 2013-09-01 21:55:00 | ES | Futures | 1698.31 | 1698.57 | 1698.05 | 1698.57 | 299.0 |
| 2013-09-01 22:00:00 | ES | Futures | 1698.31 | 1698.57 | 1697.54 | 1697.54 | 770.0 |
| 2013-09-01 22:05:00 | ES | Futures | 1697.54 | 1698.05 | 1697.28 | 1697.79 | 843.0 |
> showing 50 of 1,897 rows — these rows as CSV