PREVIEW / stock_5min / 2008-08-08
file: by_date/stock_5min/2008/2008-08-08.parquet size: 4.5 MB rows: 323,104 symbols: 3,341
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-08-08 06:35:00 | AAPL | Stock | 5.8607 | 5.8607 | 5.8571 | 5.8571 | 10584.0 |
| 2008-08-08 07:00:00 | AAPL | Stock | 5.9061 | 5.9061 | 5.9061 | 5.9061 | 3500.0 |
| 2008-08-08 07:15:00 | AAPL | Stock | 5.8982 | 5.8982 | 5.8982 | 5.8982 | 2800.0 |
| 2008-08-08 07:40:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.8679 | 5.8679 | 64400.0 |
| 2008-08-08 07:45:00 | AAPL | Stock | 5.8618 | 5.8618 | 5.8571 | 5.8607 | 182280.0 |
| 2008-08-08 07:50:00 | AAPL | Stock | 5.8607 | 5.8607 | 5.86 | 5.86 | 8120.0 |
| 2008-08-08 07:55:00 | AAPL | Stock | 5.85 | 5.85 | 5.85 | 5.85 | 2800.0 |
| 2008-08-08 08:00:00 | AAPL | Stock | 5.8543 | 5.865 | 5.8507 | 5.8607 | 154756.0 |
| 2008-08-08 08:05:00 | AAPL | Stock | 5.8629 | 5.8664 | 5.8629 | 5.8664 | 59808.0 |
| 2008-08-08 08:10:00 | AAPL | Stock | 5.8643 | 5.8643 | 5.8629 | 5.8629 | 16800.0 |
| 2008-08-08 08:15:00 | AAPL | Stock | 5.8664 | 5.8675 | 5.8643 | 5.8643 | 171724.0 |
| 2008-08-08 08:20:00 | AAPL | Stock | 5.8614 | 5.8614 | 5.8571 | 5.8607 | 192948.0 |
| 2008-08-08 08:25:00 | AAPL | Stock | 5.8571 | 5.8607 | 5.8539 | 5.8554 | 287028.0 |
| 2008-08-08 08:30:00 | AAPL | Stock | 5.8536 | 5.8625 | 5.8536 | 5.8614 | 269444.0 |
| 2008-08-08 08:35:00 | AAPL | Stock | 5.86 | 5.86 | 5.8571 | 5.8593 | 92400.0 |
| 2008-08-08 08:40:00 | AAPL | Stock | 5.8654 | 5.8711 | 5.8618 | 5.8661 | 207256.0 |
| 2008-08-08 08:45:00 | AAPL | Stock | 5.8639 | 5.8682 | 5.8611 | 5.8682 | 74060.0 |
| 2008-08-08 08:50:00 | AAPL | Stock | 5.8679 | 5.8679 | 5.8679 | 5.8679 | 2800.0 |
| 2008-08-08 08:55:00 | AAPL | Stock | 5.8689 | 5.8689 | 5.8661 | 5.8679 | 127428.0 |
| 2008-08-08 09:00:00 | AAPL | Stock | 5.8664 | 5.8679 | 5.8643 | 5.8664 | 375032.0 |
| 2008-08-08 09:05:00 | AAPL | Stock | 5.8679 | 5.8693 | 5.8629 | 5.8675 | 271600.0 |
| 2008-08-08 09:10:00 | AAPL | Stock | 5.8679 | 5.8679 | 5.8571 | 5.8571 | 369236.0 |
| 2008-08-08 09:15:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8525 | 5.8529 | 70000.0 |
| 2008-08-08 09:20:00 | AAPL | Stock | 5.85 | 5.8529 | 5.8496 | 5.8496 | 63700.0 |
| 2008-08-08 09:25:00 | AAPL | Stock | 5.8486 | 5.8568 | 5.845 | 5.8482 | 596820.0 |
| 2008-08-08 09:30:00 | AAPL | Stock | 5.8482 | 5.8875 | 5.8482 | 5.8825 | 17296188.0 |
| 2008-08-08 09:35:00 | AAPL | Stock | 5.8829 | 5.9196 | 5.8786 | 5.9143 | 17584784.0 |
| 2008-08-08 09:40:00 | AAPL | Stock | 5.9143 | 5.9232 | 5.8821 | 5.9172 | 20380752.0 |
| 2008-08-08 09:45:00 | AAPL | Stock | 5.92 | 5.9314 | 5.9036 | 5.93 | 16477720.0 |
| 2008-08-08 09:50:00 | AAPL | Stock | 5.93 | 5.9475 | 5.9275 | 5.9411 | 17291008.0 |
| 2008-08-08 09:55:00 | AAPL | Stock | 5.9418 | 5.9532 | 5.9371 | 5.945 | 13988716.0 |
| 2008-08-08 10:00:00 | AAPL | Stock | 5.9446 | 5.9554 | 5.9404 | 5.9475 | 14816816.0 |
| 2008-08-08 10:05:00 | AAPL | Stock | 5.9482 | 5.9693 | 5.9375 | 5.9689 | 19459552.0 |
| 2008-08-08 10:10:00 | AAPL | Stock | 5.9693 | 5.9725 | 5.9571 | 5.9586 | 13463464.0 |
| 2008-08-08 10:15:00 | AAPL | Stock | 5.9582 | 5.9704 | 5.9482 | 5.9561 | 12123748.0 |
| 2008-08-08 10:20:00 | AAPL | Stock | 5.9564 | 5.9689 | 5.9468 | 5.9608 | 10615976.0 |
| 2008-08-08 10:25:00 | AAPL | Stock | 5.9607 | 5.9636 | 5.9518 | 5.9607 | 6957860.0 |
| 2008-08-08 10:30:00 | AAPL | Stock | 5.9611 | 5.9639 | 5.9507 | 5.9536 | 11666508.0 |
| 2008-08-08 10:35:00 | AAPL | Stock | 5.9539 | 5.9675 | 5.9514 | 5.9579 | 8352624.0 |
| 2008-08-08 10:40:00 | AAPL | Stock | 5.9579 | 5.9689 | 5.9571 | 5.9614 | 7937272.0 |
| 2008-08-08 10:45:00 | AAPL | Stock | 5.9604 | 5.9668 | 5.9543 | 5.9621 | 6130292.0 |
| 2008-08-08 10:50:00 | AAPL | Stock | 5.9614 | 5.9714 | 5.9532 | 5.96 | 6098848.0 |
| 2008-08-08 10:55:00 | AAPL | Stock | 5.9607 | 5.9636 | 5.9439 | 5.953 | 9268784.0 |
| 2008-08-08 11:00:00 | AAPL | Stock | 5.9532 | 5.9586 | 5.9411 | 5.9586 | 7352324.0 |
| 2008-08-08 11:05:00 | AAPL | Stock | 5.9586 | 5.9586 | 5.9486 | 5.9557 | 5834220.0 |
| 2008-08-08 11:10:00 | AAPL | Stock | 5.9557 | 5.9775 | 5.9536 | 5.9734 | 13539624.0 |
| 2008-08-08 11:15:00 | AAPL | Stock | 5.9736 | 5.9804 | 5.9696 | 5.9786 | 7698012.0 |
| 2008-08-08 11:20:00 | AAPL | Stock | 5.9789 | 5.9821 | 5.9679 | 5.9707 | 6857648.0 |
| 2008-08-08 11:25:00 | AAPL | Stock | 5.9707 | 5.9857 | 5.9686 | 5.9789 | 8925560.0 |
| 2008-08-08 11:30:00 | AAPL | Stock | 5.9789 | 5.99 | 5.9732 | 5.9889 | 7606396.0 |
> showing 50 of 323,104 rows — these rows as CSV