PREVIEW / stock_5min / 2010-02-02
file: by_date/stock_5min/2010/2010-02-02.parquet size: 4.8 MB rows: 330,181 symbols: 3,439
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-02 05:15:00 | AAPL | Stock | 6.9629 | 6.9643 | 6.9629 | 6.9643 | 6020.0 |
| 2010-02-02 05:20:00 | AAPL | Stock | 6.9682 | 6.9682 | 6.9682 | 6.9682 | 5180.0 |
| 2010-02-02 06:25:00 | AAPL | Stock | 6.9907 | 6.9911 | 6.9907 | 6.9911 | 5824.0 |
| 2010-02-02 06:55:00 | AAPL | Stock | 6.9914 | 6.9914 | 6.9911 | 6.9911 | 5600.0 |
| 2010-02-02 07:05:00 | AAPL | Stock | 6.9911 | 6.9911 | 6.9911 | 6.9911 | 11760.0 |
| 2010-02-02 07:10:00 | AAPL | Stock | 6.9911 | 6.9929 | 6.9911 | 6.9929 | 16744.0 |
| 2010-02-02 07:15:00 | AAPL | Stock | 6.9996 | 6.9996 | 6.9914 | 6.9914 | 47656.0 |
| 2010-02-02 07:20:00 | AAPL | Stock | 6.9914 | 6.9914 | 6.9907 | 6.9907 | 36400.0 |
| 2010-02-02 07:25:00 | AAPL | Stock | 6.9929 | 6.9929 | 6.9904 | 6.9904 | 8120.0 |
| 2010-02-02 07:30:00 | AAPL | Stock | 6.9839 | 6.9839 | 6.9789 | 6.9789 | 35056.0 |
| 2010-02-02 07:35:00 | AAPL | Stock | 6.9789 | 6.9789 | 6.9771 | 6.9771 | 16800.0 |
| 2010-02-02 07:40:00 | AAPL | Stock | 6.9789 | 6.9829 | 6.9789 | 6.9829 | 11200.0 |
| 2010-02-02 07:50:00 | AAPL | Stock | 6.9818 | 6.9818 | 6.9818 | 6.9818 | 2800.0 |
| 2010-02-02 08:00:00 | AAPL | Stock | 6.9786 | 6.9929 | 6.9743 | 6.9929 | 602000.0 |
| 2010-02-02 08:05:00 | AAPL | Stock | 6.9929 | 6.9993 | 6.9925 | 6.9957 | 318612.0 |
| 2010-02-02 08:10:00 | AAPL | Stock | 6.9964 | 6.9968 | 6.9839 | 6.9857 | 275072.0 |
| 2010-02-02 08:15:00 | AAPL | Stock | 6.9836 | 6.985 | 6.9732 | 6.9839 | 215152.0 |
| 2010-02-02 08:20:00 | AAPL | Stock | 6.98 | 6.9821 | 6.9668 | 6.975 | 160104.0 |
| 2010-02-02 08:25:00 | AAPL | Stock | 6.9718 | 6.9807 | 6.9714 | 6.9793 | 53816.0 |
| 2010-02-02 08:30:00 | AAPL | Stock | 6.9804 | 6.9821 | 6.9782 | 6.9821 | 122304.0 |
| 2010-02-02 08:35:00 | AAPL | Stock | 6.9825 | 6.9832 | 6.9714 | 6.975 | 289268.0 |
| 2010-02-02 08:40:00 | AAPL | Stock | 6.975 | 6.9789 | 6.9682 | 6.9696 | 268520.0 |
| 2010-02-02 08:45:00 | AAPL | Stock | 6.9682 | 6.9707 | 6.9643 | 6.9657 | 426888.0 |
| 2010-02-02 08:50:00 | AAPL | Stock | 6.9664 | 6.9686 | 6.9589 | 6.9686 | 303688.0 |
| 2010-02-02 08:55:00 | AAPL | Stock | 6.9686 | 6.9796 | 6.9686 | 6.9761 | 354144.0 |
| 2010-02-02 09:00:00 | AAPL | Stock | 6.9739 | 6.98 | 6.9739 | 6.9789 | 302176.0 |
| 2010-02-02 09:05:00 | AAPL | Stock | 6.9793 | 6.9796 | 6.9721 | 6.9729 | 113736.0 |
| 2010-02-02 09:10:00 | AAPL | Stock | 6.9768 | 6.98 | 6.9768 | 6.98 | 89600.0 |
| 2010-02-02 09:15:00 | AAPL | Stock | 6.9804 | 6.9839 | 6.9789 | 6.9839 | 279664.0 |
| 2010-02-02 09:20:00 | AAPL | Stock | 6.9839 | 6.9839 | 6.98 | 6.9804 | 187096.0 |
| 2010-02-02 09:25:00 | AAPL | Stock | 6.9779 | 6.9957 | 6.9779 | 6.9957 | 581924.0 |
| 2010-02-02 09:30:00 | AAPL | Stock | 6.9914 | 7.0054 | 6.9564 | 6.9614 | 22596168.0 |
| 2010-02-02 09:35:00 | AAPL | Stock | 6.9624 | 6.9811 | 6.9404 | 6.9686 | 22391488.0 |
| 2010-02-02 09:40:00 | AAPL | Stock | 6.9689 | 6.9768 | 6.9429 | 6.9743 | 16590980.0 |
| 2010-02-02 09:45:00 | AAPL | Stock | 6.9764 | 6.9893 | 6.9664 | 6.9793 | 12002816.0 |
| 2010-02-02 09:50:00 | AAPL | Stock | 6.9783 | 6.99 | 6.9571 | 6.9607 | 10448200.0 |
| 2010-02-02 09:55:00 | AAPL | Stock | 6.9607 | 6.9754 | 6.9464 | 6.9546 | 10272780.0 |
| 2010-02-02 10:00:00 | AAPL | Stock | 6.9568 | 6.9689 | 6.9143 | 6.9286 | 18747092.0 |
| 2010-02-02 10:05:00 | AAPL | Stock | 6.9286 | 6.9336 | 6.9071 | 6.9129 | 16617916.0 |
| 2010-02-02 10:10:00 | AAPL | Stock | 6.9114 | 6.9443 | 6.9064 | 6.9408 | 12267892.0 |
| 2010-02-02 10:15:00 | AAPL | Stock | 6.9401 | 6.9643 | 6.9389 | 6.9607 | 12558504.0 |
| 2010-02-02 10:20:00 | AAPL | Stock | 6.9607 | 6.9682 | 6.9446 | 6.9546 | 9333884.0 |
| 2010-02-02 10:25:00 | AAPL | Stock | 6.9546 | 6.9786 | 6.9546 | 6.9661 | 9698864.0 |
| 2010-02-02 10:30:00 | AAPL | Stock | 6.9679 | 6.9768 | 6.9607 | 6.9625 | 8619520.0 |
| 2010-02-02 10:35:00 | AAPL | Stock | 6.9607 | 6.9768 | 6.9529 | 6.9568 | 11154640.0 |
| 2010-02-02 10:40:00 | AAPL | Stock | 6.9568 | 6.9586 | 6.9332 | 6.9429 | 13149724.0 |
| 2010-02-02 10:45:00 | AAPL | Stock | 6.9411 | 6.9518 | 6.9357 | 6.9429 | 4848900.0 |
| 2010-02-02 10:50:00 | AAPL | Stock | 6.9429 | 6.9461 | 6.9207 | 6.9279 | 12533052.0 |
| 2010-02-02 10:55:00 | AAPL | Stock | 6.9273 | 6.9371 | 6.9229 | 6.9254 | 7872312.0 |
| 2010-02-02 11:00:00 | AAPL | Stock | 6.9254 | 6.9336 | 6.9146 | 6.9157 | 9396072.0 |
> showing 50 of 330,181 rows — these rows as CSV