PREVIEW / stock_5min / 2006-09-20
file: by_date/stock_5min/2006/2006-09-20.parquet size: 3.1 MB rows: 228,315 symbols: 2,375
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-20 07:00:00 | AAPL | Stock | 2.6443 | 2.6443 | 2.6429 | 2.6429 | 19600.0 |
| 2006-09-20 08:00:00 | AAPL | Stock | 2.65 | 2.6518 | 2.6429 | 2.6429 | 264516.0 |
| 2006-09-20 08:05:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6464 | 2.6464 | 9828.0 |
| 2006-09-20 08:15:00 | AAPL | Stock | 2.6486 | 2.6486 | 2.6486 | 2.6486 | 2800.0 |
| 2006-09-20 08:20:00 | AAPL | Stock | 2.65 | 2.65 | 2.65 | 2.65 | 112000.0 |
| 2006-09-20 08:25:00 | AAPL | Stock | 2.6486 | 2.65 | 2.6486 | 2.6489 | 61040.0 |
| 2006-09-20 08:30:00 | AAPL | Stock | 2.6493 | 2.6554 | 2.6489 | 2.6532 | 170240.0 |
| 2006-09-20 08:35:00 | AAPL | Stock | 2.6532 | 2.6554 | 2.6532 | 2.6554 | 93800.0 |
| 2006-09-20 08:40:00 | AAPL | Stock | 2.65 | 2.6571 | 2.6346 | 2.6536 | 197512.0 |
| 2006-09-20 08:45:00 | AAPL | Stock | 2.6536 | 2.6554 | 2.6536 | 2.6554 | 72800.0 |
| 2006-09-20 08:50:00 | AAPL | Stock | 2.6571 | 2.6579 | 2.6539 | 2.6571 | 148400.0 |
| 2006-09-20 08:55:00 | AAPL | Stock | 2.6571 | 2.6571 | 2.655 | 2.655 | 95704.0 |
| 2006-09-20 09:00:00 | AAPL | Stock | 2.6539 | 2.6554 | 2.6539 | 2.6554 | 161000.0 |
| 2006-09-20 09:05:00 | AAPL | Stock | 2.6564 | 2.6564 | 2.6557 | 2.6564 | 29120.0 |
| 2006-09-20 09:10:00 | AAPL | Stock | 2.6564 | 2.6571 | 2.6564 | 2.6571 | 224000.0 |
| 2006-09-20 09:15:00 | AAPL | Stock | 2.6571 | 2.6579 | 2.6564 | 2.6579 | 144396.0 |
| 2006-09-20 09:20:00 | AAPL | Stock | 2.6564 | 2.6575 | 2.6564 | 2.6568 | 46200.0 |
| 2006-09-20 09:25:00 | AAPL | Stock | 2.6557 | 2.6596 | 2.6554 | 2.6561 | 409108.0 |
| 2006-09-20 09:30:00 | AAPL | Stock | 2.6564 | 2.6661 | 2.6518 | 2.6561 | 22031884.0 |
| 2006-09-20 09:35:00 | AAPL | Stock | 2.6554 | 2.6607 | 2.6507 | 2.6548 | 10525200.0 |
| 2006-09-20 09:40:00 | AAPL | Stock | 2.6546 | 2.6607 | 2.6536 | 2.6607 | 11101244.0 |
| 2006-09-20 09:45:00 | AAPL | Stock | 2.6607 | 2.6696 | 2.6589 | 2.6682 | 23267832.0 |
| 2006-09-20 09:50:00 | AAPL | Stock | 2.6682 | 2.6786 | 2.6679 | 2.6689 | 27829368.0 |
| 2006-09-20 09:55:00 | AAPL | Stock | 2.6689 | 2.6729 | 2.6661 | 2.6664 | 11520264.0 |
| 2006-09-20 10:00:00 | AAPL | Stock | 2.6664 | 2.6711 | 2.6607 | 2.6614 | 9730280.0 |
| 2006-09-20 10:05:00 | AAPL | Stock | 2.6614 | 2.6689 | 2.6575 | 2.6671 | 11516120.0 |
| 2006-09-20 10:10:00 | AAPL | Stock | 2.6671 | 2.6682 | 2.6611 | 2.6629 | 6038788.0 |
| 2006-09-20 10:15:00 | AAPL | Stock | 2.6632 | 2.67 | 2.6621 | 2.6689 | 7111188.0 |
| 2006-09-20 10:20:00 | AAPL | Stock | 2.6686 | 2.6754 | 2.6682 | 2.6732 | 11434780.0 |
| 2006-09-20 10:25:00 | AAPL | Stock | 2.6738 | 2.6775 | 2.6704 | 2.6761 | 13777092.0 |
| 2006-09-20 10:30:00 | AAPL | Stock | 2.6764 | 2.6782 | 2.6729 | 2.6746 | 11855004.0 |
| 2006-09-20 10:35:00 | AAPL | Stock | 2.6742 | 2.6746 | 2.6689 | 2.6721 | 8165304.0 |
| 2006-09-20 10:40:00 | AAPL | Stock | 2.6718 | 2.6768 | 2.6707 | 2.6764 | 6054916.0 |
| 2006-09-20 10:45:00 | AAPL | Stock | 2.6764 | 2.6786 | 2.6739 | 2.6757 | 23510564.0 |
| 2006-09-20 10:50:00 | AAPL | Stock | 2.6757 | 2.6775 | 2.6718 | 2.6764 | 9950864.0 |
| 2006-09-20 10:55:00 | AAPL | Stock | 2.6764 | 2.6889 | 2.6764 | 2.6886 | 34855464.0 |
| 2006-09-20 11:00:00 | AAPL | Stock | 2.6882 | 2.6943 | 2.6864 | 2.6943 | 19381684.0 |
| 2006-09-20 11:05:00 | AAPL | Stock | 2.6943 | 2.6982 | 2.6929 | 2.6957 | 19439840.0 |
| 2006-09-20 11:10:00 | AAPL | Stock | 2.6954 | 2.6968 | 2.6889 | 2.6893 | 16234764.0 |
| 2006-09-20 11:15:00 | AAPL | Stock | 2.6893 | 2.6921 | 2.6861 | 2.6904 | 10742564.0 |
| 2006-09-20 11:20:00 | AAPL | Stock | 2.6907 | 2.6946 | 2.6882 | 2.6929 | 12356596.0 |
| 2006-09-20 11:25:00 | AAPL | Stock | 2.6932 | 2.7018 | 2.6932 | 2.6995 | 16658964.0 |
| 2006-09-20 11:30:00 | AAPL | Stock | 2.6993 | 2.7029 | 2.6954 | 2.7 | 13829284.0 |
| 2006-09-20 11:35:00 | AAPL | Stock | 2.7 | 2.7 | 2.6936 | 2.6939 | 9393552.0 |
| 2006-09-20 11:40:00 | AAPL | Stock | 2.6939 | 2.6968 | 2.6918 | 2.6961 | 4644808.0 |
| 2006-09-20 11:45:00 | AAPL | Stock | 2.6954 | 2.6961 | 2.6904 | 2.6936 | 5755316.0 |
| 2006-09-20 11:50:00 | AAPL | Stock | 2.6936 | 2.7004 | 2.6936 | 2.6949 | 9334528.0 |
| 2006-09-20 11:55:00 | AAPL | Stock | 2.6946 | 2.6954 | 2.6907 | 2.6921 | 6287764.0 |
| 2006-09-20 12:00:00 | AAPL | Stock | 2.692 | 2.6946 | 2.6879 | 2.6929 | 6897044.0 |
| 2006-09-20 12:05:00 | AAPL | Stock | 2.6929 | 2.6954 | 2.6921 | 2.6929 | 3879568.0 |
> showing 50 of 228,315 rows — these rows as CSV