PREVIEW / stock_5min / 2013-01-18
file: by_date/stock_5min/2013/2013-01-18.parquet size: 4.8 MB rows: 322,997 symbols: 3,441
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-18 04:00:00 | AAPL | Stock | 17.8625 | 17.8625 | 17.7964 | 17.7964 | 11200.0 |
| 2013-01-18 04:05:00 | AAPL | Stock | 17.7589 | 17.8036 | 17.7589 | 17.8036 | 19600.0 |
| 2013-01-18 04:15:00 | AAPL | Stock | 17.8189 | 17.8189 | 17.8189 | 17.8189 | 8400.0 |
| 2013-01-18 04:20:00 | AAPL | Stock | 17.8189 | 17.8189 | 17.8039 | 17.8039 | 15680.0 |
| 2013-01-18 04:25:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8036 | 17.8036 | 12880.0 |
| 2013-01-18 04:30:00 | AAPL | Stock | 17.8329 | 17.8393 | 17.8329 | 17.8393 | 28000.0 |
| 2013-01-18 04:35:00 | AAPL | Stock | 17.8036 | 17.8393 | 17.8036 | 17.8393 | 16800.0 |
| 2013-01-18 04:40:00 | AAPL | Stock | 17.8479 | 17.8868 | 17.8471 | 17.8868 | 30800.0 |
| 2013-01-18 04:45:00 | AAPL | Stock | 17.8786 | 17.8786 | 17.8629 | 17.8629 | 8400.0 |
| 2013-01-18 04:50:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 11200.0 |
| 2013-01-18 05:00:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 13860.0 |
| 2013-01-18 05:20:00 | AAPL | Stock | 17.8914 | 17.8914 | 17.8914 | 17.8914 | 13300.0 |
| 2013-01-18 05:30:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 8400.0 |
| 2013-01-18 05:40:00 | AAPL | Stock | 17.8939 | 17.8939 | 17.8939 | 17.8939 | 2800.0 |
| 2013-01-18 05:50:00 | AAPL | Stock | 17.8929 | 17.9464 | 17.8929 | 17.9464 | 25200.0 |
| 2013-01-18 05:55:00 | AAPL | Stock | 17.935 | 17.9643 | 17.9286 | 17.9643 | 28000.0 |
| 2013-01-18 06:05:00 | AAPL | Stock | 17.9821 | 17.9821 | 17.9821 | 17.9821 | 2800.0 |
| 2013-01-18 06:15:00 | AAPL | Stock | 17.9814 | 17.9814 | 17.9814 | 17.9814 | 5600.0 |
| 2013-01-18 06:20:00 | AAPL | Stock | 17.9889 | 17.9889 | 17.9889 | 17.9889 | 2800.0 |
| 2013-01-18 06:25:00 | AAPL | Stock | 17.9911 | 17.9911 | 17.9911 | 17.9911 | 2800.0 |
| 2013-01-18 06:30:00 | AAPL | Stock | 17.9536 | 17.9536 | 17.9536 | 17.9536 | 5600.0 |
| 2013-01-18 06:35:00 | AAPL | Stock | 17.9464 | 17.9464 | 17.9286 | 17.9286 | 80024.0 |
| 2013-01-18 06:40:00 | AAPL | Stock | 17.9286 | 17.9286 | 17.9286 | 17.9286 | 2800.0 |
| 2013-01-18 06:45:00 | AAPL | Stock | 17.9375 | 17.9596 | 17.9375 | 17.9429 | 53396.0 |
| 2013-01-18 06:50:00 | AAPL | Stock | 17.9321 | 17.9321 | 17.9232 | 17.9286 | 16800.0 |
| 2013-01-18 06:55:00 | AAPL | Stock | 17.9286 | 17.9286 | 17.9232 | 17.9232 | 22960.0 |
| 2013-01-18 07:00:00 | AAPL | Stock | 17.9232 | 17.9286 | 17.9104 | 17.9286 | 52080.0 |
| 2013-01-18 07:05:00 | AAPL | Stock | 17.9286 | 17.9286 | 17.9018 | 17.9018 | 26572.0 |
| 2013-01-18 07:10:00 | AAPL | Stock | 17.9 | 17.9232 | 17.9 | 17.9161 | 195160.0 |
| 2013-01-18 07:15:00 | AAPL | Stock | 17.9161 | 17.9264 | 17.9161 | 17.9264 | 51688.0 |
| 2013-01-18 07:20:00 | AAPL | Stock | 17.9286 | 17.9696 | 17.925 | 17.9696 | 113960.0 |
| 2013-01-18 07:25:00 | AAPL | Stock | 17.9646 | 17.9679 | 17.9643 | 17.9643 | 33600.0 |
| 2013-01-18 07:30:00 | AAPL | Stock | 17.9632 | 17.9893 | 17.9632 | 17.9893 | 37240.0 |
| 2013-01-18 07:35:00 | AAPL | Stock | 17.9821 | 18.0246 | 17.9821 | 18.0139 | 137816.0 |
| 2013-01-18 07:40:00 | AAPL | Stock | 18.0143 | 18.0143 | 17.9857 | 17.9971 | 51240.0 |
| 2013-01-18 07:45:00 | AAPL | Stock | 17.99 | 17.99 | 17.9661 | 17.9882 | 55160.0 |
| 2013-01-18 07:50:00 | AAPL | Stock | 17.9654 | 17.9714 | 17.9625 | 17.9625 | 80164.0 |
| 2013-01-18 07:55:00 | AAPL | Stock | 17.9575 | 17.9729 | 17.9446 | 17.9446 | 91840.0 |
| 2013-01-18 08:00:00 | AAPL | Stock | 17.9464 | 18.0268 | 17.8936 | 17.9186 | 358400.0 |
| 2013-01-18 08:05:00 | AAPL | Stock | 17.9107 | 17.9443 | 17.9018 | 17.9421 | 100744.0 |
| 2013-01-18 08:10:00 | AAPL | Stock | 17.9343 | 17.9343 | 17.8786 | 17.8786 | 232456.0 |
| 2013-01-18 08:15:00 | AAPL | Stock | 17.8786 | 17.8932 | 17.8629 | 17.8664 | 237916.0 |
| 2013-01-18 08:20:00 | AAPL | Stock | 17.8714 | 17.9018 | 17.8714 | 17.8814 | 127988.0 |
| 2013-01-18 08:25:00 | AAPL | Stock | 17.8786 | 17.8786 | 17.8271 | 17.8332 | 423220.0 |
| 2013-01-18 08:30:00 | AAPL | Stock | 17.8286 | 17.8482 | 17.8096 | 17.8214 | 619612.0 |
| 2013-01-18 08:35:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.7682 | 17.8 | 702016.0 |
| 2013-01-18 08:40:00 | AAPL | Stock | 17.8121 | 17.8304 | 17.7964 | 17.8 | 390152.0 |
| 2013-01-18 08:45:00 | AAPL | Stock | 17.7964 | 17.8186 | 17.7964 | 17.7971 | 203560.0 |
| 2013-01-18 08:50:00 | AAPL | Stock | 17.8121 | 17.82 | 17.8054 | 17.8104 | 115920.0 |
| 2013-01-18 08:55:00 | AAPL | Stock | 17.8164 | 17.8164 | 17.7964 | 17.8143 | 181104.0 |
> showing 50 of 322,997 rows — these rows as CSV