PREVIEW / stock_5min / 2014-08-20
file: by_date/stock_5min/2014/2014-08-20.parquet size: 5.2 MB rows: 347,196 symbols: 3,569
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-20 04:00:00 | AAPL | Stock | 25.1075 | 25.2325 | 25.1075 | 25.2175 | 21560.0 |
| 2014-08-20 04:05:00 | AAPL | Stock | 25.225 | 25.235 | 25.2225 | 25.2225 | 2960.0 |
| 2014-08-20 04:10:00 | AAPL | Stock | 25.2225 | 25.23 | 25.205 | 25.225 | 3600.0 |
| 2014-08-20 04:15:00 | AAPL | Stock | 25.2125 | 25.2275 | 25.2075 | 25.22 | 3200.0 |
| 2014-08-20 04:20:00 | AAPL | Stock | 25.22 | 25.22 | 25.2 | 25.22 | 6000.0 |
| 2014-08-20 04:25:00 | AAPL | Stock | 25.225 | 25.23 | 25.225 | 25.23 | 5776.0 |
| 2014-08-20 04:30:00 | AAPL | Stock | 25.2 | 25.23 | 25.2 | 25.23 | 3360.0 |
| 2014-08-20 04:35:00 | AAPL | Stock | 25.2325 | 25.2325 | 25.215 | 25.23 | 2800.0 |
| 2014-08-20 04:40:00 | AAPL | Stock | 25.23 | 25.23 | 25.23 | 25.23 | 400.0 |
| 2014-08-20 04:45:00 | AAPL | Stock | 25.23 | 25.245 | 25.23 | 25.2425 | 15840.0 |
| 2014-08-20 04:50:00 | AAPL | Stock | 25.23 | 25.245 | 25.2125 | 25.2125 | 12792.0 |
| 2014-08-20 04:55:00 | AAPL | Stock | 25.235 | 25.235 | 25.2 | 25.2 | 6400.0 |
| 2014-08-20 05:00:00 | AAPL | Stock | 25.2025 | 25.2125 | 25.2 | 25.2125 | 3200.0 |
| 2014-08-20 05:05:00 | AAPL | Stock | 25.2125 | 25.2225 | 25.2075 | 25.2075 | 9200.0 |
| 2014-08-20 05:10:00 | AAPL | Stock | 25.22 | 25.23 | 25.2 | 25.22 | 9980.0 |
| 2014-08-20 05:15:00 | AAPL | Stock | 25.23 | 25.245 | 25.23 | 25.245 | 4400.0 |
| 2014-08-20 05:20:00 | AAPL | Stock | 25.245 | 25.245 | 25.245 | 25.245 | 3600.0 |
| 2014-08-20 05:25:00 | AAPL | Stock | 25.225 | 25.225 | 25.2125 | 25.225 | 23828.0 |
| 2014-08-20 05:30:00 | AAPL | Stock | 25.23 | 25.2375 | 25.2075 | 25.2375 | 13320.0 |
| 2014-08-20 05:45:00 | AAPL | Stock | 25.225 | 25.225 | 25.2225 | 25.2225 | 1020.0 |
| 2014-08-20 05:50:00 | AAPL | Stock | 25.2125 | 25.2125 | 25.205 | 25.205 | 1600.0 |
| 2014-08-20 05:55:00 | AAPL | Stock | 25.2125 | 25.2125 | 25.21 | 25.21 | 840.0 |
| 2014-08-20 06:00:00 | AAPL | Stock | 25.215 | 25.215 | 25.205 | 25.205 | 15248.0 |
| 2014-08-20 06:05:00 | AAPL | Stock | 25.205 | 25.2225 | 25.205 | 25.2225 | 2560.0 |
| 2014-08-20 06:15:00 | AAPL | Stock | 25.21 | 25.2125 | 25.2 | 25.2 | 10092.0 |
| 2014-08-20 06:20:00 | AAPL | Stock | 25.2 | 25.2125 | 25.1975 | 25.2125 | 5184.0 |
| 2014-08-20 06:25:00 | AAPL | Stock | 25.21 | 25.2125 | 25.2 | 25.2 | 6000.0 |
| 2014-08-20 06:30:00 | AAPL | Stock | 25.2175 | 25.2175 | 25.215 | 25.2175 | 4000.0 |
| 2014-08-20 06:35:00 | AAPL | Stock | 25.2175 | 25.2375 | 25.2175 | 25.2375 | 21696.0 |
| 2014-08-20 06:40:00 | AAPL | Stock | 25.2175 | 25.2375 | 25.2175 | 25.23 | 11088.0 |
| 2014-08-20 06:45:00 | AAPL | Stock | 25.2125 | 25.2125 | 25.2025 | 25.2025 | 8400.0 |
| 2014-08-20 06:50:00 | AAPL | Stock | 25.2175 | 25.225 | 25.2125 | 25.215 | 13700.0 |
| 2014-08-20 06:55:00 | AAPL | Stock | 25.2125 | 25.2175 | 25.2075 | 25.2175 | 15192.0 |
| 2014-08-20 07:00:00 | AAPL | Stock | 25.2075 | 25.2075 | 25.19 | 25.2 | 38720.0 |
| 2014-08-20 07:05:00 | AAPL | Stock | 25.2 | 25.2 | 25.16 | 25.1825 | 30016.0 |
| 2014-08-20 07:10:00 | AAPL | Stock | 25.18 | 25.1825 | 25.175 | 25.175 | 13100.0 |
| 2014-08-20 07:15:00 | AAPL | Stock | 25.18 | 25.1925 | 25.18 | 25.1875 | 43132.0 |
| 2014-08-20 07:20:00 | AAPL | Stock | 25.1875 | 25.1925 | 25.1825 | 25.1925 | 21468.0 |
| 2014-08-20 07:25:00 | AAPL | Stock | 25.19 | 25.195 | 25.1625 | 25.1625 | 24748.0 |
| 2014-08-20 07:30:00 | AAPL | Stock | 25.175 | 25.175 | 25.1625 | 25.17 | 22120.0 |
| 2014-08-20 07:35:00 | AAPL | Stock | 25.17 | 25.175 | 25.1575 | 25.1625 | 19452.0 |
| 2014-08-20 07:40:00 | AAPL | Stock | 25.1575 | 25.1675 | 25.1575 | 25.1675 | 15500.0 |
| 2014-08-20 07:45:00 | AAPL | Stock | 25.17 | 25.17 | 25.1625 | 25.1625 | 14280.0 |
| 2014-08-20 07:50:00 | AAPL | Stock | 25.1675 | 25.175 | 25.165 | 25.17 | 65784.0 |
| 2014-08-20 07:55:00 | AAPL | Stock | 25.1625 | 25.18 | 25.1625 | 25.1775 | 14448.0 |
| 2014-08-20 08:00:00 | AAPL | Stock | 25.1875 | 25.22 | 25.1575 | 25.17 | 216720.0 |
| 2014-08-20 08:05:00 | AAPL | Stock | 25.17 | 25.1725 | 25.15 | 25.15 | 134780.0 |
| 2014-08-20 08:10:00 | AAPL | Stock | 25.15 | 25.15 | 25.125 | 25.125 | 72308.0 |
| 2014-08-20 08:15:00 | AAPL | Stock | 25.125 | 25.1275 | 25.1025 | 25.1175 | 58876.0 |
| 2014-08-20 08:20:00 | AAPL | Stock | 25.1175 | 25.1275 | 25.1075 | 25.1075 | 33812.0 |
> showing 50 of 347,196 rows — these rows as CSV