PREVIEW / stock_5min / 2014-02-21
file: by_date/stock_5min/2014/2014-02-21.parquet size: 5.5 MB rows: 360,396 symbols: 3,541
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-02-21 04:25:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 2800.0 |
| 2014-02-21 06:20:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2014-02-21 06:35:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-02-21 06:50:00 | AAPL | Stock | 19.0339 | 19.0339 | 19.0214 | 19.0214 | 5600.0 |
| 2014-02-21 06:55:00 | AAPL | Stock | 19.0261 | 19.0261 | 19.0261 | 19.0261 | 2800.0 |
| 2014-02-21 07:05:00 | AAPL | Stock | 19.0236 | 19.0236 | 19.0179 | 19.0232 | 22148.0 |
| 2014-02-21 07:15:00 | AAPL | Stock | 19.0229 | 19.0229 | 19.0229 | 19.0229 | 9912.0 |
| 2014-02-21 07:50:00 | AAPL | Stock | 19.0336 | 19.035 | 19.0336 | 19.035 | 26124.0 |
| 2014-02-21 08:00:00 | AAPL | Stock | 19.0229 | 19.0411 | 19.0179 | 19.0179 | 159068.0 |
| 2014-02-21 08:05:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0125 | 19.0125 | 14700.0 |
| 2014-02-21 08:10:00 | AAPL | Stock | 19.0282 | 19.0282 | 19.0186 | 19.0204 | 66444.0 |
| 2014-02-21 08:15:00 | AAPL | Stock | 19.025 | 19.025 | 19.025 | 19.025 | 2800.0 |
| 2014-02-21 08:20:00 | AAPL | Stock | 19.0236 | 19.0246 | 19.0107 | 19.0225 | 72884.0 |
| 2014-02-21 08:25:00 | AAPL | Stock | 19.025 | 19.0282 | 19.0196 | 19.0268 | 31500.0 |
| 2014-02-21 08:30:00 | AAPL | Stock | 19.0286 | 19.0286 | 19.0146 | 19.0146 | 22400.0 |
| 2014-02-21 08:35:00 | AAPL | Stock | 19.0139 | 19.0139 | 18.9764 | 18.9821 | 180040.0 |
| 2014-02-21 08:40:00 | AAPL | Stock | 18.9818 | 19.0 | 18.9818 | 19.0 | 30520.0 |
| 2014-02-21 08:45:00 | AAPL | Stock | 19.0 | 19.0157 | 19.0 | 19.0157 | 28000.0 |
| 2014-02-21 08:50:00 | AAPL | Stock | 19.0036 | 19.0036 | 18.9821 | 18.9821 | 99820.0 |
| 2014-02-21 08:55:00 | AAPL | Stock | 18.9854 | 18.9943 | 18.985 | 18.9857 | 58520.0 |
| 2014-02-21 09:00:00 | AAPL | Stock | 18.9957 | 19.0 | 18.9954 | 19.0 | 29400.0 |
| 2014-02-21 09:05:00 | AAPL | Stock | 19.0075 | 19.0089 | 18.9946 | 19.0014 | 140196.0 |
| 2014-02-21 09:10:00 | AAPL | Stock | 19.0064 | 19.0089 | 19.0018 | 19.0089 | 53900.0 |
| 2014-02-21 09:15:00 | AAPL | Stock | 19.0139 | 19.0143 | 19.0089 | 19.0089 | 127960.0 |
| 2014-02-21 09:20:00 | AAPL | Stock | 19.0114 | 19.0246 | 19.0114 | 19.0143 | 116200.0 |
| 2014-02-21 09:25:00 | AAPL | Stock | 19.025 | 19.0329 | 19.0243 | 19.0257 | 145152.0 |
| 2014-02-21 09:30:00 | AAPL | Stock | 19.0283 | 19.0714 | 19.0004 | 19.0368 | 24820992.0 |
| 2014-02-21 09:35:00 | AAPL | Stock | 19.0439 | 19.0918 | 19.0246 | 19.0518 | 7218624.0 |
| 2014-02-21 09:40:00 | AAPL | Stock | 19.0515 | 19.0631 | 18.9868 | 19.0037 | 7334488.0 |
| 2014-02-21 09:45:00 | AAPL | Stock | 19.0039 | 19.0407 | 18.9857 | 19.0343 | 5608764.0 |
| 2014-02-21 09:50:00 | AAPL | Stock | 19.0357 | 19.0643 | 19.0286 | 19.0539 | 3925348.0 |
| 2014-02-21 09:55:00 | AAPL | Stock | 19.0557 | 19.0607 | 19.0079 | 19.022 | 3232040.0 |
| 2014-02-21 10:00:00 | AAPL | Stock | 19.0236 | 19.0357 | 19.0036 | 19.0118 | 2591764.0 |
| 2014-02-21 10:05:00 | AAPL | Stock | 19.0096 | 19.0121 | 18.9725 | 18.9807 | 3675392.0 |
| 2014-02-21 10:10:00 | AAPL | Stock | 18.9818 | 18.9927 | 18.9489 | 18.9595 | 4444384.0 |
| 2014-02-21 10:15:00 | AAPL | Stock | 18.9596 | 18.9639 | 18.9454 | 18.9621 | 3296888.0 |
| 2014-02-21 10:20:00 | AAPL | Stock | 18.9621 | 18.9854 | 18.9404 | 18.9656 | 3306744.0 |
| 2014-02-21 10:25:00 | AAPL | Stock | 18.9664 | 18.9754 | 18.955 | 18.9604 | 2099412.0 |
| 2014-02-21 10:30:00 | AAPL | Stock | 18.9593 | 18.9907 | 18.9568 | 18.9632 | 2641604.0 |
| 2014-02-21 10:35:00 | AAPL | Stock | 18.9637 | 18.9732 | 18.9325 | 18.9424 | 2666076.0 |
| 2014-02-21 10:40:00 | AAPL | Stock | 18.9396 | 18.9643 | 18.9371 | 18.9571 | 1654156.0 |
| 2014-02-21 10:45:00 | AAPL | Stock | 18.9571 | 18.9607 | 18.9432 | 18.9454 | 1329216.0 |
| 2014-02-21 10:50:00 | AAPL | Stock | 18.948 | 18.948 | 18.9107 | 18.9259 | 3758020.0 |
| 2014-02-21 10:55:00 | AAPL | Stock | 18.9261 | 18.9354 | 18.9079 | 18.9079 | 2314480.0 |
| 2014-02-21 11:00:00 | AAPL | Stock | 18.9082 | 18.9082 | 18.8646 | 18.8868 | 6641768.0 |
| 2014-02-21 11:05:00 | AAPL | Stock | 18.8839 | 18.9036 | 18.8825 | 18.8836 | 3092544.0 |
| 2014-02-21 11:10:00 | AAPL | Stock | 18.8843 | 18.8861 | 18.8504 | 18.8514 | 4099228.0 |
| 2014-02-21 11:15:00 | AAPL | Stock | 18.8514 | 18.8529 | 18.8096 | 18.8327 | 6375600.0 |
| 2014-02-21 11:20:00 | AAPL | Stock | 18.8314 | 18.8475 | 18.8214 | 18.833 | 2429392.0 |
| 2014-02-21 11:25:00 | AAPL | Stock | 18.8343 | 18.8382 | 18.7996 | 18.8057 | 3307304.0 |
> showing 50 of 360,396 rows — these rows as CSV