PREVIEW / stock_1min / 2008-05-19
file: by_date/stock_1min/2008/2008-05-19.parquet size: 12.6 MB rows: 1,010,766 symbols: 2,698
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-19 07:03:00 | AAPL | Stock | 6.7179 | 6.7179 | 6.7179 | 6.7179 | 2800.0 |
| 2008-05-19 07:10:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 70000.0 |
| 2008-05-19 07:11:00 | AAPL | Stock | 6.6614 | 6.6614 | 6.6614 | 6.6614 | 12600.0 |
| 2008-05-19 07:12:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 19600.0 |
| 2008-05-19 07:13:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6625 | 6.6625 | 70000.0 |
| 2008-05-19 07:14:00 | AAPL | Stock | 6.665 | 6.665 | 6.665 | 6.665 | 19600.0 |
| 2008-05-19 07:15:00 | AAPL | Stock | 6.6654 | 6.6668 | 6.6654 | 6.6668 | 98000.0 |
| 2008-05-19 07:17:00 | AAPL | Stock | 6.6668 | 6.6668 | 6.6668 | 6.6668 | 38500.0 |
| 2008-05-19 07:28:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 5600.0 |
| 2008-05-19 07:39:00 | AAPL | Stock | 6.6689 | 6.6689 | 6.6689 | 6.6689 | 14000.0 |
| 2008-05-19 07:55:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2008-05-19 08:00:00 | AAPL | Stock | 6.6743 | 6.705 | 6.6743 | 6.6825 | 47600.0 |
| 2008-05-19 08:01:00 | AAPL | Stock | 6.6807 | 6.6807 | 6.6804 | 6.6804 | 5600.0 |
| 2008-05-19 08:02:00 | AAPL | Stock | 6.6832 | 6.6832 | 6.68 | 6.68 | 32200.0 |
| 2008-05-19 08:04:00 | AAPL | Stock | 6.6882 | 6.6964 | 6.6882 | 6.6925 | 63000.0 |
| 2008-05-19 08:05:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6796 | 6.6825 | 110572.0 |
| 2008-05-19 08:06:00 | AAPL | Stock | 6.6875 | 6.6875 | 6.6846 | 6.6846 | 9100.0 |
| 2008-05-19 08:07:00 | AAPL | Stock | 6.6907 | 6.6964 | 6.6907 | 6.6964 | 49000.0 |
| 2008-05-19 08:08:00 | AAPL | Stock | 6.6989 | 6.6989 | 6.6929 | 6.6929 | 26852.0 |
| 2008-05-19 08:09:00 | AAPL | Stock | 6.6929 | 6.6929 | 6.6929 | 6.6929 | 9800.0 |
| 2008-05-19 08:10:00 | AAPL | Stock | 6.6946 | 6.6946 | 6.6925 | 6.6925 | 52584.0 |
| 2008-05-19 08:11:00 | AAPL | Stock | 6.6925 | 6.6946 | 6.6925 | 6.6946 | 19516.0 |
| 2008-05-19 08:12:00 | AAPL | Stock | 6.6929 | 6.6971 | 6.6925 | 6.6964 | 44660.0 |
| 2008-05-19 08:13:00 | AAPL | Stock | 6.6964 | 6.7018 | 6.6964 | 6.7018 | 42392.0 |
| 2008-05-19 08:14:00 | AAPL | Stock | 6.705 | 6.705 | 6.705 | 6.705 | 5600.0 |
| 2008-05-19 08:15:00 | AAPL | Stock | 6.7089 | 6.7179 | 6.7082 | 6.7175 | 127400.0 |
| 2008-05-19 08:16:00 | AAPL | Stock | 6.7161 | 6.7161 | 6.7143 | 6.7143 | 48580.0 |
| 2008-05-19 08:18:00 | AAPL | Stock | 6.7146 | 6.7146 | 6.7132 | 6.7132 | 29400.0 |
| 2008-05-19 08:19:00 | AAPL | Stock | 6.7132 | 6.7132 | 6.7107 | 6.7107 | 16800.0 |
| 2008-05-19 08:20:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 12880.0 |
| 2008-05-19 08:21:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 2800.0 |
| 2008-05-19 08:22:00 | AAPL | Stock | 6.7136 | 6.7136 | 6.7054 | 6.7054 | 50400.0 |
| 2008-05-19 08:23:00 | AAPL | Stock | 6.7064 | 6.7107 | 6.7061 | 6.7061 | 69832.0 |
| 2008-05-19 08:24:00 | AAPL | Stock | 6.7079 | 6.7079 | 6.7079 | 6.7079 | 2800.0 |
| 2008-05-19 08:27:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 2800.0 |
| 2008-05-19 08:29:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 10780.0 |
| 2008-05-19 08:32:00 | AAPL | Stock | 6.7079 | 6.7079 | 6.7079 | 6.7079 | 2800.0 |
| 2008-05-19 08:33:00 | AAPL | Stock | 6.7057 | 6.7057 | 6.7057 | 6.7057 | 6776.0 |
| 2008-05-19 08:35:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 2800.0 |
| 2008-05-19 08:36:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 11200.0 |
| 2008-05-19 08:41:00 | AAPL | Stock | 6.7064 | 6.7064 | 6.705 | 6.705 | 9800.0 |
| 2008-05-19 08:43:00 | AAPL | Stock | 6.7054 | 6.7054 | 6.7054 | 6.7054 | 2800.0 |
| 2008-05-19 08:44:00 | AAPL | Stock | 6.7075 | 6.7089 | 6.7075 | 6.7079 | 22400.0 |
| 2008-05-19 08:46:00 | AAPL | Stock | 6.7132 | 6.7143 | 6.7132 | 6.7143 | 18508.0 |
| 2008-05-19 08:47:00 | AAPL | Stock | 6.7111 | 6.7139 | 6.7111 | 6.7139 | 25200.0 |
| 2008-05-19 08:48:00 | AAPL | Stock | 6.7132 | 6.7132 | 6.7125 | 6.7129 | 28000.0 |
| 2008-05-19 08:49:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 17892.0 |
| 2008-05-19 08:50:00 | AAPL | Stock | 6.7143 | 6.7146 | 6.7143 | 6.7146 | 21700.0 |
| 2008-05-19 08:51:00 | AAPL | Stock | 6.715 | 6.715 | 6.7136 | 6.7143 | 102816.0 |
| 2008-05-19 08:52:00 | AAPL | Stock | 6.7132 | 6.7132 | 6.7132 | 6.7132 | 11200.0 |
> showing 50 of 1,010,766 rows — these rows as CSV