PREVIEW / stock_1min / 2012-03-29
file: by_date/stock_1min/2012/2012-03-29.parquet size: 12.9 MB rows: 959,932 symbols: 2,862
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-29 04:03:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 26600.0 |
| 2012-03-29 04:07:00 | AAPL | Stock | 22.0979 | 22.0979 | 22.0979 | 22.0979 | 11200.0 |
| 2012-03-29 04:10:00 | AAPL | Stock | 22.0857 | 22.0857 | 22.0857 | 22.0857 | 4200.0 |
| 2012-03-29 04:43:00 | AAPL | Stock | 22.0718 | 22.0718 | 22.0718 | 22.0718 | 2800.0 |
| 2012-03-29 05:07:00 | AAPL | Stock | 22.0536 | 22.0536 | 22.0464 | 22.0464 | 26012.0 |
| 2012-03-29 05:09:00 | AAPL | Stock | 22.0464 | 22.0464 | 22.0464 | 22.0464 | 11200.0 |
| 2012-03-29 05:21:00 | AAPL | Stock | 22.0429 | 22.0429 | 22.0429 | 22.0429 | 14000.0 |
| 2012-03-29 05:30:00 | AAPL | Stock | 22.0446 | 22.0446 | 22.0446 | 22.0446 | 14000.0 |
| 2012-03-29 05:31:00 | AAPL | Stock | 22.0411 | 22.0411 | 22.0411 | 22.0411 | 5600.0 |
| 2012-03-29 06:02:00 | AAPL | Stock | 22.0229 | 22.0229 | 22.0229 | 22.0229 | 2800.0 |
| 2012-03-29 06:03:00 | AAPL | Stock | 22.0182 | 22.0182 | 22.0182 | 22.0182 | 12600.0 |
| 2012-03-29 06:04:00 | AAPL | Stock | 22.0164 | 22.0164 | 22.0107 | 22.0107 | 5600.0 |
| 2012-03-29 06:05:00 | AAPL | Stock | 22.0164 | 22.0164 | 22.0164 | 22.0164 | 4200.0 |
| 2012-03-29 06:06:00 | AAPL | Stock | 22.0164 | 22.0164 | 22.0164 | 22.0164 | 5600.0 |
| 2012-03-29 06:16:00 | AAPL | Stock | 22.0093 | 22.0093 | 22.0093 | 22.0093 | 5600.0 |
| 2012-03-29 06:28:00 | AAPL | Stock | 22.0004 | 22.0004 | 22.0004 | 22.0004 | 2800.0 |
| 2012-03-29 06:32:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 8400.0 |
| 2012-03-29 06:33:00 | AAPL | Stock | 22.0321 | 22.0321 | 22.0321 | 22.0321 | 2800.0 |
| 2012-03-29 06:37:00 | AAPL | Stock | 22.025 | 22.025 | 22.025 | 22.025 | 5600.0 |
| 2012-03-29 07:00:00 | AAPL | Stock | 22.0143 | 22.0143 | 22.0036 | 22.0036 | 11200.0 |
| 2012-03-29 07:01:00 | AAPL | Stock | 22.0175 | 22.0175 | 22.01 | 22.01 | 8960.0 |
| 2012-03-29 07:05:00 | AAPL | Stock | 22.0193 | 22.0193 | 22.0193 | 22.0193 | 28000.0 |
| 2012-03-29 07:06:00 | AAPL | Stock | 22.0304 | 22.0304 | 22.0304 | 22.0304 | 2800.0 |
| 2012-03-29 07:07:00 | AAPL | Stock | 22.0161 | 22.0161 | 22.0161 | 22.0161 | 8400.0 |
| 2012-03-29 07:13:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 20720.0 |
| 2012-03-29 07:19:00 | AAPL | Stock | 22.0086 | 22.0086 | 22.0086 | 22.0086 | 2800.0 |
| 2012-03-29 07:20:00 | AAPL | Stock | 22.0075 | 22.0075 | 22.0075 | 22.0075 | 14000.0 |
| 2012-03-29 07:28:00 | AAPL | Stock | 22.0139 | 22.0139 | 22.0139 | 22.0139 | 2800.0 |
| 2012-03-29 07:30:00 | AAPL | Stock | 22.0161 | 22.0179 | 22.0161 | 22.0179 | 21980.0 |
| 2012-03-29 07:31:00 | AAPL | Stock | 22.0179 | 22.0264 | 22.0179 | 22.0264 | 17640.0 |
| 2012-03-29 07:32:00 | AAPL | Stock | 22.0186 | 22.0325 | 22.0186 | 22.0321 | 19600.0 |
| 2012-03-29 07:34:00 | AAPL | Stock | 22.0268 | 22.0268 | 22.0268 | 22.0268 | 2800.0 |
| 2012-03-29 07:35:00 | AAPL | Stock | 22.0268 | 22.0268 | 22.0268 | 22.0268 | 2800.0 |
| 2012-03-29 07:37:00 | AAPL | Stock | 22.0268 | 22.0268 | 22.0268 | 22.0268 | 16800.0 |
| 2012-03-29 07:38:00 | AAPL | Stock | 22.0268 | 22.0304 | 22.0268 | 22.0271 | 47600.0 |
| 2012-03-29 07:39:00 | AAPL | Stock | 22.0271 | 22.0357 | 22.0271 | 22.0357 | 110600.0 |
| 2012-03-29 07:40:00 | AAPL | Stock | 22.0404 | 22.0404 | 22.0361 | 22.0361 | 5600.0 |
| 2012-03-29 07:41:00 | AAPL | Stock | 22.0429 | 22.0429 | 22.0429 | 22.0429 | 11200.0 |
| 2012-03-29 07:43:00 | AAPL | Stock | 22.0357 | 22.04 | 22.0357 | 22.04 | 22400.0 |
| 2012-03-29 07:45:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-03-29 07:46:00 | AAPL | Stock | 22.0386 | 22.0386 | 22.0386 | 22.0386 | 5600.0 |
| 2012-03-29 07:48:00 | AAPL | Stock | 22.0321 | 22.0357 | 22.0321 | 22.0357 | 14000.0 |
| 2012-03-29 07:49:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-03-29 07:51:00 | AAPL | Stock | 22.0271 | 22.0271 | 22.0271 | 22.0271 | 2800.0 |
| 2012-03-29 07:52:00 | AAPL | Stock | 22.0271 | 22.0271 | 22.0271 | 22.0271 | 2800.0 |
| 2012-03-29 07:53:00 | AAPL | Stock | 22.0354 | 22.0357 | 22.0354 | 22.0357 | 28000.0 |
| 2012-03-29 07:55:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 4284.0 |
| 2012-03-29 07:57:00 | AAPL | Stock | 22.0354 | 22.0357 | 22.0346 | 22.0346 | 19600.0 |
| 2012-03-29 08:00:00 | AAPL | Stock | 22.0311 | 22.0357 | 22.0268 | 22.0332 | 342272.0 |
| 2012-03-29 08:01:00 | AAPL | Stock | 22.0321 | 22.035 | 22.0321 | 22.035 | 8400.0 |
> showing 50 of 959,932 rows — these rows as CSV