PREVIEW / stock_1min / 2014-05-23
file: by_date/stock_1min/2014/2014-05-23.parquet size: 13.2 MB rows: 981,768 symbols: 2,868
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-23 04:37:00 | AAPL | Stock | 21.6804 | 21.6804 | 21.6804 | 21.6804 | 8400.0 |
| 2014-05-23 04:38:00 | AAPL | Stock | 21.6839 | 21.6839 | 21.6839 | 21.6839 | 8400.0 |
| 2014-05-23 05:59:00 | AAPL | Stock | 21.6914 | 21.6925 | 21.6914 | 21.6925 | 5600.0 |
| 2014-05-23 06:02:00 | AAPL | Stock | 21.6993 | 21.6993 | 21.6993 | 21.6993 | 2800.0 |
| 2014-05-23 07:07:00 | AAPL | Stock | 21.6907 | 21.6907 | 21.6907 | 21.6907 | 14000.0 |
| 2014-05-23 07:10:00 | AAPL | Stock | 21.6893 | 21.6893 | 21.6875 | 21.6875 | 14000.0 |
| 2014-05-23 07:22:00 | AAPL | Stock | 21.6875 | 21.6875 | 21.6875 | 21.6875 | 2800.0 |
| 2014-05-23 07:35:00 | AAPL | Stock | 21.6861 | 21.6861 | 21.6861 | 21.6861 | 5600.0 |
| 2014-05-23 07:50:00 | AAPL | Stock | 21.6761 | 21.6761 | 21.6761 | 21.6761 | 2800.0 |
| 2014-05-23 08:00:00 | AAPL | Stock | 21.6786 | 21.6964 | 21.6786 | 21.6836 | 40600.0 |
| 2014-05-23 08:02:00 | AAPL | Stock | 21.6782 | 21.6782 | 21.6782 | 21.6782 | 4060.0 |
| 2014-05-23 08:03:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6743 | 21.6743 | 15540.0 |
| 2014-05-23 08:07:00 | AAPL | Stock | 21.6764 | 21.6764 | 21.6764 | 21.6764 | 14000.0 |
| 2014-05-23 08:12:00 | AAPL | Stock | 21.6768 | 21.6768 | 21.6768 | 21.6768 | 2800.0 |
| 2014-05-23 08:16:00 | AAPL | Stock | 21.6711 | 21.6711 | 21.6696 | 21.6696 | 11200.0 |
| 2014-05-23 08:17:00 | AAPL | Stock | 21.67 | 21.67 | 21.6668 | 21.6668 | 18200.0 |
| 2014-05-23 08:19:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6514 | 21.6514 | 11144.0 |
| 2014-05-23 08:21:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 16800.0 |
| 2014-05-23 08:34:00 | AAPL | Stock | 21.6714 | 21.6714 | 21.6714 | 21.6714 | 33600.0 |
| 2014-05-23 08:46:00 | AAPL | Stock | 21.6636 | 21.6636 | 21.6636 | 21.6636 | 5600.0 |
| 2014-05-23 08:47:00 | AAPL | Stock | 21.6696 | 21.6696 | 21.6664 | 21.6664 | 11088.0 |
| 2014-05-23 08:51:00 | AAPL | Stock | 21.6679 | 21.6679 | 21.6661 | 21.6679 | 39564.0 |
| 2014-05-23 08:57:00 | AAPL | Stock | 21.6725 | 21.6725 | 21.6725 | 21.6725 | 13888.0 |
| 2014-05-23 08:58:00 | AAPL | Stock | 21.6729 | 21.6729 | 21.6729 | 21.6729 | 2800.0 |
| 2014-05-23 08:59:00 | AAPL | Stock | 21.6668 | 21.6668 | 21.6657 | 21.6657 | 5600.0 |
| 2014-05-23 09:00:00 | AAPL | Stock | 21.6639 | 21.6639 | 21.6607 | 21.6607 | 90636.0 |
| 2014-05-23 09:01:00 | AAPL | Stock | 21.6571 | 21.6607 | 21.6571 | 21.6607 | 22400.0 |
| 2014-05-23 09:08:00 | AAPL | Stock | 21.67 | 21.6711 | 21.6693 | 21.6711 | 16800.0 |
| 2014-05-23 09:15:00 | AAPL | Stock | 21.6679 | 21.6679 | 21.6679 | 21.6679 | 2800.0 |
| 2014-05-23 09:21:00 | AAPL | Stock | 21.6693 | 21.6693 | 21.6693 | 21.6693 | 8400.0 |
| 2014-05-23 09:25:00 | AAPL | Stock | 21.6696 | 21.67 | 21.6696 | 21.67 | 22400.0 |
| 2014-05-23 09:28:00 | AAPL | Stock | 21.6786 | 21.6939 | 21.6729 | 21.6857 | 230888.0 |
| 2014-05-23 09:29:00 | AAPL | Stock | 21.6832 | 21.6875 | 21.6804 | 21.6875 | 24808.0 |
| 2014-05-23 09:30:00 | AAPL | Stock | 21.6875 | 21.7143 | 21.6729 | 21.6961 | 3690596.0 |
| 2014-05-23 09:31:00 | AAPL | Stock | 21.6957 | 21.7214 | 21.6746 | 21.7154 | 1169448.0 |
| 2014-05-23 09:32:00 | AAPL | Stock | 21.7175 | 21.7236 | 21.6871 | 21.6929 | 964068.0 |
| 2014-05-23 09:33:00 | AAPL | Stock | 21.6986 | 21.7139 | 21.6921 | 21.7136 | 570472.0 |
| 2014-05-23 09:34:00 | AAPL | Stock | 21.7118 | 21.7189 | 21.7036 | 21.7129 | 722092.0 |
| 2014-05-23 09:35:00 | AAPL | Stock | 21.7139 | 21.7225 | 21.705 | 21.7171 | 955864.0 |
| 2014-05-23 09:36:00 | AAPL | Stock | 21.7164 | 21.7164 | 21.6946 | 21.6946 | 612920.0 |
| 2014-05-23 09:37:00 | AAPL | Stock | 21.6986 | 21.6986 | 21.6815 | 21.6871 | 464884.0 |
| 2014-05-23 09:38:00 | AAPL | Stock | 21.691 | 21.7096 | 21.6893 | 21.7 | 365064.0 |
| 2014-05-23 09:39:00 | AAPL | Stock | 21.6986 | 21.7021 | 21.68 | 21.6994 | 578844.0 |
| 2014-05-23 09:40:00 | AAPL | Stock | 21.7011 | 21.7039 | 21.6893 | 21.6929 | 732984.0 |
| 2014-05-23 09:41:00 | AAPL | Stock | 21.6929 | 21.6975 | 21.6786 | 21.6839 | 530124.0 |
| 2014-05-23 09:42:00 | AAPL | Stock | 21.6877 | 21.7032 | 21.6793 | 21.6984 | 2306584.0 |
| 2014-05-23 09:43:00 | AAPL | Stock | 21.6979 | 21.7054 | 21.6879 | 21.6993 | 3862068.0 |
| 2014-05-23 09:44:00 | AAPL | Stock | 21.6989 | 21.7064 | 21.6875 | 21.7032 | 2051784.0 |
| 2014-05-23 09:45:00 | AAPL | Stock | 21.7036 | 21.7189 | 21.6986 | 21.7171 | 386204.0 |
| 2014-05-23 09:46:00 | AAPL | Stock | 21.7168 | 21.7318 | 21.7139 | 21.7256 | 898884.0 |
> showing 50 of 981,768 rows — these rows as CSV