PREVIEW / stock_1min / 2011-03-01
file: by_date/stock_1min/2011/2011-03-01.parquet size: 14.2 MB rows: 1,062,366 symbols: 2,864
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-03-01 04:00:00 | AAPL | Stock | 12.6793 | 12.7054 | 12.6793 | 12.7054 | 5600.0 |
| 2011-03-01 04:44:00 | AAPL | Stock | 12.7179 | 12.7179 | 12.7179 | 12.7179 | 2800.0 |
| 2011-03-01 05:06:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 5600.0 |
| 2011-03-01 05:10:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-03-01 05:11:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-03-01 05:13:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-03-01 05:14:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 5600.0 |
| 2011-03-01 05:15:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-03-01 06:17:00 | AAPL | Stock | 12.7111 | 12.7139 | 12.7111 | 12.7139 | 5600.0 |
| 2011-03-01 06:27:00 | AAPL | Stock | 12.6954 | 12.6954 | 12.6786 | 12.6786 | 41440.0 |
| 2011-03-01 06:35:00 | AAPL | Stock | 12.6782 | 12.6782 | 12.6782 | 12.6782 | 2800.0 |
| 2011-03-01 06:36:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 2800.0 |
| 2011-03-01 06:41:00 | AAPL | Stock | 12.6782 | 12.6782 | 12.6782 | 12.6782 | 2800.0 |
| 2011-03-01 06:42:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 8400.0 |
| 2011-03-01 06:43:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 2940.0 |
| 2011-03-01 06:53:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 2800.0 |
| 2011-03-01 07:01:00 | AAPL | Stock | 12.6936 | 12.6936 | 12.6936 | 12.6936 | 2800.0 |
| 2011-03-01 07:02:00 | AAPL | Stock | 12.6875 | 12.6875 | 12.6875 | 12.6875 | 7980.0 |
| 2011-03-01 07:03:00 | AAPL | Stock | 12.6796 | 12.6796 | 12.6796 | 12.6796 | 5600.0 |
| 2011-03-01 07:04:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.675 | 12.675 | 11200.0 |
| 2011-03-01 07:05:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 18032.0 |
| 2011-03-01 07:07:00 | AAPL | Stock | 12.6786 | 12.6893 | 12.6786 | 12.6786 | 11200.0 |
| 2011-03-01 07:09:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 8792.0 |
| 2011-03-01 07:10:00 | AAPL | Stock | 12.6757 | 12.6757 | 12.67 | 12.67 | 8400.0 |
| 2011-03-01 07:12:00 | AAPL | Stock | 12.6696 | 12.6696 | 12.6679 | 12.6696 | 47600.0 |
| 2011-03-01 07:14:00 | AAPL | Stock | 12.6607 | 12.6607 | 12.6607 | 12.6607 | 16800.0 |
| 2011-03-01 07:16:00 | AAPL | Stock | 12.6511 | 12.6511 | 12.6482 | 12.6482 | 16800.0 |
| 2011-03-01 07:19:00 | AAPL | Stock | 12.6482 | 12.6482 | 12.6482 | 12.6482 | 11200.0 |
| 2011-03-01 07:24:00 | AAPL | Stock | 12.6607 | 12.6607 | 12.6504 | 12.6504 | 11200.0 |
| 2011-03-01 07:25:00 | AAPL | Stock | 12.6496 | 12.6504 | 12.6418 | 12.6418 | 56000.0 |
| 2011-03-01 07:26:00 | AAPL | Stock | 12.6393 | 12.6393 | 12.6357 | 12.6375 | 12740.0 |
| 2011-03-01 07:27:00 | AAPL | Stock | 12.6379 | 12.6379 | 12.6304 | 12.6304 | 11200.0 |
| 2011-03-01 07:29:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 2828.0 |
| 2011-03-01 07:32:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 3192.0 |
| 2011-03-01 07:34:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 11200.0 |
| 2011-03-01 07:35:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 2800.0 |
| 2011-03-01 07:36:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 14000.0 |
| 2011-03-01 07:37:00 | AAPL | Stock | 12.6371 | 12.6371 | 12.6371 | 12.6371 | 2800.0 |
| 2011-03-01 07:38:00 | AAPL | Stock | 12.6371 | 12.6375 | 12.6371 | 12.6375 | 30800.0 |
| 2011-03-01 07:40:00 | AAPL | Stock | 12.6329 | 12.6329 | 12.6314 | 12.6314 | 5600.0 |
| 2011-03-01 07:41:00 | AAPL | Stock | 12.6261 | 12.6261 | 12.6254 | 12.6254 | 25200.0 |
| 2011-03-01 07:44:00 | AAPL | Stock | 12.6314 | 12.6318 | 12.6314 | 12.6318 | 5600.0 |
| 2011-03-01 07:46:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 14392.0 |
| 2011-03-01 07:47:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 25200.0 |
| 2011-03-01 07:54:00 | AAPL | Stock | 12.6593 | 12.6593 | 12.6593 | 12.6593 | 2800.0 |
| 2011-03-01 07:55:00 | AAPL | Stock | 12.6593 | 12.6593 | 12.6593 | 12.6593 | 8400.0 |
| 2011-03-01 07:56:00 | AAPL | Stock | 12.6593 | 12.6593 | 12.6593 | 12.6593 | 14000.0 |
| 2011-03-01 07:57:00 | AAPL | Stock | 12.6536 | 12.6536 | 12.6536 | 12.6536 | 2800.0 |
| 2011-03-01 07:59:00 | AAPL | Stock | 12.6536 | 12.6536 | 12.6536 | 12.6536 | 10080.0 |
| 2011-03-01 08:00:00 | AAPL | Stock | 12.6536 | 12.6964 | 12.6532 | 12.6536 | 168308.0 |
> showing 50 of 1,062,366 rows — these rows as CSV