PREVIEW / stock_5min / 2013-08-19
file: by_date/stock_5min/2013/2013-08-19.parquet size: 5.3 MB rows: 350,927 symbols: 3,547
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-19 04:00:00 | AAPL | Stock | 18.0696 | 18.0696 | 18.0696 | 18.0696 | 4200.0 |
| 2013-08-19 04:15:00 | AAPL | Stock | 18.05 | 18.05 | 18.05 | 18.05 | 8400.0 |
| 2013-08-19 04:20:00 | AAPL | Stock | 18.05 | 18.0689 | 18.0393 | 18.0604 | 35140.0 |
| 2013-08-19 04:35:00 | AAPL | Stock | 18.0464 | 18.0464 | 18.0443 | 18.0443 | 14000.0 |
| 2013-08-19 04:45:00 | AAPL | Stock | 18.0286 | 18.0286 | 18.0286 | 18.0286 | 2800.0 |
| 2013-08-19 04:50:00 | AAPL | Stock | 18.0214 | 18.0214 | 18.0214 | 18.0214 | 2800.0 |
| 2013-08-19 05:10:00 | AAPL | Stock | 18.0196 | 18.0196 | 18.0189 | 18.0189 | 15316.0 |
| 2013-08-19 05:15:00 | AAPL | Stock | 18.0232 | 18.0232 | 18.0232 | 18.0232 | 2800.0 |
| 2013-08-19 05:25:00 | AAPL | Stock | 18.0204 | 18.0204 | 18.0204 | 18.0204 | 5600.0 |
| 2013-08-19 05:40:00 | AAPL | Stock | 18.0511 | 18.0511 | 18.0321 | 18.0321 | 12236.0 |
| 2013-08-19 05:45:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0321 | 18.0354 | 8400.0 |
| 2013-08-19 05:50:00 | AAPL | Stock | 18.0321 | 18.0321 | 18.0275 | 18.0275 | 10220.0 |
| 2013-08-19 06:05:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 12404.0 |
| 2013-08-19 06:10:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 5600.0 |
| 2013-08-19 06:15:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2013-08-19 06:25:00 | AAPL | Stock | 18.035 | 18.035 | 18.035 | 18.035 | 2800.0 |
| 2013-08-19 06:30:00 | AAPL | Stock | 18.0268 | 18.0268 | 18.0204 | 18.0264 | 25200.0 |
| 2013-08-19 06:35:00 | AAPL | Stock | 18.0179 | 18.0214 | 18.0179 | 18.0214 | 33600.0 |
| 2013-08-19 06:40:00 | AAPL | Stock | 18.0171 | 18.0518 | 18.0171 | 18.0518 | 92344.0 |
| 2013-08-19 06:45:00 | AAPL | Stock | 18.0289 | 18.0289 | 18.0182 | 18.0182 | 27720.0 |
| 2013-08-19 06:50:00 | AAPL | Stock | 18.0089 | 18.0357 | 18.0089 | 18.0357 | 63336.0 |
| 2013-08-19 06:55:00 | AAPL | Stock | 18.025 | 18.025 | 18.0232 | 18.0232 | 8400.0 |
| 2013-08-19 07:00:00 | AAPL | Stock | 18.0239 | 18.045 | 18.0239 | 18.0411 | 56364.0 |
| 2013-08-19 07:05:00 | AAPL | Stock | 18.0464 | 18.0464 | 18.0411 | 18.0411 | 28000.0 |
| 2013-08-19 07:10:00 | AAPL | Stock | 18.0411 | 18.0411 | 18.025 | 18.0339 | 56280.0 |
| 2013-08-19 07:15:00 | AAPL | Stock | 18.0375 | 18.0375 | 18.03 | 18.035 | 9800.0 |
| 2013-08-19 07:20:00 | AAPL | Stock | 18.0243 | 18.0314 | 18.0089 | 18.0314 | 68880.0 |
| 2013-08-19 07:25:00 | AAPL | Stock | 18.0186 | 18.0186 | 18.0161 | 18.0161 | 5600.0 |
| 2013-08-19 07:30:00 | AAPL | Stock | 18.0143 | 18.0143 | 18.0143 | 18.0143 | 25200.0 |
| 2013-08-19 07:35:00 | AAPL | Stock | 18.0264 | 18.0357 | 18.0264 | 18.0354 | 86800.0 |
| 2013-08-19 07:40:00 | AAPL | Stock | 18.0393 | 18.0393 | 18.02 | 18.0218 | 19600.0 |
| 2013-08-19 07:45:00 | AAPL | Stock | 18.0229 | 18.0232 | 18.0143 | 18.0143 | 44240.0 |
| 2013-08-19 07:50:00 | AAPL | Stock | 18.0089 | 18.0171 | 18.0004 | 18.0171 | 18116.0 |
| 2013-08-19 07:55:00 | AAPL | Stock | 18.0179 | 18.0179 | 18.0179 | 18.0179 | 16800.0 |
| 2013-08-19 08:00:00 | AAPL | Stock | 18.0039 | 18.0482 | 17.9404 | 18.0143 | 309932.0 |
| 2013-08-19 08:05:00 | AAPL | Stock | 18.0043 | 18.0261 | 18.0036 | 18.02 | 141932.0 |
| 2013-08-19 08:10:00 | AAPL | Stock | 18.0214 | 18.0214 | 18.0071 | 18.02 | 223580.0 |
| 2013-08-19 08:15:00 | AAPL | Stock | 18.0139 | 18.0143 | 18.0 | 18.0007 | 183960.0 |
| 2013-08-19 08:20:00 | AAPL | Stock | 18.0 | 18.0 | 17.9754 | 17.9754 | 161672.0 |
| 2013-08-19 08:25:00 | AAPL | Stock | 17.9754 | 18.0 | 17.9754 | 18.0 | 380408.0 |
| 2013-08-19 08:30:00 | AAPL | Stock | 18.0061 | 18.0089 | 17.9964 | 18.0 | 157472.0 |
| 2013-08-19 08:35:00 | AAPL | Stock | 18.0 | 18.0089 | 17.9911 | 18.0032 | 186956.0 |
| 2013-08-19 08:40:00 | AAPL | Stock | 17.9971 | 18.0036 | 17.9832 | 17.9893 | 334012.0 |
| 2013-08-19 08:45:00 | AAPL | Stock | 17.9939 | 18.0168 | 17.9893 | 18.0168 | 191072.0 |
| 2013-08-19 08:50:00 | AAPL | Stock | 18.0207 | 18.0264 | 18.0093 | 18.0179 | 181552.0 |
| 2013-08-19 08:55:00 | AAPL | Stock | 18.0243 | 18.0318 | 18.0243 | 18.0286 | 118860.0 |
| 2013-08-19 09:00:00 | AAPL | Stock | 18.0254 | 18.0279 | 18.0218 | 18.0221 | 156240.0 |
| 2013-08-19 09:05:00 | AAPL | Stock | 18.0218 | 18.0339 | 18.0218 | 18.0339 | 108136.0 |
| 2013-08-19 09:10:00 | AAPL | Stock | 18.0339 | 18.0464 | 18.0339 | 18.0464 | 359576.0 |
| 2013-08-19 09:15:00 | AAPL | Stock | 18.0468 | 18.0521 | 18.0418 | 18.0479 | 299040.0 |
> showing 50 of 350,927 rows — these rows as CSV