PREVIEW / stock_5min / 2010-12-07
file: by_date/stock_5min/2010/2010-12-07.parquet size: 5.0 MB rows: 344,128 symbols: 3,536
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-07 04:45:00 | AAPL | Stock | 11.4993 | 11.4993 | 11.4993 | 11.4993 | 8400.0 |
| 2010-12-07 04:50:00 | AAPL | Stock | 11.5025 | 11.5025 | 11.5025 | 11.5025 | 2800.0 |
| 2010-12-07 05:15:00 | AAPL | Stock | 11.5464 | 11.5464 | 11.5464 | 11.5464 | 2800.0 |
| 2010-12-07 05:20:00 | AAPL | Stock | 11.5411 | 11.5411 | 11.5411 | 11.5411 | 2800.0 |
| 2010-12-07 06:00:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 2800.0 |
| 2010-12-07 06:30:00 | AAPL | Stock | 11.5343 | 11.5346 | 11.5343 | 11.5346 | 5600.0 |
| 2010-12-07 06:45:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5171 | 11.5179 | 8400.0 |
| 2010-12-07 06:55:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 2800.0 |
| 2010-12-07 07:00:00 | AAPL | Stock | 11.5179 | 11.5357 | 11.5179 | 11.5357 | 74900.0 |
| 2010-12-07 07:05:00 | AAPL | Stock | 11.5393 | 11.5536 | 11.5393 | 11.5396 | 27300.0 |
| 2010-12-07 07:10:00 | AAPL | Stock | 11.5396 | 11.5571 | 11.5396 | 11.5536 | 441952.0 |
| 2010-12-07 07:15:00 | AAPL | Stock | 11.5439 | 11.5439 | 11.5439 | 11.5439 | 16800.0 |
| 2010-12-07 07:20:00 | AAPL | Stock | 11.5375 | 11.5493 | 11.5343 | 11.5493 | 34636.0 |
| 2010-12-07 07:25:00 | AAPL | Stock | 11.5361 | 11.5361 | 11.5254 | 11.5293 | 58800.0 |
| 2010-12-07 07:30:00 | AAPL | Stock | 11.5354 | 11.5429 | 11.5293 | 11.5346 | 52472.0 |
| 2010-12-07 07:35:00 | AAPL | Stock | 11.5354 | 11.5393 | 11.5275 | 11.5389 | 44800.0 |
| 2010-12-07 07:40:00 | AAPL | Stock | 11.5357 | 11.5382 | 11.5357 | 11.5357 | 59080.0 |
| 2010-12-07 07:45:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5318 | 11.5357 | 104748.0 |
| 2010-12-07 07:50:00 | AAPL | Stock | 11.5321 | 11.5357 | 11.5257 | 11.5357 | 133000.0 |
| 2010-12-07 07:55:00 | AAPL | Stock | 11.5361 | 11.5429 | 11.5361 | 11.5368 | 28000.0 |
| 2010-12-07 08:00:00 | AAPL | Stock | 11.5407 | 11.5411 | 11.5179 | 11.5346 | 1298332.0 |
| 2010-12-07 08:05:00 | AAPL | Stock | 11.5339 | 11.5375 | 11.5307 | 11.5354 | 446348.0 |
| 2010-12-07 08:10:00 | AAPL | Stock | 11.5354 | 11.5357 | 11.5318 | 11.5354 | 247268.0 |
| 2010-12-07 08:15:00 | AAPL | Stock | 11.5354 | 11.5418 | 11.5329 | 11.5411 | 221508.0 |
| 2010-12-07 08:20:00 | AAPL | Stock | 11.5386 | 11.5443 | 11.5336 | 11.5418 | 707140.0 |
| 2010-12-07 08:25:00 | AAPL | Stock | 11.5432 | 11.5532 | 11.5432 | 11.5482 | 250908.0 |
| 2010-12-07 08:30:00 | AAPL | Stock | 11.5496 | 11.5536 | 11.5436 | 11.5529 | 604296.0 |
| 2010-12-07 08:35:00 | AAPL | Stock | 11.5521 | 11.5554 | 11.5446 | 11.5486 | 313292.0 |
| 2010-12-07 08:40:00 | AAPL | Stock | 11.5468 | 11.5482 | 11.5446 | 11.5482 | 212884.0 |
| 2010-12-07 08:45:00 | AAPL | Stock | 11.5511 | 11.5589 | 11.5486 | 11.5525 | 528836.0 |
| 2010-12-07 08:50:00 | AAPL | Stock | 11.5557 | 11.5582 | 11.5554 | 11.5561 | 112504.0 |
| 2010-12-07 08:55:00 | AAPL | Stock | 11.5554 | 11.5589 | 11.5546 | 11.5568 | 172536.0 |
| 2010-12-07 09:00:00 | AAPL | Stock | 11.5564 | 11.5607 | 11.5543 | 11.5593 | 435624.0 |
| 2010-12-07 09:05:00 | AAPL | Stock | 11.5586 | 11.5593 | 11.5479 | 11.5482 | 345156.0 |
| 2010-12-07 09:10:00 | AAPL | Stock | 11.5482 | 11.5607 | 11.5446 | 11.555 | 565544.0 |
| 2010-12-07 09:15:00 | AAPL | Stock | 11.5571 | 11.5607 | 11.5364 | 11.5571 | 629944.0 |
| 2010-12-07 09:20:00 | AAPL | Stock | 11.5611 | 11.5661 | 11.5593 | 11.5614 | 321972.0 |
| 2010-12-07 09:25:00 | AAPL | Stock | 11.5614 | 11.5689 | 11.5571 | 11.5643 | 365428.0 |
| 2010-12-07 09:30:00 | AAPL | Stock | 11.5636 | 11.5711 | 11.5179 | 11.5218 | 22590792.0 |
| 2010-12-07 09:35:00 | AAPL | Stock | 11.5221 | 11.5343 | 11.5136 | 11.5275 | 12135368.0 |
| 2010-12-07 09:40:00 | AAPL | Stock | 11.5275 | 11.5521 | 11.5259 | 11.5357 | 15099252.0 |
| 2010-12-07 09:45:00 | AAPL | Stock | 11.5371 | 11.5379 | 11.5179 | 11.5286 | 7093688.0 |
| 2010-12-07 09:50:00 | AAPL | Stock | 11.5296 | 11.5389 | 11.505 | 11.5075 | 9043132.0 |
| 2010-12-07 09:55:00 | AAPL | Stock | 11.5091 | 11.5282 | 11.5072 | 11.5168 | 5908084.0 |
| 2010-12-07 10:00:00 | AAPL | Stock | 11.5164 | 11.5193 | 11.4932 | 11.5025 | 9148076.0 |
| 2010-12-07 10:05:00 | AAPL | Stock | 11.5025 | 11.5082 | 11.4686 | 11.4796 | 8762208.0 |
| 2010-12-07 10:10:00 | AAPL | Stock | 11.4768 | 11.4964 | 11.4682 | 11.4936 | 8034628.0 |
| 2010-12-07 10:15:00 | AAPL | Stock | 11.4929 | 11.5114 | 11.4893 | 11.5054 | 5669468.0 |
| 2010-12-07 10:20:00 | AAPL | Stock | 11.5082 | 11.5089 | 11.4918 | 11.495 | 3406116.0 |
| 2010-12-07 10:25:00 | AAPL | Stock | 11.4961 | 11.4979 | 11.4739 | 11.4745 | 4958856.0 |
> showing 50 of 344,128 rows — these rows as CSV