PREVIEW / stock_1min / 2011-04-15
file: by_date/stock_1min/2011/2011-04-15.parquet size: 12.7 MB rows: 953,168 symbols: 2,859
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-04-15 04:40:00 | AAPL | Stock | 11.8736 | 11.8736 | 11.8736 | 11.8736 | 2800.0 |
| 2011-04-15 05:29:00 | AAPL | Stock | 11.8993 | 11.8993 | 11.8993 | 11.8993 | 2800.0 |
| 2011-04-15 05:35:00 | AAPL | Stock | 11.8929 | 11.8929 | 11.8929 | 11.8929 | 2800.0 |
| 2011-04-15 05:42:00 | AAPL | Stock | 11.8868 | 11.8868 | 11.8868 | 11.8868 | 2800.0 |
| 2011-04-15 05:47:00 | AAPL | Stock | 11.8736 | 11.8736 | 11.8736 | 11.8736 | 24780.0 |
| 2011-04-15 05:48:00 | AAPL | Stock | 11.8721 | 11.8721 | 11.8721 | 11.8721 | 2800.0 |
| 2011-04-15 05:52:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 14000.0 |
| 2011-04-15 06:04:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 2800.0 |
| 2011-04-15 06:30:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 2800.0 |
| 2011-04-15 06:31:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 2800.0 |
| 2011-04-15 06:55:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 2800.0 |
| 2011-04-15 07:01:00 | AAPL | Stock | 11.8468 | 11.8571 | 11.8464 | 11.8571 | 19600.0 |
| 2011-04-15 07:09:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8536 | 11.8536 | 2800.0 |
| 2011-04-15 07:15:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 8400.0 |
| 2011-04-15 07:17:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 14000.0 |
| 2011-04-15 07:18:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 16800.0 |
| 2011-04-15 07:24:00 | AAPL | Stock | 11.8711 | 11.8711 | 11.8711 | 11.8711 | 2800.0 |
| 2011-04-15 07:35:00 | AAPL | Stock | 11.8707 | 11.8707 | 11.8707 | 11.8707 | 2800.0 |
| 2011-04-15 07:39:00 | AAPL | Stock | 11.8629 | 11.8629 | 11.8607 | 11.8607 | 11200.0 |
| 2011-04-15 07:40:00 | AAPL | Stock | 11.8607 | 11.8607 | 11.8607 | 11.8607 | 19852.0 |
| 2011-04-15 07:44:00 | AAPL | Stock | 11.8607 | 11.8607 | 11.8607 | 11.8607 | 2800.0 |
| 2011-04-15 07:51:00 | AAPL | Stock | 11.8704 | 11.8704 | 11.8704 | 11.8704 | 2800.0 |
| 2011-04-15 07:55:00 | AAPL | Stock | 11.8704 | 11.8711 | 11.8704 | 11.8711 | 5600.0 |
| 2011-04-15 07:56:00 | AAPL | Stock | 11.8711 | 11.8711 | 11.8704 | 11.8704 | 8400.0 |
| 2011-04-15 08:00:00 | AAPL | Stock | 11.8611 | 11.8611 | 11.8611 | 11.8611 | 2800.0 |
| 2011-04-15 08:01:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 8400.0 |
| 2011-04-15 08:02:00 | AAPL | Stock | 11.8593 | 11.8593 | 11.8514 | 11.8514 | 30800.0 |
| 2011-04-15 08:03:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-04-15 08:05:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8536 | 11.8536 | 2800.0 |
| 2011-04-15 08:06:00 | AAPL | Stock | 11.8414 | 11.845 | 11.8339 | 11.8339 | 19600.0 |
| 2011-04-15 08:08:00 | AAPL | Stock | 11.8357 | 11.8357 | 11.835 | 11.835 | 8400.0 |
| 2011-04-15 08:09:00 | AAPL | Stock | 11.8357 | 11.8357 | 11.8321 | 11.8321 | 13860.0 |
| 2011-04-15 08:10:00 | AAPL | Stock | 11.8364 | 11.8364 | 11.8364 | 11.8364 | 2800.0 |
| 2011-04-15 08:11:00 | AAPL | Stock | 11.8479 | 11.8479 | 11.8479 | 11.8479 | 2800.0 |
| 2011-04-15 08:13:00 | AAPL | Stock | 11.8396 | 11.8396 | 11.8293 | 11.8293 | 81200.0 |
| 2011-04-15 08:14:00 | AAPL | Stock | 11.8346 | 11.8346 | 11.8346 | 11.8346 | 2800.0 |
| 2011-04-15 08:15:00 | AAPL | Stock | 11.8257 | 11.8257 | 11.8257 | 11.8257 | 2800.0 |
| 2011-04-15 08:16:00 | AAPL | Stock | 11.8254 | 11.8254 | 11.8254 | 11.8254 | 19320.0 |
| 2011-04-15 08:17:00 | AAPL | Stock | 11.8257 | 11.8282 | 11.8214 | 11.8254 | 76048.0 |
| 2011-04-15 08:18:00 | AAPL | Stock | 11.8286 | 11.8321 | 11.8286 | 11.8321 | 44884.0 |
| 2011-04-15 08:19:00 | AAPL | Stock | 11.8375 | 11.8393 | 11.8375 | 11.8393 | 37212.0 |
| 2011-04-15 08:20:00 | AAPL | Stock | 11.8411 | 11.8429 | 11.8404 | 11.8429 | 11200.0 |
| 2011-04-15 08:21:00 | AAPL | Stock | 11.8379 | 11.8379 | 11.8286 | 11.8286 | 22680.0 |
| 2011-04-15 08:26:00 | AAPL | Stock | 11.8304 | 11.8304 | 11.8286 | 11.8286 | 5600.0 |
| 2011-04-15 08:27:00 | AAPL | Stock | 11.8232 | 11.825 | 11.8214 | 11.8214 | 47600.0 |
| 2011-04-15 08:29:00 | AAPL | Stock | 11.8196 | 11.8196 | 11.8179 | 11.8179 | 14000.0 |
| 2011-04-15 08:30:00 | AAPL | Stock | 11.8189 | 11.8393 | 11.8189 | 11.8393 | 52080.0 |
| 2011-04-15 08:31:00 | AAPL | Stock | 11.8393 | 11.8464 | 11.8393 | 11.8464 | 19600.0 |
| 2011-04-15 08:32:00 | AAPL | Stock | 11.8436 | 11.8436 | 11.8357 | 11.8357 | 16800.0 |
| 2011-04-15 08:33:00 | AAPL | Stock | 11.8357 | 11.8393 | 11.8357 | 11.8393 | 25200.0 |
> showing 50 of 953,168 rows — these rows as CSV