PREVIEW / stock_5min / 2011-11-14
file: by_date/stock_5min/2011/2011-11-14.parquet size: 4.6 MB rows: 316,283 symbols: 3,507
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-11-14 04:50:00 | AAPL | Stock | 13.7857 | 13.7861 | 13.7857 | 13.7861 | 18760.0 |
| 2011-11-14 04:55:00 | AAPL | Stock | 13.7861 | 13.7861 | 13.7861 | 13.7861 | 2800.0 |
| 2011-11-14 05:00:00 | AAPL | Stock | 13.7861 | 13.7861 | 13.7861 | 13.7861 | 4760.0 |
| 2011-11-14 05:05:00 | AAPL | Stock | 13.7768 | 13.7768 | 13.7768 | 13.7768 | 26600.0 |
| 2011-11-14 05:15:00 | AAPL | Stock | 13.7771 | 13.7929 | 13.7771 | 13.7929 | 5600.0 |
| 2011-11-14 05:20:00 | AAPL | Stock | 13.8 | 13.8 | 13.8 | 13.8 | 5600.0 |
| 2011-11-14 05:25:00 | AAPL | Stock | 13.8179 | 13.8179 | 13.8179 | 13.8179 | 5600.0 |
| 2011-11-14 05:30:00 | AAPL | Stock | 13.8625 | 13.8643 | 13.8625 | 13.8643 | 9072.0 |
| 2011-11-14 05:55:00 | AAPL | Stock | 13.8211 | 13.8211 | 13.8211 | 13.8211 | 2800.0 |
| 2011-11-14 06:00:00 | AAPL | Stock | 13.7982 | 13.7982 | 13.7982 | 13.7982 | 4648.0 |
| 2011-11-14 06:05:00 | AAPL | Stock | 13.7857 | 13.7857 | 13.7857 | 13.7857 | 2800.0 |
| 2011-11-14 06:10:00 | AAPL | Stock | 13.7679 | 13.7679 | 13.7679 | 13.7679 | 2800.0 |
| 2011-11-14 06:15:00 | AAPL | Stock | 13.7504 | 13.7504 | 13.7504 | 13.7504 | 3500.0 |
| 2011-11-14 07:00:00 | AAPL | Stock | 13.725 | 13.725 | 13.7186 | 13.7214 | 21000.0 |
| 2011-11-14 07:05:00 | AAPL | Stock | 13.7454 | 13.7486 | 13.7454 | 13.7454 | 20860.0 |
| 2011-11-14 07:10:00 | AAPL | Stock | 13.745 | 13.745 | 13.7429 | 13.7446 | 58800.0 |
| 2011-11-14 07:15:00 | AAPL | Stock | 13.7357 | 13.7357 | 13.7357 | 13.7357 | 5600.0 |
| 2011-11-14 07:20:00 | AAPL | Stock | 13.7343 | 13.7343 | 13.7343 | 13.7343 | 5600.0 |
| 2011-11-14 07:25:00 | AAPL | Stock | 13.7232 | 13.7232 | 13.7232 | 13.7232 | 2800.0 |
| 2011-11-14 07:30:00 | AAPL | Stock | 13.7 | 13.7 | 13.6964 | 13.6964 | 10360.0 |
| 2011-11-14 07:35:00 | AAPL | Stock | 13.7139 | 13.7139 | 13.7 | 13.7 | 11200.0 |
| 2011-11-14 07:40:00 | AAPL | Stock | 13.6989 | 13.7121 | 13.6914 | 13.7121 | 32200.0 |
| 2011-11-14 07:45:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.6929 | 13.7107 | 28000.0 |
| 2011-11-14 07:50:00 | AAPL | Stock | 13.7014 | 13.75 | 13.7011 | 13.7468 | 246876.0 |
| 2011-11-14 07:55:00 | AAPL | Stock | 13.7482 | 13.75 | 13.7421 | 13.75 | 56000.0 |
| 2011-11-14 08:00:00 | AAPL | Stock | 13.7357 | 13.7529 | 13.725 | 13.7529 | 141456.0 |
| 2011-11-14 08:05:00 | AAPL | Stock | 13.7604 | 13.7657 | 13.7468 | 13.7582 | 304332.0 |
| 2011-11-14 08:10:00 | AAPL | Stock | 13.7593 | 13.775 | 13.7589 | 13.7736 | 182112.0 |
| 2011-11-14 08:15:00 | AAPL | Stock | 13.7707 | 13.775 | 13.7664 | 13.7679 | 80136.0 |
| 2011-11-14 08:20:00 | AAPL | Stock | 13.7679 | 13.77 | 13.7625 | 13.7679 | 70672.0 |
| 2011-11-14 08:25:00 | AAPL | Stock | 13.7736 | 13.7757 | 13.765 | 13.765 | 112756.0 |
| 2011-11-14 08:30:00 | AAPL | Stock | 13.7589 | 13.765 | 13.7457 | 13.7464 | 306796.0 |
| 2011-11-14 08:35:00 | AAPL | Stock | 13.7496 | 13.7557 | 13.7482 | 13.7521 | 106288.0 |
| 2011-11-14 08:40:00 | AAPL | Stock | 13.755 | 13.755 | 13.7343 | 13.7432 | 225092.0 |
| 2011-11-14 08:45:00 | AAPL | Stock | 13.7432 | 13.7571 | 13.7429 | 13.7571 | 326200.0 |
| 2011-11-14 08:50:00 | AAPL | Stock | 13.75 | 13.75 | 13.7286 | 13.7393 | 113932.0 |
| 2011-11-14 08:55:00 | AAPL | Stock | 13.7339 | 13.7379 | 13.7286 | 13.7354 | 105812.0 |
| 2011-11-14 09:00:00 | AAPL | Stock | 13.7321 | 13.7357 | 13.7254 | 13.7357 | 74900.0 |
| 2011-11-14 09:05:00 | AAPL | Stock | 13.7321 | 13.7321 | 13.6911 | 13.6964 | 63000.0 |
| 2011-11-14 09:10:00 | AAPL | Stock | 13.6964 | 13.6964 | 13.6464 | 13.6654 | 319536.0 |
| 2011-11-14 09:15:00 | AAPL | Stock | 13.6643 | 13.6775 | 13.6636 | 13.6679 | 63588.0 |
| 2011-11-14 09:20:00 | AAPL | Stock | 13.6736 | 13.6846 | 13.6736 | 13.6746 | 79408.0 |
| 2011-11-14 09:25:00 | AAPL | Stock | 13.6746 | 13.7296 | 13.6746 | 13.7018 | 631624.0 |
| 2011-11-14 09:30:00 | AAPL | Stock | 13.7061 | 13.7589 | 13.6914 | 13.7207 | 13824944.0 |
| 2011-11-14 09:35:00 | AAPL | Stock | 13.7207 | 13.75 | 13.6869 | 13.7093 | 9146928.0 |
| 2011-11-14 09:40:00 | AAPL | Stock | 13.7093 | 13.7129 | 13.6364 | 13.6504 | 11567500.0 |
| 2011-11-14 09:45:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.625 | 13.637 | 8795668.0 |
| 2011-11-14 09:50:00 | AAPL | Stock | 13.6368 | 13.6582 | 13.6046 | 13.6579 | 11514440.0 |
| 2011-11-14 09:55:00 | AAPL | Stock | 13.6579 | 13.6886 | 13.6371 | 13.6775 | 7328636.0 |
| 2011-11-14 10:00:00 | AAPL | Stock | 13.675 | 13.7214 | 13.6539 | 13.7086 | 9655436.0 |
> showing 50 of 316,283 rows — these rows as CSV