PREVIEW / stock_5min / 2012-12-14
file: by_date/stock_5min/2012/2012-12-14.parquet size: 4.7 MB rows: 318,479 symbols: 3,485
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-12-14 04:10:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 11200.0 |
| 2012-12-14 04:15:00 | AAPL | Stock | 18.875 | 18.8921 | 18.875 | 18.8921 | 11200.0 |
| 2012-12-14 04:35:00 | AAPL | Stock | 18.8911 | 18.8911 | 18.8911 | 18.8911 | 2800.0 |
| 2012-12-14 05:05:00 | AAPL | Stock | 18.875 | 18.875 | 18.8725 | 18.8725 | 19600.0 |
| 2012-12-14 05:10:00 | AAPL | Stock | 18.8871 | 18.8871 | 18.8871 | 18.8871 | 2800.0 |
| 2012-12-14 05:20:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8775 | 18.8775 | 5600.0 |
| 2012-12-14 05:25:00 | AAPL | Stock | 18.8661 | 18.875 | 18.8661 | 18.8661 | 27384.0 |
| 2012-12-14 05:30:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 7700.0 |
| 2012-12-14 05:35:00 | AAPL | Stock | 18.8407 | 18.8407 | 18.8393 | 18.8393 | 5600.0 |
| 2012-12-14 05:40:00 | AAPL | Stock | 18.8232 | 18.8232 | 18.8232 | 18.8232 | 2800.0 |
| 2012-12-14 05:50:00 | AAPL | Stock | 18.8225 | 18.8225 | 18.8225 | 18.8225 | 8400.0 |
| 2012-12-14 05:55:00 | AAPL | Stock | 18.8225 | 18.8225 | 18.8221 | 18.8221 | 5600.0 |
| 2012-12-14 06:00:00 | AAPL | Stock | 18.8214 | 18.8289 | 18.8214 | 18.8289 | 7980.0 |
| 2012-12-14 06:05:00 | AAPL | Stock | 18.8229 | 18.8354 | 18.8229 | 18.8354 | 5600.0 |
| 2012-12-14 06:10:00 | AAPL | Stock | 18.8189 | 18.8225 | 18.8189 | 18.8225 | 5600.0 |
| 2012-12-14 06:15:00 | AAPL | Stock | 18.8089 | 18.8089 | 18.7857 | 18.7857 | 8400.0 |
| 2012-12-14 06:20:00 | AAPL | Stock | 18.7857 | 18.7946 | 18.7857 | 18.7946 | 5600.0 |
| 2012-12-14 06:25:00 | AAPL | Stock | 18.7943 | 18.7943 | 18.7943 | 18.7943 | 5600.0 |
| 2012-12-14 06:30:00 | AAPL | Stock | 18.7929 | 18.7929 | 18.7929 | 18.7929 | 2800.0 |
| 2012-12-14 06:35:00 | AAPL | Stock | 18.7946 | 18.7971 | 18.7946 | 18.7946 | 28000.0 |
| 2012-12-14 06:40:00 | AAPL | Stock | 18.7843 | 18.7843 | 18.7679 | 18.7679 | 15400.0 |
| 2012-12-14 06:45:00 | AAPL | Stock | 18.7779 | 18.7779 | 18.7739 | 18.7739 | 7952.0 |
| 2012-12-14 06:55:00 | AAPL | Stock | 18.7836 | 18.7889 | 18.7739 | 18.7739 | 16800.0 |
| 2012-12-14 07:00:00 | AAPL | Stock | 18.7739 | 18.7814 | 18.7671 | 18.7686 | 43400.0 |
| 2012-12-14 07:05:00 | AAPL | Stock | 18.775 | 18.7864 | 18.7464 | 18.7496 | 104720.0 |
| 2012-12-14 07:10:00 | AAPL | Stock | 18.75 | 18.75 | 18.6968 | 18.6993 | 134316.0 |
| 2012-12-14 07:15:00 | AAPL | Stock | 18.7071 | 18.7071 | 18.6875 | 18.6893 | 93240.0 |
| 2012-12-14 07:20:00 | AAPL | Stock | 18.6879 | 18.6964 | 18.6543 | 18.6607 | 445872.0 |
| 2012-12-14 07:25:00 | AAPL | Stock | 18.6557 | 18.6639 | 18.6357 | 18.6375 | 154812.0 |
| 2012-12-14 07:30:00 | AAPL | Stock | 18.6393 | 18.6543 | 18.6311 | 18.6357 | 101920.0 |
| 2012-12-14 07:35:00 | AAPL | Stock | 18.6307 | 18.6568 | 18.5989 | 18.5989 | 386568.0 |
| 2012-12-14 07:40:00 | AAPL | Stock | 18.5871 | 18.6036 | 18.5825 | 18.5875 | 460320.0 |
| 2012-12-14 07:45:00 | AAPL | Stock | 18.5893 | 18.6071 | 18.5804 | 18.5896 | 586768.0 |
| 2012-12-14 07:50:00 | AAPL | Stock | 18.5843 | 18.585 | 18.5179 | 18.5179 | 672252.0 |
| 2012-12-14 07:55:00 | AAPL | Stock | 18.5179 | 18.5446 | 18.4814 | 18.4868 | 953596.0 |
| 2012-12-14 08:00:00 | AAPL | Stock | 18.4904 | 18.6564 | 18.4868 | 18.5643 | 2082920.0 |
| 2012-12-14 08:05:00 | AAPL | Stock | 18.5629 | 18.5629 | 18.5168 | 18.5307 | 1217440.0 |
| 2012-12-14 08:10:00 | AAPL | Stock | 18.5271 | 18.5675 | 18.5111 | 18.5536 | 914256.0 |
| 2012-12-14 08:15:00 | AAPL | Stock | 18.5539 | 18.5661 | 18.5357 | 18.5621 | 758576.0 |
| 2012-12-14 08:20:00 | AAPL | Stock | 18.5611 | 18.5864 | 18.5557 | 18.5629 | 1221864.0 |
| 2012-12-14 08:25:00 | AAPL | Stock | 18.5632 | 18.6157 | 18.5536 | 18.5711 | 1239308.0 |
| 2012-12-14 08:30:00 | AAPL | Stock | 18.5711 | 18.5714 | 18.5375 | 18.5421 | 793380.0 |
| 2012-12-14 08:35:00 | AAPL | Stock | 18.5425 | 18.5536 | 18.5357 | 18.5532 | 724864.0 |
| 2012-12-14 08:40:00 | AAPL | Stock | 18.5529 | 18.5643 | 18.5421 | 18.5586 | 747572.0 |
| 2012-12-14 08:45:00 | AAPL | Stock | 18.5582 | 18.5657 | 18.5189 | 18.5336 | 931588.0 |
| 2012-12-14 08:50:00 | AAPL | Stock | 18.5339 | 18.5354 | 18.4936 | 18.495 | 1777692.0 |
| 2012-12-14 08:55:00 | AAPL | Stock | 18.4964 | 18.5079 | 18.425 | 18.4282 | 3021760.0 |
| 2012-12-14 09:00:00 | AAPL | Stock | 18.4282 | 18.4521 | 18.3789 | 18.4521 | 4344172.0 |
| 2012-12-14 09:05:00 | AAPL | Stock | 18.4511 | 18.4721 | 18.4293 | 18.4457 | 1216208.0 |
| 2012-12-14 09:10:00 | AAPL | Stock | 18.4571 | 18.4625 | 18.3521 | 18.3529 | 2895816.0 |
> showing 50 of 318,479 rows — these rows as CSV