PREVIEW / stock_1min / 2008-06-11
file: by_date/stock_1min/2008/2008-06-11.parquet size: 12.4 MB rows: 1,001,363 symbols: 2,706
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-11 04:16:00 | AAPL | Stock | 6.6239 | 6.6239 | 6.6239 | 6.6239 | 2800.0 |
| 2008-06-11 05:10:00 | AAPL | Stock | 6.6568 | 6.6568 | 6.6568 | 6.6568 | 2800.0 |
| 2008-06-11 06:27:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 8400.0 |
| 2008-06-11 07:00:00 | AAPL | Stock | 6.6618 | 6.6618 | 6.6618 | 6.6618 | 28000.0 |
| 2008-06-11 07:01:00 | AAPL | Stock | 6.6607 | 6.6621 | 6.6607 | 6.6607 | 99400.0 |
| 2008-06-11 07:04:00 | AAPL | Stock | 6.6432 | 6.6432 | 6.6432 | 6.6432 | 2800.0 |
| 2008-06-11 07:05:00 | AAPL | Stock | 6.6432 | 6.6607 | 6.6432 | 6.6607 | 11200.0 |
| 2008-06-11 07:06:00 | AAPL | Stock | 6.66 | 6.66 | 6.66 | 6.66 | 8400.0 |
| 2008-06-11 07:07:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2008-06-11 07:13:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2008-06-11 07:19:00 | AAPL | Stock | 6.65 | 6.65 | 6.65 | 6.65 | 2800.0 |
| 2008-06-11 07:22:00 | AAPL | Stock | 6.66 | 6.6607 | 6.66 | 6.6607 | 11200.0 |
| 2008-06-11 07:23:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 8400.0 |
| 2008-06-11 07:34:00 | AAPL | Stock | 6.6643 | 6.6657 | 6.6643 | 6.6657 | 5600.0 |
| 2008-06-11 07:46:00 | AAPL | Stock | 6.6657 | 6.6657 | 6.6657 | 6.6657 | 5600.0 |
| 2008-06-11 07:47:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6507 | 6.6507 | 9800.0 |
| 2008-06-11 07:50:00 | AAPL | Stock | 6.6536 | 6.6561 | 6.6536 | 6.6561 | 16800.0 |
| 2008-06-11 07:54:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6571 | 6.6571 | 2800.0 |
| 2008-06-11 07:56:00 | AAPL | Stock | 6.6582 | 6.6607 | 6.6582 | 6.6607 | 30800.0 |
| 2008-06-11 07:57:00 | AAPL | Stock | 6.6625 | 6.6643 | 6.6625 | 6.6643 | 8400.0 |
| 2008-06-11 07:58:00 | AAPL | Stock | 6.6654 | 6.6654 | 6.6654 | 6.6654 | 2800.0 |
| 2008-06-11 08:00:00 | AAPL | Stock | 6.6625 | 6.6625 | 6.65 | 6.6554 | 138684.0 |
| 2008-06-11 08:01:00 | AAPL | Stock | 6.6557 | 6.6607 | 6.6557 | 6.6571 | 149520.0 |
| 2008-06-11 08:02:00 | AAPL | Stock | 6.6586 | 6.6661 | 6.6586 | 6.6657 | 241920.0 |
| 2008-06-11 08:03:00 | AAPL | Stock | 6.6646 | 6.6646 | 6.6571 | 6.66 | 162960.0 |
| 2008-06-11 08:04:00 | AAPL | Stock | 6.6596 | 6.6596 | 6.6518 | 6.6518 | 92680.0 |
| 2008-06-11 08:05:00 | AAPL | Stock | 6.6546 | 6.6546 | 6.6518 | 6.6543 | 15120.0 |
| 2008-06-11 08:06:00 | AAPL | Stock | 6.6521 | 6.6521 | 6.6421 | 6.6421 | 362040.0 |
| 2008-06-11 08:07:00 | AAPL | Stock | 6.6364 | 6.6429 | 6.6357 | 6.6425 | 231560.0 |
| 2008-06-11 08:08:00 | AAPL | Stock | 6.6425 | 6.6429 | 6.6321 | 6.6389 | 207200.0 |
| 2008-06-11 08:09:00 | AAPL | Stock | 6.6357 | 6.6407 | 6.6357 | 6.6393 | 61600.0 |
| 2008-06-11 08:10:00 | AAPL | Stock | 6.6393 | 6.6429 | 6.6393 | 6.6411 | 115584.0 |
| 2008-06-11 08:11:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6407 | 6.6425 | 46480.0 |
| 2008-06-11 08:12:00 | AAPL | Stock | 6.6429 | 6.6446 | 6.6407 | 6.6436 | 35000.0 |
| 2008-06-11 08:13:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6357 | 6.6357 | 147700.0 |
| 2008-06-11 08:14:00 | AAPL | Stock | 6.6357 | 6.6357 | 6.6321 | 6.6321 | 49000.0 |
| 2008-06-11 08:15:00 | AAPL | Stock | 6.635 | 6.6361 | 6.6329 | 6.6329 | 36400.0 |
| 2008-06-11 08:17:00 | AAPL | Stock | 6.6332 | 6.6364 | 6.6332 | 6.6364 | 20300.0 |
| 2008-06-11 08:18:00 | AAPL | Stock | 6.6343 | 6.6357 | 6.6343 | 6.6357 | 5600.0 |
| 2008-06-11 08:19:00 | AAPL | Stock | 6.6357 | 6.6382 | 6.6357 | 6.6379 | 14000.0 |
| 2008-06-11 08:20:00 | AAPL | Stock | 6.6361 | 6.6382 | 6.6361 | 6.6361 | 15568.0 |
| 2008-06-11 08:21:00 | AAPL | Stock | 6.6379 | 6.6393 | 6.6364 | 6.6393 | 73304.0 |
| 2008-06-11 08:22:00 | AAPL | Stock | 6.6396 | 6.6407 | 6.6375 | 6.6375 | 22400.0 |
| 2008-06-11 08:23:00 | AAPL | Stock | 6.6364 | 6.6364 | 6.6286 | 6.6286 | 166208.0 |
| 2008-06-11 08:24:00 | AAPL | Stock | 6.6261 | 6.6261 | 6.6179 | 6.6214 | 173460.0 |
| 2008-06-11 08:25:00 | AAPL | Stock | 6.6232 | 6.6264 | 6.6218 | 6.625 | 73920.0 |
| 2008-06-11 08:26:00 | AAPL | Stock | 6.625 | 6.6296 | 6.6246 | 6.6296 | 113792.0 |
| 2008-06-11 08:27:00 | AAPL | Stock | 6.6311 | 6.6311 | 6.6311 | 6.6311 | 2800.0 |
| 2008-06-11 08:28:00 | AAPL | Stock | 6.6311 | 6.6318 | 6.6261 | 6.6311 | 68040.0 |
| 2008-06-11 08:29:00 | AAPL | Stock | 6.6318 | 6.6404 | 6.6318 | 6.6336 | 107436.0 |
> showing 50 of 1,001,363 rows — these rows as CSV