PREVIEW / stock_1min / 2013-12-09
file: by_date/stock_1min/2013/2013-12-09.parquet size: 14.0 MB rows: 1,029,671 symbols: 2,872
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-09 04:07:00 | AAPL | Stock | 20.0864 | 20.0864 | 20.0864 | 20.0864 | 25200.0 |
| 2013-12-09 04:19:00 | AAPL | Stock | 20.0768 | 20.0768 | 20.0768 | 20.0768 | 14000.0 |
| 2013-12-09 04:27:00 | AAPL | Stock | 20.0725 | 20.0725 | 20.0725 | 20.0725 | 2800.0 |
| 2013-12-09 04:29:00 | AAPL | Stock | 20.0725 | 20.0725 | 20.0725 | 20.0725 | 2800.0 |
| 2013-12-09 04:46:00 | AAPL | Stock | 20.075 | 20.075 | 20.075 | 20.075 | 2800.0 |
| 2013-12-09 04:47:00 | AAPL | Stock | 20.075 | 20.075 | 20.075 | 20.075 | 2800.0 |
| 2013-12-09 05:31:00 | AAPL | Stock | 20.0621 | 20.0621 | 20.0621 | 20.0621 | 16800.0 |
| 2013-12-09 05:34:00 | AAPL | Stock | 20.0539 | 20.0539 | 20.0539 | 20.0539 | 2800.0 |
| 2013-12-09 05:45:00 | AAPL | Stock | 20.0429 | 20.0429 | 20.0429 | 20.0429 | 10220.0 |
| 2013-12-09 06:11:00 | AAPL | Stock | 20.0679 | 20.0714 | 20.0679 | 20.0714 | 14000.0 |
| 2013-12-09 06:35:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 14000.0 |
| 2013-12-09 06:37:00 | AAPL | Stock | 20.075 | 20.0771 | 20.075 | 20.0771 | 5600.0 |
| 2013-12-09 06:40:00 | AAPL | Stock | 20.0754 | 20.0754 | 20.0754 | 20.0754 | 9828.0 |
| 2013-12-09 06:58:00 | AAPL | Stock | 20.0757 | 20.0757 | 20.0757 | 20.0757 | 2800.0 |
| 2013-12-09 07:00:00 | AAPL | Stock | 20.08 | 20.08 | 20.08 | 20.08 | 2800.0 |
| 2013-12-09 07:03:00 | AAPL | Stock | 20.0714 | 20.0732 | 20.0714 | 20.0732 | 22932.0 |
| 2013-12-09 07:04:00 | AAPL | Stock | 20.0804 | 20.0804 | 20.0732 | 20.0732 | 7000.0 |
| 2013-12-09 07:06:00 | AAPL | Stock | 20.0657 | 20.0657 | 20.0657 | 20.0657 | 14000.0 |
| 2013-12-09 07:09:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 5600.0 |
| 2013-12-09 07:13:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2013-12-09 07:17:00 | AAPL | Stock | 20.0732 | 20.0732 | 20.0732 | 20.0732 | 33572.0 |
| 2013-12-09 07:23:00 | AAPL | Stock | 20.0818 | 20.0818 | 20.0818 | 20.0818 | 5600.0 |
| 2013-12-09 07:24:00 | AAPL | Stock | 20.0861 | 20.0889 | 20.0786 | 20.0786 | 28000.0 |
| 2013-12-09 07:26:00 | AAPL | Stock | 20.0886 | 20.1071 | 20.0886 | 20.1029 | 25760.0 |
| 2013-12-09 07:28:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0832 | 20.0832 | 8400.0 |
| 2013-12-09 07:32:00 | AAPL | Stock | 20.1061 | 20.1061 | 20.1061 | 20.1061 | 2800.0 |
| 2013-12-09 07:33:00 | AAPL | Stock | 20.1143 | 20.1143 | 20.1143 | 20.1143 | 2800.0 |
| 2013-12-09 07:34:00 | AAPL | Stock | 20.0914 | 20.0914 | 20.0914 | 20.0914 | 2800.0 |
| 2013-12-09 07:35:00 | AAPL | Stock | 20.0929 | 20.0929 | 20.0929 | 20.0929 | 2800.0 |
| 2013-12-09 07:36:00 | AAPL | Stock | 20.1064 | 20.1086 | 20.1064 | 20.1086 | 5600.0 |
| 2013-12-09 07:40:00 | AAPL | Stock | 20.0918 | 20.0918 | 20.0918 | 20.0918 | 2800.0 |
| 2013-12-09 07:42:00 | AAPL | Stock | 20.1046 | 20.1161 | 20.1046 | 20.1161 | 19600.0 |
| 2013-12-09 07:44:00 | AAPL | Stock | 20.1114 | 20.1114 | 20.1075 | 20.1075 | 14000.0 |
| 2013-12-09 07:50:00 | AAPL | Stock | 20.1057 | 20.1064 | 20.1057 | 20.1064 | 5600.0 |
| 2013-12-09 07:53:00 | AAPL | Stock | 20.1061 | 20.1071 | 20.1061 | 20.1071 | 28000.0 |
| 2013-12-09 08:00:00 | AAPL | Stock | 20.0982 | 20.1107 | 20.0721 | 20.0721 | 352100.0 |
| 2013-12-09 08:01:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0893 | 20.0893 | 8400.0 |
| 2013-12-09 08:02:00 | AAPL | Stock | 20.0754 | 20.0768 | 20.0679 | 20.0714 | 164696.0 |
| 2013-12-09 08:03:00 | AAPL | Stock | 20.0714 | 20.0832 | 20.0714 | 20.0818 | 38780.0 |
| 2013-12-09 08:04:00 | AAPL | Stock | 20.0811 | 20.0811 | 20.0661 | 20.0779 | 23800.0 |
| 2013-12-09 08:05:00 | AAPL | Stock | 20.0711 | 20.0711 | 20.0643 | 20.0643 | 19488.0 |
| 2013-12-09 08:07:00 | AAPL | Stock | 20.0707 | 20.0707 | 20.0689 | 20.0696 | 33320.0 |
| 2013-12-09 08:08:00 | AAPL | Stock | 20.0696 | 20.0696 | 20.0696 | 20.0696 | 2800.0 |
| 2013-12-09 08:10:00 | AAPL | Stock | 20.0696 | 20.0732 | 20.0696 | 20.0714 | 24584.0 |
| 2013-12-09 08:11:00 | AAPL | Stock | 20.075 | 20.075 | 20.0714 | 20.0714 | 14952.0 |
| 2013-12-09 08:12:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 3192.0 |
| 2013-12-09 08:13:00 | AAPL | Stock | 20.0643 | 20.0643 | 20.0607 | 20.0607 | 14000.0 |
| 2013-12-09 08:14:00 | AAPL | Stock | 20.0596 | 20.0636 | 20.0596 | 20.0636 | 8400.0 |
| 2013-12-09 08:15:00 | AAPL | Stock | 20.0643 | 20.0654 | 20.0568 | 20.0568 | 39200.0 |
| 2013-12-09 08:16:00 | AAPL | Stock | 20.0632 | 20.0654 | 20.0632 | 20.0654 | 5600.0 |
> showing 50 of 1,029,671 rows — these rows as CSV