PREVIEW / stock_5min / 2015-08-24
file: by_date/stock_5min/2015/2015-08-24.parquet size: 6.2 MB rows: 403,366 symbols: 3,517
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-24 04:00:00 | AAPL | Stock | 26.36 | 26.36 | 25.25 | 25.31 | 243468.0 |
| 2015-08-24 04:05:00 | AAPL | Stock | 25.305 | 25.45 | 25.275 | 25.4375 | 68188.0 |
| 2015-08-24 04:10:00 | AAPL | Stock | 25.4375 | 25.45 | 25.26 | 25.29 | 38204.0 |
| 2015-08-24 04:15:00 | AAPL | Stock | 25.2875 | 25.315 | 25.2875 | 25.2875 | 8400.0 |
| 2015-08-24 04:20:00 | AAPL | Stock | 25.32 | 25.35 | 25.29 | 25.3125 | 16756.0 |
| 2015-08-24 04:25:00 | AAPL | Stock | 25.32 | 25.3675 | 25.3125 | 25.35 | 28136.0 |
| 2015-08-24 04:30:00 | AAPL | Stock | 25.345 | 25.345 | 25.2925 | 25.2925 | 19400.0 |
| 2015-08-24 04:35:00 | AAPL | Stock | 25.29 | 25.325 | 25.2875 | 25.325 | 51256.0 |
| 2015-08-24 04:40:00 | AAPL | Stock | 25.325 | 25.355 | 25.2875 | 25.355 | 45272.0 |
| 2015-08-24 04:45:00 | AAPL | Stock | 25.29 | 25.325 | 25.2875 | 25.2875 | 21772.0 |
| 2015-08-24 04:50:00 | AAPL | Stock | 25.325 | 25.325 | 25.2875 | 25.3 | 34092.0 |
| 2015-08-24 04:55:00 | AAPL | Stock | 25.3 | 25.4 | 25.3 | 25.33 | 56156.0 |
| 2015-08-24 05:00:00 | AAPL | Stock | 25.3875 | 25.4125 | 25.33 | 25.4025 | 26268.0 |
| 2015-08-24 05:05:00 | AAPL | Stock | 25.43 | 25.44 | 25.375 | 25.375 | 139156.0 |
| 2015-08-24 05:10:00 | AAPL | Stock | 25.3825 | 25.4 | 25.31 | 25.335 | 7692.0 |
| 2015-08-24 05:15:00 | AAPL | Stock | 25.4 | 25.4075 | 25.375 | 25.375 | 9440.0 |
| 2015-08-24 05:20:00 | AAPL | Stock | 25.415 | 25.46 | 25.415 | 25.44 | 18472.0 |
| 2015-08-24 05:25:00 | AAPL | Stock | 25.485 | 25.495 | 25.4375 | 25.4375 | 9584.0 |
| 2015-08-24 05:30:00 | AAPL | Stock | 25.4025 | 25.5 | 25.4025 | 25.4575 | 26060.0 |
| 2015-08-24 05:35:00 | AAPL | Stock | 25.5 | 25.565 | 25.4525 | 25.565 | 28132.0 |
| 2015-08-24 05:40:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.475 | 25.475 | 20708.0 |
| 2015-08-24 05:45:00 | AAPL | Stock | 25.4575 | 25.565 | 25.4175 | 25.565 | 13304.0 |
| 2015-08-24 05:50:00 | AAPL | Stock | 25.525 | 25.6825 | 25.505 | 25.6825 | 17832.0 |
| 2015-08-24 05:55:00 | AAPL | Stock | 25.5725 | 25.625 | 25.5125 | 25.5625 | 78352.0 |
| 2015-08-24 06:00:00 | AAPL | Stock | 25.51 | 25.5875 | 25.375 | 25.45 | 64828.0 |
| 2015-08-24 06:05:00 | AAPL | Stock | 25.375 | 25.5 | 25.375 | 25.4125 | 32152.0 |
| 2015-08-24 06:10:00 | AAPL | Stock | 25.375 | 25.375 | 25.3375 | 25.3375 | 20720.0 |
| 2015-08-24 06:15:00 | AAPL | Stock | 25.35 | 25.375 | 25.3225 | 25.325 | 93972.0 |
| 2015-08-24 06:20:00 | AAPL | Stock | 25.325 | 25.325 | 25.22 | 25.2875 | 131120.0 |
| 2015-08-24 06:25:00 | AAPL | Stock | 25.29 | 25.35 | 25.25 | 25.35 | 63424.0 |
| 2015-08-24 06:30:00 | AAPL | Stock | 25.3475 | 25.35 | 25.3 | 25.3375 | 35548.0 |
| 2015-08-24 06:35:00 | AAPL | Stock | 25.3 | 25.3 | 25.175 | 25.2325 | 51760.0 |
| 2015-08-24 06:40:00 | AAPL | Stock | 25.2325 | 25.325 | 25.175 | 25.325 | 80324.0 |
| 2015-08-24 06:45:00 | AAPL | Stock | 25.285 | 25.35 | 25.275 | 25.3125 | 44268.0 |
| 2015-08-24 06:50:00 | AAPL | Stock | 25.3125 | 25.4125 | 25.3125 | 25.3725 | 84376.0 |
| 2015-08-24 06:55:00 | AAPL | Stock | 25.3825 | 25.5225 | 25.3825 | 25.5 | 93956.0 |
| 2015-08-24 07:00:00 | AAPL | Stock | 25.525 | 25.5775 | 25.3775 | 25.3775 | 184408.0 |
| 2015-08-24 07:05:00 | AAPL | Stock | 25.3775 | 25.3975 | 25.2275 | 25.2375 | 275252.0 |
| 2015-08-24 07:10:00 | AAPL | Stock | 25.2375 | 25.25 | 25.0725 | 25.125 | 365432.0 |
| 2015-08-24 07:15:00 | AAPL | Stock | 25.125 | 25.345 | 25.115 | 25.2675 | 420308.0 |
| 2015-08-24 07:20:00 | AAPL | Stock | 25.2725 | 25.4 | 25.25 | 25.325 | 204368.0 |
| 2015-08-24 07:25:00 | AAPL | Stock | 25.3475 | 25.4 | 25.25 | 25.3125 | 181940.0 |
| 2015-08-24 07:30:00 | AAPL | Stock | 25.315 | 25.335 | 25.25 | 25.29 | 193736.0 |
| 2015-08-24 07:35:00 | AAPL | Stock | 25.29 | 25.3325 | 25.25 | 25.2825 | 649120.0 |
| 2015-08-24 07:40:00 | AAPL | Stock | 25.28 | 25.2875 | 25.15 | 25.1625 | 405336.0 |
| 2015-08-24 07:45:00 | AAPL | Stock | 25.1575 | 25.2875 | 25.1275 | 25.275 | 432576.0 |
| 2015-08-24 07:50:00 | AAPL | Stock | 25.2825 | 25.31 | 25.04 | 25.045 | 331960.0 |
| 2015-08-24 07:55:00 | AAPL | Stock | 25.045 | 25.1 | 24.94 | 25.0 | 586340.0 |
| 2015-08-24 08:00:00 | AAPL | Stock | 25.0 | 25.5725 | 24.8 | 24.9125 | 1936072.0 |
| 2015-08-24 08:05:00 | AAPL | Stock | 24.935 | 24.9375 | 24.4975 | 24.65 | 1752012.0 |
> showing 50 of 403,366 rows — these rows as CSV