PREVIEW / stock_1min / 2012-11-16
file: by_date/stock_1min/2012/2012-11-16.parquet size: 13.7 MB rows: 1,019,435 symbols: 2,810
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-11-16 04:05:00 | AAPL | Stock | 18.7179 | 18.7179 | 18.7179 | 18.7179 | 2800.0 |
| 2012-11-16 04:06:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 3780.0 |
| 2012-11-16 04:29:00 | AAPL | Stock | 18.7054 | 18.7054 | 18.7054 | 18.7054 | 2800.0 |
| 2012-11-16 04:30:00 | AAPL | Stock | 18.7054 | 18.7054 | 18.7054 | 18.7054 | 2800.0 |
| 2012-11-16 04:33:00 | AAPL | Stock | 18.7 | 18.7 | 18.7 | 18.7 | 2800.0 |
| 2012-11-16 04:39:00 | AAPL | Stock | 18.6964 | 18.6964 | 18.6964 | 18.6964 | 2800.0 |
| 2012-11-16 04:49:00 | AAPL | Stock | 18.6789 | 18.6789 | 18.6789 | 18.6789 | 2800.0 |
| 2012-11-16 04:53:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6786 | 18.6786 | 5600.0 |
| 2012-11-16 05:14:00 | AAPL | Stock | 18.6614 | 18.6614 | 18.6611 | 18.6611 | 5600.0 |
| 2012-11-16 05:15:00 | AAPL | Stock | 18.65 | 18.65 | 18.6464 | 18.6464 | 5600.0 |
| 2012-11-16 05:16:00 | AAPL | Stock | 18.6464 | 18.6464 | 18.6432 | 18.6432 | 9800.0 |
| 2012-11-16 05:29:00 | AAPL | Stock | 18.6329 | 18.6329 | 18.6329 | 18.6329 | 2800.0 |
| 2012-11-16 05:30:00 | AAPL | Stock | 18.6343 | 18.6343 | 18.6343 | 18.6343 | 2800.0 |
| 2012-11-16 05:31:00 | AAPL | Stock | 18.6336 | 18.6336 | 18.6336 | 18.6336 | 8400.0 |
| 2012-11-16 05:34:00 | AAPL | Stock | 18.6304 | 18.6429 | 18.6304 | 18.6429 | 12264.0 |
| 2012-11-16 05:35:00 | AAPL | Stock | 18.6307 | 18.6307 | 18.6304 | 18.6304 | 5600.0 |
| 2012-11-16 05:37:00 | AAPL | Stock | 18.6421 | 18.6421 | 18.6421 | 18.6421 | 4620.0 |
| 2012-11-16 05:45:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6304 | 18.6304 | 16156.0 |
| 2012-11-16 05:52:00 | AAPL | Stock | 18.6393 | 18.6393 | 18.6393 | 18.6393 | 2800.0 |
| 2012-11-16 05:57:00 | AAPL | Stock | 18.6411 | 18.6429 | 18.6411 | 18.6429 | 13972.0 |
| 2012-11-16 05:58:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 2800.0 |
| 2012-11-16 06:11:00 | AAPL | Stock | 18.6243 | 18.6243 | 18.6243 | 18.6243 | 2800.0 |
| 2012-11-16 06:12:00 | AAPL | Stock | 18.6393 | 18.6396 | 18.6393 | 18.6396 | 7000.0 |
| 2012-11-16 06:15:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 5600.0 |
| 2012-11-16 06:23:00 | AAPL | Stock | 18.6696 | 18.6696 | 18.6696 | 18.6696 | 2800.0 |
| 2012-11-16 06:34:00 | AAPL | Stock | 18.655 | 18.655 | 18.655 | 18.655 | 5600.0 |
| 2012-11-16 06:41:00 | AAPL | Stock | 18.6593 | 18.6607 | 18.6593 | 18.6607 | 22400.0 |
| 2012-11-16 06:43:00 | AAPL | Stock | 18.6607 | 18.6714 | 18.6607 | 18.6607 | 12600.0 |
| 2012-11-16 06:44:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 5600.0 |
| 2012-11-16 06:45:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 2800.0 |
| 2012-11-16 06:47:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 2800.0 |
| 2012-11-16 06:48:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 14000.0 |
| 2012-11-16 06:52:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 8400.0 |
| 2012-11-16 06:54:00 | AAPL | Stock | 18.6714 | 18.6714 | 18.6714 | 18.6714 | 2800.0 |
| 2012-11-16 06:55:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6786 | 18.6786 | 19432.0 |
| 2012-11-16 06:56:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6786 | 18.6786 | 13832.0 |
| 2012-11-16 06:57:00 | AAPL | Stock | 18.6732 | 18.6732 | 18.6732 | 18.6732 | 2800.0 |
| 2012-11-16 06:58:00 | AAPL | Stock | 18.675 | 18.6786 | 18.675 | 18.6786 | 8568.0 |
| 2012-11-16 06:59:00 | AAPL | Stock | 18.695 | 18.695 | 18.695 | 18.695 | 2800.0 |
| 2012-11-16 07:00:00 | AAPL | Stock | 18.7068 | 18.7107 | 18.7068 | 18.7107 | 12432.0 |
| 2012-11-16 07:01:00 | AAPL | Stock | 18.7143 | 18.7232 | 18.7143 | 18.7232 | 5600.0 |
| 2012-11-16 07:03:00 | AAPL | Stock | 18.7318 | 18.7329 | 18.7318 | 18.7321 | 22204.0 |
| 2012-11-16 07:04:00 | AAPL | Stock | 18.7321 | 18.7418 | 18.7321 | 18.7418 | 5600.0 |
| 2012-11-16 07:05:00 | AAPL | Stock | 18.7446 | 18.7504 | 18.7446 | 18.7504 | 28000.0 |
| 2012-11-16 07:06:00 | AAPL | Stock | 18.7507 | 18.76 | 18.75 | 18.76 | 14000.0 |
| 2012-11-16 07:07:00 | AAPL | Stock | 18.7336 | 18.7336 | 18.7336 | 18.7336 | 2800.0 |
| 2012-11-16 07:08:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 11200.0 |
| 2012-11-16 07:10:00 | AAPL | Stock | 18.7486 | 18.7486 | 18.7486 | 18.7486 | 2800.0 |
| 2012-11-16 07:11:00 | AAPL | Stock | 18.7493 | 18.7711 | 18.7493 | 18.7661 | 29988.0 |
| 2012-11-16 07:12:00 | AAPL | Stock | 18.7518 | 18.7518 | 18.75 | 18.75 | 5600.0 |
> showing 50 of 1,019,435 rows — these rows as CSV