PREVIEW / stock_1min / 2014-02-24
file: by_date/stock_1min/2014/2014-02-24.parquet size: 15.1 MB rows: 1,078,455 symbols: 2,874
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-02-24 04:02:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7786 | 18.7786 | 14000.0 |
| 2014-02-24 04:07:00 | AAPL | Stock | 18.775 | 18.775 | 18.775 | 18.775 | 5600.0 |
| 2014-02-24 04:13:00 | AAPL | Stock | 18.7671 | 18.7754 | 18.7671 | 18.7754 | 39200.0 |
| 2014-02-24 04:37:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7714 | 18.7714 | 5600.0 |
| 2014-02-24 04:48:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 5600.0 |
| 2014-02-24 04:54:00 | AAPL | Stock | 18.7468 | 18.7468 | 18.7468 | 18.7468 | 2800.0 |
| 2014-02-24 04:58:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2014-02-24 05:09:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.6907 | 18.6907 | 2800.0 |
| 2014-02-24 06:03:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.6907 | 18.6907 | 2800.0 |
| 2014-02-24 06:04:00 | AAPL | Stock | 18.69 | 18.69 | 18.69 | 18.69 | 2800.0 |
| 2014-02-24 06:05:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.6907 | 18.6907 | 2800.0 |
| 2014-02-24 06:11:00 | AAPL | Stock | 18.6818 | 18.6818 | 18.6818 | 18.6818 | 2800.0 |
| 2014-02-24 06:13:00 | AAPL | Stock | 18.6821 | 18.6821 | 18.6736 | 18.6736 | 14000.0 |
| 2014-02-24 06:15:00 | AAPL | Stock | 18.6732 | 18.6732 | 18.6661 | 18.6661 | 8400.0 |
| 2014-02-24 06:26:00 | AAPL | Stock | 18.65 | 18.65 | 18.6446 | 18.6446 | 11200.0 |
| 2014-02-24 06:27:00 | AAPL | Stock | 18.6446 | 18.6482 | 18.6446 | 18.6482 | 42000.0 |
| 2014-02-24 06:30:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6368 | 18.6368 | 11200.0 |
| 2014-02-24 06:52:00 | AAPL | Stock | 18.6432 | 18.6432 | 18.6432 | 18.6432 | 2800.0 |
| 2014-02-24 06:53:00 | AAPL | Stock | 18.6446 | 18.6446 | 18.6446 | 18.6446 | 2800.0 |
| 2014-02-24 06:55:00 | AAPL | Stock | 18.6586 | 18.6586 | 18.6586 | 18.6586 | 10500.0 |
| 2014-02-24 06:56:00 | AAPL | Stock | 18.66 | 18.66 | 18.66 | 18.66 | 26600.0 |
| 2014-02-24 06:59:00 | AAPL | Stock | 18.6643 | 18.6643 | 18.6643 | 18.6643 | 2800.0 |
| 2014-02-24 07:00:00 | AAPL | Stock | 18.6711 | 18.6725 | 18.6711 | 18.6725 | 22400.0 |
| 2014-02-24 07:01:00 | AAPL | Stock | 18.6771 | 18.6771 | 18.6771 | 18.6771 | 16800.0 |
| 2014-02-24 07:02:00 | AAPL | Stock | 18.6882 | 18.6882 | 18.6882 | 18.6882 | 5600.0 |
| 2014-02-24 07:04:00 | AAPL | Stock | 18.6879 | 18.6882 | 18.6879 | 18.6882 | 5600.0 |
| 2014-02-24 07:08:00 | AAPL | Stock | 18.7143 | 18.7211 | 18.7143 | 18.7211 | 58800.0 |
| 2014-02-24 07:13:00 | AAPL | Stock | 18.6968 | 18.6968 | 18.6968 | 18.6968 | 2800.0 |
| 2014-02-24 07:20:00 | AAPL | Stock | 18.7029 | 18.7029 | 18.7 | 18.7 | 36400.0 |
| 2014-02-24 07:21:00 | AAPL | Stock | 18.7136 | 18.7136 | 18.7136 | 18.7136 | 8120.0 |
| 2014-02-24 07:24:00 | AAPL | Stock | 18.6954 | 18.6954 | 18.6929 | 18.6929 | 17444.0 |
| 2014-02-24 07:31:00 | AAPL | Stock | 18.6946 | 18.6979 | 18.6946 | 18.6979 | 5600.0 |
| 2014-02-24 07:38:00 | AAPL | Stock | 18.7111 | 18.7143 | 18.7111 | 18.7143 | 45976.0 |
| 2014-02-24 07:41:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 28000.0 |
| 2014-02-24 07:42:00 | AAPL | Stock | 18.7139 | 18.7143 | 18.7139 | 18.7143 | 42000.0 |
| 2014-02-24 07:43:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 17276.0 |
| 2014-02-24 07:44:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7082 | 18.7082 | 8400.0 |
| 2014-02-24 07:47:00 | AAPL | Stock | 18.6986 | 18.6986 | 18.6964 | 18.6964 | 7504.0 |
| 2014-02-24 07:48:00 | AAPL | Stock | 18.6864 | 18.6864 | 18.6786 | 18.6786 | 19600.0 |
| 2014-02-24 07:50:00 | AAPL | Stock | 18.6771 | 18.6771 | 18.6771 | 18.6771 | 2800.0 |
| 2014-02-24 07:51:00 | AAPL | Stock | 18.6764 | 18.6764 | 18.6714 | 18.6714 | 5600.0 |
| 2014-02-24 07:52:00 | AAPL | Stock | 18.6657 | 18.6657 | 18.6643 | 18.6643 | 5600.0 |
| 2014-02-24 07:53:00 | AAPL | Stock | 18.6768 | 18.6796 | 18.6768 | 18.6796 | 12152.0 |
| 2014-02-24 07:55:00 | AAPL | Stock | 18.6789 | 18.6789 | 18.6789 | 18.6789 | 2800.0 |
| 2014-02-24 07:57:00 | AAPL | Stock | 18.6943 | 18.7129 | 18.6943 | 18.7129 | 33600.0 |
| 2014-02-24 07:58:00 | AAPL | Stock | 18.7121 | 18.7157 | 18.7121 | 18.7146 | 130704.0 |
| 2014-02-24 07:59:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 8400.0 |
| 2014-02-24 08:00:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.6607 | 18.6607 | 163996.0 |
| 2014-02-24 08:01:00 | AAPL | Stock | 18.6625 | 18.6764 | 18.6521 | 18.6521 | 76720.0 |
| 2014-02-24 08:03:00 | AAPL | Stock | 18.6593 | 18.6593 | 18.6536 | 18.6536 | 36512.0 |
> showing 50 of 1,078,455 rows — these rows as CSV