PREVIEW / stock_1min / 2011-07-22
file: by_date/stock_1min/2011/2011-07-22.parquet size: 12.2 MB rows: 917,958 symbols: 2,854
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-07-22 04:14:00 | AAPL | Stock | 13.9032 | 13.9032 | 13.9029 | 13.9029 | 8400.0 |
| 2011-07-22 04:42:00 | AAPL | Stock | 13.9071 | 13.9071 | 13.9071 | 13.9071 | 2800.0 |
| 2011-07-22 04:43:00 | AAPL | Stock | 13.9071 | 13.9071 | 13.9071 | 13.9071 | 11200.0 |
| 2011-07-22 04:48:00 | AAPL | Stock | 13.9104 | 13.9104 | 13.9104 | 13.9104 | 5600.0 |
| 2011-07-22 04:52:00 | AAPL | Stock | 13.9129 | 13.9129 | 13.9129 | 13.9129 | 2800.0 |
| 2011-07-22 06:32:00 | AAPL | Stock | 13.9218 | 13.9218 | 13.9118 | 13.9118 | 8400.0 |
| 2011-07-22 06:41:00 | AAPL | Stock | 13.9036 | 13.9036 | 13.9036 | 13.9036 | 2800.0 |
| 2011-07-22 06:59:00 | AAPL | Stock | 13.9036 | 13.9036 | 13.9018 | 13.9018 | 8400.0 |
| 2011-07-22 07:00:00 | AAPL | Stock | 13.9204 | 13.9204 | 13.9204 | 13.9204 | 2800.0 |
| 2011-07-22 07:01:00 | AAPL | Stock | 13.9236 | 13.9239 | 13.9236 | 13.9239 | 5600.0 |
| 2011-07-22 07:03:00 | AAPL | Stock | 13.9214 | 13.9214 | 13.9214 | 13.9214 | 2800.0 |
| 2011-07-22 07:04:00 | AAPL | Stock | 13.9214 | 13.925 | 13.9214 | 13.925 | 33600.0 |
| 2011-07-22 07:05:00 | AAPL | Stock | 13.92 | 13.92 | 13.9179 | 13.9179 | 8400.0 |
| 2011-07-22 07:06:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.8961 | 13.8961 | 26880.0 |
| 2011-07-22 07:15:00 | AAPL | Stock | 13.9111 | 13.9111 | 13.9111 | 13.9111 | 2800.0 |
| 2011-07-22 07:17:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9107 | 13.9107 | 5600.0 |
| 2011-07-22 07:18:00 | AAPL | Stock | 13.9111 | 13.915 | 13.9111 | 13.915 | 7000.0 |
| 2011-07-22 07:20:00 | AAPL | Stock | 13.9196 | 13.9196 | 13.9196 | 13.9196 | 28000.0 |
| 2011-07-22 07:28:00 | AAPL | Stock | 13.9086 | 13.9086 | 13.9082 | 13.9082 | 5600.0 |
| 2011-07-22 07:32:00 | AAPL | Stock | 13.9229 | 13.925 | 13.9229 | 13.925 | 40600.0 |
| 2011-07-22 07:33:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9107 | 13.9107 | 2800.0 |
| 2011-07-22 07:34:00 | AAPL | Stock | 13.9104 | 13.9104 | 13.8986 | 13.8986 | 9800.0 |
| 2011-07-22 07:35:00 | AAPL | Stock | 13.9086 | 13.9086 | 13.9086 | 13.9086 | 14000.0 |
| 2011-07-22 07:38:00 | AAPL | Stock | 13.895 | 13.9025 | 13.895 | 13.9025 | 8400.0 |
| 2011-07-22 07:40:00 | AAPL | Stock | 13.8893 | 13.8893 | 13.8893 | 13.8893 | 2800.0 |
| 2011-07-22 07:41:00 | AAPL | Stock | 13.8879 | 13.8879 | 13.8879 | 13.8879 | 2800.0 |
| 2011-07-22 07:42:00 | AAPL | Stock | 13.8879 | 13.8879 | 13.8786 | 13.8786 | 15568.0 |
| 2011-07-22 07:43:00 | AAPL | Stock | 13.8821 | 13.8821 | 13.8821 | 13.8821 | 5600.0 |
| 2011-07-22 07:44:00 | AAPL | Stock | 13.8832 | 13.8832 | 13.8821 | 13.8821 | 22400.0 |
| 2011-07-22 07:45:00 | AAPL | Stock | 13.8821 | 13.8821 | 13.8821 | 13.8821 | 14000.0 |
| 2011-07-22 07:46:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 5320.0 |
| 2011-07-22 07:47:00 | AAPL | Stock | 13.8786 | 13.8836 | 13.8718 | 13.8836 | 51968.0 |
| 2011-07-22 07:48:00 | AAPL | Stock | 13.875 | 13.875 | 13.8586 | 13.8586 | 50400.0 |
| 2011-07-22 07:49:00 | AAPL | Stock | 13.8646 | 13.8646 | 13.8643 | 13.8643 | 8400.0 |
| 2011-07-22 07:51:00 | AAPL | Stock | 13.8814 | 13.8814 | 13.8814 | 13.8814 | 2800.0 |
| 2011-07-22 07:52:00 | AAPL | Stock | 13.8686 | 13.8686 | 13.8682 | 13.8682 | 14000.0 |
| 2011-07-22 07:56:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 2800.0 |
| 2011-07-22 07:58:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 2800.0 |
| 2011-07-22 08:00:00 | AAPL | Stock | 13.8746 | 13.9236 | 13.8643 | 13.8643 | 159040.0 |
| 2011-07-22 08:01:00 | AAPL | Stock | 13.8582 | 13.8589 | 13.8571 | 13.8571 | 44800.0 |
| 2011-07-22 08:02:00 | AAPL | Stock | 13.85 | 13.865 | 13.8432 | 13.865 | 11200.0 |
| 2011-07-22 08:03:00 | AAPL | Stock | 13.8554 | 13.8571 | 13.8554 | 13.8571 | 5600.0 |
| 2011-07-22 08:04:00 | AAPL | Stock | 13.8589 | 13.8625 | 13.8589 | 13.8621 | 50260.0 |
| 2011-07-22 08:05:00 | AAPL | Stock | 13.8621 | 13.8621 | 13.8621 | 13.8621 | 11200.0 |
| 2011-07-22 08:06:00 | AAPL | Stock | 13.8543 | 13.8543 | 13.8543 | 13.8543 | 2800.0 |
| 2011-07-22 08:07:00 | AAPL | Stock | 13.8607 | 13.8607 | 13.8607 | 13.8607 | 28000.0 |
| 2011-07-22 08:08:00 | AAPL | Stock | 13.8632 | 13.8632 | 13.8632 | 13.8632 | 2800.0 |
| 2011-07-22 08:09:00 | AAPL | Stock | 13.8643 | 13.8714 | 13.8643 | 13.8714 | 16800.0 |
| 2011-07-22 08:10:00 | AAPL | Stock | 13.8664 | 13.8743 | 13.8664 | 13.8743 | 5600.0 |
| 2011-07-22 08:11:00 | AAPL | Stock | 13.875 | 13.8889 | 13.8318 | 13.8318 | 58968.0 |
> showing 50 of 917,958 rows — these rows as CSV