PREVIEW / stock_1min / 2011-01-06
file: by_date/stock_1min/2011/2011-01-06.parquet size: 13.3 MB rows: 994,180 symbols: 2,856
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-06 05:12:00 | AAPL | Stock | 11.9968 | 11.9968 | 11.9968 | 11.9968 | 2800.0 |
| 2011-01-06 05:13:00 | AAPL | Stock | 11.9661 | 11.9707 | 11.9661 | 11.9707 | 5600.0 |
| 2011-01-06 05:15:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 8400.0 |
| 2011-01-06 05:29:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 2800.0 |
| 2011-01-06 05:31:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 2800.0 |
| 2011-01-06 05:38:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-06 05:40:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-06 05:43:00 | AAPL | Stock | 11.9989 | 11.9989 | 11.9989 | 11.9989 | 2800.0 |
| 2011-01-06 06:20:00 | AAPL | Stock | 12.0025 | 12.0025 | 12.0025 | 12.0025 | 3640.0 |
| 2011-01-06 06:35:00 | AAPL | Stock | 12.0279 | 12.0279 | 12.0279 | 12.0279 | 2800.0 |
| 2011-01-06 06:36:00 | AAPL | Stock | 11.9789 | 12.025 | 11.9789 | 12.025 | 5600.0 |
| 2011-01-06 06:50:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9532 | 11.9643 | 50680.0 |
| 2011-01-06 06:51:00 | AAPL | Stock | 12.0321 | 12.0321 | 12.0321 | 12.0321 | 5600.0 |
| 2011-01-06 06:52:00 | AAPL | Stock | 12.0311 | 12.0311 | 12.0311 | 12.0311 | 2800.0 |
| 2011-01-06 06:54:00 | AAPL | Stock | 12.0036 | 12.0036 | 12.0036 | 12.0036 | 2800.0 |
| 2011-01-06 07:05:00 | AAPL | Stock | 12.0089 | 12.0089 | 12.0089 | 12.0089 | 2800.0 |
| 2011-01-06 07:07:00 | AAPL | Stock | 12.0096 | 12.0096 | 12.0096 | 12.0096 | 5600.0 |
| 2011-01-06 07:08:00 | AAPL | Stock | 12.0096 | 12.0096 | 12.0096 | 12.0096 | 16800.0 |
| 2011-01-06 07:09:00 | AAPL | Stock | 12.0107 | 12.0107 | 12.0107 | 12.0107 | 4200.0 |
| 2011-01-06 07:10:00 | AAPL | Stock | 12.0096 | 12.0096 | 12.0096 | 12.0096 | 11200.0 |
| 2011-01-06 07:16:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 7700.0 |
| 2011-01-06 07:17:00 | AAPL | Stock | 12.0043 | 12.0043 | 12.0043 | 12.0043 | 2800.0 |
| 2011-01-06 07:19:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 25900.0 |
| 2011-01-06 07:22:00 | AAPL | Stock | 12.0089 | 12.0089 | 12.0089 | 12.0089 | 2800.0 |
| 2011-01-06 07:23:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-01-06 07:28:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-06 07:31:00 | AAPL | Stock | 12.0043 | 12.0043 | 12.0043 | 12.0043 | 2800.0 |
| 2011-01-06 07:33:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0068 | 12.0068 | 2800.0 |
| 2011-01-06 07:34:00 | AAPL | Stock | 12.0071 | 12.0071 | 12.0036 | 12.0071 | 33040.0 |
| 2011-01-06 07:36:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0068 | 12.0068 | 2800.0 |
| 2011-01-06 07:37:00 | AAPL | Stock | 12.0039 | 12.0039 | 12.0036 | 12.0036 | 28000.0 |
| 2011-01-06 07:40:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 11900.0 |
| 2011-01-06 07:41:00 | AAPL | Stock | 11.9975 | 11.9975 | 11.9975 | 11.9975 | 2800.0 |
| 2011-01-06 07:42:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-06 07:52:00 | AAPL | Stock | 11.9857 | 11.9964 | 11.985 | 11.9954 | 30800.0 |
| 2011-01-06 07:55:00 | AAPL | Stock | 11.9879 | 11.9954 | 11.9879 | 11.9954 | 8400.0 |
| 2011-01-06 07:57:00 | AAPL | Stock | 11.9893 | 11.9893 | 11.9871 | 11.9871 | 11200.0 |
| 2011-01-06 08:00:00 | AAPL | Stock | 11.9821 | 11.9957 | 11.9821 | 11.9861 | 36652.0 |
| 2011-01-06 08:01:00 | AAPL | Stock | 11.9918 | 11.9939 | 11.9918 | 11.9939 | 32340.0 |
| 2011-01-06 08:02:00 | AAPL | Stock | 11.9943 | 11.9943 | 11.9886 | 11.9939 | 19600.0 |
| 2011-01-06 08:03:00 | AAPL | Stock | 11.9939 | 12.0 | 11.9939 | 11.9946 | 40040.0 |
| 2011-01-06 08:04:00 | AAPL | Stock | 11.9996 | 12.0 | 11.9996 | 12.0 | 56000.0 |
| 2011-01-06 08:05:00 | AAPL | Stock | 12.0004 | 12.0082 | 12.0 | 12.0075 | 79380.0 |
| 2011-01-06 08:06:00 | AAPL | Stock | 12.0036 | 12.0036 | 12.0 | 12.0018 | 105000.0 |
| 2011-01-06 08:07:00 | AAPL | Stock | 12.0039 | 12.0079 | 12.0039 | 12.0079 | 11200.0 |
| 2011-01-06 08:08:00 | AAPL | Stock | 12.0075 | 12.0075 | 12.0075 | 12.0075 | 11200.0 |
| 2011-01-06 08:09:00 | AAPL | Stock | 12.0104 | 12.0125 | 12.0104 | 12.0114 | 28000.0 |
| 2011-01-06 08:10:00 | AAPL | Stock | 12.0136 | 12.0168 | 12.0136 | 12.0143 | 44800.0 |
| 2011-01-06 08:11:00 | AAPL | Stock | 12.0139 | 12.0143 | 12.0089 | 12.0089 | 32760.0 |
| 2011-01-06 08:12:00 | AAPL | Stock | 12.0071 | 12.0071 | 12.0036 | 12.0057 | 20104.0 |
> showing 50 of 994,180 rows — these rows as CSV