PREVIEW / stock_5min / 2016-06-14
file: by_date/stock_5min/2016/2016-06-14.parquet size: 5.4 MB rows: 358,841 symbols: 3,292
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-06-14 04:00:00 | AAPL | Stock | 24.235 | 24.235 | 24.235 | 24.235 | 400.0 |
| 2016-06-14 04:10:00 | AAPL | Stock | 24.2375 | 24.2375 | 24.2375 | 24.2375 | 960.0 |
| 2016-06-14 04:30:00 | AAPL | Stock | 24.235 | 24.235 | 24.235 | 24.235 | 400.0 |
| 2016-06-14 04:40:00 | AAPL | Stock | 24.1925 | 24.1925 | 24.1925 | 24.1925 | 800.0 |
| 2016-06-14 04:50:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 400.0 |
| 2016-06-14 04:55:00 | AAPL | Stock | 24.1775 | 24.1775 | 24.1775 | 24.1775 | 1400.0 |
| 2016-06-14 05:05:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 2000.0 |
| 2016-06-14 05:10:00 | AAPL | Stock | 24.175 | 24.1775 | 24.175 | 24.1775 | 3800.0 |
| 2016-06-14 05:15:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.1875 | 24.1875 | 760.0 |
| 2016-06-14 05:35:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 600.0 |
| 2016-06-14 05:55:00 | AAPL | Stock | 24.19 | 24.19 | 24.19 | 24.19 | 708.0 |
| 2016-06-14 06:05:00 | AAPL | Stock | 24.1925 | 24.1925 | 24.1925 | 24.1925 | 400.0 |
| 2016-06-14 06:30:00 | AAPL | Stock | 24.2125 | 24.225 | 24.2125 | 24.225 | 2052.0 |
| 2016-06-14 06:35:00 | AAPL | Stock | 24.255 | 24.255 | 24.255 | 24.255 | 800.0 |
| 2016-06-14 06:40:00 | AAPL | Stock | 24.245 | 24.25 | 24.245 | 24.25 | 1600.0 |
| 2016-06-14 06:45:00 | AAPL | Stock | 24.2425 | 24.2425 | 24.23 | 24.2375 | 1620.0 |
| 2016-06-14 06:55:00 | AAPL | Stock | 24.24 | 24.24 | 24.2375 | 24.2375 | 1600.0 |
| 2016-06-14 07:00:00 | AAPL | Stock | 24.25 | 24.265 | 24.25 | 24.265 | 8212.0 |
| 2016-06-14 07:05:00 | AAPL | Stock | 24.295 | 24.295 | 24.295 | 24.295 | 4000.0 |
| 2016-06-14 07:10:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 400.0 |
| 2016-06-14 07:15:00 | AAPL | Stock | 24.2375 | 24.25 | 24.2375 | 24.25 | 7160.0 |
| 2016-06-14 07:20:00 | AAPL | Stock | 24.25 | 24.2525 | 24.25 | 24.25 | 9600.0 |
| 2016-06-14 07:35:00 | AAPL | Stock | 24.285 | 24.285 | 24.26 | 24.26 | 1200.0 |
| 2016-06-14 07:50:00 | AAPL | Stock | 24.275 | 24.275 | 24.275 | 24.275 | 3200.0 |
| 2016-06-14 08:00:00 | AAPL | Stock | 24.275 | 24.2875 | 24.25 | 24.2875 | 13100.0 |
| 2016-06-14 08:05:00 | AAPL | Stock | 24.2875 | 24.325 | 24.2875 | 24.3075 | 17828.0 |
| 2016-06-14 08:10:00 | AAPL | Stock | 24.3 | 24.3 | 24.295 | 24.295 | 6000.0 |
| 2016-06-14 08:15:00 | AAPL | Stock | 24.3 | 24.3175 | 24.3 | 24.3175 | 8420.0 |
| 2016-06-14 08:20:00 | AAPL | Stock | 24.3225 | 24.3225 | 24.3 | 24.3 | 26144.0 |
| 2016-06-14 08:25:00 | AAPL | Stock | 24.295 | 24.3 | 24.2925 | 24.3 | 5000.0 |
| 2016-06-14 08:30:00 | AAPL | Stock | 24.3025 | 24.3025 | 24.3025 | 24.3025 | 400.0 |
| 2016-06-14 08:35:00 | AAPL | Stock | 24.325 | 24.33 | 24.325 | 24.325 | 8236.0 |
| 2016-06-14 08:40:00 | AAPL | Stock | 24.325 | 24.33 | 24.3125 | 24.33 | 33324.0 |
| 2016-06-14 08:45:00 | AAPL | Stock | 24.33 | 24.3425 | 24.33 | 24.3425 | 6560.0 |
| 2016-06-14 08:50:00 | AAPL | Stock | 24.33 | 24.3575 | 24.33 | 24.3575 | 17052.0 |
| 2016-06-14 08:55:00 | AAPL | Stock | 24.3575 | 24.3825 | 24.3575 | 24.3825 | 88740.0 |
| 2016-06-14 09:00:00 | AAPL | Stock | 24.3875 | 24.41 | 24.3875 | 24.4 | 38304.0 |
| 2016-06-14 09:05:00 | AAPL | Stock | 24.4 | 24.4025 | 24.39 | 24.4 | 54552.0 |
| 2016-06-14 09:10:00 | AAPL | Stock | 24.4025 | 24.4125 | 24.4 | 24.4025 | 27564.0 |
| 2016-06-14 09:15:00 | AAPL | Stock | 24.4025 | 24.4025 | 24.38 | 24.3975 | 41340.0 |
| 2016-06-14 09:20:00 | AAPL | Stock | 24.3975 | 24.3975 | 24.385 | 24.385 | 7104.0 |
| 2016-06-14 09:25:00 | AAPL | Stock | 24.385 | 24.405 | 24.335 | 24.3375 | 357968.0 |
| 2016-06-14 09:30:00 | AAPL | Stock | 24.3375 | 24.5 | 24.33 | 24.4675 | 5191404.0 |
| 2016-06-14 09:35:00 | AAPL | Stock | 24.4675 | 24.565 | 24.465 | 24.545 | 3666068.0 |
| 2016-06-14 09:40:00 | AAPL | Stock | 24.5475 | 24.6188 | 24.545 | 24.58 | 3305548.0 |
| 2016-06-14 09:45:00 | AAPL | Stock | 24.585 | 24.595 | 24.515 | 24.555 | 2563256.0 |
| 2016-06-14 09:50:00 | AAPL | Stock | 24.555 | 24.6 | 24.5275 | 24.6 | 2031420.0 |
| 2016-06-14 09:55:00 | AAPL | Stock | 24.5988 | 24.61 | 24.5625 | 24.5832 | 1800472.0 |
| 2016-06-14 10:00:00 | AAPL | Stock | 24.5825 | 24.6075 | 24.545 | 24.56 | 1706272.0 |
| 2016-06-14 10:05:00 | AAPL | Stock | 24.5608 | 24.5675 | 24.5025 | 24.51 | 1979632.0 |
> showing 50 of 358,841 rows — these rows as CSV