PREVIEW / stock_1min / 2007-01-03
file: by_date/stock_1min/2007/2007-01-03.parquet size: 10.2 MB rows: 810,203 symbols: 2,042
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-01-03 04:15:00 | AAPL | Stock | 3.0832 | 3.0832 | 3.0718 | 3.0718 | 120400.0 |
| 2007-01-03 06:07:00 | AAPL | Stock | 3.0804 | 3.0804 | 3.0804 | 3.0804 | 2800.0 |
| 2007-01-03 06:08:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0714 | 3.0729 | 136080.0 |
| 2007-01-03 06:49:00 | AAPL | Stock | 3.0729 | 3.0729 | 3.0729 | 3.0729 | 5600.0 |
| 2007-01-03 07:03:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 28000.0 |
| 2007-01-03 07:04:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 14000.0 |
| 2007-01-03 07:05:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 64400.0 |
| 2007-01-03 07:14:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 8400.0 |
| 2007-01-03 07:15:00 | AAPL | Stock | 3.0786 | 3.0821 | 3.0786 | 3.0821 | 36400.0 |
| 2007-01-03 07:16:00 | AAPL | Stock | 3.0821 | 3.0821 | 3.0821 | 3.0821 | 2800.0 |
| 2007-01-03 07:17:00 | AAPL | Stock | 3.0804 | 3.0821 | 3.0804 | 3.0821 | 14000.0 |
| 2007-01-03 07:22:00 | AAPL | Stock | 3.0768 | 3.0768 | 3.0768 | 3.0768 | 140000.0 |
| 2007-01-03 07:23:00 | AAPL | Stock | 3.0718 | 3.0718 | 3.0686 | 3.0686 | 15400.0 |
| 2007-01-03 07:29:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0711 | 3.0711 | 5600.0 |
| 2007-01-03 07:33:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0711 | 3.0711 | 58800.0 |
| 2007-01-03 07:35:00 | AAPL | Stock | 3.075 | 3.0782 | 3.0732 | 3.0732 | 14000.0 |
| 2007-01-03 07:36:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0711 | 3.0711 | 64400.0 |
| 2007-01-03 07:37:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0711 | 3.0711 | 11200.0 |
| 2007-01-03 07:38:00 | AAPL | Stock | 3.0732 | 3.0786 | 3.0732 | 3.0786 | 36400.0 |
| 2007-01-03 07:39:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 2800.0 |
| 2007-01-03 07:41:00 | AAPL | Stock | 3.0746 | 3.0746 | 3.0746 | 3.0746 | 10640.0 |
| 2007-01-03 07:42:00 | AAPL | Stock | 3.0736 | 3.0736 | 3.0736 | 3.0736 | 2800.0 |
| 2007-01-03 07:50:00 | AAPL | Stock | 3.0743 | 3.0786 | 3.0739 | 3.0782 | 364000.0 |
| 2007-01-03 07:51:00 | AAPL | Stock | 3.0775 | 3.0786 | 3.0775 | 3.0775 | 296800.0 |
| 2007-01-03 07:55:00 | AAPL | Stock | 3.0757 | 3.0757 | 3.0711 | 3.0711 | 47600.0 |
| 2007-01-03 07:56:00 | AAPL | Stock | 3.0696 | 3.0714 | 3.0686 | 3.0714 | 14000.0 |
| 2007-01-03 07:57:00 | AAPL | Stock | 3.0711 | 3.0743 | 3.0711 | 3.0743 | 19600.0 |
| 2007-01-03 07:59:00 | AAPL | Stock | 3.0754 | 3.0771 | 3.0754 | 3.0771 | 11200.0 |
| 2007-01-03 08:00:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0729 | 3.0786 | 768880.0 |
| 2007-01-03 08:01:00 | AAPL | Stock | 3.0768 | 3.0786 | 3.0768 | 3.0786 | 156800.0 |
| 2007-01-03 08:02:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0775 | 3.0786 | 225260.0 |
| 2007-01-03 08:03:00 | AAPL | Stock | 3.0786 | 3.0804 | 3.0786 | 3.0804 | 426804.0 |
| 2007-01-03 08:04:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0771 | 3.0775 | 70000.0 |
| 2007-01-03 08:05:00 | AAPL | Stock | 3.0768 | 3.0768 | 3.0754 | 3.0754 | 221956.0 |
| 2007-01-03 08:06:00 | AAPL | Stock | 3.075 | 3.0754 | 3.0732 | 3.0732 | 39200.0 |
| 2007-01-03 08:07:00 | AAPL | Stock | 3.0729 | 3.0732 | 3.0696 | 3.0714 | 679840.0 |
| 2007-01-03 08:08:00 | AAPL | Stock | 3.0704 | 3.0754 | 3.0679 | 3.0754 | 340760.0 |
| 2007-01-03 08:09:00 | AAPL | Stock | 3.0714 | 3.0754 | 3.0714 | 3.0746 | 44744.0 |
| 2007-01-03 08:10:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 34160.0 |
| 2007-01-03 08:11:00 | AAPL | Stock | 3.07 | 3.0714 | 3.07 | 3.0714 | 44240.0 |
| 2007-01-03 08:12:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0714 | 3.0714 | 37520.0 |
| 2007-01-03 08:13:00 | AAPL | Stock | 3.0704 | 3.0725 | 3.07 | 3.0725 | 208572.0 |
| 2007-01-03 08:14:00 | AAPL | Stock | 3.0732 | 3.0754 | 3.0714 | 3.0714 | 124712.0 |
| 2007-01-03 08:15:00 | AAPL | Stock | 3.0725 | 3.075 | 3.0714 | 3.0725 | 98000.0 |
| 2007-01-03 08:16:00 | AAPL | Stock | 3.0736 | 3.0736 | 3.0714 | 3.0714 | 56000.0 |
| 2007-01-03 08:17:00 | AAPL | Stock | 3.0721 | 3.075 | 3.0721 | 3.0743 | 146440.0 |
| 2007-01-03 08:18:00 | AAPL | Stock | 3.0743 | 3.075 | 3.0743 | 3.075 | 8400.0 |
| 2007-01-03 08:19:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0732 | 3.0732 | 36400.0 |
| 2007-01-03 08:20:00 | AAPL | Stock | 3.0732 | 3.0743 | 3.0732 | 3.0736 | 142800.0 |
| 2007-01-03 08:21:00 | AAPL | Stock | 3.0736 | 3.075 | 3.0732 | 3.0732 | 93520.0 |
> showing 50 of 810,203 rows — these rows as CSV