PREVIEW / stock_5min / 2013-01-10
file: by_date/stock_5min/2013/2013-01-10.parquet size: 4.9 MB rows: 329,152 symbols: 3,467
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-10 04:00:00 | AAPL | Stock | 18.4854 | 18.4854 | 18.4854 | 18.4854 | 2800.0 |
| 2013-01-10 04:30:00 | AAPL | Stock | 18.5293 | 18.5293 | 18.515 | 18.515 | 11200.0 |
| 2013-01-10 04:35:00 | AAPL | Stock | 18.5011 | 18.5143 | 18.5004 | 18.5129 | 28000.0 |
| 2013-01-10 04:40:00 | AAPL | Stock | 18.5111 | 18.5157 | 18.51 | 18.5111 | 45556.0 |
| 2013-01-10 04:45:00 | AAPL | Stock | 18.5121 | 18.515 | 18.5118 | 18.515 | 11200.0 |
| 2013-01-10 05:00:00 | AAPL | Stock | 18.5154 | 18.5157 | 18.5154 | 18.5157 | 22400.0 |
| 2013-01-10 05:05:00 | AAPL | Stock | 18.5157 | 18.5157 | 18.5157 | 18.5157 | 8400.0 |
| 2013-01-10 05:15:00 | AAPL | Stock | 18.5157 | 18.5157 | 18.5157 | 18.5157 | 2800.0 |
| 2013-01-10 05:20:00 | AAPL | Stock | 18.5157 | 18.5157 | 18.5157 | 18.5157 | 5600.0 |
| 2013-01-10 05:30:00 | AAPL | Stock | 18.5157 | 18.5157 | 18.5157 | 18.5157 | 75600.0 |
| 2013-01-10 05:35:00 | AAPL | Stock | 18.5157 | 18.5157 | 18.5157 | 18.5157 | 2800.0 |
| 2013-01-10 05:40:00 | AAPL | Stock | 18.5264 | 18.5264 | 18.5264 | 18.5264 | 2800.0 |
| 2013-01-10 05:45:00 | AAPL | Stock | 18.5264 | 18.5264 | 18.5264 | 18.5264 | 10640.0 |
| 2013-01-10 05:50:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 6664.0 |
| 2013-01-10 05:55:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5321 | 18.5321 | 8400.0 |
| 2013-01-10 06:00:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 21000.0 |
| 2013-01-10 06:05:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5321 | 18.5321 | 22400.0 |
| 2013-01-10 06:20:00 | AAPL | Stock | 18.5357 | 18.5536 | 18.5357 | 18.5536 | 131880.0 |
| 2013-01-10 06:30:00 | AAPL | Stock | 18.6 | 18.6 | 18.6 | 18.6 | 4760.0 |
| 2013-01-10 06:35:00 | AAPL | Stock | 18.5889 | 18.5889 | 18.5879 | 18.5879 | 14000.0 |
| 2013-01-10 06:40:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6064 | 18.6071 | 25200.0 |
| 2013-01-10 06:45:00 | AAPL | Stock | 18.5943 | 18.5943 | 18.575 | 18.5893 | 245168.0 |
| 2013-01-10 06:50:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 8400.0 |
| 2013-01-10 06:55:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 19068.0 |
| 2013-01-10 07:00:00 | AAPL | Stock | 18.5779 | 18.5893 | 18.5625 | 18.5629 | 85624.0 |
| 2013-01-10 07:05:00 | AAPL | Stock | 18.5625 | 18.5793 | 18.5625 | 18.5793 | 115920.0 |
| 2013-01-10 07:10:00 | AAPL | Stock | 18.5789 | 18.6236 | 18.5786 | 18.6071 | 608020.0 |
| 2013-01-10 07:15:00 | AAPL | Stock | 18.5929 | 18.6068 | 18.5893 | 18.5989 | 36540.0 |
| 2013-01-10 07:20:00 | AAPL | Stock | 18.5896 | 18.6232 | 18.5896 | 18.6232 | 244664.0 |
| 2013-01-10 07:25:00 | AAPL | Stock | 18.6154 | 18.6168 | 18.595 | 18.5982 | 168560.0 |
| 2013-01-10 07:30:00 | AAPL | Stock | 18.5996 | 18.6068 | 18.5996 | 18.6 | 118132.0 |
| 2013-01-10 07:35:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6 | 18.6068 | 161028.0 |
| 2013-01-10 07:40:00 | AAPL | Stock | 18.6071 | 18.6461 | 18.595 | 18.6411 | 134400.0 |
| 2013-01-10 07:45:00 | AAPL | Stock | 18.6286 | 18.6786 | 18.6132 | 18.6786 | 346892.0 |
| 2013-01-10 07:50:00 | AAPL | Stock | 18.6711 | 18.7429 | 18.6696 | 18.7146 | 626920.0 |
| 2013-01-10 07:55:00 | AAPL | Stock | 18.7146 | 18.7411 | 18.7143 | 18.7357 | 478044.0 |
| 2013-01-10 08:00:00 | AAPL | Stock | 18.7346 | 18.7482 | 18.6786 | 18.7357 | 1300488.0 |
| 2013-01-10 08:05:00 | AAPL | Stock | 18.7321 | 18.7357 | 18.7236 | 18.7346 | 315532.0 |
| 2013-01-10 08:10:00 | AAPL | Stock | 18.7346 | 18.7821 | 18.7346 | 18.7786 | 838152.0 |
| 2013-01-10 08:15:00 | AAPL | Stock | 18.7786 | 18.8204 | 18.7714 | 18.8204 | 1148252.0 |
| 2013-01-10 08:20:00 | AAPL | Stock | 18.82 | 18.9107 | 18.8125 | 18.9107 | 1706572.0 |
| 2013-01-10 08:25:00 | AAPL | Stock | 18.9036 | 18.9929 | 18.843 | 18.9246 | 4033652.0 |
| 2013-01-10 08:30:00 | AAPL | Stock | 18.9196 | 18.9514 | 18.8932 | 18.9321 | 1233064.0 |
| 2013-01-10 08:35:00 | AAPL | Stock | 18.9479 | 18.95 | 18.8839 | 18.8839 | 728280.0 |
| 2013-01-10 08:40:00 | AAPL | Stock | 18.8804 | 18.9125 | 18.865 | 18.9104 | 878276.0 |
| 2013-01-10 08:45:00 | AAPL | Stock | 18.9104 | 18.9243 | 18.8786 | 18.9175 | 927304.0 |
| 2013-01-10 08:50:00 | AAPL | Stock | 18.9164 | 18.9164 | 18.8646 | 18.8657 | 464128.0 |
| 2013-01-10 08:55:00 | AAPL | Stock | 18.8729 | 18.8929 | 18.8661 | 18.8875 | 316008.0 |
| 2013-01-10 09:00:00 | AAPL | Stock | 18.89 | 18.9464 | 18.89 | 18.9068 | 1199492.0 |
| 2013-01-10 09:05:00 | AAPL | Stock | 18.9089 | 18.9096 | 18.8754 | 18.8893 | 506996.0 |
> showing 50 of 329,152 rows — these rows as CSV