PREVIEW / stock_1min / 2007-01-29
file: by_date/stock_1min/2007/2007-01-29.parquet size: 9.1 MB rows: 744,827 symbols: 2,044
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-29 07:00:00 | AAPL | Stock | 3.0436 | 3.0436 | 3.0436 | 3.0436 | 26600.0 |
| 2007-01-29 07:43:00 | AAPL | Stock | 3.0464 | 3.0464 | 3.0439 | 3.0439 | 16800.0 |
| 2007-01-29 07:46:00 | AAPL | Stock | 3.0471 | 3.0471 | 3.0471 | 3.0471 | 42000.0 |
| 2007-01-29 07:52:00 | AAPL | Stock | 3.0471 | 3.0471 | 3.0471 | 3.0471 | 28000.0 |
| 2007-01-29 07:58:00 | AAPL | Stock | 3.0536 | 3.0625 | 3.0536 | 3.0625 | 137200.0 |
| 2007-01-29 07:59:00 | AAPL | Stock | 3.0625 | 3.0707 | 3.0586 | 3.0586 | 599200.0 |
| 2007-01-29 08:00:00 | AAPL | Stock | 3.0625 | 3.0693 | 3.0611 | 3.0679 | 331128.0 |
| 2007-01-29 08:01:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0632 | 3.0661 | 212520.0 |
| 2007-01-29 08:02:00 | AAPL | Stock | 3.0661 | 3.0786 | 3.0661 | 3.0721 | 716660.0 |
| 2007-01-29 08:03:00 | AAPL | Stock | 3.0725 | 3.0779 | 3.0721 | 3.075 | 329000.0 |
| 2007-01-29 08:04:00 | AAPL | Stock | 3.0754 | 3.0779 | 3.075 | 3.0754 | 426328.0 |
| 2007-01-29 08:05:00 | AAPL | Stock | 3.0754 | 3.0789 | 3.0754 | 3.0768 | 271740.0 |
| 2007-01-29 08:06:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0718 | 3.0743 | 195776.0 |
| 2007-01-29 08:07:00 | AAPL | Stock | 3.0721 | 3.0757 | 3.0721 | 3.075 | 115500.0 |
| 2007-01-29 08:08:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0682 | 3.0693 | 109368.0 |
| 2007-01-29 08:09:00 | AAPL | Stock | 3.0711 | 3.0732 | 3.0693 | 3.0693 | 145600.0 |
| 2007-01-29 08:10:00 | AAPL | Stock | 3.0696 | 3.0696 | 3.0675 | 3.0679 | 264600.0 |
| 2007-01-29 08:11:00 | AAPL | Stock | 3.0696 | 3.0714 | 3.0693 | 3.0714 | 183400.0 |
| 2007-01-29 08:12:00 | AAPL | Stock | 3.0718 | 3.0718 | 3.0714 | 3.0714 | 5600.0 |
| 2007-01-29 08:13:00 | AAPL | Stock | 3.0725 | 3.0729 | 3.0714 | 3.0714 | 42000.0 |
| 2007-01-29 08:14:00 | AAPL | Stock | 3.0704 | 3.0714 | 3.0696 | 3.0714 | 48692.0 |
| 2007-01-29 08:15:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0711 | 3.0711 | 39200.0 |
| 2007-01-29 08:16:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 103600.0 |
| 2007-01-29 08:17:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0682 | 3.0682 | 134708.0 |
| 2007-01-29 08:18:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0668 | 3.0668 | 31360.0 |
| 2007-01-29 08:19:00 | AAPL | Stock | 3.0671 | 3.0671 | 3.0671 | 3.0671 | 2800.0 |
| 2007-01-29 08:20:00 | AAPL | Stock | 3.0686 | 3.0696 | 3.0679 | 3.0696 | 33600.0 |
| 2007-01-29 08:21:00 | AAPL | Stock | 3.0693 | 3.0693 | 3.0689 | 3.0689 | 35000.0 |
| 2007-01-29 08:22:00 | AAPL | Stock | 3.0689 | 3.0704 | 3.0689 | 3.0704 | 72800.0 |
| 2007-01-29 08:23:00 | AAPL | Stock | 3.0704 | 3.0711 | 3.0704 | 3.0704 | 140224.0 |
| 2007-01-29 08:24:00 | AAPL | Stock | 3.0689 | 3.07 | 3.0689 | 3.07 | 42000.0 |
| 2007-01-29 08:25:00 | AAPL | Stock | 3.07 | 3.07 | 3.07 | 3.07 | 153160.0 |
| 2007-01-29 08:26:00 | AAPL | Stock | 3.0689 | 3.0689 | 3.0679 | 3.0689 | 33600.0 |
| 2007-01-29 08:27:00 | AAPL | Stock | 3.0707 | 3.0707 | 3.0707 | 3.0707 | 2800.0 |
| 2007-01-29 08:28:00 | AAPL | Stock | 3.0696 | 3.0696 | 3.0696 | 3.0696 | 2800.0 |
| 2007-01-29 08:29:00 | AAPL | Stock | 3.07 | 3.0711 | 3.07 | 3.0704 | 378280.0 |
| 2007-01-29 08:30:00 | AAPL | Stock | 3.0696 | 3.0711 | 3.0696 | 3.0707 | 94920.0 |
| 2007-01-29 08:31:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.07 | 3.0704 | 54600.0 |
| 2007-01-29 08:32:00 | AAPL | Stock | 3.0707 | 3.0714 | 3.0707 | 3.0714 | 129668.0 |
| 2007-01-29 08:33:00 | AAPL | Stock | 3.0711 | 3.0714 | 3.0696 | 3.0714 | 131600.0 |
| 2007-01-29 08:34:00 | AAPL | Stock | 3.0707 | 3.0714 | 3.0707 | 3.0711 | 168420.0 |
| 2007-01-29 08:35:00 | AAPL | Stock | 3.0711 | 3.0714 | 3.07 | 3.0714 | 101220.0 |
| 2007-01-29 08:36:00 | AAPL | Stock | 3.0714 | 3.075 | 3.0714 | 3.0729 | 424060.0 |
| 2007-01-29 08:37:00 | AAPL | Stock | 3.0721 | 3.0729 | 3.0718 | 3.0725 | 67200.0 |
| 2007-01-29 08:38:00 | AAPL | Stock | 3.0721 | 3.0746 | 3.0718 | 3.0746 | 98000.0 |
| 2007-01-29 08:39:00 | AAPL | Stock | 3.0739 | 3.0746 | 3.0729 | 3.0746 | 95200.0 |
| 2007-01-29 08:40:00 | AAPL | Stock | 3.0739 | 3.0739 | 3.0714 | 3.0729 | 176400.0 |
| 2007-01-29 08:41:00 | AAPL | Stock | 3.0718 | 3.0721 | 3.0714 | 3.0718 | 50400.0 |
| 2007-01-29 08:42:00 | AAPL | Stock | 3.0725 | 3.0729 | 3.0718 | 3.0725 | 117600.0 |
| 2007-01-29 08:43:00 | AAPL | Stock | 3.0725 | 3.0729 | 3.0714 | 3.0714 | 77000.0 |
> showing 50 of 744,827 rows — these rows as CSV