PREVIEW / stock_1min / 2013-08-05
file: by_date/stock_1min/2013/2013-08-05.parquet size: 13.3 MB rows: 967,160 symbols: 2,838
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-08-05 04:00:00 | AAPL | Stock | 16.5054 | 16.5054 | 16.5054 | 16.5054 | 2800.0 |
| 2013-08-05 04:22:00 | AAPL | Stock | 16.55 | 16.55 | 16.55 | 16.55 | 2800.0 |
| 2013-08-05 05:28:00 | AAPL | Stock | 16.5675 | 16.5675 | 16.5675 | 16.5675 | 2800.0 |
| 2013-08-05 06:01:00 | AAPL | Stock | 16.5771 | 16.5771 | 16.5771 | 16.5771 | 2800.0 |
| 2013-08-05 06:46:00 | AAPL | Stock | 16.6029 | 16.6029 | 16.6029 | 16.6029 | 11200.0 |
| 2013-08-05 06:47:00 | AAPL | Stock | 16.6029 | 16.6236 | 16.6018 | 16.6143 | 33600.0 |
| 2013-08-05 06:48:00 | AAPL | Stock | 16.6257 | 16.6257 | 16.6214 | 16.6214 | 14280.0 |
| 2013-08-05 06:51:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 16184.0 |
| 2013-08-05 07:01:00 | AAPL | Stock | 16.5979 | 16.5979 | 16.5979 | 16.5979 | 2800.0 |
| 2013-08-05 07:02:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5843 | 16.5893 | 28644.0 |
| 2013-08-05 07:03:00 | AAPL | Stock | 16.5993 | 16.62 | 16.5993 | 16.6079 | 35644.0 |
| 2013-08-05 07:04:00 | AAPL | Stock | 16.6214 | 16.6214 | 16.6214 | 16.6214 | 10500.0 |
| 2013-08-05 07:05:00 | AAPL | Stock | 16.6339 | 16.6339 | 16.6339 | 16.6339 | 14000.0 |
| 2013-08-05 07:06:00 | AAPL | Stock | 16.6393 | 16.6536 | 16.6393 | 16.6536 | 32480.0 |
| 2013-08-05 07:07:00 | AAPL | Stock | 16.6536 | 16.6561 | 16.6536 | 16.6561 | 21700.0 |
| 2013-08-05 07:08:00 | AAPL | Stock | 16.6639 | 16.6786 | 16.6571 | 16.6786 | 182224.0 |
| 2013-08-05 07:09:00 | AAPL | Stock | 16.6714 | 16.7143 | 16.6714 | 16.7143 | 51100.0 |
| 2013-08-05 07:10:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7054 | 16.7054 | 16800.0 |
| 2013-08-05 07:11:00 | AAPL | Stock | 16.6864 | 16.6864 | 16.6804 | 16.6804 | 39620.0 |
| 2013-08-05 07:12:00 | AAPL | Stock | 16.6804 | 16.6804 | 16.6643 | 16.6764 | 65100.0 |
| 2013-08-05 07:13:00 | AAPL | Stock | 16.675 | 16.6893 | 16.675 | 16.6893 | 59500.0 |
| 2013-08-05 07:14:00 | AAPL | Stock | 16.7032 | 16.7129 | 16.6964 | 16.7125 | 126840.0 |
| 2013-08-05 07:15:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7107 | 16.7107 | 2800.0 |
| 2013-08-05 07:18:00 | AAPL | Stock | 16.6825 | 16.6825 | 16.6825 | 16.6825 | 11200.0 |
| 2013-08-05 07:19:00 | AAPL | Stock | 16.6829 | 16.6893 | 16.6789 | 16.6789 | 36400.0 |
| 2013-08-05 07:20:00 | AAPL | Stock | 16.6768 | 16.6768 | 16.6768 | 16.6768 | 3360.0 |
| 2013-08-05 07:21:00 | AAPL | Stock | 16.6696 | 16.6696 | 16.6682 | 16.6696 | 11256.0 |
| 2013-08-05 07:22:00 | AAPL | Stock | 16.67 | 16.67 | 16.6607 | 16.6607 | 66248.0 |
| 2013-08-05 07:23:00 | AAPL | Stock | 16.6625 | 16.6679 | 16.6625 | 16.6679 | 11200.0 |
| 2013-08-05 07:24:00 | AAPL | Stock | 16.6764 | 16.6893 | 16.6764 | 16.6893 | 52332.0 |
| 2013-08-05 07:25:00 | AAPL | Stock | 16.6889 | 16.6889 | 16.6804 | 16.6804 | 8400.0 |
| 2013-08-05 07:26:00 | AAPL | Stock | 16.6893 | 16.6911 | 16.6889 | 16.6893 | 51016.0 |
| 2013-08-05 07:27:00 | AAPL | Stock | 16.6904 | 16.6904 | 16.6904 | 16.6904 | 2800.0 |
| 2013-08-05 07:29:00 | AAPL | Stock | 16.6839 | 16.6839 | 16.6825 | 16.6825 | 14000.0 |
| 2013-08-05 07:30:00 | AAPL | Stock | 16.6818 | 16.6832 | 16.6811 | 16.6811 | 14000.0 |
| 2013-08-05 07:31:00 | AAPL | Stock | 16.6786 | 16.6804 | 16.6786 | 16.6804 | 135352.0 |
| 2013-08-05 07:32:00 | AAPL | Stock | 16.6786 | 16.6804 | 16.6786 | 16.6786 | 131572.0 |
| 2013-08-05 07:33:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6682 | 16.6779 | 142800.0 |
| 2013-08-05 07:34:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6786 | 16.6786 | 2800.0 |
| 2013-08-05 07:35:00 | AAPL | Stock | 16.6696 | 16.6696 | 16.6696 | 16.6696 | 5600.0 |
| 2013-08-05 07:36:00 | AAPL | Stock | 16.6664 | 16.6679 | 16.665 | 16.665 | 42000.0 |
| 2013-08-05 07:37:00 | AAPL | Stock | 16.6664 | 16.6668 | 16.6654 | 16.6654 | 21000.0 |
| 2013-08-05 07:38:00 | AAPL | Stock | 16.6646 | 16.6646 | 16.6575 | 16.6575 | 47600.0 |
| 2013-08-05 07:39:00 | AAPL | Stock | 16.6607 | 16.6643 | 16.6607 | 16.6643 | 5600.0 |
| 2013-08-05 07:40:00 | AAPL | Stock | 16.6582 | 16.6582 | 16.6582 | 16.6582 | 2800.0 |
| 2013-08-05 07:41:00 | AAPL | Stock | 16.6579 | 16.6579 | 16.6432 | 16.6432 | 18592.0 |
| 2013-08-05 07:42:00 | AAPL | Stock | 16.6446 | 16.6468 | 16.6446 | 16.6468 | 16800.0 |
| 2013-08-05 07:43:00 | AAPL | Stock | 16.6589 | 16.6589 | 16.6589 | 16.6589 | 5600.0 |
| 2013-08-05 07:44:00 | AAPL | Stock | 16.6571 | 16.6571 | 16.6571 | 16.6571 | 2800.0 |
| 2013-08-05 07:45:00 | AAPL | Stock | 16.65 | 16.65 | 16.6475 | 16.6475 | 11200.0 |
> showing 50 of 967,160 rows — these rows as CSV