PREVIEW / stock_5min / 2013-05-30
file: by_date/stock_5min/2013/2013-05-30.parquet size: 5.1 MB rows: 336,948 symbols: 3,508
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-05-30 04:15:00 | AAPL | Stock | 15.875 | 15.875 | 15.875 | 15.875 | 3920.0 |
| 2013-05-30 05:15:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.8929 | 15.8929 | 2800.0 |
| 2013-05-30 06:40:00 | AAPL | Stock | 15.8839 | 15.8839 | 15.8839 | 15.8839 | 2800.0 |
| 2013-05-30 06:55:00 | AAPL | Stock | 15.91 | 15.91 | 15.91 | 15.91 | 3472.0 |
| 2013-05-30 07:00:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9196 | 15.9196 | 2800.0 |
| 2013-05-30 07:05:00 | AAPL | Stock | 15.9404 | 15.9896 | 15.9404 | 15.9871 | 28000.0 |
| 2013-05-30 07:10:00 | AAPL | Stock | 15.9821 | 16.0082 | 15.9821 | 16.0082 | 32844.0 |
| 2013-05-30 07:15:00 | AAPL | Stock | 16.0 | 16.0254 | 16.0 | 16.0254 | 67676.0 |
| 2013-05-30 07:20:00 | AAPL | Stock | 16.0254 | 16.0354 | 16.0161 | 16.0161 | 42000.0 |
| 2013-05-30 07:25:00 | AAPL | Stock | 16.0039 | 16.0039 | 15.9843 | 15.9893 | 35000.0 |
| 2013-05-30 07:30:00 | AAPL | Stock | 15.9861 | 15.9861 | 15.9857 | 15.9857 | 5740.0 |
| 2013-05-30 07:35:00 | AAPL | Stock | 15.9975 | 16.0 | 15.9814 | 15.9814 | 80472.0 |
| 2013-05-30 07:40:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9507 | 15.9643 | 133644.0 |
| 2013-05-30 07:45:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9539 | 15.9554 | 12460.0 |
| 2013-05-30 07:50:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9639 | 15.9639 | 5600.0 |
| 2013-05-30 07:55:00 | AAPL | Stock | 15.9507 | 15.9507 | 15.9286 | 15.9304 | 33600.0 |
| 2013-05-30 08:00:00 | AAPL | Stock | 15.9379 | 16.0004 | 15.9107 | 15.9286 | 150500.0 |
| 2013-05-30 08:05:00 | AAPL | Stock | 15.93 | 15.9379 | 15.9286 | 15.9379 | 11200.0 |
| 2013-05-30 08:10:00 | AAPL | Stock | 15.9393 | 15.9393 | 15.9382 | 15.9389 | 14000.0 |
| 2013-05-30 08:15:00 | AAPL | Stock | 15.9393 | 15.9393 | 15.9321 | 15.9371 | 39200.0 |
| 2013-05-30 08:20:00 | AAPL | Stock | 15.93 | 15.93 | 15.9268 | 15.9293 | 36820.0 |
| 2013-05-30 08:25:00 | AAPL | Stock | 15.9289 | 15.9429 | 15.9289 | 15.9429 | 64372.0 |
| 2013-05-30 08:30:00 | AAPL | Stock | 15.9464 | 15.9786 | 15.9396 | 15.9643 | 183512.0 |
| 2013-05-30 08:35:00 | AAPL | Stock | 15.9614 | 15.9729 | 15.95 | 15.9625 | 97552.0 |
| 2013-05-30 08:40:00 | AAPL | Stock | 15.9625 | 15.9654 | 15.9625 | 15.9643 | 158116.0 |
| 2013-05-30 08:45:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9504 | 15.9504 | 87220.0 |
| 2013-05-30 08:50:00 | AAPL | Stock | 15.95 | 15.9664 | 15.9393 | 15.9464 | 136640.0 |
| 2013-05-30 08:55:00 | AAPL | Stock | 15.9429 | 15.955 | 15.9429 | 15.9511 | 72800.0 |
| 2013-05-30 09:00:00 | AAPL | Stock | 15.9471 | 15.9493 | 15.9446 | 15.9493 | 48300.0 |
| 2013-05-30 09:05:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9382 | 15.9414 | 65800.0 |
| 2013-05-30 09:10:00 | AAPL | Stock | 15.9382 | 15.9461 | 15.88 | 15.8846 | 608216.0 |
| 2013-05-30 09:15:00 | AAPL | Stock | 15.8918 | 15.9111 | 15.8857 | 15.9071 | 347396.0 |
| 2013-05-30 09:20:00 | AAPL | Stock | 15.9071 | 15.9121 | 15.8896 | 15.9054 | 268996.0 |
| 2013-05-30 09:25:00 | AAPL | Stock | 15.9107 | 15.9179 | 15.9036 | 15.9161 | 123452.0 |
| 2013-05-30 09:30:00 | AAPL | Stock | 15.9057 | 15.9854 | 15.9036 | 15.9686 | 12026868.0 |
| 2013-05-30 09:35:00 | AAPL | Stock | 15.9668 | 15.9761 | 15.8936 | 15.925 | 8259916.0 |
| 2013-05-30 09:40:00 | AAPL | Stock | 15.9261 | 15.9343 | 15.8757 | 15.8821 | 5992420.0 |
| 2013-05-30 09:45:00 | AAPL | Stock | 15.8821 | 15.9082 | 15.8754 | 15.8996 | 7489776.0 |
| 2013-05-30 09:50:00 | AAPL | Stock | 15.9 | 15.9457 | 15.9 | 15.9304 | 6002388.0 |
| 2013-05-30 09:55:00 | AAPL | Stock | 15.9304 | 15.9946 | 15.9245 | 15.9917 | 10505964.0 |
| 2013-05-30 10:00:00 | AAPL | Stock | 15.9886 | 15.9993 | 15.9657 | 15.9914 | 9640064.0 |
| 2013-05-30 10:05:00 | AAPL | Stock | 15.9914 | 15.9914 | 15.9361 | 15.9421 | 8811712.0 |
| 2013-05-30 10:10:00 | AAPL | Stock | 15.9421 | 15.9554 | 15.9332 | 15.9407 | 4920272.0 |
| 2013-05-30 10:15:00 | AAPL | Stock | 15.9425 | 15.9621 | 15.9358 | 15.9546 | 3272640.0 |
| 2013-05-30 10:20:00 | AAPL | Stock | 15.9589 | 15.9589 | 15.93 | 15.9314 | 4266024.0 |
| 2013-05-30 10:25:00 | AAPL | Stock | 15.9332 | 15.9529 | 15.9236 | 15.9432 | 2684780.0 |
| 2013-05-30 10:30:00 | AAPL | Stock | 15.9482 | 15.9492 | 15.9157 | 15.92 | 3924620.0 |
| 2013-05-30 10:35:00 | AAPL | Stock | 15.9189 | 15.9307 | 15.9164 | 15.9175 | 1420384.0 |
| 2013-05-30 10:40:00 | AAPL | Stock | 15.9161 | 15.9354 | 15.9157 | 15.925 | 2718912.0 |
| 2013-05-30 10:45:00 | AAPL | Stock | 15.925 | 15.9268 | 15.9036 | 15.9168 | 3451336.0 |
> showing 50 of 336,948 rows — these rows as CSV