PREVIEW / stock_1min / 2005-09-22
file: by_date/stock_1min/2005/2005-09-22.parquet size: 7.5 MB rows: 608,034 symbols: 1,701
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-09-22 08:00:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 2800.0 |
| 2005-09-22 08:01:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 5600.0 |
| 2005-09-22 08:02:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 16800.0 |
| 2005-09-22 08:04:00 | AAPL | Stock | 1.8536 | 1.8536 | 1.8536 | 1.8536 | 5600.0 |
| 2005-09-22 08:05:00 | AAPL | Stock | 1.8532 | 1.8532 | 1.8532 | 1.8532 | 22400.0 |
| 2005-09-22 08:07:00 | AAPL | Stock | 1.8525 | 1.8525 | 1.8525 | 1.8525 | 2800.0 |
| 2005-09-22 08:08:00 | AAPL | Stock | 1.8525 | 1.8525 | 1.8443 | 1.85 | 131600.0 |
| 2005-09-22 08:09:00 | AAPL | Stock | 1.8482 | 1.8482 | 1.8482 | 1.8482 | 16800.0 |
| 2005-09-22 08:10:00 | AAPL | Stock | 1.8475 | 1.8475 | 1.8475 | 1.8475 | 28000.0 |
| 2005-09-22 08:11:00 | AAPL | Stock | 1.8471 | 1.8471 | 1.8471 | 1.8471 | 2800.0 |
| 2005-09-22 08:13:00 | AAPL | Stock | 1.8471 | 1.8525 | 1.8471 | 1.8525 | 18480.0 |
| 2005-09-22 08:18:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 30800.0 |
| 2005-09-22 08:22:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 12600.0 |
| 2005-09-22 08:26:00 | AAPL | Stock | 1.8511 | 1.8511 | 1.8511 | 1.8511 | 4200.0 |
| 2005-09-22 08:27:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 30800.0 |
| 2005-09-22 08:28:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 2800.0 |
| 2005-09-22 08:35:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 15400.0 |
| 2005-09-22 08:39:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 14000.0 |
| 2005-09-22 08:42:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 21000.0 |
| 2005-09-22 08:44:00 | AAPL | Stock | 1.8518 | 1.8571 | 1.8518 | 1.8571 | 76720.0 |
| 2005-09-22 08:50:00 | AAPL | Stock | 1.8536 | 1.8536 | 1.8536 | 1.8536 | 5600.0 |
| 2005-09-22 08:54:00 | AAPL | Stock | 1.8604 | 1.8604 | 1.8604 | 1.8604 | 28000.0 |
| 2005-09-22 08:55:00 | AAPL | Stock | 1.8604 | 1.8604 | 1.8604 | 1.8604 | 16800.0 |
| 2005-09-22 09:00:00 | AAPL | Stock | 1.8539 | 1.8539 | 1.8539 | 1.8539 | 6580.0 |
| 2005-09-22 09:02:00 | AAPL | Stock | 1.8539 | 1.8539 | 1.8539 | 1.8539 | 11200.0 |
| 2005-09-22 09:09:00 | AAPL | Stock | 1.8589 | 1.8589 | 1.8589 | 1.8589 | 14000.0 |
| 2005-09-22 09:11:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 20664.0 |
| 2005-09-22 09:12:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 7336.0 |
| 2005-09-22 09:15:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 2800.0 |
| 2005-09-22 09:17:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 5600.0 |
| 2005-09-22 09:22:00 | AAPL | Stock | 1.8554 | 1.8554 | 1.8554 | 1.8554 | 16800.0 |
| 2005-09-22 09:25:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8554 | 1.8554 | 16492.0 |
| 2005-09-22 09:26:00 | AAPL | Stock | 1.8557 | 1.8557 | 1.855 | 1.855 | 28000.0 |
| 2005-09-22 09:27:00 | AAPL | Stock | 1.855 | 1.855 | 1.855 | 1.855 | 1400000.0 |
| 2005-09-22 09:28:00 | AAPL | Stock | 1.8521 | 1.8521 | 1.8521 | 1.8521 | 2800.0 |
| 2005-09-22 09:29:00 | AAPL | Stock | 1.8536 | 1.8568 | 1.8529 | 1.8546 | 341600.0 |
| 2005-09-22 09:30:00 | AAPL | Stock | 1.8529 | 1.8571 | 1.8518 | 1.8529 | 5029808.0 |
| 2005-09-22 09:31:00 | AAPL | Stock | 1.8525 | 1.8554 | 1.85 | 1.8507 | 2168264.0 |
| 2005-09-22 09:32:00 | AAPL | Stock | 1.8504 | 1.8529 | 1.8504 | 1.8529 | 2380448.0 |
| 2005-09-22 09:33:00 | AAPL | Stock | 1.8529 | 1.8529 | 1.8514 | 1.8521 | 2037420.0 |
| 2005-09-22 09:34:00 | AAPL | Stock | 1.8525 | 1.8546 | 1.8521 | 1.8546 | 2650368.0 |
| 2005-09-22 09:35:00 | AAPL | Stock | 1.8539 | 1.8561 | 1.8532 | 1.8546 | 1847048.0 |
| 2005-09-22 09:36:00 | AAPL | Stock | 1.8546 | 1.8554 | 1.8511 | 1.8511 | 1935360.0 |
| 2005-09-22 09:37:00 | AAPL | Stock | 1.8511 | 1.8521 | 1.8511 | 1.8518 | 987504.0 |
| 2005-09-22 09:38:00 | AAPL | Stock | 1.8514 | 1.8521 | 1.8511 | 1.8518 | 1244348.0 |
| 2005-09-22 09:39:00 | AAPL | Stock | 1.8521 | 1.8546 | 1.8514 | 1.8532 | 2257416.0 |
| 2005-09-22 09:40:00 | AAPL | Stock | 1.8532 | 1.8536 | 1.8518 | 1.8525 | 1594656.0 |
| 2005-09-22 09:41:00 | AAPL | Stock | 1.8525 | 1.8525 | 1.8471 | 1.8475 | 3418772.0 |
| 2005-09-22 09:42:00 | AAPL | Stock | 1.8475 | 1.85 | 1.8446 | 1.8461 | 4774168.0 |
| 2005-09-22 09:43:00 | AAPL | Stock | 1.8461 | 1.8461 | 1.8361 | 1.8382 | 5966856.0 |
> showing 50 of 608,034 rows — these rows as CSV