PREVIEW / stock_1min / 2011-02-15
file: by_date/stock_1min/2011/2011-02-15.parquet size: 13.0 MB rows: 967,739 symbols: 2,884
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-02-15 04:01:00 | AAPL | Stock | 12.855 | 12.855 | 12.855 | 12.855 | 10640.0 |
| 2011-02-15 04:02:00 | AAPL | Stock | 12.855 | 12.855 | 12.855 | 12.855 | 2800.0 |
| 2011-02-15 04:03:00 | AAPL | Stock | 12.865 | 12.865 | 12.865 | 12.865 | 2800.0 |
| 2011-02-15 04:04:00 | AAPL | Stock | 12.8846 | 12.8846 | 12.8846 | 12.8846 | 8400.0 |
| 2011-02-15 04:15:00 | AAPL | Stock | 12.8839 | 12.8839 | 12.8839 | 12.8839 | 2800.0 |
| 2011-02-15 04:19:00 | AAPL | Stock | 12.8839 | 12.8839 | 12.8839 | 12.8839 | 5600.0 |
| 2011-02-15 04:21:00 | AAPL | Stock | 12.8839 | 12.8839 | 12.8839 | 12.8839 | 5600.0 |
| 2011-02-15 05:04:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 2800.0 |
| 2011-02-15 05:11:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 2800.0 |
| 2011-02-15 05:13:00 | AAPL | Stock | 12.8839 | 12.8839 | 12.8839 | 12.8839 | 5600.0 |
| 2011-02-15 05:26:00 | AAPL | Stock | 12.8982 | 12.8982 | 12.8982 | 12.8982 | 2800.0 |
| 2011-02-15 05:29:00 | AAPL | Stock | 12.8989 | 12.8989 | 12.8989 | 12.8989 | 2800.0 |
| 2011-02-15 05:32:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 2800.0 |
| 2011-02-15 06:31:00 | AAPL | Stock | 12.8718 | 12.8718 | 12.8718 | 12.8718 | 2800.0 |
| 2011-02-15 06:36:00 | AAPL | Stock | 12.8682 | 12.8682 | 12.8682 | 12.8682 | 2800.0 |
| 2011-02-15 06:41:00 | AAPL | Stock | 12.8714 | 12.8714 | 12.8714 | 12.8714 | 2800.0 |
| 2011-02-15 06:44:00 | AAPL | Stock | 12.8889 | 12.8889 | 12.8889 | 12.8889 | 2800.0 |
| 2011-02-15 06:51:00 | AAPL | Stock | 12.8893 | 12.8893 | 12.8893 | 12.8893 | 2800.0 |
| 2011-02-15 06:54:00 | AAPL | Stock | 12.8893 | 12.8893 | 12.875 | 12.875 | 5600.0 |
| 2011-02-15 07:00:00 | AAPL | Stock | 12.875 | 12.875 | 12.875 | 12.875 | 4592.0 |
| 2011-02-15 07:01:00 | AAPL | Stock | 12.875 | 12.875 | 12.875 | 12.875 | 11200.0 |
| 2011-02-15 07:02:00 | AAPL | Stock | 12.875 | 12.875 | 12.875 | 12.875 | 14000.0 |
| 2011-02-15 07:03:00 | AAPL | Stock | 12.8643 | 12.8643 | 12.8643 | 12.8643 | 2800.0 |
| 2011-02-15 07:04:00 | AAPL | Stock | 12.8657 | 12.8657 | 12.8657 | 12.8657 | 2800.0 |
| 2011-02-15 07:13:00 | AAPL | Stock | 12.87 | 12.87 | 12.87 | 12.87 | 2800.0 |
| 2011-02-15 07:14:00 | AAPL | Stock | 12.87 | 12.87 | 12.87 | 12.87 | 11200.0 |
| 2011-02-15 07:16:00 | AAPL | Stock | 12.8654 | 12.8654 | 12.8636 | 12.8636 | 9800.0 |
| 2011-02-15 07:19:00 | AAPL | Stock | 12.8786 | 12.8789 | 12.8786 | 12.8789 | 26600.0 |
| 2011-02-15 07:32:00 | AAPL | Stock | 12.8643 | 12.8643 | 12.8636 | 12.8636 | 22400.0 |
| 2011-02-15 07:35:00 | AAPL | Stock | 12.8589 | 12.8589 | 12.8571 | 12.8571 | 25060.0 |
| 2011-02-15 07:36:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8571 | 12.8571 | 11200.0 |
| 2011-02-15 07:37:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8571 | 12.8571 | 2800.0 |
| 2011-02-15 07:39:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8571 | 12.8571 | 8400.0 |
| 2011-02-15 07:46:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8571 | 12.8571 | 51800.0 |
| 2011-02-15 07:48:00 | AAPL | Stock | 12.8575 | 12.8632 | 12.8575 | 12.8632 | 8400.0 |
| 2011-02-15 07:49:00 | AAPL | Stock | 12.8636 | 12.8643 | 12.8636 | 12.8643 | 5600.0 |
| 2011-02-15 07:54:00 | AAPL | Stock | 12.8639 | 12.8639 | 12.8639 | 12.8639 | 2800.0 |
| 2011-02-15 07:55:00 | AAPL | Stock | 12.8636 | 12.8639 | 12.8636 | 12.8639 | 5600.0 |
| 2011-02-15 07:57:00 | AAPL | Stock | 12.8639 | 12.8643 | 12.8639 | 12.8643 | 5600.0 |
| 2011-02-15 07:58:00 | AAPL | Stock | 12.8632 | 12.8643 | 12.8632 | 12.8643 | 5600.0 |
| 2011-02-15 07:59:00 | AAPL | Stock | 12.8575 | 12.8575 | 12.8571 | 12.8571 | 11424.0 |
| 2011-02-15 08:00:00 | AAPL | Stock | 12.8518 | 12.8625 | 12.8496 | 12.8607 | 205968.0 |
| 2011-02-15 08:01:00 | AAPL | Stock | 12.8575 | 12.8575 | 12.8554 | 12.8564 | 47740.0 |
| 2011-02-15 08:02:00 | AAPL | Stock | 12.85 | 12.8532 | 12.8493 | 12.8532 | 9100.0 |
| 2011-02-15 08:03:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8568 | 12.8568 | 11984.0 |
| 2011-02-15 08:04:00 | AAPL | Stock | 12.8568 | 12.8579 | 12.8536 | 12.8536 | 34160.0 |
| 2011-02-15 08:05:00 | AAPL | Stock | 12.8564 | 12.8564 | 12.8564 | 12.8564 | 3892.0 |
| 2011-02-15 08:06:00 | AAPL | Stock | 12.8564 | 12.8564 | 12.8564 | 12.8564 | 22400.0 |
| 2011-02-15 08:07:00 | AAPL | Stock | 12.8564 | 12.8564 | 12.8564 | 12.8564 | 2800.0 |
| 2011-02-15 08:08:00 | AAPL | Stock | 12.8554 | 12.8571 | 12.8554 | 12.8571 | 8400.0 |
> showing 50 of 967,739 rows — these rows as CSV