PREVIEW / stock_5min / 2004-08-24
file: by_date/stock_5min/2004/2004-08-24.parquet size: 2.3 MB rows: 172,573 symbols: 1,824
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-24 08:55:00 | AAPL | Stock | 0.555 | 0.555 | 0.555 | 0.555 | 22400.0 |
| 2004-08-24 09:10:00 | AAPL | Stock | 0.5563 | 0.5563 | 0.5563 | 0.5563 | 17360.0 |
| 2004-08-24 09:20:00 | AAPL | Stock | 0.5552 | 0.5552 | 0.5552 | 0.5552 | 5600.0 |
| 2004-08-24 09:25:00 | AAPL | Stock | 0.5555 | 0.5571 | 0.5555 | 0.5571 | 117600.0 |
| 2004-08-24 09:30:00 | AAPL | Stock | 0.5582 | 0.5605 | 0.557 | 0.56 | 5187280.0 |
| 2004-08-24 09:35:00 | AAPL | Stock | 0.5602 | 0.5613 | 0.5575 | 0.5604 | 5966520.0 |
| 2004-08-24 09:40:00 | AAPL | Stock | 0.5604 | 0.5604 | 0.5588 | 0.5598 | 1778000.0 |
| 2004-08-24 09:45:00 | AAPL | Stock | 0.5596 | 0.5598 | 0.5575 | 0.5579 | 3869656.0 |
| 2004-08-24 09:50:00 | AAPL | Stock | 0.5575 | 0.5593 | 0.5571 | 0.5575 | 3058104.0 |
| 2004-08-24 09:55:00 | AAPL | Stock | 0.5575 | 0.5598 | 0.5573 | 0.5586 | 3688496.0 |
| 2004-08-24 10:00:00 | AAPL | Stock | 0.5582 | 0.5602 | 0.5582 | 0.5591 | 4279856.0 |
| 2004-08-24 10:05:00 | AAPL | Stock | 0.5589 | 0.5609 | 0.5588 | 0.5605 | 2922080.0 |
| 2004-08-24 10:10:00 | AAPL | Stock | 0.5607 | 0.5621 | 0.5605 | 0.5609 | 7642544.0 |
| 2004-08-24 10:15:00 | AAPL | Stock | 0.5609 | 0.5618 | 0.5605 | 0.5614 | 4685072.0 |
| 2004-08-24 10:20:00 | AAPL | Stock | 0.5614 | 0.5614 | 0.5607 | 0.5607 | 3415664.0 |
| 2004-08-24 10:25:00 | AAPL | Stock | 0.5609 | 0.5609 | 0.56 | 0.5604 | 11390512.0 |
| 2004-08-24 10:30:00 | AAPL | Stock | 0.5602 | 0.5611 | 0.5588 | 0.5591 | 6877472.0 |
| 2004-08-24 10:35:00 | AAPL | Stock | 0.5591 | 0.56 | 0.5591 | 0.5595 | 2629760.0 |
| 2004-08-24 10:40:00 | AAPL | Stock | 0.5595 | 0.56 | 0.5579 | 0.5586 | 3579800.0 |
| 2004-08-24 10:45:00 | AAPL | Stock | 0.5582 | 0.5591 | 0.5579 | 0.558 | 2733136.0 |
| 2004-08-24 10:50:00 | AAPL | Stock | 0.558 | 0.5598 | 0.5579 | 0.5584 | 3685752.0 |
| 2004-08-24 10:55:00 | AAPL | Stock | 0.5586 | 0.5598 | 0.5584 | 0.5586 | 5395768.0 |
| 2004-08-24 11:00:00 | AAPL | Stock | 0.5586 | 0.5593 | 0.5577 | 0.5577 | 5029584.0 |
| 2004-08-24 11:05:00 | AAPL | Stock | 0.5579 | 0.5589 | 0.5579 | 0.5588 | 3830848.0 |
| 2004-08-24 11:10:00 | AAPL | Stock | 0.5586 | 0.5591 | 0.5579 | 0.5591 | 1930824.0 |
| 2004-08-24 11:15:00 | AAPL | Stock | 0.5589 | 0.5596 | 0.5588 | 0.5588 | 3071768.0 |
| 2004-08-24 11:20:00 | AAPL | Stock | 0.5588 | 0.5589 | 0.5575 | 0.5584 | 4812864.0 |
| 2004-08-24 11:25:00 | AAPL | Stock | 0.5582 | 0.5591 | 0.5582 | 0.5588 | 1970136.0 |
| 2004-08-24 11:30:00 | AAPL | Stock | 0.5586 | 0.5593 | 0.5582 | 0.5591 | 1311464.0 |
| 2004-08-24 11:35:00 | AAPL | Stock | 0.5591 | 0.5595 | 0.5586 | 0.5593 | 1503600.0 |
| 2004-08-24 11:40:00 | AAPL | Stock | 0.5593 | 0.5613 | 0.5592 | 0.5604 | 4404288.0 |
| 2004-08-24 11:45:00 | AAPL | Stock | 0.5604 | 0.561 | 0.5595 | 0.5596 | 2214184.0 |
| 2004-08-24 11:50:00 | AAPL | Stock | 0.5596 | 0.5614 | 0.5596 | 0.5607 | 4599784.0 |
| 2004-08-24 11:55:00 | AAPL | Stock | 0.5607 | 0.5618 | 0.5602 | 0.5613 | 4327456.0 |
| 2004-08-24 12:00:00 | AAPL | Stock | 0.5613 | 0.5614 | 0.5604 | 0.5605 | 6735736.0 |
| 2004-08-24 12:05:00 | AAPL | Stock | 0.5605 | 0.5609 | 0.5602 | 0.5602 | 5543440.0 |
| 2004-08-24 12:10:00 | AAPL | Stock | 0.5604 | 0.562 | 0.5598 | 0.5614 | 4521440.0 |
| 2004-08-24 12:15:00 | AAPL | Stock | 0.5616 | 0.5621 | 0.5609 | 0.5616 | 4676448.0 |
| 2004-08-24 12:20:00 | AAPL | Stock | 0.5614 | 0.562 | 0.5607 | 0.5611 | 5854576.0 |
| 2004-08-24 12:25:00 | AAPL | Stock | 0.5607 | 0.5613 | 0.5607 | 0.5609 | 1805384.0 |
| 2004-08-24 12:30:00 | AAPL | Stock | 0.5609 | 0.5613 | 0.5604 | 0.5609 | 4179784.0 |
| 2004-08-24 12:35:00 | AAPL | Stock | 0.5606 | 0.5613 | 0.5598 | 0.5604 | 4911872.0 |
| 2004-08-24 12:40:00 | AAPL | Stock | 0.5604 | 0.5611 | 0.5598 | 0.5611 | 1373344.0 |
| 2004-08-24 12:45:00 | AAPL | Stock | 0.5611 | 0.5621 | 0.5607 | 0.562 | 5420464.0 |
| 2004-08-24 12:50:00 | AAPL | Stock | 0.5618 | 0.5621 | 0.5614 | 0.5618 | 1354864.0 |
| 2004-08-24 12:55:00 | AAPL | Stock | 0.5618 | 0.562 | 0.5616 | 0.562 | 810824.0 |
| 2004-08-24 13:00:00 | AAPL | Stock | 0.562 | 0.562 | 0.5614 | 0.5618 | 987336.0 |
| 2004-08-24 13:05:00 | AAPL | Stock | 0.5618 | 0.5623 | 0.5616 | 0.5623 | 2109688.0 |
| 2004-08-24 13:10:00 | AAPL | Stock | 0.5623 | 0.5629 | 0.5621 | 0.5629 | 5487160.0 |
| 2004-08-24 13:15:00 | AAPL | Stock | 0.5629 | 0.5666 | 0.5629 | 0.5657 | 14716688.0 |
> showing 50 of 172,573 rows — these rows as CSV