PREVIEW / stock_1min / 2014-04-10
file: by_date/stock_1min/2014/2014-04-10.parquet size: 15.6 MB rows: 1,119,576 symbols: 2,882
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-04-10 04:05:00 | AAPL | Stock | 19.0368 | 19.0368 | 19.0357 | 19.0357 | 26600.0 |
| 2014-04-10 04:17:00 | AAPL | Stock | 19.05 | 19.05 | 19.05 | 19.05 | 5600.0 |
| 2014-04-10 04:52:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-04-10 04:53:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 5600.0 |
| 2014-04-10 04:54:00 | AAPL | Stock | 19.0254 | 19.0254 | 19.0254 | 19.0254 | 2800.0 |
| 2014-04-10 05:01:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-04-10 05:21:00 | AAPL | Stock | 18.9482 | 18.9482 | 18.9482 | 18.9482 | 5600.0 |
| 2014-04-10 05:22:00 | AAPL | Stock | 18.9846 | 18.9846 | 18.9846 | 18.9846 | 11200.0 |
| 2014-04-10 05:23:00 | AAPL | Stock | 18.9846 | 18.9846 | 18.9846 | 18.9846 | 2800.0 |
| 2014-04-10 05:24:00 | AAPL | Stock | 18.9846 | 18.9846 | 18.9846 | 18.9846 | 8400.0 |
| 2014-04-10 05:51:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 2800.0 |
| 2014-04-10 05:57:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9464 | 18.9464 | 5600.0 |
| 2014-04-10 06:30:00 | AAPL | Stock | 18.9446 | 18.9446 | 18.9446 | 18.9446 | 11480.0 |
| 2014-04-10 06:39:00 | AAPL | Stock | 18.9446 | 18.9446 | 18.9446 | 18.9446 | 14000.0 |
| 2014-04-10 06:48:00 | AAPL | Stock | 18.9293 | 18.9643 | 18.9293 | 18.9621 | 16240.0 |
| 2014-04-10 06:55:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 20664.0 |
| 2014-04-10 06:59:00 | AAPL | Stock | 18.975 | 18.975 | 18.975 | 18.975 | 2800.0 |
| 2014-04-10 07:07:00 | AAPL | Stock | 18.975 | 18.975 | 18.975 | 18.975 | 11200.0 |
| 2014-04-10 07:08:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2014-04-10 07:09:00 | AAPL | Stock | 18.975 | 18.975 | 18.975 | 18.975 | 16800.0 |
| 2014-04-10 07:10:00 | AAPL | Stock | 18.9843 | 18.9843 | 18.9843 | 18.9843 | 2800.0 |
| 2014-04-10 07:17:00 | AAPL | Stock | 18.9929 | 19.0 | 18.9929 | 18.9964 | 126000.0 |
| 2014-04-10 07:18:00 | AAPL | Stock | 18.9964 | 18.9964 | 18.9964 | 18.9964 | 11480.0 |
| 2014-04-10 07:19:00 | AAPL | Stock | 18.9996 | 18.9996 | 18.9996 | 18.9996 | 19600.0 |
| 2014-04-10 07:21:00 | AAPL | Stock | 18.9964 | 18.9964 | 18.9964 | 18.9964 | 2800.0 |
| 2014-04-10 07:30:00 | AAPL | Stock | 19.0107 | 19.0196 | 19.0107 | 19.0196 | 19880.0 |
| 2014-04-10 07:31:00 | AAPL | Stock | 19.0111 | 19.0196 | 19.0111 | 19.0196 | 19880.0 |
| 2014-04-10 07:32:00 | AAPL | Stock | 19.0286 | 19.0357 | 19.0286 | 19.0357 | 14000.0 |
| 2014-04-10 07:35:00 | AAPL | Stock | 19.0364 | 19.0364 | 19.0318 | 19.0318 | 59920.0 |
| 2014-04-10 07:38:00 | AAPL | Stock | 19.0246 | 19.0268 | 19.0246 | 19.0268 | 8400.0 |
| 2014-04-10 07:40:00 | AAPL | Stock | 19.0125 | 19.0264 | 19.0121 | 19.0264 | 30016.0 |
| 2014-04-10 07:42:00 | AAPL | Stock | 19.0282 | 19.0286 | 19.0282 | 19.0286 | 28000.0 |
| 2014-04-10 07:44:00 | AAPL | Stock | 19.0182 | 19.0357 | 19.0182 | 19.0357 | 66164.0 |
| 2014-04-10 07:47:00 | AAPL | Stock | 19.0357 | 19.0464 | 19.0357 | 19.0464 | 23492.0 |
| 2014-04-10 07:48:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 8400.0 |
| 2014-04-10 07:50:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0093 | 19.0093 | 40600.0 |
| 2014-04-10 07:53:00 | AAPL | Stock | 19.0043 | 19.0179 | 19.0043 | 19.0179 | 26376.0 |
| 2014-04-10 07:55:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0193 | 19.0193 | 26376.0 |
| 2014-04-10 07:59:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0071 | 19.0179 | 25200.0 |
| 2014-04-10 08:00:00 | AAPL | Stock | 19.0036 | 19.0357 | 18.975 | 19.0 | 40460.0 |
| 2014-04-10 08:01:00 | AAPL | Stock | 18.99 | 18.99 | 18.9846 | 18.9846 | 16744.0 |
| 2014-04-10 08:02:00 | AAPL | Stock | 18.9821 | 18.9911 | 18.9786 | 18.9786 | 8400.0 |
| 2014-04-10 08:03:00 | AAPL | Stock | 18.9768 | 18.9893 | 18.9754 | 18.9893 | 28000.0 |
| 2014-04-10 08:04:00 | AAPL | Stock | 18.9861 | 18.9893 | 18.9861 | 18.9893 | 8400.0 |
| 2014-04-10 08:06:00 | AAPL | Stock | 19.0004 | 19.0004 | 18.9996 | 19.0004 | 14000.0 |
| 2014-04-10 08:07:00 | AAPL | Stock | 19.0 | 19.0068 | 19.0 | 19.0039 | 26880.0 |
| 2014-04-10 08:08:00 | AAPL | Stock | 19.0 | 19.0 | 18.9968 | 18.9968 | 19600.0 |
| 2014-04-10 08:09:00 | AAPL | Stock | 18.9996 | 18.9996 | 18.9996 | 18.9996 | 2800.0 |
| 2014-04-10 08:10:00 | AAPL | Stock | 19.0 | 19.0114 | 19.0 | 19.0114 | 14000.0 |
| 2014-04-10 08:11:00 | AAPL | Stock | 19.01 | 19.0114 | 19.0 | 19.005 | 61488.0 |
> showing 50 of 1,119,576 rows — these rows as CSV