PREVIEW / stock_5min / 2009-12-14
file: by_date/stock_5min/2009/2009-12-14.parquet size: 4.7 MB rows: 323,108 symbols: 3,446
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-14 04:15:00 | AAPL | Stock | 6.9714 | 7.0171 | 6.9714 | 7.0171 | 5600.0 |
| 2009-12-14 05:55:00 | AAPL | Stock | 6.9975 | 6.9975 | 6.9925 | 6.9925 | 8400.0 |
| 2009-12-14 06:20:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9864 | 6.9864 | 2800.0 |
| 2009-12-14 06:25:00 | AAPL | Stock | 6.9843 | 6.9843 | 6.9843 | 6.9843 | 2800.0 |
| 2009-12-14 06:35:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9821 | 6.9821 | 5600.0 |
| 2009-12-14 07:10:00 | AAPL | Stock | 6.9936 | 6.9964 | 6.9932 | 6.9964 | 16800.0 |
| 2009-12-14 07:15:00 | AAPL | Stock | 7.0054 | 7.0071 | 7.0004 | 7.0071 | 67004.0 |
| 2009-12-14 07:20:00 | AAPL | Stock | 7.0107 | 7.0125 | 7.0107 | 7.0125 | 5600.0 |
| 2009-12-14 07:25:00 | AAPL | Stock | 7.0143 | 7.0143 | 7.0036 | 7.0036 | 8960.0 |
| 2009-12-14 07:30:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0036 | 7.0036 | 4200.0 |
| 2009-12-14 07:35:00 | AAPL | Stock | 7.0043 | 7.0043 | 7.0036 | 7.0036 | 72660.0 |
| 2009-12-14 07:40:00 | AAPL | Stock | 7.0039 | 7.0039 | 7.0 | 7.0 | 68600.0 |
| 2009-12-14 07:45:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 44800.0 |
| 2009-12-14 07:50:00 | AAPL | Stock | 6.9996 | 6.9996 | 6.9996 | 6.9996 | 2800.0 |
| 2009-12-14 07:55:00 | AAPL | Stock | 6.9996 | 6.9996 | 6.9996 | 6.9996 | 2800.0 |
| 2009-12-14 08:00:00 | AAPL | Stock | 6.9971 | 7.0 | 6.9768 | 6.9893 | 692328.0 |
| 2009-12-14 08:05:00 | AAPL | Stock | 6.9893 | 7.0025 | 6.9873 | 6.9964 | 768936.0 |
| 2009-12-14 08:10:00 | AAPL | Stock | 6.9964 | 7.0046 | 6.9525 | 7.0 | 610960.0 |
| 2009-12-14 08:15:00 | AAPL | Stock | 7.0011 | 7.0071 | 7.0 | 7.0071 | 272636.0 |
| 2009-12-14 08:20:00 | AAPL | Stock | 7.0071 | 7.0164 | 7.0071 | 7.0143 | 468748.0 |
| 2009-12-14 08:25:00 | AAPL | Stock | 7.015 | 7.0157 | 7.0032 | 7.0032 | 253708.0 |
| 2009-12-14 08:30:00 | AAPL | Stock | 7.0004 | 7.0014 | 6.9964 | 7.0014 | 183848.0 |
| 2009-12-14 08:35:00 | AAPL | Stock | 7.0014 | 7.0014 | 6.9954 | 6.9961 | 145880.0 |
| 2009-12-14 08:40:00 | AAPL | Stock | 6.9975 | 6.9975 | 6.9929 | 6.9954 | 82348.0 |
| 2009-12-14 08:45:00 | AAPL | Stock | 6.9954 | 6.9964 | 6.9843 | 6.9843 | 124600.0 |
| 2009-12-14 08:50:00 | AAPL | Stock | 6.9857 | 6.9911 | 6.9857 | 6.9882 | 124320.0 |
| 2009-12-14 08:55:00 | AAPL | Stock | 6.9875 | 6.9875 | 6.9743 | 6.9764 | 270760.0 |
| 2009-12-14 09:00:00 | AAPL | Stock | 6.9768 | 6.9864 | 6.9768 | 6.9857 | 86604.0 |
| 2009-12-14 09:05:00 | AAPL | Stock | 6.9864 | 6.9875 | 6.9836 | 6.9843 | 275800.0 |
| 2009-12-14 09:10:00 | AAPL | Stock | 6.9843 | 6.9911 | 6.9839 | 6.9857 | 399084.0 |
| 2009-12-14 09:15:00 | AAPL | Stock | 6.9843 | 6.9893 | 6.9843 | 6.9861 | 19600.0 |
| 2009-12-14 09:20:00 | AAPL | Stock | 6.9861 | 6.9861 | 6.9821 | 6.9839 | 162736.0 |
| 2009-12-14 09:25:00 | AAPL | Stock | 6.9839 | 6.9839 | 6.975 | 6.9796 | 439824.0 |
| 2009-12-14 09:30:00 | AAPL | Stock | 6.9775 | 6.9861 | 6.9607 | 6.9653 | 11194652.0 |
| 2009-12-14 09:35:00 | AAPL | Stock | 6.9646 | 6.9696 | 6.9325 | 6.9396 | 13702668.0 |
| 2009-12-14 09:40:00 | AAPL | Stock | 6.9396 | 6.9654 | 6.9357 | 6.9632 | 10821496.0 |
| 2009-12-14 09:45:00 | AAPL | Stock | 6.9621 | 6.9754 | 6.9518 | 6.9607 | 8667736.0 |
| 2009-12-14 09:50:00 | AAPL | Stock | 6.9604 | 6.9714 | 6.9471 | 6.9529 | 6317136.0 |
| 2009-12-14 09:55:00 | AAPL | Stock | 6.9529 | 6.9571 | 6.9082 | 6.9189 | 14844872.0 |
| 2009-12-14 10:00:00 | AAPL | Stock | 6.9179 | 6.9229 | 6.8771 | 6.89 | 15319444.0 |
| 2009-12-14 10:05:00 | AAPL | Stock | 6.8904 | 6.8929 | 6.8793 | 6.89 | 10558576.0 |
| 2009-12-14 10:10:00 | AAPL | Stock | 6.8893 | 6.9107 | 6.8868 | 6.9018 | 10596264.0 |
| 2009-12-14 10:15:00 | AAPL | Stock | 6.9025 | 6.9057 | 6.8929 | 6.8929 | 7204456.0 |
| 2009-12-14 10:20:00 | AAPL | Stock | 6.8929 | 6.9137 | 6.8832 | 6.9089 | 7911036.0 |
| 2009-12-14 10:25:00 | AAPL | Stock | 6.9089 | 6.9268 | 6.9079 | 6.9171 | 6384476.0 |
| 2009-12-14 10:30:00 | AAPL | Stock | 6.9169 | 6.9321 | 6.9157 | 6.925 | 5340104.0 |
| 2009-12-14 10:35:00 | AAPL | Stock | 6.9243 | 6.9275 | 6.905 | 6.9061 | 4961264.0 |
| 2009-12-14 10:40:00 | AAPL | Stock | 6.9068 | 6.9196 | 6.9054 | 6.9126 | 3331692.0 |
| 2009-12-14 10:45:00 | AAPL | Stock | 6.9125 | 6.9229 | 6.9079 | 6.9214 | 2415644.0 |
| 2009-12-14 10:50:00 | AAPL | Stock | 6.9221 | 6.9354 | 6.9211 | 6.9332 | 3952844.0 |
> showing 50 of 323,108 rows — these rows as CSV