PREVIEW / stock_5min / 2011-01-25
file: by_date/stock_5min/2011/2011-01-25.parquet size: 4.9 MB rows: 333,585 symbols: 3,528
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-25 05:35:00 | AAPL | Stock | 12.04 | 12.04 | 12.04 | 12.04 | 2800.0 |
| 2011-01-25 05:50:00 | AAPL | Stock | 12.0446 | 12.0446 | 12.0446 | 12.0446 | 5600.0 |
| 2011-01-25 06:00:00 | AAPL | Stock | 12.0518 | 12.0518 | 12.0518 | 12.0518 | 2800.0 |
| 2011-01-25 06:25:00 | AAPL | Stock | 12.0429 | 12.0429 | 12.0429 | 12.0429 | 2800.0 |
| 2011-01-25 06:30:00 | AAPL | Stock | 12.0568 | 12.0568 | 12.0568 | 12.0568 | 2800.0 |
| 2011-01-25 07:00:00 | AAPL | Stock | 12.0625 | 12.0679 | 12.0536 | 12.0536 | 16800.0 |
| 2011-01-25 07:05:00 | AAPL | Stock | 12.0643 | 12.0643 | 12.0607 | 12.0643 | 14000.0 |
| 2011-01-25 07:10:00 | AAPL | Stock | 12.0679 | 12.0714 | 12.0679 | 12.0707 | 19600.0 |
| 2011-01-25 07:15:00 | AAPL | Stock | 12.0711 | 12.0711 | 12.0629 | 12.0707 | 36680.0 |
| 2011-01-25 07:20:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0493 | 12.0571 | 53004.0 |
| 2011-01-25 07:25:00 | AAPL | Stock | 12.0625 | 12.0625 | 12.0571 | 12.0571 | 12880.0 |
| 2011-01-25 07:30:00 | AAPL | Stock | 12.0661 | 12.0661 | 12.0661 | 12.0661 | 5600.0 |
| 2011-01-25 07:35:00 | AAPL | Stock | 12.0646 | 12.0646 | 12.0607 | 12.0607 | 14000.0 |
| 2011-01-25 07:40:00 | AAPL | Stock | 12.0575 | 12.0575 | 12.0571 | 12.0571 | 11200.0 |
| 2011-01-25 07:45:00 | AAPL | Stock | 12.0518 | 12.0518 | 12.0286 | 12.0286 | 95620.0 |
| 2011-01-25 07:50:00 | AAPL | Stock | 12.0243 | 12.0268 | 12.0232 | 12.0268 | 35392.0 |
| 2011-01-25 07:55:00 | AAPL | Stock | 12.0318 | 12.0318 | 12.0304 | 12.0304 | 22400.0 |
| 2011-01-25 08:00:00 | AAPL | Stock | 12.0286 | 12.0479 | 12.0214 | 12.0214 | 192836.0 |
| 2011-01-25 08:05:00 | AAPL | Stock | 12.0229 | 12.0232 | 12.0121 | 12.0121 | 179760.0 |
| 2011-01-25 08:10:00 | AAPL | Stock | 12.0143 | 12.0161 | 11.995 | 12.0036 | 454048.0 |
| 2011-01-25 08:15:00 | AAPL | Stock | 12.0036 | 12.0175 | 12.0032 | 12.0086 | 265440.0 |
| 2011-01-25 08:20:00 | AAPL | Stock | 12.0086 | 12.0089 | 12.0057 | 12.0089 | 71512.0 |
| 2011-01-25 08:25:00 | AAPL | Stock | 12.0089 | 12.0125 | 12.005 | 12.0093 | 45080.0 |
| 2011-01-25 08:30:00 | AAPL | Stock | 12.0093 | 12.0093 | 12.0064 | 12.0064 | 19600.0 |
| 2011-01-25 08:35:00 | AAPL | Stock | 12.0064 | 12.0064 | 11.9946 | 11.9964 | 183204.0 |
| 2011-01-25 08:40:00 | AAPL | Stock | 11.9964 | 12.0 | 11.9839 | 11.9964 | 278320.0 |
| 2011-01-25 08:45:00 | AAPL | Stock | 11.9982 | 12.0036 | 11.9982 | 12.0036 | 56084.0 |
| 2011-01-25 08:50:00 | AAPL | Stock | 12.0036 | 12.0107 | 12.0036 | 12.0071 | 84000.0 |
| 2011-01-25 08:55:00 | AAPL | Stock | 12.0036 | 12.0079 | 12.0007 | 12.0014 | 106260.0 |
| 2011-01-25 09:00:00 | AAPL | Stock | 12.0011 | 12.0011 | 11.9864 | 11.9946 | 372036.0 |
| 2011-01-25 09:05:00 | AAPL | Stock | 11.9946 | 12.0054 | 11.9946 | 11.9964 | 482048.0 |
| 2011-01-25 09:10:00 | AAPL | Stock | 11.9968 | 12.0 | 11.9964 | 12.0 | 82712.0 |
| 2011-01-25 09:15:00 | AAPL | Stock | 12.0029 | 12.0029 | 11.9911 | 11.9911 | 85680.0 |
| 2011-01-25 09:20:00 | AAPL | Stock | 11.9911 | 11.9975 | 11.9911 | 11.9975 | 36400.0 |
| 2011-01-25 09:25:00 | AAPL | Stock | 11.9996 | 12.0154 | 11.9996 | 12.0143 | 401100.0 |
| 2011-01-25 09:30:00 | AAPL | Stock | 12.0129 | 12.0286 | 11.9818 | 11.9961 | 24269056.0 |
| 2011-01-25 09:35:00 | AAPL | Stock | 11.9986 | 12.0093 | 11.9489 | 11.9718 | 16391900.0 |
| 2011-01-25 09:40:00 | AAPL | Stock | 11.9721 | 11.9929 | 11.9543 | 11.9902 | 13211632.0 |
| 2011-01-25 09:45:00 | AAPL | Stock | 11.9882 | 12.0232 | 11.9818 | 12.0211 | 11971792.0 |
| 2011-01-25 09:50:00 | AAPL | Stock | 12.0225 | 12.0664 | 12.0193 | 12.0604 | 18301864.0 |
| 2011-01-25 09:55:00 | AAPL | Stock | 12.0614 | 12.0821 | 12.0357 | 12.0818 | 15411704.0 |
| 2011-01-25 10:00:00 | AAPL | Stock | 12.0818 | 12.1118 | 12.0714 | 12.0786 | 20464892.0 |
| 2011-01-25 10:05:00 | AAPL | Stock | 12.0786 | 12.0961 | 12.0686 | 12.0857 | 10314556.0 |
| 2011-01-25 10:10:00 | AAPL | Stock | 12.0861 | 12.0907 | 12.07 | 12.0782 | 6746656.0 |
| 2011-01-25 10:15:00 | AAPL | Stock | 12.0782 | 12.0786 | 12.0536 | 12.066 | 8937544.0 |
| 2011-01-25 10:20:00 | AAPL | Stock | 12.0636 | 12.0686 | 12.0532 | 12.0573 | 5654348.0 |
| 2011-01-25 10:25:00 | AAPL | Stock | 12.0554 | 12.0868 | 12.0553 | 12.08 | 5659360.0 |
| 2011-01-25 10:30:00 | AAPL | Stock | 12.0786 | 12.1014 | 12.0757 | 12.1 | 5912704.0 |
| 2011-01-25 10:35:00 | AAPL | Stock | 12.0996 | 12.1054 | 12.09 | 12.0921 | 5413520.0 |
| 2011-01-25 10:40:00 | AAPL | Stock | 12.0921 | 12.1321 | 12.0861 | 12.1189 | 11408824.0 |
> showing 50 of 333,585 rows — these rows as CSV