PREVIEW / stock_1min / 2009-10-14
file: by_date/stock_1min/2009/2009-10-14.parquet size: 12.9 MB rows: 974,229 symbols: 2,767
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-14 04:15:00 | AAPL | Stock | 6.8168 | 6.8168 | 6.8168 | 6.8168 | 2800.0 |
| 2009-10-14 05:35:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 2800.0 |
| 2009-10-14 06:24:00 | AAPL | Stock | 6.8479 | 6.8479 | 6.8479 | 6.8479 | 2800.0 |
| 2009-10-14 06:38:00 | AAPL | Stock | 6.8539 | 6.8539 | 6.8539 | 6.8539 | 2800.0 |
| 2009-10-14 06:41:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 9800.0 |
| 2009-10-14 06:44:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 2800.0 |
| 2009-10-14 06:54:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 2800.0 |
| 2009-10-14 06:59:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 111244.0 |
| 2009-10-14 07:01:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 23884.0 |
| 2009-10-14 07:02:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 30800.0 |
| 2009-10-14 07:03:00 | AAPL | Stock | 6.8482 | 6.8564 | 6.8482 | 6.8564 | 16800.0 |
| 2009-10-14 07:06:00 | AAPL | Stock | 6.8564 | 6.8564 | 6.8564 | 6.8564 | 6440.0 |
| 2009-10-14 07:07:00 | AAPL | Stock | 6.8564 | 6.8564 | 6.8564 | 6.8564 | 10360.0 |
| 2009-10-14 07:08:00 | AAPL | Stock | 6.8568 | 6.8571 | 6.8568 | 6.8571 | 42000.0 |
| 2009-10-14 07:11:00 | AAPL | Stock | 6.8571 | 6.8625 | 6.8571 | 6.8625 | 62272.0 |
| 2009-10-14 07:16:00 | AAPL | Stock | 6.8646 | 6.8646 | 6.8646 | 6.8646 | 4900.0 |
| 2009-10-14 07:17:00 | AAPL | Stock | 6.8646 | 6.8646 | 6.8646 | 6.8646 | 56000.0 |
| 2009-10-14 07:18:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 2800.0 |
| 2009-10-14 07:20:00 | AAPL | Stock | 6.8571 | 6.8646 | 6.8571 | 6.8646 | 16660.0 |
| 2009-10-14 07:21:00 | AAPL | Stock | 6.8643 | 6.8646 | 6.8643 | 6.8646 | 14000.0 |
| 2009-10-14 07:36:00 | AAPL | Stock | 6.8646 | 6.8646 | 6.8646 | 6.8646 | 23240.0 |
| 2009-10-14 07:40:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8643 | 6.8643 | 11200.0 |
| 2009-10-14 07:43:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8643 | 6.8643 | 151200.0 |
| 2009-10-14 07:49:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 11032.0 |
| 2009-10-14 07:51:00 | AAPL | Stock | 6.8639 | 6.8639 | 6.8564 | 6.8571 | 158172.0 |
| 2009-10-14 07:52:00 | AAPL | Stock | 6.8625 | 6.8625 | 6.8625 | 6.8625 | 2800.0 |
| 2009-10-14 07:54:00 | AAPL | Stock | 6.8611 | 6.8643 | 6.8571 | 6.8643 | 285600.0 |
| 2009-10-14 08:00:00 | AAPL | Stock | 6.8639 | 6.8646 | 6.8568 | 6.86 | 363272.0 |
| 2009-10-14 08:01:00 | AAPL | Stock | 6.8575 | 6.86 | 6.8571 | 6.8571 | 131264.0 |
| 2009-10-14 08:02:00 | AAPL | Stock | 6.8589 | 6.86 | 6.8571 | 6.86 | 79912.0 |
| 2009-10-14 08:03:00 | AAPL | Stock | 6.8625 | 6.8643 | 6.8571 | 6.8611 | 68236.0 |
| 2009-10-14 08:04:00 | AAPL | Stock | 6.8611 | 6.8618 | 6.8589 | 6.8618 | 109256.0 |
| 2009-10-14 08:05:00 | AAPL | Stock | 6.86 | 6.86 | 6.86 | 6.86 | 5600.0 |
| 2009-10-14 08:06:00 | AAPL | Stock | 6.8639 | 6.8639 | 6.8639 | 6.8639 | 9100.0 |
| 2009-10-14 08:07:00 | AAPL | Stock | 6.8636 | 6.8643 | 6.8571 | 6.8571 | 95704.0 |
| 2009-10-14 08:09:00 | AAPL | Stock | 6.8607 | 6.8607 | 6.8607 | 6.8607 | 2800.0 |
| 2009-10-14 08:10:00 | AAPL | Stock | 6.8571 | 6.8607 | 6.8571 | 6.8607 | 40600.0 |
| 2009-10-14 08:11:00 | AAPL | Stock | 6.8632 | 6.8639 | 6.8618 | 6.8639 | 19600.0 |
| 2009-10-14 08:12:00 | AAPL | Stock | 6.8636 | 6.8639 | 6.8589 | 6.86 | 16800.0 |
| 2009-10-14 08:14:00 | AAPL | Stock | 6.8607 | 6.8636 | 6.8607 | 6.8636 | 18200.0 |
| 2009-10-14 08:15:00 | AAPL | Stock | 6.8607 | 6.8636 | 6.8607 | 6.8636 | 8400.0 |
| 2009-10-14 08:16:00 | AAPL | Stock | 6.8607 | 6.8607 | 6.8607 | 6.8607 | 25200.0 |
| 2009-10-14 08:17:00 | AAPL | Stock | 6.8636 | 6.8646 | 6.8636 | 6.8646 | 173320.0 |
| 2009-10-14 08:18:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8614 | 6.8643 | 70000.0 |
| 2009-10-14 08:19:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8639 | 6.8643 | 15400.0 |
| 2009-10-14 08:20:00 | AAPL | Stock | 6.8643 | 6.8664 | 6.8643 | 6.8664 | 56980.0 |
| 2009-10-14 08:22:00 | AAPL | Stock | 6.8679 | 6.8696 | 6.8679 | 6.8693 | 73584.0 |
| 2009-10-14 08:23:00 | AAPL | Stock | 6.8696 | 6.8714 | 6.8679 | 6.8714 | 86856.0 |
| 2009-10-14 08:24:00 | AAPL | Stock | 6.8704 | 6.8707 | 6.8704 | 6.8704 | 135604.0 |
| 2009-10-14 08:25:00 | AAPL | Stock | 6.8679 | 6.87 | 6.8679 | 6.87 | 14000.0 |
> showing 50 of 974,229 rows — these rows as CSV