PREVIEW / stock_5min / 2005-08-15
file: by_date/stock_5min/2005/2005-08-15.parquet size: 2.8 MB rows: 203,860 symbols: 2,062
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-15 07:15:00 | AAPL | Stock | 1.6536 | 1.6679 | 1.6521 | 1.6532 | 80500.0 |
| 2005-08-15 07:20:00 | AAPL | Stock | 1.6532 | 1.6554 | 1.6532 | 1.6536 | 56000.0 |
| 2005-08-15 07:25:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6532 | 1.6532 | 28000.0 |
| 2005-08-15 07:35:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 14000.0 |
| 2005-08-15 07:50:00 | AAPL | Stock | 1.6475 | 1.6475 | 1.6475 | 1.6475 | 2800.0 |
| 2005-08-15 07:55:00 | AAPL | Stock | 1.65 | 1.65 | 1.6461 | 1.6482 | 567560.0 |
| 2005-08-15 08:00:00 | AAPL | Stock | 1.6493 | 1.6521 | 1.6486 | 1.6507 | 1723568.0 |
| 2005-08-15 08:05:00 | AAPL | Stock | 1.6518 | 1.6546 | 1.6518 | 1.6536 | 282352.0 |
| 2005-08-15 08:10:00 | AAPL | Stock | 1.6546 | 1.655 | 1.65 | 1.6546 | 243348.0 |
| 2005-08-15 08:15:00 | AAPL | Stock | 1.655 | 1.6582 | 1.6536 | 1.6582 | 441560.0 |
| 2005-08-15 08:20:00 | AAPL | Stock | 1.6586 | 1.6621 | 1.6571 | 1.6571 | 994028.0 |
| 2005-08-15 08:25:00 | AAPL | Stock | 1.6568 | 1.6786 | 1.6554 | 1.6639 | 2065700.0 |
| 2005-08-15 08:30:00 | AAPL | Stock | 1.6639 | 1.6679 | 1.6625 | 1.6679 | 1617280.0 |
| 2005-08-15 08:35:00 | AAPL | Stock | 1.6661 | 1.6696 | 1.6661 | 1.6689 | 2242604.0 |
| 2005-08-15 08:40:00 | AAPL | Stock | 1.6693 | 1.6714 | 1.6643 | 1.6661 | 1460228.0 |
| 2005-08-15 08:45:00 | AAPL | Stock | 1.6646 | 1.6675 | 1.6625 | 1.6671 | 516068.0 |
| 2005-08-15 08:50:00 | AAPL | Stock | 1.6664 | 1.6664 | 1.6639 | 1.6654 | 333256.0 |
| 2005-08-15 08:55:00 | AAPL | Stock | 1.6646 | 1.6646 | 1.6607 | 1.6639 | 496832.0 |
| 2005-08-15 09:00:00 | AAPL | Stock | 1.6618 | 1.6636 | 1.6604 | 1.6636 | 602840.0 |
| 2005-08-15 09:05:00 | AAPL | Stock | 1.6636 | 1.6714 | 1.6636 | 1.6679 | 2020760.0 |
| 2005-08-15 09:10:00 | AAPL | Stock | 1.6668 | 1.6721 | 1.6664 | 1.67 | 1831200.0 |
| 2005-08-15 09:15:00 | AAPL | Stock | 1.6704 | 1.6746 | 1.6682 | 1.6729 | 1288560.0 |
| 2005-08-15 09:20:00 | AAPL | Stock | 1.6729 | 1.6732 | 1.6657 | 1.6675 | 1701140.0 |
| 2005-08-15 09:25:00 | AAPL | Stock | 1.6646 | 1.67 | 1.6604 | 1.6607 | 2141972.0 |
| 2005-08-15 09:30:00 | AAPL | Stock | 1.66 | 1.6846 | 1.6589 | 1.6814 | 66429440.0 |
| 2005-08-15 09:35:00 | AAPL | Stock | 1.6814 | 1.6857 | 1.6629 | 1.6743 | 41351688.0 |
| 2005-08-15 09:40:00 | AAPL | Stock | 1.6743 | 1.6814 | 1.6739 | 1.6814 | 24172484.0 |
| 2005-08-15 09:45:00 | AAPL | Stock | 1.6814 | 1.6875 | 1.6789 | 1.6846 | 27328728.0 |
| 2005-08-15 09:50:00 | AAPL | Stock | 1.6846 | 1.69 | 1.6821 | 1.6893 | 36185660.0 |
| 2005-08-15 09:55:00 | AAPL | Stock | 1.6896 | 1.6957 | 1.6864 | 1.695 | 40509560.0 |
| 2005-08-15 10:00:00 | AAPL | Stock | 1.695 | 1.6954 | 1.6886 | 1.6909 | 29606920.0 |
| 2005-08-15 10:05:00 | AAPL | Stock | 1.6911 | 1.6943 | 1.6857 | 1.6868 | 19717628.0 |
| 2005-08-15 10:10:00 | AAPL | Stock | 1.6868 | 1.6929 | 1.6843 | 1.6907 | 16505496.0 |
| 2005-08-15 10:15:00 | AAPL | Stock | 1.6911 | 1.6986 | 1.6904 | 1.6968 | 24724728.0 |
| 2005-08-15 10:20:00 | AAPL | Stock | 1.6964 | 1.6996 | 1.6925 | 1.6936 | 18443012.0 |
| 2005-08-15 10:25:00 | AAPL | Stock | 1.6936 | 1.6996 | 1.6932 | 1.6979 | 15102892.0 |
| 2005-08-15 10:30:00 | AAPL | Stock | 1.6982 | 1.7068 | 1.6982 | 1.7046 | 21725788.0 |
| 2005-08-15 10:35:00 | AAPL | Stock | 1.7046 | 1.7125 | 1.7 | 1.7111 | 29267952.0 |
| 2005-08-15 10:40:00 | AAPL | Stock | 1.7107 | 1.7111 | 1.7032 | 1.7036 | 24247356.0 |
| 2005-08-15 10:45:00 | AAPL | Stock | 1.7039 | 1.7061 | 1.7011 | 1.7046 | 12453280.0 |
| 2005-08-15 10:50:00 | AAPL | Stock | 1.7046 | 1.7071 | 1.6957 | 1.6996 | 15532664.0 |
| 2005-08-15 10:55:00 | AAPL | Stock | 1.6993 | 1.7036 | 1.6961 | 1.7036 | 11355316.0 |
| 2005-08-15 11:00:00 | AAPL | Stock | 1.7036 | 1.7054 | 1.7011 | 1.7032 | 9566536.0 |
| 2005-08-15 11:05:00 | AAPL | Stock | 1.7032 | 1.7054 | 1.7 | 1.701 | 8095668.0 |
| 2005-08-15 11:10:00 | AAPL | Stock | 1.7011 | 1.7046 | 1.6989 | 1.7029 | 13841856.0 |
| 2005-08-15 11:15:00 | AAPL | Stock | 1.7021 | 1.7054 | 1.7018 | 1.7018 | 9769424.0 |
| 2005-08-15 11:20:00 | AAPL | Stock | 1.7018 | 1.7071 | 1.6986 | 1.7039 | 11541684.0 |
| 2005-08-15 11:25:00 | AAPL | Stock | 1.7039 | 1.7039 | 1.7 | 1.7011 | 7549640.0 |
| 2005-08-15 11:30:00 | AAPL | Stock | 1.7011 | 1.7036 | 1.6964 | 1.6975 | 11008396.0 |
| 2005-08-15 11:35:00 | AAPL | Stock | 1.6979 | 1.7025 | 1.6975 | 1.7011 | 8165388.0 |
> showing 50 of 203,860 rows — these rows as CSV