PREVIEW / stock_1min / 2012-05-16
file: by_date/stock_1min/2012/2012-05-16.parquet size: 13.4 MB rows: 993,951 symbols: 2,850
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-05-16 04:02:00 | AAPL | Stock | 19.7036 | 19.7261 | 19.7036 | 19.7261 | 21336.0 |
| 2012-05-16 04:03:00 | AAPL | Stock | 19.7254 | 19.7254 | 19.7254 | 19.7254 | 2800.0 |
| 2012-05-16 04:04:00 | AAPL | Stock | 19.7254 | 19.7254 | 19.7254 | 19.7254 | 5600.0 |
| 2012-05-16 04:05:00 | AAPL | Stock | 19.7261 | 19.7261 | 19.7261 | 19.7261 | 5572.0 |
| 2012-05-16 04:08:00 | AAPL | Stock | 19.69 | 19.69 | 19.69 | 19.69 | 11200.0 |
| 2012-05-16 04:09:00 | AAPL | Stock | 19.7179 | 19.7179 | 19.7179 | 19.7179 | 2800.0 |
| 2012-05-16 04:11:00 | AAPL | Stock | 19.7179 | 19.7179 | 19.7179 | 19.7179 | 7000.0 |
| 2012-05-16 04:15:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 5628.0 |
| 2012-05-16 04:20:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 2800.0 |
| 2012-05-16 04:23:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 11200.0 |
| 2012-05-16 04:27:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 5600.0 |
| 2012-05-16 04:28:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 2800.0 |
| 2012-05-16 04:34:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 2800.0 |
| 2012-05-16 04:52:00 | AAPL | Stock | 19.7214 | 19.7214 | 19.7214 | 19.7214 | 8400.0 |
| 2012-05-16 05:16:00 | AAPL | Stock | 19.7393 | 19.7393 | 19.7393 | 19.7393 | 5600.0 |
| 2012-05-16 06:20:00 | AAPL | Stock | 19.7357 | 19.7357 | 19.7357 | 19.7357 | 5460.0 |
| 2012-05-16 06:30:00 | AAPL | Stock | 19.7768 | 19.7768 | 19.7768 | 19.7768 | 7420.0 |
| 2012-05-16 06:33:00 | AAPL | Stock | 19.7779 | 19.7782 | 19.7779 | 19.7779 | 8400.0 |
| 2012-05-16 06:34:00 | AAPL | Stock | 19.7779 | 19.7779 | 19.7779 | 19.7779 | 4200.0 |
| 2012-05-16 06:36:00 | AAPL | Stock | 19.7779 | 19.7779 | 19.7779 | 19.7779 | 2800.0 |
| 2012-05-16 06:39:00 | AAPL | Stock | 19.7779 | 19.7779 | 19.7779 | 19.7779 | 2800.0 |
| 2012-05-16 07:01:00 | AAPL | Stock | 19.785 | 19.7893 | 19.785 | 19.7893 | 14000.0 |
| 2012-05-16 07:03:00 | AAPL | Stock | 19.7996 | 19.8 | 19.7996 | 19.8 | 14000.0 |
| 2012-05-16 07:04:00 | AAPL | Stock | 19.7932 | 19.7932 | 19.7932 | 19.7932 | 2800.0 |
| 2012-05-16 07:10:00 | AAPL | Stock | 19.7982 | 19.7982 | 19.7946 | 19.7982 | 44212.0 |
| 2012-05-16 07:11:00 | AAPL | Stock | 19.8 | 19.8 | 19.8 | 19.8 | 2800.0 |
| 2012-05-16 07:12:00 | AAPL | Stock | 19.8057 | 19.8107 | 19.8057 | 19.8107 | 5600.0 |
| 2012-05-16 07:13:00 | AAPL | Stock | 19.8125 | 19.8129 | 19.8125 | 19.8129 | 12628.0 |
| 2012-05-16 07:14:00 | AAPL | Stock | 19.8171 | 19.8286 | 19.8171 | 19.8286 | 58072.0 |
| 2012-05-16 07:16:00 | AAPL | Stock | 19.8382 | 19.8386 | 19.8382 | 19.8386 | 16800.0 |
| 2012-05-16 07:17:00 | AAPL | Stock | 19.8393 | 19.8411 | 19.8146 | 19.8411 | 19600.0 |
| 2012-05-16 07:19:00 | AAPL | Stock | 19.8271 | 19.8446 | 19.8271 | 19.8443 | 18200.0 |
| 2012-05-16 07:20:00 | AAPL | Stock | 19.8443 | 19.8443 | 19.84 | 19.84 | 22400.0 |
| 2012-05-16 07:21:00 | AAPL | Stock | 19.845 | 19.85 | 19.845 | 19.85 | 30800.0 |
| 2012-05-16 07:23:00 | AAPL | Stock | 19.8532 | 19.8571 | 19.8532 | 19.8571 | 45360.0 |
| 2012-05-16 07:24:00 | AAPL | Stock | 19.8571 | 19.8661 | 19.8571 | 19.8571 | 16800.0 |
| 2012-05-16 07:26:00 | AAPL | Stock | 19.8668 | 19.8707 | 19.8589 | 19.8707 | 11200.0 |
| 2012-05-16 07:27:00 | AAPL | Stock | 19.8668 | 19.8668 | 19.8668 | 19.8668 | 14000.0 |
| 2012-05-16 07:28:00 | AAPL | Stock | 19.8482 | 19.8482 | 19.8439 | 19.8439 | 53200.0 |
| 2012-05-16 07:29:00 | AAPL | Stock | 19.85 | 19.8571 | 19.85 | 19.8571 | 24752.0 |
| 2012-05-16 07:30:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 19600.0 |
| 2012-05-16 07:31:00 | AAPL | Stock | 19.8568 | 19.8568 | 19.8568 | 19.8568 | 2800.0 |
| 2012-05-16 07:32:00 | AAPL | Stock | 19.8607 | 19.8607 | 19.8607 | 19.8607 | 2800.0 |
| 2012-05-16 07:33:00 | AAPL | Stock | 19.8568 | 19.8657 | 19.8543 | 19.8557 | 19600.0 |
| 2012-05-16 07:34:00 | AAPL | Stock | 19.8636 | 19.8636 | 19.8571 | 19.8571 | 22400.0 |
| 2012-05-16 07:36:00 | AAPL | Stock | 19.8571 | 19.8589 | 19.8571 | 19.8589 | 8400.0 |
| 2012-05-16 07:37:00 | AAPL | Stock | 19.8636 | 19.8668 | 19.8589 | 19.8589 | 50400.0 |
| 2012-05-16 07:38:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 2800.0 |
| 2012-05-16 07:39:00 | AAPL | Stock | 19.8604 | 19.8604 | 19.8604 | 19.8604 | 2800.0 |
| 2012-05-16 07:40:00 | AAPL | Stock | 19.8611 | 19.8721 | 19.8611 | 19.8721 | 92680.0 |
> showing 50 of 993,951 rows — these rows as CSV