PREVIEW / stock_1min / 2013-02-27
file: by_date/stock_1min/2013/2013-02-27.parquet size: 13.2 MB rows: 974,202 symbols: 2,826
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-02-27 05:48:00 | AAPL | Stock | 15.9768 | 15.9768 | 15.9768 | 15.9768 | 8400.0 |
| 2013-02-27 06:02:00 | AAPL | Stock | 15.9886 | 15.9886 | 15.9886 | 15.9886 | 2800.0 |
| 2013-02-27 06:03:00 | AAPL | Stock | 15.9886 | 15.9886 | 15.9886 | 15.9886 | 8400.0 |
| 2013-02-27 06:32:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 14280.0 |
| 2013-02-27 06:35:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 12320.0 |
| 2013-02-27 06:51:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 5600.0 |
| 2013-02-27 06:52:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 8400.0 |
| 2013-02-27 06:53:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 3360.0 |
| 2013-02-27 06:54:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 5600.0 |
| 2013-02-27 07:01:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 2800.0 |
| 2013-02-27 07:02:00 | AAPL | Stock | 15.9929 | 15.9929 | 15.9929 | 15.9929 | 2800.0 |
| 2013-02-27 07:03:00 | AAPL | Stock | 15.9946 | 15.9946 | 15.9946 | 15.9946 | 2800.0 |
| 2013-02-27 07:04:00 | AAPL | Stock | 15.9929 | 15.9929 | 15.9929 | 15.9929 | 15400.0 |
| 2013-02-27 07:06:00 | AAPL | Stock | 15.9975 | 15.9975 | 15.9975 | 15.9975 | 2800.0 |
| 2013-02-27 07:10:00 | AAPL | Stock | 15.9975 | 16.0 | 15.9975 | 16.0 | 19880.0 |
| 2013-02-27 07:13:00 | AAPL | Stock | 16.0054 | 16.0089 | 16.0054 | 16.0089 | 7980.0 |
| 2013-02-27 07:16:00 | AAPL | Stock | 16.0143 | 16.0157 | 16.0143 | 16.0143 | 14000.0 |
| 2013-02-27 07:18:00 | AAPL | Stock | 16.0193 | 16.0232 | 16.0193 | 16.0232 | 14000.0 |
| 2013-02-27 07:19:00 | AAPL | Stock | 16.0214 | 16.0214 | 16.0214 | 16.0214 | 2800.0 |
| 2013-02-27 07:21:00 | AAPL | Stock | 16.0114 | 16.0114 | 16.0093 | 16.0114 | 8820.0 |
| 2013-02-27 07:22:00 | AAPL | Stock | 16.0004 | 16.0004 | 16.0 | 16.0 | 92400.0 |
| 2013-02-27 07:25:00 | AAPL | Stock | 15.9979 | 16.0 | 15.9979 | 16.0 | 5600.0 |
| 2013-02-27 07:30:00 | AAPL | Stock | 16.0064 | 16.0064 | 16.0064 | 16.0064 | 2800.0 |
| 2013-02-27 07:31:00 | AAPL | Stock | 15.9886 | 15.9886 | 15.9821 | 15.9821 | 36400.0 |
| 2013-02-27 07:32:00 | AAPL | Stock | 15.9989 | 15.9989 | 15.9989 | 15.9989 | 42000.0 |
| 2013-02-27 07:35:00 | AAPL | Stock | 15.9661 | 15.9714 | 15.9657 | 15.9714 | 38360.0 |
| 2013-02-27 07:37:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 2800.0 |
| 2013-02-27 07:38:00 | AAPL | Stock | 15.9796 | 15.9821 | 15.9668 | 15.9821 | 61600.0 |
| 2013-02-27 07:40:00 | AAPL | Stock | 15.9814 | 15.9818 | 15.9814 | 15.9818 | 8400.0 |
| 2013-02-27 07:41:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 2800.0 |
| 2013-02-27 07:42:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 9100.0 |
| 2013-02-27 07:45:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 2800.0 |
| 2013-02-27 07:48:00 | AAPL | Stock | 15.9725 | 15.9725 | 15.9725 | 15.9725 | 5600.0 |
| 2013-02-27 07:49:00 | AAPL | Stock | 15.9732 | 15.9732 | 15.9732 | 15.9732 | 2800.0 |
| 2013-02-27 07:51:00 | AAPL | Stock | 15.9811 | 15.9821 | 15.9811 | 15.9821 | 14000.0 |
| 2013-02-27 07:52:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 2800.0 |
| 2013-02-27 07:54:00 | AAPL | Stock | 15.9821 | 15.9979 | 15.9821 | 15.9821 | 95676.0 |
| 2013-02-27 07:55:00 | AAPL | Stock | 15.995 | 15.9968 | 15.995 | 15.9968 | 13580.0 |
| 2013-02-27 07:56:00 | AAPL | Stock | 15.9911 | 15.9911 | 15.9907 | 15.9911 | 36400.0 |
| 2013-02-27 07:57:00 | AAPL | Stock | 15.9911 | 15.9911 | 15.9821 | 15.9821 | 11200.0 |
| 2013-02-27 07:58:00 | AAPL | Stock | 15.9904 | 15.9904 | 15.9821 | 15.9821 | 7672.0 |
| 2013-02-27 07:59:00 | AAPL | Stock | 15.9761 | 15.9761 | 15.975 | 15.975 | 14000.0 |
| 2013-02-27 08:00:00 | AAPL | Stock | 15.9929 | 16.0179 | 15.9714 | 16.0179 | 95256.0 |
| 2013-02-27 08:01:00 | AAPL | Stock | 15.9889 | 15.9904 | 15.9732 | 15.9732 | 33488.0 |
| 2013-02-27 08:02:00 | AAPL | Stock | 15.9718 | 15.9736 | 15.9643 | 15.9646 | 106624.0 |
| 2013-02-27 08:03:00 | AAPL | Stock | 15.9607 | 15.97 | 15.9607 | 15.9643 | 86296.0 |
| 2013-02-27 08:04:00 | AAPL | Stock | 15.9643 | 15.9743 | 15.9643 | 15.9696 | 36260.0 |
| 2013-02-27 08:05:00 | AAPL | Stock | 15.9643 | 15.965 | 15.9554 | 15.9571 | 136976.0 |
| 2013-02-27 08:06:00 | AAPL | Stock | 15.9571 | 15.9571 | 15.9546 | 15.9546 | 7000.0 |
| 2013-02-27 08:08:00 | AAPL | Stock | 15.9643 | 15.9654 | 15.9643 | 15.9654 | 14000.0 |
> showing 50 of 974,202 rows — these rows as CSV