PREVIEW / stock_1min / 2012-08-06
file: by_date/stock_1min/2012/2012-08-06.parquet size: 12.3 MB rows: 920,043 symbols: 2,793
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-06 06:27:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0661 | 22.0661 | 14000.0 |
| 2012-08-06 06:29:00 | AAPL | Stock | 22.0571 | 22.0571 | 22.0554 | 22.0554 | 30800.0 |
| 2012-08-06 06:35:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0661 | 22.0661 | 2800.0 |
| 2012-08-06 06:37:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0661 | 22.0661 | 8400.0 |
| 2012-08-06 06:59:00 | AAPL | Stock | 22.0625 | 22.0625 | 22.0589 | 22.0589 | 14000.0 |
| 2012-08-06 07:00:00 | AAPL | Stock | 22.0589 | 22.0589 | 22.0589 | 22.0589 | 2800.0 |
| 2012-08-06 07:01:00 | AAPL | Stock | 22.0589 | 22.0589 | 22.0589 | 22.0589 | 5600.0 |
| 2012-08-06 07:02:00 | AAPL | Stock | 22.0554 | 22.0571 | 22.0554 | 22.0554 | 11200.0 |
| 2012-08-06 07:03:00 | AAPL | Stock | 22.0554 | 22.0582 | 22.0554 | 22.0582 | 27440.0 |
| 2012-08-06 07:04:00 | AAPL | Stock | 22.0586 | 22.0664 | 22.0586 | 22.0664 | 20720.0 |
| 2012-08-06 07:05:00 | AAPL | Stock | 22.0707 | 22.0707 | 22.0707 | 22.0707 | 5600.0 |
| 2012-08-06 07:06:00 | AAPL | Stock | 22.0707 | 22.0714 | 22.0707 | 22.0714 | 14000.0 |
| 2012-08-06 07:08:00 | AAPL | Stock | 22.0679 | 22.0714 | 22.0593 | 22.0714 | 41272.0 |
| 2012-08-06 07:09:00 | AAPL | Stock | 22.0643 | 22.0643 | 22.0643 | 22.0643 | 8400.0 |
| 2012-08-06 07:10:00 | AAPL | Stock | 22.0643 | 22.0786 | 22.0643 | 22.0786 | 14980.0 |
| 2012-08-06 07:11:00 | AAPL | Stock | 22.0718 | 22.0718 | 22.0714 | 22.0714 | 13748.0 |
| 2012-08-06 07:12:00 | AAPL | Stock | 22.0804 | 22.0829 | 22.0804 | 22.0829 | 30520.0 |
| 2012-08-06 07:13:00 | AAPL | Stock | 22.0832 | 22.09 | 22.0832 | 22.09 | 22400.0 |
| 2012-08-06 07:14:00 | AAPL | Stock | 22.09 | 22.0982 | 22.09 | 22.09 | 36400.0 |
| 2012-08-06 07:16:00 | AAPL | Stock | 22.0882 | 22.0893 | 22.0882 | 22.0893 | 8400.0 |
| 2012-08-06 07:17:00 | AAPL | Stock | 22.095 | 22.1014 | 22.095 | 22.1014 | 14112.0 |
| 2012-08-06 07:19:00 | AAPL | Stock | 22.0961 | 22.0961 | 22.0961 | 22.0961 | 4200.0 |
| 2012-08-06 07:20:00 | AAPL | Stock | 22.0943 | 22.0954 | 22.0754 | 22.0754 | 28000.0 |
| 2012-08-06 07:22:00 | AAPL | Stock | 22.0754 | 22.0754 | 22.0754 | 22.0754 | 2800.0 |
| 2012-08-06 07:23:00 | AAPL | Stock | 22.0714 | 22.0839 | 22.0714 | 22.0839 | 14000.0 |
| 2012-08-06 07:24:00 | AAPL | Stock | 22.0804 | 22.0804 | 22.0804 | 22.0804 | 2800.0 |
| 2012-08-06 07:26:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0661 | 22.0661 | 11424.0 |
| 2012-08-06 07:32:00 | AAPL | Stock | 22.075 | 22.075 | 22.075 | 22.075 | 2800.0 |
| 2012-08-06 07:33:00 | AAPL | Stock | 22.0686 | 22.0686 | 22.0664 | 22.0664 | 6300.0 |
| 2012-08-06 07:34:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 2800.0 |
| 2012-08-06 07:35:00 | AAPL | Stock | 22.0779 | 22.0786 | 22.0779 | 22.0786 | 32340.0 |
| 2012-08-06 07:36:00 | AAPL | Stock | 22.0754 | 22.0754 | 22.0754 | 22.0754 | 2800.0 |
| 2012-08-06 07:37:00 | AAPL | Stock | 22.0786 | 22.0829 | 22.0786 | 22.0829 | 19600.0 |
| 2012-08-06 07:38:00 | AAPL | Stock | 22.0832 | 22.0846 | 22.0832 | 22.0846 | 16800.0 |
| 2012-08-06 07:40:00 | AAPL | Stock | 22.0857 | 22.0921 | 22.0857 | 22.0921 | 28000.0 |
| 2012-08-06 07:41:00 | AAPL | Stock | 22.0893 | 22.0893 | 22.0893 | 22.0893 | 28000.0 |
| 2012-08-06 07:42:00 | AAPL | Stock | 22.0921 | 22.0921 | 22.0921 | 22.0921 | 5600.0 |
| 2012-08-06 07:43:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0921 | 22.0921 | 5600.0 |
| 2012-08-06 07:44:00 | AAPL | Stock | 22.0868 | 22.0868 | 22.0868 | 22.0868 | 2800.0 |
| 2012-08-06 07:45:00 | AAPL | Stock | 22.0875 | 22.0875 | 22.0875 | 22.0875 | 4004.0 |
| 2012-08-06 07:46:00 | AAPL | Stock | 22.0864 | 22.0893 | 22.0864 | 22.0893 | 8400.0 |
| 2012-08-06 07:47:00 | AAPL | Stock | 22.0864 | 22.0864 | 22.0864 | 22.0864 | 2800.0 |
| 2012-08-06 07:48:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 3920.0 |
| 2012-08-06 07:49:00 | AAPL | Stock | 22.0868 | 22.0946 | 22.0868 | 22.0946 | 8400.0 |
| 2012-08-06 07:50:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0964 | 22.0964 | 5600.0 |
| 2012-08-06 07:51:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0964 | 22.0964 | 11200.0 |
| 2012-08-06 07:52:00 | AAPL | Stock | 22.0946 | 22.0946 | 22.0946 | 22.0946 | 5992.0 |
| 2012-08-06 07:57:00 | AAPL | Stock | 22.0946 | 22.0946 | 22.0946 | 22.0946 | 11200.0 |
| 2012-08-06 07:58:00 | AAPL | Stock | 22.0925 | 22.0925 | 22.0914 | 22.0914 | 8400.0 |
| 2012-08-06 07:59:00 | AAPL | Stock | 22.0946 | 22.0946 | 22.0946 | 22.0946 | 2800.0 |
> showing 50 of 920,043 rows — these rows as CSV