PREVIEW / stock_1min / 2014-05-05
file: by_date/stock_1min/2014/2014-05-05.parquet size: 14.0 MB rows: 1,039,464 symbols: 2,874
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-05 04:46:00 | AAPL | Stock | 21.1096 | 21.1096 | 21.1096 | 21.1096 | 2800.0 |
| 2014-05-05 04:48:00 | AAPL | Stock | 21.1096 | 21.1096 | 21.1096 | 21.1096 | 2800.0 |
| 2014-05-05 05:05:00 | AAPL | Stock | 21.0396 | 21.0396 | 21.0396 | 21.0396 | 2800.0 |
| 2014-05-05 05:37:00 | AAPL | Stock | 21.0286 | 21.0286 | 21.0286 | 21.0286 | 2800.0 |
| 2014-05-05 06:25:00 | AAPL | Stock | 21.0039 | 21.0039 | 21.0004 | 21.0004 | 5600.0 |
| 2014-05-05 06:46:00 | AAPL | Stock | 21.0314 | 21.0314 | 21.0314 | 21.0314 | 2800.0 |
| 2014-05-05 06:57:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 4200.0 |
| 2014-05-05 07:00:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2014-05-05 07:01:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2014-05-05 07:02:00 | AAPL | Stock | 21.0304 | 21.0357 | 21.0304 | 21.0357 | 5600.0 |
| 2014-05-05 07:12:00 | AAPL | Stock | 21.0179 | 21.0179 | 21.0179 | 21.0179 | 2800.0 |
| 2014-05-05 07:13:00 | AAPL | Stock | 21.0182 | 21.0182 | 21.0179 | 21.0179 | 5600.0 |
| 2014-05-05 07:18:00 | AAPL | Stock | 21.025 | 21.025 | 21.025 | 21.025 | 2800.0 |
| 2014-05-05 07:19:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2014-05-05 07:21:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 2800.0 |
| 2014-05-05 07:22:00 | AAPL | Stock | 21.0496 | 21.05 | 21.0496 | 21.05 | 8988.0 |
| 2014-05-05 07:28:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0536 | 21.0536 | 2800.0 |
| 2014-05-05 07:29:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0471 | 21.0471 | 12376.0 |
| 2014-05-05 07:31:00 | AAPL | Stock | 21.0471 | 21.0471 | 21.0471 | 21.0471 | 2800.0 |
| 2014-05-05 07:36:00 | AAPL | Stock | 21.0571 | 21.0571 | 21.0571 | 21.0571 | 2800.0 |
| 2014-05-05 07:37:00 | AAPL | Stock | 21.0679 | 21.0714 | 21.0679 | 21.0714 | 9800.0 |
| 2014-05-05 07:45:00 | AAPL | Stock | 21.0786 | 21.0786 | 21.0786 | 21.0786 | 7336.0 |
| 2014-05-05 07:49:00 | AAPL | Stock | 21.0632 | 21.0632 | 21.0632 | 21.0632 | 3220.0 |
| 2014-05-05 07:50:00 | AAPL | Stock | 21.0764 | 21.0768 | 21.0764 | 21.0764 | 11200.0 |
| 2014-05-05 07:54:00 | AAPL | Stock | 21.0682 | 21.0768 | 21.0682 | 21.0768 | 12600.0 |
| 2014-05-05 07:55:00 | AAPL | Stock | 21.0768 | 21.0768 | 21.0725 | 21.0725 | 16800.0 |
| 2014-05-05 07:56:00 | AAPL | Stock | 21.0768 | 21.0768 | 21.0768 | 21.0768 | 2800.0 |
| 2014-05-05 07:58:00 | AAPL | Stock | 21.0879 | 21.0879 | 21.0879 | 21.0879 | 5600.0 |
| 2014-05-05 07:59:00 | AAPL | Stock | 21.0886 | 21.0961 | 21.0886 | 21.0961 | 11200.0 |
| 2014-05-05 08:00:00 | AAPL | Stock | 21.0961 | 21.0979 | 21.0071 | 21.0893 | 79240.0 |
| 2014-05-05 08:01:00 | AAPL | Stock | 21.0836 | 21.0836 | 21.0804 | 21.0804 | 89964.0 |
| 2014-05-05 08:02:00 | AAPL | Stock | 21.075 | 21.0857 | 21.0714 | 21.0857 | 86520.0 |
| 2014-05-05 08:04:00 | AAPL | Stock | 21.0839 | 21.0839 | 21.0839 | 21.0839 | 5600.0 |
| 2014-05-05 08:05:00 | AAPL | Stock | 21.075 | 21.075 | 21.075 | 21.075 | 25200.0 |
| 2014-05-05 08:06:00 | AAPL | Stock | 21.0857 | 21.0857 | 21.0857 | 21.0857 | 2800.0 |
| 2014-05-05 08:07:00 | AAPL | Stock | 21.0871 | 21.0871 | 21.0861 | 21.0861 | 19600.0 |
| 2014-05-05 08:08:00 | AAPL | Stock | 21.0871 | 21.0964 | 21.0871 | 21.0964 | 42812.0 |
| 2014-05-05 08:09:00 | AAPL | Stock | 21.0964 | 21.0964 | 21.0964 | 21.0964 | 7980.0 |
| 2014-05-05 08:14:00 | AAPL | Stock | 21.0982 | 21.0982 | 21.0971 | 21.0971 | 8400.0 |
| 2014-05-05 08:15:00 | AAPL | Stock | 21.0964 | 21.0964 | 21.0964 | 21.0964 | 2800.0 |
| 2014-05-05 08:16:00 | AAPL | Stock | 21.0964 | 21.0979 | 21.0964 | 21.0979 | 14700.0 |
| 2014-05-05 08:17:00 | AAPL | Stock | 21.0979 | 21.1071 | 21.0964 | 21.1071 | 63644.0 |
| 2014-05-05 08:18:00 | AAPL | Stock | 21.1143 | 21.1143 | 21.1143 | 21.1143 | 4480.0 |
| 2014-05-05 08:21:00 | AAPL | Stock | 21.1036 | 21.1036 | 21.1036 | 21.1036 | 2800.0 |
| 2014-05-05 08:26:00 | AAPL | Stock | 21.0989 | 21.1104 | 21.0989 | 21.1104 | 14616.0 |
| 2014-05-05 08:27:00 | AAPL | Stock | 21.1014 | 21.1014 | 21.0982 | 21.0982 | 8400.0 |
| 2014-05-05 08:28:00 | AAPL | Stock | 21.0964 | 21.0964 | 21.0964 | 21.0964 | 2800.0 |
| 2014-05-05 08:30:00 | AAPL | Stock | 21.1025 | 21.1025 | 21.1025 | 21.1025 | 8400.0 |
| 2014-05-05 08:31:00 | AAPL | Stock | 21.1036 | 21.1036 | 21.1036 | 21.1036 | 2800.0 |
| 2014-05-05 08:32:00 | AAPL | Stock | 21.0982 | 21.105 | 21.0982 | 21.105 | 8400.0 |
> showing 50 of 1,039,464 rows — these rows as CSV