PREVIEW / stock_1min / 2009-05-29
file: by_date/stock_1min/2009/2009-05-29.parquet size: 13.1 MB rows: 1,001,514 symbols: 2,743
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-05-29 06:44:00 | AAPL | Stock | 4.8782 | 4.8782 | 4.8782 | 4.8782 | 2800.0 |
| 2009-05-29 07:23:00 | AAPL | Stock | 4.8743 | 4.8743 | 4.8743 | 4.8743 | 2800.0 |
| 2009-05-29 07:26:00 | AAPL | Stock | 4.8743 | 4.8743 | 4.8743 | 4.8743 | 5600.0 |
| 2009-05-29 07:28:00 | AAPL | Stock | 4.8743 | 4.8746 | 4.8743 | 4.8746 | 8680.0 |
| 2009-05-29 07:29:00 | AAPL | Stock | 4.8746 | 4.8746 | 4.8746 | 4.8746 | 5600.0 |
| 2009-05-29 07:41:00 | AAPL | Stock | 4.875 | 4.875 | 4.8729 | 4.875 | 29960.0 |
| 2009-05-29 08:00:00 | AAPL | Stock | 4.8525 | 4.8657 | 4.8482 | 4.8482 | 45052.0 |
| 2009-05-29 08:01:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.8571 | 4.8571 | 5908.0 |
| 2009-05-29 08:02:00 | AAPL | Stock | 4.8557 | 4.8636 | 4.8557 | 4.8607 | 43120.0 |
| 2009-05-29 08:03:00 | AAPL | Stock | 4.8554 | 4.8607 | 4.8554 | 4.8607 | 47600.0 |
| 2009-05-29 08:04:00 | AAPL | Stock | 4.8636 | 4.8661 | 4.8636 | 4.8643 | 32900.0 |
| 2009-05-29 08:05:00 | AAPL | Stock | 4.8661 | 4.8679 | 4.8661 | 4.8661 | 32116.0 |
| 2009-05-29 08:06:00 | AAPL | Stock | 4.8582 | 4.8661 | 4.8571 | 4.8661 | 28196.0 |
| 2009-05-29 08:09:00 | AAPL | Stock | 4.8661 | 4.8661 | 4.865 | 4.865 | 34692.0 |
| 2009-05-29 08:10:00 | AAPL | Stock | 4.8661 | 4.8671 | 4.865 | 4.8671 | 39340.0 |
| 2009-05-29 08:12:00 | AAPL | Stock | 4.8614 | 4.8614 | 4.8614 | 4.8614 | 2800.0 |
| 2009-05-29 08:13:00 | AAPL | Stock | 4.8654 | 4.8661 | 4.8654 | 4.8661 | 24136.0 |
| 2009-05-29 08:14:00 | AAPL | Stock | 4.8614 | 4.8614 | 4.8614 | 4.8614 | 2800.0 |
| 2009-05-29 08:15:00 | AAPL | Stock | 4.8614 | 4.8668 | 4.8607 | 4.8668 | 75796.0 |
| 2009-05-29 08:16:00 | AAPL | Stock | 4.8646 | 4.8679 | 4.8625 | 4.8679 | 36400.0 |
| 2009-05-29 08:17:00 | AAPL | Stock | 4.8618 | 4.8618 | 4.8589 | 4.8607 | 61544.0 |
| 2009-05-29 08:18:00 | AAPL | Stock | 4.8618 | 4.8618 | 4.86 | 4.86 | 46900.0 |
| 2009-05-29 08:19:00 | AAPL | Stock | 4.8593 | 4.8604 | 4.8571 | 4.8604 | 60060.0 |
| 2009-05-29 08:20:00 | AAPL | Stock | 4.8582 | 4.8582 | 4.8571 | 4.8571 | 26600.0 |
| 2009-05-29 08:21:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.8564 | 4.8571 | 22400.0 |
| 2009-05-29 08:22:00 | AAPL | Stock | 4.8568 | 4.8568 | 4.8539 | 4.8539 | 25200.0 |
| 2009-05-29 08:23:00 | AAPL | Stock | 4.8554 | 4.8571 | 4.8529 | 4.8529 | 46200.0 |
| 2009-05-29 08:24:00 | AAPL | Stock | 4.8529 | 4.8536 | 4.8529 | 4.8536 | 16800.0 |
| 2009-05-29 08:25:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8536 | 4.8536 | 18172.0 |
| 2009-05-29 08:29:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8536 | 4.8536 | 2800.0 |
| 2009-05-29 08:30:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8518 | 4.8518 | 23520.0 |
| 2009-05-29 08:31:00 | AAPL | Stock | 4.8468 | 4.8486 | 4.8461 | 4.8479 | 23800.0 |
| 2009-05-29 08:32:00 | AAPL | Stock | 4.8479 | 4.85 | 4.8464 | 4.85 | 14280.0 |
| 2009-05-29 08:33:00 | AAPL | Stock | 4.8464 | 4.8521 | 4.8464 | 4.8464 | 33600.0 |
| 2009-05-29 08:34:00 | AAPL | Stock | 4.8468 | 4.8489 | 4.8468 | 4.8489 | 5600.0 |
| 2009-05-29 08:35:00 | AAPL | Stock | 4.8475 | 4.85 | 4.8461 | 4.8461 | 53704.0 |
| 2009-05-29 08:36:00 | AAPL | Stock | 4.8493 | 4.8493 | 4.8489 | 4.8493 | 9800.0 |
| 2009-05-29 08:38:00 | AAPL | Stock | 4.8511 | 4.8539 | 4.8507 | 4.8536 | 33600.0 |
| 2009-05-29 08:39:00 | AAPL | Stock | 4.8525 | 4.8525 | 4.8496 | 4.8496 | 30520.0 |
| 2009-05-29 08:40:00 | AAPL | Stock | 4.8493 | 4.8493 | 4.8493 | 4.8493 | 2800.0 |
| 2009-05-29 08:41:00 | AAPL | Stock | 4.8486 | 4.8486 | 4.8479 | 4.8482 | 8400.0 |
| 2009-05-29 08:42:00 | AAPL | Stock | 4.8479 | 4.8482 | 4.8479 | 4.8479 | 8400.0 |
| 2009-05-29 08:43:00 | AAPL | Stock | 4.8471 | 4.8482 | 4.8464 | 4.8482 | 28000.0 |
| 2009-05-29 08:44:00 | AAPL | Stock | 4.8493 | 4.85 | 4.8489 | 4.85 | 11200.0 |
| 2009-05-29 08:45:00 | AAPL | Stock | 4.8504 | 4.8504 | 4.8504 | 4.8504 | 2800.0 |
| 2009-05-29 08:46:00 | AAPL | Stock | 4.8493 | 4.8493 | 4.8482 | 4.8482 | 11200.0 |
| 2009-05-29 08:47:00 | AAPL | Stock | 4.8525 | 4.8525 | 4.8514 | 4.8514 | 8400.0 |
| 2009-05-29 08:49:00 | AAPL | Stock | 4.8514 | 4.8514 | 4.8514 | 4.8514 | 5600.0 |
| 2009-05-29 08:50:00 | AAPL | Stock | 4.8507 | 4.8514 | 4.8507 | 4.8511 | 8400.0 |
| 2009-05-29 08:55:00 | AAPL | Stock | 4.8514 | 4.8518 | 4.8514 | 4.8518 | 12600.0 |
> showing 50 of 1,001,514 rows — these rows as CSV