PREVIEW / stock_5min / 2011-09-08
file: by_date/stock_5min/2011/2011-09-08.parquet size: 4.8 MB rows: 325,634 symbols: 3,505
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-08 05:45:00 | AAPL | Stock | 13.7679 | 13.7679 | 13.7679 | 13.7679 | 14000.0 |
| 2011-09-08 05:55:00 | AAPL | Stock | 13.7571 | 13.7571 | 13.7571 | 13.7571 | 2800.0 |
| 2011-09-08 06:00:00 | AAPL | Stock | 13.75 | 13.75 | 13.75 | 13.75 | 11200.0 |
| 2011-09-08 06:20:00 | AAPL | Stock | 13.7679 | 13.7821 | 13.7679 | 13.7732 | 95200.0 |
| 2011-09-08 06:25:00 | AAPL | Stock | 13.7732 | 13.7839 | 13.7732 | 13.7839 | 5600.0 |
| 2011-09-08 06:30:00 | AAPL | Stock | 13.7857 | 13.7857 | 13.7857 | 13.7857 | 2800.0 |
| 2011-09-08 06:35:00 | AAPL | Stock | 13.775 | 13.775 | 13.775 | 13.775 | 2800.0 |
| 2011-09-08 07:00:00 | AAPL | Stock | 13.7607 | 13.7768 | 13.7607 | 13.7768 | 50120.0 |
| 2011-09-08 07:05:00 | AAPL | Stock | 13.7764 | 13.7764 | 13.7764 | 13.7764 | 2800.0 |
| 2011-09-08 07:10:00 | AAPL | Stock | 13.7804 | 13.7804 | 13.7679 | 13.7679 | 17584.0 |
| 2011-09-08 07:15:00 | AAPL | Stock | 13.7675 | 13.7857 | 13.7675 | 13.7732 | 109424.0 |
| 2011-09-08 07:20:00 | AAPL | Stock | 13.7736 | 13.7811 | 13.7679 | 13.7768 | 40600.0 |
| 2011-09-08 07:25:00 | AAPL | Stock | 13.7686 | 13.7686 | 13.7625 | 13.7625 | 150920.0 |
| 2011-09-08 07:30:00 | AAPL | Stock | 13.7604 | 13.7714 | 13.7593 | 13.7593 | 53200.0 |
| 2011-09-08 07:40:00 | AAPL | Stock | 13.7646 | 13.7646 | 13.7618 | 13.7618 | 7000.0 |
| 2011-09-08 07:45:00 | AAPL | Stock | 13.7646 | 13.765 | 13.715 | 13.7186 | 83860.0 |
| 2011-09-08 07:50:00 | AAPL | Stock | 13.7107 | 13.7286 | 13.7096 | 13.7286 | 103740.0 |
| 2011-09-08 07:55:00 | AAPL | Stock | 13.7232 | 13.7364 | 13.71 | 13.7136 | 89460.0 |
| 2011-09-08 08:00:00 | AAPL | Stock | 13.7143 | 13.7229 | 13.7036 | 13.7071 | 251832.0 |
| 2011-09-08 08:05:00 | AAPL | Stock | 13.7043 | 13.725 | 13.7043 | 13.7243 | 136444.0 |
| 2011-09-08 08:10:00 | AAPL | Stock | 13.7182 | 13.7182 | 13.71 | 13.7143 | 82600.0 |
| 2011-09-08 08:15:00 | AAPL | Stock | 13.7054 | 13.7068 | 13.6964 | 13.6982 | 56000.0 |
| 2011-09-08 08:20:00 | AAPL | Stock | 13.7054 | 13.7054 | 13.6836 | 13.6904 | 84000.0 |
| 2011-09-08 08:25:00 | AAPL | Stock | 13.6886 | 13.6932 | 13.6839 | 13.6839 | 36400.0 |
| 2011-09-08 08:30:00 | AAPL | Stock | 13.685 | 13.7 | 13.6607 | 13.6664 | 485212.0 |
| 2011-09-08 08:35:00 | AAPL | Stock | 13.6643 | 13.6786 | 13.6504 | 13.6571 | 321384.0 |
| 2011-09-08 08:40:00 | AAPL | Stock | 13.6582 | 13.6607 | 13.6471 | 13.655 | 319060.0 |
| 2011-09-08 08:45:00 | AAPL | Stock | 13.6629 | 13.6636 | 13.6379 | 13.6439 | 227808.0 |
| 2011-09-08 08:50:00 | AAPL | Stock | 13.6436 | 13.6571 | 13.6386 | 13.6507 | 723576.0 |
| 2011-09-08 08:55:00 | AAPL | Stock | 13.6507 | 13.6568 | 13.6429 | 13.6461 | 244720.0 |
| 2011-09-08 09:00:00 | AAPL | Stock | 13.6443 | 13.6464 | 13.6375 | 13.6386 | 413840.0 |
| 2011-09-08 09:05:00 | AAPL | Stock | 13.6396 | 13.6411 | 13.6268 | 13.6296 | 357420.0 |
| 2011-09-08 09:10:00 | AAPL | Stock | 13.6261 | 13.63 | 13.6164 | 13.6214 | 397992.0 |
| 2011-09-08 09:15:00 | AAPL | Stock | 13.6211 | 13.6379 | 13.6179 | 13.6332 | 812392.0 |
| 2011-09-08 09:20:00 | AAPL | Stock | 13.6329 | 13.6329 | 13.6243 | 13.6268 | 298256.0 |
| 2011-09-08 09:25:00 | AAPL | Stock | 13.6286 | 13.6679 | 13.6254 | 13.6518 | 326536.0 |
| 2011-09-08 09:30:00 | AAPL | Stock | 13.6546 | 13.7139 | 13.6539 | 13.6786 | 11961320.0 |
| 2011-09-08 09:35:00 | AAPL | Stock | 13.6807 | 13.7457 | 13.6725 | 13.7361 | 14220360.0 |
| 2011-09-08 09:40:00 | AAPL | Stock | 13.7364 | 13.7493 | 13.7321 | 13.7432 | 10049508.0 |
| 2011-09-08 09:45:00 | AAPL | Stock | 13.7429 | 13.7475 | 13.735 | 13.7411 | 7517076.0 |
| 2011-09-08 09:50:00 | AAPL | Stock | 13.7404 | 13.7461 | 13.7279 | 13.7461 | 7420476.0 |
| 2011-09-08 09:55:00 | AAPL | Stock | 13.7457 | 13.7471 | 13.7061 | 13.7275 | 7611828.0 |
| 2011-09-08 10:00:00 | AAPL | Stock | 13.7293 | 13.7311 | 13.6979 | 13.7214 | 6249264.0 |
| 2011-09-08 10:05:00 | AAPL | Stock | 13.7243 | 13.7435 | 13.7096 | 13.7371 | 7585872.0 |
| 2011-09-08 10:10:00 | AAPL | Stock | 13.7375 | 13.7411 | 13.7311 | 13.7354 | 5146932.0 |
| 2011-09-08 10:15:00 | AAPL | Stock | 13.7364 | 13.7746 | 13.7271 | 13.7624 | 14259784.0 |
| 2011-09-08 10:20:00 | AAPL | Stock | 13.7654 | 13.7829 | 13.7604 | 13.7746 | 6210876.0 |
| 2011-09-08 10:25:00 | AAPL | Stock | 13.7757 | 13.81 | 13.7725 | 13.8039 | 9767520.0 |
| 2011-09-08 10:30:00 | AAPL | Stock | 13.8039 | 13.8389 | 13.8007 | 13.8314 | 9067884.0 |
| 2011-09-08 10:35:00 | AAPL | Stock | 13.83 | 13.8371 | 13.8107 | 13.8236 | 5002396.0 |
> showing 50 of 325,634 rows — these rows as CSV