PREVIEW / stock_5min / 2000-07-19
file: by_date/stock_5min/2000/2000-07-19.parquet size: 1.1 MB rows: 85,153 symbols: 1,188
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-19 08:00:00 | AAPL | Stock | 0.9732 | 0.9866 | 0.9621 | 0.9866 | 1971200.0 |
| 2000-07-19 08:05:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9509 | 0.9643 | 2156000.0 |
| 2000-07-19 08:10:00 | AAPL | Stock | 0.9643 | 0.9732 | 0.9632 | 0.9732 | 1243200.0 |
| 2000-07-19 08:15:00 | AAPL | Stock | 0.9732 | 0.9821 | 0.9688 | 0.9732 | 151200.0 |
| 2000-07-19 08:20:00 | AAPL | Stock | 0.9732 | 0.9777 | 0.9732 | 0.9777 | 173600.0 |
| 2000-07-19 08:25:00 | AAPL | Stock | 0.9799 | 0.9799 | 0.9799 | 0.9799 | 5600.0 |
| 2000-07-19 08:30:00 | AAPL | Stock | 0.9799 | 0.9799 | 0.9732 | 0.9799 | 509600.0 |
| 2000-07-19 08:35:00 | AAPL | Stock | 0.9799 | 0.9866 | 0.9799 | 0.9866 | 576800.0 |
| 2000-07-19 08:40:00 | AAPL | Stock | 0.9866 | 1.0 | 0.9866 | 1.0 | 1708000.0 |
| 2000-07-19 08:45:00 | AAPL | Stock | 1.0 | 1.0 | 0.99 | 0.9911 | 1114400.0 |
| 2000-07-19 08:50:00 | AAPL | Stock | 0.9911 | 1.0 | 0.9911 | 0.9955 | 184800.0 |
| 2000-07-19 08:55:00 | AAPL | Stock | 1.0 | 1.0229 | 0.9978 | 1.0045 | 336000.0 |
| 2000-07-19 09:00:00 | AAPL | Stock | 1.0 | 1.0 | 0.9866 | 0.99 | 134400.0 |
| 2000-07-19 09:05:00 | AAPL | Stock | 0.9866 | 1.0 | 0.9821 | 0.9911 | 179200.0 |
| 2000-07-19 09:10:00 | AAPL | Stock | 0.9866 | 0.9911 | 0.9621 | 0.9821 | 459200.0 |
| 2000-07-19 09:15:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9732 | 0.9821 | 604800.0 |
| 2000-07-19 09:20:00 | AAPL | Stock | 0.9821 | 0.9911 | 0.9821 | 0.9866 | 828800.0 |
| 2000-07-19 09:25:00 | AAPL | Stock | 0.9844 | 0.9888 | 0.9821 | 0.9833 | 784000.0 |
| 2000-07-19 09:30:00 | AAPL | Stock | 0.9855 | 0.99 | 0.9821 | 0.9877 | 6865600.0 |
| 2000-07-19 09:35:00 | AAPL | Stock | 0.9877 | 1.0112 | 0.9861 | 1.0112 | 15736000.0 |
| 2000-07-19 09:40:00 | AAPL | Stock | 1.01 | 1.0145 | 1.0 | 1.0011 | 11149600.0 |
| 2000-07-19 09:45:00 | AAPL | Stock | 1.0022 | 1.0022 | 0.9922 | 0.9955 | 5863200.0 |
| 2000-07-19 09:50:00 | AAPL | Stock | 0.9955 | 0.9967 | 0.9922 | 0.9944 | 6076000.0 |
| 2000-07-19 09:55:00 | AAPL | Stock | 0.9944 | 0.9955 | 0.9766 | 0.9777 | 7386400.0 |
| 2000-07-19 10:00:00 | AAPL | Stock | 0.9777 | 0.9844 | 0.9699 | 0.9721 | 6770400.0 |
| 2000-07-19 10:05:00 | AAPL | Stock | 0.9721 | 0.9732 | 0.9598 | 0.9699 | 13372800.0 |
| 2000-07-19 10:10:00 | AAPL | Stock | 0.9699 | 0.9732 | 0.9654 | 0.9732 | 5538400.0 |
| 2000-07-19 10:15:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9643 | 0.9643 | 4586400.0 |
| 2000-07-19 10:20:00 | AAPL | Stock | 0.9643 | 0.9732 | 0.9621 | 0.971 | 6731200.0 |
| 2000-07-19 10:25:00 | AAPL | Stock | 0.971 | 0.9721 | 0.9665 | 0.971 | 4138400.0 |
| 2000-07-19 10:30:00 | AAPL | Stock | 0.971 | 0.9721 | 0.9665 | 0.9688 | 2833600.0 |
| 2000-07-19 10:35:00 | AAPL | Stock | 0.9699 | 0.9777 | 0.9676 | 0.9743 | 6014400.0 |
| 2000-07-19 10:40:00 | AAPL | Stock | 0.9732 | 0.9777 | 0.9688 | 0.9688 | 4216800.0 |
| 2000-07-19 10:45:00 | AAPL | Stock | 0.9699 | 0.9743 | 0.9654 | 0.9665 | 4334400.0 |
| 2000-07-19 10:50:00 | AAPL | Stock | 0.9665 | 0.9676 | 0.9632 | 0.9654 | 5504800.0 |
| 2000-07-19 10:55:00 | AAPL | Stock | 0.9643 | 0.9676 | 0.9632 | 0.9632 | 5208000.0 |
| 2000-07-19 11:00:00 | AAPL | Stock | 0.9632 | 0.9704 | 0.9621 | 0.9699 | 9094400.0 |
| 2000-07-19 11:05:00 | AAPL | Stock | 0.9688 | 0.9699 | 0.9632 | 0.9665 | 6356000.0 |
| 2000-07-19 11:10:00 | AAPL | Stock | 0.9665 | 0.9665 | 0.9632 | 0.9654 | 5532800.0 |
| 2000-07-19 11:15:00 | AAPL | Stock | 0.9654 | 0.9699 | 0.9643 | 0.9676 | 4956000.0 |
| 2000-07-19 11:20:00 | AAPL | Stock | 0.9676 | 0.9688 | 0.9643 | 0.9676 | 3617600.0 |
| 2000-07-19 11:25:00 | AAPL | Stock | 0.9654 | 0.9721 | 0.9632 | 0.971 | 9548000.0 |
| 2000-07-19 11:30:00 | AAPL | Stock | 0.9676 | 0.9732 | 0.9643 | 0.9732 | 8036000.0 |
| 2000-07-19 11:35:00 | AAPL | Stock | 0.9732 | 0.9799 | 0.971 | 0.9732 | 4597600.0 |
| 2000-07-19 11:40:00 | AAPL | Stock | 0.9721 | 0.9743 | 0.9688 | 0.9732 | 5588800.0 |
| 2000-07-19 11:45:00 | AAPL | Stock | 0.9721 | 0.9721 | 0.9621 | 0.9643 | 5868800.0 |
| 2000-07-19 11:50:00 | AAPL | Stock | 0.9632 | 0.9643 | 0.9509 | 0.9509 | 8108800.0 |
| 2000-07-19 11:55:00 | AAPL | Stock | 0.9509 | 0.9554 | 0.9509 | 0.9542 | 5717600.0 |
| 2000-07-19 12:00:00 | AAPL | Stock | 0.9554 | 0.9576 | 0.9531 | 0.9576 | 2626400.0 |
| 2000-07-19 12:05:00 | AAPL | Stock | 0.9565 | 0.9621 | 0.9531 | 0.9609 | 2536800.0 |
> showing 50 of 85,153 rows — these rows as CSV