PREVIEW / stock_1min / 2007-09-07
file: by_date/stock_1min/2007/2007-09-07.parquet size: 11.3 MB rows: 926,606 symbols: 2,550
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-09-07 09:30:00 | AAPL | Stock | 4.7146 | 4.7182 | 4.6918 | 4.6971 | 24712380.0 |
| 2007-09-07 09:31:00 | AAPL | Stock | 4.6968 | 4.7149 | 4.6639 | 4.6643 | 15107204.0 |
| 2007-09-07 09:32:00 | AAPL | Stock | 4.665 | 4.6829 | 4.6611 | 4.67 | 13652408.0 |
| 2007-09-07 09:33:00 | AAPL | Stock | 4.6675 | 4.6864 | 4.6629 | 4.6854 | 10989104.0 |
| 2007-09-07 09:34:00 | AAPL | Stock | 4.6857 | 4.7146 | 4.6646 | 4.6714 | 7948836.0 |
| 2007-09-07 09:35:00 | AAPL | Stock | 4.6711 | 4.6907 | 4.6669 | 4.6771 | 8741124.0 |
| 2007-09-07 09:36:00 | AAPL | Stock | 4.6757 | 4.6879 | 4.6646 | 4.685 | 7331772.0 |
| 2007-09-07 09:37:00 | AAPL | Stock | 4.6839 | 4.6911 | 4.6757 | 4.6764 | 7359156.0 |
| 2007-09-07 09:38:00 | AAPL | Stock | 4.6764 | 4.6771 | 4.6546 | 4.665 | 11663680.0 |
| 2007-09-07 09:39:00 | AAPL | Stock | 4.6643 | 4.6793 | 4.6614 | 4.6732 | 7351988.0 |
| 2007-09-07 09:40:00 | AAPL | Stock | 4.6732 | 4.6846 | 4.6675 | 4.6771 | 7449316.0 |
| 2007-09-07 09:41:00 | AAPL | Stock | 4.6771 | 4.6807 | 4.6696 | 4.6732 | 5516168.0 |
| 2007-09-07 09:42:00 | AAPL | Stock | 4.6715 | 4.6804 | 4.6707 | 4.6771 | 4708312.0 |
| 2007-09-07 09:43:00 | AAPL | Stock | 4.6771 | 4.6929 | 4.6766 | 4.6911 | 8857464.0 |
| 2007-09-07 09:44:00 | AAPL | Stock | 4.6911 | 4.6916 | 4.6786 | 4.6893 | 5443172.0 |
| 2007-09-07 09:45:00 | AAPL | Stock | 4.6893 | 4.69 | 4.6761 | 4.6768 | 7030380.0 |
| 2007-09-07 09:46:00 | AAPL | Stock | 4.6764 | 4.6775 | 4.6679 | 4.6771 | 6085296.0 |
| 2007-09-07 09:47:00 | AAPL | Stock | 4.6768 | 4.6829 | 4.6754 | 4.6754 | 4722536.0 |
| 2007-09-07 09:48:00 | AAPL | Stock | 4.6757 | 4.6789 | 4.6696 | 4.6707 | 5973548.0 |
| 2007-09-07 09:49:00 | AAPL | Stock | 4.67 | 4.6814 | 4.6679 | 4.6804 | 5899656.0 |
| 2007-09-07 09:50:00 | AAPL | Stock | 4.679 | 4.6961 | 4.6779 | 4.6961 | 10752084.0 |
| 2007-09-07 09:51:00 | AAPL | Stock | 4.6961 | 4.6979 | 4.6804 | 4.6843 | 6729800.0 |
| 2007-09-07 09:52:00 | AAPL | Stock | 4.6843 | 4.6886 | 4.6786 | 4.6876 | 6054132.0 |
| 2007-09-07 09:53:00 | AAPL | Stock | 4.6886 | 4.6893 | 4.6829 | 4.6875 | 3980032.0 |
| 2007-09-07 09:54:00 | AAPL | Stock | 4.6879 | 4.6946 | 4.6875 | 4.6921 | 5444796.0 |
| 2007-09-07 09:55:00 | AAPL | Stock | 4.6925 | 4.6925 | 4.6829 | 4.6871 | 4125604.0 |
| 2007-09-07 09:56:00 | AAPL | Stock | 4.6871 | 4.6907 | 4.6846 | 4.6879 | 4185776.0 |
| 2007-09-07 09:57:00 | AAPL | Stock | 4.6882 | 4.6921 | 4.6807 | 4.6814 | 4607792.0 |
| 2007-09-07 09:58:00 | AAPL | Stock | 4.6814 | 4.6861 | 4.6757 | 4.6822 | 6110104.0 |
| 2007-09-07 09:59:00 | AAPL | Stock | 4.6829 | 4.6857 | 4.6789 | 4.68 | 2576000.0 |
| 2007-09-07 10:00:00 | AAPL | Stock | 4.6814 | 4.6814 | 4.6723 | 4.6743 | 5024572.0 |
| 2007-09-07 10:01:00 | AAPL | Stock | 4.6743 | 4.6793 | 4.6732 | 4.6789 | 3144148.0 |
| 2007-09-07 10:02:00 | AAPL | Stock | 4.6793 | 4.6854 | 4.6782 | 4.6846 | 4830224.0 |
| 2007-09-07 10:03:00 | AAPL | Stock | 4.6843 | 4.6929 | 4.6811 | 4.6918 | 5608932.0 |
| 2007-09-07 10:04:00 | AAPL | Stock | 4.6929 | 4.6993 | 4.6886 | 4.6889 | 7548800.0 |
| 2007-09-07 10:05:00 | AAPL | Stock | 4.6896 | 4.7014 | 4.6886 | 4.6986 | 5794880.0 |
| 2007-09-07 10:06:00 | AAPL | Stock | 4.7004 | 4.7008 | 4.6929 | 4.6957 | 4164776.0 |
| 2007-09-07 10:07:00 | AAPL | Stock | 4.695 | 4.6979 | 4.6936 | 4.6946 | 3045812.0 |
| 2007-09-07 10:08:00 | AAPL | Stock | 4.6957 | 4.6957 | 4.6832 | 4.685 | 5285028.0 |
| 2007-09-07 10:09:00 | AAPL | Stock | 4.6846 | 4.6886 | 4.6804 | 4.6821 | 4524156.0 |
| 2007-09-07 10:10:00 | AAPL | Stock | 4.6811 | 4.6882 | 4.6786 | 4.6811 | 3651200.0 |
| 2007-09-07 10:11:00 | AAPL | Stock | 4.68 | 4.6846 | 4.6771 | 4.6793 | 4831400.0 |
| 2007-09-07 10:12:00 | AAPL | Stock | 4.68 | 4.6871 | 4.68 | 4.6832 | 2125816.0 |
| 2007-09-07 10:13:00 | AAPL | Stock | 4.6832 | 4.6846 | 4.68 | 4.6811 | 3671472.0 |
| 2007-09-07 10:14:00 | AAPL | Stock | 4.6814 | 4.6836 | 4.6768 | 4.6811 | 5902064.0 |
| 2007-09-07 10:15:00 | AAPL | Stock | 4.6814 | 4.683 | 4.6764 | 4.6793 | 4777612.0 |
| 2007-09-07 10:16:00 | AAPL | Stock | 4.6789 | 4.6875 | 4.6771 | 4.6857 | 3682700.0 |
| 2007-09-07 10:17:00 | AAPL | Stock | 4.6854 | 4.6946 | 4.6821 | 4.6911 | 5605880.0 |
| 2007-09-07 10:18:00 | AAPL | Stock | 4.6914 | 4.6946 | 4.6843 | 4.6914 | 4324824.0 |
| 2007-09-07 10:19:00 | AAPL | Stock | 4.6914 | 4.6921 | 4.6825 | 4.6896 | 2920036.0 |
> showing 50 of 926,606 rows — these rows as CSV