PREVIEW / stock_5min / 2011-12-20
file: by_date/stock_5min/2011/2011-12-20.parquet size: 5.0 MB rows: 337,742 symbols: 3,591
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-12-20 07:00:00 | AAPL | Stock | 13.7589 | 13.7589 | 13.7589 | 13.7589 | 2800.0 |
| 2011-12-20 07:10:00 | AAPL | Stock | 13.75 | 13.75 | 13.75 | 13.75 | 8400.0 |
| 2011-12-20 07:15:00 | AAPL | Stock | 13.7807 | 13.7857 | 13.7789 | 13.7789 | 66500.0 |
| 2011-12-20 07:20:00 | AAPL | Stock | 13.7789 | 13.8021 | 13.7789 | 13.8021 | 50960.0 |
| 2011-12-20 07:25:00 | AAPL | Stock | 13.7871 | 13.7871 | 13.7643 | 13.7643 | 16800.0 |
| 2011-12-20 07:35:00 | AAPL | Stock | 13.7657 | 13.7925 | 13.7657 | 13.7857 | 47600.0 |
| 2011-12-20 07:40:00 | AAPL | Stock | 13.7925 | 13.7964 | 13.7893 | 13.7961 | 33600.0 |
| 2011-12-20 07:45:00 | AAPL | Stock | 13.7946 | 13.7946 | 13.7946 | 13.7946 | 8400.0 |
| 2011-12-20 07:50:00 | AAPL | Stock | 13.7946 | 13.7946 | 13.7857 | 13.7896 | 84980.0 |
| 2011-12-20 07:55:00 | AAPL | Stock | 13.7939 | 13.8068 | 13.7857 | 13.7857 | 84784.0 |
| 2011-12-20 08:00:00 | AAPL | Stock | 13.7718 | 13.7964 | 13.7696 | 13.7714 | 169092.0 |
| 2011-12-20 08:05:00 | AAPL | Stock | 13.7732 | 13.7854 | 13.7561 | 13.7561 | 150808.0 |
| 2011-12-20 08:10:00 | AAPL | Stock | 13.7582 | 13.7668 | 13.7561 | 13.7668 | 48720.0 |
| 2011-12-20 08:15:00 | AAPL | Stock | 13.7671 | 13.7761 | 13.7671 | 13.7696 | 33600.0 |
| 2011-12-20 08:20:00 | AAPL | Stock | 13.7714 | 13.7782 | 13.7714 | 13.7782 | 5600.0 |
| 2011-12-20 08:30:00 | AAPL | Stock | 13.7746 | 13.775 | 13.7739 | 13.775 | 34972.0 |
| 2011-12-20 08:35:00 | AAPL | Stock | 13.7807 | 13.79 | 13.7804 | 13.7804 | 275576.0 |
| 2011-12-20 08:40:00 | AAPL | Stock | 13.7857 | 13.7875 | 13.7757 | 13.7836 | 106428.0 |
| 2011-12-20 08:45:00 | AAPL | Stock | 13.7793 | 13.7857 | 13.7793 | 13.7857 | 240744.0 |
| 2011-12-20 08:50:00 | AAPL | Stock | 13.7907 | 13.7929 | 13.7864 | 13.7893 | 90692.0 |
| 2011-12-20 08:55:00 | AAPL | Stock | 13.7918 | 13.7918 | 13.7875 | 13.7907 | 18172.0 |
| 2011-12-20 09:00:00 | AAPL | Stock | 13.7893 | 13.8125 | 13.7879 | 13.8071 | 233996.0 |
| 2011-12-20 09:05:00 | AAPL | Stock | 13.8132 | 13.8146 | 13.8075 | 13.8146 | 156660.0 |
| 2011-12-20 09:10:00 | AAPL | Stock | 13.8168 | 13.8311 | 13.8136 | 13.8214 | 364896.0 |
| 2011-12-20 09:15:00 | AAPL | Stock | 13.8214 | 13.8289 | 13.8214 | 13.8214 | 195860.0 |
| 2011-12-20 09:20:00 | AAPL | Stock | 13.8214 | 13.8296 | 13.8214 | 13.8268 | 263060.0 |
| 2011-12-20 09:25:00 | AAPL | Stock | 13.8289 | 13.8554 | 13.8139 | 13.8482 | 1304856.0 |
| 2011-12-20 09:30:00 | AAPL | Stock | 13.8486 | 13.8875 | 13.8307 | 13.8839 | 19970748.0 |
| 2011-12-20 09:35:00 | AAPL | Stock | 13.8839 | 13.8921 | 13.8393 | 13.8685 | 12131336.0 |
| 2011-12-20 09:40:00 | AAPL | Stock | 13.8686 | 13.9054 | 13.8643 | 13.8886 | 7008876.0 |
| 2011-12-20 09:45:00 | AAPL | Stock | 13.8889 | 13.9037 | 13.8839 | 13.8864 | 4967060.0 |
| 2011-12-20 09:50:00 | AAPL | Stock | 13.8896 | 13.9036 | 13.8857 | 13.9 | 3941168.0 |
| 2011-12-20 09:55:00 | AAPL | Stock | 13.9029 | 13.9125 | 13.8815 | 13.8871 | 5946248.0 |
| 2011-12-20 10:00:00 | AAPL | Stock | 13.8839 | 13.9061 | 13.8836 | 13.9043 | 3515316.0 |
| 2011-12-20 10:05:00 | AAPL | Stock | 13.9054 | 13.9214 | 13.9021 | 13.9081 | 5475848.0 |
| 2011-12-20 10:10:00 | AAPL | Stock | 13.9071 | 13.9189 | 13.905 | 13.9161 | 3079720.0 |
| 2011-12-20 10:15:00 | AAPL | Stock | 13.9175 | 13.9457 | 13.9136 | 13.9379 | 6396796.0 |
| 2011-12-20 10:20:00 | AAPL | Stock | 13.9375 | 13.9393 | 13.9221 | 13.9267 | 3477208.0 |
| 2011-12-20 10:25:00 | AAPL | Stock | 13.9279 | 13.9639 | 13.9275 | 13.9586 | 4407900.0 |
| 2011-12-20 10:30:00 | AAPL | Stock | 13.9561 | 13.9646 | 13.9514 | 13.9564 | 3548300.0 |
| 2011-12-20 10:35:00 | AAPL | Stock | 13.9571 | 13.9607 | 13.9439 | 13.9467 | 2944228.0 |
| 2011-12-20 10:40:00 | AAPL | Stock | 13.9472 | 13.9607 | 13.9439 | 13.9607 | 2202004.0 |
| 2011-12-20 10:45:00 | AAPL | Stock | 13.96 | 13.9721 | 13.9586 | 13.9664 | 4806508.0 |
| 2011-12-20 10:50:00 | AAPL | Stock | 13.965 | 13.9957 | 13.9646 | 13.9889 | 5313728.0 |
| 2011-12-20 10:55:00 | AAPL | Stock | 13.9882 | 14.0157 | 13.9882 | 14.0136 | 6512240.0 |
| 2011-12-20 11:00:00 | AAPL | Stock | 14.0139 | 14.0357 | 14.0114 | 14.0354 | 5103812.0 |
| 2011-12-20 11:05:00 | AAPL | Stock | 14.0349 | 14.0841 | 14.0346 | 14.0764 | 10980816.0 |
| 2011-12-20 11:10:00 | AAPL | Stock | 14.0754 | 14.0846 | 14.0607 | 14.0611 | 7934080.0 |
| 2011-12-20 11:15:00 | AAPL | Stock | 14.0604 | 14.0686 | 14.0525 | 14.0614 | 4844924.0 |
| 2011-12-20 11:20:00 | AAPL | Stock | 14.06 | 14.0614 | 14.0407 | 14.0469 | 3669960.0 |
> showing 50 of 337,742 rows — these rows as CSV