PREVIEW / stock_1min / 2012-03-21
file: by_date/stock_1min/2012/2012-03-21.parquet size: 12.6 MB rows: 944,476 symbols: 2,839
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-03-21 04:04:00 | AAPL | Stock | 21.6679 | 21.6779 | 21.6679 | 21.6779 | 16800.0 |
| 2012-03-21 04:05:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 2800.0 |
| 2012-03-21 04:07:00 | AAPL | Stock | 21.6875 | 21.6929 | 21.6875 | 21.6929 | 25200.0 |
| 2012-03-21 04:08:00 | AAPL | Stock | 21.6907 | 21.6907 | 21.6893 | 21.6893 | 5600.0 |
| 2012-03-21 04:09:00 | AAPL | Stock | 21.6896 | 21.6896 | 21.6896 | 21.6896 | 5600.0 |
| 2012-03-21 04:10:00 | AAPL | Stock | 21.6893 | 21.6893 | 21.6893 | 21.6893 | 4200.0 |
| 2012-03-21 04:12:00 | AAPL | Stock | 21.6932 | 21.6932 | 21.6929 | 21.6929 | 8400.0 |
| 2012-03-21 04:13:00 | AAPL | Stock | 21.6889 | 21.6893 | 21.6889 | 21.6893 | 5600.0 |
| 2012-03-21 04:14:00 | AAPL | Stock | 21.6893 | 21.6893 | 21.6875 | 21.6875 | 8400.0 |
| 2012-03-21 04:15:00 | AAPL | Stock | 21.6821 | 21.6821 | 21.6793 | 21.6793 | 5600.0 |
| 2012-03-21 04:16:00 | AAPL | Stock | 21.6768 | 21.6768 | 21.6768 | 21.6768 | 2800.0 |
| 2012-03-21 04:18:00 | AAPL | Stock | 21.6854 | 21.6854 | 21.6829 | 21.6829 | 5600.0 |
| 2012-03-21 04:24:00 | AAPL | Stock | 21.6721 | 21.6721 | 21.6721 | 21.6721 | 4200.0 |
| 2012-03-21 04:34:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 5600.0 |
| 2012-03-21 04:41:00 | AAPL | Stock | 21.6629 | 21.6629 | 21.6607 | 21.6607 | 5600.0 |
| 2012-03-21 04:46:00 | AAPL | Stock | 21.65 | 21.65 | 21.65 | 21.65 | 2800.0 |
| 2012-03-21 04:56:00 | AAPL | Stock | 21.6571 | 21.6571 | 21.6571 | 21.6571 | 5600.0 |
| 2012-03-21 05:01:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 2940.0 |
| 2012-03-21 05:09:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 2800.0 |
| 2012-03-21 05:10:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 2800.0 |
| 2012-03-21 05:11:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6461 | 21.6461 | 8400.0 |
| 2012-03-21 05:18:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6518 | 21.6518 | 2800.0 |
| 2012-03-21 05:20:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6518 | 21.6518 | 2800.0 |
| 2012-03-21 05:21:00 | AAPL | Stock | 21.65 | 21.65 | 21.65 | 21.65 | 2800.0 |
| 2012-03-21 05:22:00 | AAPL | Stock | 21.6407 | 21.6407 | 21.6407 | 21.6407 | 2800.0 |
| 2012-03-21 05:26:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 05:27:00 | AAPL | Stock | 21.6146 | 21.6146 | 21.6146 | 21.6146 | 2800.0 |
| 2012-03-21 05:42:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 05:45:00 | AAPL | Stock | 21.5964 | 21.5964 | 21.5964 | 21.5964 | 2800.0 |
| 2012-03-21 05:46:00 | AAPL | Stock | 21.5964 | 21.5964 | 21.5964 | 21.5964 | 2800.0 |
| 2012-03-21 05:52:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 06:03:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6107 | 21.6107 | 8372.0 |
| 2012-03-21 06:20:00 | AAPL | Stock | 21.6075 | 21.6075 | 21.6075 | 21.6075 | 2800.0 |
| 2012-03-21 06:31:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 06:47:00 | AAPL | Stock | 21.6018 | 21.6018 | 21.6018 | 21.6018 | 2800.0 |
| 2012-03-21 07:01:00 | AAPL | Stock | 21.5982 | 21.5982 | 21.5982 | 21.5982 | 2800.0 |
| 2012-03-21 07:02:00 | AAPL | Stock | 21.6057 | 21.6057 | 21.6057 | 21.6057 | 2800.0 |
| 2012-03-21 07:03:00 | AAPL | Stock | 21.6071 | 21.6171 | 21.6071 | 21.6071 | 8400.0 |
| 2012-03-21 07:07:00 | AAPL | Stock | 21.6154 | 21.6154 | 21.6154 | 21.6154 | 2800.0 |
| 2012-03-21 07:08:00 | AAPL | Stock | 21.625 | 21.625 | 21.625 | 21.625 | 2800.0 |
| 2012-03-21 07:10:00 | AAPL | Stock | 21.6246 | 21.6339 | 21.6246 | 21.6339 | 15400.0 |
| 2012-03-21 07:12:00 | AAPL | Stock | 21.625 | 21.625 | 21.6071 | 21.6071 | 21336.0 |
| 2012-03-21 07:13:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6107 | 21.6107 | 2800.0 |
| 2012-03-21 07:15:00 | AAPL | Stock | 21.5957 | 21.6107 | 21.5861 | 21.5929 | 37520.0 |
| 2012-03-21 07:16:00 | AAPL | Stock | 21.5882 | 21.5882 | 21.5857 | 21.5857 | 11200.0 |
| 2012-03-21 07:17:00 | AAPL | Stock | 21.5804 | 21.5804 | 21.5754 | 21.5754 | 28980.0 |
| 2012-03-21 07:18:00 | AAPL | Stock | 21.5732 | 21.5732 | 21.5714 | 21.5714 | 10780.0 |
| 2012-03-21 07:22:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5611 | 21.5611 | 6160.0 |
| 2012-03-21 07:23:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5661 | 21.5714 | 19600.0 |
| 2012-03-21 07:25:00 | AAPL | Stock | 21.5889 | 21.5889 | 21.5889 | 21.5889 | 11760.0 |
> showing 50 of 944,476 rows — these rows as CSV