PREVIEW / stock_1min / 2012-04-26
file: by_date/stock_1min/2012/2012-04-26.parquet size: 12.9 MB rows: 954,385 symbols: 2,858
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-26 04:00:00 | AAPL | Stock | 21.8932 | 21.8932 | 21.8932 | 21.8932 | 11200.0 |
| 2012-04-26 04:02:00 | AAPL | Stock | 21.8893 | 21.8893 | 21.8893 | 21.8893 | 5600.0 |
| 2012-04-26 04:03:00 | AAPL | Stock | 21.8857 | 21.8857 | 21.8857 | 21.8857 | 8400.0 |
| 2012-04-26 04:04:00 | AAPL | Stock | 21.8893 | 21.8893 | 21.8893 | 21.8893 | 11816.0 |
| 2012-04-26 04:06:00 | AAPL | Stock | 21.8929 | 21.8929 | 21.8929 | 21.8929 | 2800.0 |
| 2012-04-26 04:09:00 | AAPL | Stock | 21.9 | 21.9 | 21.8929 | 21.8929 | 14000.0 |
| 2012-04-26 04:18:00 | AAPL | Stock | 21.9 | 21.9 | 21.9 | 21.9 | 2800.0 |
| 2012-04-26 04:19:00 | AAPL | Stock | 21.9282 | 21.9282 | 21.9282 | 21.9282 | 2800.0 |
| 2012-04-26 04:20:00 | AAPL | Stock | 21.9282 | 21.9282 | 21.9282 | 21.9282 | 2800.0 |
| 2012-04-26 04:21:00 | AAPL | Stock | 21.9389 | 21.9389 | 21.9389 | 21.9389 | 2800.0 |
| 2012-04-26 04:22:00 | AAPL | Stock | 21.9389 | 21.9532 | 21.9389 | 21.9532 | 5600.0 |
| 2012-04-26 04:23:00 | AAPL | Stock | 21.9464 | 21.9554 | 21.9464 | 21.9554 | 9828.0 |
| 2012-04-26 04:52:00 | AAPL | Stock | 21.8664 | 21.8857 | 21.8661 | 21.8857 | 11200.0 |
| 2012-04-26 04:53:00 | AAPL | Stock | 21.8857 | 21.8857 | 21.8857 | 21.8857 | 5600.0 |
| 2012-04-26 04:54:00 | AAPL | Stock | 21.8593 | 21.8593 | 21.8593 | 21.8593 | 2800.0 |
| 2012-04-26 04:56:00 | AAPL | Stock | 21.8629 | 21.8629 | 21.8629 | 21.8629 | 2800.0 |
| 2012-04-26 04:57:00 | AAPL | Stock | 21.8629 | 21.8629 | 21.8629 | 21.8629 | 2800.0 |
| 2012-04-26 05:02:00 | AAPL | Stock | 21.8661 | 21.8661 | 21.8661 | 21.8661 | 2800.0 |
| 2012-04-26 05:03:00 | AAPL | Stock | 21.8661 | 21.8661 | 21.8661 | 21.8661 | 2800.0 |
| 2012-04-26 05:04:00 | AAPL | Stock | 21.8629 | 21.8629 | 21.8629 | 21.8629 | 2800.0 |
| 2012-04-26 05:05:00 | AAPL | Stock | 21.8646 | 21.8646 | 21.8646 | 21.8646 | 2800.0 |
| 2012-04-26 05:14:00 | AAPL | Stock | 21.8982 | 21.8982 | 21.8982 | 21.8982 | 4200.0 |
| 2012-04-26 05:17:00 | AAPL | Stock | 21.8982 | 21.8982 | 21.8982 | 21.8982 | 2800.0 |
| 2012-04-26 05:18:00 | AAPL | Stock | 21.8982 | 21.8982 | 21.8982 | 21.8982 | 2800.0 |
| 2012-04-26 05:32:00 | AAPL | Stock | 21.8675 | 21.8675 | 21.8675 | 21.8675 | 2800.0 |
| 2012-04-26 05:33:00 | AAPL | Stock | 21.8593 | 21.8593 | 21.85 | 21.85 | 12600.0 |
| 2012-04-26 05:34:00 | AAPL | Stock | 21.8486 | 21.8486 | 21.8393 | 21.8393 | 12600.0 |
| 2012-04-26 05:35:00 | AAPL | Stock | 21.8393 | 21.8571 | 21.8393 | 21.8571 | 19600.0 |
| 2012-04-26 05:39:00 | AAPL | Stock | 21.8429 | 21.8429 | 21.8429 | 21.8429 | 11200.0 |
| 2012-04-26 05:52:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8571 | 21.8571 | 22400.0 |
| 2012-04-26 05:54:00 | AAPL | Stock | 21.8557 | 21.8571 | 21.8557 | 21.8571 | 8400.0 |
| 2012-04-26 05:55:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8571 | 21.8571 | 5600.0 |
| 2012-04-26 06:01:00 | AAPL | Stock | 21.8411 | 21.8411 | 21.8411 | 21.8411 | 2800.0 |
| 2012-04-26 06:02:00 | AAPL | Stock | 21.8411 | 21.8411 | 21.8411 | 21.8411 | 2800.0 |
| 2012-04-26 06:03:00 | AAPL | Stock | 21.835 | 21.835 | 21.835 | 21.835 | 7000.0 |
| 2012-04-26 06:12:00 | AAPL | Stock | 21.85 | 21.8568 | 21.85 | 21.8568 | 5600.0 |
| 2012-04-26 06:32:00 | AAPL | Stock | 21.8257 | 21.8257 | 21.8236 | 21.8236 | 9800.0 |
| 2012-04-26 06:47:00 | AAPL | Stock | 21.8079 | 21.8079 | 21.8079 | 21.8079 | 6216.0 |
| 2012-04-26 06:48:00 | AAPL | Stock | 21.8082 | 21.8082 | 21.8014 | 21.8014 | 8400.0 |
| 2012-04-26 06:51:00 | AAPL | Stock | 21.795 | 21.795 | 21.7857 | 21.7857 | 15596.0 |
| 2012-04-26 06:54:00 | AAPL | Stock | 21.8054 | 21.8054 | 21.8054 | 21.8054 | 2800.0 |
| 2012-04-26 07:00:00 | AAPL | Stock | 21.8071 | 21.8071 | 21.7986 | 21.7986 | 16800.0 |
| 2012-04-26 07:02:00 | AAPL | Stock | 21.7946 | 21.7946 | 21.7857 | 21.7857 | 6888.0 |
| 2012-04-26 07:13:00 | AAPL | Stock | 21.8161 | 21.8161 | 21.8161 | 21.8161 | 4480.0 |
| 2012-04-26 07:15:00 | AAPL | Stock | 21.8143 | 21.8143 | 21.8143 | 21.8143 | 5936.0 |
| 2012-04-26 07:18:00 | AAPL | Stock | 21.8196 | 21.8214 | 21.8196 | 21.8214 | 40488.0 |
| 2012-04-26 07:21:00 | AAPL | Stock | 21.8461 | 21.8461 | 21.8457 | 21.8457 | 42000.0 |
| 2012-04-26 07:22:00 | AAPL | Stock | 21.8389 | 21.8389 | 21.8389 | 21.8389 | 5600.0 |
| 2012-04-26 07:25:00 | AAPL | Stock | 21.8375 | 21.8375 | 21.8375 | 21.8375 | 5600.0 |
| 2012-04-26 07:26:00 | AAPL | Stock | 21.8371 | 21.8371 | 21.8339 | 21.8339 | 5600.0 |
> showing 50 of 954,385 rows — these rows as CSV