PREVIEW / stock_5min / 2008-02-12
file: by_date/stock_5min/2008/2008-02-12.parquet size: 4.3 MB rows: 318,172 symbols: 3,284
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-02-12 05:00:00 | AAPL | Stock | 4.6418 | 4.6418 | 4.6418 | 4.6418 | 2800.0 |
| 2008-02-12 05:30:00 | AAPL | Stock | 4.6418 | 4.6429 | 4.6418 | 4.6429 | 8400.0 |
| 2008-02-12 06:05:00 | AAPL | Stock | 4.6439 | 4.6439 | 4.6439 | 4.6439 | 19600.0 |
| 2008-02-12 06:15:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 8400.0 |
| 2008-02-12 06:20:00 | AAPL | Stock | 4.6639 | 4.6639 | 4.6525 | 4.6525 | 5600.0 |
| 2008-02-12 06:25:00 | AAPL | Stock | 4.6729 | 4.6729 | 4.6529 | 4.6529 | 29960.0 |
| 2008-02-12 06:35:00 | AAPL | Stock | 4.6539 | 4.6782 | 4.6539 | 4.6782 | 28000.0 |
| 2008-02-12 06:40:00 | AAPL | Stock | 4.6757 | 4.6757 | 4.6757 | 4.6757 | 8400.0 |
| 2008-02-12 06:50:00 | AAPL | Stock | 4.6643 | 4.6643 | 4.6643 | 4.6643 | 14000.0 |
| 2008-02-12 06:55:00 | AAPL | Stock | 4.6714 | 4.6714 | 4.6714 | 4.6714 | 5600.0 |
| 2008-02-12 07:00:00 | AAPL | Stock | 4.6643 | 4.6732 | 4.6643 | 4.6732 | 22400.0 |
| 2008-02-12 07:10:00 | AAPL | Stock | 4.6736 | 4.6786 | 4.6736 | 4.6786 | 36400.0 |
| 2008-02-12 07:15:00 | AAPL | Stock | 4.6736 | 4.6786 | 4.6661 | 4.6786 | 56420.0 |
| 2008-02-12 07:20:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6696 | 4.6696 | 2800.0 |
| 2008-02-12 07:25:00 | AAPL | Stock | 4.6679 | 4.6714 | 4.6643 | 4.6714 | 107800.0 |
| 2008-02-12 07:30:00 | AAPL | Stock | 4.6511 | 4.6511 | 4.6511 | 4.6511 | 2800.0 |
| 2008-02-12 07:35:00 | AAPL | Stock | 4.6679 | 4.6679 | 4.6668 | 4.6679 | 21980.0 |
| 2008-02-12 07:40:00 | AAPL | Stock | 4.66 | 4.6625 | 4.66 | 4.6625 | 33600.0 |
| 2008-02-12 07:45:00 | AAPL | Stock | 4.6589 | 4.6607 | 4.6482 | 4.6607 | 64400.0 |
| 2008-02-12 07:50:00 | AAPL | Stock | 4.6521 | 4.6571 | 4.6521 | 4.6554 | 82320.0 |
| 2008-02-12 07:55:00 | AAPL | Stock | 4.6536 | 4.6589 | 4.6536 | 4.6589 | 17360.0 |
| 2008-02-12 08:00:00 | AAPL | Stock | 4.6529 | 4.6654 | 4.6429 | 4.6646 | 985236.0 |
| 2008-02-12 08:05:00 | AAPL | Stock | 4.6639 | 4.6732 | 4.6607 | 4.6607 | 1268708.0 |
| 2008-02-12 08:10:00 | AAPL | Stock | 4.6607 | 4.6693 | 4.6593 | 4.6643 | 466536.0 |
| 2008-02-12 08:15:00 | AAPL | Stock | 4.6643 | 4.6696 | 4.6643 | 4.6696 | 345520.0 |
| 2008-02-12 08:20:00 | AAPL | Stock | 4.6675 | 4.6739 | 4.6643 | 4.6714 | 544740.0 |
| 2008-02-12 08:25:00 | AAPL | Stock | 4.6696 | 4.675 | 4.6679 | 4.6729 | 670936.0 |
| 2008-02-12 08:30:00 | AAPL | Stock | 4.6736 | 4.6754 | 4.6679 | 4.67 | 498120.0 |
| 2008-02-12 08:35:00 | AAPL | Stock | 4.6714 | 4.675 | 4.6714 | 4.6743 | 119504.0 |
| 2008-02-12 08:40:00 | AAPL | Stock | 4.6746 | 4.675 | 4.6679 | 4.6679 | 275912.0 |
| 2008-02-12 08:45:00 | AAPL | Stock | 4.6661 | 4.6746 | 4.6643 | 4.6696 | 238896.0 |
| 2008-02-12 08:50:00 | AAPL | Stock | 4.6714 | 4.6714 | 4.6682 | 4.6696 | 110992.0 |
| 2008-02-12 08:55:00 | AAPL | Stock | 4.6696 | 4.6732 | 4.6696 | 4.6704 | 158928.0 |
| 2008-02-12 09:00:00 | AAPL | Stock | 4.6704 | 4.6704 | 4.6643 | 4.6643 | 301728.0 |
| 2008-02-12 09:05:00 | AAPL | Stock | 4.6643 | 4.6693 | 4.6643 | 4.6664 | 99260.0 |
| 2008-02-12 09:10:00 | AAPL | Stock | 4.6661 | 4.6668 | 4.6643 | 4.6661 | 455784.0 |
| 2008-02-12 09:15:00 | AAPL | Stock | 4.665 | 4.6664 | 4.6607 | 4.6611 | 365400.0 |
| 2008-02-12 09:20:00 | AAPL | Stock | 4.6618 | 4.6618 | 4.6525 | 4.6596 | 1072652.0 |
| 2008-02-12 09:25:00 | AAPL | Stock | 4.6596 | 4.675 | 4.6579 | 4.6679 | 1733340.0 |
| 2008-02-12 09:30:00 | AAPL | Stock | 4.6682 | 4.6786 | 4.6536 | 4.6696 | 40929840.0 |
| 2008-02-12 09:35:00 | AAPL | Stock | 4.6696 | 4.6707 | 4.6429 | 4.6475 | 29033004.0 |
| 2008-02-12 09:40:00 | AAPL | Stock | 4.6475 | 4.66 | 4.6393 | 4.6532 | 25034184.0 |
| 2008-02-12 09:45:00 | AAPL | Stock | 4.6532 | 4.6682 | 4.6518 | 4.6564 | 20867448.0 |
| 2008-02-12 09:50:00 | AAPL | Stock | 4.6564 | 4.6593 | 4.6296 | 4.6296 | 25755660.0 |
| 2008-02-12 09:55:00 | AAPL | Stock | 4.6304 | 4.6375 | 4.6071 | 4.6071 | 31220476.0 |
| 2008-02-12 10:00:00 | AAPL | Stock | 4.6071 | 4.6332 | 4.605 | 4.6314 | 27403096.0 |
| 2008-02-12 10:05:00 | AAPL | Stock | 4.6318 | 4.6321 | 4.5882 | 4.5968 | 32195716.0 |
| 2008-02-12 10:10:00 | AAPL | Stock | 4.5968 | 4.6093 | 4.5832 | 4.5911 | 33048904.0 |
| 2008-02-12 10:15:00 | AAPL | Stock | 4.5911 | 4.6029 | 4.5811 | 4.5936 | 26590004.0 |
| 2008-02-12 10:20:00 | AAPL | Stock | 4.5937 | 4.5979 | 4.5829 | 4.5925 | 17261692.0 |
> showing 50 of 318,172 rows — these rows as CSV