PREVIEW / stock_1min / 2009-05-12
file: by_date/stock_1min/2009/2009-05-12.parquet size: 13.3 MB rows: 1,010,734 symbols: 2,721
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-12 05:14:00 | AAPL | Stock | 4.6425 | 4.6425 | 4.6425 | 4.6425 | 14000.0 |
| 2009-05-12 07:00:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 14000.0 |
| 2009-05-12 07:46:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 14000.0 |
| 2009-05-12 07:49:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 11200.0 |
| 2009-05-12 07:53:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 2800.0 |
| 2009-05-12 08:01:00 | AAPL | Stock | 4.6339 | 4.6339 | 4.6339 | 4.6339 | 14000.0 |
| 2009-05-12 08:02:00 | AAPL | Stock | 4.6339 | 4.6339 | 4.6339 | 4.6339 | 11200.0 |
| 2009-05-12 08:03:00 | AAPL | Stock | 4.6289 | 4.6357 | 4.6289 | 4.6357 | 15960.0 |
| 2009-05-12 08:05:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6357 | 4.6357 | 8400.0 |
| 2009-05-12 08:07:00 | AAPL | Stock | 4.6346 | 4.6346 | 4.6346 | 4.6346 | 2800.0 |
| 2009-05-12 08:10:00 | AAPL | Stock | 4.6364 | 4.6404 | 4.6357 | 4.6404 | 19600.0 |
| 2009-05-12 08:12:00 | AAPL | Stock | 4.6411 | 4.6411 | 4.6411 | 4.6411 | 2800.0 |
| 2009-05-12 08:18:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 4620.0 |
| 2009-05-12 08:21:00 | AAPL | Stock | 4.6461 | 4.6464 | 4.6461 | 4.6461 | 39844.0 |
| 2009-05-12 08:22:00 | AAPL | Stock | 4.6461 | 4.6461 | 4.6461 | 4.6461 | 13356.0 |
| 2009-05-12 08:26:00 | AAPL | Stock | 4.65 | 4.6504 | 4.6489 | 4.6489 | 11200.0 |
| 2009-05-12 08:28:00 | AAPL | Stock | 4.6471 | 4.6471 | 4.6471 | 4.6471 | 2800.0 |
| 2009-05-12 08:29:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6471 | 4.6471 | 11956.0 |
| 2009-05-12 08:30:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 2800.0 |
| 2009-05-12 08:31:00 | AAPL | Stock | 4.6471 | 4.6471 | 4.6471 | 4.6471 | 19600.0 |
| 2009-05-12 08:32:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 2800.0 |
| 2009-05-12 08:33:00 | AAPL | Stock | 4.6446 | 4.6446 | 4.6432 | 4.6432 | 8400.0 |
| 2009-05-12 08:35:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6464 | 4.6464 | 11200.0 |
| 2009-05-12 08:38:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6464 | 4.6464 | 2800.0 |
| 2009-05-12 08:40:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6464 | 4.6464 | 5600.0 |
| 2009-05-12 08:41:00 | AAPL | Stock | 4.6475 | 4.6496 | 4.6475 | 4.6482 | 36400.0 |
| 2009-05-12 08:47:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 2800.0 |
| 2009-05-12 08:48:00 | AAPL | Stock | 4.6493 | 4.65 | 4.6493 | 4.65 | 50400.0 |
| 2009-05-12 08:49:00 | AAPL | Stock | 4.6504 | 4.6529 | 4.6504 | 4.6529 | 28000.0 |
| 2009-05-12 08:50:00 | AAPL | Stock | 4.6539 | 4.655 | 4.6539 | 4.655 | 5600.0 |
| 2009-05-12 08:51:00 | AAPL | Stock | 4.6536 | 4.6536 | 4.6536 | 4.6536 | 2800.0 |
| 2009-05-12 08:52:00 | AAPL | Stock | 4.6511 | 4.6511 | 4.6511 | 4.6511 | 2800.0 |
| 2009-05-12 09:01:00 | AAPL | Stock | 4.6457 | 4.6457 | 4.6457 | 4.6457 | 2800.0 |
| 2009-05-12 09:03:00 | AAPL | Stock | 4.6493 | 4.6493 | 4.6493 | 4.6493 | 2800.0 |
| 2009-05-12 09:04:00 | AAPL | Stock | 4.6439 | 4.6443 | 4.6429 | 4.6429 | 67144.0 |
| 2009-05-12 09:05:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6393 | 4.6393 | 39200.0 |
| 2009-05-12 09:06:00 | AAPL | Stock | 4.6393 | 4.6393 | 4.6375 | 4.6382 | 41720.0 |
| 2009-05-12 09:08:00 | AAPL | Stock | 4.6382 | 4.6382 | 4.6375 | 4.6375 | 10640.0 |
| 2009-05-12 09:10:00 | AAPL | Stock | 4.6386 | 4.6386 | 4.6386 | 4.6386 | 2800.0 |
| 2009-05-12 09:12:00 | AAPL | Stock | 4.6386 | 4.6386 | 4.6386 | 4.6386 | 26600.0 |
| 2009-05-12 09:15:00 | AAPL | Stock | 4.6407 | 4.6425 | 4.6407 | 4.6425 | 19600.0 |
| 2009-05-12 09:17:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6386 | 4.6386 | 16772.0 |
| 2009-05-12 09:18:00 | AAPL | Stock | 4.6425 | 4.6429 | 4.6425 | 4.6429 | 11200.0 |
| 2009-05-12 09:22:00 | AAPL | Stock | 4.6436 | 4.6436 | 4.6436 | 4.6436 | 2800.0 |
| 2009-05-12 09:24:00 | AAPL | Stock | 4.6443 | 4.6443 | 4.6443 | 4.6443 | 2800.0 |
| 2009-05-12 09:27:00 | AAPL | Stock | 4.6393 | 4.6393 | 4.6386 | 4.6386 | 16100.0 |
| 2009-05-12 09:28:00 | AAPL | Stock | 4.6382 | 4.6382 | 4.6321 | 4.6321 | 16800.0 |
| 2009-05-12 09:29:00 | AAPL | Stock | 4.6321 | 4.6321 | 4.6275 | 4.6314 | 238000.0 |
| 2009-05-12 09:30:00 | AAPL | Stock | 4.6279 | 4.6325 | 4.6068 | 4.6208 | 5047616.0 |
| 2009-05-12 09:31:00 | AAPL | Stock | 4.6207 | 4.6232 | 4.5954 | 4.6014 | 2902900.0 |
> showing 50 of 1,010,734 rows — these rows as CSV