PREVIEW / stock_5min / 2013-07-08
file: by_date/stock_5min/2013/2013-07-08.parquet size: 5.1 MB rows: 345,112 symbols: 3,510
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-07-08 04:05:00 | AAPL | Stock | 14.9629 | 14.9629 | 14.9629 | 14.9629 | 13468.0 |
| 2013-07-08 05:05:00 | AAPL | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 4200.0 |
| 2013-07-08 06:00:00 | AAPL | Stock | 14.9989 | 14.9989 | 14.9989 | 14.9989 | 2800.0 |
| 2013-07-08 06:05:00 | AAPL | Stock | 14.9929 | 14.9929 | 14.9929 | 14.9929 | 22008.0 |
| 2013-07-08 06:40:00 | AAPL | Stock | 14.9964 | 14.9964 | 14.9964 | 14.9964 | 12880.0 |
| 2013-07-08 07:00:00 | AAPL | Stock | 14.9979 | 15.0 | 14.9979 | 15.0 | 24556.0 |
| 2013-07-08 07:05:00 | AAPL | Stock | 15.0061 | 15.0089 | 15.0061 | 15.0089 | 8400.0 |
| 2013-07-08 07:10:00 | AAPL | Stock | 15.0 | 15.0004 | 15.0 | 15.0 | 36400.0 |
| 2013-07-08 07:15:00 | AAPL | Stock | 15.0 | 15.0004 | 15.0 | 15.0 | 33600.0 |
| 2013-07-08 07:25:00 | AAPL | Stock | 14.9946 | 14.9946 | 14.9864 | 14.9929 | 29232.0 |
| 2013-07-08 07:30:00 | AAPL | Stock | 14.9929 | 14.9929 | 14.9836 | 14.9836 | 8400.0 |
| 2013-07-08 07:35:00 | AAPL | Stock | 14.9829 | 14.9829 | 14.9671 | 14.9821 | 59360.0 |
| 2013-07-08 07:50:00 | AAPL | Stock | 14.9732 | 14.9768 | 14.9732 | 14.9739 | 25228.0 |
| 2013-07-08 07:55:00 | AAPL | Stock | 14.9764 | 14.9775 | 14.9732 | 14.9732 | 44828.0 |
| 2013-07-08 08:00:00 | AAPL | Stock | 15.0 | 15.0 | 14.9732 | 14.9775 | 66080.0 |
| 2013-07-08 08:05:00 | AAPL | Stock | 14.8571 | 14.9746 | 14.8571 | 14.9507 | 80612.0 |
| 2013-07-08 08:10:00 | AAPL | Stock | 14.9589 | 14.9607 | 14.9482 | 14.9561 | 64372.0 |
| 2013-07-08 08:15:00 | AAPL | Stock | 14.9621 | 14.9639 | 14.9514 | 14.9564 | 78148.0 |
| 2013-07-08 08:20:00 | AAPL | Stock | 14.9536 | 14.9639 | 14.95 | 14.9639 | 105084.0 |
| 2013-07-08 08:25:00 | AAPL | Stock | 14.9571 | 14.9629 | 14.9543 | 14.9571 | 27720.0 |
| 2013-07-08 08:30:00 | AAPL | Stock | 14.9575 | 14.9629 | 14.9561 | 14.9625 | 14000.0 |
| 2013-07-08 08:35:00 | AAPL | Stock | 14.9625 | 14.9625 | 14.9571 | 14.9571 | 26264.0 |
| 2013-07-08 08:40:00 | AAPL | Stock | 14.9536 | 14.9604 | 14.95 | 14.9589 | 240744.0 |
| 2013-07-08 08:45:00 | AAPL | Stock | 14.9561 | 14.9639 | 14.9561 | 14.9625 | 51072.0 |
| 2013-07-08 08:50:00 | AAPL | Stock | 14.9582 | 14.9604 | 14.9514 | 14.9514 | 59388.0 |
| 2013-07-08 08:55:00 | AAPL | Stock | 14.9518 | 14.9582 | 14.9504 | 14.9536 | 135800.0 |
| 2013-07-08 09:00:00 | AAPL | Stock | 14.955 | 14.9614 | 14.955 | 14.96 | 50400.0 |
| 2013-07-08 09:05:00 | AAPL | Stock | 14.9571 | 14.975 | 14.9571 | 14.975 | 98868.0 |
| 2013-07-08 09:10:00 | AAPL | Stock | 14.9786 | 15.0179 | 14.9786 | 15.0179 | 386008.0 |
| 2013-07-08 09:15:00 | AAPL | Stock | 15.0214 | 15.0893 | 15.0179 | 15.0436 | 964152.0 |
| 2013-07-08 09:20:00 | AAPL | Stock | 15.0486 | 15.0536 | 15.0329 | 15.0357 | 181384.0 |
| 2013-07-08 09:25:00 | AAPL | Stock | 15.0318 | 15.0432 | 14.9957 | 15.0011 | 424620.0 |
| 2013-07-08 09:30:00 | AAPL | Stock | 15.0036 | 15.0357 | 14.9471 | 14.9696 | 14525224.0 |
| 2013-07-08 09:35:00 | AAPL | Stock | 14.9754 | 14.9918 | 14.9175 | 14.9596 | 7357084.0 |
| 2013-07-08 09:40:00 | AAPL | Stock | 14.9566 | 14.9786 | 14.8611 | 14.8932 | 8685236.0 |
| 2013-07-08 09:45:00 | AAPL | Stock | 14.8929 | 14.8982 | 14.8489 | 14.8791 | 7488572.0 |
| 2013-07-08 09:50:00 | AAPL | Stock | 14.8846 | 14.8879 | 14.8232 | 14.8321 | 6847792.0 |
| 2013-07-08 09:55:00 | AAPL | Stock | 14.8352 | 14.8375 | 14.7775 | 14.7993 | 11275124.0 |
| 2013-07-08 10:00:00 | AAPL | Stock | 14.7993 | 14.8318 | 14.7946 | 14.8121 | 7066388.0 |
| 2013-07-08 10:05:00 | AAPL | Stock | 14.8164 | 14.8443 | 14.8075 | 14.8282 | 4665640.0 |
| 2013-07-08 10:10:00 | AAPL | Stock | 14.8321 | 14.8339 | 14.7968 | 14.7971 | 5108992.0 |
| 2013-07-08 10:15:00 | AAPL | Stock | 14.7986 | 14.8279 | 14.7982 | 14.8139 | 3500952.0 |
| 2013-07-08 10:20:00 | AAPL | Stock | 14.8171 | 14.8243 | 14.7521 | 14.7654 | 8495956.0 |
| 2013-07-08 10:25:00 | AAPL | Stock | 14.7604 | 14.7636 | 14.7232 | 14.7271 | 7077588.0 |
| 2013-07-08 10:30:00 | AAPL | Stock | 14.7368 | 14.7393 | 14.6714 | 14.675 | 11965436.0 |
| 2013-07-08 10:35:00 | AAPL | Stock | 14.6725 | 14.7168 | 14.6661 | 14.7096 | 6869100.0 |
| 2013-07-08 10:40:00 | AAPL | Stock | 14.7086 | 14.715 | 14.6886 | 14.7114 | 4585028.0 |
| 2013-07-08 10:45:00 | AAPL | Stock | 14.7111 | 14.7629 | 14.6911 | 14.7436 | 8866844.0 |
| 2013-07-08 10:50:00 | AAPL | Stock | 14.7471 | 14.7489 | 14.7218 | 14.7264 | 5632844.0 |
| 2013-07-08 10:55:00 | AAPL | Stock | 14.7264 | 14.735 | 14.6986 | 14.7118 | 4822468.0 |
> showing 50 of 345,112 rows — these rows as CSV