PREVIEW / stock_1min / 2013-11-04
file: by_date/stock_1min/2013/2013-11-04.parquet size: 14.6 MB rows: 1,069,219 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 |
|---|---|---|---|---|---|---|---|
| 2013-11-04 04:00:00 | AAPL | Stock | 18.5771 | 18.5771 | 18.575 | 18.575 | 16800.0 |
| 2013-11-04 04:39:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 2800.0 |
| 2013-11-04 04:40:00 | AAPL | Stock | 18.6089 | 18.6089 | 18.6089 | 18.6089 | 12852.0 |
| 2013-11-04 04:41:00 | AAPL | Stock | 18.6196 | 18.6196 | 18.6196 | 18.6196 | 5040.0 |
| 2013-11-04 05:17:00 | AAPL | Stock | 18.6214 | 18.6214 | 18.6196 | 18.6196 | 8400.0 |
| 2013-11-04 05:29:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 5600.0 |
| 2013-11-04 05:43:00 | AAPL | Stock | 18.6589 | 18.6589 | 18.6589 | 18.6589 | 3920.0 |
| 2013-11-04 06:27:00 | AAPL | Stock | 18.6518 | 18.6518 | 18.6518 | 18.6518 | 8400.0 |
| 2013-11-04 07:02:00 | AAPL | Stock | 18.6196 | 18.6196 | 18.6071 | 18.6071 | 40684.0 |
| 2013-11-04 07:03:00 | AAPL | Stock | 18.6068 | 18.6068 | 18.5961 | 18.5961 | 33320.0 |
| 2013-11-04 07:08:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 7728.0 |
| 2013-11-04 07:09:00 | AAPL | Stock | 18.5964 | 18.5964 | 18.5964 | 18.5964 | 2800.0 |
| 2013-11-04 07:11:00 | AAPL | Stock | 18.5964 | 18.5964 | 18.5964 | 18.5964 | 2800.0 |
| 2013-11-04 07:18:00 | AAPL | Stock | 18.6032 | 18.6032 | 18.6032 | 18.6032 | 15400.0 |
| 2013-11-04 07:19:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 2800.0 |
| 2013-11-04 07:20:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 8176.0 |
| 2013-11-04 07:21:00 | AAPL | Stock | 18.6071 | 18.6161 | 18.6071 | 18.6161 | 25424.0 |
| 2013-11-04 07:27:00 | AAPL | Stock | 18.6143 | 18.6161 | 18.6143 | 18.6161 | 46340.0 |
| 2013-11-04 07:29:00 | AAPL | Stock | 18.6214 | 18.6289 | 18.6214 | 18.6289 | 21700.0 |
| 2013-11-04 07:36:00 | AAPL | Stock | 18.6289 | 18.6289 | 18.6289 | 18.6289 | 5600.0 |
| 2013-11-04 07:37:00 | AAPL | Stock | 18.6389 | 18.6425 | 18.6389 | 18.6425 | 29848.0 |
| 2013-11-04 07:42:00 | AAPL | Stock | 18.6214 | 18.6214 | 18.6214 | 18.6214 | 10920.0 |
| 2013-11-04 07:47:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 8400.0 |
| 2013-11-04 07:48:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6321 | 18.6321 | 11200.0 |
| 2013-11-04 07:50:00 | AAPL | Stock | 18.6218 | 18.6218 | 18.6218 | 18.6218 | 5600.0 |
| 2013-11-04 07:52:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 2800.0 |
| 2013-11-04 07:54:00 | AAPL | Stock | 18.6214 | 18.6214 | 18.6214 | 18.6214 | 5600.0 |
| 2013-11-04 07:56:00 | AAPL | Stock | 18.6214 | 18.6214 | 18.6214 | 18.6214 | 2800.0 |
| 2013-11-04 08:00:00 | AAPL | Stock | 18.6386 | 18.6425 | 18.5721 | 18.6125 | 186228.0 |
| 2013-11-04 08:02:00 | AAPL | Stock | 18.5964 | 18.5964 | 18.5929 | 18.5929 | 11060.0 |
| 2013-11-04 08:03:00 | AAPL | Stock | 18.5789 | 18.5789 | 18.5789 | 18.5789 | 5600.0 |
| 2013-11-04 08:04:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 5600.0 |
| 2013-11-04 08:05:00 | AAPL | Stock | 18.5893 | 18.5929 | 18.5893 | 18.5911 | 21000.0 |
| 2013-11-04 08:06:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 5544.0 |
| 2013-11-04 08:07:00 | AAPL | Stock | 18.5925 | 18.5925 | 18.5825 | 18.5825 | 17948.0 |
| 2013-11-04 08:08:00 | AAPL | Stock | 18.5789 | 18.5789 | 18.5789 | 18.5789 | 5320.0 |
| 2013-11-04 08:09:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 4200.0 |
| 2013-11-04 08:10:00 | AAPL | Stock | 18.5839 | 18.5893 | 18.5839 | 18.5857 | 16968.0 |
| 2013-11-04 08:11:00 | AAPL | Stock | 18.5893 | 18.5929 | 18.5893 | 18.5929 | 28000.0 |
| 2013-11-04 08:12:00 | AAPL | Stock | 18.5964 | 18.5964 | 18.5893 | 18.5893 | 26376.0 |
| 2013-11-04 08:13:00 | AAPL | Stock | 18.5964 | 18.5964 | 18.5893 | 18.5893 | 88760.0 |
| 2013-11-04 08:14:00 | AAPL | Stock | 18.5929 | 18.5964 | 18.5929 | 18.5964 | 20664.0 |
| 2013-11-04 08:15:00 | AAPL | Stock | 18.5996 | 18.6 | 18.59 | 18.59 | 22904.0 |
| 2013-11-04 08:16:00 | AAPL | Stock | 18.5982 | 18.6036 | 18.5982 | 18.6 | 60200.0 |
| 2013-11-04 08:17:00 | AAPL | Stock | 18.5904 | 18.5904 | 18.5896 | 18.5904 | 11200.0 |
| 2013-11-04 08:18:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 9100.0 |
| 2013-11-04 08:19:00 | AAPL | Stock | 18.6029 | 18.6032 | 18.5893 | 18.5893 | 19600.0 |
| 2013-11-04 08:20:00 | AAPL | Stock | 18.5911 | 18.6 | 18.5911 | 18.6 | 19600.0 |
| 2013-11-04 08:22:00 | AAPL | Stock | 18.5982 | 18.5982 | 18.5982 | 18.5982 | 27188.0 |
| 2013-11-04 08:23:00 | AAPL | Stock | 18.5989 | 18.6 | 18.5989 | 18.6 | 28000.0 |
> showing 50 of 1,069,219 rows — these rows as CSV