PREVIEW / stock_1min / 2008-03-28
file: by_date/stock_1min/2008/2008-03-28.parquet size: 11.9 MB rows: 971,380 symbols: 2,680
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-03-28 04:24:00 | AAPL | Stock | 5.0393 | 5.0393 | 5.0393 | 5.0393 | 5600.0 |
| 2008-03-28 04:48:00 | AAPL | Stock | 5.0393 | 5.0393 | 5.0393 | 5.0393 | 5600.0 |
| 2008-03-28 05:29:00 | AAPL | Stock | 5.0761 | 5.0761 | 5.0761 | 5.0761 | 14000.0 |
| 2008-03-28 06:04:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0818 | 5.0818 | 2800.0 |
| 2008-03-28 06:05:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0818 | 5.0818 | 2800.0 |
| 2008-03-28 06:27:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 14000.0 |
| 2008-03-28 06:36:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 2800.0 |
| 2008-03-28 06:38:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 2800.0 |
| 2008-03-28 06:57:00 | AAPL | Stock | 5.0671 | 5.0671 | 5.0393 | 5.0393 | 83720.0 |
| 2008-03-28 06:58:00 | AAPL | Stock | 5.0411 | 5.0411 | 5.0411 | 5.0411 | 5040.0 |
| 2008-03-28 07:02:00 | AAPL | Stock | 5.08 | 5.08 | 5.08 | 5.08 | 5600.0 |
| 2008-03-28 07:15:00 | AAPL | Stock | 5.0711 | 5.0711 | 5.0711 | 5.0711 | 14000.0 |
| 2008-03-28 07:16:00 | AAPL | Stock | 5.0725 | 5.0725 | 5.0725 | 5.0725 | 8400.0 |
| 2008-03-28 07:17:00 | AAPL | Stock | 5.075 | 5.075 | 5.075 | 5.075 | 2800.0 |
| 2008-03-28 07:18:00 | AAPL | Stock | 5.0725 | 5.075 | 5.0725 | 5.075 | 40600.0 |
| 2008-03-28 07:19:00 | AAPL | Stock | 5.075 | 5.0782 | 5.075 | 5.0782 | 72240.0 |
| 2008-03-28 07:26:00 | AAPL | Stock | 5.075 | 5.075 | 5.075 | 5.075 | 19600.0 |
| 2008-03-28 07:32:00 | AAPL | Stock | 5.0893 | 5.09 | 5.0893 | 5.09 | 25396.0 |
| 2008-03-28 07:37:00 | AAPL | Stock | 5.0911 | 5.0911 | 5.0911 | 5.0911 | 2800.0 |
| 2008-03-28 07:39:00 | AAPL | Stock | 5.0882 | 5.0893 | 5.0882 | 5.0886 | 36400.0 |
| 2008-03-28 07:45:00 | AAPL | Stock | 5.0814 | 5.0814 | 5.0814 | 5.0814 | 2800.0 |
| 2008-03-28 07:52:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 8400.0 |
| 2008-03-28 07:53:00 | AAPL | Stock | 5.0893 | 5.0964 | 5.0893 | 5.0964 | 19124.0 |
| 2008-03-28 07:56:00 | AAPL | Stock | 5.0814 | 5.0821 | 5.0607 | 5.075 | 33180.0 |
| 2008-03-28 07:57:00 | AAPL | Stock | 5.0711 | 5.0714 | 5.0711 | 5.0714 | 19600.0 |
| 2008-03-28 07:59:00 | AAPL | Stock | 5.0807 | 5.0807 | 5.0807 | 5.0807 | 2800.0 |
| 2008-03-28 08:00:00 | AAPL | Stock | 5.0821 | 5.0871 | 5.0682 | 5.0786 | 157360.0 |
| 2008-03-28 08:01:00 | AAPL | Stock | 5.075 | 5.075 | 5.0714 | 5.0714 | 73640.0 |
| 2008-03-28 08:02:00 | AAPL | Stock | 5.0714 | 5.0764 | 5.0714 | 5.0764 | 35000.0 |
| 2008-03-28 08:03:00 | AAPL | Stock | 5.0732 | 5.0732 | 5.0661 | 5.0661 | 117600.0 |
| 2008-03-28 08:04:00 | AAPL | Stock | 5.0679 | 5.0714 | 5.0643 | 5.0643 | 77672.0 |
| 2008-03-28 08:05:00 | AAPL | Stock | 5.0643 | 5.0668 | 5.0643 | 5.0668 | 14728.0 |
| 2008-03-28 08:06:00 | AAPL | Stock | 5.0679 | 5.0679 | 5.0679 | 5.0679 | 5600.0 |
| 2008-03-28 08:07:00 | AAPL | Stock | 5.0668 | 5.07 | 5.0668 | 5.07 | 22400.0 |
| 2008-03-28 08:08:00 | AAPL | Stock | 5.07 | 5.0707 | 5.07 | 5.07 | 38500.0 |
| 2008-03-28 08:09:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 50400.0 |
| 2008-03-28 08:10:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 5600.0 |
| 2008-03-28 08:12:00 | AAPL | Stock | 5.0714 | 5.0729 | 5.0707 | 5.0718 | 110880.0 |
| 2008-03-28 08:13:00 | AAPL | Stock | 5.0714 | 5.0732 | 5.0707 | 5.0707 | 8568.0 |
| 2008-03-28 08:14:00 | AAPL | Stock | 5.0671 | 5.0671 | 5.0661 | 5.0671 | 10668.0 |
| 2008-03-28 08:15:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0661 | 5.0661 | 41300.0 |
| 2008-03-28 08:17:00 | AAPL | Stock | 5.0711 | 5.0714 | 5.0711 | 5.0711 | 39200.0 |
| 2008-03-28 08:19:00 | AAPL | Stock | 5.0696 | 5.0714 | 5.0693 | 5.0714 | 47600.0 |
| 2008-03-28 08:20:00 | AAPL | Stock | 5.0711 | 5.0711 | 5.0711 | 5.0711 | 2800.0 |
| 2008-03-28 08:21:00 | AAPL | Stock | 5.07 | 5.07 | 5.07 | 5.07 | 2800.0 |
| 2008-03-28 08:22:00 | AAPL | Stock | 5.0714 | 5.0732 | 5.0714 | 5.0732 | 37800.0 |
| 2008-03-28 08:23:00 | AAPL | Stock | 5.0729 | 5.0732 | 5.0729 | 5.0732 | 50484.0 |
| 2008-03-28 08:24:00 | AAPL | Stock | 5.0732 | 5.0746 | 5.0732 | 5.0746 | 50316.0 |
| 2008-03-28 08:25:00 | AAPL | Stock | 5.0736 | 5.0739 | 5.0732 | 5.0739 | 8400.0 |
| 2008-03-28 08:26:00 | AAPL | Stock | 5.0732 | 5.0732 | 5.0714 | 5.0714 | 80528.0 |
> showing 50 of 971,380 rows — these rows as CSV