PREVIEW / stock_5min / 2010-01-06
file: by_date/stock_5min/2010/2010-01-06.parquet size: 4.8 MB rows: 331,452 symbols: 3,442
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-01-06 04:15:00 | AAPL | Stock | 7.6668 | 7.6696 | 7.6668 | 7.6696 | 5600.0 |
| 2010-01-06 04:30:00 | AAPL | Stock | 7.6714 | 7.6714 | 7.6714 | 7.6714 | 2800.0 |
| 2010-01-06 04:45:00 | AAPL | Stock | 7.6743 | 7.675 | 7.6743 | 7.675 | 5600.0 |
| 2010-01-06 06:00:00 | AAPL | Stock | 7.6782 | 7.6782 | 7.6782 | 7.6782 | 3584.0 |
| 2010-01-06 07:05:00 | AAPL | Stock | 7.6782 | 7.6782 | 7.675 | 7.675 | 8400.0 |
| 2010-01-06 07:10:00 | AAPL | Stock | 7.6746 | 7.6746 | 7.6714 | 7.6714 | 17668.0 |
| 2010-01-06 07:15:00 | AAPL | Stock | 7.6711 | 7.6711 | 7.6532 | 7.6536 | 32200.0 |
| 2010-01-06 07:20:00 | AAPL | Stock | 7.6571 | 7.6571 | 7.6571 | 7.6571 | 2800.0 |
| 2010-01-06 07:25:00 | AAPL | Stock | 7.6554 | 7.6554 | 7.6521 | 7.6521 | 19600.0 |
| 2010-01-06 07:30:00 | AAPL | Stock | 7.6518 | 7.6518 | 7.6518 | 7.6518 | 30800.0 |
| 2010-01-06 07:35:00 | AAPL | Stock | 7.6471 | 7.6471 | 7.6464 | 7.6464 | 32648.0 |
| 2010-01-06 07:40:00 | AAPL | Stock | 7.65 | 7.65 | 7.65 | 7.65 | 2800.0 |
| 2010-01-06 07:45:00 | AAPL | Stock | 7.65 | 7.65 | 7.65 | 7.65 | 2800.0 |
| 2010-01-06 07:50:00 | AAPL | Stock | 7.6611 | 7.6611 | 7.6611 | 7.6611 | 2800.0 |
| 2010-01-06 08:00:00 | AAPL | Stock | 7.6607 | 7.6629 | 7.6607 | 7.6629 | 58240.0 |
| 2010-01-06 08:05:00 | AAPL | Stock | 7.6568 | 7.6568 | 7.6554 | 7.6554 | 21700.0 |
| 2010-01-06 08:10:00 | AAPL | Stock | 7.6554 | 7.6589 | 7.6507 | 7.6589 | 81872.0 |
| 2010-01-06 08:15:00 | AAPL | Stock | 7.6554 | 7.6571 | 7.6536 | 7.6571 | 64372.0 |
| 2010-01-06 08:20:00 | AAPL | Stock | 7.6589 | 7.6607 | 7.6571 | 7.6589 | 81956.0 |
| 2010-01-06 08:25:00 | AAPL | Stock | 7.6589 | 7.6611 | 7.6589 | 7.6611 | 8400.0 |
| 2010-01-06 08:30:00 | AAPL | Stock | 7.6596 | 7.6596 | 7.6571 | 7.6571 | 47936.0 |
| 2010-01-06 08:35:00 | AAPL | Stock | 7.6621 | 7.6621 | 7.6604 | 7.6604 | 11900.0 |
| 2010-01-06 08:40:00 | AAPL | Stock | 7.66 | 7.6604 | 7.66 | 7.66 | 14028.0 |
| 2010-01-06 08:45:00 | AAPL | Stock | 7.6607 | 7.6629 | 7.6607 | 7.6629 | 22400.0 |
| 2010-01-06 08:50:00 | AAPL | Stock | 7.6639 | 7.6643 | 7.6607 | 7.6629 | 50400.0 |
| 2010-01-06 08:55:00 | AAPL | Stock | 7.6632 | 7.6696 | 7.6629 | 7.6679 | 102144.0 |
| 2010-01-06 09:00:00 | AAPL | Stock | 7.6682 | 7.6696 | 7.6671 | 7.6679 | 55804.0 |
| 2010-01-06 09:05:00 | AAPL | Stock | 7.6679 | 7.6679 | 7.6643 | 7.6643 | 68600.0 |
| 2010-01-06 09:10:00 | AAPL | Stock | 7.6661 | 7.6714 | 7.6625 | 7.6643 | 196980.0 |
| 2010-01-06 09:15:00 | AAPL | Stock | 7.6643 | 7.6661 | 7.6643 | 7.6661 | 8400.0 |
| 2010-01-06 09:20:00 | AAPL | Stock | 7.6629 | 7.6636 | 7.6571 | 7.6571 | 32676.0 |
| 2010-01-06 09:25:00 | AAPL | Stock | 7.66 | 7.6657 | 7.6518 | 7.6596 | 116480.0 |
| 2010-01-06 09:30:00 | AAPL | Stock | 7.6564 | 7.6721 | 7.6518 | 7.6671 | 13997228.0 |
| 2010-01-06 09:35:00 | AAPL | Stock | 7.6671 | 7.6868 | 7.6625 | 7.6693 | 13021120.0 |
| 2010-01-06 09:40:00 | AAPL | Stock | 7.6693 | 7.6733 | 7.6346 | 7.647 | 15001448.0 |
| 2010-01-06 09:45:00 | AAPL | Stock | 7.6468 | 7.6607 | 7.635 | 7.6582 | 9760912.0 |
| 2010-01-06 09:50:00 | AAPL | Stock | 7.6568 | 7.6643 | 7.6443 | 7.6639 | 9210796.0 |
| 2010-01-06 09:55:00 | AAPL | Stock | 7.6629 | 7.6661 | 7.6471 | 7.6536 | 5035212.0 |
| 2010-01-06 10:00:00 | AAPL | Stock | 7.6529 | 7.6711 | 7.6457 | 7.6671 | 8787632.0 |
| 2010-01-06 10:05:00 | AAPL | Stock | 7.6711 | 7.6736 | 7.6586 | 7.6714 | 8142708.0 |
| 2010-01-06 10:10:00 | AAPL | Stock | 7.6721 | 7.6729 | 7.6596 | 7.6646 | 5368188.0 |
| 2010-01-06 10:15:00 | AAPL | Stock | 7.6654 | 7.668 | 7.6607 | 7.6679 | 5394200.0 |
| 2010-01-06 10:20:00 | AAPL | Stock | 7.6675 | 7.6714 | 7.6568 | 7.6575 | 6912584.0 |
| 2010-01-06 10:25:00 | AAPL | Stock | 7.6589 | 7.6679 | 7.6536 | 7.655 | 8128960.0 |
| 2010-01-06 10:30:00 | AAPL | Stock | 7.6543 | 7.6696 | 7.6489 | 7.65 | 8867712.0 |
| 2010-01-06 10:35:00 | AAPL | Stock | 7.6511 | 7.6604 | 7.6489 | 7.6604 | 4871048.0 |
| 2010-01-06 10:40:00 | AAPL | Stock | 7.66 | 7.6643 | 7.6557 | 7.6593 | 3969532.0 |
| 2010-01-06 10:45:00 | AAPL | Stock | 7.6593 | 7.6636 | 7.6546 | 7.6586 | 4108384.0 |
| 2010-01-06 10:50:00 | AAPL | Stock | 7.6586 | 7.6646 | 7.6514 | 7.6521 | 5611060.0 |
| 2010-01-06 10:55:00 | AAPL | Stock | 7.6532 | 7.6679 | 7.6511 | 7.6661 | 4386228.0 |
> showing 50 of 331,452 rows — these rows as CSV