PREVIEW / stock_5min / 2008-01-31
file: by_date/stock_5min/2008/2008-01-31.parquet size: 4.6 MB rows: 326,229 symbols: 3,271
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-01-31 05:05:00 | AAPL | Stock | 4.6489 | 4.6489 | 4.6489 | 4.6489 | 3248.0 |
| 2008-01-31 07:25:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 8400.0 |
| 2008-01-31 07:30:00 | AAPL | Stock | 4.6857 | 4.6857 | 4.6786 | 4.6786 | 5600.0 |
| 2008-01-31 07:35:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 8400.0 |
| 2008-01-31 07:40:00 | AAPL | Stock | 4.6786 | 4.6946 | 4.6786 | 4.6946 | 11200.0 |
| 2008-01-31 07:50:00 | AAPL | Stock | 4.6904 | 4.6904 | 4.6904 | 4.6904 | 2800.0 |
| 2008-01-31 08:00:00 | AAPL | Stock | 4.685 | 4.7054 | 4.675 | 4.6821 | 232176.0 |
| 2008-01-31 08:05:00 | AAPL | Stock | 4.6807 | 4.6918 | 4.6786 | 4.6875 | 180768.0 |
| 2008-01-31 08:10:00 | AAPL | Stock | 4.6868 | 4.6911 | 4.6868 | 4.6904 | 42000.0 |
| 2008-01-31 08:15:00 | AAPL | Stock | 4.6893 | 4.7143 | 4.6893 | 4.7071 | 197204.0 |
| 2008-01-31 08:20:00 | AAPL | Stock | 4.7071 | 4.7071 | 4.7 | 4.7 | 56420.0 |
| 2008-01-31 08:25:00 | AAPL | Stock | 4.7018 | 4.7089 | 4.6946 | 4.7 | 152236.0 |
| 2008-01-31 08:30:00 | AAPL | Stock | 4.6982 | 4.6982 | 4.6661 | 4.6661 | 635908.0 |
| 2008-01-31 08:35:00 | AAPL | Stock | 4.6714 | 4.6718 | 4.65 | 4.6607 | 639296.0 |
| 2008-01-31 08:40:00 | AAPL | Stock | 4.6607 | 4.6661 | 4.6586 | 4.6611 | 447356.0 |
| 2008-01-31 08:45:00 | AAPL | Stock | 4.6632 | 4.6704 | 4.6543 | 4.655 | 484400.0 |
| 2008-01-31 08:50:00 | AAPL | Stock | 4.655 | 4.6571 | 4.6436 | 4.6464 | 668640.0 |
| 2008-01-31 08:55:00 | AAPL | Stock | 4.6443 | 4.65 | 4.6282 | 4.6282 | 813344.0 |
| 2008-01-31 09:00:00 | AAPL | Stock | 4.6282 | 4.6396 | 4.6236 | 4.6354 | 1516144.0 |
| 2008-01-31 09:05:00 | AAPL | Stock | 4.6354 | 4.6354 | 4.6089 | 4.6143 | 1130836.0 |
| 2008-01-31 09:10:00 | AAPL | Stock | 4.6143 | 4.6186 | 4.59 | 4.5979 | 3016608.0 |
| 2008-01-31 09:15:00 | AAPL | Stock | 4.5961 | 4.6014 | 4.5868 | 4.5964 | 1197084.0 |
| 2008-01-31 09:20:00 | AAPL | Stock | 4.5957 | 4.6196 | 4.5896 | 4.6161 | 909300.0 |
| 2008-01-31 09:25:00 | AAPL | Stock | 4.6164 | 4.6325 | 4.6079 | 4.6221 | 1928192.0 |
| 2008-01-31 09:30:00 | AAPL | Stock | 4.6229 | 4.6671 | 4.6214 | 4.6618 | 38150924.0 |
| 2008-01-31 09:35:00 | AAPL | Stock | 4.6618 | 4.6768 | 4.6446 | 4.6514 | 26060552.0 |
| 2008-01-31 09:40:00 | AAPL | Stock | 4.6504 | 4.6686 | 4.6425 | 4.6582 | 19585160.0 |
| 2008-01-31 09:45:00 | AAPL | Stock | 4.6582 | 4.68 | 4.6375 | 4.68 | 26630296.0 |
| 2008-01-31 09:50:00 | AAPL | Stock | 4.68 | 4.6875 | 4.6639 | 4.6639 | 25805612.0 |
| 2008-01-31 09:55:00 | AAPL | Stock | 4.6639 | 4.6875 | 4.6586 | 4.6789 | 24293948.0 |
| 2008-01-31 10:00:00 | AAPL | Stock | 4.6779 | 4.6843 | 4.6621 | 4.6793 | 19158496.0 |
| 2008-01-31 10:05:00 | AAPL | Stock | 4.6782 | 4.7096 | 4.6711 | 4.7014 | 29014300.0 |
| 2008-01-31 10:10:00 | AAPL | Stock | 4.7004 | 4.7107 | 4.6886 | 4.7007 | 20300504.0 |
| 2008-01-31 10:15:00 | AAPL | Stock | 4.7007 | 4.7075 | 4.6796 | 4.6836 | 17483144.0 |
| 2008-01-31 10:20:00 | AAPL | Stock | 4.6846 | 4.6943 | 4.6696 | 4.68 | 15139096.0 |
| 2008-01-31 10:25:00 | AAPL | Stock | 4.6793 | 4.6982 | 4.6757 | 4.6943 | 14289660.0 |
| 2008-01-31 10:30:00 | AAPL | Stock | 4.695 | 4.7164 | 4.6918 | 4.7046 | 19681620.0 |
| 2008-01-31 10:35:00 | AAPL | Stock | 4.7054 | 4.7096 | 4.6857 | 4.6941 | 14734944.0 |
| 2008-01-31 10:40:00 | AAPL | Stock | 4.6936 | 4.6946 | 4.6814 | 4.6821 | 9494576.0 |
| 2008-01-31 10:45:00 | AAPL | Stock | 4.6814 | 4.6893 | 4.6743 | 4.6882 | 10863300.0 |
| 2008-01-31 10:50:00 | AAPL | Stock | 4.6879 | 4.6968 | 4.6821 | 4.6964 | 9390416.0 |
| 2008-01-31 10:55:00 | AAPL | Stock | 4.6961 | 4.7068 | 4.6882 | 4.7043 | 12374544.0 |
| 2008-01-31 11:00:00 | AAPL | Stock | 4.7046 | 4.7132 | 4.7036 | 4.7039 | 14341264.0 |
| 2008-01-31 11:05:00 | AAPL | Stock | 4.7039 | 4.715 | 4.6971 | 4.7021 | 11296544.0 |
| 2008-01-31 11:10:00 | AAPL | Stock | 4.7018 | 4.7039 | 4.6896 | 4.6975 | 9911720.0 |
| 2008-01-31 11:15:00 | AAPL | Stock | 4.6975 | 4.7061 | 4.6939 | 4.7025 | 9378208.0 |
| 2008-01-31 11:20:00 | AAPL | Stock | 4.7021 | 4.7325 | 4.7 | 4.7304 | 19471900.0 |
| 2008-01-31 11:25:00 | AAPL | Stock | 4.7307 | 4.7632 | 4.7293 | 4.7561 | 24643696.0 |
| 2008-01-31 11:30:00 | AAPL | Stock | 4.7557 | 4.78 | 4.7489 | 4.7636 | 21293384.0 |
| 2008-01-31 11:35:00 | AAPL | Stock | 4.7636 | 4.7679 | 4.7404 | 4.7475 | 14685972.0 |
> showing 50 of 326,229 rows — these rows as CSV