PREVIEW / stock_5min / 2005-08-11
file: by_date/stock_5min/2005/2005-08-11.parquet size: 2.7 MB rows: 198,612 symbols: 2,054
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-11 08:00:00 | AAPL | Stock | 1.5536 | 1.5571 | 1.5493 | 1.5568 | 133560.0 |
| 2005-08-11 08:10:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 28000.0 |
| 2005-08-11 08:15:00 | AAPL | Stock | 1.5546 | 1.5546 | 1.5546 | 1.5546 | 14000.0 |
| 2005-08-11 08:20:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 3248.0 |
| 2005-08-11 08:25:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 16800.0 |
| 2005-08-11 08:35:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 2800.0 |
| 2005-08-11 08:40:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.55 | 1.55 | 41552.0 |
| 2005-08-11 08:45:00 | AAPL | Stock | 1.5493 | 1.5496 | 1.5493 | 1.5496 | 22400.0 |
| 2005-08-11 08:50:00 | AAPL | Stock | 1.5493 | 1.55 | 1.5493 | 1.55 | 14252.0 |
| 2005-08-11 09:00:00 | AAPL | Stock | 1.5493 | 1.5493 | 1.5454 | 1.5454 | 82712.0 |
| 2005-08-11 09:05:00 | AAPL | Stock | 1.5464 | 1.5464 | 1.5461 | 1.5461 | 19600.0 |
| 2005-08-11 09:10:00 | AAPL | Stock | 1.5461 | 1.5468 | 1.5461 | 1.5468 | 62524.0 |
| 2005-08-11 09:15:00 | AAPL | Stock | 1.5464 | 1.5464 | 1.5457 | 1.5457 | 39200.0 |
| 2005-08-11 09:20:00 | AAPL | Stock | 1.5471 | 1.5471 | 1.5471 | 1.5471 | 2800.0 |
| 2005-08-11 09:25:00 | AAPL | Stock | 1.5475 | 1.55 | 1.5457 | 1.5457 | 512344.0 |
| 2005-08-11 09:30:00 | AAPL | Stock | 1.5496 | 1.55 | 1.5446 | 1.5493 | 6979364.0 |
| 2005-08-11 09:35:00 | AAPL | Stock | 1.5493 | 1.5543 | 1.5482 | 1.5539 | 6958952.0 |
| 2005-08-11 09:40:00 | AAPL | Stock | 1.5539 | 1.5582 | 1.5529 | 1.5582 | 5306448.0 |
| 2005-08-11 09:45:00 | AAPL | Stock | 1.5579 | 1.5586 | 1.5525 | 1.5525 | 4000612.0 |
| 2005-08-11 09:50:00 | AAPL | Stock | 1.5529 | 1.5568 | 1.5525 | 1.5546 | 3666628.0 |
| 2005-08-11 09:55:00 | AAPL | Stock | 1.5546 | 1.5554 | 1.5507 | 1.555 | 3673600.0 |
| 2005-08-11 10:00:00 | AAPL | Stock | 1.5554 | 1.5596 | 1.555 | 1.5582 | 3947636.0 |
| 2005-08-11 10:05:00 | AAPL | Stock | 1.5582 | 1.5625 | 1.5546 | 1.5614 | 4630584.0 |
| 2005-08-11 10:10:00 | AAPL | Stock | 1.5618 | 1.565 | 1.5611 | 1.5646 | 4112528.0 |
| 2005-08-11 10:15:00 | AAPL | Stock | 1.5646 | 1.5664 | 1.5614 | 1.5646 | 4974480.0 |
| 2005-08-11 10:20:00 | AAPL | Stock | 1.5646 | 1.5711 | 1.5632 | 1.57 | 6632780.0 |
| 2005-08-11 10:25:00 | AAPL | Stock | 1.57 | 1.5721 | 1.5679 | 1.5685 | 9641492.0 |
| 2005-08-11 10:30:00 | AAPL | Stock | 1.5682 | 1.5707 | 1.5654 | 1.5707 | 4190340.0 |
| 2005-08-11 10:35:00 | AAPL | Stock | 1.5707 | 1.5711 | 1.5679 | 1.5704 | 2870644.0 |
| 2005-08-11 10:40:00 | AAPL | Stock | 1.5704 | 1.5707 | 1.5668 | 1.5675 | 3165736.0 |
| 2005-08-11 10:45:00 | AAPL | Stock | 1.5671 | 1.5693 | 1.5661 | 1.5689 | 2105264.0 |
| 2005-08-11 10:50:00 | AAPL | Stock | 1.5689 | 1.5714 | 1.5679 | 1.5696 | 3792012.0 |
| 2005-08-11 10:55:00 | AAPL | Stock | 1.5696 | 1.5704 | 1.5668 | 1.5675 | 2734676.0 |
| 2005-08-11 11:00:00 | AAPL | Stock | 1.5675 | 1.5704 | 1.5671 | 1.5696 | 3875704.0 |
| 2005-08-11 11:05:00 | AAPL | Stock | 1.5696 | 1.5696 | 1.5661 | 1.5668 | 2180668.0 |
| 2005-08-11 11:10:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5636 | 1.5654 | 3370136.0 |
| 2005-08-11 11:15:00 | AAPL | Stock | 1.5654 | 1.5664 | 1.5636 | 1.5654 | 1590008.0 |
| 2005-08-11 11:20:00 | AAPL | Stock | 1.5654 | 1.5654 | 1.5643 | 1.5646 | 1572732.0 |
| 2005-08-11 11:25:00 | AAPL | Stock | 1.5646 | 1.565 | 1.5629 | 1.5643 | 1698564.0 |
| 2005-08-11 11:30:00 | AAPL | Stock | 1.5639 | 1.5643 | 1.5607 | 1.5614 | 2632840.0 |
| 2005-08-11 11:35:00 | AAPL | Stock | 1.5618 | 1.5632 | 1.5611 | 1.5632 | 2648464.0 |
| 2005-08-11 11:40:00 | AAPL | Stock | 1.5632 | 1.5664 | 1.5632 | 1.5661 | 2422728.0 |
| 2005-08-11 11:45:00 | AAPL | Stock | 1.5664 | 1.5675 | 1.5661 | 1.5671 | 1870876.0 |
| 2005-08-11 11:50:00 | AAPL | Stock | 1.5671 | 1.5686 | 1.5661 | 1.5682 | 3865372.0 |
| 2005-08-11 11:55:00 | AAPL | Stock | 1.5682 | 1.5682 | 1.5675 | 1.5679 | 1461208.0 |
| 2005-08-11 12:00:00 | AAPL | Stock | 1.5675 | 1.5679 | 1.5661 | 1.5671 | 2789500.0 |
| 2005-08-11 12:05:00 | AAPL | Stock | 1.5675 | 1.5679 | 1.5661 | 1.5661 | 968772.0 |
| 2005-08-11 12:10:00 | AAPL | Stock | 1.5661 | 1.5668 | 1.5643 | 1.5657 | 3132892.0 |
| 2005-08-11 12:15:00 | AAPL | Stock | 1.5657 | 1.5661 | 1.5621 | 1.5629 | 3355716.0 |
| 2005-08-11 12:20:00 | AAPL | Stock | 1.5629 | 1.5643 | 1.5618 | 1.5629 | 4115832.0 |
> showing 50 of 198,612 rows — these rows as CSV