PREVIEW / stock_1min / 2014-02-20
file: by_date/stock_1min/2014/2014-02-20.parquet size: 14.5 MB rows: 1,056,608 symbols: 2,870
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-02-20 04:00:00 | AAPL | Stock | 19.1068 | 19.1068 | 19.1068 | 19.1068 | 5600.0 |
| 2014-02-20 04:06:00 | AAPL | Stock | 19.1139 | 19.1139 | 19.1139 | 19.1139 | 11200.0 |
| 2014-02-20 04:20:00 | AAPL | Stock | 19.1214 | 19.1214 | 19.1214 | 19.1214 | 2800.0 |
| 2014-02-20 04:33:00 | AAPL | Stock | 19.1118 | 19.1118 | 19.1118 | 19.1118 | 2800.0 |
| 2014-02-20 04:34:00 | AAPL | Stock | 19.1082 | 19.1082 | 19.1082 | 19.1082 | 2800.0 |
| 2014-02-20 04:36:00 | AAPL | Stock | 19.1275 | 19.1275 | 19.1275 | 19.1275 | 8400.0 |
| 2014-02-20 04:55:00 | AAPL | Stock | 19.1336 | 19.1336 | 19.1336 | 19.1336 | 2800.0 |
| 2014-02-20 04:56:00 | AAPL | Stock | 19.1486 | 19.1486 | 19.1486 | 19.1486 | 5600.0 |
| 2014-02-20 04:58:00 | AAPL | Stock | 19.1518 | 19.1518 | 19.1518 | 19.1518 | 11200.0 |
| 2014-02-20 05:34:00 | AAPL | Stock | 19.14 | 19.14 | 19.14 | 19.14 | 2800.0 |
| 2014-02-20 06:02:00 | AAPL | Stock | 19.125 | 19.125 | 19.125 | 19.125 | 5600.0 |
| 2014-02-20 06:03:00 | AAPL | Stock | 19.0825 | 19.0825 | 19.0775 | 19.0775 | 8400.0 |
| 2014-02-20 06:04:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0536 | 19.0536 | 33600.0 |
| 2014-02-20 06:05:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0536 | 19.0536 | 27272.0 |
| 2014-02-20 06:06:00 | AAPL | Stock | 19.0375 | 19.0375 | 19.0364 | 19.0364 | 16800.0 |
| 2014-02-20 06:08:00 | AAPL | Stock | 19.0282 | 19.0282 | 19.0282 | 19.0282 | 28000.0 |
| 2014-02-20 06:09:00 | AAPL | Stock | 19.0182 | 19.0182 | 19.0182 | 19.0182 | 2800.0 |
| 2014-02-20 06:11:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 2800.0 |
| 2014-02-20 06:12:00 | AAPL | Stock | 19.0096 | 19.0096 | 18.9957 | 18.9957 | 22400.0 |
| 2014-02-20 06:13:00 | AAPL | Stock | 19.0179 | 19.0179 | 18.9996 | 19.0179 | 55972.0 |
| 2014-02-20 06:14:00 | AAPL | Stock | 18.9971 | 18.9971 | 18.9971 | 18.9971 | 2800.0 |
| 2014-02-20 06:16:00 | AAPL | Stock | 19.0089 | 19.0089 | 18.9964 | 18.9964 | 32172.0 |
| 2014-02-20 06:17:00 | AAPL | Stock | 18.9857 | 18.9857 | 18.965 | 18.965 | 27860.0 |
| 2014-02-20 06:20:00 | AAPL | Stock | 18.975 | 18.975 | 18.975 | 18.975 | 2800.0 |
| 2014-02-20 06:21:00 | AAPL | Stock | 18.975 | 18.9757 | 18.975 | 18.9757 | 18284.0 |
| 2014-02-20 06:23:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 22400.0 |
| 2014-02-20 06:25:00 | AAPL | Stock | 18.9639 | 18.9639 | 18.9629 | 18.9629 | 6720.0 |
| 2014-02-20 06:26:00 | AAPL | Stock | 18.9639 | 18.9643 | 18.9639 | 18.9643 | 5600.0 |
| 2014-02-20 06:29:00 | AAPL | Stock | 18.9532 | 18.9532 | 18.9532 | 18.9532 | 2800.0 |
| 2014-02-20 06:30:00 | AAPL | Stock | 18.9557 | 18.9661 | 18.9557 | 18.9661 | 16800.0 |
| 2014-02-20 06:31:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9636 | 18.9636 | 20160.0 |
| 2014-02-20 06:38:00 | AAPL | Stock | 18.9764 | 18.9764 | 18.9764 | 18.9764 | 5600.0 |
| 2014-02-20 06:42:00 | AAPL | Stock | 18.9982 | 19.0 | 18.9982 | 19.0 | 16940.0 |
| 2014-02-20 06:49:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 11200.0 |
| 2014-02-20 06:50:00 | AAPL | Stock | 19.0179 | 19.0261 | 19.0179 | 19.0261 | 16800.0 |
| 2014-02-20 06:51:00 | AAPL | Stock | 19.0268 | 19.0282 | 19.0179 | 19.0282 | 18200.0 |
| 2014-02-20 06:53:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 5600.0 |
| 2014-02-20 06:55:00 | AAPL | Stock | 19.025 | 19.025 | 19.025 | 19.025 | 2800.0 |
| 2014-02-20 06:58:00 | AAPL | Stock | 19.0089 | 19.0175 | 19.0089 | 19.0175 | 9800.0 |
| 2014-02-20 06:59:00 | AAPL | Stock | 19.0129 | 19.0129 | 19.0129 | 19.0129 | 2800.0 |
| 2014-02-20 07:00:00 | AAPL | Stock | 19.0129 | 19.0129 | 19.0129 | 19.0129 | 5600.0 |
| 2014-02-20 07:02:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 5600.0 |
| 2014-02-20 07:04:00 | AAPL | Stock | 19.0143 | 19.0143 | 19.0089 | 19.0089 | 15400.0 |
| 2014-02-20 07:05:00 | AAPL | Stock | 19.0014 | 19.0014 | 18.9664 | 18.9664 | 75152.0 |
| 2014-02-20 07:06:00 | AAPL | Stock | 18.9964 | 18.9964 | 18.9821 | 18.9821 | 14280.0 |
| 2014-02-20 07:08:00 | AAPL | Stock | 18.9871 | 18.9889 | 18.9811 | 18.9821 | 51800.0 |
| 2014-02-20 07:10:00 | AAPL | Stock | 18.9821 | 18.9821 | 18.9786 | 18.9786 | 16660.0 |
| 2014-02-20 07:11:00 | AAPL | Stock | 18.9911 | 18.9911 | 18.9893 | 18.9911 | 97944.0 |
| 2014-02-20 07:13:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 2800.0 |
| 2014-02-20 07:14:00 | AAPL | Stock | 18.9986 | 19.0 | 18.9986 | 19.0 | 83300.0 |
> showing 50 of 1,056,608 rows — these rows as CSV