PREVIEW / stock_1min / 2013-05-29
file: by_date/stock_1min/2013/2013-05-29.parquet size: 13.7 MB rows: 998,617 symbols: 2,844
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-05-29 05:18:00 | AAPL | Stock | 15.7239 | 15.7239 | 15.7239 | 15.7239 | 2800.0 |
| 2013-05-29 06:21:00 | AAPL | Stock | 15.7239 | 15.7239 | 15.7229 | 15.7229 | 16800.0 |
| 2013-05-29 06:43:00 | AAPL | Stock | 15.7118 | 15.7118 | 15.7118 | 15.7118 | 2800.0 |
| 2013-05-29 07:00:00 | AAPL | Stock | 15.6793 | 15.6793 | 15.6671 | 15.6671 | 14000.0 |
| 2013-05-29 07:02:00 | AAPL | Stock | 15.6671 | 15.6786 | 15.6671 | 15.6786 | 45108.0 |
| 2013-05-29 07:03:00 | AAPL | Stock | 15.6886 | 15.6896 | 15.6886 | 15.6896 | 53200.0 |
| 2013-05-29 07:04:00 | AAPL | Stock | 15.6804 | 15.6804 | 15.6696 | 15.6696 | 35280.0 |
| 2013-05-29 07:05:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 27860.0 |
| 2013-05-29 07:09:00 | AAPL | Stock | 15.6579 | 15.6579 | 15.6554 | 15.6554 | 11200.0 |
| 2013-05-29 07:10:00 | AAPL | Stock | 15.6557 | 15.6607 | 15.6557 | 15.6607 | 8400.0 |
| 2013-05-29 07:11:00 | AAPL | Stock | 15.6554 | 15.6554 | 15.6554 | 15.6554 | 3724.0 |
| 2013-05-29 07:12:00 | AAPL | Stock | 15.6504 | 15.6557 | 15.6504 | 15.6557 | 11200.0 |
| 2013-05-29 07:19:00 | AAPL | Stock | 15.6661 | 15.6732 | 15.6661 | 15.6732 | 10080.0 |
| 2013-05-29 07:21:00 | AAPL | Stock | 15.6725 | 15.6786 | 15.6725 | 15.6786 | 33824.0 |
| 2013-05-29 07:22:00 | AAPL | Stock | 15.6711 | 15.6711 | 15.6704 | 15.6704 | 11200.0 |
| 2013-05-29 07:23:00 | AAPL | Stock | 15.67 | 15.6704 | 15.67 | 15.6704 | 5600.0 |
| 2013-05-29 07:24:00 | AAPL | Stock | 15.6696 | 15.67 | 15.6696 | 15.67 | 28000.0 |
| 2013-05-29 07:26:00 | AAPL | Stock | 15.6643 | 15.6643 | 15.6643 | 15.6643 | 5600.0 |
| 2013-05-29 07:28:00 | AAPL | Stock | 15.6814 | 15.6814 | 15.6668 | 15.6668 | 11200.0 |
| 2013-05-29 07:31:00 | AAPL | Stock | 15.6625 | 15.6625 | 15.6625 | 15.6625 | 22764.0 |
| 2013-05-29 07:32:00 | AAPL | Stock | 15.6607 | 15.6607 | 15.6518 | 15.6518 | 58548.0 |
| 2013-05-29 07:33:00 | AAPL | Stock | 15.6596 | 15.6675 | 15.6596 | 15.6675 | 8400.0 |
| 2013-05-29 07:34:00 | AAPL | Stock | 15.6661 | 15.6661 | 15.6661 | 15.6661 | 11200.0 |
| 2013-05-29 07:35:00 | AAPL | Stock | 15.6675 | 15.6675 | 15.6675 | 15.6675 | 2800.0 |
| 2013-05-29 07:39:00 | AAPL | Stock | 15.6696 | 15.6696 | 15.6696 | 15.6696 | 2800.0 |
| 2013-05-29 07:40:00 | AAPL | Stock | 15.6679 | 15.6786 | 15.6679 | 15.6786 | 16800.0 |
| 2013-05-29 07:42:00 | AAPL | Stock | 15.6711 | 15.6786 | 15.6711 | 15.6786 | 25200.0 |
| 2013-05-29 07:45:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6696 | 15.6696 | 16800.0 |
| 2013-05-29 07:46:00 | AAPL | Stock | 15.6675 | 15.6675 | 15.66 | 15.66 | 10472.0 |
| 2013-05-29 07:47:00 | AAPL | Stock | 15.6564 | 15.6571 | 15.6536 | 15.6571 | 14000.0 |
| 2013-05-29 07:49:00 | AAPL | Stock | 15.6571 | 15.6571 | 15.6571 | 15.6571 | 24528.0 |
| 2013-05-29 07:50:00 | AAPL | Stock | 15.6571 | 15.6571 | 15.6571 | 15.6571 | 8260.0 |
| 2013-05-29 07:52:00 | AAPL | Stock | 15.6539 | 15.6539 | 15.6539 | 15.6539 | 2800.0 |
| 2013-05-29 07:53:00 | AAPL | Stock | 15.6518 | 15.6518 | 15.6518 | 15.6518 | 2800.0 |
| 2013-05-29 07:54:00 | AAPL | Stock | 15.6464 | 15.6464 | 15.6382 | 15.6382 | 56364.0 |
| 2013-05-29 07:55:00 | AAPL | Stock | 15.6357 | 15.6357 | 15.6286 | 15.6286 | 16800.0 |
| 2013-05-29 07:56:00 | AAPL | Stock | 15.6286 | 15.6286 | 15.6243 | 15.6243 | 22400.0 |
| 2013-05-29 07:58:00 | AAPL | Stock | 15.6246 | 15.6261 | 15.6246 | 15.6261 | 14000.0 |
| 2013-05-29 08:00:00 | AAPL | Stock | 15.6379 | 15.6875 | 15.6379 | 15.6429 | 64988.0 |
| 2013-05-29 08:01:00 | AAPL | Stock | 15.6307 | 15.6314 | 15.6307 | 15.6314 | 8400.0 |
| 2013-05-29 08:02:00 | AAPL | Stock | 15.6343 | 15.6389 | 15.6261 | 15.6336 | 62440.0 |
| 2013-05-29 08:03:00 | AAPL | Stock | 15.6339 | 15.6407 | 15.6211 | 15.625 | 122192.0 |
| 2013-05-29 08:04:00 | AAPL | Stock | 15.625 | 15.7321 | 15.625 | 15.7321 | 58800.0 |
| 2013-05-29 08:05:00 | AAPL | Stock | 15.6311 | 15.6311 | 15.6211 | 15.6225 | 28000.0 |
| 2013-05-29 08:06:00 | AAPL | Stock | 15.6168 | 15.6214 | 15.5964 | 15.6054 | 227388.0 |
| 2013-05-29 08:07:00 | AAPL | Stock | 15.5971 | 15.6054 | 15.5964 | 15.6054 | 49280.0 |
| 2013-05-29 08:08:00 | AAPL | Stock | 15.6225 | 15.6225 | 15.6157 | 15.6214 | 16800.0 |
| 2013-05-29 08:09:00 | AAPL | Stock | 15.6225 | 15.6282 | 15.6125 | 15.6129 | 62860.0 |
| 2013-05-29 08:10:00 | AAPL | Stock | 15.6111 | 15.6121 | 15.6107 | 15.6107 | 27720.0 |
| 2013-05-29 08:11:00 | AAPL | Stock | 15.6161 | 15.6161 | 15.6161 | 15.6161 | 2800.0 |
> showing 50 of 998,617 rows — these rows as CSV