PREVIEW / stock_5min / 2006-06-19
file: by_date/stock_5min/2006/2006-06-19.parquet size: 3.2 MB rows: 232,053 symbols: 2,292
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-19 06:30:00 | AAPL | Stock | 2.0625 | 2.0625 | 2.0625 | 2.0625 | 2800.0 |
| 2006-06-19 06:55:00 | AAPL | Stock | 2.0625 | 2.0625 | 2.0625 | 2.0625 | 16800.0 |
| 2006-06-19 07:50:00 | AAPL | Stock | 2.0679 | 2.0696 | 2.0679 | 2.0696 | 25200.0 |
| 2006-06-19 08:00:00 | AAPL | Stock | 2.0682 | 2.0718 | 2.0643 | 2.07 | 456708.0 |
| 2006-06-19 08:05:00 | AAPL | Stock | 2.0707 | 2.0743 | 2.0707 | 2.0714 | 427000.0 |
| 2006-06-19 08:10:00 | AAPL | Stock | 2.0714 | 2.0714 | 2.0679 | 2.0679 | 157892.0 |
| 2006-06-19 08:15:00 | AAPL | Stock | 2.0661 | 2.0696 | 2.0661 | 2.0664 | 133448.0 |
| 2006-06-19 08:20:00 | AAPL | Stock | 2.0664 | 2.0693 | 2.0664 | 2.0693 | 18760.0 |
| 2006-06-19 08:25:00 | AAPL | Stock | 2.0679 | 2.0696 | 2.0671 | 2.0696 | 104300.0 |
| 2006-06-19 08:30:00 | AAPL | Stock | 2.0696 | 2.0696 | 2.0671 | 2.0671 | 22400.0 |
| 2006-06-19 08:35:00 | AAPL | Stock | 2.0693 | 2.0693 | 2.0693 | 2.0693 | 2800.0 |
| 2006-06-19 08:40:00 | AAPL | Stock | 2.0696 | 2.0714 | 2.0693 | 2.0696 | 170660.0 |
| 2006-06-19 08:45:00 | AAPL | Stock | 2.0679 | 2.0679 | 2.0671 | 2.0671 | 89936.0 |
| 2006-06-19 08:50:00 | AAPL | Stock | 2.0671 | 2.0675 | 2.0668 | 2.0668 | 41300.0 |
| 2006-06-19 08:55:00 | AAPL | Stock | 2.0679 | 2.0689 | 2.0668 | 2.0668 | 99400.0 |
| 2006-06-19 09:00:00 | AAPL | Stock | 2.0671 | 2.0675 | 2.0654 | 2.0661 | 54096.0 |
| 2006-06-19 09:05:00 | AAPL | Stock | 2.0671 | 2.0679 | 2.0671 | 2.0679 | 23520.0 |
| 2006-06-19 09:10:00 | AAPL | Stock | 2.0679 | 2.0679 | 2.0675 | 2.0675 | 29372.0 |
| 2006-06-19 09:15:00 | AAPL | Stock | 2.0661 | 2.0661 | 2.0646 | 2.0646 | 30800.0 |
| 2006-06-19 09:20:00 | AAPL | Stock | 2.065 | 2.0675 | 2.0643 | 2.0643 | 218512.0 |
| 2006-06-19 09:25:00 | AAPL | Stock | 2.0629 | 2.0675 | 2.0629 | 2.0675 | 291200.0 |
| 2006-06-19 09:30:00 | AAPL | Stock | 2.0654 | 2.0732 | 2.0586 | 2.0693 | 18978708.0 |
| 2006-06-19 09:35:00 | AAPL | Stock | 2.0696 | 2.0779 | 2.0689 | 2.0689 | 16234680.0 |
| 2006-06-19 09:40:00 | AAPL | Stock | 2.0689 | 2.0707 | 2.0646 | 2.0657 | 10803296.0 |
| 2006-06-19 09:45:00 | AAPL | Stock | 2.0657 | 2.0668 | 2.0532 | 2.0621 | 17307556.0 |
| 2006-06-19 09:50:00 | AAPL | Stock | 2.0621 | 2.0646 | 2.0546 | 2.0611 | 14034048.0 |
| 2006-06-19 09:55:00 | AAPL | Stock | 2.0614 | 2.0632 | 2.0486 | 2.06 | 17962840.0 |
| 2006-06-19 10:00:00 | AAPL | Stock | 2.0604 | 2.0614 | 2.0532 | 2.0611 | 14912576.0 |
| 2006-06-19 10:05:00 | AAPL | Stock | 2.0611 | 2.0632 | 2.0564 | 2.0568 | 8832488.0 |
| 2006-06-19 10:10:00 | AAPL | Stock | 2.0571 | 2.0586 | 2.0518 | 2.0564 | 9783592.0 |
| 2006-06-19 10:15:00 | AAPL | Stock | 2.0568 | 2.0575 | 2.0461 | 2.0493 | 13997536.0 |
| 2006-06-19 10:20:00 | AAPL | Stock | 2.0493 | 2.0518 | 2.0407 | 2.0411 | 15441524.0 |
| 2006-06-19 10:25:00 | AAPL | Stock | 2.0414 | 2.0457 | 2.0386 | 2.0457 | 10117324.0 |
| 2006-06-19 10:30:00 | AAPL | Stock | 2.0457 | 2.0496 | 2.0357 | 2.0368 | 11086320.0 |
| 2006-06-19 10:35:00 | AAPL | Stock | 2.0366 | 2.0425 | 2.0357 | 2.0411 | 10058412.0 |
| 2006-06-19 10:40:00 | AAPL | Stock | 2.0411 | 2.0443 | 2.0389 | 2.0436 | 4109476.0 |
| 2006-06-19 10:45:00 | AAPL | Stock | 2.0439 | 2.0752 | 2.0404 | 2.0446 | 6595456.0 |
| 2006-06-19 10:50:00 | AAPL | Stock | 2.0446 | 2.0525 | 2.0443 | 2.0514 | 8259412.0 |
| 2006-06-19 10:55:00 | AAPL | Stock | 2.0518 | 2.0543 | 2.0486 | 2.0511 | 7200984.0 |
| 2006-06-19 11:00:00 | AAPL | Stock | 2.0514 | 2.0721 | 2.0514 | 2.0546 | 10674160.0 |
| 2006-06-19 11:05:00 | AAPL | Stock | 2.0546 | 2.0554 | 2.0482 | 2.0539 | 7821240.0 |
| 2006-06-19 11:10:00 | AAPL | Stock | 2.0543 | 2.0625 | 2.0529 | 2.0618 | 11888044.0 |
| 2006-06-19 11:15:00 | AAPL | Stock | 2.0625 | 2.0633 | 2.0557 | 2.0611 | 7001064.0 |
| 2006-06-19 11:20:00 | AAPL | Stock | 2.0611 | 2.0625 | 2.055 | 2.0554 | 5387340.0 |
| 2006-06-19 11:25:00 | AAPL | Stock | 2.0554 | 2.0571 | 2.0525 | 2.0543 | 9069788.0 |
| 2006-06-19 11:30:00 | AAPL | Stock | 2.0543 | 2.0607 | 2.0536 | 2.0557 | 6063288.0 |
| 2006-06-19 11:35:00 | AAPL | Stock | 2.0554 | 2.06 | 2.0521 | 2.0596 | 8032500.0 |
| 2006-06-19 11:40:00 | AAPL | Stock | 2.06 | 2.0714 | 2.06 | 2.0679 | 16384088.0 |
| 2006-06-19 11:45:00 | AAPL | Stock | 2.0679 | 2.0732 | 2.0657 | 2.0696 | 14910532.0 |
| 2006-06-19 11:50:00 | AAPL | Stock | 2.07 | 2.07 | 2.0632 | 2.0668 | 8438948.0 |
> showing 50 of 232,053 rows — these rows as CSV