PREVIEW / stock_5min / 2000-09-28
file: by_date/stock_5min/2000/2000-09-28.parquet size: 1.3 MB rows: 95,442 symbols: 1,222
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-09-28 08:00:00 | AAPL | Stock | 0.8733 | 0.8733 | 0.8733 | 0.8733 | 4715200.0 |
| 2000-09-28 09:20:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.8761 | 0.8761 | 308000.0 |
| 2000-09-28 09:25:00 | AAPL | Stock | 0.8806 | 0.8817 | 0.8795 | 0.8806 | 173600.0 |
| 2000-09-28 09:30:00 | AAPL | Stock | 0.8806 | 0.8884 | 0.8806 | 0.8862 | 4961600.0 |
| 2000-09-28 09:35:00 | AAPL | Stock | 0.8862 | 0.8884 | 0.8817 | 0.885 | 11760000.0 |
| 2000-09-28 09:40:00 | AAPL | Stock | 0.8845 | 0.8873 | 0.8828 | 0.885 | 5712000.0 |
| 2000-09-28 09:45:00 | AAPL | Stock | 0.885 | 0.885 | 0.8817 | 0.8817 | 3533600.0 |
| 2000-09-28 09:50:00 | AAPL | Stock | 0.8806 | 0.885 | 0.8783 | 0.8783 | 2850400.0 |
| 2000-09-28 09:55:00 | AAPL | Stock | 0.8828 | 0.885 | 0.8806 | 0.8817 | 2990400.0 |
| 2000-09-28 10:00:00 | AAPL | Stock | 0.8817 | 0.8839 | 0.8806 | 0.8828 | 4144000.0 |
| 2000-09-28 10:05:00 | AAPL | Stock | 0.8828 | 0.8828 | 0.8795 | 0.8795 | 6266400.0 |
| 2000-09-28 10:10:00 | AAPL | Stock | 0.8817 | 0.8817 | 0.8795 | 0.8811 | 2329600.0 |
| 2000-09-28 10:15:00 | AAPL | Stock | 0.88 | 0.8823 | 0.8761 | 0.8778 | 6076000.0 |
| 2000-09-28 10:20:00 | AAPL | Stock | 0.8783 | 0.8795 | 0.875 | 0.8783 | 1540000.0 |
| 2000-09-28 10:25:00 | AAPL | Stock | 0.8783 | 0.8783 | 0.875 | 0.8756 | 3024000.0 |
| 2000-09-28 10:30:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.8638 | 0.865 | 5891200.0 |
| 2000-09-28 10:35:00 | AAPL | Stock | 0.8638 | 0.8666 | 0.8594 | 0.865 | 10981600.0 |
| 2000-09-28 10:40:00 | AAPL | Stock | 0.865 | 0.8661 | 0.8638 | 0.8661 | 3634400.0 |
| 2000-09-28 10:45:00 | AAPL | Stock | 0.8638 | 0.8717 | 0.8627 | 0.8717 | 2889600.0 |
| 2000-09-28 10:50:00 | AAPL | Stock | 0.8717 | 0.8761 | 0.8711 | 0.875 | 6776000.0 |
| 2000-09-28 10:55:00 | AAPL | Stock | 0.8756 | 0.8828 | 0.8756 | 0.8795 | 3270400.0 |
| 2000-09-28 11:00:00 | AAPL | Stock | 0.8806 | 0.8806 | 0.8761 | 0.8795 | 6619200.0 |
| 2000-09-28 11:05:00 | AAPL | Stock | 0.8795 | 0.8828 | 0.8772 | 0.8806 | 11468800.0 |
| 2000-09-28 11:10:00 | AAPL | Stock | 0.8783 | 0.8811 | 0.8783 | 0.8806 | 537600.0 |
| 2000-09-28 11:15:00 | AAPL | Stock | 0.8806 | 0.8817 | 0.8795 | 0.8795 | 554400.0 |
| 2000-09-28 11:20:00 | AAPL | Stock | 0.8806 | 0.8839 | 0.8795 | 0.8839 | 1467200.0 |
| 2000-09-28 11:25:00 | AAPL | Stock | 0.8839 | 0.885 | 0.8828 | 0.885 | 2900800.0 |
| 2000-09-28 11:30:00 | AAPL | Stock | 0.885 | 0.8895 | 0.885 | 0.8895 | 3080000.0 |
| 2000-09-28 11:35:00 | AAPL | Stock | 0.8895 | 0.8906 | 0.8884 | 0.8906 | 756000.0 |
| 2000-09-28 11:40:00 | AAPL | Stock | 0.8906 | 0.9007 | 0.8906 | 0.9001 | 6479200.0 |
| 2000-09-28 11:45:00 | AAPL | Stock | 0.8996 | 0.9007 | 0.8962 | 0.8996 | 8640800.0 |
| 2000-09-28 11:50:00 | AAPL | Stock | 0.8984 | 0.8996 | 0.8962 | 0.8962 | 7050400.0 |
| 2000-09-28 11:55:00 | AAPL | Stock | 0.8984 | 0.9046 | 0.8962 | 0.9046 | 8260000.0 |
| 2000-09-28 12:00:00 | AAPL | Stock | 0.904 | 0.9063 | 0.9018 | 0.9051 | 4222400.0 |
| 2000-09-28 12:05:00 | AAPL | Stock | 0.9051 | 0.9096 | 0.904 | 0.9063 | 4608800.0 |
| 2000-09-28 12:10:00 | AAPL | Stock | 0.9063 | 0.9074 | 0.904 | 0.9063 | 2133600.0 |
| 2000-09-28 12:15:00 | AAPL | Stock | 0.9074 | 0.9129 | 0.9063 | 0.9129 | 9654400.0 |
| 2000-09-28 12:20:00 | AAPL | Stock | 0.9118 | 0.9129 | 0.9063 | 0.9096 | 1377600.0 |
| 2000-09-28 12:25:00 | AAPL | Stock | 0.9096 | 0.9118 | 0.9085 | 0.9107 | 3701600.0 |
| 2000-09-28 12:30:00 | AAPL | Stock | 0.9118 | 0.9118 | 0.9074 | 0.9085 | 980000.0 |
| 2000-09-28 12:35:00 | AAPL | Stock | 0.9085 | 0.9085 | 0.904 | 0.9046 | 3645600.0 |
| 2000-09-28 12:40:00 | AAPL | Stock | 0.9029 | 0.9063 | 0.9018 | 0.9063 | 1495200.0 |
| 2000-09-28 12:45:00 | AAPL | Stock | 0.9063 | 0.9085 | 0.9063 | 0.9085 | 1971200.0 |
| 2000-09-28 12:50:00 | AAPL | Stock | 0.9074 | 0.9152 | 0.9074 | 0.9152 | 1422400.0 |
| 2000-09-28 12:55:00 | AAPL | Stock | 0.9157 | 0.9163 | 0.9107 | 0.9118 | 1836800.0 |
| 2000-09-28 13:00:00 | AAPL | Stock | 0.9118 | 0.9129 | 0.9096 | 0.9107 | 2284800.0 |
| 2000-09-28 13:05:00 | AAPL | Stock | 0.9129 | 0.9129 | 0.9107 | 0.9118 | 548800.0 |
| 2000-09-28 13:10:00 | AAPL | Stock | 0.9129 | 0.9163 | 0.9118 | 0.9152 | 3393600.0 |
| 2000-09-28 13:15:00 | AAPL | Stock | 0.9146 | 0.9152 | 0.9107 | 0.9152 | 2945600.0 |
| 2000-09-28 13:20:00 | AAPL | Stock | 0.9152 | 0.9174 | 0.9141 | 0.9174 | 2576000.0 |
> showing 50 of 95,442 rows — these rows as CSV