PREVIEW / stock_5min / 2008-07-21
file: by_date/stock_5min/2008/2008-07-21.parquet size: 4.3 MB rows: 309,326 symbols: 3,327
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-21 05:25:00 | AAPL | Stock | 5.9161 | 5.9161 | 5.9161 | 5.9161 | 28000.0 |
| 2008-07-21 05:50:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9171 | 5.9171 | 8400.0 |
| 2008-07-21 06:45:00 | AAPL | Stock | 5.9271 | 5.9393 | 5.9271 | 5.9393 | 5600.0 |
| 2008-07-21 06:55:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 3360.0 |
| 2008-07-21 07:00:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 2800.0 |
| 2008-07-21 07:05:00 | AAPL | Stock | 5.95 | 5.9511 | 5.9464 | 5.9511 | 42280.0 |
| 2008-07-21 07:10:00 | AAPL | Stock | 5.9511 | 5.9511 | 5.9511 | 5.9511 | 2800.0 |
| 2008-07-21 07:15:00 | AAPL | Stock | 5.9525 | 5.9536 | 5.9525 | 5.9536 | 70000.0 |
| 2008-07-21 07:20:00 | AAPL | Stock | 5.9729 | 5.9729 | 5.9643 | 5.9643 | 54348.0 |
| 2008-07-21 07:25:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9539 | 5.9539 | 52920.0 |
| 2008-07-21 07:30:00 | AAPL | Stock | 5.9554 | 5.9643 | 5.9554 | 5.9561 | 50400.0 |
| 2008-07-21 07:35:00 | AAPL | Stock | 5.9564 | 5.9625 | 5.9564 | 5.9625 | 19040.0 |
| 2008-07-21 07:40:00 | AAPL | Stock | 5.9571 | 5.9621 | 5.9536 | 5.9536 | 134260.0 |
| 2008-07-21 07:45:00 | AAPL | Stock | 5.9421 | 5.9421 | 5.9393 | 5.9393 | 11200.0 |
| 2008-07-21 07:55:00 | AAPL | Stock | 5.9464 | 5.9514 | 5.9464 | 5.95 | 55860.0 |
| 2008-07-21 08:00:00 | AAPL | Stock | 5.9482 | 5.9536 | 5.9464 | 5.9514 | 892444.0 |
| 2008-07-21 08:05:00 | AAPL | Stock | 5.9525 | 5.9557 | 5.9486 | 5.9496 | 450100.0 |
| 2008-07-21 08:10:00 | AAPL | Stock | 5.9518 | 5.9554 | 5.95 | 5.9507 | 368088.0 |
| 2008-07-21 08:15:00 | AAPL | Stock | 5.9536 | 5.9571 | 5.9486 | 5.95 | 492408.0 |
| 2008-07-21 08:20:00 | AAPL | Stock | 5.95 | 5.95 | 5.9446 | 5.9464 | 725536.0 |
| 2008-07-21 08:25:00 | AAPL | Stock | 5.9464 | 5.9554 | 5.9457 | 5.9514 | 422856.0 |
| 2008-07-21 08:30:00 | AAPL | Stock | 5.95 | 5.9629 | 5.95 | 5.9625 | 1481256.0 |
| 2008-07-21 08:35:00 | AAPL | Stock | 5.9607 | 5.9643 | 5.9557 | 5.9557 | 579376.0 |
| 2008-07-21 08:40:00 | AAPL | Stock | 5.9564 | 5.9589 | 5.9482 | 5.9554 | 508200.0 |
| 2008-07-21 08:45:00 | AAPL | Stock | 5.9571 | 5.9589 | 5.9482 | 5.9557 | 647528.0 |
| 2008-07-21 08:50:00 | AAPL | Stock | 5.9586 | 5.9586 | 5.9504 | 5.9521 | 285880.0 |
| 2008-07-21 08:55:00 | AAPL | Stock | 5.9521 | 5.9554 | 5.9421 | 5.9518 | 771904.0 |
| 2008-07-21 09:00:00 | AAPL | Stock | 5.9518 | 5.9571 | 5.9464 | 5.9536 | 257320.0 |
| 2008-07-21 09:05:00 | AAPL | Stock | 5.9529 | 5.9539 | 5.9375 | 5.9393 | 1088080.0 |
| 2008-07-21 09:10:00 | AAPL | Stock | 5.9418 | 5.95 | 5.9411 | 5.9446 | 374444.0 |
| 2008-07-21 09:15:00 | AAPL | Stock | 5.9439 | 5.9457 | 5.9375 | 5.9436 | 633192.0 |
| 2008-07-21 09:20:00 | AAPL | Stock | 5.9429 | 5.9554 | 5.9289 | 5.9496 | 2204552.0 |
| 2008-07-21 09:25:00 | AAPL | Stock | 5.9496 | 5.9632 | 5.9468 | 5.9607 | 911652.0 |
| 2008-07-21 09:30:00 | AAPL | Stock | 5.9604 | 5.9618 | 5.9296 | 5.9464 | 19040924.0 |
| 2008-07-21 09:35:00 | AAPL | Stock | 5.9464 | 5.9821 | 5.9436 | 5.9571 | 25515840.0 |
| 2008-07-21 09:40:00 | AAPL | Stock | 5.9563 | 5.9582 | 5.9196 | 5.9286 | 19371716.0 |
| 2008-07-21 09:45:00 | AAPL | Stock | 5.9296 | 5.9339 | 5.9039 | 5.9089 | 16587088.0 |
| 2008-07-21 09:50:00 | AAPL | Stock | 5.9089 | 5.9164 | 5.8611 | 5.875 | 28969276.0 |
| 2008-07-21 09:55:00 | AAPL | Stock | 5.875 | 5.9104 | 5.8696 | 5.8929 | 15396472.0 |
| 2008-07-21 10:00:00 | AAPL | Stock | 5.8929 | 5.9046 | 5.875 | 5.8921 | 14481824.0 |
| 2008-07-21 10:05:00 | AAPL | Stock | 5.8921 | 5.8936 | 5.8661 | 5.8739 | 13413540.0 |
| 2008-07-21 10:10:00 | AAPL | Stock | 5.8754 | 5.8757 | 5.8432 | 5.8729 | 22766856.0 |
| 2008-07-21 10:15:00 | AAPL | Stock | 5.8725 | 5.875 | 5.8432 | 5.8736 | 16508996.0 |
| 2008-07-21 10:20:00 | AAPL | Stock | 5.8721 | 5.8736 | 5.8407 | 5.8441 | 11628568.0 |
| 2008-07-21 10:25:00 | AAPL | Stock | 5.8446 | 5.8818 | 5.8429 | 5.8632 | 13520276.0 |
| 2008-07-21 10:30:00 | AAPL | Stock | 5.8632 | 5.8768 | 5.8595 | 5.8721 | 7117880.0 |
| 2008-07-21 10:35:00 | AAPL | Stock | 5.8718 | 5.8932 | 5.8682 | 5.8904 | 12168968.0 |
| 2008-07-21 10:40:00 | AAPL | Stock | 5.8896 | 5.8921 | 5.8718 | 5.8723 | 6776868.0 |
| 2008-07-21 10:45:00 | AAPL | Stock | 5.8729 | 5.8821 | 5.8571 | 5.8754 | 9028992.0 |
| 2008-07-21 10:50:00 | AAPL | Stock | 5.8754 | 5.8759 | 5.8596 | 5.8675 | 5569200.0 |
> showing 50 of 309,326 rows — these rows as CSV