PREVIEW / stock_1min / 2005-10-04
file: by_date/stock_1min/2005/2005-10-04.parquet size: 7.5 MB rows: 619,307 symbols: 1,709
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-04 08:00:00 | AAPL | Stock | 1.9482 | 1.9482 | 1.9482 | 1.9482 | 28000.0 |
| 2005-10-04 08:09:00 | AAPL | Stock | 1.95 | 1.95 | 1.95 | 1.95 | 11200.0 |
| 2005-10-04 08:10:00 | AAPL | Stock | 1.95 | 1.9543 | 1.95 | 1.9539 | 99960.0 |
| 2005-10-04 08:13:00 | AAPL | Stock | 1.9571 | 1.9571 | 1.9571 | 1.9571 | 33600.0 |
| 2005-10-04 08:14:00 | AAPL | Stock | 1.9546 | 1.9596 | 1.9546 | 1.9596 | 16800.0 |
| 2005-10-04 08:15:00 | AAPL | Stock | 1.9589 | 1.96 | 1.9589 | 1.9589 | 28000.0 |
| 2005-10-04 08:16:00 | AAPL | Stock | 1.9586 | 1.9586 | 1.9586 | 1.9586 | 28000.0 |
| 2005-10-04 08:17:00 | AAPL | Stock | 1.9589 | 1.9589 | 1.9589 | 1.9589 | 5600.0 |
| 2005-10-04 08:19:00 | AAPL | Stock | 1.9589 | 1.9589 | 1.9589 | 1.9589 | 28000.0 |
| 2005-10-04 08:21:00 | AAPL | Stock | 1.9561 | 1.9561 | 1.9561 | 1.9561 | 28000.0 |
| 2005-10-04 08:22:00 | AAPL | Stock | 1.9536 | 1.9554 | 1.9536 | 1.9554 | 16408.0 |
| 2005-10-04 08:23:00 | AAPL | Stock | 1.9554 | 1.9554 | 1.9554 | 1.9554 | 3500.0 |
| 2005-10-04 08:25:00 | AAPL | Stock | 1.9539 | 1.9543 | 1.9539 | 1.9543 | 30800.0 |
| 2005-10-04 08:26:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9536 | 1.9536 | 6720.0 |
| 2005-10-04 08:27:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9536 | 1.9536 | 29400.0 |
| 2005-10-04 08:28:00 | AAPL | Stock | 1.9521 | 1.9536 | 1.9521 | 1.9536 | 62384.0 |
| 2005-10-04 08:29:00 | AAPL | Stock | 1.9518 | 1.9518 | 1.9518 | 1.9518 | 5600.0 |
| 2005-10-04 08:30:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9521 | 1.9536 | 56000.0 |
| 2005-10-04 08:31:00 | AAPL | Stock | 1.9521 | 1.9521 | 1.9521 | 1.9521 | 2800.0 |
| 2005-10-04 08:32:00 | AAPL | Stock | 1.9521 | 1.9536 | 1.9521 | 1.9532 | 30800.0 |
| 2005-10-04 08:33:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9536 | 1.9536 | 8400.0 |
| 2005-10-04 08:34:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9536 | 1.9536 | 25200.0 |
| 2005-10-04 08:35:00 | AAPL | Stock | 1.9543 | 1.9571 | 1.9543 | 1.9571 | 58940.0 |
| 2005-10-04 08:36:00 | AAPL | Stock | 1.9571 | 1.9571 | 1.9571 | 1.9571 | 22540.0 |
| 2005-10-04 08:38:00 | AAPL | Stock | 1.9554 | 1.9554 | 1.9554 | 1.9554 | 27860.0 |
| 2005-10-04 08:41:00 | AAPL | Stock | 1.9564 | 1.9571 | 1.9564 | 1.9571 | 58800.0 |
| 2005-10-04 08:42:00 | AAPL | Stock | 1.9571 | 1.9579 | 1.9571 | 1.9579 | 33600.0 |
| 2005-10-04 08:43:00 | AAPL | Stock | 1.9586 | 1.9589 | 1.9586 | 1.9589 | 126000.0 |
| 2005-10-04 08:44:00 | AAPL | Stock | 1.96 | 1.9604 | 1.9596 | 1.9596 | 28000.0 |
| 2005-10-04 08:45:00 | AAPL | Stock | 1.9607 | 1.9607 | 1.9604 | 1.9607 | 92400.0 |
| 2005-10-04 08:46:00 | AAPL | Stock | 1.9625 | 1.9625 | 1.9625 | 1.9625 | 53200.0 |
| 2005-10-04 08:47:00 | AAPL | Stock | 1.9589 | 1.9589 | 1.9589 | 1.9589 | 30800.0 |
| 2005-10-04 08:48:00 | AAPL | Stock | 1.9607 | 1.9625 | 1.9604 | 1.9625 | 140000.0 |
| 2005-10-04 08:53:00 | AAPL | Stock | 1.9596 | 1.9596 | 1.9596 | 1.9596 | 2800.0 |
| 2005-10-04 08:54:00 | AAPL | Stock | 1.9596 | 1.9596 | 1.9596 | 1.9596 | 28000.0 |
| 2005-10-04 08:56:00 | AAPL | Stock | 1.9611 | 1.9611 | 1.9611 | 1.9611 | 33600.0 |
| 2005-10-04 08:57:00 | AAPL | Stock | 1.9621 | 1.9621 | 1.9614 | 1.9614 | 19600.0 |
| 2005-10-04 08:58:00 | AAPL | Stock | 1.9621 | 1.9621 | 1.9607 | 1.9607 | 45080.0 |
| 2005-10-04 08:59:00 | AAPL | Stock | 1.9607 | 1.9621 | 1.9607 | 1.9621 | 29120.0 |
| 2005-10-04 09:00:00 | AAPL | Stock | 1.9621 | 1.9621 | 1.9621 | 1.9621 | 6440.0 |
| 2005-10-04 09:01:00 | AAPL | Stock | 1.9614 | 1.9625 | 1.9614 | 1.9625 | 65548.0 |
| 2005-10-04 09:03:00 | AAPL | Stock | 1.9614 | 1.9629 | 1.9614 | 1.9629 | 12180.0 |
| 2005-10-04 09:05:00 | AAPL | Stock | 1.9632 | 1.9632 | 1.9632 | 1.9632 | 28000.0 |
| 2005-10-04 09:06:00 | AAPL | Stock | 1.9625 | 1.9625 | 1.9625 | 1.9625 | 2800.0 |
| 2005-10-04 09:07:00 | AAPL | Stock | 1.9625 | 1.9625 | 1.9618 | 1.9618 | 9800.0 |
| 2005-10-04 09:08:00 | AAPL | Stock | 1.9614 | 1.9614 | 1.9614 | 1.9614 | 8400.0 |
| 2005-10-04 09:09:00 | AAPL | Stock | 1.9607 | 1.9611 | 1.9607 | 1.9607 | 84840.0 |
| 2005-10-04 09:10:00 | AAPL | Stock | 1.9604 | 1.9604 | 1.9604 | 1.9604 | 12600.0 |
| 2005-10-04 09:14:00 | AAPL | Stock | 1.9596 | 1.9596 | 1.9596 | 1.9596 | 2800.0 |
| 2005-10-04 09:15:00 | AAPL | Stock | 1.9589 | 1.9589 | 1.9589 | 1.9589 | 14000.0 |
> showing 50 of 619,307 rows — these rows as CSV