PREVIEW / stock_1min / 2013-06-06
file: by_date/stock_1min/2013/2013-06-06.parquet size: 13.5 MB rows: 992,852 symbols: 2,822
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-06 05:06:00 | AAPL | Stock | 15.9418 | 15.9418 | 15.9418 | 15.9418 | 2800.0 |
| 2013-06-06 05:39:00 | AAPL | Stock | 15.9393 | 15.9393 | 15.9393 | 15.9393 | 4200.0 |
| 2013-06-06 06:03:00 | AAPL | Stock | 15.9571 | 15.9571 | 15.9571 | 15.9571 | 2800.0 |
| 2013-06-06 06:17:00 | AAPL | Stock | 15.9568 | 15.9571 | 15.9568 | 15.9571 | 28000.0 |
| 2013-06-06 06:22:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-06-06 06:23:00 | AAPL | Stock | 15.9757 | 15.9757 | 15.9757 | 15.9757 | 2800.0 |
| 2013-06-06 07:01:00 | AAPL | Stock | 15.9836 | 15.9911 | 15.9646 | 15.9646 | 82460.0 |
| 2013-06-06 07:03:00 | AAPL | Stock | 15.9714 | 15.9714 | 15.9714 | 15.9714 | 2800.0 |
| 2013-06-06 07:04:00 | AAPL | Stock | 15.9646 | 15.9646 | 15.9643 | 15.9643 | 16800.0 |
| 2013-06-06 07:15:00 | AAPL | Stock | 15.96 | 15.96 | 15.96 | 15.96 | 2800.0 |
| 2013-06-06 07:24:00 | AAPL | Stock | 15.9568 | 15.9568 | 15.9568 | 15.9568 | 2800.0 |
| 2013-06-06 07:28:00 | AAPL | Stock | 15.9432 | 15.9432 | 15.9432 | 15.9432 | 2800.0 |
| 2013-06-06 07:31:00 | AAPL | Stock | 15.9568 | 15.9568 | 15.9568 | 15.9568 | 11200.0 |
| 2013-06-06 07:35:00 | AAPL | Stock | 15.9507 | 15.9536 | 15.9507 | 15.9536 | 15400.0 |
| 2013-06-06 07:36:00 | AAPL | Stock | 15.9536 | 15.9536 | 15.9464 | 15.9464 | 13020.0 |
| 2013-06-06 07:42:00 | AAPL | Stock | 15.9496 | 15.9518 | 15.9496 | 15.9518 | 27244.0 |
| 2013-06-06 07:43:00 | AAPL | Stock | 15.95 | 15.9643 | 15.95 | 15.9643 | 40600.0 |
| 2013-06-06 07:44:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-06-06 07:45:00 | AAPL | Stock | 15.9639 | 15.9639 | 15.9639 | 15.9639 | 2800.0 |
| 2013-06-06 07:48:00 | AAPL | Stock | 15.9632 | 15.9643 | 15.9621 | 15.9621 | 26572.0 |
| 2013-06-06 07:49:00 | AAPL | Stock | 15.9721 | 15.9889 | 15.9721 | 15.9821 | 38080.0 |
| 2013-06-06 07:50:00 | AAPL | Stock | 15.9682 | 15.9739 | 15.9664 | 15.9739 | 19600.0 |
| 2013-06-06 08:00:00 | AAPL | Stock | 15.9696 | 15.9696 | 15.93 | 15.9625 | 188356.0 |
| 2013-06-06 08:01:00 | AAPL | Stock | 15.9614 | 15.9621 | 15.9536 | 15.9621 | 16800.0 |
| 2013-06-06 08:02:00 | AAPL | Stock | 15.9536 | 15.9539 | 15.9375 | 15.9464 | 64120.0 |
| 2013-06-06 08:03:00 | AAPL | Stock | 15.9429 | 15.9429 | 15.8929 | 15.8929 | 16800.0 |
| 2013-06-06 08:04:00 | AAPL | Stock | 15.9396 | 15.95 | 15.9382 | 15.95 | 14196.0 |
| 2013-06-06 08:05:00 | AAPL | Stock | 15.9464 | 15.9586 | 15.9464 | 15.9511 | 59836.0 |
| 2013-06-06 08:06:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 13664.0 |
| 2013-06-06 08:07:00 | AAPL | Stock | 15.9529 | 15.9643 | 15.9529 | 15.9643 | 125692.0 |
| 2013-06-06 08:08:00 | AAPL | Stock | 15.9593 | 15.9643 | 15.9586 | 15.9643 | 65380.0 |
| 2013-06-06 08:10:00 | AAPL | Stock | 15.9661 | 15.9661 | 15.965 | 15.965 | 11200.0 |
| 2013-06-06 08:11:00 | AAPL | Stock | 15.9611 | 15.9611 | 15.9396 | 15.9396 | 172844.0 |
| 2013-06-06 08:12:00 | AAPL | Stock | 15.9471 | 15.9471 | 15.9471 | 15.9471 | 5600.0 |
| 2013-06-06 08:13:00 | AAPL | Stock | 15.9471 | 15.9471 | 15.9471 | 15.9471 | 15176.0 |
| 2013-06-06 08:14:00 | AAPL | Stock | 15.9471 | 15.9471 | 15.9471 | 15.9471 | 4200.0 |
| 2013-06-06 08:16:00 | AAPL | Stock | 15.9471 | 15.95 | 15.9471 | 15.95 | 50400.0 |
| 2013-06-06 08:17:00 | AAPL | Stock | 15.9568 | 15.9568 | 15.9554 | 15.9554 | 6720.0 |
| 2013-06-06 08:20:00 | AAPL | Stock | 15.9486 | 15.9486 | 15.9471 | 15.9471 | 40628.0 |
| 2013-06-06 08:21:00 | AAPL | Stock | 15.95 | 15.955 | 15.95 | 15.955 | 19600.0 |
| 2013-06-06 08:22:00 | AAPL | Stock | 15.9536 | 15.9536 | 15.9536 | 15.9536 | 2800.0 |
| 2013-06-06 08:23:00 | AAPL | Stock | 15.9504 | 15.9582 | 15.95 | 15.9582 | 42000.0 |
| 2013-06-06 08:24:00 | AAPL | Stock | 15.96 | 15.9625 | 15.96 | 15.9607 | 40040.0 |
| 2013-06-06 08:25:00 | AAPL | Stock | 15.9575 | 15.9575 | 15.9575 | 15.9575 | 2800.0 |
| 2013-06-06 08:26:00 | AAPL | Stock | 15.9636 | 15.9636 | 15.9636 | 15.9636 | 2800.0 |
| 2013-06-06 08:27:00 | AAPL | Stock | 15.9629 | 15.9629 | 15.9629 | 15.9629 | 2800.0 |
| 2013-06-06 08:29:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 73948.0 |
| 2013-06-06 08:30:00 | AAPL | Stock | 15.9579 | 15.9579 | 15.9464 | 15.9464 | 22400.0 |
| 2013-06-06 08:31:00 | AAPL | Stock | 15.9493 | 15.9493 | 15.9464 | 15.9464 | 77308.0 |
| 2013-06-06 08:32:00 | AAPL | Stock | 15.9471 | 15.9557 | 15.9379 | 15.9557 | 39200.0 |
> showing 50 of 992,852 rows — these rows as CSV