PREVIEW / stock_5min / 2005-04-04
file: by_date/stock_5min/2005/2005-04-04.parquet size: 2.7 MB rows: 196,678 symbols: 1,957
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-04-04 08:00:00 | AAPL | Stock | 1.4607 | 1.4607 | 1.4536 | 1.4604 | 190456.0 |
| 2005-04-04 08:05:00 | AAPL | Stock | 1.4536 | 1.4536 | 1.4536 | 1.4536 | 28000.0 |
| 2005-04-04 08:10:00 | AAPL | Stock | 1.4464 | 1.4479 | 1.4457 | 1.4457 | 64400.0 |
| 2005-04-04 08:15:00 | AAPL | Stock | 1.4464 | 1.4496 | 1.4129 | 1.4446 | 473480.0 |
| 2005-04-04 08:20:00 | AAPL | Stock | 1.4464 | 1.4496 | 1.4464 | 1.4464 | 57400.0 |
| 2005-04-04 08:25:00 | AAPL | Stock | 1.4464 | 1.4475 | 1.4457 | 1.4464 | 263200.0 |
| 2005-04-04 08:30:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4464 | 1.4464 | 39200.0 |
| 2005-04-04 08:35:00 | AAPL | Stock | 1.4461 | 1.4493 | 1.4461 | 1.4493 | 105000.0 |
| 2005-04-04 08:40:00 | AAPL | Stock | 1.4493 | 1.4493 | 1.4493 | 1.4493 | 5600.0 |
| 2005-04-04 08:45:00 | AAPL | Stock | 1.4493 | 1.45 | 1.4461 | 1.45 | 506800.0 |
| 2005-04-04 08:50:00 | AAPL | Stock | 1.45 | 1.4604 | 1.4496 | 1.4589 | 258608.0 |
| 2005-04-04 08:55:00 | AAPL | Stock | 1.4589 | 1.4604 | 1.4571 | 1.4593 | 418208.0 |
| 2005-04-04 09:00:00 | AAPL | Stock | 1.4589 | 1.4589 | 1.4571 | 1.4571 | 72800.0 |
| 2005-04-04 09:05:00 | AAPL | Stock | 1.4546 | 1.4557 | 1.4529 | 1.4536 | 78400.0 |
| 2005-04-04 09:10:00 | AAPL | Stock | 1.4536 | 1.4546 | 1.4496 | 1.4525 | 145600.0 |
| 2005-04-04 09:15:00 | AAPL | Stock | 1.4532 | 1.4536 | 1.4496 | 1.4536 | 106400.0 |
| 2005-04-04 09:20:00 | AAPL | Stock | 1.4586 | 1.4589 | 1.4582 | 1.4586 | 67200.0 |
| 2005-04-04 09:25:00 | AAPL | Stock | 1.4543 | 1.4643 | 1.4543 | 1.4639 | 654108.0 |
| 2005-04-04 09:30:00 | AAPL | Stock | 1.4639 | 1.4654 | 1.4368 | 1.4379 | 26525072.0 |
| 2005-04-04 09:35:00 | AAPL | Stock | 1.4382 | 1.4571 | 1.4343 | 1.4571 | 24181444.0 |
| 2005-04-04 09:40:00 | AAPL | Stock | 1.4571 | 1.46 | 1.4479 | 1.4571 | 15275092.0 |
| 2005-04-04 09:45:00 | AAPL | Stock | 1.4568 | 1.4689 | 1.4554 | 1.4604 | 20276452.0 |
| 2005-04-04 09:50:00 | AAPL | Stock | 1.46 | 1.475 | 1.4571 | 1.4682 | 24002664.0 |
| 2005-04-04 09:55:00 | AAPL | Stock | 1.4686 | 1.4693 | 1.4589 | 1.4589 | 11193588.0 |
| 2005-04-04 10:00:00 | AAPL | Stock | 1.4586 | 1.4614 | 1.455 | 1.4593 | 8582812.0 |
| 2005-04-04 10:05:00 | AAPL | Stock | 1.4614 | 1.4636 | 1.4511 | 1.4532 | 11677400.0 |
| 2005-04-04 10:10:00 | AAPL | Stock | 1.4532 | 1.4564 | 1.4489 | 1.4518 | 13899648.0 |
| 2005-04-04 10:15:00 | AAPL | Stock | 1.4518 | 1.4543 | 1.4496 | 1.4529 | 7808052.0 |
| 2005-04-04 10:20:00 | AAPL | Stock | 1.4525 | 1.4529 | 1.4482 | 1.4493 | 7343308.0 |
| 2005-04-04 10:25:00 | AAPL | Stock | 1.45 | 1.4539 | 1.4493 | 1.4532 | 5095776.0 |
| 2005-04-04 10:30:00 | AAPL | Stock | 1.4529 | 1.4611 | 1.4518 | 1.4596 | 8558732.0 |
| 2005-04-04 10:35:00 | AAPL | Stock | 1.4596 | 1.4664 | 1.4589 | 1.4625 | 12199124.0 |
| 2005-04-04 10:40:00 | AAPL | Stock | 1.4629 | 1.4643 | 1.4596 | 1.4621 | 7205492.0 |
| 2005-04-04 10:45:00 | AAPL | Stock | 1.4621 | 1.4632 | 1.4589 | 1.4596 | 7405356.0 |
| 2005-04-04 10:50:00 | AAPL | Stock | 1.4596 | 1.4611 | 1.4529 | 1.4589 | 10624068.0 |
| 2005-04-04 10:55:00 | AAPL | Stock | 1.4586 | 1.4607 | 1.4568 | 1.4607 | 4824652.0 |
| 2005-04-04 11:00:00 | AAPL | Stock | 1.4604 | 1.465 | 1.46 | 1.4614 | 9329656.0 |
| 2005-04-04 11:05:00 | AAPL | Stock | 1.4614 | 1.4639 | 1.4582 | 1.4607 | 8132376.0 |
| 2005-04-04 11:10:00 | AAPL | Stock | 1.4607 | 1.4607 | 1.4532 | 1.4557 | 10552528.0 |
| 2005-04-04 11:15:00 | AAPL | Stock | 1.4561 | 1.4568 | 1.4504 | 1.4518 | 8117200.0 |
| 2005-04-04 11:20:00 | AAPL | Stock | 1.4543 | 1.4543 | 1.45 | 1.4529 | 10981936.0 |
| 2005-04-04 11:25:00 | AAPL | Stock | 1.4529 | 1.4532 | 1.4504 | 1.4518 | 4654468.0 |
| 2005-04-04 11:30:00 | AAPL | Stock | 1.4514 | 1.4525 | 1.4432 | 1.4482 | 8756552.0 |
| 2005-04-04 11:35:00 | AAPL | Stock | 1.4479 | 1.4525 | 1.4464 | 1.4518 | 8855700.0 |
| 2005-04-04 11:40:00 | AAPL | Stock | 1.4514 | 1.4543 | 1.4496 | 1.4514 | 7235592.0 |
| 2005-04-04 11:45:00 | AAPL | Stock | 1.4514 | 1.455 | 1.4511 | 1.4521 | 3353784.0 |
| 2005-04-04 11:50:00 | AAPL | Stock | 1.4525 | 1.4571 | 1.4525 | 1.4546 | 4470844.0 |
| 2005-04-04 11:55:00 | AAPL | Stock | 1.4546 | 1.4554 | 1.4525 | 1.4543 | 2433396.0 |
| 2005-04-04 12:00:00 | AAPL | Stock | 1.4536 | 1.4543 | 1.4532 | 1.4539 | 2898756.0 |
| 2005-04-04 12:05:00 | AAPL | Stock | 1.4539 | 1.4568 | 1.4529 | 1.4536 | 9897496.0 |
> showing 50 of 196,678 rows — these rows as CSV