PREVIEW / stock_1min / 2013-09-05
file: by_date/stock_1min/2013/2013-09-05.parquet size: 13.1 MB rows: 968,604 symbols: 2,844
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-09-05 04:08:00 | AAPL | Stock | 17.9107 | 17.9107 | 17.9107 | 17.9107 | 2800.0 |
| 2013-09-05 04:11:00 | AAPL | Stock | 17.8986 | 17.8986 | 17.8929 | 17.8929 | 13356.0 |
| 2013-09-05 04:14:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 10864.0 |
| 2013-09-05 04:22:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8571 | 17.8571 | 20020.0 |
| 2013-09-05 04:23:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 5600.0 |
| 2013-09-05 04:30:00 | AAPL | Stock | 17.8757 | 17.8757 | 17.875 | 17.875 | 28000.0 |
| 2013-09-05 04:31:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 14000.0 |
| 2013-09-05 04:35:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 27832.0 |
| 2013-09-05 04:43:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 27832.0 |
| 2013-09-05 04:44:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 27832.0 |
| 2013-09-05 04:47:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-09-05 04:48:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 16100.0 |
| 2013-09-05 05:13:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-09-05 05:39:00 | AAPL | Stock | 17.8725 | 17.8725 | 17.8725 | 17.8725 | 2800.0 |
| 2013-09-05 05:47:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-09-05 05:58:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 3024.0 |
| 2013-09-05 05:59:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-09-05 06:02:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 8400.0 |
| 2013-09-05 06:12:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-09-05 06:41:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 8428.0 |
| 2013-09-05 07:00:00 | AAPL | Stock | 17.875 | 17.8929 | 17.875 | 17.875 | 31332.0 |
| 2013-09-05 07:01:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-09-05 07:03:00 | AAPL | Stock | 17.8857 | 17.8932 | 17.8857 | 17.8918 | 56420.0 |
| 2013-09-05 07:04:00 | AAPL | Stock | 17.8918 | 17.9071 | 17.8918 | 17.9071 | 5600.0 |
| 2013-09-05 07:05:00 | AAPL | Stock | 17.9054 | 17.9093 | 17.9054 | 17.9093 | 10864.0 |
| 2013-09-05 07:06:00 | AAPL | Stock | 17.9 | 17.9 | 17.9 | 17.9 | 5600.0 |
| 2013-09-05 07:07:00 | AAPL | Stock | 17.9068 | 17.9068 | 17.9068 | 17.9068 | 2800.0 |
| 2013-09-05 07:09:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 5600.0 |
| 2013-09-05 07:13:00 | AAPL | Stock | 17.8768 | 17.8768 | 17.8714 | 17.8714 | 8400.0 |
| 2013-09-05 07:16:00 | AAPL | Stock | 17.8629 | 17.8629 | 17.8607 | 17.8607 | 12712.0 |
| 2013-09-05 07:18:00 | AAPL | Stock | 17.8682 | 17.8682 | 17.8682 | 17.8682 | 2800.0 |
| 2013-09-05 07:20:00 | AAPL | Stock | 17.8786 | 17.8929 | 17.8786 | 17.8929 | 47880.0 |
| 2013-09-05 07:23:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 14000.0 |
| 2013-09-05 07:25:00 | AAPL | Stock | 17.8918 | 17.8918 | 17.8918 | 17.8918 | 2800.0 |
| 2013-09-05 07:26:00 | AAPL | Stock | 17.8857 | 17.8911 | 17.8857 | 17.8911 | 5600.0 |
| 2013-09-05 07:28:00 | AAPL | Stock | 17.8911 | 17.8911 | 17.8911 | 17.8911 | 4984.0 |
| 2013-09-05 07:31:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 16800.0 |
| 2013-09-05 07:32:00 | AAPL | Stock | 17.8996 | 17.8996 | 17.8996 | 17.8996 | 11200.0 |
| 2013-09-05 07:34:00 | AAPL | Stock | 17.8936 | 17.9018 | 17.8857 | 17.8857 | 46536.0 |
| 2013-09-05 07:35:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 9800.0 |
| 2013-09-05 07:36:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 8400.0 |
| 2013-09-05 07:37:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-09-05 07:38:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 14000.0 |
| 2013-09-05 07:40:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-09-05 07:43:00 | AAPL | Stock | 17.8936 | 17.9093 | 17.8929 | 17.9093 | 26320.0 |
| 2013-09-05 07:45:00 | AAPL | Stock | 17.9107 | 17.9129 | 17.9107 | 17.9129 | 14000.0 |
| 2013-09-05 07:46:00 | AAPL | Stock | 17.9089 | 17.9171 | 17.9089 | 17.9107 | 40880.0 |
| 2013-09-05 07:47:00 | AAPL | Stock | 17.9121 | 17.9121 | 17.8954 | 17.9036 | 54880.0 |
| 2013-09-05 07:48:00 | AAPL | Stock | 17.9104 | 17.9107 | 17.9104 | 17.9107 | 5600.0 |
| 2013-09-05 07:50:00 | AAPL | Stock | 17.9168 | 17.9204 | 17.9168 | 17.9204 | 12684.0 |
> showing 50 of 968,604 rows — these rows as CSV