PREVIEW / stock_1min / 2013-12-31
file: by_date/stock_1min/2013/2013-12-31.parquet size: 14.1 MB rows: 1,028,436 symbols: 2,881
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-31 07:12:00 | AAPL | Stock | 19.805 | 19.805 | 19.805 | 19.805 | 2800.0 |
| 2013-12-31 07:22:00 | AAPL | Stock | 19.81 | 19.81 | 19.81 | 19.81 | 8400.0 |
| 2013-12-31 07:26:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 2800.0 |
| 2013-12-31 07:46:00 | AAPL | Stock | 19.7868 | 19.7868 | 19.7857 | 19.7857 | 11480.0 |
| 2013-12-31 07:49:00 | AAPL | Stock | 19.7689 | 19.7689 | 19.7679 | 19.7679 | 5600.0 |
| 2013-12-31 07:54:00 | AAPL | Stock | 19.7557 | 19.7557 | 19.75 | 19.75 | 18200.0 |
| 2013-12-31 07:58:00 | AAPL | Stock | 19.75 | 19.75 | 19.7486 | 19.7486 | 14000.0 |
| 2013-12-31 07:59:00 | AAPL | Stock | 19.7482 | 19.7507 | 19.7482 | 19.75 | 100800.0 |
| 2013-12-31 08:00:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 11760.0 |
| 2013-12-31 08:02:00 | AAPL | Stock | 19.7514 | 19.7514 | 19.7514 | 19.7514 | 2800.0 |
| 2013-12-31 08:05:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7554 | 19.7554 | 15428.0 |
| 2013-12-31 08:07:00 | AAPL | Stock | 19.7557 | 19.7557 | 19.7554 | 19.7554 | 16772.0 |
| 2013-12-31 08:08:00 | AAPL | Stock | 19.7629 | 19.7629 | 19.7629 | 19.7629 | 40656.0 |
| 2013-12-31 08:09:00 | AAPL | Stock | 19.7525 | 19.7525 | 19.7525 | 19.7525 | 2800.0 |
| 2013-12-31 08:11:00 | AAPL | Stock | 19.7482 | 19.7482 | 19.7482 | 19.7482 | 3360.0 |
| 2013-12-31 08:12:00 | AAPL | Stock | 19.7504 | 19.7504 | 19.7504 | 19.7504 | 2800.0 |
| 2013-12-31 08:13:00 | AAPL | Stock | 19.7604 | 19.7714 | 19.7554 | 19.7714 | 18676.0 |
| 2013-12-31 08:23:00 | AAPL | Stock | 19.7696 | 19.7714 | 19.7696 | 19.7696 | 15400.0 |
| 2013-12-31 08:26:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 2800.0 |
| 2013-12-31 08:27:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7696 | 19.7696 | 20160.0 |
| 2013-12-31 08:28:00 | AAPL | Stock | 19.7854 | 19.7854 | 19.7854 | 19.7854 | 5600.0 |
| 2013-12-31 08:35:00 | AAPL | Stock | 19.7854 | 19.7854 | 19.7854 | 19.7854 | 2800.0 |
| 2013-12-31 08:36:00 | AAPL | Stock | 19.7854 | 19.8196 | 19.7854 | 19.8196 | 16492.0 |
| 2013-12-31 08:37:00 | AAPL | Stock | 19.8125 | 19.8125 | 19.8125 | 19.8125 | 2800.0 |
| 2013-12-31 08:38:00 | AAPL | Stock | 19.8096 | 19.8096 | 19.8096 | 19.8096 | 8400.0 |
| 2013-12-31 08:41:00 | AAPL | Stock | 19.805 | 19.8082 | 19.805 | 19.8082 | 11200.0 |
| 2013-12-31 08:48:00 | AAPL | Stock | 19.7982 | 19.7982 | 19.7975 | 19.7975 | 8400.0 |
| 2013-12-31 08:49:00 | AAPL | Stock | 19.7975 | 19.7979 | 19.7829 | 19.7864 | 32200.0 |
| 2013-12-31 08:51:00 | AAPL | Stock | 19.8018 | 19.8018 | 19.7861 | 19.7861 | 13916.0 |
| 2013-12-31 08:53:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 2800.0 |
| 2013-12-31 08:56:00 | AAPL | Stock | 19.7789 | 19.7839 | 19.7789 | 19.7839 | 5600.0 |
| 2013-12-31 09:05:00 | AAPL | Stock | 19.7957 | 19.7975 | 19.7957 | 19.7971 | 16800.0 |
| 2013-12-31 09:06:00 | AAPL | Stock | 19.7982 | 19.7982 | 19.7964 | 19.7964 | 19600.0 |
| 2013-12-31 09:08:00 | AAPL | Stock | 19.7996 | 19.8043 | 19.7996 | 19.8043 | 11200.0 |
| 2013-12-31 09:09:00 | AAPL | Stock | 19.8071 | 19.8114 | 19.8071 | 19.8114 | 16800.0 |
| 2013-12-31 09:10:00 | AAPL | Stock | 19.8054 | 19.8054 | 19.8054 | 19.8054 | 2800.0 |
| 2013-12-31 09:12:00 | AAPL | Stock | 19.8043 | 19.8043 | 19.8039 | 19.8039 | 19600.0 |
| 2013-12-31 09:13:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.7946 | 19.8036 | 28000.0 |
| 2013-12-31 09:14:00 | AAPL | Stock | 19.81 | 19.81 | 19.8054 | 19.8054 | 15400.0 |
| 2013-12-31 09:16:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 2800.0 |
| 2013-12-31 09:17:00 | AAPL | Stock | 19.8068 | 19.8068 | 19.8043 | 19.8043 | 11676.0 |
| 2013-12-31 09:19:00 | AAPL | Stock | 19.8054 | 19.8079 | 19.8043 | 19.8043 | 8400.0 |
| 2013-12-31 09:20:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 51772.0 |
| 2013-12-31 09:22:00 | AAPL | Stock | 19.8078 | 19.8078 | 19.8068 | 19.8078 | 17416.0 |
| 2013-12-31 09:23:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8018 | 19.8036 | 31276.0 |
| 2013-12-31 09:24:00 | AAPL | Stock | 19.8075 | 19.8075 | 19.8064 | 19.8064 | 8400.0 |
| 2013-12-31 09:28:00 | AAPL | Stock | 19.7936 | 19.7936 | 19.7871 | 19.7871 | 5600.0 |
| 2013-12-31 09:29:00 | AAPL | Stock | 19.8036 | 19.8071 | 19.7857 | 19.7957 | 98392.0 |
| 2013-12-31 09:30:00 | AAPL | Stock | 19.7904 | 19.8043 | 19.7857 | 19.797 | 2113496.0 |
| 2013-12-31 09:31:00 | AAPL | Stock | 19.7979 | 19.8546 | 19.7907 | 19.8442 | 1646372.0 |
> showing 50 of 1,028,436 rows — these rows as CSV