PREVIEW / stock_1min / 2006-12-28
file: by_date/stock_1min/2006/2006-12-28.parquet size: 8.5 MB rows: 685,797 symbols: 2,024
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-28 04:53:00 | AAPL | Stock | 2.8282 | 2.8282 | 2.8282 | 2.8282 | 5600.0 |
| 2006-12-28 06:00:00 | AAPL | Stock | 2.8143 | 2.8143 | 2.8143 | 2.8143 | 28000.0 |
| 2006-12-28 06:05:00 | AAPL | Stock | 2.8232 | 2.8232 | 2.8232 | 2.8232 | 140000.0 |
| 2006-12-28 06:15:00 | AAPL | Stock | 2.8257 | 2.8257 | 2.8257 | 2.8257 | 11200.0 |
| 2006-12-28 06:20:00 | AAPL | Stock | 2.825 | 2.825 | 2.825 | 2.825 | 28000.0 |
| 2006-12-28 06:32:00 | AAPL | Stock | 2.8257 | 2.8261 | 2.8257 | 2.8261 | 11200.0 |
| 2006-12-28 06:37:00 | AAPL | Stock | 2.8257 | 2.8257 | 2.8257 | 2.8257 | 2800.0 |
| 2006-12-28 06:44:00 | AAPL | Stock | 2.8268 | 2.8268 | 2.8268 | 2.8268 | 112000.0 |
| 2006-12-28 06:53:00 | AAPL | Stock | 2.8179 | 2.8179 | 2.8179 | 2.8179 | 139636.0 |
| 2006-12-28 06:58:00 | AAPL | Stock | 2.8161 | 2.8161 | 2.8143 | 2.8143 | 114800.0 |
| 2006-12-28 07:00:00 | AAPL | Stock | 2.8161 | 2.8161 | 2.8039 | 2.8039 | 5600.0 |
| 2006-12-28 07:01:00 | AAPL | Stock | 2.8161 | 2.8161 | 2.8161 | 2.8161 | 2828.0 |
| 2006-12-28 07:02:00 | AAPL | Stock | 2.8043 | 2.8043 | 2.8043 | 2.8043 | 14000.0 |
| 2006-12-28 07:04:00 | AAPL | Stock | 2.815 | 2.8161 | 2.815 | 2.8161 | 200620.0 |
| 2006-12-28 07:05:00 | AAPL | Stock | 2.8168 | 2.8168 | 2.8164 | 2.8164 | 56000.0 |
| 2006-12-28 07:06:00 | AAPL | Stock | 2.8146 | 2.8146 | 2.8146 | 2.8146 | 14000.0 |
| 2006-12-28 07:07:00 | AAPL | Stock | 2.8132 | 2.8132 | 2.8132 | 2.8132 | 33600.0 |
| 2006-12-28 07:08:00 | AAPL | Stock | 2.8132 | 2.8161 | 2.8132 | 2.8161 | 28000.0 |
| 2006-12-28 07:09:00 | AAPL | Stock | 2.8143 | 2.8143 | 2.8143 | 2.8143 | 2800.0 |
| 2006-12-28 07:10:00 | AAPL | Stock | 2.8143 | 2.8143 | 2.8125 | 2.8125 | 98028.0 |
| 2006-12-28 07:11:00 | AAPL | Stock | 2.8061 | 2.8061 | 2.8036 | 2.805 | 153608.0 |
| 2006-12-28 07:12:00 | AAPL | Stock | 2.805 | 2.805 | 2.805 | 2.805 | 28000.0 |
| 2006-12-28 07:13:00 | AAPL | Stock | 2.8043 | 2.8071 | 2.8004 | 2.8004 | 210420.0 |
| 2006-12-28 07:14:00 | AAPL | Stock | 2.8004 | 2.8004 | 2.7932 | 2.7932 | 355600.0 |
| 2006-12-28 07:15:00 | AAPL | Stock | 2.7932 | 2.7932 | 2.7818 | 2.7857 | 212800.0 |
| 2006-12-28 07:16:00 | AAPL | Stock | 2.7857 | 2.7893 | 2.7818 | 2.7825 | 100800.0 |
| 2006-12-28 07:17:00 | AAPL | Stock | 2.7821 | 2.7857 | 2.7821 | 2.7821 | 56000.0 |
| 2006-12-28 07:18:00 | AAPL | Stock | 2.7796 | 2.7857 | 2.7786 | 2.7789 | 127372.0 |
| 2006-12-28 07:19:00 | AAPL | Stock | 2.7786 | 2.7786 | 2.7714 | 2.7714 | 114156.0 |
| 2006-12-28 07:20:00 | AAPL | Stock | 2.7754 | 2.7754 | 2.7714 | 2.775 | 150976.0 |
| 2006-12-28 07:21:00 | AAPL | Stock | 2.775 | 2.7754 | 2.7704 | 2.7704 | 446600.0 |
| 2006-12-28 07:22:00 | AAPL | Stock | 2.77 | 2.7714 | 2.7625 | 2.7643 | 375200.0 |
| 2006-12-28 07:23:00 | AAPL | Stock | 2.7629 | 2.7686 | 2.7579 | 2.7686 | 267400.0 |
| 2006-12-28 07:24:00 | AAPL | Stock | 2.7686 | 2.7754 | 2.7686 | 2.775 | 228200.0 |
| 2006-12-28 07:25:00 | AAPL | Stock | 2.775 | 2.7754 | 2.775 | 2.7754 | 210000.0 |
| 2006-12-28 07:26:00 | AAPL | Stock | 2.775 | 2.8143 | 2.7714 | 2.7754 | 386400.0 |
| 2006-12-28 07:27:00 | AAPL | Stock | 2.7754 | 2.7754 | 2.775 | 2.775 | 61600.0 |
| 2006-12-28 07:28:00 | AAPL | Stock | 2.7729 | 2.7729 | 2.7729 | 2.7729 | 44800.0 |
| 2006-12-28 07:29:00 | AAPL | Stock | 2.7725 | 2.7779 | 2.7725 | 2.7779 | 142800.0 |
| 2006-12-28 07:30:00 | AAPL | Stock | 2.775 | 2.8 | 2.775 | 2.8 | 292488.0 |
| 2006-12-28 07:31:00 | AAPL | Stock | 2.8 | 2.8007 | 2.7929 | 2.7929 | 495600.0 |
| 2006-12-28 07:32:00 | AAPL | Stock | 2.7929 | 2.7946 | 2.7886 | 2.7946 | 140000.0 |
| 2006-12-28 07:33:00 | AAPL | Stock | 2.7932 | 2.7964 | 2.7929 | 2.7929 | 243600.0 |
| 2006-12-28 07:34:00 | AAPL | Stock | 2.7896 | 2.7939 | 2.7829 | 2.7929 | 475440.0 |
| 2006-12-28 07:35:00 | AAPL | Stock | 2.7893 | 2.7929 | 2.7893 | 2.7929 | 291200.0 |
| 2006-12-28 07:36:00 | AAPL | Stock | 2.7911 | 2.7911 | 2.7911 | 2.7911 | 11200.0 |
| 2006-12-28 07:37:00 | AAPL | Stock | 2.7929 | 2.7929 | 2.7929 | 2.7929 | 14000.0 |
| 2006-12-28 07:38:00 | AAPL | Stock | 2.7929 | 2.8 | 2.7929 | 2.8 | 235172.0 |
| 2006-12-28 07:39:00 | AAPL | Stock | 2.8 | 2.8036 | 2.7982 | 2.7982 | 91840.0 |
| 2006-12-28 07:40:00 | AAPL | Stock | 2.8 | 2.8068 | 2.8 | 2.805 | 232400.0 |
> showing 50 of 685,797 rows — these rows as CSV