PREVIEW / stock_5min / 2011-12-08
file: by_date/stock_5min/2011/2011-12-08.parquet size: 4.8 MB rows: 323,103 symbols: 3,492
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-08 04:05:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 8400.0 |
| 2011-12-08 04:15:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 2800.0 |
| 2011-12-08 04:30:00 | AAPL | Stock | 13.8411 | 13.8411 | 13.8411 | 13.8411 | 5600.0 |
| 2011-12-08 06:40:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 14000.0 |
| 2011-12-08 07:00:00 | AAPL | Stock | 13.9054 | 13.9354 | 13.9054 | 13.9286 | 28000.0 |
| 2011-12-08 07:05:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-12-08 07:10:00 | AAPL | Stock | 13.9321 | 13.9457 | 13.9321 | 13.9457 | 29820.0 |
| 2011-12-08 07:15:00 | AAPL | Stock | 13.9357 | 13.9593 | 13.9336 | 13.9593 | 137340.0 |
| 2011-12-08 07:20:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9464 | 13.9464 | 5600.0 |
| 2011-12-08 07:25:00 | AAPL | Stock | 13.9518 | 13.9682 | 13.9475 | 13.9643 | 47460.0 |
| 2011-12-08 07:30:00 | AAPL | Stock | 13.9643 | 13.9782 | 13.9643 | 13.975 | 65800.0 |
| 2011-12-08 07:35:00 | AAPL | Stock | 13.9679 | 13.9914 | 13.9571 | 13.9857 | 184184.0 |
| 2011-12-08 07:40:00 | AAPL | Stock | 13.9979 | 14.0 | 13.98 | 13.98 | 119980.0 |
| 2011-12-08 07:45:00 | AAPL | Stock | 13.9789 | 14.0179 | 13.9643 | 14.0179 | 352800.0 |
| 2011-12-08 07:50:00 | AAPL | Stock | 14.0182 | 14.0386 | 14.0025 | 14.0314 | 221200.0 |
| 2011-12-08 07:55:00 | AAPL | Stock | 14.0314 | 14.0589 | 14.0261 | 14.0311 | 144200.0 |
| 2011-12-08 08:00:00 | AAPL | Stock | 14.0214 | 14.0404 | 14.0096 | 14.0404 | 482720.0 |
| 2011-12-08 08:05:00 | AAPL | Stock | 14.0318 | 14.0318 | 14.015 | 14.0214 | 97580.0 |
| 2011-12-08 08:10:00 | AAPL | Stock | 14.02 | 14.0357 | 14.01 | 14.0107 | 362880.0 |
| 2011-12-08 08:15:00 | AAPL | Stock | 14.0107 | 14.0211 | 14.0107 | 14.0146 | 81116.0 |
| 2011-12-08 08:20:00 | AAPL | Stock | 14.0175 | 14.0175 | 14.0161 | 14.0161 | 16800.0 |
| 2011-12-08 08:25:00 | AAPL | Stock | 14.0229 | 14.0229 | 14.0107 | 14.0179 | 97020.0 |
| 2011-12-08 08:30:00 | AAPL | Stock | 14.0179 | 14.0471 | 14.0171 | 14.0446 | 427140.0 |
| 2011-12-08 08:35:00 | AAPL | Stock | 14.0446 | 14.0618 | 14.0446 | 14.0579 | 403060.0 |
| 2011-12-08 08:40:00 | AAPL | Stock | 14.06 | 14.0768 | 14.06 | 14.0721 | 608664.0 |
| 2011-12-08 08:45:00 | AAPL | Stock | 14.0679 | 14.07 | 14.025 | 14.035 | 945560.0 |
| 2011-12-08 08:50:00 | AAPL | Stock | 14.0321 | 14.0357 | 14.01 | 14.0196 | 406700.0 |
| 2011-12-08 08:55:00 | AAPL | Stock | 14.0179 | 14.0529 | 14.0114 | 14.0229 | 802284.0 |
| 2011-12-08 09:00:00 | AAPL | Stock | 14.0186 | 14.0229 | 13.97 | 13.9943 | 692300.0 |
| 2011-12-08 09:05:00 | AAPL | Stock | 13.9925 | 13.9957 | 13.9393 | 13.9464 | 817936.0 |
| 2011-12-08 09:10:00 | AAPL | Stock | 13.9464 | 13.9911 | 13.9289 | 13.9821 | 490420.0 |
| 2011-12-08 09:15:00 | AAPL | Stock | 13.9821 | 13.9839 | 13.9679 | 13.9757 | 301028.0 |
| 2011-12-08 09:20:00 | AAPL | Stock | 13.9757 | 13.9871 | 13.9757 | 13.9768 | 112000.0 |
| 2011-12-08 09:25:00 | AAPL | Stock | 13.9764 | 13.9925 | 13.9732 | 13.9854 | 258468.0 |
| 2011-12-08 09:30:00 | AAPL | Stock | 13.9811 | 14.0714 | 13.9714 | 14.0471 | 21507024.0 |
| 2011-12-08 09:35:00 | AAPL | Stock | 14.0485 | 14.0485 | 14.0179 | 14.0441 | 8041768.0 |
| 2011-12-08 09:40:00 | AAPL | Stock | 14.0411 | 14.0521 | 14.0107 | 14.0304 | 7365736.0 |
| 2011-12-08 09:45:00 | AAPL | Stock | 14.0295 | 14.1025 | 14.0254 | 14.0904 | 15780324.0 |
| 2011-12-08 09:50:00 | AAPL | Stock | 14.0908 | 14.125 | 14.0886 | 14.1107 | 13018236.0 |
| 2011-12-08 09:55:00 | AAPL | Stock | 14.1132 | 14.1136 | 14.0804 | 14.0916 | 6256572.0 |
| 2011-12-08 10:00:00 | AAPL | Stock | 14.0889 | 14.1014 | 14.0561 | 14.0582 | 7559048.0 |
| 2011-12-08 10:05:00 | AAPL | Stock | 14.0604 | 14.0707 | 14.0368 | 14.0514 | 8677648.0 |
| 2011-12-08 10:10:00 | AAPL | Stock | 14.0532 | 14.0832 | 14.0489 | 14.061 | 5298216.0 |
| 2011-12-08 10:15:00 | AAPL | Stock | 14.0607 | 14.07 | 14.01 | 14.0118 | 7616924.0 |
| 2011-12-08 10:20:00 | AAPL | Stock | 14.0121 | 14.041 | 14.0111 | 14.0282 | 4959136.0 |
| 2011-12-08 10:25:00 | AAPL | Stock | 14.0275 | 14.0389 | 14.0218 | 14.0281 | 2838640.0 |
| 2011-12-08 10:30:00 | AAPL | Stock | 14.0264 | 14.1025 | 14.0221 | 14.0955 | 7956760.0 |
| 2011-12-08 10:35:00 | AAPL | Stock | 14.0961 | 14.1071 | 14.0789 | 14.0882 | 7293580.0 |
| 2011-12-08 10:40:00 | AAPL | Stock | 14.0876 | 14.0893 | 14.0716 | 14.0849 | 3804612.0 |
| 2011-12-08 10:45:00 | AAPL | Stock | 14.0846 | 14.1039 | 14.0786 | 14.0857 | 4051180.0 |
> showing 50 of 323,103 rows — these rows as CSV