PREVIEW / stock_5min / 2010-12-21
file: by_date/stock_5min/2010/2010-12-21.parquet size: 4.9 MB rows: 338,944 symbols: 3,546
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-21 04:00:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-21 06:25:00 | AAPL | Stock | 11.5139 | 11.5139 | 11.5139 | 11.5139 | 2800.0 |
| 2010-12-21 07:05:00 | AAPL | Stock | 11.5243 | 11.5268 | 11.5243 | 11.5268 | 33600.0 |
| 2010-12-21 07:10:00 | AAPL | Stock | 11.5279 | 11.55 | 11.5279 | 11.55 | 47600.0 |
| 2010-12-21 07:15:00 | AAPL | Stock | 11.5386 | 11.5386 | 11.5386 | 11.5386 | 2800.0 |
| 2010-12-21 07:20:00 | AAPL | Stock | 11.5364 | 11.5457 | 11.5364 | 11.5446 | 30800.0 |
| 2010-12-21 07:25:00 | AAPL | Stock | 11.5525 | 11.5589 | 11.5525 | 11.5589 | 40600.0 |
| 2010-12-21 07:30:00 | AAPL | Stock | 11.555 | 11.555 | 11.555 | 11.555 | 5600.0 |
| 2010-12-21 07:35:00 | AAPL | Stock | 11.5536 | 11.5625 | 11.5536 | 11.5596 | 69944.0 |
| 2010-12-21 07:40:00 | AAPL | Stock | 11.5514 | 11.5571 | 11.5482 | 11.5568 | 43540.0 |
| 2010-12-21 07:45:00 | AAPL | Stock | 11.5568 | 11.5568 | 11.5536 | 11.5543 | 36400.0 |
| 2010-12-21 07:50:00 | AAPL | Stock | 11.5568 | 11.5639 | 11.5568 | 11.5639 | 119980.0 |
| 2010-12-21 07:55:00 | AAPL | Stock | 11.5621 | 11.5632 | 11.5621 | 11.5632 | 8400.0 |
| 2010-12-21 08:00:00 | AAPL | Stock | 11.5575 | 11.5589 | 11.5357 | 11.5414 | 667044.0 |
| 2010-12-21 08:05:00 | AAPL | Stock | 11.54 | 11.5486 | 11.5393 | 11.5486 | 242760.0 |
| 2010-12-21 08:10:00 | AAPL | Stock | 11.5464 | 11.55 | 11.545 | 11.5482 | 148820.0 |
| 2010-12-21 08:15:00 | AAPL | Stock | 11.5493 | 11.5554 | 11.5493 | 11.5536 | 246512.0 |
| 2010-12-21 08:20:00 | AAPL | Stock | 11.5546 | 11.5571 | 11.5536 | 11.5554 | 133000.0 |
| 2010-12-21 08:25:00 | AAPL | Stock | 11.5546 | 11.5557 | 11.5532 | 11.5546 | 138320.0 |
| 2010-12-21 08:30:00 | AAPL | Stock | 11.5554 | 11.5568 | 11.5468 | 11.5468 | 439908.0 |
| 2010-12-21 08:35:00 | AAPL | Stock | 11.5471 | 11.5514 | 11.5446 | 11.5457 | 370972.0 |
| 2010-12-21 08:40:00 | AAPL | Stock | 11.5493 | 11.55 | 11.5464 | 11.5464 | 71960.0 |
| 2010-12-21 08:45:00 | AAPL | Stock | 11.5468 | 11.5468 | 11.5382 | 11.5382 | 61992.0 |
| 2010-12-21 08:50:00 | AAPL | Stock | 11.5382 | 11.5396 | 11.5343 | 11.5396 | 162512.0 |
| 2010-12-21 08:55:00 | AAPL | Stock | 11.5379 | 11.5379 | 11.5261 | 11.5339 | 374584.0 |
| 2010-12-21 09:00:00 | AAPL | Stock | 11.5336 | 11.5339 | 11.5286 | 11.5329 | 78400.0 |
| 2010-12-21 09:05:00 | AAPL | Stock | 11.5321 | 11.5336 | 11.5293 | 11.5307 | 57400.0 |
| 2010-12-21 09:10:00 | AAPL | Stock | 11.5332 | 11.5332 | 11.5257 | 11.5296 | 184660.0 |
| 2010-12-21 09:15:00 | AAPL | Stock | 11.5286 | 11.5357 | 11.5275 | 11.5336 | 238952.0 |
| 2010-12-21 09:20:00 | AAPL | Stock | 11.5336 | 11.5357 | 11.5336 | 11.5354 | 59444.0 |
| 2010-12-21 09:25:00 | AAPL | Stock | 11.5354 | 11.5429 | 11.5354 | 11.5357 | 195720.0 |
| 2010-12-21 09:30:00 | AAPL | Stock | 11.5361 | 11.5429 | 11.5082 | 11.5093 | 11338068.0 |
| 2010-12-21 09:35:00 | AAPL | Stock | 11.5121 | 11.5318 | 11.5018 | 11.5263 | 6502720.0 |
| 2010-12-21 09:40:00 | AAPL | Stock | 11.53 | 11.5625 | 11.525 | 11.5532 | 12011748.0 |
| 2010-12-21 09:45:00 | AAPL | Stock | 11.55 | 11.5671 | 11.5386 | 11.5421 | 8724548.0 |
| 2010-12-21 09:50:00 | AAPL | Stock | 11.5418 | 11.5586 | 11.5364 | 11.5368 | 6352780.0 |
| 2010-12-21 09:55:00 | AAPL | Stock | 11.5382 | 11.5471 | 11.5275 | 11.5289 | 5745376.0 |
| 2010-12-21 10:00:00 | AAPL | Stock | 11.5304 | 11.5421 | 11.5286 | 11.53 | 4363828.0 |
| 2010-12-21 10:05:00 | AAPL | Stock | 11.5318 | 11.5404 | 11.5304 | 11.5382 | 3017224.0 |
| 2010-12-21 10:10:00 | AAPL | Stock | 11.5389 | 11.5411 | 11.5321 | 11.537 | 3406396.0 |
| 2010-12-21 10:15:00 | AAPL | Stock | 11.5357 | 11.5536 | 11.535 | 11.5507 | 3529652.0 |
| 2010-12-21 10:20:00 | AAPL | Stock | 11.5518 | 11.5714 | 11.55 | 11.5596 | 7793856.0 |
| 2010-12-21 10:25:00 | AAPL | Stock | 11.5621 | 11.5679 | 11.5561 | 11.5643 | 3227980.0 |
| 2010-12-21 10:30:00 | AAPL | Stock | 11.5661 | 11.5679 | 11.5625 | 11.565 | 2321032.0 |
| 2010-12-21 10:35:00 | AAPL | Stock | 11.5654 | 11.5768 | 11.5632 | 11.5768 | 5801544.0 |
| 2010-12-21 10:40:00 | AAPL | Stock | 11.5739 | 11.5804 | 11.5654 | 11.5693 | 5831336.0 |
| 2010-12-21 10:45:00 | AAPL | Stock | 11.5668 | 11.5689 | 11.5593 | 11.5615 | 2849084.0 |
| 2010-12-21 10:50:00 | AAPL | Stock | 11.5629 | 11.5704 | 11.5579 | 11.5661 | 2690632.0 |
| 2010-12-21 10:55:00 | AAPL | Stock | 11.5661 | 11.57 | 11.5618 | 11.5639 | 1729448.0 |
| 2010-12-21 11:00:00 | AAPL | Stock | 11.5654 | 11.5679 | 11.5589 | 11.56 | 1741040.0 |
> showing 50 of 338,944 rows — these rows as CSV