PREVIEW / stock_5min / 2013-02-21
file: by_date/stock_5min/2013/2013-02-21.parquet size: 5.0 MB rows: 332,859 symbols: 3,486
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-02-21 05:45:00 | AAPL | Stock | 15.9339 | 15.9339 | 15.9339 | 15.9339 | 5600.0 |
| 2013-02-21 05:50:00 | AAPL | Stock | 15.9279 | 15.9279 | 15.9279 | 15.9279 | 5600.0 |
| 2013-02-21 06:45:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 2800.0 |
| 2013-02-21 06:55:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9118 | 15.9118 | 11200.0 |
| 2013-02-21 07:00:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9196 | 15.9196 | 2800.0 |
| 2013-02-21 07:05:00 | AAPL | Stock | 15.9264 | 15.9286 | 15.9264 | 15.9286 | 15148.0 |
| 2013-02-21 07:10:00 | AAPL | Stock | 15.9293 | 15.9364 | 15.9289 | 15.9364 | 11200.0 |
| 2013-02-21 07:15:00 | AAPL | Stock | 15.9293 | 15.9293 | 15.9261 | 15.9261 | 31640.0 |
| 2013-02-21 07:20:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9282 | 15.9286 | 30520.0 |
| 2013-02-21 07:25:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 5600.0 |
| 2013-02-21 07:30:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9196 | 15.9196 | 12040.0 |
| 2013-02-21 07:35:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.8929 | 15.9 | 99456.0 |
| 2013-02-21 07:40:00 | AAPL | Stock | 15.9089 | 15.9089 | 15.8857 | 15.8857 | 159292.0 |
| 2013-02-21 07:45:00 | AAPL | Stock | 15.8893 | 15.9104 | 15.8893 | 15.8939 | 105252.0 |
| 2013-02-21 07:50:00 | AAPL | Stock | 15.8993 | 15.9121 | 15.8975 | 15.9107 | 29400.0 |
| 2013-02-21 07:55:00 | AAPL | Stock | 15.9107 | 15.9161 | 15.9071 | 15.9079 | 39760.0 |
| 2013-02-21 08:00:00 | AAPL | Stock | 15.9157 | 15.9375 | 15.8936 | 15.9286 | 339444.0 |
| 2013-02-21 08:05:00 | AAPL | Stock | 15.935 | 16.0714 | 15.9286 | 15.9339 | 140812.0 |
| 2013-02-21 08:10:00 | AAPL | Stock | 15.9339 | 15.9382 | 15.9143 | 15.9143 | 156548.0 |
| 2013-02-21 08:15:00 | AAPL | Stock | 15.9157 | 15.9321 | 15.9146 | 15.9261 | 118020.0 |
| 2013-02-21 08:20:00 | AAPL | Stock | 15.9336 | 15.945 | 15.9289 | 15.9375 | 177100.0 |
| 2013-02-21 08:25:00 | AAPL | Stock | 15.945 | 15.975 | 15.9425 | 15.9643 | 212492.0 |
| 2013-02-21 08:30:00 | AAPL | Stock | 15.9729 | 15.9732 | 15.9411 | 15.9607 | 156352.0 |
| 2013-02-21 08:35:00 | AAPL | Stock | 15.9575 | 15.9786 | 15.9554 | 15.9768 | 191492.0 |
| 2013-02-21 08:40:00 | AAPL | Stock | 15.9782 | 16.0 | 15.9779 | 15.9914 | 282324.0 |
| 2013-02-21 08:45:00 | AAPL | Stock | 15.9839 | 15.9861 | 15.9761 | 15.9768 | 107436.0 |
| 2013-02-21 08:50:00 | AAPL | Stock | 15.9786 | 15.9786 | 15.9643 | 15.9661 | 70784.0 |
| 2013-02-21 08:55:00 | AAPL | Stock | 15.9661 | 15.9661 | 15.9268 | 15.9396 | 312844.0 |
| 2013-02-21 09:00:00 | AAPL | Stock | 15.945 | 15.9496 | 15.9232 | 15.9279 | 320796.0 |
| 2013-02-21 09:05:00 | AAPL | Stock | 15.9232 | 15.9371 | 15.9225 | 15.93 | 113960.0 |
| 2013-02-21 09:10:00 | AAPL | Stock | 15.9336 | 15.9429 | 15.9118 | 15.9179 | 193256.0 |
| 2013-02-21 09:15:00 | AAPL | Stock | 15.9182 | 15.9429 | 15.9182 | 15.9429 | 200732.0 |
| 2013-02-21 09:20:00 | AAPL | Stock | 15.9379 | 15.9457 | 15.9321 | 15.9457 | 379344.0 |
| 2013-02-21 09:25:00 | AAPL | Stock | 15.94 | 15.94 | 15.9143 | 15.9225 | 655564.0 |
| 2013-02-21 09:30:00 | AAPL | Stock | 15.9193 | 16.003 | 15.8757 | 15.89 | 20360116.0 |
| 2013-02-21 09:35:00 | AAPL | Stock | 15.89 | 15.9757 | 15.8682 | 15.9725 | 14524048.0 |
| 2013-02-21 09:40:00 | AAPL | Stock | 15.9743 | 15.9804 | 15.9068 | 15.9691 | 7570892.0 |
| 2013-02-21 09:45:00 | AAPL | Stock | 15.9636 | 15.9686 | 15.8971 | 15.91 | 7321328.0 |
| 2013-02-21 09:50:00 | AAPL | Stock | 15.9066 | 15.915 | 15.8454 | 15.8889 | 12238856.0 |
| 2013-02-21 09:55:00 | AAPL | Stock | 15.8996 | 15.9043 | 15.8646 | 15.9011 | 8197532.0 |
| 2013-02-21 10:00:00 | AAPL | Stock | 15.8982 | 15.9114 | 15.8539 | 15.8882 | 9045372.0 |
| 2013-02-21 10:05:00 | AAPL | Stock | 15.8882 | 15.91 | 15.8804 | 15.8932 | 4973920.0 |
| 2013-02-21 10:10:00 | AAPL | Stock | 15.8907 | 15.9107 | 15.8636 | 15.8954 | 5194476.0 |
| 2013-02-21 10:15:00 | AAPL | Stock | 15.8986 | 15.98 | 15.8934 | 15.9614 | 10384500.0 |
| 2013-02-21 10:20:00 | AAPL | Stock | 15.9664 | 16.0157 | 15.9493 | 15.9546 | 10591616.0 |
| 2013-02-21 10:25:00 | AAPL | Stock | 15.9589 | 15.9857 | 15.9529 | 15.9784 | 5121452.0 |
| 2013-02-21 10:30:00 | AAPL | Stock | 15.9864 | 15.9896 | 15.9557 | 15.9771 | 4102000.0 |
| 2013-02-21 10:35:00 | AAPL | Stock | 15.98 | 16.0118 | 15.9382 | 15.9578 | 6467328.0 |
| 2013-02-21 10:40:00 | AAPL | Stock | 15.9578 | 16.03 | 15.9511 | 16.0107 | 8545488.0 |
| 2013-02-21 10:45:00 | AAPL | Stock | 16.0107 | 16.0296 | 15.9832 | 15.9918 | 8370068.0 |
> showing 50 of 332,859 rows — these rows as CSV