PREVIEW / stock_5min / 2010-02-03
file: by_date/stock_5min/2010/2010-02-03.parquet size: 4.7 MB rows: 325,654 symbols: 3,423
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-02-03 04:15:00 | AAPL | Stock | 7.0011 | 7.0011 | 7.0011 | 7.0011 | 5600.0 |
| 2010-02-03 05:30:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 2800.0 |
| 2010-02-03 06:35:00 | AAPL | Stock | 6.9946 | 6.9946 | 6.9946 | 6.9946 | 2800.0 |
| 2010-02-03 07:05:00 | AAPL | Stock | 6.9946 | 6.9946 | 6.9857 | 6.9857 | 9128.0 |
| 2010-02-03 07:15:00 | AAPL | Stock | 6.9911 | 6.9911 | 6.9911 | 6.9911 | 10780.0 |
| 2010-02-03 07:20:00 | AAPL | Stock | 6.9929 | 6.9929 | 6.9929 | 6.9929 | 2800.0 |
| 2010-02-03 07:35:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 2800.0 |
| 2010-02-03 07:40:00 | AAPL | Stock | 6.9789 | 6.9789 | 6.9789 | 6.9789 | 2940.0 |
| 2010-02-03 07:45:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 2940.0 |
| 2010-02-03 07:50:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 2800.0 |
| 2010-02-03 08:00:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9536 | 6.96 | 368900.0 |
| 2010-02-03 08:05:00 | AAPL | Stock | 6.9636 | 6.9643 | 6.9604 | 6.9607 | 51856.0 |
| 2010-02-03 08:10:00 | AAPL | Stock | 6.9629 | 6.9629 | 6.9518 | 6.9586 | 257600.0 |
| 2010-02-03 08:15:00 | AAPL | Stock | 6.9632 | 6.975 | 6.9632 | 6.9679 | 232764.0 |
| 2010-02-03 08:20:00 | AAPL | Stock | 6.9711 | 6.9711 | 6.9607 | 6.9671 | 82460.0 |
| 2010-02-03 08:25:00 | AAPL | Stock | 6.965 | 6.9654 | 6.9589 | 6.9589 | 67536.0 |
| 2010-02-03 08:30:00 | AAPL | Stock | 6.9586 | 6.9639 | 6.9582 | 6.9639 | 40600.0 |
| 2010-02-03 08:35:00 | AAPL | Stock | 6.9679 | 6.9682 | 6.9625 | 6.9682 | 47600.0 |
| 2010-02-03 08:40:00 | AAPL | Stock | 6.9682 | 6.975 | 6.9607 | 6.9636 | 175000.0 |
| 2010-02-03 08:45:00 | AAPL | Stock | 6.9636 | 6.9636 | 6.9589 | 6.9621 | 50400.0 |
| 2010-02-03 08:50:00 | AAPL | Stock | 6.9607 | 6.9611 | 6.9514 | 6.9514 | 197344.0 |
| 2010-02-03 08:55:00 | AAPL | Stock | 6.9507 | 6.9596 | 6.9507 | 6.9571 | 98588.0 |
| 2010-02-03 09:00:00 | AAPL | Stock | 6.9575 | 6.9621 | 6.9575 | 6.9586 | 180040.0 |
| 2010-02-03 09:05:00 | AAPL | Stock | 6.9586 | 6.96 | 6.9564 | 6.9582 | 64400.0 |
| 2010-02-03 09:10:00 | AAPL | Stock | 6.9604 | 6.9639 | 6.955 | 6.9561 | 204820.0 |
| 2010-02-03 09:15:00 | AAPL | Stock | 6.9564 | 6.9636 | 6.9561 | 6.9607 | 95200.0 |
| 2010-02-03 09:20:00 | AAPL | Stock | 6.9621 | 6.9711 | 6.9621 | 6.9636 | 225428.0 |
| 2010-02-03 09:25:00 | AAPL | Stock | 6.9618 | 6.9721 | 6.9543 | 6.9714 | 626080.0 |
| 2010-02-03 09:30:00 | AAPL | Stock | 6.9718 | 6.9814 | 6.9436 | 6.9689 | 15159060.0 |
| 2010-02-03 09:35:00 | AAPL | Stock | 6.9695 | 6.9868 | 6.9639 | 6.9761 | 13096076.0 |
| 2010-02-03 09:40:00 | AAPL | Stock | 6.9771 | 7.0364 | 6.9764 | 7.0357 | 20939716.0 |
| 2010-02-03 09:45:00 | AAPL | Stock | 7.0357 | 7.05 | 7.0261 | 7.0439 | 15263948.0 |
| 2010-02-03 09:50:00 | AAPL | Stock | 7.0443 | 7.0829 | 7.0418 | 7.0704 | 21384720.0 |
| 2010-02-03 09:55:00 | AAPL | Stock | 7.0714 | 7.0725 | 7.0532 | 7.0596 | 12729696.0 |
| 2010-02-03 10:00:00 | AAPL | Stock | 7.0596 | 7.075 | 7.0443 | 7.0671 | 15755068.0 |
| 2010-02-03 10:05:00 | AAPL | Stock | 7.0661 | 7.0774 | 7.0546 | 7.0668 | 10450776.0 |
| 2010-02-03 10:10:00 | AAPL | Stock | 7.0668 | 7.0821 | 7.0536 | 7.0793 | 11942420.0 |
| 2010-02-03 10:15:00 | AAPL | Stock | 7.0793 | 7.0893 | 7.0575 | 7.0646 | 12303620.0 |
| 2010-02-03 10:20:00 | AAPL | Stock | 7.0639 | 7.0782 | 7.0546 | 7.0725 | 9201024.0 |
| 2010-02-03 10:25:00 | AAPL | Stock | 7.0725 | 7.0734 | 7.0507 | 7.0607 | 7856744.0 |
| 2010-02-03 10:30:00 | AAPL | Stock | 7.06 | 7.0754 | 7.0536 | 7.0589 | 7013020.0 |
| 2010-02-03 10:35:00 | AAPL | Stock | 7.0604 | 7.0643 | 7.0225 | 7.0379 | 13709892.0 |
| 2010-02-03 10:40:00 | AAPL | Stock | 7.0389 | 7.05 | 7.0357 | 7.0489 | 6473852.0 |
| 2010-02-03 10:45:00 | AAPL | Stock | 7.0489 | 7.0714 | 7.0386 | 7.07 | 9438632.0 |
| 2010-02-03 10:50:00 | AAPL | Stock | 7.07 | 7.0707 | 7.0607 | 7.0614 | 5640768.0 |
| 2010-02-03 10:55:00 | AAPL | Stock | 7.0629 | 7.0707 | 7.0571 | 7.0611 | 4838736.0 |
| 2010-02-03 11:00:00 | AAPL | Stock | 7.063 | 7.0692 | 7.0571 | 7.0632 | 3174024.0 |
| 2010-02-03 11:05:00 | AAPL | Stock | 7.0636 | 7.0868 | 7.0621 | 7.0821 | 11660684.0 |
| 2010-02-03 11:10:00 | AAPL | Stock | 7.0816 | 7.1025 | 7.0814 | 7.1018 | 12077828.0 |
| 2010-02-03 11:15:00 | AAPL | Stock | 7.1021 | 7.1143 | 7.1 | 7.1121 | 13614104.0 |
> showing 50 of 325,654 rows — these rows as CSV