PREVIEW / stock_5min / 2004-09-23
file: by_date/stock_5min/2004/2004-09-23.parquet size: 2.3 MB rows: 172,745 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-09-23 08:00:00 | AAPL | Stock | 0.6591 | 0.6593 | 0.6591 | 0.6591 | 51184.0 |
| 2004-09-23 08:35:00 | AAPL | Stock | 0.6598 | 0.6598 | 0.6598 | 0.6598 | 39200.0 |
| 2004-09-23 09:25:00 | AAPL | Stock | 0.6613 | 0.6613 | 0.6604 | 0.6607 | 935200.0 |
| 2004-09-23 09:30:00 | AAPL | Stock | 0.6614 | 0.6652 | 0.6607 | 0.6643 | 15780240.0 |
| 2004-09-23 09:35:00 | AAPL | Stock | 0.6645 | 0.6652 | 0.6618 | 0.6625 | 18307800.0 |
| 2004-09-23 09:40:00 | AAPL | Stock | 0.6625 | 0.6634 | 0.6623 | 0.6625 | 4754568.0 |
| 2004-09-23 09:45:00 | AAPL | Stock | 0.6625 | 0.6628 | 0.6602 | 0.6623 | 6246016.0 |
| 2004-09-23 09:50:00 | AAPL | Stock | 0.6625 | 0.6632 | 0.6616 | 0.663 | 7370944.0 |
| 2004-09-23 09:55:00 | AAPL | Stock | 0.663 | 0.6638 | 0.6627 | 0.6634 | 12057472.0 |
| 2004-09-23 10:00:00 | AAPL | Stock | 0.6632 | 0.6632 | 0.6595 | 0.6598 | 12009256.0 |
| 2004-09-23 10:05:00 | AAPL | Stock | 0.66 | 0.6614 | 0.6595 | 0.6614 | 9453136.0 |
| 2004-09-23 10:10:00 | AAPL | Stock | 0.6616 | 0.6638 | 0.6607 | 0.6634 | 4717888.0 |
| 2004-09-23 10:15:00 | AAPL | Stock | 0.6634 | 0.667 | 0.6627 | 0.667 | 9881592.0 |
| 2004-09-23 10:20:00 | AAPL | Stock | 0.6666 | 0.667 | 0.6646 | 0.6654 | 9196656.0 |
| 2004-09-23 10:25:00 | AAPL | Stock | 0.6654 | 0.6666 | 0.6652 | 0.6659 | 5943560.0 |
| 2004-09-23 10:30:00 | AAPL | Stock | 0.6657 | 0.6661 | 0.6652 | 0.6655 | 3630088.0 |
| 2004-09-23 10:35:00 | AAPL | Stock | 0.6654 | 0.6657 | 0.6638 | 0.6648 | 6031648.0 |
| 2004-09-23 10:40:00 | AAPL | Stock | 0.6648 | 0.6657 | 0.6634 | 0.6643 | 3165960.0 |
| 2004-09-23 10:45:00 | AAPL | Stock | 0.6641 | 0.6654 | 0.6638 | 0.6645 | 4141816.0 |
| 2004-09-23 10:50:00 | AAPL | Stock | 0.6648 | 0.6659 | 0.6643 | 0.6657 | 6810216.0 |
| 2004-09-23 10:55:00 | AAPL | Stock | 0.6657 | 0.668 | 0.6655 | 0.6679 | 8369256.0 |
| 2004-09-23 11:00:00 | AAPL | Stock | 0.6679 | 0.6689 | 0.6674 | 0.668 | 7613312.0 |
| 2004-09-23 11:05:00 | AAPL | Stock | 0.6679 | 0.668 | 0.6664 | 0.667 | 4931640.0 |
| 2004-09-23 11:10:00 | AAPL | Stock | 0.667 | 0.6679 | 0.6661 | 0.6666 | 2918384.0 |
| 2004-09-23 11:15:00 | AAPL | Stock | 0.6663 | 0.667 | 0.6661 | 0.6663 | 4095056.0 |
| 2004-09-23 11:20:00 | AAPL | Stock | 0.6661 | 0.6668 | 0.6654 | 0.6664 | 2338168.0 |
| 2004-09-23 11:25:00 | AAPL | Stock | 0.6664 | 0.6668 | 0.6661 | 0.6663 | 1806280.0 |
| 2004-09-23 11:30:00 | AAPL | Stock | 0.6663 | 0.6666 | 0.6663 | 0.6663 | 560952.0 |
| 2004-09-23 11:35:00 | AAPL | Stock | 0.6663 | 0.6668 | 0.6654 | 0.6659 | 3341576.0 |
| 2004-09-23 11:40:00 | AAPL | Stock | 0.6657 | 0.6661 | 0.6646 | 0.6652 | 2916032.0 |
| 2004-09-23 11:45:00 | AAPL | Stock | 0.6652 | 0.6652 | 0.6643 | 0.665 | 1715224.0 |
| 2004-09-23 11:50:00 | AAPL | Stock | 0.665 | 0.6668 | 0.665 | 0.6668 | 1333248.0 |
| 2004-09-23 11:55:00 | AAPL | Stock | 0.6668 | 0.6673 | 0.6663 | 0.6663 | 1120896.0 |
| 2004-09-23 12:00:00 | AAPL | Stock | 0.6663 | 0.6671 | 0.6661 | 0.6664 | 2305520.0 |
| 2004-09-23 12:05:00 | AAPL | Stock | 0.6664 | 0.6673 | 0.6661 | 0.6673 | 1716400.0 |
| 2004-09-23 12:10:00 | AAPL | Stock | 0.6671 | 0.6677 | 0.6661 | 0.6673 | 2117024.0 |
| 2004-09-23 12:15:00 | AAPL | Stock | 0.6673 | 0.6673 | 0.6661 | 0.6668 | 922152.0 |
| 2004-09-23 12:20:00 | AAPL | Stock | 0.6668 | 0.6668 | 0.6661 | 0.6663 | 1285032.0 |
| 2004-09-23 12:25:00 | AAPL | Stock | 0.6663 | 0.6666 | 0.6643 | 0.6645 | 1737512.0 |
| 2004-09-23 12:30:00 | AAPL | Stock | 0.6646 | 0.6652 | 0.6643 | 0.6646 | 2415952.0 |
| 2004-09-23 12:35:00 | AAPL | Stock | 0.6648 | 0.6648 | 0.6634 | 0.6645 | 2431520.0 |
| 2004-09-23 12:40:00 | AAPL | Stock | 0.6645 | 0.6652 | 0.6641 | 0.6643 | 1018976.0 |
| 2004-09-23 12:45:00 | AAPL | Stock | 0.6639 | 0.6643 | 0.6618 | 0.6632 | 2202928.0 |
| 2004-09-23 12:50:00 | AAPL | Stock | 0.6632 | 0.6646 | 0.6632 | 0.6643 | 3419360.0 |
| 2004-09-23 12:55:00 | AAPL | Stock | 0.6645 | 0.6654 | 0.6643 | 0.665 | 2270184.0 |
| 2004-09-23 13:00:00 | AAPL | Stock | 0.665 | 0.6652 | 0.6643 | 0.6648 | 4082680.0 |
| 2004-09-23 13:05:00 | AAPL | Stock | 0.6652 | 0.6663 | 0.665 | 0.6659 | 1975904.0 |
| 2004-09-23 13:10:00 | AAPL | Stock | 0.6657 | 0.6673 | 0.6654 | 0.6661 | 3995600.0 |
| 2004-09-23 13:15:00 | AAPL | Stock | 0.6661 | 0.6663 | 0.6654 | 0.6659 | 4239032.0 |
| 2004-09-23 13:20:00 | AAPL | Stock | 0.6657 | 0.6657 | 0.6646 | 0.6648 | 922656.0 |
> showing 50 of 172,745 rows — these rows as CSV