PREVIEW / stock_1min / 2008-01-28
file: by_date/stock_1min/2008/2008-01-28.parquet size: 12.7 MB rows: 1,029,890 symbols: 2,663
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-28 06:54:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 2800.0 |
| 2008-01-28 07:13:00 | AAPL | Stock | 4.5979 | 4.5979 | 4.5964 | 4.5964 | 24752.0 |
| 2008-01-28 07:14:00 | AAPL | Stock | 4.6021 | 4.6021 | 4.6021 | 4.6021 | 14000.0 |
| 2008-01-28 07:15:00 | AAPL | Stock | 4.6021 | 4.6021 | 4.6021 | 4.6021 | 2800.0 |
| 2008-01-28 07:25:00 | AAPL | Stock | 4.5896 | 4.5896 | 4.5893 | 4.5893 | 87080.0 |
| 2008-01-28 07:29:00 | AAPL | Stock | 4.6 | 4.6 | 4.5996 | 4.6 | 27888.0 |
| 2008-01-28 07:31:00 | AAPL | Stock | 4.5857 | 4.5996 | 4.5857 | 4.5996 | 14000.0 |
| 2008-01-28 07:32:00 | AAPL | Stock | 4.5768 | 4.5768 | 4.5736 | 4.5736 | 39480.0 |
| 2008-01-28 07:35:00 | AAPL | Stock | 4.5929 | 4.5929 | 4.5929 | 4.5929 | 2800.0 |
| 2008-01-28 07:40:00 | AAPL | Stock | 4.5921 | 4.5921 | 4.5921 | 4.5921 | 2800.0 |
| 2008-01-28 07:41:00 | AAPL | Stock | 4.5832 | 4.5911 | 4.5829 | 4.5911 | 12600.0 |
| 2008-01-28 07:44:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 2800.0 |
| 2008-01-28 07:45:00 | AAPL | Stock | 4.5961 | 4.5961 | 4.5961 | 4.5961 | 2800.0 |
| 2008-01-28 07:46:00 | AAPL | Stock | 4.5993 | 4.6029 | 4.5986 | 4.6018 | 97636.0 |
| 2008-01-28 07:49:00 | AAPL | Stock | 4.6061 | 4.6061 | 4.6061 | 4.6061 | 19600.0 |
| 2008-01-28 07:51:00 | AAPL | Stock | 4.6082 | 4.6082 | 4.6082 | 4.6082 | 53928.0 |
| 2008-01-28 07:52:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 6328.0 |
| 2008-01-28 07:53:00 | AAPL | Stock | 4.6071 | 4.6161 | 4.6071 | 4.6161 | 77672.0 |
| 2008-01-28 07:58:00 | AAPL | Stock | 4.61 | 4.61 | 4.61 | 4.61 | 14000.0 |
| 2008-01-28 07:59:00 | AAPL | Stock | 4.61 | 4.62 | 4.6071 | 4.6071 | 25760.0 |
| 2008-01-28 08:00:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.5807 | 4.5839 | 354480.0 |
| 2008-01-28 08:01:00 | AAPL | Stock | 4.5925 | 4.5925 | 4.5821 | 4.5821 | 79996.0 |
| 2008-01-28 08:02:00 | AAPL | Stock | 4.5793 | 4.5893 | 4.575 | 4.5893 | 105028.0 |
| 2008-01-28 08:03:00 | AAPL | Stock | 4.5889 | 4.5943 | 4.5889 | 4.5943 | 140224.0 |
| 2008-01-28 08:04:00 | AAPL | Stock | 4.5996 | 4.6125 | 4.5996 | 4.6114 | 273056.0 |
| 2008-01-28 08:05:00 | AAPL | Stock | 4.6068 | 4.6161 | 4.6068 | 4.6161 | 306572.0 |
| 2008-01-28 08:06:00 | AAPL | Stock | 4.6161 | 4.6161 | 4.6096 | 4.6096 | 78960.0 |
| 2008-01-28 08:07:00 | AAPL | Stock | 4.6114 | 4.6114 | 4.6 | 4.6 | 98000.0 |
| 2008-01-28 08:08:00 | AAPL | Stock | 4.6007 | 4.6011 | 4.5936 | 4.5936 | 68040.0 |
| 2008-01-28 08:09:00 | AAPL | Stock | 4.5929 | 4.5964 | 4.5821 | 4.5821 | 136500.0 |
| 2008-01-28 08:10:00 | AAPL | Stock | 4.5893 | 4.5929 | 4.5893 | 4.5893 | 146216.0 |
| 2008-01-28 08:11:00 | AAPL | Stock | 4.5893 | 4.5918 | 4.5832 | 4.5857 | 169344.0 |
| 2008-01-28 08:12:00 | AAPL | Stock | 4.5857 | 4.5875 | 4.5804 | 4.5804 | 180264.0 |
| 2008-01-28 08:13:00 | AAPL | Stock | 4.5804 | 4.5893 | 4.5714 | 4.5714 | 185276.0 |
| 2008-01-28 08:14:00 | AAPL | Stock | 4.5786 | 4.5939 | 4.575 | 4.585 | 272748.0 |
| 2008-01-28 08:15:00 | AAPL | Stock | 4.5839 | 4.585 | 4.575 | 4.575 | 225260.0 |
| 2008-01-28 08:16:00 | AAPL | Stock | 4.5754 | 4.5811 | 4.575 | 4.5754 | 92400.0 |
| 2008-01-28 08:17:00 | AAPL | Stock | 4.5786 | 4.5804 | 4.5786 | 4.5804 | 11900.0 |
| 2008-01-28 08:18:00 | AAPL | Stock | 4.5786 | 4.5804 | 4.575 | 4.575 | 264460.0 |
| 2008-01-28 08:19:00 | AAPL | Stock | 4.575 | 4.5786 | 4.575 | 4.5779 | 80108.0 |
| 2008-01-28 08:20:00 | AAPL | Stock | 4.5764 | 4.5807 | 4.575 | 4.5807 | 124040.0 |
| 2008-01-28 08:21:00 | AAPL | Stock | 4.5807 | 4.5807 | 4.5732 | 4.5732 | 110320.0 |
| 2008-01-28 08:22:00 | AAPL | Stock | 4.5732 | 4.5793 | 4.5718 | 4.5743 | 74928.0 |
| 2008-01-28 08:23:00 | AAPL | Stock | 4.5793 | 4.5796 | 4.5736 | 4.5736 | 131152.0 |
| 2008-01-28 08:24:00 | AAPL | Stock | 4.5761 | 4.5764 | 4.5725 | 4.5725 | 33600.0 |
| 2008-01-28 08:25:00 | AAPL | Stock | 4.5725 | 4.5725 | 4.5671 | 4.5671 | 118328.0 |
| 2008-01-28 08:26:00 | AAPL | Stock | 4.5661 | 4.5686 | 4.5593 | 4.5632 | 83468.0 |
| 2008-01-28 08:27:00 | AAPL | Stock | 4.5629 | 4.5675 | 4.5611 | 4.5639 | 115108.0 |
| 2008-01-28 08:28:00 | AAPL | Stock | 4.5661 | 4.5679 | 4.5571 | 4.5679 | 157528.0 |
| 2008-01-28 08:29:00 | AAPL | Stock | 4.5679 | 4.5739 | 4.5679 | 4.5714 | 215460.0 |
> showing 50 of 1,029,890 rows — these rows as CSV