PREVIEW / stock_5min / 2008-07-29
file: by_date/stock_5min/2008/2008-07-29.parquet size: 4.5 MB rows: 321,970 symbols: 3,325
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-07-29 07:15:00 | AAPL | Stock | 5.5357 | 5.5357 | 5.5186 | 5.535 | 16800.0 |
| 2008-07-29 07:20:00 | AAPL | Stock | 5.535 | 5.5357 | 5.535 | 5.5357 | 40740.0 |
| 2008-07-29 07:25:00 | AAPL | Stock | 5.5421 | 5.5421 | 5.5421 | 5.5421 | 13440.0 |
| 2008-07-29 07:30:00 | AAPL | Stock | 5.5446 | 5.5464 | 5.5446 | 5.5464 | 8400.0 |
| 2008-07-29 07:50:00 | AAPL | Stock | 5.5464 | 5.5464 | 5.5464 | 5.5464 | 39900.0 |
| 2008-07-29 07:55:00 | AAPL | Stock | 5.5464 | 5.5471 | 5.5464 | 5.5471 | 11900.0 |
| 2008-07-29 08:00:00 | AAPL | Stock | 5.5357 | 5.5464 | 5.5357 | 5.5429 | 236740.0 |
| 2008-07-29 08:05:00 | AAPL | Stock | 5.5432 | 5.5464 | 5.5361 | 5.5375 | 386204.0 |
| 2008-07-29 08:10:00 | AAPL | Stock | 5.5361 | 5.5429 | 5.5361 | 5.5414 | 94360.0 |
| 2008-07-29 08:15:00 | AAPL | Stock | 5.5393 | 5.5425 | 5.5393 | 5.5425 | 261100.0 |
| 2008-07-29 08:20:00 | AAPL | Stock | 5.5418 | 5.5418 | 5.5361 | 5.5361 | 121688.0 |
| 2008-07-29 08:25:00 | AAPL | Stock | 5.5393 | 5.5393 | 5.5361 | 5.5375 | 56756.0 |
| 2008-07-29 08:30:00 | AAPL | Stock | 5.5386 | 5.5443 | 5.535 | 5.5425 | 498232.0 |
| 2008-07-29 08:35:00 | AAPL | Stock | 5.5425 | 5.5532 | 5.5418 | 5.55 | 566692.0 |
| 2008-07-29 08:40:00 | AAPL | Stock | 5.5479 | 5.5536 | 5.5471 | 5.55 | 190204.0 |
| 2008-07-29 08:45:00 | AAPL | Stock | 5.55 | 5.5571 | 5.55 | 5.5571 | 226604.0 |
| 2008-07-29 08:50:00 | AAPL | Stock | 5.5554 | 5.5607 | 5.5521 | 5.5546 | 452312.0 |
| 2008-07-29 08:55:00 | AAPL | Stock | 5.5546 | 5.5546 | 5.5518 | 5.5536 | 140700.0 |
| 2008-07-29 09:00:00 | AAPL | Stock | 5.555 | 5.555 | 5.5536 | 5.555 | 57204.0 |
| 2008-07-29 09:05:00 | AAPL | Stock | 5.5568 | 5.5661 | 5.5568 | 5.5661 | 93800.0 |
| 2008-07-29 09:10:00 | AAPL | Stock | 5.5643 | 5.5646 | 5.5575 | 5.5625 | 243600.0 |
| 2008-07-29 09:15:00 | AAPL | Stock | 5.5618 | 5.5621 | 5.5479 | 5.5511 | 261800.0 |
| 2008-07-29 09:20:00 | AAPL | Stock | 5.5496 | 5.5536 | 5.5486 | 5.5486 | 40320.0 |
| 2008-07-29 09:25:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5375 | 5.5468 | 182000.0 |
| 2008-07-29 09:30:00 | AAPL | Stock | 5.5482 | 5.5714 | 5.5157 | 5.5229 | 24243352.0 |
| 2008-07-29 09:35:00 | AAPL | Stock | 5.5246 | 5.535 | 5.4875 | 5.5217 | 23629060.0 |
| 2008-07-29 09:40:00 | AAPL | Stock | 5.5221 | 5.5675 | 5.5221 | 5.5393 | 15858360.0 |
| 2008-07-29 09:45:00 | AAPL | Stock | 5.5389 | 5.5564 | 5.5171 | 5.5396 | 12110756.0 |
| 2008-07-29 09:50:00 | AAPL | Stock | 5.5411 | 5.5957 | 5.5404 | 5.5832 | 16481696.0 |
| 2008-07-29 09:55:00 | AAPL | Stock | 5.5832 | 5.5996 | 5.5654 | 5.5736 | 10561180.0 |
| 2008-07-29 10:00:00 | AAPL | Stock | 5.5736 | 5.6179 | 5.5725 | 5.6179 | 16203684.0 |
| 2008-07-29 10:05:00 | AAPL | Stock | 5.6179 | 5.6429 | 5.61 | 5.6336 | 20764380.0 |
| 2008-07-29 10:10:00 | AAPL | Stock | 5.6312 | 5.6496 | 5.6289 | 5.63 | 16276876.0 |
| 2008-07-29 10:15:00 | AAPL | Stock | 5.63 | 5.6521 | 5.63 | 5.6346 | 14867244.0 |
| 2008-07-29 10:20:00 | AAPL | Stock | 5.6375 | 5.6457 | 5.6232 | 5.6354 | 13195588.0 |
| 2008-07-29 10:25:00 | AAPL | Stock | 5.6363 | 5.6386 | 5.6146 | 5.6161 | 12661376.0 |
| 2008-07-29 10:30:00 | AAPL | Stock | 5.6161 | 5.6379 | 5.615 | 5.6336 | 11688376.0 |
| 2008-07-29 10:35:00 | AAPL | Stock | 5.6336 | 5.65 | 5.6321 | 5.6446 | 9377676.0 |
| 2008-07-29 10:40:00 | AAPL | Stock | 5.6446 | 5.6693 | 5.6443 | 5.665 | 15546692.0 |
| 2008-07-29 10:45:00 | AAPL | Stock | 5.665 | 5.6946 | 5.6586 | 5.6793 | 18475800.0 |
| 2008-07-29 10:50:00 | AAPL | Stock | 5.6796 | 5.6861 | 5.665 | 5.6732 | 12041120.0 |
| 2008-07-29 10:55:00 | AAPL | Stock | 5.6739 | 5.6829 | 5.6607 | 5.6675 | 7558768.0 |
| 2008-07-29 11:00:00 | AAPL | Stock | 5.6682 | 5.6714 | 5.6564 | 5.6632 | 5327364.0 |
| 2008-07-29 11:05:00 | AAPL | Stock | 5.6632 | 5.6696 | 5.6546 | 5.6593 | 5595436.0 |
| 2008-07-29 11:10:00 | AAPL | Stock | 5.6589 | 5.6782 | 5.6554 | 5.6736 | 5642728.0 |
| 2008-07-29 11:15:00 | AAPL | Stock | 5.6736 | 5.6829 | 5.6654 | 5.6754 | 7005208.0 |
| 2008-07-29 11:20:00 | AAPL | Stock | 5.6754 | 5.6771 | 5.6689 | 5.6707 | 5854380.0 |
| 2008-07-29 11:25:00 | AAPL | Stock | 5.6711 | 5.6768 | 5.6571 | 5.6632 | 5845952.0 |
| 2008-07-29 11:30:00 | AAPL | Stock | 5.6636 | 5.6675 | 5.6471 | 5.6586 | 6679204.0 |
| 2008-07-29 11:35:00 | AAPL | Stock | 5.6579 | 5.6618 | 5.6393 | 5.6543 | 8372700.0 |
> showing 50 of 321,970 rows — these rows as CSV