PREVIEW / stock_1min / 2010-08-24
file: by_date/stock_1min/2010/2010-08-24.parquet size: 12.8 MB rows: 968,749 symbols: 2,821
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-08-24 04:00:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 11200.0 |
| 2010-08-24 07:05:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7232 | 8.7232 | 5600.0 |
| 2010-08-24 07:07:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7232 | 8.7232 | 5600.0 |
| 2010-08-24 07:08:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7232 | 8.7232 | 5600.0 |
| 2010-08-24 07:13:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7054 | 8.7054 | 32648.0 |
| 2010-08-24 07:14:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7143 | 8.7143 | 2800.0 |
| 2010-08-24 07:16:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7143 | 8.7143 | 5600.0 |
| 2010-08-24 07:17:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7143 | 8.7143 | 2800.0 |
| 2010-08-24 07:18:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7071 | 8.7071 | 14000.0 |
| 2010-08-24 07:19:00 | AAPL | Stock | 8.7107 | 8.7107 | 8.7107 | 8.7107 | 2800.0 |
| 2010-08-24 07:21:00 | AAPL | Stock | 8.7107 | 8.7107 | 8.7107 | 8.7107 | 11200.0 |
| 2010-08-24 07:23:00 | AAPL | Stock | 8.7107 | 8.7107 | 8.7107 | 8.7107 | 11984.0 |
| 2010-08-24 07:24:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7107 | 8.7107 | 12740.0 |
| 2010-08-24 07:25:00 | AAPL | Stock | 8.7057 | 8.7057 | 8.7057 | 8.7057 | 2800.0 |
| 2010-08-24 07:28:00 | AAPL | Stock | 8.7071 | 8.7071 | 8.6964 | 8.6964 | 32816.0 |
| 2010-08-24 07:29:00 | AAPL | Stock | 8.6982 | 8.6982 | 8.6975 | 8.6975 | 32900.0 |
| 2010-08-24 07:31:00 | AAPL | Stock | 8.6975 | 8.6975 | 8.6968 | 8.6968 | 8400.0 |
| 2010-08-24 07:32:00 | AAPL | Stock | 8.6961 | 8.6961 | 8.6929 | 8.6961 | 86996.0 |
| 2010-08-24 07:33:00 | AAPL | Stock | 8.7 | 8.7089 | 8.7 | 8.7089 | 23660.0 |
| 2010-08-24 07:48:00 | AAPL | Stock | 8.6929 | 8.6964 | 8.6929 | 8.6929 | 23296.0 |
| 2010-08-24 07:50:00 | AAPL | Stock | 8.6946 | 8.6946 | 8.6946 | 8.6946 | 2800.0 |
| 2010-08-24 07:56:00 | AAPL | Stock | 8.6964 | 8.6964 | 8.6946 | 8.6946 | 11900.0 |
| 2010-08-24 07:57:00 | AAPL | Stock | 8.6964 | 8.6964 | 8.6964 | 8.6964 | 23240.0 |
| 2010-08-24 07:58:00 | AAPL | Stock | 8.6957 | 8.6957 | 8.6957 | 8.6957 | 8400.0 |
| 2010-08-24 08:00:00 | AAPL | Stock | 8.7036 | 8.7446 | 8.6946 | 8.7004 | 357084.0 |
| 2010-08-24 08:01:00 | AAPL | Stock | 8.7036 | 8.7071 | 8.7021 | 8.7054 | 50232.0 |
| 2010-08-24 08:02:00 | AAPL | Stock | 8.7046 | 8.7071 | 8.7018 | 8.7018 | 44240.0 |
| 2010-08-24 08:03:00 | AAPL | Stock | 8.7018 | 8.7018 | 8.7 | 8.7 | 18480.0 |
| 2010-08-24 08:04:00 | AAPL | Stock | 8.7007 | 8.7007 | 8.6982 | 8.6982 | 17920.0 |
| 2010-08-24 08:05:00 | AAPL | Stock | 8.6982 | 8.7032 | 8.6982 | 8.6982 | 18200.0 |
| 2010-08-24 08:06:00 | AAPL | Stock | 8.6982 | 8.6982 | 8.6982 | 8.6982 | 30436.0 |
| 2010-08-24 08:07:00 | AAPL | Stock | 8.6932 | 8.6982 | 8.6929 | 8.6961 | 166600.0 |
| 2010-08-24 08:09:00 | AAPL | Stock | 8.6929 | 8.6957 | 8.6929 | 8.6946 | 39200.0 |
| 2010-08-24 08:10:00 | AAPL | Stock | 8.6993 | 8.7 | 8.6964 | 8.6964 | 34160.0 |
| 2010-08-24 08:11:00 | AAPL | Stock | 8.6936 | 8.6982 | 8.6893 | 8.6893 | 91896.0 |
| 2010-08-24 08:12:00 | AAPL | Stock | 8.6886 | 8.6904 | 8.6839 | 8.6839 | 71988.0 |
| 2010-08-24 08:13:00 | AAPL | Stock | 8.6807 | 8.6868 | 8.6718 | 8.6721 | 101612.0 |
| 2010-08-24 08:14:00 | AAPL | Stock | 8.6718 | 8.6732 | 8.6696 | 8.6696 | 89180.0 |
| 2010-08-24 08:15:00 | AAPL | Stock | 8.6696 | 8.6736 | 8.6654 | 8.6704 | 235900.0 |
| 2010-08-24 08:16:00 | AAPL | Stock | 8.6775 | 8.6775 | 8.6696 | 8.6696 | 8400.0 |
| 2010-08-24 08:17:00 | AAPL | Stock | 8.6689 | 8.6714 | 8.6664 | 8.6664 | 38920.0 |
| 2010-08-24 08:18:00 | AAPL | Stock | 8.6679 | 8.6696 | 8.6607 | 8.6679 | 110740.0 |
| 2010-08-24 08:19:00 | AAPL | Stock | 8.6668 | 8.6679 | 8.6607 | 8.6679 | 41860.0 |
| 2010-08-24 08:20:00 | AAPL | Stock | 8.6643 | 8.6643 | 8.6643 | 8.6643 | 7000.0 |
| 2010-08-24 08:21:00 | AAPL | Stock | 8.6607 | 8.6679 | 8.6607 | 8.6643 | 27860.0 |
| 2010-08-24 08:22:00 | AAPL | Stock | 8.6611 | 8.6679 | 8.6607 | 8.6679 | 22400.0 |
| 2010-08-24 08:23:00 | AAPL | Stock | 8.6675 | 8.6675 | 8.6675 | 8.6675 | 14000.0 |
| 2010-08-24 08:24:00 | AAPL | Stock | 8.6632 | 8.6711 | 8.6629 | 8.6711 | 14000.0 |
| 2010-08-24 08:25:00 | AAPL | Stock | 8.6714 | 8.675 | 8.6679 | 8.6696 | 23744.0 |
| 2010-08-24 08:26:00 | AAPL | Stock | 8.6696 | 8.6696 | 8.6657 | 8.6682 | 16800.0 |
> showing 50 of 968,749 rows — these rows as CSV