PREVIEW / stock_1min / 2007-10-26
file: by_date/stock_1min/2007/2007-10-26.parquet size: 12.0 MB rows: 976,902 symbols: 2,578
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-26 05:24:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 2800.0 |
| 2007-10-26 05:30:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 2800.0 |
| 2007-10-26 06:00:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 2800.0 |
| 2007-10-26 06:01:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 11200.0 |
| 2007-10-26 06:55:00 | AAPL | Stock | 6.6061 | 6.6061 | 6.6061 | 6.6061 | 17472.0 |
| 2007-10-26 06:58:00 | AAPL | Stock | 6.6061 | 6.6061 | 6.6061 | 6.6061 | 14000.0 |
| 2007-10-26 07:02:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 2800.0 |
| 2007-10-26 07:04:00 | AAPL | Stock | 6.6139 | 6.6143 | 6.6139 | 6.6143 | 5600.0 |
| 2007-10-26 07:05:00 | AAPL | Stock | 6.6146 | 6.6146 | 6.6107 | 6.6107 | 38500.0 |
| 2007-10-26 07:07:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 8960.0 |
| 2007-10-26 07:08:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 5040.0 |
| 2007-10-26 07:09:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 5600.0 |
| 2007-10-26 07:14:00 | AAPL | Stock | 6.5936 | 6.5964 | 6.5932 | 6.5964 | 16800.0 |
| 2007-10-26 07:15:00 | AAPL | Stock | 6.5929 | 6.5929 | 6.5929 | 6.5929 | 9156.0 |
| 2007-10-26 07:18:00 | AAPL | Stock | 6.5936 | 6.5936 | 6.5918 | 6.5936 | 30800.0 |
| 2007-10-26 07:22:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 28000.0 |
| 2007-10-26 07:26:00 | AAPL | Stock | 6.6068 | 6.6071 | 6.6068 | 6.6071 | 11200.0 |
| 2007-10-26 07:27:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 4200.0 |
| 2007-10-26 07:28:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 4200.0 |
| 2007-10-26 07:29:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 25480.0 |
| 2007-10-26 07:30:00 | AAPL | Stock | 6.6004 | 6.6071 | 6.6 | 6.6071 | 19600.0 |
| 2007-10-26 07:32:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 68600.0 |
| 2007-10-26 07:35:00 | AAPL | Stock | 6.6043 | 6.6057 | 6.6043 | 6.6046 | 107800.0 |
| 2007-10-26 07:37:00 | AAPL | Stock | 6.5936 | 6.5936 | 6.5936 | 6.5936 | 8400.0 |
| 2007-10-26 07:39:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 14000.0 |
| 2007-10-26 07:46:00 | AAPL | Stock | 6.5936 | 6.5936 | 6.5871 | 6.5871 | 192724.0 |
| 2007-10-26 07:47:00 | AAPL | Stock | 6.5818 | 6.5818 | 6.575 | 6.575 | 386400.0 |
| 2007-10-26 07:48:00 | AAPL | Stock | 6.5721 | 6.5771 | 6.5721 | 6.5764 | 58800.0 |
| 2007-10-26 07:49:00 | AAPL | Stock | 6.5771 | 6.5771 | 6.5764 | 6.5771 | 100800.0 |
| 2007-10-26 07:50:00 | AAPL | Stock | 6.5871 | 6.5875 | 6.5786 | 6.5786 | 30800.0 |
| 2007-10-26 07:55:00 | AAPL | Stock | 6.5786 | 6.5786 | 6.5786 | 6.5786 | 2800.0 |
| 2007-10-26 07:56:00 | AAPL | Stock | 6.5714 | 6.5714 | 6.5714 | 6.5714 | 5600.0 |
| 2007-10-26 07:58:00 | AAPL | Stock | 6.5721 | 6.5786 | 6.5714 | 6.5714 | 132776.0 |
| 2007-10-26 08:00:00 | AAPL | Stock | 6.5786 | 6.5864 | 6.5643 | 6.5643 | 573692.0 |
| 2007-10-26 08:01:00 | AAPL | Stock | 6.5643 | 6.57 | 6.5639 | 6.5643 | 67200.0 |
| 2007-10-26 08:02:00 | AAPL | Stock | 6.5668 | 6.5714 | 6.5668 | 6.5714 | 96320.0 |
| 2007-10-26 08:03:00 | AAPL | Stock | 6.5714 | 6.575 | 6.5679 | 6.5714 | 122248.0 |
| 2007-10-26 08:04:00 | AAPL | Stock | 6.5761 | 6.5779 | 6.5714 | 6.5757 | 92848.0 |
| 2007-10-26 08:05:00 | AAPL | Stock | 6.5714 | 6.5746 | 6.5696 | 6.5714 | 56000.0 |
| 2007-10-26 08:06:00 | AAPL | Stock | 6.5714 | 6.575 | 6.5714 | 6.5714 | 35812.0 |
| 2007-10-26 08:07:00 | AAPL | Stock | 6.5696 | 6.5714 | 6.5679 | 6.5714 | 30744.0 |
| 2007-10-26 08:08:00 | AAPL | Stock | 6.5714 | 6.5714 | 6.5714 | 6.5714 | 29344.0 |
| 2007-10-26 08:09:00 | AAPL | Stock | 6.5714 | 6.5714 | 6.5714 | 6.5714 | 5600.0 |
| 2007-10-26 08:10:00 | AAPL | Stock | 6.5682 | 6.5714 | 6.5682 | 6.5714 | 19600.0 |
| 2007-10-26 08:11:00 | AAPL | Stock | 6.5714 | 6.5714 | 6.5696 | 6.5696 | 31780.0 |
| 2007-10-26 08:12:00 | AAPL | Stock | 6.5679 | 6.5711 | 6.5675 | 6.5675 | 56028.0 |
| 2007-10-26 08:13:00 | AAPL | Stock | 6.5675 | 6.5675 | 6.5621 | 6.5621 | 58800.0 |
| 2007-10-26 08:14:00 | AAPL | Stock | 6.5596 | 6.5621 | 6.5475 | 6.5546 | 248752.0 |
| 2007-10-26 08:15:00 | AAPL | Stock | 6.5525 | 6.5529 | 6.5446 | 6.5464 | 96264.0 |
| 2007-10-26 08:16:00 | AAPL | Stock | 6.5525 | 6.5532 | 6.5443 | 6.5525 | 130620.0 |
> showing 50 of 976,902 rows — these rows as CSV