PREVIEW / stock_1min / 2014-06-05
file: by_date/stock_1min/2014/2014-06-05.parquet size: 14.6 MB rows: 1,067,038 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-06-05 05:10:00 | AAPL | Stock | 23.0536 | 23.0536 | 23.0536 | 23.0536 | 2800.0 |
| 2014-06-05 06:34:00 | AAPL | Stock | 23.0571 | 23.0571 | 23.0571 | 23.0571 | 2800.0 |
| 2014-06-05 07:09:00 | AAPL | Stock | 23.0714 | 23.0714 | 23.0714 | 23.0714 | 11200.0 |
| 2014-06-05 07:10:00 | AAPL | Stock | 23.0714 | 23.0736 | 23.0714 | 23.0736 | 5600.0 |
| 2014-06-05 07:11:00 | AAPL | Stock | 23.0825 | 23.0893 | 23.0825 | 23.0893 | 8400.0 |
| 2014-06-05 07:12:00 | AAPL | Stock | 23.0893 | 23.0893 | 23.0893 | 23.0893 | 2800.0 |
| 2014-06-05 07:16:00 | AAPL | Stock | 23.0875 | 23.0875 | 23.0843 | 23.0843 | 19488.0 |
| 2014-06-05 07:17:00 | AAPL | Stock | 23.0821 | 23.0939 | 23.0821 | 23.0939 | 8400.0 |
| 2014-06-05 07:18:00 | AAPL | Stock | 23.0939 | 23.0939 | 23.0939 | 23.0939 | 25200.0 |
| 2014-06-05 07:20:00 | AAPL | Stock | 23.0968 | 23.0968 | 23.0964 | 23.0964 | 14000.0 |
| 2014-06-05 07:21:00 | AAPL | Stock | 23.09 | 23.09 | 23.0821 | 23.0821 | 21672.0 |
| 2014-06-05 07:22:00 | AAPL | Stock | 23.0964 | 23.0964 | 23.0871 | 23.0871 | 5600.0 |
| 2014-06-05 07:26:00 | AAPL | Stock | 23.0943 | 23.0964 | 23.0943 | 23.0964 | 15288.0 |
| 2014-06-05 07:30:00 | AAPL | Stock | 23.0893 | 23.0893 | 23.0893 | 23.0893 | 14000.0 |
| 2014-06-05 07:31:00 | AAPL | Stock | 23.0857 | 23.0857 | 23.0857 | 23.0857 | 27888.0 |
| 2014-06-05 07:32:00 | AAPL | Stock | 23.0821 | 23.0821 | 23.0571 | 23.0571 | 70280.0 |
| 2014-06-05 07:38:00 | AAPL | Stock | 23.0857 | 23.0857 | 23.075 | 23.075 | 28000.0 |
| 2014-06-05 07:39:00 | AAPL | Stock | 23.075 | 23.075 | 23.075 | 23.075 | 9436.0 |
| 2014-06-05 07:40:00 | AAPL | Stock | 23.075 | 23.075 | 23.075 | 23.075 | 5600.0 |
| 2014-06-05 07:41:00 | AAPL | Stock | 23.0804 | 23.0804 | 23.0804 | 23.0804 | 2800.0 |
| 2014-06-05 07:42:00 | AAPL | Stock | 23.0893 | 23.0893 | 23.0893 | 23.0893 | 2800.0 |
| 2014-06-05 07:45:00 | AAPL | Stock | 23.0893 | 23.0893 | 23.0539 | 23.0539 | 55720.0 |
| 2014-06-05 07:46:00 | AAPL | Stock | 23.0714 | 23.0714 | 23.0643 | 23.0643 | 5600.0 |
| 2014-06-05 07:47:00 | AAPL | Stock | 23.0643 | 23.0643 | 23.0643 | 23.0643 | 2800.0 |
| 2014-06-05 07:48:00 | AAPL | Stock | 23.0843 | 23.0893 | 23.0843 | 23.0893 | 30660.0 |
| 2014-06-05 07:49:00 | AAPL | Stock | 23.0889 | 23.1 | 23.0889 | 23.1 | 25564.0 |
| 2014-06-05 07:50:00 | AAPL | Stock | 23.1 | 23.1036 | 23.0904 | 23.0996 | 19068.0 |
| 2014-06-05 07:51:00 | AAPL | Stock | 23.0975 | 23.0982 | 23.0893 | 23.0893 | 16800.0 |
| 2014-06-05 07:52:00 | AAPL | Stock | 23.0979 | 23.0979 | 23.0979 | 23.0979 | 2800.0 |
| 2014-06-05 07:54:00 | AAPL | Stock | 23.0989 | 23.0989 | 23.0989 | 23.0989 | 2800.0 |
| 2014-06-05 07:59:00 | AAPL | Stock | 23.0725 | 23.0725 | 23.0679 | 23.0714 | 29120.0 |
| 2014-06-05 08:00:00 | AAPL | Stock | 23.0714 | 23.1071 | 23.0575 | 23.0757 | 119784.0 |
| 2014-06-05 08:01:00 | AAPL | Stock | 23.0846 | 23.0846 | 23.0846 | 23.0846 | 12600.0 |
| 2014-06-05 08:02:00 | AAPL | Stock | 23.07 | 23.07 | 23.07 | 23.07 | 2800.0 |
| 2014-06-05 08:03:00 | AAPL | Stock | 23.0729 | 23.0729 | 23.0729 | 23.0729 | 2800.0 |
| 2014-06-05 08:05:00 | AAPL | Stock | 23.0714 | 23.0714 | 23.0714 | 23.0714 | 14000.0 |
| 2014-06-05 08:06:00 | AAPL | Stock | 23.0839 | 23.0839 | 23.0839 | 23.0839 | 2800.0 |
| 2014-06-05 08:07:00 | AAPL | Stock | 23.0714 | 23.1018 | 23.0714 | 23.0964 | 150780.0 |
| 2014-06-05 08:08:00 | AAPL | Stock | 23.0929 | 23.0929 | 23.0911 | 23.0911 | 19600.0 |
| 2014-06-05 08:09:00 | AAPL | Stock | 23.0964 | 23.0964 | 23.0893 | 23.0911 | 47600.0 |
| 2014-06-05 08:10:00 | AAPL | Stock | 23.0882 | 23.0882 | 23.0714 | 23.0804 | 95368.0 |
| 2014-06-05 08:11:00 | AAPL | Stock | 23.0768 | 23.0789 | 23.0768 | 23.0789 | 6412.0 |
| 2014-06-05 08:12:00 | AAPL | Stock | 23.0789 | 23.0839 | 23.0739 | 23.0821 | 14000.0 |
| 2014-06-05 08:14:00 | AAPL | Stock | 23.0771 | 23.0857 | 23.0771 | 23.0857 | 8400.0 |
| 2014-06-05 08:15:00 | AAPL | Stock | 23.0821 | 23.0821 | 23.0786 | 23.0786 | 19600.0 |
| 2014-06-05 08:16:00 | AAPL | Stock | 23.0775 | 23.0775 | 23.0761 | 23.0761 | 5600.0 |
| 2014-06-05 08:17:00 | AAPL | Stock | 23.0832 | 23.0893 | 23.0832 | 23.0879 | 32200.0 |
| 2014-06-05 08:19:00 | AAPL | Stock | 23.0871 | 23.0871 | 23.0857 | 23.0857 | 11200.0 |
| 2014-06-05 08:23:00 | AAPL | Stock | 23.0864 | 23.0871 | 23.0864 | 23.0871 | 16212.0 |
| 2014-06-05 08:26:00 | AAPL | Stock | 23.0893 | 23.0911 | 23.0893 | 23.0911 | 6580.0 |
> showing 50 of 1,067,038 rows — these rows as CSV