PREVIEW / stock_1min / 2011-09-20
file: by_date/stock_1min/2011/2011-09-20.parquet size: 13.1 MB rows: 977,929 symbols: 2,838
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-09-20 04:00:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6429 | 14.6429 | 2800.0 |
| 2011-09-20 04:02:00 | AAPL | Stock | 14.75 | 14.75 | 14.75 | 14.75 | 2800.0 |
| 2011-09-20 04:03:00 | AAPL | Stock | 14.7564 | 14.7736 | 14.75 | 14.7736 | 19600.0 |
| 2011-09-20 04:04:00 | AAPL | Stock | 14.7657 | 14.7736 | 14.7657 | 14.7736 | 5600.0 |
| 2011-09-20 04:09:00 | AAPL | Stock | 14.7704 | 14.7711 | 14.7704 | 14.7711 | 11200.0 |
| 2011-09-20 04:11:00 | AAPL | Stock | 14.78 | 14.78 | 14.78 | 14.78 | 2800.0 |
| 2011-09-20 04:12:00 | AAPL | Stock | 14.78 | 14.78 | 14.78 | 14.78 | 2800.0 |
| 2011-09-20 04:15:00 | AAPL | Stock | 14.7804 | 14.7804 | 14.7804 | 14.7804 | 11200.0 |
| 2011-09-20 04:18:00 | AAPL | Stock | 14.8018 | 14.8018 | 14.8018 | 14.8018 | 8400.0 |
| 2011-09-20 04:35:00 | AAPL | Stock | 14.7496 | 14.7496 | 14.7496 | 14.7496 | 2800.0 |
| 2011-09-20 05:04:00 | AAPL | Stock | 14.7796 | 14.7796 | 14.7796 | 14.7796 | 2800.0 |
| 2011-09-20 05:06:00 | AAPL | Stock | 14.7796 | 14.7796 | 14.7796 | 14.7796 | 5600.0 |
| 2011-09-20 05:29:00 | AAPL | Stock | 14.7893 | 14.7893 | 14.7893 | 14.7893 | 2800.0 |
| 2011-09-20 05:35:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 13860.0 |
| 2011-09-20 05:36:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 2800.0 |
| 2011-09-20 05:40:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 58800.0 |
| 2011-09-20 05:41:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 8400.0 |
| 2011-09-20 05:42:00 | AAPL | Stock | 14.8125 | 14.8125 | 14.8125 | 14.8125 | 5600.0 |
| 2011-09-20 05:43:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 53200.0 |
| 2011-09-20 05:48:00 | AAPL | Stock | 14.8321 | 14.8321 | 14.8321 | 14.8321 | 14000.0 |
| 2011-09-20 05:52:00 | AAPL | Stock | 14.8679 | 14.8679 | 14.8654 | 14.8654 | 5600.0 |
| 2011-09-20 05:56:00 | AAPL | Stock | 14.8661 | 14.8661 | 14.8661 | 14.8661 | 2800.0 |
| 2011-09-20 06:07:00 | AAPL | Stock | 14.8661 | 14.8661 | 14.8661 | 14.8661 | 2800.0 |
| 2011-09-20 06:08:00 | AAPL | Stock | 14.8661 | 14.8661 | 14.8661 | 14.8661 | 2800.0 |
| 2011-09-20 06:22:00 | AAPL | Stock | 14.8657 | 14.8657 | 14.8657 | 14.8657 | 8400.0 |
| 2011-09-20 06:26:00 | AAPL | Stock | 14.8629 | 14.875 | 14.8629 | 14.875 | 21000.0 |
| 2011-09-20 06:27:00 | AAPL | Stock | 14.8929 | 14.8929 | 14.8929 | 14.8929 | 2800.0 |
| 2011-09-20 06:28:00 | AAPL | Stock | 14.875 | 14.875 | 14.875 | 14.875 | 19600.0 |
| 2011-09-20 06:46:00 | AAPL | Stock | 14.8668 | 14.8675 | 14.8589 | 14.8589 | 18480.0 |
| 2011-09-20 07:00:00 | AAPL | Stock | 14.8443 | 14.8571 | 14.8443 | 14.8571 | 24192.0 |
| 2011-09-20 07:01:00 | AAPL | Stock | 14.8232 | 14.8518 | 14.8232 | 14.8286 | 14000.0 |
| 2011-09-20 07:02:00 | AAPL | Stock | 14.8339 | 14.8393 | 14.8339 | 14.8393 | 16800.0 |
| 2011-09-20 07:03:00 | AAPL | Stock | 14.8389 | 14.8586 | 14.8389 | 14.8586 | 46620.0 |
| 2011-09-20 07:04:00 | AAPL | Stock | 14.8554 | 14.8554 | 14.8532 | 14.8536 | 24220.0 |
| 2011-09-20 07:05:00 | AAPL | Stock | 14.8561 | 14.8879 | 14.8554 | 14.8593 | 33600.0 |
| 2011-09-20 07:06:00 | AAPL | Stock | 14.8586 | 14.8586 | 14.8536 | 14.8536 | 11200.0 |
| 2011-09-20 07:08:00 | AAPL | Stock | 14.8411 | 14.8411 | 14.8411 | 14.8411 | 2800.0 |
| 2011-09-20 07:09:00 | AAPL | Stock | 14.8411 | 14.8504 | 14.8411 | 14.8411 | 22400.0 |
| 2011-09-20 07:10:00 | AAPL | Stock | 14.8411 | 14.8411 | 14.8393 | 14.8393 | 5600.0 |
| 2011-09-20 07:11:00 | AAPL | Stock | 14.8393 | 14.8393 | 14.8393 | 14.8393 | 5600.0 |
| 2011-09-20 07:12:00 | AAPL | Stock | 14.8468 | 14.8468 | 14.8436 | 14.8436 | 8400.0 |
| 2011-09-20 07:14:00 | AAPL | Stock | 14.8461 | 14.8461 | 14.8446 | 14.8446 | 8400.0 |
| 2011-09-20 07:15:00 | AAPL | Stock | 14.8482 | 14.8482 | 14.8482 | 14.8482 | 16800.0 |
| 2011-09-20 07:16:00 | AAPL | Stock | 14.8446 | 14.8446 | 14.8446 | 14.8446 | 5600.0 |
| 2011-09-20 07:17:00 | AAPL | Stock | 14.8446 | 14.8475 | 14.8393 | 14.8475 | 33880.0 |
| 2011-09-20 07:18:00 | AAPL | Stock | 14.8393 | 14.8393 | 14.8371 | 14.8371 | 22400.0 |
| 2011-09-20 07:19:00 | AAPL | Stock | 14.8443 | 14.8446 | 14.8429 | 14.8446 | 27188.0 |
| 2011-09-20 07:20:00 | AAPL | Stock | 14.8446 | 14.8446 | 14.8411 | 14.8411 | 8400.0 |
| 2011-09-20 07:21:00 | AAPL | Stock | 14.8396 | 14.8411 | 14.8393 | 14.8393 | 15988.0 |
| 2011-09-20 07:22:00 | AAPL | Stock | 14.8393 | 14.8411 | 14.8393 | 14.8411 | 14588.0 |
> showing 50 of 977,929 rows — these rows as CSV