PREVIEW / stock_5min / 2013-10-17
file: by_date/stock_5min/2013/2013-10-17.parquet size: 5.3 MB rows: 350,970 symbols: 3,522
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-17 04:35:00 | AAPL | Stock | 17.8939 | 17.8939 | 17.8939 | 17.8939 | 2800.0 |
| 2013-10-17 05:10:00 | AAPL | Stock | 17.8718 | 17.8718 | 17.8679 | 17.87 | 16800.0 |
| 2013-10-17 05:20:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8661 | 17.8661 | 5600.0 |
| 2013-10-17 05:45:00 | AAPL | Stock | 17.8643 | 17.8643 | 17.8643 | 17.8643 | 8400.0 |
| 2013-10-17 05:55:00 | AAPL | Stock | 17.8643 | 17.8643 | 17.8607 | 17.8607 | 8400.0 |
| 2013-10-17 06:10:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-10-17 06:15:00 | AAPL | Stock | 17.8682 | 17.8682 | 17.8682 | 17.8682 | 7000.0 |
| 2013-10-17 06:25:00 | AAPL | Stock | 17.8843 | 17.8843 | 17.8843 | 17.8843 | 5600.0 |
| 2013-10-17 06:55:00 | AAPL | Stock | 17.8961 | 17.9018 | 17.8961 | 17.9018 | 14000.0 |
| 2013-10-17 07:00:00 | AAPL | Stock | 17.8936 | 17.9004 | 17.8893 | 17.9004 | 18200.0 |
| 2013-10-17 07:05:00 | AAPL | Stock | 17.9107 | 17.9304 | 17.8929 | 17.9132 | 67200.0 |
| 2013-10-17 07:10:00 | AAPL | Stock | 17.9243 | 17.9257 | 17.9243 | 17.9257 | 5600.0 |
| 2013-10-17 07:15:00 | AAPL | Stock | 17.9257 | 17.9439 | 17.92 | 17.9286 | 76244.0 |
| 2013-10-17 07:20:00 | AAPL | Stock | 17.9325 | 17.9325 | 17.9179 | 17.9179 | 38724.0 |
| 2013-10-17 07:25:00 | AAPL | Stock | 17.9268 | 17.9268 | 17.9268 | 17.9268 | 2800.0 |
| 2013-10-17 07:30:00 | AAPL | Stock | 17.9286 | 17.935 | 17.9218 | 17.935 | 51968.0 |
| 2013-10-17 07:35:00 | AAPL | Stock | 17.9282 | 17.9286 | 17.9143 | 17.9143 | 86408.0 |
| 2013-10-17 07:40:00 | AAPL | Stock | 17.9114 | 17.9136 | 17.9114 | 17.9136 | 5600.0 |
| 2013-10-17 07:45:00 | AAPL | Stock | 17.9161 | 17.9161 | 17.9018 | 17.9107 | 75600.0 |
| 2013-10-17 07:50:00 | AAPL | Stock | 17.9089 | 17.9107 | 17.9071 | 17.9107 | 14000.0 |
| 2013-10-17 07:55:00 | AAPL | Stock | 17.9054 | 17.9054 | 17.9054 | 17.9054 | 8400.0 |
| 2013-10-17 08:00:00 | AAPL | Stock | 17.91 | 17.9464 | 17.8929 | 17.8929 | 314440.0 |
| 2013-10-17 08:05:00 | AAPL | Stock | 17.895 | 17.895 | 17.8325 | 17.8325 | 440328.0 |
| 2013-10-17 08:10:00 | AAPL | Stock | 17.84 | 17.84 | 17.81 | 17.8293 | 359492.0 |
| 2013-10-17 08:15:00 | AAPL | Stock | 17.8307 | 17.8736 | 17.8307 | 17.8661 | 126000.0 |
| 2013-10-17 08:20:00 | AAPL | Stock | 17.8661 | 17.8886 | 17.8568 | 17.8825 | 115920.0 |
| 2013-10-17 08:25:00 | AAPL | Stock | 17.8579 | 17.8807 | 17.8579 | 17.875 | 72240.0 |
| 2013-10-17 08:30:00 | AAPL | Stock | 17.8643 | 17.8807 | 17.8643 | 17.8704 | 19600.0 |
| 2013-10-17 08:35:00 | AAPL | Stock | 17.8704 | 17.8707 | 17.85 | 17.85 | 104468.0 |
| 2013-10-17 08:40:00 | AAPL | Stock | 17.8464 | 17.8704 | 17.8432 | 17.865 | 220892.0 |
| 2013-10-17 08:45:00 | AAPL | Stock | 17.8679 | 17.8868 | 17.8679 | 17.8868 | 42000.0 |
| 2013-10-17 08:50:00 | AAPL | Stock | 17.8796 | 17.8804 | 17.8696 | 17.8696 | 50400.0 |
| 2013-10-17 08:55:00 | AAPL | Stock | 17.8696 | 17.8696 | 17.8679 | 17.8679 | 28000.0 |
| 2013-10-17 09:00:00 | AAPL | Stock | 17.8568 | 17.8618 | 17.8418 | 17.8571 | 112000.0 |
| 2013-10-17 09:05:00 | AAPL | Stock | 17.8571 | 17.8607 | 17.8568 | 17.8575 | 80416.0 |
| 2013-10-17 09:10:00 | AAPL | Stock | 17.8575 | 17.8661 | 17.8564 | 17.8564 | 108220.0 |
| 2013-10-17 09:15:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8339 | 17.8339 | 188412.0 |
| 2013-10-17 09:20:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8214 | 17.8304 | 235172.0 |
| 2013-10-17 09:25:00 | AAPL | Stock | 17.83 | 17.8571 | 17.8296 | 17.8536 | 467768.0 |
| 2013-10-17 09:30:00 | AAPL | Stock | 17.8536 | 17.9068 | 17.8457 | 17.9068 | 11991756.0 |
| 2013-10-17 09:35:00 | AAPL | Stock | 17.9064 | 17.9571 | 17.9064 | 17.9557 | 13004768.0 |
| 2013-10-17 09:40:00 | AAPL | Stock | 17.9521 | 17.9789 | 17.9467 | 17.9661 | 9847180.0 |
| 2013-10-17 09:45:00 | AAPL | Stock | 17.9704 | 17.9768 | 17.9296 | 17.9361 | 5723144.0 |
| 2013-10-17 09:50:00 | AAPL | Stock | 17.9361 | 17.9525 | 17.9018 | 17.9246 | 6350932.0 |
| 2013-10-17 09:55:00 | AAPL | Stock | 17.9231 | 17.9511 | 17.9164 | 17.9439 | 3248756.0 |
| 2013-10-17 10:00:00 | AAPL | Stock | 17.9493 | 17.9643 | 17.9386 | 17.9443 | 3680628.0 |
| 2013-10-17 10:05:00 | AAPL | Stock | 17.9411 | 17.9586 | 17.9189 | 17.9368 | 3494820.0 |
| 2013-10-17 10:10:00 | AAPL | Stock | 17.9396 | 17.9486 | 17.9257 | 17.9365 | 2186912.0 |
| 2013-10-17 10:15:00 | AAPL | Stock | 17.9411 | 17.9746 | 17.94 | 17.9714 | 4630248.0 |
| 2013-10-17 10:20:00 | AAPL | Stock | 17.9728 | 18.0054 | 17.9686 | 17.9954 | 7930552.0 |
> showing 50 of 350,970 rows — these rows as CSV