PREVIEW / stock_5min / 2004-03-09
file: by_date/stock_5min/2004/2004-03-09.parquet size: 2.3 MB rows: 166,299 symbols: 1,731
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-03-09 08:00:00 | AAPL | Stock | 0.4661 | 0.4661 | 0.4661 | 0.4661 | 11200.0 |
| 2004-03-09 08:55:00 | AAPL | Stock | 0.4645 | 0.4645 | 0.4625 | 0.4625 | 705880.0 |
| 2004-03-09 09:00:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 56000.0 |
| 2004-03-09 09:10:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 56000.0 |
| 2004-03-09 09:15:00 | AAPL | Stock | 0.4625 | 0.463 | 0.4625 | 0.463 | 116200.0 |
| 2004-03-09 09:20:00 | AAPL | Stock | 0.463 | 0.463 | 0.463 | 0.463 | 21000.0 |
| 2004-03-09 09:25:00 | AAPL | Stock | 0.463 | 0.4657 | 0.4627 | 0.4634 | 426552.0 |
| 2004-03-09 09:30:00 | AAPL | Stock | 0.4625 | 0.4643 | 0.4607 | 0.4609 | 6035288.0 |
| 2004-03-09 09:35:00 | AAPL | Stock | 0.4607 | 0.462 | 0.4604 | 0.4605 | 3049984.0 |
| 2004-03-09 09:40:00 | AAPL | Stock | 0.4609 | 0.4668 | 0.4598 | 0.4668 | 3971408.0 |
| 2004-03-09 09:45:00 | AAPL | Stock | 0.4664 | 0.4732 | 0.4655 | 0.4732 | 10926384.0 |
| 2004-03-09 09:50:00 | AAPL | Stock | 0.4732 | 0.4732 | 0.4684 | 0.4684 | 4826808.0 |
| 2004-03-09 09:55:00 | AAPL | Stock | 0.4684 | 0.4729 | 0.4682 | 0.4729 | 3538360.0 |
| 2004-03-09 10:00:00 | AAPL | Stock | 0.4729 | 0.473 | 0.4702 | 0.4707 | 3988152.0 |
| 2004-03-09 10:05:00 | AAPL | Stock | 0.4707 | 0.472 | 0.4705 | 0.4705 | 2446696.0 |
| 2004-03-09 10:10:00 | AAPL | Stock | 0.4705 | 0.4707 | 0.4702 | 0.4702 | 1652616.0 |
| 2004-03-09 10:15:00 | AAPL | Stock | 0.4705 | 0.4705 | 0.4646 | 0.4657 | 3832696.0 |
| 2004-03-09 10:20:00 | AAPL | Stock | 0.4659 | 0.4711 | 0.4659 | 0.4711 | 6345528.0 |
| 2004-03-09 10:25:00 | AAPL | Stock | 0.4711 | 0.4711 | 0.4682 | 0.47 | 2663416.0 |
| 2004-03-09 10:30:00 | AAPL | Stock | 0.47 | 0.4702 | 0.4668 | 0.4673 | 3738336.0 |
| 2004-03-09 10:35:00 | AAPL | Stock | 0.4677 | 0.4686 | 0.4673 | 0.4675 | 6959008.0 |
| 2004-03-09 10:40:00 | AAPL | Stock | 0.4675 | 0.4698 | 0.4675 | 0.4696 | 6287848.0 |
| 2004-03-09 10:45:00 | AAPL | Stock | 0.4696 | 0.4714 | 0.4695 | 0.47 | 3085320.0 |
| 2004-03-09 10:50:00 | AAPL | Stock | 0.4704 | 0.4705 | 0.4696 | 0.4704 | 4947544.0 |
| 2004-03-09 10:55:00 | AAPL | Stock | 0.4702 | 0.473 | 0.47 | 0.4729 | 4675328.0 |
| 2004-03-09 11:00:00 | AAPL | Stock | 0.4729 | 0.4764 | 0.4725 | 0.4755 | 7190456.0 |
| 2004-03-09 11:05:00 | AAPL | Stock | 0.4757 | 0.4757 | 0.4741 | 0.4743 | 3732568.0 |
| 2004-03-09 11:10:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4738 | 0.4743 | 2284520.0 |
| 2004-03-09 11:15:00 | AAPL | Stock | 0.4739 | 0.475 | 0.4736 | 0.4741 | 4450040.0 |
| 2004-03-09 11:20:00 | AAPL | Stock | 0.4743 | 0.4746 | 0.4741 | 0.4746 | 3722656.0 |
| 2004-03-09 11:25:00 | AAPL | Stock | 0.4745 | 0.4748 | 0.4741 | 0.4746 | 1995672.0 |
| 2004-03-09 11:30:00 | AAPL | Stock | 0.4746 | 0.4768 | 0.4745 | 0.4764 | 5685680.0 |
| 2004-03-09 11:35:00 | AAPL | Stock | 0.4764 | 0.4768 | 0.475 | 0.4752 | 7294112.0 |
| 2004-03-09 11:40:00 | AAPL | Stock | 0.4754 | 0.4757 | 0.4743 | 0.4748 | 3461584.0 |
| 2004-03-09 11:45:00 | AAPL | Stock | 0.4746 | 0.475 | 0.4741 | 0.4741 | 3339840.0 |
| 2004-03-09 11:50:00 | AAPL | Stock | 0.4743 | 0.4746 | 0.4729 | 0.473 | 4691344.0 |
| 2004-03-09 11:55:00 | AAPL | Stock | 0.4732 | 0.4734 | 0.4716 | 0.472 | 3137232.0 |
| 2004-03-09 12:00:00 | AAPL | Stock | 0.472 | 0.4736 | 0.4714 | 0.4723 | 7022960.0 |
| 2004-03-09 12:05:00 | AAPL | Stock | 0.4729 | 0.4732 | 0.4723 | 0.4727 | 2353792.0 |
| 2004-03-09 12:10:00 | AAPL | Stock | 0.4725 | 0.4739 | 0.4725 | 0.4736 | 3445400.0 |
| 2004-03-09 12:15:00 | AAPL | Stock | 0.4734 | 0.4738 | 0.4732 | 0.4734 | 3915352.0 |
| 2004-03-09 12:20:00 | AAPL | Stock | 0.4734 | 0.4741 | 0.4732 | 0.4734 | 5030872.0 |
| 2004-03-09 12:25:00 | AAPL | Stock | 0.4736 | 0.4739 | 0.4721 | 0.4739 | 4603368.0 |
| 2004-03-09 12:30:00 | AAPL | Stock | 0.4741 | 0.475 | 0.4732 | 0.4743 | 6097616.0 |
| 2004-03-09 12:35:00 | AAPL | Stock | 0.4741 | 0.4752 | 0.4741 | 0.4746 | 4649456.0 |
| 2004-03-09 12:40:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4741 | 0.4743 | 2058784.0 |
| 2004-03-09 12:45:00 | AAPL | Stock | 0.4743 | 0.4748 | 0.4736 | 0.4736 | 1301552.0 |
| 2004-03-09 12:50:00 | AAPL | Stock | 0.4736 | 0.4741 | 0.4734 | 0.4738 | 5676384.0 |
| 2004-03-09 12:55:00 | AAPL | Stock | 0.4738 | 0.4739 | 0.473 | 0.4738 | 2771776.0 |
| 2004-03-09 13:00:00 | AAPL | Stock | 0.4739 | 0.4752 | 0.4732 | 0.4741 | 10967096.0 |
> showing 50 of 166,299 rows — these rows as CSV