PREVIEW / stock_1min / 2010-05-07
file: by_date/stock_1min/2010/2010-05-07.parquet size: 16.1 MB rows: 1,172,975 symbols: 2,824
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-07 04:05:00 | AAPL | Stock | 8.6714 | 8.6714 | 8.6714 | 8.6714 | 14000.0 |
| 2010-05-07 04:14:00 | AAPL | Stock | 8.6989 | 8.6989 | 8.6975 | 8.6975 | 28000.0 |
| 2010-05-07 04:15:00 | AAPL | Stock | 8.6961 | 8.6961 | 8.6954 | 8.6954 | 27440.0 |
| 2010-05-07 04:17:00 | AAPL | Stock | 8.6882 | 8.6882 | 8.6882 | 8.6882 | 8960.0 |
| 2010-05-07 04:18:00 | AAPL | Stock | 8.685 | 8.685 | 8.685 | 8.685 | 14000.0 |
| 2010-05-07 04:21:00 | AAPL | Stock | 8.7036 | 8.7036 | 8.7036 | 8.7036 | 11200.0 |
| 2010-05-07 04:30:00 | AAPL | Stock | 8.7043 | 8.7043 | 8.7043 | 8.7043 | 14000.0 |
| 2010-05-07 04:34:00 | AAPL | Stock | 8.7171 | 8.7171 | 8.7171 | 8.7171 | 14000.0 |
| 2010-05-07 04:37:00 | AAPL | Stock | 8.7136 | 8.7136 | 8.7136 | 8.7136 | 11200.0 |
| 2010-05-07 04:38:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7143 | 8.7143 | 5600.0 |
| 2010-05-07 04:40:00 | AAPL | Stock | 8.7136 | 8.7136 | 8.6864 | 8.6864 | 7000.0 |
| 2010-05-07 04:41:00 | AAPL | Stock | 8.7104 | 8.7104 | 8.7104 | 8.7104 | 2800.0 |
| 2010-05-07 04:49:00 | AAPL | Stock | 8.7089 | 8.7089 | 8.7089 | 8.7089 | 5600.0 |
| 2010-05-07 04:51:00 | AAPL | Stock | 8.6889 | 8.6893 | 8.6889 | 8.6893 | 8400.0 |
| 2010-05-07 04:59:00 | AAPL | Stock | 8.6786 | 8.6786 | 8.6564 | 8.6564 | 5600.0 |
| 2010-05-07 05:00:00 | AAPL | Stock | 8.6504 | 8.6504 | 8.6504 | 8.6504 | 7000.0 |
| 2010-05-07 05:02:00 | AAPL | Stock | 8.6886 | 8.6886 | 8.6886 | 8.6886 | 2800.0 |
| 2010-05-07 05:09:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 2800.0 |
| 2010-05-07 05:19:00 | AAPL | Stock | 8.6886 | 8.6957 | 8.6886 | 8.6957 | 26600.0 |
| 2010-05-07 05:20:00 | AAPL | Stock | 8.6936 | 8.6936 | 8.6936 | 8.6936 | 14000.0 |
| 2010-05-07 05:39:00 | AAPL | Stock | 8.6893 | 8.6893 | 8.6893 | 8.6893 | 3500.0 |
| 2010-05-07 05:44:00 | AAPL | Stock | 8.6904 | 8.6904 | 8.6904 | 8.6904 | 2800.0 |
| 2010-05-07 06:01:00 | AAPL | Stock | 8.6921 | 8.6971 | 8.6921 | 8.6971 | 16800.0 |
| 2010-05-07 06:08:00 | AAPL | Stock | 8.7032 | 8.7032 | 8.7032 | 8.7032 | 12208.0 |
| 2010-05-07 06:09:00 | AAPL | Stock | 8.7071 | 8.7143 | 8.6796 | 8.6796 | 50400.0 |
| 2010-05-07 06:11:00 | AAPL | Stock | 8.7139 | 8.7139 | 8.7139 | 8.7139 | 14000.0 |
| 2010-05-07 06:14:00 | AAPL | Stock | 8.7096 | 8.7107 | 8.7096 | 8.7107 | 5600.0 |
| 2010-05-07 06:15:00 | AAPL | Stock | 8.7104 | 8.7207 | 8.7104 | 8.7207 | 11200.0 |
| 2010-05-07 06:22:00 | AAPL | Stock | 8.7236 | 8.7236 | 8.7236 | 8.7236 | 11200.0 |
| 2010-05-07 06:34:00 | AAPL | Stock | 8.7214 | 8.7214 | 8.7214 | 8.7214 | 8400.0 |
| 2010-05-07 06:35:00 | AAPL | Stock | 8.7214 | 8.7214 | 8.7214 | 8.7214 | 8400.0 |
| 2010-05-07 06:36:00 | AAPL | Stock | 8.7214 | 8.775 | 8.7214 | 8.7746 | 123144.0 |
| 2010-05-07 06:37:00 | AAPL | Stock | 8.7818 | 8.7964 | 8.7818 | 8.7964 | 119644.0 |
| 2010-05-07 06:39:00 | AAPL | Stock | 8.7854 | 8.7854 | 8.7854 | 8.7854 | 14000.0 |
| 2010-05-07 06:40:00 | AAPL | Stock | 8.7836 | 8.7836 | 8.7836 | 8.7836 | 28000.0 |
| 2010-05-07 06:41:00 | AAPL | Stock | 8.7754 | 8.7754 | 8.7754 | 8.7754 | 28000.0 |
| 2010-05-07 06:42:00 | AAPL | Stock | 8.7818 | 8.7825 | 8.7818 | 8.7825 | 28000.0 |
| 2010-05-07 06:44:00 | AAPL | Stock | 8.7821 | 8.7821 | 8.7821 | 8.7821 | 5600.0 |
| 2010-05-07 06:45:00 | AAPL | Stock | 8.7929 | 8.7954 | 8.7857 | 8.7857 | 19600.0 |
| 2010-05-07 06:46:00 | AAPL | Stock | 8.7882 | 8.7882 | 8.7882 | 8.7882 | 19600.0 |
| 2010-05-07 06:49:00 | AAPL | Stock | 8.7882 | 8.7882 | 8.7882 | 8.7882 | 42000.0 |
| 2010-05-07 06:53:00 | AAPL | Stock | 8.7896 | 8.7896 | 8.7893 | 8.7893 | 14000.0 |
| 2010-05-07 06:54:00 | AAPL | Stock | 8.7836 | 8.7836 | 8.7836 | 8.7836 | 8400.0 |
| 2010-05-07 06:55:00 | AAPL | Stock | 8.7954 | 8.7968 | 8.7954 | 8.7968 | 25676.0 |
| 2010-05-07 06:56:00 | AAPL | Stock | 8.7911 | 8.7911 | 8.7857 | 8.7857 | 30800.0 |
| 2010-05-07 06:57:00 | AAPL | Stock | 8.7768 | 8.7768 | 8.7768 | 8.7768 | 28000.0 |
| 2010-05-07 06:59:00 | AAPL | Stock | 8.7768 | 8.7768 | 8.7768 | 8.7768 | 5488.0 |
| 2010-05-07 07:00:00 | AAPL | Stock | 8.7893 | 8.8029 | 8.7857 | 8.7929 | 83720.0 |
| 2010-05-07 07:01:00 | AAPL | Stock | 8.7964 | 8.7964 | 8.7964 | 8.7964 | 8400.0 |
| 2010-05-07 07:02:00 | AAPL | Stock | 8.7982 | 8.7982 | 8.7893 | 8.7893 | 30100.0 |
> showing 50 of 1,172,975 rows — these rows as CSV