PREVIEW / stock_5min / 2013-10-22
file: by_date/stock_5min/2013/2013-10-22.parquet size: 5.4 MB rows: 356,695 symbols: 3,552
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-10-22 04:00:00 | AAPL | Stock | 18.75 | 18.75 | 18.7143 | 18.72 | 36400.0 |
| 2013-10-22 04:05:00 | AAPL | Stock | 18.7296 | 18.7296 | 18.7296 | 18.7296 | 8400.0 |
| 2013-10-22 04:10:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 11200.0 |
| 2013-10-22 04:55:00 | AAPL | Stock | 18.72 | 18.72 | 18.72 | 18.72 | 2800.0 |
| 2013-10-22 05:00:00 | AAPL | Stock | 18.72 | 18.72 | 18.72 | 18.72 | 2800.0 |
| 2013-10-22 05:25:00 | AAPL | Stock | 18.7232 | 18.7232 | 18.7207 | 18.7207 | 28000.0 |
| 2013-10-22 05:35:00 | AAPL | Stock | 18.7286 | 18.7296 | 18.7225 | 18.7225 | 15596.0 |
| 2013-10-22 05:40:00 | AAPL | Stock | 18.7225 | 18.7225 | 18.7225 | 18.7225 | 16800.0 |
| 2013-10-22 05:55:00 | AAPL | Stock | 18.7307 | 18.7404 | 18.7307 | 18.7404 | 13300.0 |
| 2013-10-22 06:00:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 8400.0 |
| 2013-10-22 06:05:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 3892.0 |
| 2013-10-22 06:10:00 | AAPL | Stock | 18.7464 | 18.7464 | 18.7143 | 18.7143 | 74032.0 |
| 2013-10-22 06:15:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 122108.0 |
| 2013-10-22 06:25:00 | AAPL | Stock | 18.7139 | 18.7143 | 18.7061 | 18.7061 | 37240.0 |
| 2013-10-22 06:30:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 30800.0 |
| 2013-10-22 06:35:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 9800.0 |
| 2013-10-22 06:40:00 | AAPL | Stock | 18.7143 | 18.73 | 18.7143 | 18.7154 | 31892.0 |
| 2013-10-22 06:45:00 | AAPL | Stock | 18.7311 | 18.7564 | 18.7311 | 18.7564 | 27916.0 |
| 2013-10-22 06:50:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7336 | 18.7643 | 30800.0 |
| 2013-10-22 07:00:00 | AAPL | Stock | 18.7843 | 18.7857 | 18.7607 | 18.7675 | 56756.0 |
| 2013-10-22 07:05:00 | AAPL | Stock | 18.7661 | 18.8018 | 18.7661 | 18.7943 | 164360.0 |
| 2013-10-22 07:10:00 | AAPL | Stock | 18.7943 | 18.8071 | 18.7786 | 18.7786 | 204400.0 |
| 2013-10-22 07:15:00 | AAPL | Stock | 18.775 | 18.7807 | 18.775 | 18.7807 | 195132.0 |
| 2013-10-22 07:20:00 | AAPL | Stock | 18.7768 | 18.7857 | 18.7768 | 18.7857 | 48524.0 |
| 2013-10-22 07:25:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7768 | 18.7768 | 98308.0 |
| 2013-10-22 07:30:00 | AAPL | Stock | 18.7768 | 18.7857 | 18.7768 | 18.7782 | 155260.0 |
| 2013-10-22 07:35:00 | AAPL | Stock | 18.7704 | 18.7704 | 18.7679 | 18.7679 | 28784.0 |
| 2013-10-22 07:40:00 | AAPL | Stock | 18.7682 | 18.7693 | 18.75 | 18.75 | 106988.0 |
| 2013-10-22 07:45:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7286 | 18.7375 | 138236.0 |
| 2013-10-22 07:50:00 | AAPL | Stock | 18.7496 | 18.75 | 18.7375 | 18.7411 | 88032.0 |
| 2013-10-22 07:55:00 | AAPL | Stock | 18.7421 | 18.75 | 18.7346 | 18.7496 | 183904.0 |
| 2013-10-22 08:00:00 | AAPL | Stock | 18.75 | 18.8036 | 18.7429 | 18.7429 | 356552.0 |
| 2013-10-22 08:05:00 | AAPL | Stock | 18.775 | 18.8179 | 18.7746 | 18.8036 | 618436.0 |
| 2013-10-22 08:10:00 | AAPL | Stock | 18.8139 | 18.8393 | 18.8032 | 18.8286 | 652596.0 |
| 2013-10-22 08:15:00 | AAPL | Stock | 18.8286 | 18.8429 | 18.8229 | 18.8393 | 288316.0 |
| 2013-10-22 08:20:00 | AAPL | Stock | 18.8393 | 18.8514 | 18.8214 | 18.8343 | 519428.0 |
| 2013-10-22 08:25:00 | AAPL | Stock | 18.8357 | 18.8589 | 18.8321 | 18.8518 | 445060.0 |
| 2013-10-22 08:30:00 | AAPL | Stock | 18.8514 | 18.8871 | 18.8304 | 18.8725 | 890204.0 |
| 2013-10-22 08:35:00 | AAPL | Stock | 18.8661 | 18.8668 | 18.8371 | 18.8393 | 343980.0 |
| 2013-10-22 08:40:00 | AAPL | Stock | 18.84 | 18.8514 | 18.8214 | 18.835 | 365764.0 |
| 2013-10-22 08:45:00 | AAPL | Stock | 18.8264 | 18.8386 | 18.8243 | 18.8371 | 76580.0 |
| 2013-10-22 08:50:00 | AAPL | Stock | 18.8357 | 18.8357 | 18.8286 | 18.8293 | 109732.0 |
| 2013-10-22 08:55:00 | AAPL | Stock | 18.8293 | 18.8296 | 18.8136 | 18.8214 | 357364.0 |
| 2013-10-22 09:00:00 | AAPL | Stock | 18.8211 | 18.8336 | 18.8146 | 18.8336 | 133616.0 |
| 2013-10-22 09:05:00 | AAPL | Stock | 18.8329 | 18.8571 | 18.8286 | 18.8536 | 244440.0 |
| 2013-10-22 09:10:00 | AAPL | Stock | 18.8543 | 18.8661 | 18.8504 | 18.8529 | 345604.0 |
| 2013-10-22 09:15:00 | AAPL | Stock | 18.8529 | 18.8589 | 18.8396 | 18.8557 | 225540.0 |
| 2013-10-22 09:20:00 | AAPL | Stock | 18.8543 | 18.8796 | 18.8504 | 18.8661 | 627284.0 |
| 2013-10-22 09:25:00 | AAPL | Stock | 18.8679 | 18.8679 | 18.7946 | 18.7996 | 799400.0 |
| 2013-10-22 09:30:00 | AAPL | Stock | 18.8029 | 18.8732 | 18.7857 | 18.8649 | 23520392.0 |
> showing 50 of 356,695 rows — these rows as CSV