PREVIEW / stock_5min / 2005-02-09
file: by_date/stock_5min/2005/2005-02-09.parquet size: 2.6 MB rows: 191,272 symbols: 1,932
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-02-09 08:00:00 | AAPL | Stock | 1.4464 | 1.4516 | 1.4464 | 1.4482 | 268800.0 |
| 2005-02-09 08:05:00 | AAPL | Stock | 1.4464 | 1.4466 | 1.4455 | 1.4463 | 61600.0 |
| 2005-02-09 08:10:00 | AAPL | Stock | 1.4463 | 1.4463 | 1.4463 | 1.4463 | 56000.0 |
| 2005-02-09 08:15:00 | AAPL | Stock | 1.4464 | 1.4464 | 1.4464 | 1.4464 | 42000.0 |
| 2005-02-09 08:20:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4464 | 1.4482 | 176400.0 |
| 2005-02-09 08:25:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 95200.0 |
| 2005-02-09 08:30:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 5600.0 |
| 2005-02-09 08:35:00 | AAPL | Stock | 1.4482 | 1.4491 | 1.4473 | 1.4491 | 78400.0 |
| 2005-02-09 08:40:00 | AAPL | Stock | 1.4505 | 1.4527 | 1.4505 | 1.4518 | 176400.0 |
| 2005-02-09 08:45:00 | AAPL | Stock | 1.4518 | 1.4545 | 1.4518 | 1.4527 | 182000.0 |
| 2005-02-09 08:50:00 | AAPL | Stock | 1.4525 | 1.4525 | 1.452 | 1.4523 | 146832.0 |
| 2005-02-09 08:55:00 | AAPL | Stock | 1.4525 | 1.4548 | 1.4525 | 1.4536 | 221984.0 |
| 2005-02-09 09:00:00 | AAPL | Stock | 1.4548 | 1.4554 | 1.4527 | 1.4527 | 498400.0 |
| 2005-02-09 09:05:00 | AAPL | Stock | 1.4527 | 1.4548 | 1.4527 | 1.4536 | 1008000.0 |
| 2005-02-09 09:10:00 | AAPL | Stock | 1.4543 | 1.4554 | 1.4541 | 1.4541 | 576240.0 |
| 2005-02-09 09:15:00 | AAPL | Stock | 1.4539 | 1.4545 | 1.4509 | 1.4509 | 89600.0 |
| 2005-02-09 09:20:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.45 | 1.45 | 372568.0 |
| 2005-02-09 09:25:00 | AAPL | Stock | 1.4464 | 1.4511 | 1.4464 | 1.448 | 1036448.0 |
| 2005-02-09 09:30:00 | AAPL | Stock | 1.4471 | 1.4568 | 1.4439 | 1.452 | 31491208.0 |
| 2005-02-09 09:35:00 | AAPL | Stock | 1.4521 | 1.4589 | 1.4464 | 1.4573 | 25289040.0 |
| 2005-02-09 09:40:00 | AAPL | Stock | 1.457 | 1.4598 | 1.4488 | 1.4529 | 14802256.0 |
| 2005-02-09 09:45:00 | AAPL | Stock | 1.4528 | 1.4543 | 1.45 | 1.4502 | 11378808.0 |
| 2005-02-09 09:50:00 | AAPL | Stock | 1.45 | 1.4536 | 1.4479 | 1.4518 | 14037744.0 |
| 2005-02-09 09:55:00 | AAPL | Stock | 1.4518 | 1.4575 | 1.4509 | 1.4571 | 13851656.0 |
| 2005-02-09 10:00:00 | AAPL | Stock | 1.4573 | 1.462 | 1.4495 | 1.4584 | 22294272.0 |
| 2005-02-09 10:05:00 | AAPL | Stock | 1.4591 | 1.4641 | 1.4582 | 1.4638 | 16131864.0 |
| 2005-02-09 10:10:00 | AAPL | Stock | 1.4639 | 1.4639 | 1.4543 | 1.4559 | 18300240.0 |
| 2005-02-09 10:15:00 | AAPL | Stock | 1.4554 | 1.4579 | 1.4532 | 1.4568 | 16603608.0 |
| 2005-02-09 10:20:00 | AAPL | Stock | 1.4563 | 1.457 | 1.45 | 1.4507 | 17199840.0 |
| 2005-02-09 10:25:00 | AAPL | Stock | 1.4504 | 1.4536 | 1.4488 | 1.4525 | 14357392.0 |
| 2005-02-09 10:30:00 | AAPL | Stock | 1.4523 | 1.4552 | 1.4502 | 1.4504 | 15186360.0 |
| 2005-02-09 10:35:00 | AAPL | Stock | 1.4504 | 1.4545 | 1.4486 | 1.4498 | 17086496.0 |
| 2005-02-09 10:40:00 | AAPL | Stock | 1.45 | 1.4521 | 1.4496 | 1.4502 | 15552992.0 |
| 2005-02-09 10:45:00 | AAPL | Stock | 1.4504 | 1.452 | 1.45 | 1.4516 | 11262664.0 |
| 2005-02-09 10:50:00 | AAPL | Stock | 1.4516 | 1.4523 | 1.4505 | 1.4513 | 13388928.0 |
| 2005-02-09 10:55:00 | AAPL | Stock | 1.4513 | 1.4543 | 1.4505 | 1.4534 | 12170200.0 |
| 2005-02-09 11:00:00 | AAPL | Stock | 1.4532 | 1.4538 | 1.4513 | 1.453 | 6407352.0 |
| 2005-02-09 11:05:00 | AAPL | Stock | 1.4529 | 1.4545 | 1.4527 | 1.4534 | 8640520.0 |
| 2005-02-09 11:10:00 | AAPL | Stock | 1.4534 | 1.4543 | 1.4523 | 1.453 | 4081112.0 |
| 2005-02-09 11:15:00 | AAPL | Stock | 1.453 | 1.4577 | 1.4529 | 1.4559 | 5117168.0 |
| 2005-02-09 11:20:00 | AAPL | Stock | 1.4561 | 1.4598 | 1.4555 | 1.4582 | 12876136.0 |
| 2005-02-09 11:25:00 | AAPL | Stock | 1.4582 | 1.4582 | 1.4523 | 1.4527 | 7910448.0 |
| 2005-02-09 11:30:00 | AAPL | Stock | 1.4527 | 1.4541 | 1.4509 | 1.4532 | 6772976.0 |
| 2005-02-09 11:35:00 | AAPL | Stock | 1.4534 | 1.455 | 1.4529 | 1.4534 | 5355224.0 |
| 2005-02-09 11:40:00 | AAPL | Stock | 1.4532 | 1.4532 | 1.4495 | 1.4507 | 10771096.0 |
| 2005-02-09 11:45:00 | AAPL | Stock | 1.4507 | 1.452 | 1.4498 | 1.4516 | 4357584.0 |
| 2005-02-09 11:50:00 | AAPL | Stock | 1.4514 | 1.4525 | 1.4509 | 1.4513 | 3227336.0 |
| 2005-02-09 11:55:00 | AAPL | Stock | 1.4513 | 1.4525 | 1.4513 | 1.4516 | 3403232.0 |
| 2005-02-09 12:00:00 | AAPL | Stock | 1.452 | 1.4532 | 1.4513 | 1.4527 | 5540752.0 |
| 2005-02-09 12:05:00 | AAPL | Stock | 1.4527 | 1.4529 | 1.4518 | 1.4518 | 1800064.0 |
> showing 50 of 191,272 rows — these rows as CSV