PREVIEW / stock_1min / 2007-11-05
file: by_date/stock_1min/2007/2007-11-05.parquet size: 12.7 MB rows: 1,037,044 symbols: 2,607
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-11-05 04:16:00 | AAPL | Stock | 6.6804 | 6.6804 | 6.6804 | 6.6804 | 2800.0 |
| 2007-11-05 05:55:00 | AAPL | Stock | 6.6539 | 6.6539 | 6.6518 | 6.6518 | 50400.0 |
| 2007-11-05 05:57:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6518 | 6.6518 | 2800.0 |
| 2007-11-05 06:12:00 | AAPL | Stock | 6.645 | 6.645 | 6.6432 | 6.6432 | 28000.0 |
| 2007-11-05 06:34:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5600.0 |
| 2007-11-05 06:37:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2007-11-05 06:38:00 | AAPL | Stock | 6.66 | 6.66 | 6.66 | 6.66 | 5600.0 |
| 2007-11-05 06:42:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 14000.0 |
| 2007-11-05 06:52:00 | AAPL | Stock | 6.6464 | 6.6464 | 6.6429 | 6.6429 | 8400.0 |
| 2007-11-05 06:53:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 2800.0 |
| 2007-11-05 06:56:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 2800.0 |
| 2007-11-05 06:58:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 5600.0 |
| 2007-11-05 06:59:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 5600.0 |
| 2007-11-05 07:02:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 14000.0 |
| 2007-11-05 07:03:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 32900.0 |
| 2007-11-05 07:05:00 | AAPL | Stock | 6.6536 | 6.6536 | 6.6536 | 6.6536 | 8400.0 |
| 2007-11-05 07:06:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6571 | 6.6571 | 11200.0 |
| 2007-11-05 07:07:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6571 | 6.6571 | 28000.0 |
| 2007-11-05 07:11:00 | AAPL | Stock | 6.6604 | 6.6604 | 6.6604 | 6.6604 | 8400.0 |
| 2007-11-05 07:17:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 28000.0 |
| 2007-11-05 07:19:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2007-11-05 07:20:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5600.0 |
| 2007-11-05 07:21:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 72800.0 |
| 2007-11-05 07:22:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 56000.0 |
| 2007-11-05 07:24:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6732 | 6.6732 | 2800.0 |
| 2007-11-05 07:25:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6732 | 6.6732 | 2800.0 |
| 2007-11-05 07:27:00 | AAPL | Stock | 6.6679 | 6.6679 | 6.6679 | 6.6679 | 8400.0 |
| 2007-11-05 07:29:00 | AAPL | Stock | 6.6729 | 6.6729 | 6.6729 | 6.6729 | 2800.0 |
| 2007-11-05 07:32:00 | AAPL | Stock | 6.6696 | 6.6696 | 6.6696 | 6.6696 | 28000.0 |
| 2007-11-05 07:33:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 2800.0 |
| 2007-11-05 07:34:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 28000.0 |
| 2007-11-05 07:35:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 28000.0 |
| 2007-11-05 07:48:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 5600.0 |
| 2007-11-05 07:50:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6571 | 6.6571 | 2800.0 |
| 2007-11-05 07:53:00 | AAPL | Stock | 6.6679 | 6.6679 | 6.6679 | 6.6679 | 2800.0 |
| 2007-11-05 07:55:00 | AAPL | Stock | 6.6589 | 6.6589 | 6.6589 | 6.6589 | 11200.0 |
| 2007-11-05 07:58:00 | AAPL | Stock | 6.6582 | 6.6582 | 6.6554 | 6.6554 | 8400.0 |
| 2007-11-05 07:59:00 | AAPL | Stock | 6.6525 | 6.6525 | 6.6525 | 6.6525 | 25200.0 |
| 2007-11-05 08:00:00 | AAPL | Stock | 6.6554 | 6.7096 | 6.6429 | 6.6439 | 1296596.0 |
| 2007-11-05 08:01:00 | AAPL | Stock | 6.6439 | 6.65 | 6.6429 | 6.6429 | 161616.0 |
| 2007-11-05 08:02:00 | AAPL | Stock | 6.6429 | 6.6432 | 6.6429 | 6.6432 | 43204.0 |
| 2007-11-05 08:03:00 | AAPL | Stock | 6.6429 | 6.6464 | 6.6321 | 6.6429 | 120344.0 |
| 2007-11-05 08:04:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 72688.0 |
| 2007-11-05 08:05:00 | AAPL | Stock | 6.6464 | 6.6518 | 6.6429 | 6.6518 | 108612.0 |
| 2007-11-05 08:06:00 | AAPL | Stock | 6.6489 | 6.6489 | 6.6489 | 6.6489 | 2800.0 |
| 2007-11-05 08:08:00 | AAPL | Stock | 6.6446 | 6.6464 | 6.6439 | 6.6446 | 162400.0 |
| 2007-11-05 08:09:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6396 | 6.6396 | 19600.0 |
| 2007-11-05 08:10:00 | AAPL | Stock | 6.64 | 6.6429 | 6.64 | 6.6429 | 56896.0 |
| 2007-11-05 08:11:00 | AAPL | Stock | 6.6411 | 6.6425 | 6.64 | 6.6411 | 92400.0 |
| 2007-11-05 08:12:00 | AAPL | Stock | 6.64 | 6.6411 | 6.64 | 6.64 | 64484.0 |
> showing 50 of 1,037,044 rows — these rows as CSV