PREVIEW / stock_5min / 2012-02-14
file: by_date/stock_5min/2012/2012-02-14.parquet size: 4.8 MB rows: 324,962 symbols: 3,527
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-14 04:00:00 | AAPL | Stock | 17.9643 | 18.0696 | 17.9643 | 18.0404 | 90020.0 |
| 2012-02-14 04:05:00 | AAPL | Stock | 18.05 | 18.05 | 18.0286 | 18.0286 | 53200.0 |
| 2012-02-14 04:10:00 | AAPL | Stock | 18.0357 | 18.0439 | 18.0357 | 18.0429 | 28000.0 |
| 2012-02-14 04:15:00 | AAPL | Stock | 18.0429 | 18.0464 | 18.0429 | 18.0464 | 8400.0 |
| 2012-02-14 04:20:00 | AAPL | Stock | 18.0536 | 18.0536 | 18.0536 | 18.0536 | 2800.0 |
| 2012-02-14 04:25:00 | AAPL | Stock | 18.0536 | 18.0671 | 18.0489 | 18.0671 | 8960.0 |
| 2012-02-14 04:40:00 | AAPL | Stock | 18.0486 | 18.0486 | 18.0486 | 18.0486 | 14000.0 |
| 2012-02-14 04:45:00 | AAPL | Stock | 18.0636 | 18.0636 | 18.0536 | 18.0536 | 19600.0 |
| 2012-02-14 04:50:00 | AAPL | Stock | 18.0643 | 18.0643 | 18.0643 | 18.0643 | 2800.0 |
| 2012-02-14 04:55:00 | AAPL | Stock | 18.0711 | 18.0714 | 18.0711 | 18.0714 | 10500.0 |
| 2012-02-14 05:00:00 | AAPL | Stock | 18.0779 | 18.0779 | 18.065 | 18.065 | 33600.0 |
| 2012-02-14 05:05:00 | AAPL | Stock | 18.0586 | 18.0586 | 18.0586 | 18.0586 | 5600.0 |
| 2012-02-14 05:10:00 | AAPL | Stock | 18.0711 | 18.0711 | 18.0711 | 18.0711 | 2800.0 |
| 2012-02-14 05:15:00 | AAPL | Stock | 18.0693 | 18.0714 | 18.0693 | 18.0714 | 29960.0 |
| 2012-02-14 05:20:00 | AAPL | Stock | 18.0714 | 18.1071 | 18.0714 | 18.1071 | 25200.0 |
| 2012-02-14 05:25:00 | AAPL | Stock | 18.1068 | 18.1068 | 18.1068 | 18.1068 | 8400.0 |
| 2012-02-14 05:30:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1071 | 18.1071 | 9800.0 |
| 2012-02-14 05:35:00 | AAPL | Stock | 18.0886 | 18.0886 | 18.0857 | 18.0857 | 11200.0 |
| 2012-02-14 05:50:00 | AAPL | Stock | 18.1 | 18.1071 | 18.1 | 18.1071 | 36400.0 |
| 2012-02-14 05:55:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1071 | 18.1071 | 2800.0 |
| 2012-02-14 06:05:00 | AAPL | Stock | 18.1 | 18.1 | 18.1 | 18.1 | 12040.0 |
| 2012-02-14 06:10:00 | AAPL | Stock | 18.1179 | 18.1179 | 18.1179 | 18.1179 | 2800.0 |
| 2012-02-14 06:15:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0714 | 18.075 | 36400.0 |
| 2012-02-14 06:20:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0714 | 18.0714 | 33628.0 |
| 2012-02-14 06:25:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0893 | 18.0893 | 2800.0 |
| 2012-02-14 06:35:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.075 | 18.075 | 11200.0 |
| 2012-02-14 06:40:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0875 | 18.0875 | 36400.0 |
| 2012-02-14 06:45:00 | AAPL | Stock | 18.0843 | 18.0864 | 18.075 | 18.075 | 50400.0 |
| 2012-02-14 06:50:00 | AAPL | Stock | 18.0771 | 18.0771 | 18.0686 | 18.0714 | 33600.0 |
| 2012-02-14 07:00:00 | AAPL | Stock | 18.075 | 18.0804 | 18.0529 | 18.0643 | 237944.0 |
| 2012-02-14 07:05:00 | AAPL | Stock | 18.0657 | 18.0714 | 18.0643 | 18.0714 | 70000.0 |
| 2012-02-14 07:10:00 | AAPL | Stock | 18.0736 | 18.0736 | 18.065 | 18.065 | 122640.0 |
| 2012-02-14 07:15:00 | AAPL | Stock | 18.065 | 18.0689 | 18.0589 | 18.0668 | 89600.0 |
| 2012-02-14 07:20:00 | AAPL | Stock | 18.0646 | 18.0646 | 18.0593 | 18.0614 | 40656.0 |
| 2012-02-14 07:25:00 | AAPL | Stock | 18.0689 | 18.0696 | 18.06 | 18.0625 | 124600.0 |
| 2012-02-14 07:30:00 | AAPL | Stock | 18.0693 | 18.0718 | 18.0689 | 18.0714 | 84252.0 |
| 2012-02-14 07:35:00 | AAPL | Stock | 18.0679 | 18.07 | 18.0582 | 18.0625 | 94612.0 |
| 2012-02-14 07:40:00 | AAPL | Stock | 18.0607 | 18.0607 | 18.0496 | 18.0514 | 51800.0 |
| 2012-02-14 07:45:00 | AAPL | Stock | 18.045 | 18.0568 | 18.0446 | 18.0464 | 61880.0 |
| 2012-02-14 07:50:00 | AAPL | Stock | 18.0446 | 18.0521 | 18.0311 | 18.0329 | 128912.0 |
| 2012-02-14 07:55:00 | AAPL | Stock | 18.0329 | 18.0446 | 18.0232 | 18.0232 | 120540.0 |
| 2012-02-14 08:00:00 | AAPL | Stock | 18.0336 | 18.075 | 17.9832 | 17.9857 | 842324.0 |
| 2012-02-14 08:05:00 | AAPL | Stock | 17.9925 | 17.9964 | 17.9857 | 17.99 | 193088.0 |
| 2012-02-14 08:10:00 | AAPL | Stock | 17.99 | 18.0054 | 17.99 | 18.0054 | 293160.0 |
| 2012-02-14 08:15:00 | AAPL | Stock | 18.0054 | 18.0214 | 18.0 | 18.0161 | 526680.0 |
| 2012-02-14 08:20:00 | AAPL | Stock | 18.0121 | 18.0179 | 18.0057 | 18.0086 | 464324.0 |
| 2012-02-14 08:25:00 | AAPL | Stock | 18.0086 | 18.0146 | 18.0071 | 18.0071 | 111188.0 |
| 2012-02-14 08:30:00 | AAPL | Stock | 18.0071 | 18.0143 | 17.9879 | 18.0 | 433748.0 |
| 2012-02-14 08:35:00 | AAPL | Stock | 17.9987 | 18.0089 | 17.9975 | 18.0071 | 74424.0 |
| 2012-02-14 08:40:00 | AAPL | Stock | 18.0025 | 18.0061 | 17.9882 | 17.9911 | 327292.0 |
> showing 50 of 324,962 rows — these rows as CSV