PREVIEW / stock_1min / 2010-10-29
file: by_date/stock_1min/2010/2010-10-29.parquet size: 12.3 MB rows: 927,475 symbols: 2,829
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-29 05:19:00 | AAPL | Stock | 10.8414 | 10.8661 | 10.8368 | 10.8368 | 9800.0 |
| 2010-10-29 05:37:00 | AAPL | Stock | 10.8586 | 10.8586 | 10.8586 | 10.8586 | 2800.0 |
| 2010-10-29 05:50:00 | AAPL | Stock | 10.8489 | 10.8489 | 10.8489 | 10.8489 | 2800.0 |
| 2010-10-29 06:28:00 | AAPL | Stock | 10.8371 | 10.8371 | 10.8371 | 10.8371 | 2800.0 |
| 2010-10-29 06:55:00 | AAPL | Stock | 10.8468 | 10.8468 | 10.8468 | 10.8468 | 2800.0 |
| 2010-10-29 06:56:00 | AAPL | Stock | 10.8518 | 10.8518 | 10.8471 | 10.8471 | 5600.0 |
| 2010-10-29 06:57:00 | AAPL | Stock | 10.8571 | 10.8571 | 10.8571 | 10.8571 | 2800.0 |
| 2010-10-29 07:03:00 | AAPL | Stock | 10.8464 | 10.8464 | 10.8464 | 10.8464 | 5600.0 |
| 2010-10-29 07:06:00 | AAPL | Stock | 10.8496 | 10.8496 | 10.8496 | 10.8496 | 2800.0 |
| 2010-10-29 07:20:00 | AAPL | Stock | 10.8396 | 10.8396 | 10.8396 | 10.8396 | 2800.0 |
| 2010-10-29 07:26:00 | AAPL | Stock | 10.8396 | 10.8396 | 10.8396 | 10.8396 | 2800.0 |
| 2010-10-29 07:37:00 | AAPL | Stock | 10.8393 | 10.8393 | 10.8393 | 10.8393 | 5600.0 |
| 2010-10-29 07:38:00 | AAPL | Stock | 10.8393 | 10.8393 | 10.8393 | 10.8393 | 4200.0 |
| 2010-10-29 07:52:00 | AAPL | Stock | 10.8432 | 10.8432 | 10.8432 | 10.8432 | 2800.0 |
| 2010-10-29 07:53:00 | AAPL | Stock | 10.8468 | 10.8468 | 10.8432 | 10.8432 | 5600.0 |
| 2010-10-29 07:58:00 | AAPL | Stock | 10.8525 | 10.8536 | 10.8525 | 10.8536 | 9380.0 |
| 2010-10-29 07:59:00 | AAPL | Stock | 10.8536 | 10.86 | 10.8536 | 10.86 | 22400.0 |
| 2010-10-29 08:00:00 | AAPL | Stock | 10.8629 | 10.8679 | 10.8539 | 10.8571 | 59640.0 |
| 2010-10-29 08:01:00 | AAPL | Stock | 10.8571 | 10.8571 | 10.8571 | 10.8571 | 5880.0 |
| 2010-10-29 08:02:00 | AAPL | Stock | 10.8571 | 10.8571 | 10.8571 | 10.8571 | 2800.0 |
| 2010-10-29 08:03:00 | AAPL | Stock | 10.8571 | 10.8618 | 10.8539 | 10.8568 | 76692.0 |
| 2010-10-29 08:04:00 | AAPL | Stock | 10.8564 | 10.8568 | 10.85 | 10.8529 | 63840.0 |
| 2010-10-29 08:05:00 | AAPL | Stock | 10.8564 | 10.8568 | 10.8564 | 10.8568 | 22204.0 |
| 2010-10-29 08:06:00 | AAPL | Stock | 10.8543 | 10.8543 | 10.8536 | 10.8536 | 25200.0 |
| 2010-10-29 08:07:00 | AAPL | Stock | 10.8518 | 10.8518 | 10.8518 | 10.8518 | 7980.0 |
| 2010-10-29 08:08:00 | AAPL | Stock | 10.8568 | 10.8571 | 10.8568 | 10.8571 | 23548.0 |
| 2010-10-29 08:09:00 | AAPL | Stock | 10.8621 | 10.8675 | 10.8621 | 10.8675 | 15400.0 |
| 2010-10-29 08:10:00 | AAPL | Stock | 10.8661 | 10.8693 | 10.8661 | 10.8693 | 12600.0 |
| 2010-10-29 08:11:00 | AAPL | Stock | 10.8714 | 10.8725 | 10.8714 | 10.8714 | 22400.0 |
| 2010-10-29 08:12:00 | AAPL | Stock | 10.8689 | 10.8689 | 10.8689 | 10.8689 | 5600.0 |
| 2010-10-29 08:13:00 | AAPL | Stock | 10.8714 | 10.8714 | 10.87 | 10.8711 | 32172.0 |
| 2010-10-29 08:14:00 | AAPL | Stock | 10.8714 | 10.8764 | 10.8686 | 10.8764 | 124544.0 |
| 2010-10-29 08:15:00 | AAPL | Stock | 10.88 | 10.8839 | 10.8732 | 10.8775 | 158200.0 |
| 2010-10-29 08:16:00 | AAPL | Stock | 10.8786 | 10.8804 | 10.8786 | 10.8804 | 14000.0 |
| 2010-10-29 08:17:00 | AAPL | Stock | 10.8818 | 10.8918 | 10.88 | 10.8886 | 92456.0 |
| 2010-10-29 08:18:00 | AAPL | Stock | 10.8846 | 10.8857 | 10.8746 | 10.8746 | 53200.0 |
| 2010-10-29 08:19:00 | AAPL | Stock | 10.875 | 10.875 | 10.875 | 10.875 | 2800.0 |
| 2010-10-29 08:20:00 | AAPL | Stock | 10.8782 | 10.8818 | 10.875 | 10.8807 | 68824.0 |
| 2010-10-29 08:21:00 | AAPL | Stock | 10.8811 | 10.8811 | 10.8804 | 10.8807 | 121800.0 |
| 2010-10-29 08:22:00 | AAPL | Stock | 10.8764 | 10.8764 | 10.875 | 10.875 | 9436.0 |
| 2010-10-29 08:24:00 | AAPL | Stock | 10.8739 | 10.8739 | 10.8732 | 10.8732 | 17416.0 |
| 2010-10-29 08:25:00 | AAPL | Stock | 10.8714 | 10.8718 | 10.8675 | 10.8718 | 8400.0 |
| 2010-10-29 08:26:00 | AAPL | Stock | 10.8686 | 10.8714 | 10.8686 | 10.8711 | 25200.0 |
| 2010-10-29 08:27:00 | AAPL | Stock | 10.8696 | 10.8696 | 10.8696 | 10.8696 | 2800.0 |
| 2010-10-29 08:28:00 | AAPL | Stock | 10.8707 | 10.8718 | 10.8707 | 10.8718 | 16800.0 |
| 2010-10-29 08:29:00 | AAPL | Stock | 10.8739 | 10.8779 | 10.8739 | 10.8779 | 25200.0 |
| 2010-10-29 08:30:00 | AAPL | Stock | 10.8779 | 10.8779 | 10.8646 | 10.8739 | 76720.0 |
| 2010-10-29 08:31:00 | AAPL | Stock | 10.8771 | 10.8814 | 10.8771 | 10.8814 | 55580.0 |
| 2010-10-29 08:32:00 | AAPL | Stock | 10.8839 | 10.8889 | 10.8839 | 10.8854 | 53200.0 |
| 2010-10-29 08:33:00 | AAPL | Stock | 10.8882 | 10.8911 | 10.8857 | 10.8857 | 84336.0 |
> showing 50 of 927,475 rows — these rows as CSV