PREVIEW / stock_1min / 2012-02-16
file: by_date/stock_1min/2012/2012-02-16.parquet size: 13.4 MB rows: 989,304 symbols: 2,856
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-02-16 04:03:00 | AAPL | Stock | 17.6079 | 17.6079 | 17.6079 | 17.6079 | 28000.0 |
| 2012-02-16 04:11:00 | AAPL | Stock | 17.6418 | 17.6418 | 17.6418 | 17.6418 | 2800.0 |
| 2012-02-16 04:16:00 | AAPL | Stock | 17.665 | 17.665 | 17.665 | 17.665 | 5600.0 |
| 2012-02-16 04:41:00 | AAPL | Stock | 17.6961 | 17.6964 | 17.6961 | 17.6964 | 8400.0 |
| 2012-02-16 04:43:00 | AAPL | Stock | 17.6964 | 17.6964 | 17.6964 | 17.6964 | 8400.0 |
| 2012-02-16 04:45:00 | AAPL | Stock | 17.6789 | 17.6789 | 17.6789 | 17.6789 | 5600.0 |
| 2012-02-16 04:50:00 | AAPL | Stock | 17.6789 | 17.6789 | 17.6786 | 17.6786 | 8400.0 |
| 2012-02-16 04:56:00 | AAPL | Stock | 17.7071 | 17.7071 | 17.7071 | 17.7071 | 7840.0 |
| 2012-02-16 05:01:00 | AAPL | Stock | 17.6843 | 17.6843 | 17.6786 | 17.6786 | 5600.0 |
| 2012-02-16 05:05:00 | AAPL | Stock | 17.7218 | 17.7218 | 17.7218 | 17.7218 | 2800.0 |
| 2012-02-16 05:09:00 | AAPL | Stock | 17.7 | 17.7 | 17.7 | 17.7 | 3752.0 |
| 2012-02-16 05:10:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7214 | 17.7214 | 28000.0 |
| 2012-02-16 05:35:00 | AAPL | Stock | 17.7061 | 17.7061 | 17.7 | 17.7 | 8400.0 |
| 2012-02-16 05:38:00 | AAPL | Stock | 17.7054 | 17.7054 | 17.7054 | 17.7054 | 2800.0 |
| 2012-02-16 05:52:00 | AAPL | Stock | 17.7061 | 17.7061 | 17.7061 | 17.7061 | 2800.0 |
| 2012-02-16 06:07:00 | AAPL | Stock | 17.7264 | 17.7264 | 17.7171 | 17.7171 | 10920.0 |
| 2012-02-16 06:11:00 | AAPL | Stock | 17.7132 | 17.7132 | 17.7132 | 17.7132 | 2800.0 |
| 2012-02-16 06:20:00 | AAPL | Stock | 17.7314 | 17.7314 | 17.7314 | 17.7314 | 17080.0 |
| 2012-02-16 06:36:00 | AAPL | Stock | 17.7314 | 17.7314 | 17.7314 | 17.7314 | 2800.0 |
| 2012-02-16 06:39:00 | AAPL | Stock | 17.7296 | 17.7296 | 17.7286 | 17.7286 | 11200.0 |
| 2012-02-16 06:53:00 | AAPL | Stock | 17.7146 | 17.7146 | 17.7146 | 17.7146 | 2800.0 |
| 2012-02-16 07:00:00 | AAPL | Stock | 17.7121 | 17.7121 | 17.7018 | 17.7018 | 11200.0 |
| 2012-02-16 07:01:00 | AAPL | Stock | 17.6982 | 17.6982 | 17.6479 | 17.6786 | 96600.0 |
| 2012-02-16 07:02:00 | AAPL | Stock | 17.6807 | 17.6807 | 17.6807 | 17.6807 | 5600.0 |
| 2012-02-16 07:03:00 | AAPL | Stock | 17.6661 | 17.6661 | 17.6486 | 17.6486 | 8400.0 |
| 2012-02-16 07:04:00 | AAPL | Stock | 17.65 | 17.65 | 17.6361 | 17.6375 | 65576.0 |
| 2012-02-16 07:05:00 | AAPL | Stock | 17.6321 | 17.6321 | 17.6321 | 17.6321 | 14000.0 |
| 2012-02-16 07:06:00 | AAPL | Stock | 17.6196 | 17.6196 | 17.6157 | 17.6157 | 5600.0 |
| 2012-02-16 07:07:00 | AAPL | Stock | 17.625 | 17.625 | 17.625 | 17.625 | 74060.0 |
| 2012-02-16 07:08:00 | AAPL | Stock | 17.6214 | 17.6429 | 17.6214 | 17.625 | 113204.0 |
| 2012-02-16 07:09:00 | AAPL | Stock | 17.6429 | 17.6679 | 17.6429 | 17.6679 | 13888.0 |
| 2012-02-16 07:11:00 | AAPL | Stock | 17.6571 | 17.6571 | 17.6521 | 17.6521 | 5600.0 |
| 2012-02-16 07:12:00 | AAPL | Stock | 17.6521 | 17.6521 | 17.6521 | 17.6521 | 2800.0 |
| 2012-02-16 07:13:00 | AAPL | Stock | 17.6682 | 17.6682 | 17.6682 | 17.6682 | 2800.0 |
| 2012-02-16 07:14:00 | AAPL | Stock | 17.6779 | 17.6779 | 17.6779 | 17.6779 | 2800.0 |
| 2012-02-16 07:16:00 | AAPL | Stock | 17.6768 | 17.6782 | 17.6768 | 17.6782 | 14336.0 |
| 2012-02-16 07:21:00 | AAPL | Stock | 17.6696 | 17.6775 | 17.6696 | 17.6768 | 16800.0 |
| 2012-02-16 07:22:00 | AAPL | Stock | 17.6696 | 17.6696 | 17.6696 | 17.6696 | 2800.0 |
| 2012-02-16 07:23:00 | AAPL | Stock | 17.6607 | 17.6964 | 17.6607 | 17.68 | 166572.0 |
| 2012-02-16 07:24:00 | AAPL | Stock | 17.6807 | 17.6807 | 17.6786 | 17.6793 | 16660.0 |
| 2012-02-16 07:25:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6786 | 17.6786 | 2800.0 |
| 2012-02-16 07:26:00 | AAPL | Stock | 17.6643 | 17.6643 | 17.6643 | 17.6643 | 6104.0 |
| 2012-02-16 07:28:00 | AAPL | Stock | 17.6554 | 17.6554 | 17.6536 | 17.6536 | 5600.0 |
| 2012-02-16 07:29:00 | AAPL | Stock | 17.6696 | 17.6714 | 17.6696 | 17.6714 | 5600.0 |
| 2012-02-16 07:30:00 | AAPL | Stock | 17.6471 | 17.6554 | 17.6471 | 17.6536 | 8400.0 |
| 2012-02-16 07:31:00 | AAPL | Stock | 17.6536 | 17.6707 | 17.6393 | 17.6604 | 61600.0 |
| 2012-02-16 07:32:00 | AAPL | Stock | 17.6429 | 17.6446 | 17.6393 | 17.6393 | 39200.0 |
| 2012-02-16 07:33:00 | AAPL | Stock | 17.6293 | 17.6393 | 17.6286 | 17.6393 | 44744.0 |
| 2012-02-16 07:34:00 | AAPL | Stock | 17.6393 | 17.6589 | 17.6393 | 17.6393 | 50400.0 |
| 2012-02-16 07:36:00 | AAPL | Stock | 17.6446 | 17.6446 | 17.6429 | 17.6429 | 9800.0 |
> showing 50 of 989,304 rows — these rows as CSV