PREVIEW / stock_1min / 2005-08-24
file: by_date/stock_1min/2005/2005-08-24.parquet size: 7.0 MB rows: 578,948 symbols: 1,690
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-24 08:08:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 14000.0 |
| 2005-08-24 08:11:00 | AAPL | Stock | 1.6232 | 1.625 | 1.6232 | 1.625 | 19600.0 |
| 2005-08-24 08:13:00 | AAPL | Stock | 1.6232 | 1.6232 | 1.6232 | 1.6232 | 10360.0 |
| 2005-08-24 08:14:00 | AAPL | Stock | 1.6232 | 1.6232 | 1.6232 | 1.6232 | 2800.0 |
| 2005-08-24 08:15:00 | AAPL | Stock | 1.625 | 1.6279 | 1.625 | 1.6279 | 28000.0 |
| 2005-08-24 08:17:00 | AAPL | Stock | 1.6268 | 1.6279 | 1.6268 | 1.6279 | 42000.0 |
| 2005-08-24 08:30:00 | AAPL | Stock | 1.6275 | 1.6275 | 1.6275 | 1.6275 | 28000.0 |
| 2005-08-24 08:31:00 | AAPL | Stock | 1.6275 | 1.6275 | 1.6271 | 1.6271 | 103600.0 |
| 2005-08-24 08:32:00 | AAPL | Stock | 1.6275 | 1.6275 | 1.6254 | 1.6254 | 56000.0 |
| 2005-08-24 08:34:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 8400.0 |
| 2005-08-24 08:39:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 36400.0 |
| 2005-08-24 08:42:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 26600.0 |
| 2005-08-24 08:44:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 28000.0 |
| 2005-08-24 08:45:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 13664.0 |
| 2005-08-24 08:50:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.625 | 1.625 | 30800.0 |
| 2005-08-24 08:51:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 22400.0 |
| 2005-08-24 08:52:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 11200.0 |
| 2005-08-24 08:54:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 14000.0 |
| 2005-08-24 08:57:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 14000.0 |
| 2005-08-24 08:59:00 | AAPL | Stock | 1.6336 | 1.6336 | 1.6336 | 1.6336 | 462000.0 |
| 2005-08-24 09:00:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.625 | 1.625 | 5600.0 |
| 2005-08-24 09:01:00 | AAPL | Stock | 1.625 | 1.625 | 1.6243 | 1.6243 | 47600.0 |
| 2005-08-24 09:02:00 | AAPL | Stock | 1.6239 | 1.6239 | 1.6239 | 1.6239 | 11900.0 |
| 2005-08-24 09:03:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 2800.0 |
| 2005-08-24 09:04:00 | AAPL | Stock | 1.6232 | 1.6232 | 1.6232 | 1.6232 | 3640.0 |
| 2005-08-24 09:07:00 | AAPL | Stock | 1.6232 | 1.6232 | 1.6232 | 1.6232 | 2800.0 |
| 2005-08-24 09:16:00 | AAPL | Stock | 1.6239 | 1.6239 | 1.6239 | 1.6239 | 2800.0 |
| 2005-08-24 09:17:00 | AAPL | Stock | 1.6236 | 1.6236 | 1.6236 | 1.6236 | 2800.0 |
| 2005-08-24 09:19:00 | AAPL | Stock | 1.6246 | 1.6246 | 1.6246 | 1.6246 | 14000.0 |
| 2005-08-24 09:20:00 | AAPL | Stock | 1.625 | 1.625 | 1.6232 | 1.6232 | 27160.0 |
| 2005-08-24 09:24:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 145488.0 |
| 2005-08-24 09:25:00 | AAPL | Stock | 1.6254 | 1.6279 | 1.6254 | 1.6254 | 142800.0 |
| 2005-08-24 09:27:00 | AAPL | Stock | 1.6282 | 1.6286 | 1.6279 | 1.6279 | 140000.0 |
| 2005-08-24 09:29:00 | AAPL | Stock | 1.6282 | 1.6289 | 1.6246 | 1.6286 | 112000.0 |
| 2005-08-24 09:30:00 | AAPL | Stock | 1.6286 | 1.6375 | 1.6282 | 1.6375 | 3492188.0 |
| 2005-08-24 09:31:00 | AAPL | Stock | 1.6375 | 1.64 | 1.6314 | 1.6339 | 1974532.0 |
| 2005-08-24 09:32:00 | AAPL | Stock | 1.6336 | 1.6371 | 1.6329 | 1.6343 | 1168468.0 |
| 2005-08-24 09:33:00 | AAPL | Stock | 1.6346 | 1.6368 | 1.6339 | 1.635 | 2359280.0 |
| 2005-08-24 09:34:00 | AAPL | Stock | 1.635 | 1.6429 | 1.635 | 1.6425 | 7366352.0 |
| 2005-08-24 09:35:00 | AAPL | Stock | 1.6429 | 1.6464 | 1.6396 | 1.6464 | 5115740.0 |
| 2005-08-24 09:36:00 | AAPL | Stock | 1.6468 | 1.6468 | 1.6418 | 1.6421 | 2742796.0 |
| 2005-08-24 09:37:00 | AAPL | Stock | 1.6418 | 1.6421 | 1.6346 | 1.6375 | 2560040.0 |
| 2005-08-24 09:38:00 | AAPL | Stock | 1.6379 | 1.6386 | 1.6343 | 1.6386 | 1919456.0 |
| 2005-08-24 09:39:00 | AAPL | Stock | 1.6382 | 1.6407 | 1.6364 | 1.6385 | 1871240.0 |
| 2005-08-24 09:40:00 | AAPL | Stock | 1.6382 | 1.6389 | 1.6357 | 1.6375 | 2496060.0 |
| 2005-08-24 09:41:00 | AAPL | Stock | 1.6375 | 1.6393 | 1.6361 | 1.6371 | 1865248.0 |
| 2005-08-24 09:42:00 | AAPL | Stock | 1.6379 | 1.64 | 1.6368 | 1.6396 | 1308496.0 |
| 2005-08-24 09:43:00 | AAPL | Stock | 1.64 | 1.6436 | 1.6396 | 1.6404 | 3038896.0 |
| 2005-08-24 09:44:00 | AAPL | Stock | 1.6418 | 1.6418 | 1.6386 | 1.6396 | 1494864.0 |
| 2005-08-24 09:45:00 | AAPL | Stock | 1.6396 | 1.6411 | 1.6393 | 1.6393 | 961352.0 |
> showing 50 of 578,948 rows — these rows as CSV