PREVIEW / stock_5min / 2007-11-30
file: by_date/stock_5min/2007/2007-11-30.parquet size: 4.5 MB rows: 326,280 symbols: 3,229
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-30 04:20:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2007-11-30 04:35:00 | AAPL | Stock | 6.6871 | 6.6871 | 6.6871 | 6.6871 | 5600.0 |
| 2007-11-30 04:40:00 | AAPL | Stock | 6.665 | 6.665 | 6.665 | 6.665 | 5600.0 |
| 2007-11-30 04:55:00 | AAPL | Stock | 6.7029 | 6.7029 | 6.7029 | 6.7029 | 2800.0 |
| 2007-11-30 05:00:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.7036 | 6.7036 | 2800.0 |
| 2007-11-30 05:20:00 | AAPL | Stock | 6.6975 | 6.6975 | 6.6975 | 6.6975 | 2800.0 |
| 2007-11-30 05:30:00 | AAPL | Stock | 6.6975 | 6.6975 | 6.6975 | 6.6975 | 2800.0 |
| 2007-11-30 05:45:00 | AAPL | Stock | 6.7086 | 6.7086 | 6.6964 | 6.6964 | 8400.0 |
| 2007-11-30 05:55:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6579 | 6.6579 | 85652.0 |
| 2007-11-30 06:05:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6704 | 6.6704 | 11200.0 |
| 2007-11-30 06:35:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6704 | 6.6704 | 2800.0 |
| 2007-11-30 06:45:00 | AAPL | Stock | 6.6679 | 6.6679 | 6.6679 | 6.6679 | 5600.0 |
| 2007-11-30 06:50:00 | AAPL | Stock | 6.6579 | 6.6579 | 6.6554 | 6.6554 | 50792.0 |
| 2007-11-30 06:55:00 | AAPL | Stock | 6.6521 | 6.6521 | 6.6521 | 6.6521 | 5600.0 |
| 2007-11-30 07:00:00 | AAPL | Stock | 6.6554 | 6.6704 | 6.6554 | 6.6704 | 58912.0 |
| 2007-11-30 07:05:00 | AAPL | Stock | 6.675 | 6.7139 | 6.675 | 6.6964 | 115500.0 |
| 2007-11-30 07:10:00 | AAPL | Stock | 6.6964 | 6.7054 | 6.6911 | 6.7029 | 422800.0 |
| 2007-11-30 07:15:00 | AAPL | Stock | 6.6804 | 6.6804 | 6.6796 | 6.6796 | 35280.0 |
| 2007-11-30 07:20:00 | AAPL | Stock | 6.6957 | 6.6982 | 6.6954 | 6.6982 | 92820.0 |
| 2007-11-30 07:25:00 | AAPL | Stock | 6.6982 | 6.7036 | 6.6979 | 6.6979 | 418880.0 |
| 2007-11-30 07:30:00 | AAPL | Stock | 6.6896 | 6.6979 | 6.6893 | 6.6979 | 77952.0 |
| 2007-11-30 07:35:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6893 | 6.6893 | 40460.0 |
| 2007-11-30 07:40:00 | AAPL | Stock | 6.6893 | 6.7 | 6.6857 | 6.6857 | 105700.0 |
| 2007-11-30 07:45:00 | AAPL | Stock | 6.6893 | 6.6929 | 6.6821 | 6.6843 | 170520.0 |
| 2007-11-30 07:50:00 | AAPL | Stock | 6.6904 | 6.6904 | 6.6857 | 6.6893 | 39200.0 |
| 2007-11-30 07:55:00 | AAPL | Stock | 6.6821 | 6.725 | 6.6821 | 6.6971 | 744240.0 |
| 2007-11-30 08:00:00 | AAPL | Stock | 6.6964 | 6.7089 | 6.6893 | 6.7 | 2087764.0 |
| 2007-11-30 08:05:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.6721 | 6.6721 | 1310036.0 |
| 2007-11-30 08:10:00 | AAPL | Stock | 6.6786 | 6.6832 | 6.6718 | 6.6786 | 848148.0 |
| 2007-11-30 08:15:00 | AAPL | Stock | 6.6764 | 6.6836 | 6.6757 | 6.6807 | 618436.0 |
| 2007-11-30 08:20:00 | AAPL | Stock | 6.6807 | 6.6964 | 6.6775 | 6.6957 | 557732.0 |
| 2007-11-30 08:25:00 | AAPL | Stock | 6.6957 | 6.7036 | 6.6879 | 6.6968 | 657804.0 |
| 2007-11-30 08:30:00 | AAPL | Stock | 6.6896 | 6.6968 | 6.6896 | 6.6943 | 275604.0 |
| 2007-11-30 08:35:00 | AAPL | Stock | 6.6896 | 6.6946 | 6.6893 | 6.6946 | 172032.0 |
| 2007-11-30 08:40:00 | AAPL | Stock | 6.6946 | 6.6946 | 6.6911 | 6.6929 | 488152.0 |
| 2007-11-30 08:45:00 | AAPL | Stock | 6.6936 | 6.7036 | 6.6929 | 6.7 | 847644.0 |
| 2007-11-30 08:50:00 | AAPL | Stock | 6.6964 | 6.7036 | 6.6929 | 6.7021 | 934332.0 |
| 2007-11-30 08:55:00 | AAPL | Stock | 6.7018 | 6.7021 | 6.6961 | 6.6964 | 650860.0 |
| 2007-11-30 09:00:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6857 | 6.6875 | 412692.0 |
| 2007-11-30 09:05:00 | AAPL | Stock | 6.6893 | 6.6921 | 6.6864 | 6.6911 | 330596.0 |
| 2007-11-30 09:10:00 | AAPL | Stock | 6.6889 | 6.7 | 6.6879 | 6.7 | 747012.0 |
| 2007-11-30 09:15:00 | AAPL | Stock | 6.7 | 6.7 | 6.6868 | 6.6907 | 404740.0 |
| 2007-11-30 09:20:00 | AAPL | Stock | 6.6918 | 6.6918 | 6.6807 | 6.685 | 435624.0 |
| 2007-11-30 09:25:00 | AAPL | Stock | 6.685 | 6.7018 | 6.6771 | 6.6939 | 1468796.0 |
| 2007-11-30 09:30:00 | AAPL | Stock | 6.6921 | 6.6989 | 6.6696 | 6.6982 | 42160916.0 |
| 2007-11-30 09:35:00 | AAPL | Stock | 6.6989 | 6.7036 | 6.6771 | 6.6786 | 27557348.0 |
| 2007-11-30 09:40:00 | AAPL | Stock | 6.6786 | 6.6982 | 6.6754 | 6.6775 | 24517164.0 |
| 2007-11-30 09:45:00 | AAPL | Stock | 6.6779 | 6.6886 | 6.6668 | 6.6796 | 26419148.0 |
| 2007-11-30 09:50:00 | AAPL | Stock | 6.6796 | 6.6836 | 6.6607 | 6.6682 | 23123072.0 |
| 2007-11-30 09:55:00 | AAPL | Stock | 6.6689 | 6.6996 | 6.6682 | 6.6846 | 25774588.0 |
> showing 50 of 326,280 rows — these rows as CSV