PREVIEW / stock_5min / 2011-07-22
file: by_date/stock_5min/2011/2011-07-22.parquet size: 4.6 MB rows: 313,731 symbols: 3,530
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-07-22 04:10:00 | AAPL | Stock | 13.9032 | 13.9032 | 13.9029 | 13.9029 | 8400.0 |
| 2011-07-22 04:40:00 | AAPL | Stock | 13.9071 | 13.9071 | 13.9071 | 13.9071 | 14000.0 |
| 2011-07-22 04:45:00 | AAPL | Stock | 13.9104 | 13.9104 | 13.9104 | 13.9104 | 5600.0 |
| 2011-07-22 04:50:00 | AAPL | Stock | 13.9129 | 13.9129 | 13.9129 | 13.9129 | 2800.0 |
| 2011-07-22 06:30:00 | AAPL | Stock | 13.9218 | 13.9218 | 13.9118 | 13.9118 | 8400.0 |
| 2011-07-22 06:40:00 | AAPL | Stock | 13.9036 | 13.9036 | 13.9036 | 13.9036 | 2800.0 |
| 2011-07-22 06:55:00 | AAPL | Stock | 13.9036 | 13.9036 | 13.9018 | 13.9018 | 8400.0 |
| 2011-07-22 07:00:00 | AAPL | Stock | 13.9204 | 13.925 | 13.9204 | 13.925 | 44800.0 |
| 2011-07-22 07:05:00 | AAPL | Stock | 13.92 | 13.9286 | 13.8961 | 13.8961 | 35280.0 |
| 2011-07-22 07:15:00 | AAPL | Stock | 13.9111 | 13.915 | 13.9107 | 13.915 | 15400.0 |
| 2011-07-22 07:20:00 | AAPL | Stock | 13.9196 | 13.9196 | 13.9196 | 13.9196 | 28000.0 |
| 2011-07-22 07:25:00 | AAPL | Stock | 13.9086 | 13.9086 | 13.9082 | 13.9082 | 5600.0 |
| 2011-07-22 07:30:00 | AAPL | Stock | 13.9229 | 13.925 | 13.8986 | 13.8986 | 53200.0 |
| 2011-07-22 07:35:00 | AAPL | Stock | 13.9086 | 13.9086 | 13.895 | 13.9025 | 22400.0 |
| 2011-07-22 07:40:00 | AAPL | Stock | 13.8893 | 13.8893 | 13.8786 | 13.8821 | 49168.0 |
| 2011-07-22 07:45:00 | AAPL | Stock | 13.8821 | 13.8836 | 13.8586 | 13.8643 | 130088.0 |
| 2011-07-22 07:50:00 | AAPL | Stock | 13.8814 | 13.8814 | 13.8682 | 13.8682 | 16800.0 |
| 2011-07-22 07:55:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 5600.0 |
| 2011-07-22 08:00:00 | AAPL | Stock | 13.8746 | 13.9236 | 13.8432 | 13.8621 | 270900.0 |
| 2011-07-22 08:05:00 | AAPL | Stock | 13.8621 | 13.8714 | 13.8543 | 13.8714 | 61600.0 |
| 2011-07-22 08:10:00 | AAPL | Stock | 13.8664 | 13.8907 | 13.8318 | 13.8771 | 92568.0 |
| 2011-07-22 08:15:00 | AAPL | Stock | 13.8836 | 13.8836 | 13.8768 | 13.8832 | 57400.0 |
| 2011-07-22 08:20:00 | AAPL | Stock | 13.8836 | 13.8925 | 13.8571 | 13.8571 | 190932.0 |
| 2011-07-22 08:25:00 | AAPL | Stock | 13.8582 | 13.8693 | 13.8571 | 13.8607 | 49280.0 |
| 2011-07-22 08:30:00 | AAPL | Stock | 13.8586 | 13.8586 | 13.8454 | 13.8511 | 89600.0 |
| 2011-07-22 08:35:00 | AAPL | Stock | 13.8482 | 13.8482 | 13.8254 | 13.8321 | 163380.0 |
| 2011-07-22 08:40:00 | AAPL | Stock | 13.8354 | 13.85 | 13.8354 | 13.8464 | 44156.0 |
| 2011-07-22 08:45:00 | AAPL | Stock | 13.8446 | 13.8536 | 13.8446 | 13.8464 | 78400.0 |
| 2011-07-22 08:50:00 | AAPL | Stock | 13.8464 | 13.8536 | 13.8464 | 13.8536 | 25200.0 |
| 2011-07-22 08:55:00 | AAPL | Stock | 13.8514 | 13.8532 | 13.8507 | 13.8514 | 62300.0 |
| 2011-07-22 09:00:00 | AAPL | Stock | 13.8461 | 13.8504 | 13.8375 | 13.8375 | 92092.0 |
| 2011-07-22 09:05:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8393 | 13.8393 | 11200.0 |
| 2011-07-22 09:10:00 | AAPL | Stock | 13.8464 | 13.8561 | 13.8318 | 13.8546 | 145460.0 |
| 2011-07-22 09:15:00 | AAPL | Stock | 13.8479 | 13.8479 | 13.8214 | 13.8214 | 185416.0 |
| 2011-07-22 09:20:00 | AAPL | Stock | 13.8314 | 13.8371 | 13.8221 | 13.8371 | 64400.0 |
| 2011-07-22 09:25:00 | AAPL | Stock | 13.8289 | 13.875 | 13.8214 | 13.8686 | 764624.0 |
| 2011-07-22 09:30:00 | AAPL | Stock | 13.8686 | 13.9264 | 13.8482 | 13.9086 | 15417332.0 |
| 2011-07-22 09:35:00 | AAPL | Stock | 13.9093 | 13.9254 | 13.8995 | 13.9102 | 9868264.0 |
| 2011-07-22 09:40:00 | AAPL | Stock | 13.9119 | 13.9175 | 13.8825 | 13.9054 | 10369044.0 |
| 2011-07-22 09:45:00 | AAPL | Stock | 13.906 | 13.9286 | 13.8971 | 13.9257 | 11106900.0 |
| 2011-07-22 09:50:00 | AAPL | Stock | 13.9254 | 13.9286 | 13.8982 | 13.9139 | 6812708.0 |
| 2011-07-22 09:55:00 | AAPL | Stock | 13.9157 | 13.9214 | 13.8857 | 13.8962 | 6820492.0 |
| 2011-07-22 10:00:00 | AAPL | Stock | 13.8957 | 13.9179 | 13.8861 | 13.9134 | 6027980.0 |
| 2011-07-22 10:05:00 | AAPL | Stock | 13.9149 | 13.9425 | 13.913 | 13.9421 | 13357344.0 |
| 2011-07-22 10:10:00 | AAPL | Stock | 13.9411 | 13.9621 | 13.9403 | 13.9546 | 12637968.0 |
| 2011-07-22 10:15:00 | AAPL | Stock | 13.9543 | 13.9565 | 13.9107 | 13.9343 | 10580640.0 |
| 2011-07-22 10:20:00 | AAPL | Stock | 13.9332 | 13.9493 | 13.9114 | 13.9214 | 8245524.0 |
| 2011-07-22 10:25:00 | AAPL | Stock | 13.9243 | 13.9364 | 13.9157 | 13.9256 | 6123236.0 |
| 2011-07-22 10:30:00 | AAPL | Stock | 13.9214 | 13.9318 | 13.9189 | 13.929 | 4371808.0 |
| 2011-07-22 10:35:00 | AAPL | Stock | 13.9286 | 13.9464 | 13.9196 | 13.9339 | 6551468.0 |
> showing 50 of 313,731 rows — these rows as CSV