PREVIEW / stock_1min / 2011-09-22
file: by_date/stock_1min/2011/2011-09-22.parquet size: 15.1 MB rows: 1,104,508 symbols: 2,862
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-22 04:04:00 | AAPL | Stock | 14.525 | 14.525 | 14.525 | 14.525 | 2800.0 |
| 2011-09-22 04:05:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-22 04:06:00 | AAPL | Stock | 14.4929 | 14.4929 | 14.4929 | 14.4929 | 8400.0 |
| 2011-09-22 04:07:00 | AAPL | Stock | 14.4929 | 14.4929 | 14.4929 | 14.4929 | 2800.0 |
| 2011-09-22 04:08:00 | AAPL | Stock | 14.4929 | 14.4929 | 14.4643 | 14.4643 | 30296.0 |
| 2011-09-22 04:24:00 | AAPL | Stock | 14.5304 | 14.5304 | 14.5275 | 14.5275 | 5600.0 |
| 2011-09-22 04:27:00 | AAPL | Stock | 14.5329 | 14.5386 | 14.5329 | 14.5386 | 5600.0 |
| 2011-09-22 04:29:00 | AAPL | Stock | 14.5296 | 14.5296 | 14.5296 | 14.5296 | 2800.0 |
| 2011-09-22 04:30:00 | AAPL | Stock | 14.5196 | 14.5196 | 14.5196 | 14.5196 | 2800.0 |
| 2011-09-22 04:44:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-22 04:47:00 | AAPL | Stock | 14.4954 | 14.4954 | 14.4946 | 14.4946 | 5600.0 |
| 2011-09-22 04:50:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 4900.0 |
| 2011-09-22 04:52:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-09-22 04:55:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-09-22 04:58:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-22 04:59:00 | AAPL | Stock | 14.4896 | 14.4896 | 14.4896 | 14.4896 | 2800.0 |
| 2011-09-22 05:00:00 | AAPL | Stock | 14.4893 | 14.4893 | 14.4821 | 14.4821 | 14000.0 |
| 2011-09-22 05:12:00 | AAPL | Stock | 14.4857 | 14.4857 | 14.4821 | 14.4821 | 5600.0 |
| 2011-09-22 05:13:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 5600.0 |
| 2011-09-22 05:14:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 2800.0 |
| 2011-09-22 05:15:00 | AAPL | Stock | 14.4836 | 14.4836 | 14.4821 | 14.4821 | 5600.0 |
| 2011-09-22 05:18:00 | AAPL | Stock | 14.4693 | 14.4693 | 14.4693 | 14.4693 | 2800.0 |
| 2011-09-22 05:19:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4643 | 14.4643 | 8400.0 |
| 2011-09-22 05:21:00 | AAPL | Stock | 14.4725 | 14.4764 | 14.4725 | 14.4764 | 11200.0 |
| 2011-09-22 05:22:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 2800.0 |
| 2011-09-22 05:23:00 | AAPL | Stock | 14.4646 | 14.4646 | 14.4643 | 14.4643 | 28000.0 |
| 2011-09-22 05:24:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4679 | 14.4679 | 11200.0 |
| 2011-09-22 05:26:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 2800.0 |
| 2011-09-22 05:32:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4679 | 14.4679 | 2800.0 |
| 2011-09-22 05:33:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 2800.0 |
| 2011-09-22 05:40:00 | AAPL | Stock | 14.4846 | 14.4846 | 14.4846 | 14.4846 | 2800.0 |
| 2011-09-22 05:41:00 | AAPL | Stock | 14.4868 | 14.4868 | 14.4868 | 14.4868 | 2800.0 |
| 2011-09-22 05:48:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 2800.0 |
| 2011-09-22 05:49:00 | AAPL | Stock | 14.4893 | 14.4893 | 14.4893 | 14.4893 | 2800.0 |
| 2011-09-22 05:50:00 | AAPL | Stock | 14.4821 | 14.4893 | 14.4821 | 14.4893 | 14000.0 |
| 2011-09-22 05:51:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 5600.0 |
| 2011-09-22 05:59:00 | AAPL | Stock | 14.4757 | 14.4757 | 14.4757 | 14.4757 | 2800.0 |
| 2011-09-22 06:03:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 5600.0 |
| 2011-09-22 06:05:00 | AAPL | Stock | 14.4682 | 14.4682 | 14.4682 | 14.4682 | 2800.0 |
| 2011-09-22 06:10:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4679 | 14.4679 | 2800.0 |
| 2011-09-22 06:12:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 5600.0 |
| 2011-09-22 06:24:00 | AAPL | Stock | 14.4882 | 14.4882 | 14.4882 | 14.4882 | 2800.0 |
| 2011-09-22 06:27:00 | AAPL | Stock | 14.4732 | 14.5107 | 14.4732 | 14.5107 | 8400.0 |
| 2011-09-22 06:34:00 | AAPL | Stock | 14.4929 | 14.4929 | 14.4929 | 14.4929 | 2800.0 |
| 2011-09-22 06:35:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 8400.0 |
| 2011-09-22 06:36:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 2800.0 |
| 2011-09-22 06:37:00 | AAPL | Stock | 14.4893 | 14.4893 | 14.4893 | 14.4893 | 2800.0 |
| 2011-09-22 06:39:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 28000.0 |
| 2011-09-22 06:41:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 5600.0 |
| 2011-09-22 06:42:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 2800.0 |
> showing 50 of 1,104,508 rows — these rows as CSV