PREVIEW / stock_5min / 2016-04-11
file: by_date/stock_5min/2016/2016-04-11.parquet size: 5.3 MB rows: 354,929 symbols: 3,327
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-04-11 04:00:00 | AAPL | Stock | 27.165 | 27.3425 | 27.165 | 27.3425 | 2400.0 |
| 2016-04-11 05:00:00 | AAPL | Stock | 27.2775 | 27.2775 | 27.2775 | 27.2775 | 400.0 |
| 2016-04-11 05:30:00 | AAPL | Stock | 27.3225 | 27.3375 | 27.3225 | 27.3375 | 7216.0 |
| 2016-04-11 06:25:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2875 | 27.2875 | 4000.0 |
| 2016-04-11 06:35:00 | AAPL | Stock | 27.3 | 27.31 | 27.3 | 27.31 | 2400.0 |
| 2016-04-11 06:45:00 | AAPL | Stock | 27.31 | 27.31 | 27.31 | 27.31 | 1200.0 |
| 2016-04-11 07:00:00 | AAPL | Stock | 27.2625 | 27.3075 | 27.2625 | 27.285 | 8000.0 |
| 2016-04-11 07:05:00 | AAPL | Stock | 27.285 | 27.285 | 27.285 | 27.285 | 6096.0 |
| 2016-04-11 07:10:00 | AAPL | Stock | 27.28 | 27.28 | 27.27 | 27.27 | 5652.0 |
| 2016-04-11 07:15:00 | AAPL | Stock | 27.2675 | 27.28 | 27.265 | 27.275 | 12580.0 |
| 2016-04-11 07:20:00 | AAPL | Stock | 27.275 | 27.275 | 27.265 | 27.265 | 2400.0 |
| 2016-04-11 07:25:00 | AAPL | Stock | 27.2675 | 27.275 | 27.2675 | 27.275 | 3200.0 |
| 2016-04-11 07:30:00 | AAPL | Stock | 27.2875 | 27.2975 | 27.2875 | 27.2975 | 8000.0 |
| 2016-04-11 07:35:00 | AAPL | Stock | 27.3 | 27.3 | 27.29 | 27.29 | 7680.0 |
| 2016-04-11 07:40:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2875 | 27.2875 | 1400.0 |
| 2016-04-11 07:45:00 | AAPL | Stock | 27.2925 | 27.2925 | 27.2925 | 27.2925 | 11200.0 |
| 2016-04-11 07:50:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 400.0 |
| 2016-04-11 07:55:00 | AAPL | Stock | 27.2875 | 27.295 | 27.2875 | 27.295 | 2400.0 |
| 2016-04-11 08:00:00 | AAPL | Stock | 27.295 | 27.2975 | 27.265 | 27.2675 | 62880.0 |
| 2016-04-11 08:05:00 | AAPL | Stock | 27.275 | 27.3 | 27.275 | 27.2875 | 21280.0 |
| 2016-04-11 08:10:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2875 | 27.2875 | 600.0 |
| 2016-04-11 08:15:00 | AAPL | Stock | 27.29 | 27.2925 | 27.2675 | 27.2675 | 20932.0 |
| 2016-04-11 08:20:00 | AAPL | Stock | 27.285 | 27.2975 | 27.265 | 27.2875 | 25396.0 |
| 2016-04-11 08:25:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2625 | 27.2625 | 10000.0 |
| 2016-04-11 08:30:00 | AAPL | Stock | 27.265 | 27.27 | 27.25 | 27.2625 | 44572.0 |
| 2016-04-11 08:35:00 | AAPL | Stock | 27.26 | 27.2725 | 27.26 | 27.2725 | 4740.0 |
| 2016-04-11 08:40:00 | AAPL | Stock | 27.2725 | 27.275 | 27.27 | 27.27 | 5480.0 |
| 2016-04-11 08:45:00 | AAPL | Stock | 27.27 | 27.27 | 27.25 | 27.25 | 22352.0 |
| 2016-04-11 08:50:00 | AAPL | Stock | 27.26 | 27.275 | 27.26 | 27.275 | 22656.0 |
| 2016-04-11 08:55:00 | AAPL | Stock | 27.275 | 27.295 | 27.2725 | 27.2925 | 21848.0 |
| 2016-04-11 09:00:00 | AAPL | Stock | 27.165 | 27.2925 | 27.165 | 27.2875 | 34468.0 |
| 2016-04-11 09:05:00 | AAPL | Stock | 27.2875 | 27.305 | 27.285 | 27.3025 | 53520.0 |
| 2016-04-11 09:10:00 | AAPL | Stock | 27.295 | 27.295 | 27.2625 | 27.2625 | 29200.0 |
| 2016-04-11 09:15:00 | AAPL | Stock | 27.265 | 27.29 | 27.2625 | 27.29 | 13668.0 |
| 2016-04-11 09:20:00 | AAPL | Stock | 27.295 | 27.3025 | 27.295 | 27.3025 | 23572.0 |
| 2016-04-11 09:25:00 | AAPL | Stock | 27.3 | 27.3075 | 27.2375 | 27.2425 | 165184.0 |
| 2016-04-11 09:30:00 | AAPL | Stock | 27.2425 | 27.325 | 27.2075 | 27.2425 | 3880936.0 |
| 2016-04-11 09:35:00 | AAPL | Stock | 27.24 | 27.3475 | 27.2375 | 27.33 | 2503792.0 |
| 2016-04-11 09:40:00 | AAPL | Stock | 27.33 | 27.4075 | 27.3125 | 27.405 | 2247796.0 |
| 2016-04-11 09:45:00 | AAPL | Stock | 27.4025 | 27.47 | 27.4025 | 27.445 | 2712208.0 |
| 2016-04-11 09:50:00 | AAPL | Stock | 27.4475 | 27.605 | 27.4475 | 27.6 | 5865000.0 |
| 2016-04-11 09:55:00 | AAPL | Stock | 27.6025 | 27.61 | 27.545 | 27.5925 | 2607332.0 |
| 2016-04-11 10:00:00 | AAPL | Stock | 27.5925 | 27.6225 | 27.5575 | 27.5625 | 2601724.0 |
| 2016-04-11 10:05:00 | AAPL | Stock | 27.5625 | 27.62 | 27.56 | 27.6125 | 1502172.0 |
| 2016-04-11 10:10:00 | AAPL | Stock | 27.61 | 27.6375 | 27.6 | 27.6112 | 2388680.0 |
| 2016-04-11 10:15:00 | AAPL | Stock | 27.611 | 27.62 | 27.59 | 27.6162 | 1505976.0 |
| 2016-04-11 10:20:00 | AAPL | Stock | 27.6175 | 27.63 | 27.6 | 27.62 | 1922140.0 |
| 2016-04-11 10:25:00 | AAPL | Stock | 27.62 | 27.62 | 27.5625 | 27.585 | 1393864.0 |
| 2016-04-11 10:30:00 | AAPL | Stock | 27.5848 | 27.6025 | 27.57 | 27.5975 | 999180.0 |
| 2016-04-11 10:35:00 | AAPL | Stock | 27.5975 | 27.6525 | 27.5775 | 27.605 | 2959396.0 |
> showing 50 of 354,929 rows — these rows as CSV