PREVIEW / stock_1min / 2011-03-02
file: by_date/stock_1min/2011/2011-03-02.parquet size: 13.6 MB rows: 1,024,554 symbols: 2,856
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-02 04:06:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-03-02 04:22:00 | AAPL | Stock | 12.4907 | 12.4907 | 12.4907 | 12.4907 | 2800.0 |
| 2011-03-02 04:23:00 | AAPL | Stock | 12.4907 | 12.4907 | 12.4907 | 12.4907 | 2800.0 |
| 2011-03-02 05:03:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 2800.0 |
| 2011-03-02 05:24:00 | AAPL | Stock | 12.5218 | 12.5218 | 12.5218 | 12.5218 | 2800.0 |
| 2011-03-02 05:25:00 | AAPL | Stock | 12.5232 | 12.5232 | 12.5232 | 12.5232 | 2800.0 |
| 2011-03-02 05:33:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 11200.0 |
| 2011-03-02 05:35:00 | AAPL | Stock | 12.5475 | 12.55 | 12.5475 | 12.55 | 11200.0 |
| 2011-03-02 05:36:00 | AAPL | Stock | 12.5725 | 12.5725 | 12.5714 | 12.5714 | 16800.0 |
| 2011-03-02 05:56:00 | AAPL | Stock | 12.5346 | 12.5346 | 12.5343 | 12.5343 | 5600.0 |
| 2011-03-02 06:44:00 | AAPL | Stock | 12.5139 | 12.5139 | 12.5139 | 12.5139 | 2800.0 |
| 2011-03-02 06:54:00 | AAPL | Stock | 12.5343 | 12.5343 | 12.5343 | 12.5343 | 2800.0 |
| 2011-03-02 07:01:00 | AAPL | Stock | 12.5071 | 12.5146 | 12.5071 | 12.5146 | 5600.0 |
| 2011-03-02 07:02:00 | AAPL | Stock | 12.5179 | 12.5357 | 12.5179 | 12.5357 | 11200.0 |
| 2011-03-02 07:03:00 | AAPL | Stock | 12.5157 | 12.5189 | 12.5157 | 12.5175 | 8400.0 |
| 2011-03-02 07:04:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 2800.0 |
| 2011-03-02 07:05:00 | AAPL | Stock | 12.525 | 12.525 | 12.5214 | 12.5214 | 8400.0 |
| 2011-03-02 07:06:00 | AAPL | Stock | 12.5179 | 12.5179 | 12.5139 | 12.5139 | 11200.0 |
| 2011-03-02 07:07:00 | AAPL | Stock | 12.5107 | 12.5107 | 12.5004 | 12.5004 | 18760.0 |
| 2011-03-02 07:09:00 | AAPL | Stock | 12.5104 | 12.5107 | 12.5104 | 12.5107 | 37800.0 |
| 2011-03-02 07:10:00 | AAPL | Stock | 12.5107 | 12.5107 | 12.5107 | 12.5107 | 2800.0 |
| 2011-03-02 07:11:00 | AAPL | Stock | 12.5107 | 12.5107 | 12.5107 | 12.5107 | 5040.0 |
| 2011-03-02 07:17:00 | AAPL | Stock | 12.5154 | 12.5154 | 12.5154 | 12.5154 | 5432.0 |
| 2011-03-02 07:19:00 | AAPL | Stock | 12.5107 | 12.5107 | 12.5107 | 12.5107 | 4200.0 |
| 2011-03-02 07:22:00 | AAPL | Stock | 12.5243 | 12.5243 | 12.5232 | 12.5232 | 5600.0 |
| 2011-03-02 07:26:00 | AAPL | Stock | 12.5236 | 12.5264 | 12.5236 | 12.5264 | 14000.0 |
| 2011-03-02 07:28:00 | AAPL | Stock | 12.5257 | 12.5357 | 12.5257 | 12.5357 | 30800.0 |
| 2011-03-02 07:30:00 | AAPL | Stock | 12.5264 | 12.5264 | 12.5264 | 12.5264 | 2800.0 |
| 2011-03-02 07:35:00 | AAPL | Stock | 12.5264 | 12.5264 | 12.5264 | 12.5264 | 2800.0 |
| 2011-03-02 07:37:00 | AAPL | Stock | 12.5307 | 12.5307 | 12.5214 | 12.5214 | 5600.0 |
| 2011-03-02 07:38:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 11200.0 |
| 2011-03-02 07:48:00 | AAPL | Stock | 12.5261 | 12.5264 | 12.5261 | 12.5264 | 19600.0 |
| 2011-03-02 07:49:00 | AAPL | Stock | 12.5264 | 12.5264 | 12.5261 | 12.5261 | 136500.0 |
| 2011-03-02 07:51:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 2800.0 |
| 2011-03-02 07:54:00 | AAPL | Stock | 12.5268 | 12.5268 | 12.5268 | 12.5268 | 19320.0 |
| 2011-03-02 07:56:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 14728.0 |
| 2011-03-02 07:57:00 | AAPL | Stock | 12.5382 | 12.55 | 12.5382 | 12.5429 | 11200.0 |
| 2011-03-02 07:58:00 | AAPL | Stock | 12.5493 | 12.55 | 12.5493 | 12.55 | 16800.0 |
| 2011-03-02 08:00:00 | AAPL | Stock | 12.5379 | 12.5379 | 12.5357 | 12.5357 | 47208.0 |
| 2011-03-02 08:01:00 | AAPL | Stock | 12.5286 | 12.5286 | 12.5268 | 12.5268 | 83720.0 |
| 2011-03-02 08:02:00 | AAPL | Stock | 12.5214 | 12.5621 | 12.5179 | 12.5296 | 105504.0 |
| 2011-03-02 08:05:00 | AAPL | Stock | 12.5404 | 12.5404 | 12.535 | 12.535 | 12600.0 |
| 2011-03-02 08:06:00 | AAPL | Stock | 12.535 | 12.5393 | 12.535 | 12.5357 | 33320.0 |
| 2011-03-02 08:07:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 29596.0 |
| 2011-03-02 08:08:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 2800.0 |
| 2011-03-02 08:09:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5275 | 12.5275 | 125720.0 |
| 2011-03-02 08:10:00 | AAPL | Stock | 12.5343 | 12.5357 | 12.5343 | 12.5357 | 12040.0 |
| 2011-03-02 08:11:00 | AAPL | Stock | 12.5346 | 12.5346 | 12.5246 | 12.5246 | 10164.0 |
| 2011-03-02 08:12:00 | AAPL | Stock | 12.5204 | 12.5204 | 12.5204 | 12.5204 | 2800.0 |
| 2011-03-02 08:14:00 | AAPL | Stock | 12.5232 | 12.5339 | 12.5232 | 12.5336 | 17584.0 |
> showing 50 of 1,024,554 rows — these rows as CSV