PREVIEW / stock_1min / 2013-12-16
file: by_date/stock_1min/2013/2013-12-16.parquet size: 14.7 MB rows: 1,073,773 symbols: 2,875
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-12-16 04:00:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 5600.0 |
| 2013-12-16 04:06:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 10640.0 |
| 2013-12-16 04:07:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 8400.0 |
| 2013-12-16 04:08:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 5600.0 |
| 2013-12-16 04:14:00 | AAPL | Stock | 19.7875 | 19.7875 | 19.7875 | 19.7875 | 5600.0 |
| 2013-12-16 04:20:00 | AAPL | Stock | 19.7918 | 19.7932 | 19.7918 | 19.7932 | 5600.0 |
| 2013-12-16 04:23:00 | AAPL | Stock | 19.8107 | 19.8107 | 19.8107 | 19.8107 | 2800.0 |
| 2013-12-16 04:35:00 | AAPL | Stock | 19.8125 | 19.8125 | 19.8125 | 19.8125 | 2800.0 |
| 2013-12-16 05:02:00 | AAPL | Stock | 19.8511 | 19.8511 | 19.8511 | 19.8511 | 2800.0 |
| 2013-12-16 05:03:00 | AAPL | Stock | 19.84 | 19.84 | 19.84 | 19.84 | 2800.0 |
| 2013-12-16 05:09:00 | AAPL | Stock | 19.8396 | 19.8396 | 19.8396 | 19.8396 | 2800.0 |
| 2013-12-16 05:10:00 | AAPL | Stock | 19.8479 | 19.8479 | 19.8479 | 19.8479 | 2800.0 |
| 2013-12-16 05:11:00 | AAPL | Stock | 19.8479 | 19.8479 | 19.8479 | 19.8479 | 5600.0 |
| 2013-12-16 05:22:00 | AAPL | Stock | 19.8732 | 19.875 | 19.8732 | 19.875 | 25200.0 |
| 2013-12-16 05:24:00 | AAPL | Stock | 19.8764 | 19.8764 | 19.875 | 19.875 | 33600.0 |
| 2013-12-16 05:26:00 | AAPL | Stock | 19.875 | 19.875 | 19.875 | 19.875 | 2800.0 |
| 2013-12-16 05:28:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 9800.0 |
| 2013-12-16 05:34:00 | AAPL | Stock | 19.8771 | 19.8771 | 19.8771 | 19.8771 | 4200.0 |
| 2013-12-16 05:51:00 | AAPL | Stock | 19.8786 | 19.8786 | 19.8761 | 19.8761 | 15624.0 |
| 2013-12-16 06:02:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8929 | 19.8929 | 2800.0 |
| 2013-12-16 06:03:00 | AAPL | Stock | 19.8964 | 19.8964 | 19.8964 | 19.8964 | 2800.0 |
| 2013-12-16 06:07:00 | AAPL | Stock | 19.8839 | 19.8839 | 19.8789 | 19.8789 | 9632.0 |
| 2013-12-16 06:13:00 | AAPL | Stock | 19.8768 | 19.8768 | 19.8768 | 19.8768 | 25200.0 |
| 2013-12-16 06:14:00 | AAPL | Stock | 19.8671 | 19.8671 | 19.8482 | 19.8482 | 53200.0 |
| 2013-12-16 06:16:00 | AAPL | Stock | 19.8561 | 19.8561 | 19.8561 | 19.8561 | 2800.0 |
| 2013-12-16 06:26:00 | AAPL | Stock | 19.875 | 19.875 | 19.875 | 19.875 | 2800.0 |
| 2013-12-16 06:28:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5600.0 |
| 2013-12-16 06:32:00 | AAPL | Stock | 19.8739 | 19.8739 | 19.8739 | 19.8739 | 4200.0 |
| 2013-12-16 06:34:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8521 | 19.8521 | 16800.0 |
| 2013-12-16 06:58:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8661 | 19.8661 | 14000.0 |
| 2013-12-16 07:00:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8661 | 19.8661 | 5600.0 |
| 2013-12-16 07:02:00 | AAPL | Stock | 19.8621 | 19.8661 | 19.8571 | 19.8661 | 25732.0 |
| 2013-12-16 07:04:00 | AAPL | Stock | 19.8643 | 19.8643 | 19.8643 | 19.8643 | 2800.0 |
| 2013-12-16 07:05:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8661 | 19.8661 | 2800.0 |
| 2013-12-16 07:06:00 | AAPL | Stock | 19.8664 | 19.8664 | 19.8664 | 19.8664 | 2800.0 |
| 2013-12-16 07:08:00 | AAPL | Stock | 19.8679 | 19.8679 | 19.8679 | 19.8679 | 5068.0 |
| 2013-12-16 07:10:00 | AAPL | Stock | 19.8782 | 19.8782 | 19.8782 | 19.8782 | 26740.0 |
| 2013-12-16 07:12:00 | AAPL | Stock | 19.8664 | 19.8664 | 19.8664 | 19.8664 | 5600.0 |
| 2013-12-16 07:16:00 | AAPL | Stock | 19.8714 | 19.8714 | 19.8714 | 19.8714 | 14000.0 |
| 2013-12-16 07:22:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8661 | 19.8661 | 4480.0 |
| 2013-12-16 07:29:00 | AAPL | Stock | 19.8668 | 19.8668 | 19.8661 | 19.8664 | 16800.0 |
| 2013-12-16 07:30:00 | AAPL | Stock | 19.8668 | 19.875 | 19.8664 | 19.8668 | 16800.0 |
| 2013-12-16 07:32:00 | AAPL | Stock | 19.8679 | 19.8679 | 19.8679 | 19.8679 | 28000.0 |
| 2013-12-16 07:33:00 | AAPL | Stock | 19.8714 | 19.8714 | 19.8714 | 19.8714 | 2800.0 |
| 2013-12-16 07:36:00 | AAPL | Stock | 19.8729 | 19.8857 | 19.8729 | 19.8857 | 31836.0 |
| 2013-12-16 07:38:00 | AAPL | Stock | 19.8857 | 19.8921 | 19.8857 | 19.8921 | 42000.0 |
| 2013-12-16 07:39:00 | AAPL | Stock | 19.8921 | 19.9 | 19.8921 | 19.9 | 22400.0 |
| 2013-12-16 07:40:00 | AAPL | Stock | 19.9 | 19.9086 | 19.9 | 19.9061 | 31472.0 |
| 2013-12-16 07:43:00 | AAPL | Stock | 19.9089 | 19.9089 | 19.9089 | 19.9089 | 2800.0 |
| 2013-12-16 07:46:00 | AAPL | Stock | 19.9086 | 19.9104 | 19.895 | 19.895 | 33600.0 |
> showing 50 of 1,073,773 rows — these rows as CSV