PREVIEW / stock_1min / 2007-03-05
file: by_date/stock_1min/2007/2007-03-05.parquet size: 10.7 MB rows: 859,918 symbols: 2,068
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-05 04:55:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 14700.0 |
| 2007-03-05 06:05:00 | AAPL | Stock | 2.9921 | 2.9921 | 2.9921 | 2.9921 | 11200.0 |
| 2007-03-05 06:07:00 | AAPL | Stock | 2.9921 | 2.9921 | 2.9921 | 2.9921 | 16800.0 |
| 2007-03-05 06:23:00 | AAPL | Stock | 2.9893 | 2.9893 | 2.9893 | 2.9893 | 14000.0 |
| 2007-03-05 06:34:00 | AAPL | Stock | 2.9986 | 3.0018 | 2.9986 | 3.0018 | 11200.0 |
| 2007-03-05 06:35:00 | AAPL | Stock | 3.03 | 3.03 | 3.0232 | 3.0232 | 67200.0 |
| 2007-03-05 06:36:00 | AAPL | Stock | 3.0232 | 3.0246 | 3.0232 | 3.0246 | 28000.0 |
| 2007-03-05 06:40:00 | AAPL | Stock | 3.0286 | 3.035 | 3.0286 | 3.035 | 28000.0 |
| 2007-03-05 06:42:00 | AAPL | Stock | 3.0314 | 3.0321 | 3.0314 | 3.0321 | 39200.0 |
| 2007-03-05 06:43:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0111 | 3.0111 | 12040.0 |
| 2007-03-05 06:48:00 | AAPL | Stock | 3.0286 | 3.0321 | 3.0286 | 3.0321 | 5600.0 |
| 2007-03-05 06:50:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 19600.0 |
| 2007-03-05 06:52:00 | AAPL | Stock | 3.0257 | 3.0257 | 3.0257 | 3.0257 | 14000.0 |
| 2007-03-05 06:57:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 5600.0 |
| 2007-03-05 07:01:00 | AAPL | Stock | 3.035 | 3.0357 | 3.035 | 3.0357 | 14000.0 |
| 2007-03-05 07:04:00 | AAPL | Stock | 3.0232 | 3.0286 | 3.0214 | 3.0286 | 17220.0 |
| 2007-03-05 07:05:00 | AAPL | Stock | 3.0286 | 3.0321 | 3.025 | 3.0321 | 70000.0 |
| 2007-03-05 07:07:00 | AAPL | Stock | 3.0289 | 3.0357 | 3.0289 | 3.0357 | 22876.0 |
| 2007-03-05 07:08:00 | AAPL | Stock | 3.0293 | 3.0293 | 3.0293 | 3.0293 | 2800.0 |
| 2007-03-05 07:12:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 2800.0 |
| 2007-03-05 07:13:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 16800.0 |
| 2007-03-05 07:21:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 8400.0 |
| 2007-03-05 07:23:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 33600.0 |
| 2007-03-05 07:27:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 43400.0 |
| 2007-03-05 07:30:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 7000.0 |
| 2007-03-05 07:31:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 14000.0 |
| 2007-03-05 07:32:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 39200.0 |
| 2007-03-05 07:34:00 | AAPL | Stock | 3.0329 | 3.0329 | 3.0329 | 3.0329 | 2800.0 |
| 2007-03-05 07:35:00 | AAPL | Stock | 3.0332 | 3.0336 | 3.0332 | 3.0336 | 5600.0 |
| 2007-03-05 07:36:00 | AAPL | Stock | 3.0364 | 3.0364 | 3.0364 | 3.0364 | 4928.0 |
| 2007-03-05 07:38:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 2800.0 |
| 2007-03-05 07:39:00 | AAPL | Stock | 3.0386 | 3.0443 | 3.0321 | 3.0443 | 86800.0 |
| 2007-03-05 07:40:00 | AAPL | Stock | 3.0404 | 3.0446 | 3.0404 | 3.0446 | 39200.0 |
| 2007-03-05 07:41:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0396 | 3.0396 | 147140.0 |
| 2007-03-05 07:42:00 | AAPL | Stock | 3.0425 | 3.0429 | 3.0425 | 3.0429 | 85260.0 |
| 2007-03-05 07:44:00 | AAPL | Stock | 3.0429 | 3.0443 | 3.0429 | 3.0443 | 25200.0 |
| 2007-03-05 07:45:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 22400.0 |
| 2007-03-05 07:46:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 14140.0 |
| 2007-03-05 07:48:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 2800.0 |
| 2007-03-05 07:50:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0375 | 3.0375 | 27860.0 |
| 2007-03-05 07:51:00 | AAPL | Stock | 3.0425 | 3.0425 | 3.0379 | 3.0379 | 16800.0 |
| 2007-03-05 07:55:00 | AAPL | Stock | 3.0411 | 3.0439 | 3.0375 | 3.0439 | 58940.0 |
| 2007-03-05 07:56:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 36400.0 |
| 2007-03-05 07:57:00 | AAPL | Stock | 3.0461 | 3.0461 | 3.0411 | 3.0429 | 40600.0 |
| 2007-03-05 07:59:00 | AAPL | Stock | 3.0418 | 3.0446 | 3.04 | 3.0446 | 78400.0 |
| 2007-03-05 08:00:00 | AAPL | Stock | 3.04 | 3.0457 | 3.0357 | 3.0407 | 243012.0 |
| 2007-03-05 08:01:00 | AAPL | Stock | 3.0393 | 3.0418 | 3.0393 | 3.0407 | 119420.0 |
| 2007-03-05 08:02:00 | AAPL | Stock | 3.0411 | 3.0418 | 3.0404 | 3.0418 | 134400.0 |
| 2007-03-05 08:03:00 | AAPL | Stock | 3.0404 | 3.0429 | 3.0404 | 3.0404 | 182728.0 |
| 2007-03-05 08:04:00 | AAPL | Stock | 3.0418 | 3.0418 | 3.0414 | 3.0414 | 72240.0 |
> showing 50 of 859,918 rows — these rows as CSV