PREVIEW / stock_1min / 2012-02-07
file: by_date/stock_1min/2012/2012-02-07.parquet size: 13.0 MB rows: 954,419 symbols: 2,862
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-07 04:15:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 8400.0 |
| 2012-02-07 04:17:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 5600.0 |
| 2012-02-07 04:20:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 2800.0 |
| 2012-02-07 04:23:00 | AAPL | Stock | 16.6068 | 16.6068 | 16.6068 | 16.6068 | 2800.0 |
| 2012-02-07 04:29:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 5600.0 |
| 2012-02-07 04:45:00 | AAPL | Stock | 16.6068 | 16.6068 | 16.6068 | 16.6068 | 5600.0 |
| 2012-02-07 04:46:00 | AAPL | Stock | 16.6068 | 16.6068 | 16.6068 | 16.6068 | 5600.0 |
| 2012-02-07 04:48:00 | AAPL | Stock | 16.6068 | 16.6068 | 16.6068 | 16.6068 | 2800.0 |
| 2012-02-07 04:49:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 5600.0 |
| 2012-02-07 05:54:00 | AAPL | Stock | 16.62 | 16.62 | 16.62 | 16.62 | 2800.0 |
| 2012-02-07 06:00:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 4956.0 |
| 2012-02-07 06:12:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 13356.0 |
| 2012-02-07 06:26:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 11200.0 |
| 2012-02-07 06:45:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 5600.0 |
| 2012-02-07 06:48:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 19600.0 |
| 2012-02-07 06:51:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 8400.0 |
| 2012-02-07 07:01:00 | AAPL | Stock | 16.5907 | 16.5907 | 16.5907 | 16.5907 | 13776.0 |
| 2012-02-07 07:04:00 | AAPL | Stock | 16.575 | 16.575 | 16.5718 | 16.575 | 16800.0 |
| 2012-02-07 07:11:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 2800.0 |
| 2012-02-07 07:13:00 | AAPL | Stock | 16.5632 | 16.5632 | 16.5632 | 16.5632 | 11900.0 |
| 2012-02-07 07:19:00 | AAPL | Stock | 16.5625 | 16.5625 | 16.5589 | 16.5589 | 5600.0 |
| 2012-02-07 07:24:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5679 | 16.5679 | 3612.0 |
| 2012-02-07 07:32:00 | AAPL | Stock | 16.5618 | 16.5618 | 16.5607 | 16.5607 | 9072.0 |
| 2012-02-07 07:33:00 | AAPL | Stock | 16.5607 | 16.5607 | 16.5607 | 16.5607 | 5600.0 |
| 2012-02-07 07:34:00 | AAPL | Stock | 16.5607 | 16.5607 | 16.5607 | 16.5607 | 4200.0 |
| 2012-02-07 07:37:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 2800.0 |
| 2012-02-07 07:38:00 | AAPL | Stock | 16.5879 | 16.5879 | 16.5861 | 16.5861 | 10780.0 |
| 2012-02-07 07:44:00 | AAPL | Stock | 16.5886 | 16.5886 | 16.5864 | 16.5864 | 29512.0 |
| 2012-02-07 07:49:00 | AAPL | Stock | 16.5957 | 16.5961 | 16.5943 | 16.5961 | 14000.0 |
| 2012-02-07 07:54:00 | AAPL | Stock | 16.5868 | 16.5868 | 16.5868 | 16.5868 | 2800.0 |
| 2012-02-07 07:55:00 | AAPL | Stock | 16.5764 | 16.5764 | 16.5714 | 16.5714 | 14000.0 |
| 2012-02-07 07:59:00 | AAPL | Stock | 16.5718 | 16.5743 | 16.5714 | 16.5714 | 18200.0 |
| 2012-02-07 08:00:00 | AAPL | Stock | 16.5854 | 16.5893 | 16.5714 | 16.5893 | 41160.0 |
| 2012-02-07 08:02:00 | AAPL | Stock | 16.5861 | 16.5861 | 16.5861 | 16.5861 | 2800.0 |
| 2012-02-07 08:05:00 | AAPL | Stock | 16.5357 | 16.5357 | 16.5357 | 16.5357 | 33600.0 |
| 2012-02-07 08:07:00 | AAPL | Stock | 16.5829 | 16.5829 | 16.5821 | 16.5825 | 11200.0 |
| 2012-02-07 08:08:00 | AAPL | Stock | 16.5786 | 16.5839 | 16.5786 | 16.5821 | 44800.0 |
| 2012-02-07 08:10:00 | AAPL | Stock | 16.5893 | 16.5932 | 16.5893 | 16.5932 | 8400.0 |
| 2012-02-07 08:12:00 | AAPL | Stock | 16.595 | 16.595 | 16.595 | 16.595 | 8400.0 |
| 2012-02-07 08:13:00 | AAPL | Stock | 16.5929 | 16.595 | 16.5929 | 16.595 | 5600.0 |
| 2012-02-07 08:16:00 | AAPL | Stock | 16.5954 | 16.5954 | 16.5929 | 16.5929 | 14000.0 |
| 2012-02-07 08:20:00 | AAPL | Stock | 16.5868 | 16.5868 | 16.5868 | 16.5868 | 4200.0 |
| 2012-02-07 08:22:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5893 | 16.5893 | 2800.0 |
| 2012-02-07 08:23:00 | AAPL | Stock | 16.595 | 16.5961 | 16.5896 | 16.5961 | 26628.0 |
| 2012-02-07 08:24:00 | AAPL | Stock | 16.5946 | 16.5961 | 16.5946 | 16.5961 | 15904.0 |
| 2012-02-07 08:26:00 | AAPL | Stock | 16.5957 | 16.6 | 16.5957 | 16.6 | 74200.0 |
| 2012-02-07 08:27:00 | AAPL | Stock | 16.6036 | 16.6036 | 16.6018 | 16.6032 | 14000.0 |
| 2012-02-07 08:28:00 | AAPL | Stock | 16.6 | 16.6054 | 16.6 | 16.6054 | 9800.0 |
| 2012-02-07 08:29:00 | AAPL | Stock | 16.6 | 16.6 | 16.6 | 16.6 | 2800.0 |
| 2012-02-07 08:30:00 | AAPL | Stock | 16.6032 | 16.6036 | 16.6032 | 16.6032 | 27720.0 |
> showing 50 of 954,419 rows — these rows as CSV