PREVIEW / stock_5min / 2011-09-21
file: by_date/stock_5min/2011/2011-09-21.parquet size: 4.7 MB rows: 320,342 symbols: 3,500
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-09-21 04:05:00 | AAPL | Stock | 14.8457 | 14.8475 | 14.8393 | 14.8393 | 25200.0 |
| 2011-09-21 04:10:00 | AAPL | Stock | 14.8475 | 14.8475 | 14.8475 | 14.8475 | 2800.0 |
| 2011-09-21 04:15:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 2800.0 |
| 2011-09-21 04:35:00 | AAPL | Stock | 14.7793 | 14.7964 | 14.7793 | 14.7964 | 16520.0 |
| 2011-09-21 04:40:00 | AAPL | Stock | 14.7818 | 14.7818 | 14.7818 | 14.7818 | 2800.0 |
| 2011-09-21 04:50:00 | AAPL | Stock | 14.8039 | 14.8039 | 14.8039 | 14.8039 | 2800.0 |
| 2011-09-21 05:05:00 | AAPL | Stock | 14.8129 | 14.8129 | 14.8129 | 14.8129 | 2800.0 |
| 2011-09-21 05:15:00 | AAPL | Stock | 14.8343 | 14.8343 | 14.8343 | 14.8343 | 2800.0 |
| 2011-09-21 05:20:00 | AAPL | Stock | 14.8457 | 14.8468 | 14.8343 | 14.8343 | 11200.0 |
| 2011-09-21 05:35:00 | AAPL | Stock | 14.8736 | 14.8736 | 14.8736 | 14.8736 | 2800.0 |
| 2011-09-21 05:45:00 | AAPL | Stock | 14.8557 | 14.8557 | 14.8557 | 14.8557 | 2800.0 |
| 2011-09-21 06:00:00 | AAPL | Stock | 14.8321 | 14.8321 | 14.8286 | 14.8286 | 5600.0 |
| 2011-09-21 06:25:00 | AAPL | Stock | 14.8364 | 14.8364 | 14.8364 | 14.8364 | 2800.0 |
| 2011-09-21 06:30:00 | AAPL | Stock | 14.8386 | 14.8386 | 14.8386 | 14.8386 | 2800.0 |
| 2011-09-21 06:50:00 | AAPL | Stock | 14.8254 | 14.8254 | 14.8254 | 14.8254 | 2800.0 |
| 2011-09-21 07:00:00 | AAPL | Stock | 14.8254 | 14.8696 | 14.825 | 14.8696 | 152600.0 |
| 2011-09-21 07:05:00 | AAPL | Stock | 14.8796 | 14.9179 | 14.8746 | 14.9104 | 123480.0 |
| 2011-09-21 07:10:00 | AAPL | Stock | 14.9107 | 14.9107 | 14.9107 | 14.9107 | 22400.0 |
| 2011-09-21 07:15:00 | AAPL | Stock | 14.8929 | 14.8929 | 14.8696 | 14.875 | 144368.0 |
| 2011-09-21 07:20:00 | AAPL | Stock | 14.8696 | 14.8804 | 14.8429 | 14.875 | 77252.0 |
| 2011-09-21 07:25:00 | AAPL | Stock | 14.8804 | 14.9221 | 14.8804 | 14.9221 | 133560.0 |
| 2011-09-21 07:30:00 | AAPL | Stock | 14.9221 | 14.9221 | 14.8957 | 14.8989 | 164500.0 |
| 2011-09-21 07:35:00 | AAPL | Stock | 14.8982 | 14.9071 | 14.8854 | 14.8929 | 113960.0 |
| 2011-09-21 07:40:00 | AAPL | Stock | 14.8754 | 14.8754 | 14.8571 | 14.8575 | 141624.0 |
| 2011-09-21 07:45:00 | AAPL | Stock | 14.8496 | 14.8496 | 14.8304 | 14.8414 | 125188.0 |
| 2011-09-21 07:50:00 | AAPL | Stock | 14.8432 | 14.8664 | 14.8393 | 14.8393 | 115024.0 |
| 2011-09-21 07:55:00 | AAPL | Stock | 14.8432 | 14.8432 | 14.8268 | 14.8286 | 69160.0 |
| 2011-09-21 08:00:00 | AAPL | Stock | 14.8304 | 14.8554 | 14.8036 | 14.8125 | 477008.0 |
| 2011-09-21 08:05:00 | AAPL | Stock | 14.8082 | 14.8193 | 14.8082 | 14.8143 | 177268.0 |
| 2011-09-21 08:10:00 | AAPL | Stock | 14.8164 | 14.8196 | 14.8036 | 14.8036 | 395584.0 |
| 2011-09-21 08:15:00 | AAPL | Stock | 14.7993 | 14.8 | 14.7821 | 14.7979 | 270200.0 |
| 2011-09-21 08:20:00 | AAPL | Stock | 14.7918 | 14.8207 | 14.7918 | 14.8164 | 257292.0 |
| 2011-09-21 08:25:00 | AAPL | Stock | 14.8161 | 14.8429 | 14.8043 | 14.8429 | 272720.0 |
| 2011-09-21 08:30:00 | AAPL | Stock | 14.845 | 14.8618 | 14.8429 | 14.8568 | 260708.0 |
| 2011-09-21 08:35:00 | AAPL | Stock | 14.8539 | 14.8739 | 14.8493 | 14.85 | 275268.0 |
| 2011-09-21 08:40:00 | AAPL | Stock | 14.8521 | 14.8554 | 14.8429 | 14.8529 | 259056.0 |
| 2011-09-21 08:45:00 | AAPL | Stock | 14.8493 | 14.8671 | 14.8493 | 14.8661 | 221760.0 |
| 2011-09-21 08:50:00 | AAPL | Stock | 14.8657 | 14.9096 | 14.8643 | 14.8843 | 603288.0 |
| 2011-09-21 08:55:00 | AAPL | Stock | 14.8846 | 14.9036 | 14.8839 | 14.9011 | 263592.0 |
| 2011-09-21 09:00:00 | AAPL | Stock | 14.9 | 14.9086 | 14.8839 | 14.9054 | 537236.0 |
| 2011-09-21 09:05:00 | AAPL | Stock | 14.9018 | 14.9225 | 14.8839 | 14.9225 | 787836.0 |
| 2011-09-21 09:10:00 | AAPL | Stock | 14.9246 | 14.9857 | 14.9129 | 14.9604 | 2236052.0 |
| 2011-09-21 09:15:00 | AAPL | Stock | 14.9604 | 14.9786 | 14.9479 | 14.975 | 1026816.0 |
| 2011-09-21 09:20:00 | AAPL | Stock | 14.975 | 14.9879 | 14.9571 | 14.9671 | 690340.0 |
| 2011-09-21 09:25:00 | AAPL | Stock | 14.9643 | 14.995 | 14.9618 | 14.9868 | 1247988.0 |
| 2011-09-21 09:30:00 | AAPL | Stock | 14.9893 | 14.9996 | 14.9425 | 14.9916 | 23613912.0 |
| 2011-09-21 09:35:00 | AAPL | Stock | 14.9909 | 15.0568 | 14.9707 | 14.9725 | 22294580.0 |
| 2011-09-21 09:40:00 | AAPL | Stock | 14.9721 | 14.9818 | 14.9104 | 14.9228 | 16959768.0 |
| 2011-09-21 09:45:00 | AAPL | Stock | 14.9223 | 14.9821 | 14.91 | 14.9299 | 11676420.0 |
| 2011-09-21 09:50:00 | AAPL | Stock | 14.9282 | 14.9421 | 14.8829 | 14.9421 | 13336988.0 |
> showing 50 of 320,342 rows — these rows as CSV