PREVIEW / stock_1min / 2010-03-11
file: by_date/stock_1min/2010/2010-03-11.parquet size: 12.5 MB rows: 947,828 symbols: 2,818
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-11 05:27:00 | AAPL | Stock | 8.0618 | 8.0618 | 8.0618 | 8.0618 | 7000.0 |
| 2010-03-11 07:13:00 | AAPL | Stock | 8.0393 | 8.0393 | 8.0393 | 8.0393 | 2800.0 |
| 2010-03-11 07:27:00 | AAPL | Stock | 8.0429 | 8.0429 | 8.0429 | 8.0429 | 2800.0 |
| 2010-03-11 07:33:00 | AAPL | Stock | 8.0329 | 8.0329 | 8.0286 | 8.0286 | 56000.0 |
| 2010-03-11 07:38:00 | AAPL | Stock | 8.0286 | 8.0286 | 8.0286 | 8.0286 | 28000.0 |
| 2010-03-11 07:53:00 | AAPL | Stock | 8.0289 | 8.0289 | 8.0289 | 8.0289 | 5600.0 |
| 2010-03-11 07:57:00 | AAPL | Stock | 8.0289 | 8.0289 | 8.025 | 8.025 | 33712.0 |
| 2010-03-11 08:00:00 | AAPL | Stock | 8.025 | 8.025 | 8.0246 | 8.025 | 10220.0 |
| 2010-03-11 08:02:00 | AAPL | Stock | 8.0196 | 8.02 | 8.0196 | 8.0196 | 28000.0 |
| 2010-03-11 08:03:00 | AAPL | Stock | 8.0196 | 8.0196 | 8.0196 | 8.0196 | 21000.0 |
| 2010-03-11 08:04:00 | AAPL | Stock | 8.0179 | 8.0179 | 8.0179 | 8.0179 | 11200.0 |
| 2010-03-11 08:05:00 | AAPL | Stock | 8.0164 | 8.0164 | 8.0164 | 8.0164 | 25200.0 |
| 2010-03-11 08:06:00 | AAPL | Stock | 8.0175 | 8.0179 | 8.0175 | 8.0179 | 16968.0 |
| 2010-03-11 08:07:00 | AAPL | Stock | 8.0164 | 8.0179 | 8.0164 | 8.0179 | 21728.0 |
| 2010-03-11 08:09:00 | AAPL | Stock | 8.0157 | 8.0261 | 8.0157 | 8.0261 | 23100.0 |
| 2010-03-11 08:10:00 | AAPL | Stock | 8.0257 | 8.0261 | 8.0214 | 8.025 | 14392.0 |
| 2010-03-11 08:11:00 | AAPL | Stock | 8.0236 | 8.0236 | 8.0236 | 8.0236 | 17948.0 |
| 2010-03-11 08:13:00 | AAPL | Stock | 8.0204 | 8.0204 | 8.0204 | 8.0204 | 6636.0 |
| 2010-03-11 08:14:00 | AAPL | Stock | 8.0204 | 8.0204 | 8.0164 | 8.0164 | 5600.0 |
| 2010-03-11 08:15:00 | AAPL | Stock | 8.0239 | 8.0239 | 8.0239 | 8.0239 | 2800.0 |
| 2010-03-11 08:16:00 | AAPL | Stock | 8.0237 | 8.0237 | 8.0237 | 8.0237 | 5600.0 |
| 2010-03-11 08:17:00 | AAPL | Stock | 8.0179 | 8.0179 | 8.0179 | 8.0179 | 7000.0 |
| 2010-03-11 08:20:00 | AAPL | Stock | 8.0214 | 8.0214 | 8.0214 | 8.0214 | 3836.0 |
| 2010-03-11 08:22:00 | AAPL | Stock | 8.0236 | 8.0243 | 8.0236 | 8.0243 | 18284.0 |
| 2010-03-11 08:23:00 | AAPL | Stock | 8.0243 | 8.0243 | 8.0202 | 8.0204 | 9800.0 |
| 2010-03-11 08:25:00 | AAPL | Stock | 8.0204 | 8.0204 | 8.0204 | 8.0204 | 3612.0 |
| 2010-03-11 08:27:00 | AAPL | Stock | 8.0207 | 8.0207 | 8.0129 | 8.0179 | 25200.0 |
| 2010-03-11 08:29:00 | AAPL | Stock | 8.0157 | 8.025 | 8.0157 | 8.02 | 46956.0 |
| 2010-03-11 08:30:00 | AAPL | Stock | 8.0196 | 8.0307 | 8.0154 | 8.0282 | 60760.0 |
| 2010-03-11 08:31:00 | AAPL | Stock | 8.0282 | 8.0282 | 8.0196 | 8.0196 | 44800.0 |
| 2010-03-11 08:32:00 | AAPL | Stock | 8.0189 | 8.0189 | 8.0107 | 8.0143 | 33460.0 |
| 2010-03-11 08:33:00 | AAPL | Stock | 8.0186 | 8.0186 | 8.0036 | 8.0143 | 46088.0 |
| 2010-03-11 08:34:00 | AAPL | Stock | 8.0107 | 8.0146 | 8.0107 | 8.0146 | 24640.0 |
| 2010-03-11 08:35:00 | AAPL | Stock | 8.0129 | 8.0136 | 8.0071 | 8.0136 | 60200.0 |
| 2010-03-11 08:36:00 | AAPL | Stock | 8.0125 | 8.0125 | 8.0068 | 8.0096 | 29792.0 |
| 2010-03-11 08:37:00 | AAPL | Stock | 8.0107 | 8.0107 | 8.0107 | 8.0107 | 6328.0 |
| 2010-03-11 08:38:00 | AAPL | Stock | 8.0132 | 8.0136 | 8.0107 | 8.0136 | 19600.0 |
| 2010-03-11 08:39:00 | AAPL | Stock | 8.0125 | 8.0136 | 8.0107 | 8.0107 | 14000.0 |
| 2010-03-11 08:40:00 | AAPL | Stock | 8.0093 | 8.0093 | 8.0036 | 8.0043 | 102200.0 |
| 2010-03-11 08:41:00 | AAPL | Stock | 8.0054 | 8.0075 | 8.0043 | 8.0043 | 42000.0 |
| 2010-03-11 08:42:00 | AAPL | Stock | 8.0039 | 8.0054 | 7.9964 | 7.9986 | 223552.0 |
| 2010-03-11 08:43:00 | AAPL | Stock | 8.0 | 8.0018 | 7.9957 | 7.9957 | 98000.0 |
| 2010-03-11 08:44:00 | AAPL | Stock | 7.9964 | 7.9964 | 7.9921 | 7.9921 | 47768.0 |
| 2010-03-11 08:45:00 | AAPL | Stock | 7.9932 | 7.995 | 7.9893 | 7.9929 | 84392.0 |
| 2010-03-11 08:46:00 | AAPL | Stock | 7.9893 | 7.9914 | 7.9889 | 7.99 | 65800.0 |
| 2010-03-11 08:47:00 | AAPL | Stock | 7.9904 | 7.9932 | 7.9893 | 7.9921 | 113400.0 |
| 2010-03-11 08:48:00 | AAPL | Stock | 7.9921 | 7.9939 | 7.9921 | 7.9939 | 8400.0 |
| 2010-03-11 08:49:00 | AAPL | Stock | 7.9929 | 7.9961 | 7.9929 | 7.9961 | 36400.0 |
| 2010-03-11 08:50:00 | AAPL | Stock | 7.9954 | 7.9964 | 7.9914 | 7.9964 | 32200.0 |
| 2010-03-11 08:51:00 | AAPL | Stock | 7.9982 | 8.0 | 7.9982 | 8.0 | 37800.0 |
> showing 50 of 947,828 rows — these rows as CSV