PREVIEW / stock_1min / 2014-03-07
file: by_date/stock_1min/2014/2014-03-07.parquet size: 15.0 MB rows: 1,079,334 symbols: 2,878
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-03-07 04:07:00 | AAPL | Stock | 18.9557 | 18.9557 | 18.9557 | 18.9557 | 2800.0 |
| 2014-03-07 04:08:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 2800.0 |
| 2014-03-07 06:21:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 5600.0 |
| 2014-03-07 06:36:00 | AAPL | Stock | 18.9796 | 18.9796 | 18.9796 | 18.9796 | 14000.0 |
| 2014-03-07 07:08:00 | AAPL | Stock | 18.9786 | 18.9786 | 18.9786 | 18.9786 | 2800.0 |
| 2014-03-07 07:11:00 | AAPL | Stock | 18.9739 | 18.9739 | 18.9739 | 18.9739 | 5600.0 |
| 2014-03-07 07:12:00 | AAPL | Stock | 18.9768 | 18.9786 | 18.9764 | 18.9764 | 8400.0 |
| 2014-03-07 07:52:00 | AAPL | Stock | 18.9646 | 18.9646 | 18.9646 | 18.9646 | 2800.0 |
| 2014-03-07 08:01:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2014-03-07 08:08:00 | AAPL | Stock | 18.9589 | 18.9589 | 18.9589 | 18.9589 | 14000.0 |
| 2014-03-07 08:10:00 | AAPL | Stock | 18.9571 | 18.9571 | 18.9571 | 18.9571 | 2800.0 |
| 2014-03-07 08:11:00 | AAPL | Stock | 18.9536 | 18.9536 | 18.9464 | 18.9464 | 8400.0 |
| 2014-03-07 08:13:00 | AAPL | Stock | 18.945 | 18.9471 | 18.9429 | 18.9429 | 17360.0 |
| 2014-03-07 08:14:00 | AAPL | Stock | 18.9429 | 18.9429 | 18.9429 | 18.9429 | 2800.0 |
| 2014-03-07 08:16:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9321 | 18.9321 | 19432.0 |
| 2014-03-07 08:17:00 | AAPL | Stock | 18.9236 | 18.9236 | 18.9196 | 18.9196 | 11200.0 |
| 2014-03-07 08:21:00 | AAPL | Stock | 18.9179 | 18.9179 | 18.9179 | 18.9179 | 3388.0 |
| 2014-03-07 08:22:00 | AAPL | Stock | 18.9107 | 18.9179 | 18.8971 | 18.8971 | 30800.0 |
| 2014-03-07 08:23:00 | AAPL | Stock | 18.8989 | 18.9143 | 18.8968 | 18.9143 | 16800.0 |
| 2014-03-07 08:24:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.8929 | 18.8929 | 8400.0 |
| 2014-03-07 08:25:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 14000.0 |
| 2014-03-07 08:26:00 | AAPL | Stock | 18.9086 | 18.91 | 18.9086 | 18.91 | 8092.0 |
| 2014-03-07 08:28:00 | AAPL | Stock | 18.9086 | 18.9086 | 18.9086 | 18.9086 | 2800.0 |
| 2014-03-07 08:30:00 | AAPL | Stock | 18.9179 | 18.9632 | 18.8986 | 18.9311 | 171276.0 |
| 2014-03-07 08:31:00 | AAPL | Stock | 18.9464 | 18.9546 | 18.9411 | 18.95 | 58800.0 |
| 2014-03-07 08:32:00 | AAPL | Stock | 18.9536 | 18.975 | 18.95 | 18.9661 | 51520.0 |
| 2014-03-07 08:33:00 | AAPL | Stock | 18.9525 | 18.9661 | 18.9504 | 18.9536 | 75600.0 |
| 2014-03-07 08:34:00 | AAPL | Stock | 18.9639 | 18.9732 | 18.9625 | 18.9732 | 66976.0 |
| 2014-03-07 08:35:00 | AAPL | Stock | 18.9682 | 18.9764 | 18.9682 | 18.9764 | 16800.0 |
| 2014-03-07 08:36:00 | AAPL | Stock | 18.9768 | 18.9796 | 18.9725 | 18.9786 | 91392.0 |
| 2014-03-07 08:37:00 | AAPL | Stock | 18.9796 | 18.9796 | 18.9779 | 18.9796 | 40852.0 |
| 2014-03-07 08:38:00 | AAPL | Stock | 18.9786 | 18.9857 | 18.9786 | 18.9854 | 39200.0 |
| 2014-03-07 08:39:00 | AAPL | Stock | 18.98 | 18.9811 | 18.9732 | 18.9732 | 19600.0 |
| 2014-03-07 08:40:00 | AAPL | Stock | 18.98 | 18.98 | 18.98 | 18.98 | 14000.0 |
| 2014-03-07 08:41:00 | AAPL | Stock | 18.9857 | 18.9882 | 18.9829 | 18.9829 | 15400.0 |
| 2014-03-07 08:42:00 | AAPL | Stock | 18.9886 | 18.9957 | 18.9886 | 18.9929 | 45276.0 |
| 2014-03-07 08:43:00 | AAPL | Stock | 18.9957 | 18.9957 | 18.9946 | 18.9946 | 13720.0 |
| 2014-03-07 08:44:00 | AAPL | Stock | 18.9943 | 18.9943 | 18.9821 | 18.9821 | 18508.0 |
| 2014-03-07 08:46:00 | AAPL | Stock | 18.9889 | 18.9889 | 18.9889 | 18.9889 | 5600.0 |
| 2014-03-07 08:47:00 | AAPL | Stock | 18.9821 | 18.9821 | 18.9821 | 18.9821 | 11144.0 |
| 2014-03-07 08:48:00 | AAPL | Stock | 18.9925 | 18.9925 | 18.9925 | 18.9925 | 2800.0 |
| 2014-03-07 08:49:00 | AAPL | Stock | 18.9861 | 18.9914 | 18.9729 | 18.9729 | 28308.0 |
| 2014-03-07 08:50:00 | AAPL | Stock | 18.975 | 18.9771 | 18.975 | 18.9771 | 8400.0 |
| 2014-03-07 08:51:00 | AAPL | Stock | 18.9714 | 18.9714 | 18.9714 | 18.9714 | 14000.0 |
| 2014-03-07 08:53:00 | AAPL | Stock | 18.975 | 18.9818 | 18.975 | 18.9818 | 13860.0 |
| 2014-03-07 08:54:00 | AAPL | Stock | 18.9761 | 18.9818 | 18.975 | 18.9818 | 16800.0 |
| 2014-03-07 08:56:00 | AAPL | Stock | 18.975 | 18.975 | 18.9743 | 18.9743 | 8204.0 |
| 2014-03-07 08:57:00 | AAPL | Stock | 18.975 | 18.975 | 18.975 | 18.975 | 5600.0 |
| 2014-03-07 08:58:00 | AAPL | Stock | 18.9729 | 18.9736 | 18.9729 | 18.9736 | 11200.0 |
| 2014-03-07 09:01:00 | AAPL | Stock | 18.9664 | 18.9664 | 18.9646 | 18.9646 | 14000.0 |
> showing 50 of 1,079,334 rows — these rows as CSV