PREVIEW / stock_5min / 2010-03-18
file: by_date/stock_5min/2010/2010-03-18.parquet size: 4.7 MB rows: 319,836 symbols: 3,467
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-03-18 05:05:00 | AAPL | Stock | 7.9671 | 7.9671 | 7.9632 | 7.9632 | 5600.0 |
| 2010-03-18 05:15:00 | AAPL | Stock | 7.9821 | 7.9821 | 7.9821 | 7.9821 | 2800.0 |
| 2010-03-18 05:30:00 | AAPL | Stock | 7.9911 | 7.9911 | 7.9911 | 7.9911 | 2800.0 |
| 2010-03-18 07:05:00 | AAPL | Stock | 7.9911 | 7.9911 | 7.9911 | 7.9911 | 2800.0 |
| 2010-03-18 07:30:00 | AAPL | Stock | 8.0232 | 8.0232 | 8.0232 | 8.0232 | 2800.0 |
| 2010-03-18 07:45:00 | AAPL | Stock | 8.0036 | 8.0036 | 8.0036 | 8.0036 | 14280.0 |
| 2010-03-18 07:50:00 | AAPL | Stock | 8.005 | 8.0054 | 8.005 | 8.0054 | 14420.0 |
| 2010-03-18 07:55:00 | AAPL | Stock | 8.0029 | 8.0029 | 8.0029 | 8.0029 | 5600.0 |
| 2010-03-18 08:00:00 | AAPL | Stock | 8.0054 | 8.0054 | 7.9943 | 8.0 | 86520.0 |
| 2010-03-18 08:05:00 | AAPL | Stock | 8.0 | 8.0054 | 7.9911 | 8.0054 | 60760.0 |
| 2010-03-18 08:10:00 | AAPL | Stock | 8.0071 | 8.0071 | 8.0004 | 8.0004 | 22540.0 |
| 2010-03-18 08:15:00 | AAPL | Stock | 7.9975 | 7.9975 | 7.9954 | 7.9964 | 47600.0 |
| 2010-03-18 08:20:00 | AAPL | Stock | 7.9964 | 7.9964 | 7.9932 | 7.9932 | 11200.0 |
| 2010-03-18 08:25:00 | AAPL | Stock | 7.9929 | 8.0059 | 7.9929 | 7.9989 | 106400.0 |
| 2010-03-18 08:30:00 | AAPL | Stock | 8.0005 | 8.0082 | 8.0005 | 8.0082 | 31640.0 |
| 2010-03-18 08:35:00 | AAPL | Stock | 8.0086 | 8.0268 | 8.0086 | 8.0236 | 559272.0 |
| 2010-03-18 08:40:00 | AAPL | Stock | 8.0243 | 8.0293 | 8.0243 | 8.025 | 134792.0 |
| 2010-03-18 08:45:00 | AAPL | Stock | 8.025 | 8.0264 | 8.0214 | 8.0218 | 61600.0 |
| 2010-03-18 08:50:00 | AAPL | Stock | 8.0261 | 8.0261 | 8.0207 | 8.0207 | 187600.0 |
| 2010-03-18 08:55:00 | AAPL | Stock | 8.0207 | 8.0221 | 8.0207 | 8.0207 | 50400.0 |
| 2010-03-18 09:00:00 | AAPL | Stock | 8.02 | 8.0207 | 8.0179 | 8.0179 | 275464.0 |
| 2010-03-18 09:05:00 | AAPL | Stock | 8.0164 | 8.0179 | 8.0146 | 8.0179 | 11200.0 |
| 2010-03-18 09:10:00 | AAPL | Stock | 8.0171 | 8.0179 | 8.0164 | 8.0175 | 52080.0 |
| 2010-03-18 09:15:00 | AAPL | Stock | 8.0193 | 8.0229 | 8.0193 | 8.0196 | 116228.0 |
| 2010-03-18 09:20:00 | AAPL | Stock | 8.0189 | 8.0211 | 8.0154 | 8.0179 | 36400.0 |
| 2010-03-18 09:25:00 | AAPL | Stock | 8.0214 | 8.0214 | 8.0071 | 8.0079 | 321300.0 |
| 2010-03-18 09:30:00 | AAPL | Stock | 8.0071 | 8.015 | 7.9911 | 8.0011 | 11359488.0 |
| 2010-03-18 09:35:00 | AAPL | Stock | 8.0005 | 8.0132 | 7.9786 | 7.9814 | 10714760.0 |
| 2010-03-18 09:40:00 | AAPL | Stock | 7.9821 | 7.9996 | 7.9814 | 7.9932 | 6858432.0 |
| 2010-03-18 09:45:00 | AAPL | Stock | 7.9932 | 7.9943 | 7.9843 | 7.99 | 5973744.0 |
| 2010-03-18 09:50:00 | AAPL | Stock | 7.9896 | 7.9929 | 7.9786 | 7.9839 | 7386456.0 |
| 2010-03-18 09:55:00 | AAPL | Stock | 7.9839 | 7.9843 | 7.9568 | 7.9657 | 11862872.0 |
| 2010-03-18 10:00:00 | AAPL | Stock | 7.9657 | 7.9904 | 7.9636 | 7.9693 | 10559556.0 |
| 2010-03-18 10:05:00 | AAPL | Stock | 7.9707 | 7.9729 | 7.9589 | 7.9643 | 8981364.0 |
| 2010-03-18 10:10:00 | AAPL | Stock | 7.9643 | 7.9746 | 7.9607 | 7.9618 | 5297656.0 |
| 2010-03-18 10:15:00 | AAPL | Stock | 7.9621 | 7.9746 | 7.9504 | 7.9718 | 7370244.0 |
| 2010-03-18 10:20:00 | AAPL | Stock | 7.9718 | 7.9879 | 7.9696 | 7.9864 | 7504364.0 |
| 2010-03-18 10:25:00 | AAPL | Stock | 7.9873 | 7.9873 | 7.9725 | 7.9746 | 3595704.0 |
| 2010-03-18 10:30:00 | AAPL | Stock | 7.975 | 7.9832 | 7.9739 | 7.9786 | 2788044.0 |
| 2010-03-18 10:35:00 | AAPL | Stock | 7.9786 | 7.9796 | 7.9664 | 7.9732 | 4017188.0 |
| 2010-03-18 10:40:00 | AAPL | Stock | 7.9732 | 7.98 | 7.9661 | 7.9771 | 3844288.0 |
| 2010-03-18 10:45:00 | AAPL | Stock | 7.9782 | 7.9804 | 7.9739 | 7.9772 | 2402876.0 |
| 2010-03-18 10:50:00 | AAPL | Stock | 7.9764 | 7.9821 | 7.9707 | 7.9752 | 2467304.0 |
| 2010-03-18 10:55:00 | AAPL | Stock | 7.9745 | 7.9971 | 7.9732 | 7.9947 | 6329400.0 |
| 2010-03-18 11:00:00 | AAPL | Stock | 7.9946 | 8.0 | 7.9905 | 7.9953 | 6203176.0 |
| 2010-03-18 11:05:00 | AAPL | Stock | 7.995 | 8.0089 | 7.9943 | 8.0036 | 5492648.0 |
| 2010-03-18 11:10:00 | AAPL | Stock | 8.0046 | 8.0096 | 7.9957 | 8.0036 | 4435704.0 |
| 2010-03-18 11:15:00 | AAPL | Stock | 8.0043 | 8.0132 | 8.0011 | 8.0032 | 4964120.0 |
| 2010-03-18 11:20:00 | AAPL | Stock | 8.0031 | 8.0096 | 7.9986 | 8.0004 | 2928240.0 |
| 2010-03-18 11:25:00 | AAPL | Stock | 8.0 | 8.005 | 7.9986 | 8.0018 | 2418696.0 |
> showing 50 of 319,836 rows — these rows as CSV