PREVIEW / stock_1min / 2012-05-21
file: by_date/stock_1min/2012/2012-05-21.parquet size: 13.3 MB rows: 988,383 symbols: 2,849
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-21 04:00:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.0 | 19.0261 | 11200.0 |
| 2012-05-21 04:01:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2012-05-21 04:10:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 4760.0 |
| 2012-05-21 05:07:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-05-21 05:20:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 8400.0 |
| 2012-05-21 05:26:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-05-21 05:55:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-05-21 06:13:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 6216.0 |
| 2012-05-21 06:21:00 | AAPL | Stock | 19.0857 | 19.0857 | 19.0857 | 19.0857 | 11200.0 |
| 2012-05-21 06:31:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 2800.0 |
| 2012-05-21 06:56:00 | AAPL | Stock | 19.0964 | 19.1064 | 19.0964 | 19.1064 | 5600.0 |
| 2012-05-21 06:58:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 5600.0 |
| 2012-05-21 07:00:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 11200.0 |
| 2012-05-21 07:01:00 | AAPL | Stock | 19.1321 | 19.1357 | 19.1071 | 19.1075 | 19460.0 |
| 2012-05-21 07:02:00 | AAPL | Stock | 19.1311 | 19.1311 | 19.1075 | 19.1111 | 14000.0 |
| 2012-05-21 07:03:00 | AAPL | Stock | 19.125 | 19.125 | 19.125 | 19.125 | 11200.0 |
| 2012-05-21 07:04:00 | AAPL | Stock | 19.1082 | 19.1107 | 19.1071 | 19.1071 | 16800.0 |
| 2012-05-21 07:06:00 | AAPL | Stock | 19.1107 | 19.1107 | 19.1107 | 19.1107 | 11900.0 |
| 2012-05-21 07:07:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2012-05-21 07:08:00 | AAPL | Stock | 19.0721 | 19.0893 | 19.0721 | 19.0893 | 17136.0 |
| 2012-05-21 07:14:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 11200.0 |
| 2012-05-21 07:15:00 | AAPL | Stock | 19.1029 | 19.1029 | 19.1029 | 19.1029 | 2800.0 |
| 2012-05-21 07:18:00 | AAPL | Stock | 19.1 | 19.1 | 19.1 | 19.1 | 2800.0 |
| 2012-05-21 07:19:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0889 | 19.0893 | 14000.0 |
| 2012-05-21 07:21:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0893 | 19.0893 | 5600.0 |
| 2012-05-21 07:27:00 | AAPL | Stock | 19.0821 | 19.0821 | 19.0821 | 19.0821 | 2800.0 |
| 2012-05-21 07:28:00 | AAPL | Stock | 19.0911 | 19.0911 | 19.0911 | 19.0911 | 2800.0 |
| 2012-05-21 07:29:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0804 | 19.0804 | 2800.0 |
| 2012-05-21 07:31:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0804 | 19.0804 | 2800.0 |
| 2012-05-21 07:34:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0893 | 19.0893 | 2800.0 |
| 2012-05-21 07:38:00 | AAPL | Stock | 19.0843 | 19.0843 | 19.0843 | 19.0843 | 2800.0 |
| 2012-05-21 07:39:00 | AAPL | Stock | 19.0843 | 19.0843 | 19.0843 | 19.0843 | 2800.0 |
| 2012-05-21 07:40:00 | AAPL | Stock | 19.0975 | 19.1104 | 19.0975 | 19.1104 | 56924.0 |
| 2012-05-21 07:41:00 | AAPL | Stock | 19.1136 | 19.1136 | 19.0996 | 19.0996 | 8400.0 |
| 2012-05-21 07:45:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 28000.0 |
| 2012-05-21 07:46:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2012-05-21 07:47:00 | AAPL | Stock | 19.1107 | 19.1107 | 19.1107 | 19.1107 | 2800.0 |
| 2012-05-21 07:50:00 | AAPL | Stock | 19.0989 | 19.0989 | 19.0989 | 19.0989 | 5320.0 |
| 2012-05-21 07:51:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.0964 | 19.0964 | 2800.0 |
| 2012-05-21 07:52:00 | AAPL | Stock | 19.0893 | 19.0896 | 19.0793 | 19.0793 | 8400.0 |
| 2012-05-21 07:55:00 | AAPL | Stock | 19.0825 | 19.0893 | 19.0775 | 19.0775 | 11200.0 |
| 2012-05-21 07:56:00 | AAPL | Stock | 19.0739 | 19.0739 | 19.0739 | 19.0739 | 2800.0 |
| 2012-05-21 07:57:00 | AAPL | Stock | 19.0732 | 19.0732 | 19.0732 | 19.0732 | 22400.0 |
| 2012-05-21 07:58:00 | AAPL | Stock | 19.0732 | 19.0793 | 19.0732 | 19.0793 | 11200.0 |
| 2012-05-21 07:59:00 | AAPL | Stock | 19.0846 | 19.0846 | 19.0846 | 19.0846 | 2800.0 |
| 2012-05-21 08:00:00 | AAPL | Stock | 19.0768 | 19.105 | 19.0732 | 19.0857 | 152880.0 |
| 2012-05-21 08:01:00 | AAPL | Stock | 19.0814 | 19.0886 | 19.0718 | 19.0768 | 28560.0 |
| 2012-05-21 08:02:00 | AAPL | Stock | 19.075 | 19.075 | 19.0643 | 19.0643 | 83300.0 |
| 2012-05-21 08:03:00 | AAPL | Stock | 19.0611 | 19.0714 | 19.0611 | 19.07 | 38640.0 |
| 2012-05-21 08:04:00 | AAPL | Stock | 19.07 | 19.07 | 19.055 | 19.0643 | 52360.0 |
> showing 50 of 988,383 rows — these rows as CSV