PREVIEW / stock_5min / 2005-08-09
file: by_date/stock_5min/2005/2005-08-09.parquet size: 2.7 MB rows: 199,410 symbols: 2,063
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-08-09 08:15:00 | AAPL | Stock | 1.5239 | 1.5239 | 1.5239 | 1.5239 | 2800.0 |
| 2005-08-09 08:20:00 | AAPL | Stock | 1.5239 | 1.5239 | 1.5239 | 1.5239 | 8400.0 |
| 2005-08-09 08:50:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 5264.0 |
| 2005-08-09 09:05:00 | AAPL | Stock | 1.5304 | 1.5354 | 1.5304 | 1.5354 | 40040.0 |
| 2005-08-09 09:15:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5339 | 1.5339 | 11620.0 |
| 2005-08-09 09:25:00 | AAPL | Stock | 1.5321 | 1.5357 | 1.5321 | 1.5346 | 405776.0 |
| 2005-08-09 09:30:00 | AAPL | Stock | 1.5332 | 1.5421 | 1.5325 | 1.5396 | 9391508.0 |
| 2005-08-09 09:35:00 | AAPL | Stock | 1.5397 | 1.5407 | 1.5357 | 1.5386 | 6174000.0 |
| 2005-08-09 09:40:00 | AAPL | Stock | 1.5389 | 1.5418 | 1.5382 | 1.5404 | 4663092.0 |
| 2005-08-09 09:45:00 | AAPL | Stock | 1.5404 | 1.5418 | 1.5382 | 1.5407 | 3669148.0 |
| 2005-08-09 09:50:00 | AAPL | Stock | 1.5411 | 1.5411 | 1.5389 | 1.5407 | 1897308.0 |
| 2005-08-09 09:55:00 | AAPL | Stock | 1.5407 | 1.5411 | 1.5393 | 1.5407 | 2616684.0 |
| 2005-08-09 10:00:00 | AAPL | Stock | 1.5407 | 1.5411 | 1.5393 | 1.5396 | 2541952.0 |
| 2005-08-09 10:05:00 | AAPL | Stock | 1.5396 | 1.5404 | 1.5361 | 1.5375 | 2498916.0 |
| 2005-08-09 10:10:00 | AAPL | Stock | 1.5379 | 1.5411 | 1.5371 | 1.54 | 2971472.0 |
| 2005-08-09 10:15:00 | AAPL | Stock | 1.54 | 1.5411 | 1.5393 | 1.5411 | 2320948.0 |
| 2005-08-09 10:20:00 | AAPL | Stock | 1.5411 | 1.5493 | 1.5404 | 1.5489 | 8597764.0 |
| 2005-08-09 10:25:00 | AAPL | Stock | 1.5489 | 1.5582 | 1.5471 | 1.5557 | 14353332.0 |
| 2005-08-09 10:30:00 | AAPL | Stock | 1.5557 | 1.5593 | 1.5525 | 1.5546 | 8444688.0 |
| 2005-08-09 10:35:00 | AAPL | Stock | 1.5543 | 1.5618 | 1.5489 | 1.5589 | 8614760.0 |
| 2005-08-09 10:40:00 | AAPL | Stock | 1.5589 | 1.5618 | 1.5579 | 1.5582 | 6572692.0 |
| 2005-08-09 10:45:00 | AAPL | Stock | 1.5579 | 1.56 | 1.5571 | 1.5579 | 2888088.0 |
| 2005-08-09 10:50:00 | AAPL | Stock | 1.5575 | 1.5579 | 1.5543 | 1.5543 | 3260824.0 |
| 2005-08-09 10:55:00 | AAPL | Stock | 1.5543 | 1.5561 | 1.5536 | 1.5557 | 2684108.0 |
| 2005-08-09 11:00:00 | AAPL | Stock | 1.5564 | 1.5586 | 1.5546 | 1.5568 | 4041184.0 |
| 2005-08-09 11:05:00 | AAPL | Stock | 1.5564 | 1.5567 | 1.5536 | 1.5536 | 2517872.0 |
| 2005-08-09 11:10:00 | AAPL | Stock | 1.5543 | 1.5546 | 1.5525 | 1.5532 | 1871100.0 |
| 2005-08-09 11:15:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5529 | 1.5532 | 1889468.0 |
| 2005-08-09 11:20:00 | AAPL | Stock | 1.5536 | 1.555 | 1.5532 | 1.5532 | 3372880.0 |
| 2005-08-09 11:25:00 | AAPL | Stock | 1.5532 | 1.5564 | 1.5532 | 1.555 | 5280968.0 |
| 2005-08-09 11:30:00 | AAPL | Stock | 1.5554 | 1.5557 | 1.5525 | 1.5557 | 4397988.0 |
| 2005-08-09 11:35:00 | AAPL | Stock | 1.5554 | 1.5557 | 1.5532 | 1.5536 | 3321724.0 |
| 2005-08-09 11:40:00 | AAPL | Stock | 1.5539 | 1.5571 | 1.5536 | 1.555 | 10579324.0 |
| 2005-08-09 11:45:00 | AAPL | Stock | 1.5554 | 1.5571 | 1.5543 | 1.5571 | 4674516.0 |
| 2005-08-09 11:50:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.5568 | 1.5582 | 3470768.0 |
| 2005-08-09 11:55:00 | AAPL | Stock | 1.5582 | 1.5629 | 1.5579 | 1.5625 | 5946248.0 |
| 2005-08-09 12:00:00 | AAPL | Stock | 1.5625 | 1.5625 | 1.5607 | 1.5607 | 3625216.0 |
| 2005-08-09 12:05:00 | AAPL | Stock | 1.5611 | 1.5639 | 1.5607 | 1.5632 | 11285932.0 |
| 2005-08-09 12:10:00 | AAPL | Stock | 1.5629 | 1.5632 | 1.56 | 1.5604 | 2717148.0 |
| 2005-08-09 12:15:00 | AAPL | Stock | 1.56 | 1.5614 | 1.5536 | 1.5604 | 4037684.0 |
| 2005-08-09 12:20:00 | AAPL | Stock | 1.5604 | 1.5607 | 1.5589 | 1.5596 | 3030608.0 |
| 2005-08-09 12:25:00 | AAPL | Stock | 1.5593 | 1.5611 | 1.5593 | 1.5611 | 2321284.0 |
| 2005-08-09 12:30:00 | AAPL | Stock | 1.5611 | 1.5621 | 1.5596 | 1.5607 | 2158100.0 |
| 2005-08-09 12:35:00 | AAPL | Stock | 1.5607 | 1.5611 | 1.5604 | 1.5604 | 1195264.0 |
| 2005-08-09 12:40:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.56 | 1.5604 | 2510368.0 |
| 2005-08-09 12:45:00 | AAPL | Stock | 1.5607 | 1.5611 | 1.5604 | 1.5604 | 1485988.0 |
| 2005-08-09 12:50:00 | AAPL | Stock | 1.5604 | 1.5611 | 1.56 | 1.5607 | 2312632.0 |
| 2005-08-09 12:55:00 | AAPL | Stock | 1.5611 | 1.5621 | 1.5604 | 1.5618 | 4369540.0 |
| 2005-08-09 13:00:00 | AAPL | Stock | 1.5618 | 1.5621 | 1.5604 | 1.5604 | 1205652.0 |
| 2005-08-09 13:05:00 | AAPL | Stock | 1.5604 | 1.5611 | 1.56 | 1.5607 | 1735216.0 |
> showing 50 of 199,410 rows — these rows as CSV