PREVIEW / stock_1min / 2014-03-11
file: by_date/stock_1min/2014/2014-03-11.parquet size: 15.3 MB rows: 1,091,232 symbols: 2,873
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-11 04:00:00 | AAPL | Stock | 18.9143 | 18.9143 | 18.9143 | 18.9143 | 25200.0 |
| 2014-03-11 04:12:00 | AAPL | Stock | 19.005 | 19.0064 | 19.005 | 19.0064 | 61600.0 |
| 2014-03-11 04:13:00 | AAPL | Stock | 19.0329 | 19.0329 | 19.0329 | 19.0329 | 13776.0 |
| 2014-03-11 04:19:00 | AAPL | Stock | 19.0514 | 19.0539 | 19.0514 | 19.0539 | 5600.0 |
| 2014-03-11 04:21:00 | AAPL | Stock | 19.0946 | 19.0946 | 19.0946 | 19.0946 | 2800.0 |
| 2014-03-11 04:25:00 | AAPL | Stock | 19.0539 | 19.0539 | 19.0518 | 19.0518 | 11200.0 |
| 2014-03-11 04:28:00 | AAPL | Stock | 19.0696 | 19.0696 | 19.0696 | 19.0696 | 5600.0 |
| 2014-03-11 04:39:00 | AAPL | Stock | 19.0804 | 19.0964 | 19.0804 | 19.0964 | 33600.0 |
| 2014-03-11 04:45:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 16800.0 |
| 2014-03-11 04:47:00 | AAPL | Stock | 19.1232 | 19.1286 | 19.1232 | 19.1286 | 14000.0 |
| 2014-03-11 04:48:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2014-03-11 04:53:00 | AAPL | Stock | 19.1071 | 19.1075 | 19.1071 | 19.1075 | 8400.0 |
| 2014-03-11 04:54:00 | AAPL | Stock | 19.1075 | 19.1075 | 19.1075 | 19.1075 | 2800.0 |
| 2014-03-11 05:00:00 | AAPL | Stock | 19.1057 | 19.1057 | 19.1057 | 19.1057 | 2800.0 |
| 2014-03-11 05:05:00 | AAPL | Stock | 19.0896 | 19.0929 | 19.0896 | 19.0929 | 8400.0 |
| 2014-03-11 05:06:00 | AAPL | Stock | 19.0929 | 19.0929 | 19.0929 | 19.0929 | 5600.0 |
| 2014-03-11 05:15:00 | AAPL | Stock | 19.0879 | 19.0879 | 19.0879 | 19.0879 | 2800.0 |
| 2014-03-11 05:20:00 | AAPL | Stock | 19.0886 | 19.0889 | 19.0886 | 19.0889 | 5600.0 |
| 2014-03-11 05:24:00 | AAPL | Stock | 19.0879 | 19.0893 | 19.0879 | 19.0893 | 18760.0 |
| 2014-03-11 05:36:00 | AAPL | Stock | 19.1004 | 19.1004 | 19.1004 | 19.1004 | 2800.0 |
| 2014-03-11 05:39:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2014-03-11 06:11:00 | AAPL | Stock | 19.0589 | 19.0589 | 19.0589 | 19.0589 | 2800.0 |
| 2014-03-11 06:14:00 | AAPL | Stock | 19.0946 | 19.0946 | 19.0946 | 19.0946 | 2800.0 |
| 2014-03-11 06:17:00 | AAPL | Stock | 19.0589 | 19.0589 | 19.0589 | 19.0589 | 5600.0 |
| 2014-03-11 06:23:00 | AAPL | Stock | 19.0711 | 19.0711 | 19.0711 | 19.0711 | 2800.0 |
| 2014-03-11 06:32:00 | AAPL | Stock | 19.0736 | 19.0736 | 19.0736 | 19.0736 | 2800.0 |
| 2014-03-11 06:33:00 | AAPL | Stock | 19.0939 | 19.0939 | 19.0939 | 19.0939 | 7000.0 |
| 2014-03-11 06:37:00 | AAPL | Stock | 19.075 | 19.075 | 19.075 | 19.075 | 2800.0 |
| 2014-03-11 06:38:00 | AAPL | Stock | 19.075 | 19.075 | 19.075 | 19.075 | 2800.0 |
| 2014-03-11 06:47:00 | AAPL | Stock | 19.0714 | 19.075 | 19.0714 | 19.075 | 5600.0 |
| 2014-03-11 07:00:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.0964 | 19.0964 | 2800.0 |
| 2014-03-11 07:09:00 | AAPL | Stock | 19.0961 | 19.0961 | 19.0961 | 19.0961 | 2800.0 |
| 2014-03-11 07:10:00 | AAPL | Stock | 19.0893 | 19.0929 | 19.0893 | 19.0929 | 36400.0 |
| 2014-03-11 07:11:00 | AAPL | Stock | 19.0771 | 19.0771 | 19.075 | 19.075 | 30800.0 |
| 2014-03-11 07:12:00 | AAPL | Stock | 19.0871 | 19.0871 | 19.0871 | 19.0871 | 2800.0 |
| 2014-03-11 07:13:00 | AAPL | Stock | 19.0721 | 19.0721 | 19.0721 | 19.0721 | 5600.0 |
| 2014-03-11 07:14:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2014-03-11 07:17:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 5600.0 |
| 2014-03-11 07:18:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 12656.0 |
| 2014-03-11 07:23:00 | AAPL | Stock | 19.0639 | 19.0639 | 19.0536 | 19.0536 | 8400.0 |
| 2014-03-11 07:27:00 | AAPL | Stock | 19.0639 | 19.0657 | 19.0639 | 19.0657 | 5600.0 |
| 2014-03-11 07:31:00 | AAPL | Stock | 19.0657 | 19.0768 | 19.0657 | 19.0768 | 21000.0 |
| 2014-03-11 07:37:00 | AAPL | Stock | 19.0768 | 19.0768 | 19.0714 | 19.0714 | 15120.0 |
| 2014-03-11 07:38:00 | AAPL | Stock | 19.0839 | 19.0879 | 19.0839 | 19.0857 | 36400.0 |
| 2014-03-11 07:39:00 | AAPL | Stock | 19.0857 | 19.0857 | 19.0857 | 19.0857 | 5600.0 |
| 2014-03-11 07:40:00 | AAPL | Stock | 19.0821 | 19.0914 | 19.0821 | 19.0893 | 41412.0 |
| 2014-03-11 07:44:00 | AAPL | Stock | 19.0729 | 19.0729 | 19.0729 | 19.0729 | 4452.0 |
| 2014-03-11 07:46:00 | AAPL | Stock | 19.0611 | 19.0611 | 19.0571 | 19.0571 | 11200.0 |
| 2014-03-11 07:48:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 5012.0 |
| 2014-03-11 07:49:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 25172.0 |
> showing 50 of 1,091,232 rows — these rows as CSV