PREVIEW / stock_5min / 2008-05-19
file: by_date/stock_5min/2008/2008-05-19.parquet size: 4.6 MB rows: 323,930 symbols: 3,314
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-19 07:00:00 | AAPL | Stock | 6.7179 | 6.7179 | 6.7179 | 6.7179 | 2800.0 |
| 2008-05-19 07:10:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6614 | 6.665 | 191800.0 |
| 2008-05-19 07:15:00 | AAPL | Stock | 6.6654 | 6.6668 | 6.6654 | 6.6668 | 136500.0 |
| 2008-05-19 07:25:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 5600.0 |
| 2008-05-19 07:35:00 | AAPL | Stock | 6.6689 | 6.6689 | 6.6689 | 6.6689 | 14000.0 |
| 2008-05-19 07:55:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2008-05-19 08:00:00 | AAPL | Stock | 6.6743 | 6.705 | 6.6743 | 6.6925 | 148400.0 |
| 2008-05-19 08:05:00 | AAPL | Stock | 6.6964 | 6.6989 | 6.6796 | 6.6929 | 205324.0 |
| 2008-05-19 08:10:00 | AAPL | Stock | 6.6946 | 6.705 | 6.6925 | 6.705 | 164752.0 |
| 2008-05-19 08:15:00 | AAPL | Stock | 6.7089 | 6.7179 | 6.7082 | 6.7107 | 222180.0 |
| 2008-05-19 08:20:00 | AAPL | Stock | 6.7107 | 6.7136 | 6.7054 | 6.7079 | 138712.0 |
| 2008-05-19 08:25:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 13580.0 |
| 2008-05-19 08:30:00 | AAPL | Stock | 6.7079 | 6.7079 | 6.7057 | 6.7057 | 9576.0 |
| 2008-05-19 08:35:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 14000.0 |
| 2008-05-19 08:40:00 | AAPL | Stock | 6.7064 | 6.7089 | 6.705 | 6.7079 | 35000.0 |
| 2008-05-19 08:45:00 | AAPL | Stock | 6.7132 | 6.7143 | 6.7111 | 6.7143 | 89600.0 |
| 2008-05-19 08:50:00 | AAPL | Stock | 6.7143 | 6.715 | 6.7132 | 6.7146 | 165480.0 |
| 2008-05-19 08:55:00 | AAPL | Stock | 6.7136 | 6.7146 | 6.7132 | 6.7136 | 137760.0 |
| 2008-05-19 09:00:00 | AAPL | Stock | 6.7125 | 6.7132 | 6.7089 | 6.7089 | 193200.0 |
| 2008-05-19 09:05:00 | AAPL | Stock | 6.7104 | 6.7104 | 6.7061 | 6.7079 | 192500.0 |
| 2008-05-19 09:10:00 | AAPL | Stock | 6.7089 | 6.7107 | 6.7082 | 6.7082 | 154140.0 |
| 2008-05-19 09:15:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 8400.0 |
| 2008-05-19 09:20:00 | AAPL | Stock | 6.7093 | 6.7093 | 6.6954 | 6.6971 | 92008.0 |
| 2008-05-19 09:25:00 | AAPL | Stock | 6.6971 | 6.7114 | 6.6961 | 6.7096 | 326060.0 |
| 2008-05-19 09:30:00 | AAPL | Stock | 6.7075 | 6.7125 | 6.6607 | 6.6704 | 23215640.0 |
| 2008-05-19 09:35:00 | AAPL | Stock | 6.6704 | 6.6907 | 6.6661 | 6.6679 | 12192348.0 |
| 2008-05-19 09:40:00 | AAPL | Stock | 6.6686 | 6.69 | 6.6546 | 6.6593 | 14843724.0 |
| 2008-05-19 09:45:00 | AAPL | Stock | 6.6582 | 6.6814 | 6.6582 | 6.6746 | 12912788.0 |
| 2008-05-19 09:50:00 | AAPL | Stock | 6.6746 | 6.6839 | 6.6504 | 6.6657 | 14972216.0 |
| 2008-05-19 09:55:00 | AAPL | Stock | 6.6654 | 6.6675 | 6.6464 | 6.6607 | 11931752.0 |
| 2008-05-19 10:00:00 | AAPL | Stock | 6.6611 | 6.675 | 6.6536 | 6.6743 | 12989256.0 |
| 2008-05-19 10:05:00 | AAPL | Stock | 6.6743 | 6.7239 | 6.6739 | 6.7168 | 21221648.0 |
| 2008-05-19 10:10:00 | AAPL | Stock | 6.7168 | 6.7257 | 6.6936 | 6.6968 | 16221744.0 |
| 2008-05-19 10:15:00 | AAPL | Stock | 6.6961 | 6.7018 | 6.6811 | 6.6879 | 12381992.0 |
| 2008-05-19 10:20:00 | AAPL | Stock | 6.6886 | 6.6929 | 6.6696 | 6.6736 | 13772136.0 |
| 2008-05-19 10:25:00 | AAPL | Stock | 6.6732 | 6.6779 | 6.6543 | 6.6621 | 17533936.0 |
| 2008-05-19 10:30:00 | AAPL | Stock | 6.6621 | 6.675 | 6.6546 | 6.6679 | 11035192.0 |
| 2008-05-19 10:35:00 | AAPL | Stock | 6.6689 | 6.6768 | 6.6614 | 6.6618 | 12732132.0 |
| 2008-05-19 10:40:00 | AAPL | Stock | 6.6621 | 6.6632 | 6.6486 | 6.65 | 14964796.0 |
| 2008-05-19 10:45:00 | AAPL | Stock | 6.6496 | 6.665 | 6.6439 | 6.6554 | 13919864.0 |
| 2008-05-19 10:50:00 | AAPL | Stock | 6.6561 | 6.6739 | 6.6507 | 6.6714 | 9210348.0 |
| 2008-05-19 10:55:00 | AAPL | Stock | 6.6714 | 6.6739 | 6.6564 | 6.6593 | 7765632.0 |
| 2008-05-19 11:00:00 | AAPL | Stock | 6.6593 | 6.663 | 6.65 | 6.6521 | 6000820.0 |
| 2008-05-19 11:05:00 | AAPL | Stock | 6.6521 | 6.6564 | 6.6411 | 6.6521 | 14342636.0 |
| 2008-05-19 11:10:00 | AAPL | Stock | 6.6511 | 6.6661 | 6.6461 | 6.6596 | 7059360.0 |
| 2008-05-19 11:15:00 | AAPL | Stock | 6.6596 | 6.6818 | 6.6554 | 6.6768 | 10719744.0 |
| 2008-05-19 11:20:00 | AAPL | Stock | 6.6764 | 6.68 | 6.6679 | 6.6732 | 11837700.0 |
| 2008-05-19 11:25:00 | AAPL | Stock | 6.6734 | 6.6768 | 6.6589 | 6.6596 | 7840924.0 |
| 2008-05-19 11:30:00 | AAPL | Stock | 6.6604 | 6.6625 | 6.6518 | 6.6527 | 5558140.0 |
| 2008-05-19 11:35:00 | AAPL | Stock | 6.6529 | 6.6579 | 6.6457 | 6.6493 | 8074164.0 |
> showing 50 of 323,930 rows — these rows as CSV