PREVIEW / stock_5min / 2008-10-20
file: by_date/stock_5min/2008/2008-10-20.parquet size: 4.4 MB rows: 316,018 symbols: 3,342
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-20 05:20:00 | AAPL | Stock | 3.555 | 3.5796 | 3.555 | 3.5796 | 11480.0 |
| 2008-10-20 05:35:00 | AAPL | Stock | 3.5939 | 3.5939 | 3.5939 | 3.5939 | 8372.0 |
| 2008-10-20 06:10:00 | AAPL | Stock | 3.6068 | 3.6068 | 3.6068 | 3.6068 | 2800.0 |
| 2008-10-20 06:40:00 | AAPL | Stock | 3.5929 | 3.5929 | 3.5929 | 3.5929 | 2800.0 |
| 2008-10-20 06:50:00 | AAPL | Stock | 3.5614 | 3.5614 | 3.5614 | 3.5614 | 11200.0 |
| 2008-10-20 06:55:00 | AAPL | Stock | 3.5668 | 3.5714 | 3.5668 | 3.5714 | 32200.0 |
| 2008-10-20 07:00:00 | AAPL | Stock | 3.5793 | 3.5929 | 3.5793 | 3.58 | 20748.0 |
| 2008-10-20 07:05:00 | AAPL | Stock | 3.58 | 3.6071 | 3.58 | 3.6071 | 43652.0 |
| 2008-10-20 07:10:00 | AAPL | Stock | 3.575 | 3.575 | 3.5714 | 3.5714 | 17052.0 |
| 2008-10-20 07:15:00 | AAPL | Stock | 3.5786 | 3.5893 | 3.5714 | 3.5714 | 66388.0 |
| 2008-10-20 07:20:00 | AAPL | Stock | 3.5661 | 3.5661 | 3.5593 | 3.5593 | 36400.0 |
| 2008-10-20 07:25:00 | AAPL | Stock | 3.5607 | 3.5679 | 3.5607 | 3.5679 | 5600.0 |
| 2008-10-20 07:30:00 | AAPL | Stock | 3.5539 | 3.5539 | 3.5525 | 3.5536 | 41720.0 |
| 2008-10-20 07:35:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5446 | 3.5446 | 56700.0 |
| 2008-10-20 07:40:00 | AAPL | Stock | 3.5375 | 3.5446 | 3.5375 | 3.5446 | 26600.0 |
| 2008-10-20 07:45:00 | AAPL | Stock | 3.5482 | 3.5786 | 3.5482 | 3.5593 | 63000.0 |
| 2008-10-20 07:50:00 | AAPL | Stock | 3.5561 | 3.5561 | 3.5446 | 3.5457 | 54600.0 |
| 2008-10-20 07:55:00 | AAPL | Stock | 3.5464 | 3.5464 | 3.5464 | 3.5464 | 8400.0 |
| 2008-10-20 08:00:00 | AAPL | Stock | 3.5568 | 3.5689 | 3.5368 | 3.5614 | 705824.0 |
| 2008-10-20 08:05:00 | AAPL | Stock | 3.5604 | 3.5604 | 3.5454 | 3.5493 | 701960.0 |
| 2008-10-20 08:10:00 | AAPL | Stock | 3.5475 | 3.55 | 3.5411 | 3.5446 | 204876.0 |
| 2008-10-20 08:15:00 | AAPL | Stock | 3.5475 | 3.5625 | 3.5436 | 3.5511 | 336616.0 |
| 2008-10-20 08:20:00 | AAPL | Stock | 3.5504 | 3.5546 | 3.5486 | 3.5493 | 91252.0 |
| 2008-10-20 08:25:00 | AAPL | Stock | 3.5489 | 3.5625 | 3.5418 | 3.5482 | 293384.0 |
| 2008-10-20 08:30:00 | AAPL | Stock | 3.5482 | 3.5532 | 3.5482 | 3.5529 | 32200.0 |
| 2008-10-20 08:35:00 | AAPL | Stock | 3.5532 | 3.5675 | 3.5532 | 3.5621 | 201824.0 |
| 2008-10-20 08:40:00 | AAPL | Stock | 3.5604 | 3.5625 | 3.5557 | 3.5561 | 64036.0 |
| 2008-10-20 08:45:00 | AAPL | Stock | 3.5554 | 3.5621 | 3.5554 | 3.5589 | 139468.0 |
| 2008-10-20 08:50:00 | AAPL | Stock | 3.5575 | 3.5643 | 3.5571 | 3.5643 | 142940.0 |
| 2008-10-20 08:55:00 | AAPL | Stock | 3.5643 | 3.5643 | 3.5525 | 3.5571 | 430892.0 |
| 2008-10-20 09:00:00 | AAPL | Stock | 3.5579 | 3.5589 | 3.54 | 3.5493 | 490560.0 |
| 2008-10-20 09:05:00 | AAPL | Stock | 3.5479 | 3.5518 | 3.5464 | 3.5504 | 323624.0 |
| 2008-10-20 09:10:00 | AAPL | Stock | 3.5518 | 3.5582 | 3.5504 | 3.5582 | 627760.0 |
| 2008-10-20 09:15:00 | AAPL | Stock | 3.5575 | 3.5593 | 3.5564 | 3.5589 | 265272.0 |
| 2008-10-20 09:20:00 | AAPL | Stock | 3.5593 | 3.5593 | 3.5536 | 3.5543 | 419440.0 |
| 2008-10-20 09:25:00 | AAPL | Stock | 3.5546 | 3.5714 | 3.5546 | 3.5643 | 1357748.0 |
| 2008-10-20 09:30:00 | AAPL | Stock | 3.5632 | 3.5725 | 3.5289 | 3.5421 | 41866020.0 |
| 2008-10-20 09:35:00 | AAPL | Stock | 3.5425 | 3.5464 | 3.5075 | 3.5307 | 35883316.0 |
| 2008-10-20 09:40:00 | AAPL | Stock | 3.5307 | 3.5429 | 3.49 | 3.5025 | 32896024.0 |
| 2008-10-20 09:45:00 | AAPL | Stock | 3.5021 | 3.5257 | 3.4804 | 3.5079 | 24217340.0 |
| 2008-10-20 09:50:00 | AAPL | Stock | 3.5079 | 3.5196 | 3.4689 | 3.4775 | 36297380.0 |
| 2008-10-20 09:55:00 | AAPL | Stock | 3.4775 | 3.5068 | 3.4643 | 3.475 | 34434204.0 |
| 2008-10-20 10:00:00 | AAPL | Stock | 3.475 | 3.5121 | 3.4671 | 3.4679 | 33228244.0 |
| 2008-10-20 10:05:00 | AAPL | Stock | 3.4689 | 3.5 | 3.4625 | 3.4911 | 41215076.0 |
| 2008-10-20 10:10:00 | AAPL | Stock | 3.4868 | 3.5007 | 3.4393 | 3.4568 | 40240144.0 |
| 2008-10-20 10:15:00 | AAPL | Stock | 3.4568 | 3.4693 | 3.4307 | 3.4318 | 30527420.0 |
| 2008-10-20 10:20:00 | AAPL | Stock | 3.4325 | 3.4529 | 3.4204 | 3.4293 | 23873696.0 |
| 2008-10-20 10:25:00 | AAPL | Stock | 3.4293 | 3.4429 | 3.3964 | 3.4025 | 25407648.0 |
| 2008-10-20 10:30:00 | AAPL | Stock | 3.4036 | 3.4281 | 3.3993 | 3.4218 | 23155832.0 |
| 2008-10-20 10:35:00 | AAPL | Stock | 3.4218 | 3.4375 | 3.4121 | 3.4246 | 18935224.0 |
> showing 50 of 316,018 rows — these rows as CSV