PREVIEW / stock_1min / 2013-10-22
file: by_date/stock_1min/2013/2013-10-22.parquet size: 14.3 MB rows: 1,037,750 symbols: 2,884
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-22 04:00:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 14000.0 |
| 2013-10-22 04:01:00 | AAPL | Stock | 18.7196 | 18.75 | 18.7196 | 18.75 | 14000.0 |
| 2013-10-22 04:02:00 | AAPL | Stock | 18.7196 | 18.7196 | 18.7143 | 18.7143 | 5600.0 |
| 2013-10-22 04:03:00 | AAPL | Stock | 18.72 | 18.72 | 18.72 | 18.72 | 2800.0 |
| 2013-10-22 04:05:00 | AAPL | Stock | 18.7296 | 18.7296 | 18.7296 | 18.7296 | 8400.0 |
| 2013-10-22 04:14:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 11200.0 |
| 2013-10-22 04:57:00 | AAPL | Stock | 18.72 | 18.72 | 18.72 | 18.72 | 2800.0 |
| 2013-10-22 05:03:00 | AAPL | Stock | 18.72 | 18.72 | 18.72 | 18.72 | 2800.0 |
| 2013-10-22 05:29:00 | AAPL | Stock | 18.7232 | 18.7232 | 18.7207 | 18.7207 | 28000.0 |
| 2013-10-22 05:37:00 | AAPL | Stock | 18.7286 | 18.7286 | 18.7286 | 18.7286 | 2800.0 |
| 2013-10-22 05:38:00 | AAPL | Stock | 18.7296 | 18.7296 | 18.7296 | 18.7296 | 5460.0 |
| 2013-10-22 05:39:00 | AAPL | Stock | 18.7225 | 18.7225 | 18.7225 | 18.7225 | 7336.0 |
| 2013-10-22 05:40:00 | AAPL | Stock | 18.7225 | 18.7225 | 18.7225 | 18.7225 | 2800.0 |
| 2013-10-22 05:41:00 | AAPL | Stock | 18.7225 | 18.7225 | 18.7225 | 18.7225 | 11200.0 |
| 2013-10-22 05:42:00 | AAPL | Stock | 18.7225 | 18.7225 | 18.7225 | 18.7225 | 2800.0 |
| 2013-10-22 05:55:00 | AAPL | Stock | 18.7307 | 18.7321 | 18.7307 | 18.7321 | 5600.0 |
| 2013-10-22 05:57:00 | AAPL | Stock | 18.7404 | 18.7404 | 18.7404 | 18.7404 | 7700.0 |
| 2013-10-22 06:03:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 8400.0 |
| 2013-10-22 06:06:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 3892.0 |
| 2013-10-22 06:11:00 | AAPL | Stock | 18.7464 | 18.7464 | 18.7464 | 18.7464 | 2800.0 |
| 2013-10-22 06:12:00 | AAPL | Stock | 18.7275 | 18.7304 | 18.7268 | 18.7304 | 30576.0 |
| 2013-10-22 06:13:00 | AAPL | Stock | 18.7243 | 18.7243 | 18.7143 | 18.7143 | 26656.0 |
| 2013-10-22 06:14:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 14000.0 |
| 2013-10-22 06:16:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2013-10-22 06:17:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 119308.0 |
| 2013-10-22 06:26:00 | AAPL | Stock | 18.7139 | 18.7143 | 18.7139 | 18.7143 | 14000.0 |
| 2013-10-22 06:27:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 20440.0 |
| 2013-10-22 06:28:00 | AAPL | Stock | 18.7061 | 18.7061 | 18.7061 | 18.7061 | 2800.0 |
| 2013-10-22 06:33:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2013-10-22 06:34:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 28000.0 |
| 2013-10-22 06:36:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 5600.0 |
| 2013-10-22 06:37:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 4200.0 |
| 2013-10-22 06:41:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 17892.0 |
| 2013-10-22 06:44:00 | AAPL | Stock | 18.7296 | 18.73 | 18.7154 | 18.7154 | 14000.0 |
| 2013-10-22 06:45:00 | AAPL | Stock | 18.7311 | 18.7311 | 18.7311 | 18.7311 | 2800.0 |
| 2013-10-22 06:47:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 5600.0 |
| 2013-10-22 06:48:00 | AAPL | Stock | 18.7325 | 18.7325 | 18.7325 | 18.7325 | 5516.0 |
| 2013-10-22 06:49:00 | AAPL | Stock | 18.7457 | 18.7564 | 18.7457 | 18.7564 | 14000.0 |
| 2013-10-22 06:53:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7643 | 18.7643 | 2800.0 |
| 2013-10-22 06:54:00 | AAPL | Stock | 18.7336 | 18.7643 | 18.7336 | 18.7643 | 28000.0 |
| 2013-10-22 07:02:00 | AAPL | Stock | 18.7843 | 18.785 | 18.7843 | 18.785 | 8400.0 |
| 2013-10-22 07:03:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7754 | 18.7754 | 8400.0 |
| 2013-10-22 07:04:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7607 | 18.7675 | 39956.0 |
| 2013-10-22 07:05:00 | AAPL | Stock | 18.7661 | 18.7661 | 18.7661 | 18.7661 | 5600.0 |
| 2013-10-22 07:06:00 | AAPL | Stock | 18.7893 | 18.7893 | 18.7857 | 18.7857 | 31920.0 |
| 2013-10-22 07:07:00 | AAPL | Stock | 18.7786 | 18.7893 | 18.7786 | 18.7893 | 36400.0 |
| 2013-10-22 07:08:00 | AAPL | Stock | 18.7839 | 18.8018 | 18.7839 | 18.7904 | 84840.0 |
| 2013-10-22 07:09:00 | AAPL | Stock | 18.7943 | 18.7943 | 18.7943 | 18.7943 | 5600.0 |
| 2013-10-22 07:10:00 | AAPL | Stock | 18.7943 | 18.7982 | 18.7943 | 18.7982 | 11200.0 |
| 2013-10-22 07:11:00 | AAPL | Stock | 18.7971 | 18.8071 | 18.7971 | 18.8032 | 22400.0 |
> showing 50 of 1,037,750 rows — these rows as CSV