PREVIEW / stock_1min / 2014-03-05
file: by_date/stock_1min/2014/2014-03-05.parquet size: 14.5 MB rows: 1,055,849 symbols: 2,860
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-03-05 04:52:00 | AAPL | Stock | 18.9736 | 18.9736 | 18.9736 | 18.9736 | 2800.0 |
| 2014-03-05 05:09:00 | AAPL | Stock | 18.9832 | 18.9832 | 18.9832 | 18.9832 | 5600.0 |
| 2014-03-05 05:50:00 | AAPL | Stock | 18.9889 | 18.9904 | 18.9889 | 18.9904 | 14000.0 |
| 2014-03-05 07:01:00 | AAPL | Stock | 18.9921 | 18.9921 | 18.9921 | 18.9921 | 5600.0 |
| 2014-03-05 07:02:00 | AAPL | Stock | 19.0036 | 19.0036 | 19.0036 | 19.0036 | 2800.0 |
| 2014-03-05 07:04:00 | AAPL | Stock | 19.0161 | 19.0161 | 19.0161 | 19.0161 | 2800.0 |
| 2014-03-05 07:05:00 | AAPL | Stock | 19.0175 | 19.0207 | 19.0175 | 19.0207 | 12656.0 |
| 2014-03-05 07:10:00 | AAPL | Stock | 19.0039 | 19.0039 | 19.0036 | 19.0036 | 11200.0 |
| 2014-03-05 07:16:00 | AAPL | Stock | 19.0171 | 19.0357 | 19.0171 | 19.0357 | 25396.0 |
| 2014-03-05 07:18:00 | AAPL | Stock | 19.0314 | 19.0357 | 19.0314 | 19.0357 | 14000.0 |
| 2014-03-05 07:22:00 | AAPL | Stock | 19.0186 | 19.0186 | 19.0186 | 19.0186 | 2800.0 |
| 2014-03-05 07:23:00 | AAPL | Stock | 19.0182 | 19.0182 | 19.0182 | 19.0182 | 2800.0 |
| 2014-03-05 07:24:00 | AAPL | Stock | 19.0057 | 19.0057 | 19.0039 | 19.0039 | 11200.0 |
| 2014-03-05 07:33:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-03-05 07:34:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 12880.0 |
| 2014-03-05 07:35:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-03-05 07:36:00 | AAPL | Stock | 19.0357 | 19.0446 | 19.0357 | 19.0446 | 30380.0 |
| 2014-03-05 07:37:00 | AAPL | Stock | 19.0439 | 19.0446 | 19.0439 | 19.0446 | 24360.0 |
| 2014-03-05 07:54:00 | AAPL | Stock | 19.0411 | 19.0411 | 19.0411 | 19.0411 | 2800.0 |
| 2014-03-05 07:55:00 | AAPL | Stock | 19.0393 | 19.0521 | 19.0393 | 19.0521 | 23632.0 |
| 2014-03-05 08:00:00 | AAPL | Stock | 19.0289 | 19.0446 | 19.0039 | 19.0179 | 143556.0 |
| 2014-03-05 08:01:00 | AAPL | Stock | 19.0179 | 19.0179 | 18.9286 | 19.0179 | 14896.0 |
| 2014-03-05 08:02:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2014-03-05 08:03:00 | AAPL | Stock | 19.0354 | 19.0357 | 19.0354 | 19.0357 | 5600.0 |
| 2014-03-05 08:04:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0268 | 19.0268 | 8400.0 |
| 2014-03-05 08:05:00 | AAPL | Stock | 19.0182 | 19.0182 | 19.0089 | 19.0104 | 15512.0 |
| 2014-03-05 08:07:00 | AAPL | Stock | 19.0 | 19.0321 | 19.0 | 19.0321 | 8120.0 |
| 2014-03-05 08:08:00 | AAPL | Stock | 19.0336 | 19.0336 | 19.0336 | 19.0336 | 2800.0 |
| 2014-03-05 08:09:00 | AAPL | Stock | 19.0186 | 19.0186 | 19.0104 | 19.0104 | 25200.0 |
| 2014-03-05 08:13:00 | AAPL | Stock | 19.0143 | 19.0143 | 19.0143 | 19.0143 | 4760.0 |
| 2014-03-05 08:14:00 | AAPL | Stock | 19.0179 | 19.0179 | 18.9864 | 18.9864 | 41020.0 |
| 2014-03-05 08:16:00 | AAPL | Stock | 18.9875 | 18.9875 | 18.9811 | 18.9811 | 33460.0 |
| 2014-03-05 08:18:00 | AAPL | Stock | 18.9729 | 18.9729 | 18.9675 | 18.9675 | 42000.0 |
| 2014-03-05 08:19:00 | AAPL | Stock | 18.9714 | 18.9714 | 18.9714 | 18.9714 | 14000.0 |
| 2014-03-05 08:21:00 | AAPL | Stock | 18.9643 | 18.9646 | 18.9561 | 18.9643 | 30296.0 |
| 2014-03-05 08:23:00 | AAPL | Stock | 18.9643 | 18.9746 | 18.9643 | 18.9746 | 184604.0 |
| 2014-03-05 08:25:00 | AAPL | Stock | 18.9743 | 18.9754 | 18.9543 | 18.9543 | 17640.0 |
| 2014-03-05 08:26:00 | AAPL | Stock | 18.9854 | 18.9861 | 18.9854 | 18.9861 | 7000.0 |
| 2014-03-05 08:27:00 | AAPL | Stock | 18.9643 | 18.9782 | 18.9643 | 18.9782 | 8400.0 |
| 2014-03-05 08:30:00 | AAPL | Stock | 18.9661 | 18.9661 | 18.9543 | 18.9543 | 14000.0 |
| 2014-03-05 08:33:00 | AAPL | Stock | 18.9607 | 18.9643 | 18.9446 | 18.9643 | 53788.0 |
| 2014-03-05 08:36:00 | AAPL | Stock | 18.9536 | 18.9536 | 18.9429 | 18.9429 | 8820.0 |
| 2014-03-05 08:37:00 | AAPL | Stock | 18.9404 | 18.9404 | 18.9293 | 18.9293 | 8988.0 |
| 2014-03-05 08:38:00 | AAPL | Stock | 18.9321 | 18.9429 | 18.9321 | 18.9429 | 8400.0 |
| 2014-03-05 08:39:00 | AAPL | Stock | 18.9357 | 18.9357 | 18.9357 | 18.9357 | 5600.0 |
| 2014-03-05 08:40:00 | AAPL | Stock | 18.9375 | 18.9375 | 18.9375 | 18.9375 | 6440.0 |
| 2014-03-05 08:41:00 | AAPL | Stock | 18.9325 | 18.9325 | 18.9321 | 18.9321 | 19012.0 |
| 2014-03-05 08:42:00 | AAPL | Stock | 18.9296 | 18.9296 | 18.9261 | 18.9261 | 30800.0 |
| 2014-03-05 08:44:00 | AAPL | Stock | 18.9307 | 18.9321 | 18.9307 | 18.9321 | 15008.0 |
| 2014-03-05 08:47:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9286 | 18.9286 | 16800.0 |
> showing 50 of 1,055,849 rows — these rows as CSV