PREVIEW / stock_1min / 2013-05-02
file: by_date/stock_1min/2013/2013-05-02.parquet size: 13.7 MB rows: 1,005,154 symbols: 2,818
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-05-02 05:15:00 | AAPL | Stock | 15.7171 | 15.7171 | 15.7171 | 15.7171 | 2800.0 |
| 2013-05-02 06:28:00 | AAPL | Stock | 15.7411 | 15.7479 | 15.7411 | 15.7479 | 8400.0 |
| 2013-05-02 06:32:00 | AAPL | Stock | 15.7482 | 15.7482 | 15.7482 | 15.7482 | 2800.0 |
| 2013-05-02 06:57:00 | AAPL | Stock | 15.7407 | 15.7407 | 15.7407 | 15.7407 | 2800.0 |
| 2013-05-02 06:58:00 | AAPL | Stock | 15.7479 | 15.75 | 15.7479 | 15.75 | 26712.0 |
| 2013-05-02 07:01:00 | AAPL | Stock | 15.7675 | 15.7675 | 15.7675 | 15.7675 | 11424.0 |
| 2013-05-02 07:02:00 | AAPL | Stock | 15.7732 | 15.7732 | 15.7679 | 15.7679 | 33600.0 |
| 2013-05-02 07:06:00 | AAPL | Stock | 15.7729 | 15.7729 | 15.7679 | 15.7679 | 26600.0 |
| 2013-05-02 07:07:00 | AAPL | Stock | 15.7679 | 15.7679 | 15.7679 | 15.7679 | 2800.0 |
| 2013-05-02 07:13:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 11200.0 |
| 2013-05-02 07:23:00 | AAPL | Stock | 15.7554 | 15.7607 | 15.7554 | 15.7607 | 36400.0 |
| 2013-05-02 07:24:00 | AAPL | Stock | 15.7607 | 15.7661 | 15.7607 | 15.7661 | 25200.0 |
| 2013-05-02 07:25:00 | AAPL | Stock | 15.7675 | 15.7679 | 15.7675 | 15.7679 | 19600.0 |
| 2013-05-02 07:26:00 | AAPL | Stock | 15.7679 | 15.7718 | 15.7679 | 15.7718 | 11200.0 |
| 2013-05-02 07:28:00 | AAPL | Stock | 15.7739 | 15.7821 | 15.7682 | 15.7821 | 22400.0 |
| 2013-05-02 07:32:00 | AAPL | Stock | 15.7796 | 15.7807 | 15.7793 | 15.7807 | 16800.0 |
| 2013-05-02 07:34:00 | AAPL | Stock | 15.78 | 15.78 | 15.78 | 15.78 | 2800.0 |
| 2013-05-02 07:36:00 | AAPL | Stock | 15.7711 | 15.7711 | 15.7711 | 15.7711 | 8400.0 |
| 2013-05-02 07:37:00 | AAPL | Stock | 15.7711 | 15.7761 | 15.7711 | 15.7761 | 8400.0 |
| 2013-05-02 07:38:00 | AAPL | Stock | 15.7775 | 15.7879 | 15.7775 | 15.7879 | 77812.0 |
| 2013-05-02 07:40:00 | AAPL | Stock | 15.8018 | 15.8129 | 15.7982 | 15.7982 | 42000.0 |
| 2013-05-02 07:42:00 | AAPL | Stock | 15.7946 | 15.7946 | 15.7946 | 15.7946 | 2800.0 |
| 2013-05-02 07:44:00 | AAPL | Stock | 15.7896 | 15.7904 | 15.7896 | 15.7896 | 8400.0 |
| 2013-05-02 07:45:00 | AAPL | Stock | 15.8018 | 15.8032 | 15.8018 | 15.8025 | 15932.0 |
| 2013-05-02 07:46:00 | AAPL | Stock | 15.8032 | 15.8146 | 15.8032 | 15.8036 | 80808.0 |
| 2013-05-02 07:47:00 | AAPL | Stock | 15.8046 | 15.8239 | 15.8021 | 15.8239 | 113904.0 |
| 2013-05-02 07:48:00 | AAPL | Stock | 15.8239 | 15.8311 | 15.8214 | 15.8304 | 47600.0 |
| 2013-05-02 07:49:00 | AAPL | Stock | 15.8196 | 15.8196 | 15.8143 | 15.8143 | 30268.0 |
| 2013-05-02 07:50:00 | AAPL | Stock | 15.8214 | 15.8264 | 15.8214 | 15.8264 | 8400.0 |
| 2013-05-02 07:51:00 | AAPL | Stock | 15.8268 | 15.8393 | 15.8268 | 15.8393 | 64344.0 |
| 2013-05-02 07:52:00 | AAPL | Stock | 15.8389 | 15.8389 | 15.8375 | 15.8375 | 14448.0 |
| 2013-05-02 07:53:00 | AAPL | Stock | 15.8264 | 15.8264 | 15.8214 | 15.8214 | 27160.0 |
| 2013-05-02 07:54:00 | AAPL | Stock | 15.8214 | 15.8214 | 15.8214 | 15.8214 | 51716.0 |
| 2013-05-02 07:55:00 | AAPL | Stock | 15.8214 | 15.825 | 15.8214 | 15.825 | 19600.0 |
| 2013-05-02 07:56:00 | AAPL | Stock | 15.83 | 15.84 | 15.83 | 15.84 | 57428.0 |
| 2013-05-02 07:57:00 | AAPL | Stock | 15.825 | 15.8354 | 15.825 | 15.8354 | 5600.0 |
| 2013-05-02 07:58:00 | AAPL | Stock | 15.8286 | 15.8286 | 15.8279 | 15.8279 | 8400.0 |
| 2013-05-02 07:59:00 | AAPL | Stock | 15.825 | 15.825 | 15.825 | 15.825 | 2800.0 |
| 2013-05-02 08:00:00 | AAPL | Stock | 15.825 | 15.8346 | 15.7607 | 15.8211 | 148568.0 |
| 2013-05-02 08:01:00 | AAPL | Stock | 15.8139 | 15.8139 | 15.7957 | 15.8 | 99288.0 |
| 2013-05-02 08:02:00 | AAPL | Stock | 15.8 | 15.8089 | 15.7911 | 15.8036 | 114240.0 |
| 2013-05-02 08:03:00 | AAPL | Stock | 15.7932 | 15.8036 | 15.7932 | 15.8036 | 28560.0 |
| 2013-05-02 08:04:00 | AAPL | Stock | 15.7946 | 15.7946 | 15.7821 | 15.7854 | 108220.0 |
| 2013-05-02 08:05:00 | AAPL | Stock | 15.785 | 15.7864 | 15.7729 | 15.7729 | 52164.0 |
| 2013-05-02 08:06:00 | AAPL | Stock | 15.7786 | 15.7946 | 15.7786 | 15.7946 | 23520.0 |
| 2013-05-02 08:07:00 | AAPL | Stock | 15.8 | 15.8 | 15.7829 | 15.7829 | 31164.0 |
| 2013-05-02 08:09:00 | AAPL | Stock | 15.7921 | 15.7921 | 15.7861 | 15.7861 | 10612.0 |
| 2013-05-02 08:10:00 | AAPL | Stock | 15.7968 | 15.7968 | 15.7946 | 15.7954 | 11200.0 |
| 2013-05-02 08:11:00 | AAPL | Stock | 15.7979 | 15.7979 | 15.7918 | 15.7964 | 19712.0 |
| 2013-05-02 08:12:00 | AAPL | Stock | 15.7964 | 15.7982 | 15.7961 | 15.7961 | 16800.0 |
> showing 50 of 1,005,154 rows — these rows as CSV