PREVIEW / stock_5min / 2000-06-20
file: by_date/stock_5min/2000/2000-06-20.parquet size: 1.2 MB rows: 88,460 symbols: 1,178
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-06-20 08:00:00 | AAPL | Stock | 0.863 | 0.863 | 0.863 | 0.863 | 504000.0 |
| 2000-06-20 08:05:00 | AAPL | Stock | 0.8728 | 0.875 | 0.8728 | 0.875 | 22400.0 |
| 2000-06-20 08:10:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.8697 | 0.8697 | 44800.0 |
| 2000-06-20 08:15:00 | AAPL | Stock | 0.8722 | 0.8722 | 0.8722 | 0.8722 | 11200.0 |
| 2000-06-20 08:20:00 | AAPL | Stock | 0.8717 | 0.8722 | 0.8717 | 0.8717 | 156800.0 |
| 2000-06-20 08:25:00 | AAPL | Stock | 0.8733 | 0.8733 | 0.8638 | 0.8638 | 179200.0 |
| 2000-06-20 08:30:00 | AAPL | Stock | 0.8638 | 0.8638 | 0.8638 | 0.8638 | 33600.0 |
| 2000-06-20 08:35:00 | AAPL | Stock | 0.8666 | 0.8666 | 0.8666 | 0.8666 | 11200.0 |
| 2000-06-20 08:45:00 | AAPL | Stock | 0.8666 | 0.8666 | 0.8666 | 0.8666 | 22400.0 |
| 2000-06-20 08:55:00 | AAPL | Stock | 0.8661 | 0.8661 | 0.8627 | 0.8627 | 22400.0 |
| 2000-06-20 09:00:00 | AAPL | Stock | 0.8672 | 0.8672 | 0.8672 | 0.8672 | 89600.0 |
| 2000-06-20 09:10:00 | AAPL | Stock | 0.8672 | 0.8683 | 0.8672 | 0.8672 | 168000.0 |
| 2000-06-20 09:15:00 | AAPL | Stock | 0.8683 | 0.8683 | 0.8661 | 0.8661 | 302400.0 |
| 2000-06-20 09:20:00 | AAPL | Stock | 0.865 | 0.8772 | 0.865 | 0.8772 | 526400.0 |
| 2000-06-20 09:25:00 | AAPL | Stock | 0.8756 | 0.8795 | 0.8728 | 0.8795 | 1657600.0 |
| 2000-06-20 09:30:00 | AAPL | Stock | 0.8795 | 0.8884 | 0.8783 | 0.8884 | 15097600.0 |
| 2000-06-20 09:35:00 | AAPL | Stock | 0.8878 | 0.8962 | 0.8839 | 0.8951 | 23732800.0 |
| 2000-06-20 09:40:00 | AAPL | Stock | 0.8962 | 0.9169 | 0.8929 | 0.9129 | 20249600.0 |
| 2000-06-20 09:45:00 | AAPL | Stock | 0.9135 | 0.9169 | 0.9085 | 0.9163 | 15556800.0 |
| 2000-06-20 09:50:00 | AAPL | Stock | 0.9146 | 0.9163 | 0.9074 | 0.909 | 11692800.0 |
| 2000-06-20 09:55:00 | AAPL | Stock | 0.9096 | 0.9096 | 0.9046 | 0.9057 | 7380800.0 |
| 2000-06-20 10:00:00 | AAPL | Stock | 0.9063 | 0.9074 | 0.9023 | 0.9063 | 5476800.0 |
| 2000-06-20 10:05:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.904 | 0.9096 | 6753600.0 |
| 2000-06-20 10:10:00 | AAPL | Stock | 0.9093 | 0.9121 | 0.9074 | 0.9096 | 8747200.0 |
| 2000-06-20 10:15:00 | AAPL | Stock | 0.9096 | 0.9107 | 0.9063 | 0.9068 | 4491200.0 |
| 2000-06-20 10:20:00 | AAPL | Stock | 0.9063 | 0.9096 | 0.9063 | 0.9074 | 5936000.0 |
| 2000-06-20 10:25:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9046 | 0.9096 | 4177600.0 |
| 2000-06-20 10:30:00 | AAPL | Stock | 0.9096 | 0.9107 | 0.9074 | 0.9096 | 5017600.0 |
| 2000-06-20 10:35:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9068 | 0.9074 | 3908800.0 |
| 2000-06-20 10:40:00 | AAPL | Stock | 0.9074 | 0.9135 | 0.9074 | 0.9135 | 6686400.0 |
| 2000-06-20 10:45:00 | AAPL | Stock | 0.9135 | 0.9152 | 0.9107 | 0.9113 | 4188800.0 |
| 2000-06-20 10:50:00 | AAPL | Stock | 0.9113 | 0.9146 | 0.9107 | 0.9129 | 3091200.0 |
| 2000-06-20 10:55:00 | AAPL | Stock | 0.9129 | 0.9141 | 0.9113 | 0.9113 | 3348800.0 |
| 2000-06-20 11:00:00 | AAPL | Stock | 0.9113 | 0.9129 | 0.9113 | 0.9113 | 2654400.0 |
| 2000-06-20 11:05:00 | AAPL | Stock | 0.9113 | 0.9118 | 0.9096 | 0.9107 | 5555200.0 |
| 2000-06-20 11:10:00 | AAPL | Stock | 0.9102 | 0.9129 | 0.9102 | 0.9102 | 5812800.0 |
| 2000-06-20 11:15:00 | AAPL | Stock | 0.9102 | 0.9107 | 0.9068 | 0.909 | 8500800.0 |
| 2000-06-20 11:20:00 | AAPL | Stock | 0.9096 | 0.9102 | 0.9074 | 0.909 | 3326400.0 |
| 2000-06-20 11:25:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9063 | 0.9085 | 4782400.0 |
| 2000-06-20 11:30:00 | AAPL | Stock | 0.9079 | 0.9096 | 0.8996 | 0.9001 | 20552000.0 |
| 2000-06-20 11:35:00 | AAPL | Stock | 0.9007 | 0.9051 | 0.8973 | 0.9023 | 9004800.0 |
| 2000-06-20 11:40:00 | AAPL | Stock | 0.9018 | 0.9063 | 0.9012 | 0.904 | 4771200.0 |
| 2000-06-20 11:45:00 | AAPL | Stock | 0.9051 | 0.9057 | 0.9018 | 0.904 | 4177600.0 |
| 2000-06-20 11:50:00 | AAPL | Stock | 0.9035 | 0.9043 | 0.8979 | 0.8979 | 2822400.0 |
| 2000-06-20 11:55:00 | AAPL | Stock | 0.8979 | 0.899 | 0.8945 | 0.8956 | 12678400.0 |
| 2000-06-20 12:00:00 | AAPL | Stock | 0.8956 | 0.8979 | 0.8945 | 0.897 | 5790400.0 |
| 2000-06-20 12:05:00 | AAPL | Stock | 0.8979 | 0.904 | 0.8973 | 0.9035 | 5476800.0 |
| 2000-06-20 12:10:00 | AAPL | Stock | 0.904 | 0.9063 | 0.9018 | 0.9046 | 4961600.0 |
| 2000-06-20 12:15:00 | AAPL | Stock | 0.9029 | 0.9051 | 0.9029 | 0.9035 | 1187200.0 |
| 2000-06-20 12:20:00 | AAPL | Stock | 0.9035 | 0.9063 | 0.9035 | 0.9063 | 2441600.0 |
> showing 50 of 88,460 rows — these rows as CSV