PREVIEW / stock_1min / 2012-06-20
file: by_date/stock_1min/2012/2012-06-20.parquet size: 13.0 MB rows: 978,341 symbols: 2,813
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-06-20 06:21:00 | AAPL | Stock | 20.9732 | 20.9732 | 20.9732 | 20.9732 | 2800.0 |
| 2012-06-20 07:00:00 | AAPL | Stock | 20.9989 | 20.9989 | 20.9989 | 20.9989 | 2800.0 |
| 2012-06-20 07:03:00 | AAPL | Stock | 20.9914 | 20.9914 | 20.9911 | 20.9911 | 5600.0 |
| 2012-06-20 07:05:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 2800.0 |
| 2012-06-20 07:13:00 | AAPL | Stock | 21.0039 | 21.0039 | 21.0039 | 21.0039 | 11200.0 |
| 2012-06-20 07:14:00 | AAPL | Stock | 21.0114 | 21.0114 | 21.0114 | 21.0114 | 2800.0 |
| 2012-06-20 07:15:00 | AAPL | Stock | 21.0007 | 21.0007 | 21.0 | 21.0 | 5600.0 |
| 2012-06-20 07:16:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 28000.0 |
| 2012-06-20 07:18:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 2800.0 |
| 2012-06-20 07:19:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 2800.0 |
| 2012-06-20 07:20:00 | AAPL | Stock | 21.0171 | 21.0175 | 21.0171 | 21.0175 | 5600.0 |
| 2012-06-20 07:22:00 | AAPL | Stock | 21.0179 | 21.0214 | 21.0179 | 21.0214 | 14000.0 |
| 2012-06-20 07:25:00 | AAPL | Stock | 21.0179 | 21.0179 | 21.0179 | 21.0179 | 5600.0 |
| 2012-06-20 07:26:00 | AAPL | Stock | 21.0193 | 21.025 | 21.0193 | 21.025 | 11200.0 |
| 2012-06-20 07:31:00 | AAPL | Stock | 21.0268 | 21.0275 | 21.0268 | 21.0275 | 6580.0 |
| 2012-06-20 07:32:00 | AAPL | Stock | 21.03 | 21.0311 | 21.03 | 21.0311 | 5600.0 |
| 2012-06-20 07:39:00 | AAPL | Stock | 21.0275 | 21.0275 | 21.0275 | 21.0275 | 2800.0 |
| 2012-06-20 07:40:00 | AAPL | Stock | 21.0271 | 21.0271 | 21.0271 | 21.0271 | 2800.0 |
| 2012-06-20 07:50:00 | AAPL | Stock | 21.0107 | 21.0107 | 21.0107 | 21.0107 | 11200.0 |
| 2012-06-20 07:56:00 | AAPL | Stock | 21.0139 | 21.0143 | 21.0093 | 21.0143 | 14000.0 |
| 2012-06-20 07:57:00 | AAPL | Stock | 21.0039 | 21.0039 | 21.0039 | 21.0039 | 5600.0 |
| 2012-06-20 08:00:00 | AAPL | Stock | 21.0 | 21.0321 | 20.9911 | 20.9911 | 35700.0 |
| 2012-06-20 08:01:00 | AAPL | Stock | 20.9936 | 20.9946 | 20.9893 | 20.9911 | 39200.0 |
| 2012-06-20 08:02:00 | AAPL | Stock | 20.9875 | 20.9875 | 20.975 | 20.975 | 31500.0 |
| 2012-06-20 08:04:00 | AAPL | Stock | 20.9718 | 20.9718 | 20.9646 | 20.9711 | 27272.0 |
| 2012-06-20 08:05:00 | AAPL | Stock | 20.9543 | 20.9543 | 20.9507 | 20.9507 | 14000.0 |
| 2012-06-20 08:07:00 | AAPL | Stock | 20.9639 | 20.9643 | 20.9639 | 20.9643 | 14644.0 |
| 2012-06-20 08:08:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 5600.0 |
| 2012-06-20 08:10:00 | AAPL | Stock | 20.9679 | 20.9718 | 20.9679 | 20.9679 | 25200.0 |
| 2012-06-20 08:14:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9768 | 20.9768 | 19012.0 |
| 2012-06-20 08:15:00 | AAPL | Stock | 20.9768 | 20.9768 | 20.9768 | 20.9768 | 14000.0 |
| 2012-06-20 08:16:00 | AAPL | Stock | 20.9771 | 20.9771 | 20.9761 | 20.9768 | 17808.0 |
| 2012-06-20 08:17:00 | AAPL | Stock | 20.9804 | 20.9821 | 20.9804 | 20.9821 | 14000.0 |
| 2012-06-20 08:19:00 | AAPL | Stock | 20.9807 | 20.9821 | 20.9807 | 20.9821 | 11508.0 |
| 2012-06-20 08:20:00 | AAPL | Stock | 20.9818 | 20.9818 | 20.9818 | 20.9818 | 2800.0 |
| 2012-06-20 08:23:00 | AAPL | Stock | 20.9807 | 20.9846 | 20.9807 | 20.9846 | 27440.0 |
| 2012-06-20 08:25:00 | AAPL | Stock | 20.9957 | 20.9957 | 20.9957 | 20.9957 | 2800.0 |
| 2012-06-20 08:26:00 | AAPL | Stock | 20.9964 | 20.9964 | 20.9882 | 20.9882 | 8400.0 |
| 2012-06-20 08:27:00 | AAPL | Stock | 20.9946 | 20.9946 | 20.9946 | 20.9946 | 8400.0 |
| 2012-06-20 08:30:00 | AAPL | Stock | 20.9868 | 20.9868 | 20.9789 | 20.9789 | 22400.0 |
| 2012-06-20 08:31:00 | AAPL | Stock | 20.9775 | 20.9775 | 20.975 | 20.9754 | 12880.0 |
| 2012-06-20 08:32:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-06-20 08:35:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-06-20 08:36:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9821 | 20.9821 | 2800.0 |
| 2012-06-20 08:37:00 | AAPL | Stock | 20.9875 | 20.9875 | 20.9875 | 20.9875 | 2800.0 |
| 2012-06-20 08:38:00 | AAPL | Stock | 20.9871 | 20.9871 | 20.9861 | 20.9861 | 5600.0 |
| 2012-06-20 08:39:00 | AAPL | Stock | 20.9882 | 20.9886 | 20.9839 | 20.9886 | 19600.0 |
| 2012-06-20 08:40:00 | AAPL | Stock | 20.9882 | 20.9882 | 20.9882 | 20.9882 | 11200.0 |
| 2012-06-20 08:41:00 | AAPL | Stock | 20.9882 | 20.9932 | 20.9882 | 20.9932 | 8400.0 |
| 2012-06-20 08:44:00 | AAPL | Stock | 20.9889 | 20.9889 | 20.9889 | 20.9889 | 2800.0 |
> showing 50 of 978,341 rows — these rows as CSV