PREVIEW / stock_1min / 2014-02-21
file: by_date/stock_1min/2014/2014-02-21.parquet size: 14.7 MB rows: 1,071,465 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-02-21 04:28:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 2800.0 |
| 2014-02-21 06:20:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2014-02-21 06:36:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-02-21 06:52:00 | AAPL | Stock | 19.0339 | 19.0339 | 19.0339 | 19.0339 | 2800.0 |
| 2014-02-21 06:54:00 | AAPL | Stock | 19.0214 | 19.0214 | 19.0214 | 19.0214 | 2800.0 |
| 2014-02-21 06:55:00 | AAPL | Stock | 19.0261 | 19.0261 | 19.0261 | 19.0261 | 2800.0 |
| 2014-02-21 07:05:00 | AAPL | Stock | 19.0236 | 19.0236 | 19.0179 | 19.0179 | 16548.0 |
| 2014-02-21 07:06:00 | AAPL | Stock | 19.0232 | 19.0232 | 19.0232 | 19.0232 | 5600.0 |
| 2014-02-21 07:16:00 | AAPL | Stock | 19.0229 | 19.0229 | 19.0229 | 19.0229 | 9912.0 |
| 2014-02-21 07:50:00 | AAPL | Stock | 19.0336 | 19.035 | 19.0336 | 19.035 | 26124.0 |
| 2014-02-21 08:00:00 | AAPL | Stock | 19.0229 | 19.0411 | 19.0229 | 19.0357 | 115808.0 |
| 2014-02-21 08:01:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-02-21 08:04:00 | AAPL | Stock | 19.025 | 19.025 | 19.0179 | 19.0179 | 40460.0 |
| 2014-02-21 08:06:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 2800.0 |
| 2014-02-21 08:07:00 | AAPL | Stock | 19.0132 | 19.0132 | 19.0125 | 19.0125 | 11900.0 |
| 2014-02-21 08:10:00 | AAPL | Stock | 19.0282 | 19.0282 | 19.0186 | 19.0186 | 30800.0 |
| 2014-02-21 08:11:00 | AAPL | Stock | 19.0204 | 19.0204 | 19.0204 | 19.0204 | 4060.0 |
| 2014-02-21 08:12:00 | AAPL | Stock | 19.0282 | 19.0282 | 19.0204 | 19.0204 | 31584.0 |
| 2014-02-21 08:16:00 | AAPL | Stock | 19.025 | 19.025 | 19.025 | 19.025 | 2800.0 |
| 2014-02-21 08:20:00 | AAPL | Stock | 19.0236 | 19.0236 | 19.0111 | 19.0111 | 8400.0 |
| 2014-02-21 08:21:00 | AAPL | Stock | 19.0121 | 19.0121 | 19.0107 | 19.0107 | 33600.0 |
| 2014-02-21 08:22:00 | AAPL | Stock | 19.0229 | 19.0246 | 19.0214 | 19.0214 | 25284.0 |
| 2014-02-21 08:24:00 | AAPL | Stock | 19.0225 | 19.0225 | 19.0225 | 19.0225 | 5600.0 |
| 2014-02-21 08:25:00 | AAPL | Stock | 19.025 | 19.025 | 19.025 | 19.025 | 11900.0 |
| 2014-02-21 08:26:00 | AAPL | Stock | 19.0225 | 19.0282 | 19.0204 | 19.0204 | 14000.0 |
| 2014-02-21 08:27:00 | AAPL | Stock | 19.0196 | 19.0196 | 19.0196 | 19.0196 | 2800.0 |
| 2014-02-21 08:29:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2014-02-21 08:30:00 | AAPL | Stock | 19.0286 | 19.0286 | 19.0286 | 19.0286 | 5600.0 |
| 2014-02-21 08:32:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2014-02-21 08:33:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 11200.0 |
| 2014-02-21 08:34:00 | AAPL | Stock | 19.0146 | 19.0146 | 19.0146 | 19.0146 | 2800.0 |
| 2014-02-21 08:35:00 | AAPL | Stock | 19.0139 | 19.0139 | 18.9875 | 18.9875 | 137200.0 |
| 2014-02-21 08:36:00 | AAPL | Stock | 18.9889 | 18.9893 | 18.9889 | 18.9893 | 14000.0 |
| 2014-02-21 08:37:00 | AAPL | Stock | 18.98 | 18.9893 | 18.9764 | 18.9821 | 28840.0 |
| 2014-02-21 08:40:00 | AAPL | Stock | 18.9818 | 18.9821 | 18.9818 | 18.9821 | 14000.0 |
| 2014-02-21 08:41:00 | AAPL | Stock | 18.9936 | 18.9939 | 18.9936 | 18.9939 | 5600.0 |
| 2014-02-21 08:44:00 | AAPL | Stock | 18.9989 | 19.0 | 18.9989 | 19.0 | 10920.0 |
| 2014-02-21 08:46:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 2800.0 |
| 2014-02-21 08:47:00 | AAPL | Stock | 19.0036 | 19.0036 | 19.0004 | 19.0004 | 16800.0 |
| 2014-02-21 08:48:00 | AAPL | Stock | 19.01 | 19.0157 | 19.01 | 19.0157 | 8400.0 |
| 2014-02-21 08:50:00 | AAPL | Stock | 19.0036 | 19.0036 | 19.0 | 19.0 | 16772.0 |
| 2014-02-21 08:51:00 | AAPL | Stock | 19.0018 | 19.0018 | 19.0018 | 19.0018 | 8400.0 |
| 2014-02-21 08:53:00 | AAPL | Stock | 18.9914 | 18.9918 | 18.9821 | 18.9821 | 74648.0 |
| 2014-02-21 08:56:00 | AAPL | Stock | 18.9854 | 18.9943 | 18.985 | 18.9918 | 44380.0 |
| 2014-02-21 08:58:00 | AAPL | Stock | 18.9921 | 18.9921 | 18.9857 | 18.9857 | 14140.0 |
| 2014-02-21 09:02:00 | AAPL | Stock | 18.9957 | 18.9957 | 18.9954 | 18.9954 | 5600.0 |
| 2014-02-21 09:03:00 | AAPL | Stock | 18.9968 | 18.9968 | 18.9968 | 18.9968 | 15400.0 |
| 2014-02-21 09:04:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 8400.0 |
| 2014-02-21 09:06:00 | AAPL | Stock | 19.0075 | 19.0089 | 19.0 | 19.0007 | 58520.0 |
| 2014-02-21 09:07:00 | AAPL | Stock | 18.9968 | 19.0007 | 18.9946 | 19.0007 | 13524.0 |
> showing 50 of 1,071,465 rows — these rows as CSV