PREVIEW / stock_5min / 2016-08-19
file: by_date/stock_5min/2016/2016-08-19.parquet size: 5.2 MB rows: 341,505 symbols: 3,258
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-19 04:05:00 | AAPL | Stock | 27.255 | 27.255 | 27.255 | 27.255 | 5600.0 |
| 2016-08-19 04:15:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 1344.0 |
| 2016-08-19 04:30:00 | AAPL | Stock | 27.2175 | 27.2175 | 27.2175 | 27.2175 | 1600.0 |
| 2016-08-19 04:55:00 | AAPL | Stock | 27.1975 | 27.1975 | 27.1975 | 27.1975 | 400.0 |
| 2016-08-19 05:30:00 | AAPL | Stock | 27.2225 | 27.2225 | 27.2225 | 27.2225 | 800.0 |
| 2016-08-19 05:50:00 | AAPL | Stock | 27.215 | 27.215 | 27.215 | 27.215 | 1600.0 |
| 2016-08-19 06:25:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 400.0 |
| 2016-08-19 06:40:00 | AAPL | Stock | 27.2525 | 27.2525 | 27.24 | 27.24 | 5504.0 |
| 2016-08-19 07:00:00 | AAPL | Stock | 27.2425 | 27.2425 | 27.2425 | 27.2425 | 2800.0 |
| 2016-08-19 07:10:00 | AAPL | Stock | 27.2425 | 27.2425 | 27.2425 | 27.2425 | 1000.0 |
| 2016-08-19 07:25:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 2000.0 |
| 2016-08-19 07:30:00 | AAPL | Stock | 27.245 | 27.245 | 27.245 | 27.245 | 1200.0 |
| 2016-08-19 07:35:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 2400.0 |
| 2016-08-19 07:50:00 | AAPL | Stock | 27.245 | 27.245 | 27.225 | 27.225 | 42360.0 |
| 2016-08-19 07:55:00 | AAPL | Stock | 27.235 | 27.2375 | 27.235 | 27.2375 | 800.0 |
| 2016-08-19 08:00:00 | AAPL | Stock | 27.22 | 27.25 | 27.22 | 27.225 | 34708.0 |
| 2016-08-19 08:05:00 | AAPL | Stock | 27.225 | 27.25 | 27.225 | 27.25 | 22752.0 |
| 2016-08-19 08:10:00 | AAPL | Stock | 27.2625 | 27.265 | 27.24 | 27.25 | 12272.0 |
| 2016-08-19 08:15:00 | AAPL | Stock | 27.25 | 27.25 | 27.24 | 27.24 | 8844.0 |
| 2016-08-19 08:20:00 | AAPL | Stock | 27.2375 | 27.2575 | 27.2375 | 27.2525 | 40988.0 |
| 2016-08-19 08:25:00 | AAPL | Stock | 27.25 | 27.2525 | 27.25 | 27.2525 | 6340.0 |
| 2016-08-19 08:30:00 | AAPL | Stock | 27.24 | 27.25 | 27.24 | 27.25 | 7600.0 |
| 2016-08-19 08:35:00 | AAPL | Stock | 27.2575 | 27.2575 | 27.24 | 27.24 | 4600.0 |
| 2016-08-19 08:40:00 | AAPL | Stock | 27.25 | 27.2625 | 27.25 | 27.25 | 25200.0 |
| 2016-08-19 08:45:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 2800.0 |
| 2016-08-19 08:50:00 | AAPL | Stock | 27.2575 | 27.2575 | 27.2575 | 27.2575 | 4000.0 |
| 2016-08-19 08:55:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 900.0 |
| 2016-08-19 09:00:00 | AAPL | Stock | 27.25 | 27.25 | 27.2375 | 27.24 | 15864.0 |
| 2016-08-19 09:05:00 | AAPL | Stock | 27.2375 | 27.2625 | 27.2325 | 27.2625 | 42244.0 |
| 2016-08-19 09:10:00 | AAPL | Stock | 27.2575 | 27.2575 | 27.2575 | 27.2575 | 4000.0 |
| 2016-08-19 09:15:00 | AAPL | Stock | 27.25 | 27.265 | 27.25 | 27.2625 | 6600.0 |
| 2016-08-19 09:20:00 | AAPL | Stock | 27.2625 | 27.2675 | 27.2625 | 27.2675 | 16108.0 |
| 2016-08-19 09:25:00 | AAPL | Stock | 27.2675 | 27.2675 | 27.18 | 27.2025 | 154148.0 |
| 2016-08-19 09:30:00 | AAPL | Stock | 27.195 | 27.21 | 27.125 | 27.155 | 10279012.0 |
| 2016-08-19 09:35:00 | AAPL | Stock | 27.1525 | 27.1825 | 27.1252 | 27.134 | 2248720.0 |
| 2016-08-19 09:40:00 | AAPL | Stock | 27.135 | 27.145 | 27.1025 | 27.12 | 2203780.0 |
| 2016-08-19 09:45:00 | AAPL | Stock | 27.1208 | 27.135 | 27.09 | 27.1225 | 2262748.0 |
| 2016-08-19 09:50:00 | AAPL | Stock | 27.1225 | 27.155 | 27.1 | 27.1375 | 1493940.0 |
| 2016-08-19 09:55:00 | AAPL | Stock | 27.1375 | 27.2175 | 27.1375 | 27.205 | 1772516.0 |
| 2016-08-19 10:00:00 | AAPL | Stock | 27.205 | 27.21 | 27.1725 | 27.185 | 1497820.0 |
| 2016-08-19 10:05:00 | AAPL | Stock | 27.185 | 27.2175 | 27.17 | 27.2015 | 1242816.0 |
| 2016-08-19 10:10:00 | AAPL | Stock | 27.2025 | 27.22 | 27.1725 | 27.175 | 1364252.0 |
| 2016-08-19 10:15:00 | AAPL | Stock | 27.175 | 27.205 | 27.1688 | 27.205 | 1112832.0 |
| 2016-08-19 10:20:00 | AAPL | Stock | 27.2048 | 27.25 | 27.1975 | 27.245 | 1792992.0 |
| 2016-08-19 10:25:00 | AAPL | Stock | 27.2475 | 27.305 | 27.2375 | 27.3025 | 2047052.0 |
| 2016-08-19 10:30:00 | AAPL | Stock | 27.305 | 27.3075 | 27.2575 | 27.2875 | 2091048.0 |
| 2016-08-19 10:35:00 | AAPL | Stock | 27.2875 | 27.325 | 27.2825 | 27.3212 | 1905416.0 |
| 2016-08-19 10:40:00 | AAPL | Stock | 27.3175 | 27.3362 | 27.2875 | 27.32 | 1762816.0 |
| 2016-08-19 10:45:00 | AAPL | Stock | 27.3175 | 27.3375 | 27.3 | 27.3025 | 1221796.0 |
| 2016-08-19 10:50:00 | AAPL | Stock | 27.3025 | 27.325 | 27.295 | 27.32 | 1295736.0 |
> showing 50 of 341,505 rows — these rows as CSV