PREVIEW / stock_5min / 2000-07-20
file: by_date/stock_5min/2000/2000-07-20.parquet size: 1.2 MB rows: 88,584 symbols: 1,196
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-20 08:05:00 | AAPL | Stock | 0.9554 | 0.9643 | 0.9542 | 0.9643 | 28000.0 |
| 2000-07-20 08:15:00 | AAPL | Stock | 0.9643 | 0.9643 | 0.9643 | 0.9643 | 11200.0 |
| 2000-07-20 08:20:00 | AAPL | Stock | 0.9621 | 0.9688 | 0.9621 | 0.9688 | 117600.0 |
| 2000-07-20 08:25:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 56000.0 |
| 2000-07-20 08:30:00 | AAPL | Stock | 0.9464 | 0.9464 | 0.9464 | 0.9464 | 5600.0 |
| 2000-07-20 08:35:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.971 | 0.971 | 112000.0 |
| 2000-07-20 08:40:00 | AAPL | Stock | 0.9754 | 0.9754 | 0.9688 | 0.9688 | 61600.0 |
| 2000-07-20 08:45:00 | AAPL | Stock | 0.9688 | 0.9699 | 0.9688 | 0.9688 | 56000.0 |
| 2000-07-20 08:50:00 | AAPL | Stock | 0.9688 | 0.9688 | 0.9643 | 0.9688 | 56000.0 |
| 2000-07-20 09:00:00 | AAPL | Stock | 0.9688 | 0.9727 | 0.9688 | 0.971 | 145600.0 |
| 2000-07-20 09:05:00 | AAPL | Stock | 0.9654 | 0.9688 | 0.9654 | 0.9665 | 106400.0 |
| 2000-07-20 09:10:00 | AAPL | Stock | 0.9688 | 0.9688 | 0.9688 | 0.9688 | 11200.0 |
| 2000-07-20 09:15:00 | AAPL | Stock | 0.9643 | 0.9721 | 0.9643 | 0.9721 | 201600.0 |
| 2000-07-20 09:20:00 | AAPL | Stock | 0.9721 | 0.9732 | 0.971 | 0.971 | 453600.0 |
| 2000-07-20 09:25:00 | AAPL | Stock | 0.971 | 0.9821 | 0.971 | 0.9821 | 3052000.0 |
| 2000-07-20 09:30:00 | AAPL | Stock | 0.9821 | 0.9911 | 0.9799 | 0.9816 | 10651200.0 |
| 2000-07-20 09:35:00 | AAPL | Stock | 0.99 | 0.9933 | 0.981 | 0.9933 | 23553600.0 |
| 2000-07-20 09:40:00 | AAPL | Stock | 0.9922 | 1.0089 | 0.9922 | 1.0089 | 19314400.0 |
| 2000-07-20 09:45:00 | AAPL | Stock | 1.0089 | 1.0089 | 0.9922 | 0.9944 | 19936000.0 |
| 2000-07-20 09:50:00 | AAPL | Stock | 0.9933 | 0.9944 | 0.9821 | 0.9833 | 14117600.0 |
| 2000-07-20 09:55:00 | AAPL | Stock | 0.9833 | 1.0011 | 0.9821 | 0.9922 | 7408800.0 |
| 2000-07-20 10:00:00 | AAPL | Stock | 0.9933 | 1.0089 | 0.9922 | 1.0089 | 15192800.0 |
| 2000-07-20 10:05:00 | AAPL | Stock | 1.0089 | 1.019 | 1.0067 | 1.0179 | 9307200.0 |
| 2000-07-20 10:10:00 | AAPL | Stock | 1.0156 | 1.019 | 1.01 | 1.01 | 9049600.0 |
| 2000-07-20 10:15:00 | AAPL | Stock | 1.0112 | 1.0134 | 1.0045 | 1.0134 | 9318400.0 |
| 2000-07-20 10:20:00 | AAPL | Stock | 1.0134 | 1.0145 | 1.0134 | 1.0134 | 9066400.0 |
| 2000-07-20 10:25:00 | AAPL | Stock | 1.0134 | 1.0145 | 1.0045 | 1.0045 | 4933600.0 |
| 2000-07-20 10:30:00 | AAPL | Stock | 1.0045 | 1.01 | 1.0033 | 1.0067 | 11485600.0 |
| 2000-07-20 10:35:00 | AAPL | Stock | 1.0061 | 1.0089 | 1.0045 | 1.0067 | 5572000.0 |
| 2000-07-20 10:40:00 | AAPL | Stock | 1.0067 | 1.0067 | 1.0022 | 1.0022 | 4799200.0 |
| 2000-07-20 10:45:00 | AAPL | Stock | 1.0017 | 1.0056 | 1.0011 | 1.0033 | 3152800.0 |
| 2000-07-20 10:50:00 | AAPL | Stock | 1.0045 | 1.0045 | 1.0011 | 1.0022 | 3264800.0 |
| 2000-07-20 10:55:00 | AAPL | Stock | 1.0011 | 1.0022 | 0.9933 | 0.9944 | 6451200.0 |
| 2000-07-20 11:00:00 | AAPL | Stock | 0.9944 | 0.9978 | 0.9922 | 0.9955 | 9100000.0 |
| 2000-07-20 11:05:00 | AAPL | Stock | 0.9955 | 0.9955 | 0.9911 | 0.9955 | 7229600.0 |
| 2000-07-20 11:10:00 | AAPL | Stock | 0.9955 | 0.9955 | 0.9888 | 0.9922 | 14112000.0 |
| 2000-07-20 11:15:00 | AAPL | Stock | 0.9933 | 0.9933 | 0.9821 | 0.9866 | 5185600.0 |
| 2000-07-20 11:20:00 | AAPL | Stock | 0.9855 | 0.9888 | 0.9844 | 0.9866 | 3774400.0 |
| 2000-07-20 11:25:00 | AAPL | Stock | 0.9877 | 0.9888 | 0.981 | 0.9821 | 6400800.0 |
| 2000-07-20 11:30:00 | AAPL | Stock | 0.9833 | 0.9844 | 0.981 | 0.9821 | 6977600.0 |
| 2000-07-20 11:35:00 | AAPL | Stock | 0.981 | 0.9855 | 0.981 | 0.9821 | 5174400.0 |
| 2000-07-20 11:40:00 | AAPL | Stock | 0.9833 | 0.9833 | 0.981 | 0.9821 | 3292800.0 |
| 2000-07-20 11:45:00 | AAPL | Stock | 0.9833 | 0.9844 | 0.9799 | 0.981 | 11877600.0 |
| 2000-07-20 11:50:00 | AAPL | Stock | 0.981 | 0.9821 | 0.9777 | 0.9777 | 5292000.0 |
| 2000-07-20 11:55:00 | AAPL | Stock | 0.9788 | 0.9833 | 0.9766 | 0.981 | 3774400.0 |
| 2000-07-20 12:00:00 | AAPL | Stock | 0.9805 | 0.9821 | 0.9777 | 0.9799 | 5488000.0 |
| 2000-07-20 12:05:00 | AAPL | Stock | 0.9799 | 0.9821 | 0.9788 | 0.9821 | 5605600.0 |
| 2000-07-20 12:10:00 | AAPL | Stock | 0.9821 | 0.9844 | 0.9821 | 0.9844 | 4054400.0 |
| 2000-07-20 12:15:00 | AAPL | Stock | 0.9844 | 0.9844 | 0.9821 | 0.9844 | 2497600.0 |
| 2000-07-20 12:20:00 | AAPL | Stock | 0.9844 | 0.9855 | 0.9833 | 0.9833 | 2654400.0 |
> showing 50 of 88,584 rows — these rows as CSV