PREVIEW / stock_1min / 2013-08-22
file: by_date/stock_1min/2013/2013-08-22.parquet size: 10.8 MB rows: 783,657 symbols: 2,846
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-08-22 04:00:00 | AAPL | Stock | 17.9771 | 17.9771 | 17.9771 | 17.9771 | 2800.0 |
| 2013-08-22 04:01:00 | AAPL | Stock | 18.0304 | 18.0339 | 18.0304 | 18.0339 | 19600.0 |
| 2013-08-22 04:07:00 | AAPL | Stock | 18.0475 | 18.0475 | 18.0475 | 18.0475 | 4760.0 |
| 2013-08-22 04:45:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 2800.0 |
| 2013-08-22 05:19:00 | AAPL | Stock | 18.0225 | 18.0225 | 18.0225 | 18.0225 | 2800.0 |
| 2013-08-22 05:35:00 | AAPL | Stock | 18.0321 | 18.0321 | 18.0321 | 18.0321 | 2800.0 |
| 2013-08-22 05:52:00 | AAPL | Stock | 18.0268 | 18.0304 | 18.0268 | 18.0304 | 16800.0 |
| 2013-08-22 05:54:00 | AAPL | Stock | 18.0268 | 18.0268 | 18.0268 | 18.0268 | 4200.0 |
| 2013-08-22 06:32:00 | AAPL | Stock | 18.0311 | 18.0311 | 18.0311 | 18.0311 | 2800.0 |
| 2013-08-22 06:52:00 | AAPL | Stock | 18.0318 | 18.0318 | 18.0318 | 18.0318 | 2800.0 |
| 2013-08-22 06:55:00 | AAPL | Stock | 18.0321 | 18.0321 | 18.0321 | 18.0321 | 13272.0 |
| 2013-08-22 07:00:00 | AAPL | Stock | 18.0075 | 18.0075 | 18.0057 | 18.0057 | 13720.0 |
| 2013-08-22 07:01:00 | AAPL | Stock | 18.0043 | 18.0043 | 18.0036 | 18.0036 | 11200.0 |
| 2013-08-22 07:02:00 | AAPL | Stock | 18.0036 | 18.0036 | 17.9946 | 17.9946 | 22400.0 |
| 2013-08-22 07:10:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 12992.0 |
| 2013-08-22 07:13:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 14000.0 |
| 2013-08-22 07:15:00 | AAPL | Stock | 18.0129 | 18.0143 | 18.0125 | 18.0143 | 20132.0 |
| 2013-08-22 07:16:00 | AAPL | Stock | 18.0246 | 18.0268 | 18.0214 | 18.0214 | 21644.0 |
| 2013-08-22 07:17:00 | AAPL | Stock | 18.0179 | 18.0179 | 18.0179 | 18.0179 | 13776.0 |
| 2013-08-22 07:19:00 | AAPL | Stock | 18.0179 | 18.0179 | 18.0143 | 18.0143 | 8400.0 |
| 2013-08-22 07:20:00 | AAPL | Stock | 18.0071 | 18.0143 | 18.0071 | 18.0143 | 24640.0 |
| 2013-08-22 07:21:00 | AAPL | Stock | 18.0143 | 18.0143 | 18.0143 | 18.0143 | 2800.0 |
| 2013-08-22 07:24:00 | AAPL | Stock | 18.0211 | 18.0214 | 18.0211 | 18.0214 | 11200.0 |
| 2013-08-22 07:28:00 | AAPL | Stock | 18.0257 | 18.0257 | 18.0214 | 18.0214 | 16800.0 |
| 2013-08-22 07:29:00 | AAPL | Stock | 18.0214 | 18.0214 | 18.0214 | 18.0214 | 2800.0 |
| 2013-08-22 07:34:00 | AAPL | Stock | 18.0264 | 18.0307 | 18.0264 | 18.0307 | 5880.0 |
| 2013-08-22 07:44:00 | AAPL | Stock | 18.0282 | 18.0321 | 18.0282 | 18.0321 | 35560.0 |
| 2013-08-22 07:46:00 | AAPL | Stock | 18.0446 | 18.0564 | 18.0446 | 18.0561 | 30352.0 |
| 2013-08-22 07:47:00 | AAPL | Stock | 18.0571 | 18.0668 | 18.0571 | 18.0661 | 14000.0 |
| 2013-08-22 07:48:00 | AAPL | Stock | 18.0671 | 18.0671 | 18.0571 | 18.0571 | 68600.0 |
| 2013-08-22 07:51:00 | AAPL | Stock | 18.0511 | 18.0511 | 18.0511 | 18.0511 | 2800.0 |
| 2013-08-22 07:53:00 | AAPL | Stock | 18.05 | 18.05 | 18.05 | 18.05 | 2800.0 |
| 2013-08-22 07:57:00 | AAPL | Stock | 18.05 | 18.05 | 18.05 | 18.05 | 2800.0 |
| 2013-08-22 07:59:00 | AAPL | Stock | 18.05 | 18.0604 | 18.05 | 18.0604 | 14000.0 |
| 2013-08-22 08:00:00 | AAPL | Stock | 18.0571 | 18.0571 | 18.0179 | 18.0464 | 160748.0 |
| 2013-08-22 08:01:00 | AAPL | Stock | 18.0364 | 18.0364 | 18.0236 | 18.0236 | 41300.0 |
| 2013-08-22 08:02:00 | AAPL | Stock | 18.0321 | 18.0321 | 18.0257 | 18.0321 | 11200.0 |
| 2013-08-22 08:03:00 | AAPL | Stock | 18.0289 | 18.0289 | 18.0179 | 18.0179 | 53200.0 |
| 2013-08-22 08:04:00 | AAPL | Stock | 18.0214 | 18.0214 | 18.0143 | 18.0143 | 8820.0 |
| 2013-08-22 08:05:00 | AAPL | Stock | 18.0143 | 18.0143 | 18.0061 | 18.0061 | 30800.0 |
| 2013-08-22 08:06:00 | AAPL | Stock | 18.0139 | 18.025 | 18.0071 | 18.0071 | 73192.0 |
| 2013-08-22 08:07:00 | AAPL | Stock | 18.0079 | 18.0079 | 18.0043 | 18.0043 | 32508.0 |
| 2013-08-22 08:08:00 | AAPL | Stock | 18.0036 | 18.0036 | 17.9846 | 17.9864 | 30240.0 |
| 2013-08-22 08:11:00 | AAPL | Stock | 18.0007 | 18.0007 | 18.0007 | 18.0007 | 3780.0 |
| 2013-08-22 08:12:00 | AAPL | Stock | 18.0054 | 18.0089 | 18.0036 | 18.0089 | 27720.0 |
| 2013-08-22 08:13:00 | AAPL | Stock | 18.0089 | 18.0107 | 18.0032 | 18.0032 | 22092.0 |
| 2013-08-22 08:14:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 2800.0 |
| 2013-08-22 08:15:00 | AAPL | Stock | 17.9936 | 17.9936 | 17.9936 | 17.9936 | 2800.0 |
| 2013-08-22 08:17:00 | AAPL | Stock | 18.0011 | 18.0036 | 18.0011 | 18.0036 | 61320.0 |
| 2013-08-22 08:18:00 | AAPL | Stock | 18.0054 | 18.0157 | 18.0054 | 18.0107 | 42000.0 |
> showing 50 of 783,657 rows — these rows as CSV