PREVIEW / stock_5min / 2004-08-16
file: by_date/stock_5min/2004/2004-08-16.parquet size: 2.4 MB rows: 174,715 symbols: 1,816
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-16 08:55:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 212800.0 |
| 2004-08-16 09:05:00 | AAPL | Stock | 0.5511 | 0.5511 | 0.5511 | 0.5511 | 11200.0 |
| 2004-08-16 09:20:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 56000.0 |
| 2004-08-16 09:25:00 | AAPL | Stock | 0.5509 | 0.5536 | 0.5509 | 0.5536 | 526400.0 |
| 2004-08-16 09:30:00 | AAPL | Stock | 0.5514 | 0.5536 | 0.5507 | 0.5527 | 3894352.0 |
| 2004-08-16 09:35:00 | AAPL | Stock | 0.5525 | 0.5538 | 0.5511 | 0.5514 | 4718448.0 |
| 2004-08-16 09:40:00 | AAPL | Stock | 0.5511 | 0.5579 | 0.5511 | 0.5571 | 5935496.0 |
| 2004-08-16 09:45:00 | AAPL | Stock | 0.5571 | 0.5604 | 0.557 | 0.5604 | 5352368.0 |
| 2004-08-16 09:50:00 | AAPL | Stock | 0.5604 | 0.5611 | 0.5589 | 0.5599 | 5958848.0 |
| 2004-08-16 09:55:00 | AAPL | Stock | 0.56 | 0.5604 | 0.5584 | 0.5589 | 3320576.0 |
| 2004-08-16 10:00:00 | AAPL | Stock | 0.5589 | 0.5598 | 0.5571 | 0.5595 | 11262664.0 |
| 2004-08-16 10:05:00 | AAPL | Stock | 0.5596 | 0.5616 | 0.5588 | 0.5616 | 4950568.0 |
| 2004-08-16 10:10:00 | AAPL | Stock | 0.5616 | 0.563 | 0.5607 | 0.5629 | 5528376.0 |
| 2004-08-16 10:15:00 | AAPL | Stock | 0.5625 | 0.5664 | 0.5625 | 0.5661 | 9492896.0 |
| 2004-08-16 10:20:00 | AAPL | Stock | 0.5661 | 0.5661 | 0.5641 | 0.5641 | 7334768.0 |
| 2004-08-16 10:25:00 | AAPL | Stock | 0.5643 | 0.5643 | 0.5632 | 0.5634 | 3730216.0 |
| 2004-08-16 10:30:00 | AAPL | Stock | 0.5634 | 0.5652 | 0.563 | 0.5632 | 4063304.0 |
| 2004-08-16 10:35:00 | AAPL | Stock | 0.5634 | 0.5634 | 0.5621 | 0.5621 | 3454696.0 |
| 2004-08-16 10:40:00 | AAPL | Stock | 0.562 | 0.5625 | 0.5607 | 0.562 | 7089712.0 |
| 2004-08-16 10:45:00 | AAPL | Stock | 0.5623 | 0.5625 | 0.5595 | 0.5595 | 3598560.0 |
| 2004-08-16 10:50:00 | AAPL | Stock | 0.5595 | 0.5614 | 0.5595 | 0.56 | 2526608.0 |
| 2004-08-16 10:55:00 | AAPL | Stock | 0.56 | 0.56 | 0.5589 | 0.5593 | 2852472.0 |
| 2004-08-16 11:00:00 | AAPL | Stock | 0.5591 | 0.562 | 0.5591 | 0.5614 | 2097648.0 |
| 2004-08-16 11:05:00 | AAPL | Stock | 0.5613 | 0.5616 | 0.5611 | 0.5616 | 2184896.0 |
| 2004-08-16 11:10:00 | AAPL | Stock | 0.5616 | 0.563 | 0.5611 | 0.563 | 4404288.0 |
| 2004-08-16 11:15:00 | AAPL | Stock | 0.563 | 0.5645 | 0.5625 | 0.5634 | 3566304.0 |
| 2004-08-16 11:20:00 | AAPL | Stock | 0.5634 | 0.5636 | 0.5627 | 0.5627 | 2743944.0 |
| 2004-08-16 11:25:00 | AAPL | Stock | 0.5627 | 0.5634 | 0.5627 | 0.5632 | 1527960.0 |
| 2004-08-16 11:30:00 | AAPL | Stock | 0.5634 | 0.5639 | 0.5632 | 0.5636 | 1617224.0 |
| 2004-08-16 11:35:00 | AAPL | Stock | 0.5639 | 0.5641 | 0.5636 | 0.5638 | 1319248.0 |
| 2004-08-16 11:40:00 | AAPL | Stock | 0.5636 | 0.5636 | 0.563 | 0.5636 | 921984.0 |
| 2004-08-16 11:45:00 | AAPL | Stock | 0.5634 | 0.5643 | 0.5632 | 0.5638 | 2846984.0 |
| 2004-08-16 11:50:00 | AAPL | Stock | 0.5636 | 0.5659 | 0.5634 | 0.5654 | 3707984.0 |
| 2004-08-16 11:55:00 | AAPL | Stock | 0.5643 | 0.5655 | 0.5643 | 0.5648 | 5358248.0 |
| 2004-08-16 12:00:00 | AAPL | Stock | 0.5646 | 0.5652 | 0.5646 | 0.5646 | 1313424.0 |
| 2004-08-16 12:05:00 | AAPL | Stock | 0.5647 | 0.5655 | 0.5646 | 0.5654 | 2626400.0 |
| 2004-08-16 12:10:00 | AAPL | Stock | 0.5652 | 0.5652 | 0.5643 | 0.5643 | 2732408.0 |
| 2004-08-16 12:15:00 | AAPL | Stock | 0.5643 | 0.5646 | 0.5636 | 0.5639 | 4300744.0 |
| 2004-08-16 12:20:00 | AAPL | Stock | 0.5639 | 0.5648 | 0.5639 | 0.5643 | 3326512.0 |
| 2004-08-16 12:25:00 | AAPL | Stock | 0.5639 | 0.5641 | 0.5632 | 0.5632 | 1202208.0 |
| 2004-08-16 12:30:00 | AAPL | Stock | 0.5632 | 0.5636 | 0.5627 | 0.5632 | 2024064.0 |
| 2004-08-16 12:35:00 | AAPL | Stock | 0.563 | 0.5638 | 0.5627 | 0.5629 | 2631608.0 |
| 2004-08-16 12:40:00 | AAPL | Stock | 0.5629 | 0.5632 | 0.5627 | 0.5632 | 2303112.0 |
| 2004-08-16 12:45:00 | AAPL | Stock | 0.5634 | 0.5634 | 0.5625 | 0.5629 | 4861584.0 |
| 2004-08-16 12:50:00 | AAPL | Stock | 0.5627 | 0.563 | 0.5623 | 0.5624 | 2891784.0 |
| 2004-08-16 12:55:00 | AAPL | Stock | 0.5627 | 0.5627 | 0.5621 | 0.5625 | 2319408.0 |
| 2004-08-16 13:00:00 | AAPL | Stock | 0.5625 | 0.5625 | 0.5621 | 0.5623 | 762888.0 |
| 2004-08-16 13:05:00 | AAPL | Stock | 0.5623 | 0.5623 | 0.5621 | 0.5621 | 635600.0 |
| 2004-08-16 13:10:00 | AAPL | Stock | 0.5621 | 0.5627 | 0.562 | 0.562 | 1189944.0 |
| 2004-08-16 13:15:00 | AAPL | Stock | 0.562 | 0.5629 | 0.5618 | 0.5627 | 5280128.0 |
> showing 50 of 174,715 rows — these rows as CSV