PREVIEW / stock_5min / 2010-08-26
file: by_date/stock_5min/2010/2010-08-26.parquet size: 4.6 MB rows: 316,283 symbols: 3,467
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-26 04:05:00 | AAPL | Stock | 8.7096 | 8.75 | 8.7096 | 8.75 | 5600.0 |
| 2010-08-26 04:45:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 3500.0 |
| 2010-08-26 05:10:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7143 | 8.7143 | 2800.0 |
| 2010-08-26 06:05:00 | AAPL | Stock | 8.7339 | 8.7339 | 8.7339 | 8.7339 | 2800.0 |
| 2010-08-26 06:10:00 | AAPL | Stock | 8.7339 | 8.735 | 8.7339 | 8.735 | 14000.0 |
| 2010-08-26 06:15:00 | AAPL | Stock | 8.7371 | 8.7371 | 8.7371 | 8.7371 | 2800.0 |
| 2010-08-26 06:50:00 | AAPL | Stock | 8.7161 | 8.7161 | 8.7143 | 8.7143 | 28000.0 |
| 2010-08-26 07:00:00 | AAPL | Stock | 8.7286 | 8.7286 | 8.7286 | 8.7286 | 25200.0 |
| 2010-08-26 07:05:00 | AAPL | Stock | 8.7154 | 8.7182 | 8.7143 | 8.7179 | 64400.0 |
| 2010-08-26 07:10:00 | AAPL | Stock | 8.705 | 8.705 | 8.7046 | 8.7046 | 16800.0 |
| 2010-08-26 07:15:00 | AAPL | Stock | 8.7036 | 8.7036 | 8.6943 | 8.7036 | 56000.0 |
| 2010-08-26 07:20:00 | AAPL | Stock | 8.7036 | 8.7039 | 8.7036 | 8.7039 | 14000.0 |
| 2010-08-26 07:25:00 | AAPL | Stock | 8.7061 | 8.7143 | 8.7061 | 8.7107 | 103600.0 |
| 2010-08-26 07:30:00 | AAPL | Stock | 8.7107 | 8.7107 | 8.7107 | 8.7107 | 2800.0 |
| 2010-08-26 07:35:00 | AAPL | Stock | 8.7089 | 8.7143 | 8.7046 | 8.7046 | 15400.0 |
| 2010-08-26 07:45:00 | AAPL | Stock | 8.6982 | 8.6982 | 8.6979 | 8.6979 | 14000.0 |
| 2010-08-26 07:50:00 | AAPL | Stock | 8.6979 | 8.7043 | 8.6979 | 8.7043 | 11900.0 |
| 2010-08-26 07:55:00 | AAPL | Stock | 8.6979 | 8.6979 | 8.6975 | 8.6975 | 8400.0 |
| 2010-08-26 08:00:00 | AAPL | Stock | 8.7018 | 8.7036 | 8.6804 | 8.6957 | 148372.0 |
| 2010-08-26 08:05:00 | AAPL | Stock | 8.6896 | 8.6896 | 8.6625 | 8.6696 | 334852.0 |
| 2010-08-26 08:10:00 | AAPL | Stock | 8.6696 | 8.6786 | 8.6696 | 8.6746 | 99400.0 |
| 2010-08-26 08:15:00 | AAPL | Stock | 8.6832 | 8.6957 | 8.6786 | 8.6857 | 155680.0 |
| 2010-08-26 08:20:00 | AAPL | Stock | 8.6893 | 8.6932 | 8.6811 | 8.6911 | 59080.0 |
| 2010-08-26 08:25:00 | AAPL | Stock | 8.6843 | 8.6875 | 8.6786 | 8.6829 | 123256.0 |
| 2010-08-26 08:30:00 | AAPL | Stock | 8.6871 | 8.7529 | 8.6871 | 8.7521 | 1953616.0 |
| 2010-08-26 08:35:00 | AAPL | Stock | 8.7518 | 8.7546 | 8.7357 | 8.7357 | 827652.0 |
| 2010-08-26 08:40:00 | AAPL | Stock | 8.7357 | 8.7475 | 8.7332 | 8.7454 | 294700.0 |
| 2010-08-26 08:45:00 | AAPL | Stock | 8.7454 | 8.7454 | 8.7321 | 8.7357 | 192500.0 |
| 2010-08-26 08:50:00 | AAPL | Stock | 8.7361 | 8.75 | 8.7357 | 8.7464 | 1064280.0 |
| 2010-08-26 08:55:00 | AAPL | Stock | 8.7482 | 8.7564 | 8.7479 | 8.7532 | 627060.0 |
| 2010-08-26 09:00:00 | AAPL | Stock | 8.7507 | 8.7529 | 8.7361 | 8.7393 | 630812.0 |
| 2010-08-26 09:05:00 | AAPL | Stock | 8.7393 | 8.7464 | 8.7393 | 8.745 | 152012.0 |
| 2010-08-26 09:10:00 | AAPL | Stock | 8.7446 | 8.7464 | 8.7339 | 8.7339 | 280616.0 |
| 2010-08-26 09:15:00 | AAPL | Stock | 8.7375 | 8.7443 | 8.7343 | 8.7443 | 165368.0 |
| 2010-08-26 09:20:00 | AAPL | Stock | 8.7432 | 8.7479 | 8.7393 | 8.7393 | 96852.0 |
| 2010-08-26 09:25:00 | AAPL | Stock | 8.7375 | 8.7679 | 8.7332 | 8.7664 | 1246532.0 |
| 2010-08-26 09:30:00 | AAPL | Stock | 8.7632 | 8.7679 | 8.72 | 8.7215 | 18761484.0 |
| 2010-08-26 09:35:00 | AAPL | Stock | 8.7218 | 8.7579 | 8.7186 | 8.7396 | 12733784.0 |
| 2010-08-26 09:40:00 | AAPL | Stock | 8.7393 | 8.755 | 8.7211 | 8.7344 | 13393128.0 |
| 2010-08-26 09:45:00 | AAPL | Stock | 8.7346 | 8.7418 | 8.7182 | 8.7264 | 8248324.0 |
| 2010-08-26 09:50:00 | AAPL | Stock | 8.7268 | 8.7312 | 8.7007 | 8.7043 | 10942708.0 |
| 2010-08-26 09:55:00 | AAPL | Stock | 8.7043 | 8.7429 | 8.7029 | 8.7375 | 10593576.0 |
| 2010-08-26 10:00:00 | AAPL | Stock | 8.7357 | 8.7554 | 8.7336 | 8.7521 | 9790872.0 |
| 2010-08-26 10:05:00 | AAPL | Stock | 8.7518 | 8.7554 | 8.7421 | 8.7521 | 6868344.0 |
| 2010-08-26 10:10:00 | AAPL | Stock | 8.7514 | 8.7757 | 8.7479 | 8.7655 | 10547040.0 |
| 2010-08-26 10:15:00 | AAPL | Stock | 8.7652 | 8.7764 | 8.7579 | 8.7714 | 8745324.0 |
| 2010-08-26 10:20:00 | AAPL | Stock | 8.7736 | 8.7768 | 8.7557 | 8.7568 | 8000188.0 |
| 2010-08-26 10:25:00 | AAPL | Stock | 8.7586 | 8.7711 | 8.7525 | 8.7564 | 7761432.0 |
| 2010-08-26 10:30:00 | AAPL | Stock | 8.7582 | 8.76 | 8.7432 | 8.7539 | 7240632.0 |
| 2010-08-26 10:35:00 | AAPL | Stock | 8.7552 | 8.7693 | 8.7536 | 8.7596 | 6697264.0 |
> showing 50 of 316,283 rows — these rows as CSV