PREVIEW / stock_1min / 2008-08-06
file: by_date/stock_1min/2008/2008-08-06.parquet size: 12.7 MB rows: 1,027,954 symbols: 2,706
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-08-06 07:30:00 | AAPL | Stock | 5.7411 | 5.75 | 5.7411 | 5.75 | 15680.0 |
| 2008-08-06 07:35:00 | AAPL | Stock | 5.7518 | 5.7518 | 5.7518 | 5.7518 | 5600.0 |
| 2008-08-06 07:36:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 2800.0 |
| 2008-08-06 07:58:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 16800.0 |
| 2008-08-06 08:00:00 | AAPL | Stock | 5.7171 | 5.7286 | 5.7171 | 5.7214 | 19600.0 |
| 2008-08-06 08:01:00 | AAPL | Stock | 5.7268 | 5.7321 | 5.7218 | 5.7321 | 28000.0 |
| 2008-08-06 08:02:00 | AAPL | Stock | 5.7314 | 5.7314 | 5.73 | 5.73 | 5600.0 |
| 2008-08-06 08:03:00 | AAPL | Stock | 5.7304 | 5.7304 | 5.7304 | 5.7304 | 2800.0 |
| 2008-08-06 08:05:00 | AAPL | Stock | 5.7246 | 5.7282 | 5.7214 | 5.7279 | 29400.0 |
| 2008-08-06 08:06:00 | AAPL | Stock | 5.7279 | 5.7279 | 5.7179 | 5.7214 | 137900.0 |
| 2008-08-06 08:07:00 | AAPL | Stock | 5.7214 | 5.7214 | 5.7214 | 5.7214 | 28000.0 |
| 2008-08-06 08:08:00 | AAPL | Stock | 5.7257 | 5.7268 | 5.7232 | 5.7232 | 26600.0 |
| 2008-08-06 08:09:00 | AAPL | Stock | 5.7221 | 5.7268 | 5.7221 | 5.7268 | 42000.0 |
| 2008-08-06 08:10:00 | AAPL | Stock | 5.7264 | 5.7271 | 5.7232 | 5.7271 | 178920.0 |
| 2008-08-06 08:12:00 | AAPL | Stock | 5.7275 | 5.7304 | 5.7275 | 5.7304 | 116200.0 |
| 2008-08-06 08:13:00 | AAPL | Stock | 5.7321 | 5.7321 | 5.7321 | 5.7321 | 2800.0 |
| 2008-08-06 08:14:00 | AAPL | Stock | 5.7318 | 5.7346 | 5.7314 | 5.7346 | 74480.0 |
| 2008-08-06 08:16:00 | AAPL | Stock | 5.7286 | 5.7286 | 5.7286 | 5.7286 | 16072.0 |
| 2008-08-06 08:17:00 | AAPL | Stock | 5.7257 | 5.7282 | 5.7257 | 5.7282 | 5600.0 |
| 2008-08-06 08:18:00 | AAPL | Stock | 5.7286 | 5.7318 | 5.7229 | 5.7286 | 54656.0 |
| 2008-08-06 08:19:00 | AAPL | Stock | 5.7289 | 5.735 | 5.7289 | 5.7339 | 54684.0 |
| 2008-08-06 08:21:00 | AAPL | Stock | 5.7339 | 5.7339 | 5.7339 | 5.7339 | 2800.0 |
| 2008-08-06 08:23:00 | AAPL | Stock | 5.7321 | 5.7321 | 5.7289 | 5.7289 | 52472.0 |
| 2008-08-06 08:24:00 | AAPL | Stock | 5.7289 | 5.7289 | 5.7229 | 5.7236 | 157080.0 |
| 2008-08-06 08:27:00 | AAPL | Stock | 5.7264 | 5.7264 | 5.7236 | 5.7236 | 5600.0 |
| 2008-08-06 08:29:00 | AAPL | Stock | 5.7221 | 5.7225 | 5.7221 | 5.7221 | 8400.0 |
| 2008-08-06 08:30:00 | AAPL | Stock | 5.7229 | 5.7229 | 5.7229 | 5.7229 | 4200.0 |
| 2008-08-06 08:31:00 | AAPL | Stock | 5.7218 | 5.7218 | 5.7186 | 5.7186 | 5600.0 |
| 2008-08-06 08:32:00 | AAPL | Stock | 5.7189 | 5.7189 | 5.7146 | 5.7146 | 61152.0 |
| 2008-08-06 08:33:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 50400.0 |
| 2008-08-06 08:34:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7132 | 5.7143 | 95200.0 |
| 2008-08-06 08:35:00 | AAPL | Stock | 5.7107 | 5.7107 | 5.7107 | 5.7107 | 2800.0 |
| 2008-08-06 08:36:00 | AAPL | Stock | 5.7136 | 5.7204 | 5.7136 | 5.7143 | 48888.0 |
| 2008-08-06 08:37:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 16800.0 |
| 2008-08-06 08:39:00 | AAPL | Stock | 5.7107 | 5.7107 | 5.7107 | 5.7107 | 11200.0 |
| 2008-08-06 08:40:00 | AAPL | Stock | 5.7107 | 5.7107 | 5.7107 | 5.7107 | 8400.0 |
| 2008-08-06 08:41:00 | AAPL | Stock | 5.7107 | 5.7143 | 5.7107 | 5.7143 | 27244.0 |
| 2008-08-06 08:42:00 | AAPL | Stock | 5.715 | 5.715 | 5.7143 | 5.7143 | 28000.0 |
| 2008-08-06 08:44:00 | AAPL | Stock | 5.7146 | 5.7146 | 5.7143 | 5.7143 | 14000.0 |
| 2008-08-06 08:46:00 | AAPL | Stock | 5.7143 | 5.7175 | 5.7143 | 5.7175 | 11200.0 |
| 2008-08-06 08:47:00 | AAPL | Stock | 5.7175 | 5.7175 | 5.7175 | 5.7175 | 44800.0 |
| 2008-08-06 08:48:00 | AAPL | Stock | 5.7175 | 5.7175 | 5.7175 | 5.7175 | 5600.0 |
| 2008-08-06 08:50:00 | AAPL | Stock | 5.7171 | 5.7175 | 5.7143 | 5.7143 | 59920.0 |
| 2008-08-06 08:51:00 | AAPL | Stock | 5.7146 | 5.7146 | 5.7143 | 5.7143 | 19600.0 |
| 2008-08-06 08:53:00 | AAPL | Stock | 5.7125 | 5.7125 | 5.7125 | 5.7125 | 2800.0 |
| 2008-08-06 08:54:00 | AAPL | Stock | 5.7125 | 5.7139 | 5.7125 | 5.7139 | 5600.0 |
| 2008-08-06 08:55:00 | AAPL | Stock | 5.7175 | 5.7175 | 5.7175 | 5.7175 | 2800.0 |
| 2008-08-06 08:58:00 | AAPL | Stock | 5.7164 | 5.7164 | 5.7139 | 5.715 | 72800.0 |
| 2008-08-06 08:59:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 28000.0 |
| 2008-08-06 09:00:00 | AAPL | Stock | 5.7164 | 5.7175 | 5.7143 | 5.7143 | 24640.0 |
> showing 50 of 1,027,954 rows — these rows as CSV