PREVIEW / stock_1min / 2009-11-27
file: by_date/stock_1min/2009/2009-11-27.parquet size: 7.0 MB rows: 513,360 symbols: 2,704
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-27 04:15:00 | AAPL | Stock | 7.0707 | 7.1161 | 7.0707 | 7.1071 | 39200.0 |
| 2009-11-27 04:17:00 | AAPL | Stock | 7.0718 | 7.0718 | 7.0718 | 7.0718 | 2800.0 |
| 2009-11-27 04:56:00 | AAPL | Stock | 7.1025 | 7.1025 | 7.1025 | 7.1025 | 11200.0 |
| 2009-11-27 05:08:00 | AAPL | Stock | 7.0596 | 7.0596 | 7.0532 | 7.0532 | 8400.0 |
| 2009-11-27 05:14:00 | AAPL | Stock | 7.0364 | 7.0364 | 7.0361 | 7.0361 | 11200.0 |
| 2009-11-27 05:18:00 | AAPL | Stock | 7.0361 | 7.0361 | 7.0361 | 7.0361 | 18200.0 |
| 2009-11-27 05:20:00 | AAPL | Stock | 7.0361 | 7.0361 | 7.0361 | 7.0361 | 64400.0 |
| 2009-11-27 05:43:00 | AAPL | Stock | 7.0336 | 7.0336 | 7.0336 | 7.0336 | 2800.0 |
| 2009-11-27 06:32:00 | AAPL | Stock | 7.0514 | 7.0514 | 7.0514 | 7.0514 | 2800.0 |
| 2009-11-27 06:36:00 | AAPL | Stock | 7.0571 | 7.0618 | 7.0571 | 7.0618 | 30800.0 |
| 2009-11-27 06:37:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0607 | 7.0607 | 2800.0 |
| 2009-11-27 06:38:00 | AAPL | Stock | 7.0618 | 7.0618 | 7.0618 | 7.0618 | 5600.0 |
| 2009-11-27 06:39:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 2800.0 |
| 2009-11-27 06:40:00 | AAPL | Stock | 7.0768 | 7.0768 | 7.0768 | 7.0768 | 2800.0 |
| 2009-11-27 06:42:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 2800.0 |
| 2009-11-27 06:56:00 | AAPL | Stock | 7.0775 | 7.0775 | 7.0768 | 7.0768 | 61600.0 |
| 2009-11-27 06:57:00 | AAPL | Stock | 7.0768 | 7.0768 | 7.0768 | 7.0768 | 8400.0 |
| 2009-11-27 06:58:00 | AAPL | Stock | 7.075 | 7.075 | 7.0721 | 7.0732 | 17892.0 |
| 2009-11-27 07:00:00 | AAPL | Stock | 7.0736 | 7.0736 | 7.0736 | 7.0736 | 5600.0 |
| 2009-11-27 07:01:00 | AAPL | Stock | 7.075 | 7.0893 | 7.075 | 7.0893 | 23800.0 |
| 2009-11-27 07:02:00 | AAPL | Stock | 7.0911 | 7.0914 | 7.0911 | 7.0911 | 38612.0 |
| 2009-11-27 07:03:00 | AAPL | Stock | 7.0911 | 7.0911 | 7.0754 | 7.0754 | 14000.0 |
| 2009-11-27 07:08:00 | AAPL | Stock | 7.0896 | 7.0896 | 7.0771 | 7.0771 | 16800.0 |
| 2009-11-27 07:09:00 | AAPL | Stock | 7.09 | 7.09 | 7.09 | 7.09 | 2800.0 |
| 2009-11-27 07:10:00 | AAPL | Stock | 7.0771 | 7.0904 | 7.0771 | 7.0821 | 148400.0 |
| 2009-11-27 07:11:00 | AAPL | Stock | 7.0893 | 7.0929 | 7.0893 | 7.0929 | 30800.0 |
| 2009-11-27 07:12:00 | AAPL | Stock | 7.0807 | 7.0807 | 7.0807 | 7.0807 | 50400.0 |
| 2009-11-27 07:15:00 | AAPL | Stock | 7.0832 | 7.0832 | 7.0832 | 7.0832 | 2800.0 |
| 2009-11-27 07:16:00 | AAPL | Stock | 7.0986 | 7.0989 | 7.0986 | 7.0989 | 19600.0 |
| 2009-11-27 07:19:00 | AAPL | Stock | 7.1061 | 7.1071 | 7.1061 | 7.1071 | 34692.0 |
| 2009-11-27 07:21:00 | AAPL | Stock | 7.1111 | 7.1111 | 7.1111 | 7.1111 | 2800.0 |
| 2009-11-27 07:22:00 | AAPL | Stock | 7.1075 | 7.1075 | 7.0839 | 7.0882 | 134428.0 |
| 2009-11-27 07:26:00 | AAPL | Stock | 7.0964 | 7.0964 | 7.0846 | 7.0846 | 76300.0 |
| 2009-11-27 07:27:00 | AAPL | Stock | 7.0911 | 7.0911 | 7.0846 | 7.0846 | 26628.0 |
| 2009-11-27 07:28:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0889 | 7.0889 | 5600.0 |
| 2009-11-27 07:29:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0893 | 7.0893 | 19600.0 |
| 2009-11-27 07:30:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0893 | 7.0893 | 8400.0 |
| 2009-11-27 07:31:00 | AAPL | Stock | 7.0982 | 7.0982 | 7.0982 | 7.0982 | 14000.0 |
| 2009-11-27 07:33:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0893 | 7.0893 | 14000.0 |
| 2009-11-27 07:34:00 | AAPL | Stock | 7.0896 | 7.0896 | 7.0893 | 7.0893 | 5600.0 |
| 2009-11-27 07:35:00 | AAPL | Stock | 7.0896 | 7.0896 | 7.0896 | 7.0896 | 2800.0 |
| 2009-11-27 07:37:00 | AAPL | Stock | 7.09 | 7.09 | 7.0804 | 7.0804 | 119392.0 |
| 2009-11-27 07:38:00 | AAPL | Stock | 7.0789 | 7.0804 | 7.0757 | 7.0757 | 65800.0 |
| 2009-11-27 07:39:00 | AAPL | Stock | 7.08 | 7.0807 | 7.08 | 7.0807 | 72800.0 |
| 2009-11-27 07:43:00 | AAPL | Stock | 7.0893 | 7.0982 | 7.0893 | 7.0982 | 30464.0 |
| 2009-11-27 07:44:00 | AAPL | Stock | 7.1036 | 7.1071 | 7.1036 | 7.1071 | 14616.0 |
| 2009-11-27 07:45:00 | AAPL | Stock | 7.1064 | 7.1071 | 7.1014 | 7.1071 | 22764.0 |
| 2009-11-27 07:46:00 | AAPL | Stock | 7.1036 | 7.1036 | 7.1036 | 7.1036 | 5600.0 |
| 2009-11-27 07:49:00 | AAPL | Stock | 7.1061 | 7.1071 | 7.1061 | 7.1071 | 32004.0 |
| 2009-11-27 07:50:00 | AAPL | Stock | 7.1071 | 7.1118 | 7.1068 | 7.1118 | 47600.0 |
> showing 50 of 513,360 rows — these rows as CSV