PREVIEW / stock_1min / 2008-05-13
file: by_date/stock_1min/2008/2008-05-13.parquet size: 12.1 MB rows: 980,068 symbols: 2,688
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-13 05:26:00 | AAPL | Stock | 6.6993 | 6.6993 | 6.6993 | 6.6993 | 4200.0 |
| 2008-05-13 06:57:00 | AAPL | Stock | 6.7354 | 6.7354 | 6.7354 | 6.7354 | 2800.0 |
| 2008-05-13 07:23:00 | AAPL | Stock | 6.715 | 6.715 | 6.7143 | 6.7143 | 58800.0 |
| 2008-05-13 07:25:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 2800.0 |
| 2008-05-13 07:26:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 16800.0 |
| 2008-05-13 07:29:00 | AAPL | Stock | 6.7089 | 6.7143 | 6.7089 | 6.7143 | 25200.0 |
| 2008-05-13 07:47:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 2800.0 |
| 2008-05-13 07:48:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 7532.0 |
| 2008-05-13 07:51:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 25200.0 |
| 2008-05-13 07:54:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 28000.0 |
| 2008-05-13 07:58:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.7036 | 6.7036 | 5600.0 |
| 2008-05-13 08:00:00 | AAPL | Stock | 6.7093 | 6.7104 | 6.7057 | 6.7057 | 48132.0 |
| 2008-05-13 08:01:00 | AAPL | Stock | 6.7061 | 6.7061 | 6.7004 | 6.7007 | 11200.0 |
| 2008-05-13 08:02:00 | AAPL | Stock | 6.7018 | 6.7021 | 6.7018 | 6.7018 | 41440.0 |
| 2008-05-13 08:03:00 | AAPL | Stock | 6.7018 | 6.7068 | 6.6989 | 6.7068 | 70028.0 |
| 2008-05-13 08:04:00 | AAPL | Stock | 6.7068 | 6.7071 | 6.7068 | 6.7071 | 16996.0 |
| 2008-05-13 08:07:00 | AAPL | Stock | 6.7079 | 6.7079 | 6.7079 | 6.7079 | 25200.0 |
| 2008-05-13 08:08:00 | AAPL | Stock | 6.7079 | 6.7079 | 6.7071 | 6.7071 | 25312.0 |
| 2008-05-13 08:09:00 | AAPL | Stock | 6.7061 | 6.7071 | 6.7061 | 6.7071 | 16100.0 |
| 2008-05-13 08:10:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7061 | 6.7061 | 16800.0 |
| 2008-05-13 08:13:00 | AAPL | Stock | 6.7089 | 6.7089 | 6.7089 | 6.7089 | 2800.0 |
| 2008-05-13 08:14:00 | AAPL | Stock | 6.7089 | 6.7089 | 6.7089 | 6.7089 | 7000.0 |
| 2008-05-13 08:16:00 | AAPL | Stock | 6.7086 | 6.7096 | 6.7086 | 6.7096 | 37492.0 |
| 2008-05-13 08:17:00 | AAPL | Stock | 6.71 | 6.7121 | 6.71 | 6.7121 | 8400.0 |
| 2008-05-13 08:18:00 | AAPL | Stock | 6.7114 | 6.7161 | 6.7114 | 6.7161 | 19600.0 |
| 2008-05-13 08:19:00 | AAPL | Stock | 6.7146 | 6.7146 | 6.7146 | 6.7146 | 2800.0 |
| 2008-05-13 08:20:00 | AAPL | Stock | 6.7146 | 6.7175 | 6.7143 | 6.7175 | 22400.0 |
| 2008-05-13 08:21:00 | AAPL | Stock | 6.7175 | 6.7189 | 6.7175 | 6.7189 | 28168.0 |
| 2008-05-13 08:22:00 | AAPL | Stock | 6.7196 | 6.7196 | 6.7132 | 6.7132 | 58100.0 |
| 2008-05-13 08:24:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 6160.0 |
| 2008-05-13 08:25:00 | AAPL | Stock | 6.7104 | 6.7107 | 6.7089 | 6.7089 | 25200.0 |
| 2008-05-13 08:26:00 | AAPL | Stock | 6.7089 | 6.7104 | 6.7075 | 6.7075 | 8400.0 |
| 2008-05-13 08:27:00 | AAPL | Stock | 6.7107 | 6.7139 | 6.7075 | 6.7075 | 28000.0 |
| 2008-05-13 08:28:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7121 | 6.7121 | 5600.0 |
| 2008-05-13 08:29:00 | AAPL | Stock | 6.7164 | 6.7164 | 6.7157 | 6.7164 | 14000.0 |
| 2008-05-13 08:30:00 | AAPL | Stock | 6.7143 | 6.7196 | 6.7136 | 6.7196 | 168448.0 |
| 2008-05-13 08:31:00 | AAPL | Stock | 6.7196 | 6.7214 | 6.7196 | 6.7214 | 55440.0 |
| 2008-05-13 08:32:00 | AAPL | Stock | 6.7196 | 6.7232 | 6.7196 | 6.7221 | 174160.0 |
| 2008-05-13 08:33:00 | AAPL | Stock | 6.7236 | 6.725 | 6.7221 | 6.7239 | 72800.0 |
| 2008-05-13 08:34:00 | AAPL | Stock | 6.7229 | 6.7236 | 6.7214 | 6.7236 | 98000.0 |
| 2008-05-13 08:35:00 | AAPL | Stock | 6.7229 | 6.725 | 6.7221 | 6.725 | 70000.0 |
| 2008-05-13 08:36:00 | AAPL | Stock | 6.725 | 6.7304 | 6.725 | 6.73 | 153720.0 |
| 2008-05-13 08:37:00 | AAPL | Stock | 6.7257 | 6.7275 | 6.7246 | 6.7275 | 44800.0 |
| 2008-05-13 08:38:00 | AAPL | Stock | 6.725 | 6.7254 | 6.7236 | 6.7236 | 21000.0 |
| 2008-05-13 08:39:00 | AAPL | Stock | 6.7257 | 6.7304 | 6.7257 | 6.7293 | 125020.0 |
| 2008-05-13 08:40:00 | AAPL | Stock | 6.7293 | 6.7332 | 6.7293 | 6.7321 | 72688.0 |
| 2008-05-13 08:41:00 | AAPL | Stock | 6.7314 | 6.7314 | 6.7289 | 6.7304 | 79884.0 |
| 2008-05-13 08:42:00 | AAPL | Stock | 6.7293 | 6.7318 | 6.7293 | 6.7296 | 34104.0 |
| 2008-05-13 08:43:00 | AAPL | Stock | 6.7296 | 6.7304 | 6.7296 | 6.7304 | 18424.0 |
| 2008-05-13 08:44:00 | AAPL | Stock | 6.7296 | 6.7318 | 6.7296 | 6.7314 | 33880.0 |
> showing 50 of 980,068 rows — these rows as CSV