PREVIEW / stock_5min / 2005-03-01
file: by_date/stock_5min/2005/2005-03-01.parquet size: 2.7 MB rows: 201,870 symbols: 1,943
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-01 08:00:00 | AAPL | Stock | 1.6086 | 1.6089 | 1.6086 | 1.6086 | 103600.0 |
| 2005-03-01 08:05:00 | AAPL | Stock | 1.6086 | 1.6086 | 1.6071 | 1.6071 | 70000.0 |
| 2005-03-01 08:10:00 | AAPL | Stock | 1.6054 | 1.6071 | 1.6054 | 1.6071 | 162400.0 |
| 2005-03-01 08:15:00 | AAPL | Stock | 1.6071 | 1.6071 | 1.6061 | 1.6061 | 30800.0 |
| 2005-03-01 08:20:00 | AAPL | Stock | 1.605 | 1.605 | 1.605 | 1.605 | 2800.0 |
| 2005-03-01 08:25:00 | AAPL | Stock | 1.6071 | 1.6071 | 1.6071 | 1.6071 | 48160.0 |
| 2005-03-01 08:30:00 | AAPL | Stock | 1.6071 | 1.6071 | 1.6064 | 1.6064 | 40600.0 |
| 2005-03-01 08:35:00 | AAPL | Stock | 1.6071 | 1.6089 | 1.6071 | 1.6089 | 81200.0 |
| 2005-03-01 08:40:00 | AAPL | Stock | 1.6107 | 1.6111 | 1.605 | 1.6075 | 674688.0 |
| 2005-03-01 08:45:00 | AAPL | Stock | 1.6075 | 1.6107 | 1.6021 | 1.6082 | 155680.0 |
| 2005-03-01 08:50:00 | AAPL | Stock | 1.6089 | 1.6107 | 1.6089 | 1.6107 | 44380.0 |
| 2005-03-01 08:55:00 | AAPL | Stock | 1.6089 | 1.6089 | 1.6079 | 1.6079 | 2543632.0 |
| 2005-03-01 09:00:00 | AAPL | Stock | 1.6082 | 1.6082 | 1.6057 | 1.6064 | 151704.0 |
| 2005-03-01 09:05:00 | AAPL | Stock | 1.6071 | 1.6071 | 1.6071 | 1.6071 | 10360.0 |
| 2005-03-01 09:10:00 | AAPL | Stock | 1.6064 | 1.6071 | 1.6054 | 1.6064 | 246540.0 |
| 2005-03-01 09:15:00 | AAPL | Stock | 1.605 | 1.6071 | 1.605 | 1.6071 | 206360.0 |
| 2005-03-01 09:20:00 | AAPL | Stock | 1.6071 | 1.6089 | 1.6061 | 1.6071 | 623280.0 |
| 2005-03-01 09:25:00 | AAPL | Stock | 1.6071 | 1.6096 | 1.6071 | 1.6086 | 2659300.0 |
| 2005-03-01 09:30:00 | AAPL | Stock | 1.6068 | 1.6111 | 1.6018 | 1.6043 | 30800868.0 |
| 2005-03-01 09:35:00 | AAPL | Stock | 1.6054 | 1.6089 | 1.6018 | 1.6068 | 14277788.0 |
| 2005-03-01 09:40:00 | AAPL | Stock | 1.6068 | 1.6068 | 1.5982 | 1.6 | 13818420.0 |
| 2005-03-01 09:45:00 | AAPL | Stock | 1.6 | 1.6025 | 1.5957 | 1.6014 | 9567012.0 |
| 2005-03-01 09:50:00 | AAPL | Stock | 1.6018 | 1.6025 | 1.5961 | 1.5992 | 9808064.0 |
| 2005-03-01 09:55:00 | AAPL | Stock | 1.5993 | 1.6 | 1.5929 | 1.5932 | 7910168.0 |
| 2005-03-01 10:00:00 | AAPL | Stock | 1.5936 | 1.5989 | 1.5904 | 1.5975 | 11574892.0 |
| 2005-03-01 10:05:00 | AAPL | Stock | 1.5971 | 1.6014 | 1.595 | 1.595 | 9154656.0 |
| 2005-03-01 10:10:00 | AAPL | Stock | 1.5957 | 1.5982 | 1.5929 | 1.5968 | 6299300.0 |
| 2005-03-01 10:15:00 | AAPL | Stock | 1.5975 | 1.6011 | 1.5961 | 1.5964 | 5551252.0 |
| 2005-03-01 10:20:00 | AAPL | Stock | 1.5964 | 1.5996 | 1.5946 | 1.5979 | 5347188.0 |
| 2005-03-01 10:25:00 | AAPL | Stock | 1.5975 | 1.6021 | 1.5964 | 1.6021 | 5947760.0 |
| 2005-03-01 10:30:00 | AAPL | Stock | 1.6025 | 1.6046 | 1.6 | 1.6025 | 7900928.0 |
| 2005-03-01 10:35:00 | AAPL | Stock | 1.6025 | 1.6064 | 1.6025 | 1.6029 | 9142308.0 |
| 2005-03-01 10:40:00 | AAPL | Stock | 1.6029 | 1.6068 | 1.6025 | 1.6029 | 4851672.0 |
| 2005-03-01 10:45:00 | AAPL | Stock | 1.6029 | 1.6071 | 1.5964 | 1.5982 | 7573272.0 |
| 2005-03-01 10:50:00 | AAPL | Stock | 1.5986 | 1.6011 | 1.5979 | 1.5979 | 4700248.0 |
| 2005-03-01 10:55:00 | AAPL | Stock | 1.5982 | 1.5993 | 1.5964 | 1.5982 | 5198340.0 |
| 2005-03-01 11:00:00 | AAPL | Stock | 1.5982 | 1.5986 | 1.5911 | 1.5954 | 12876416.0 |
| 2005-03-01 11:05:00 | AAPL | Stock | 1.5954 | 1.5964 | 1.5925 | 1.5939 | 5732020.0 |
| 2005-03-01 11:10:00 | AAPL | Stock | 1.5939 | 1.5957 | 1.5929 | 1.5939 | 5246136.0 |
| 2005-03-01 11:15:00 | AAPL | Stock | 1.5943 | 1.5964 | 1.5918 | 1.5918 | 10853836.0 |
| 2005-03-01 11:20:00 | AAPL | Stock | 1.5918 | 1.5946 | 1.5914 | 1.5936 | 4877824.0 |
| 2005-03-01 11:25:00 | AAPL | Stock | 1.5936 | 1.5961 | 1.5911 | 1.5925 | 5074496.0 |
| 2005-03-01 11:30:00 | AAPL | Stock | 1.5925 | 1.5954 | 1.5918 | 1.5939 | 3911824.0 |
| 2005-03-01 11:35:00 | AAPL | Stock | 1.5939 | 1.5957 | 1.5936 | 1.5946 | 1302784.0 |
| 2005-03-01 11:40:00 | AAPL | Stock | 1.5946 | 1.5946 | 1.5882 | 1.5893 | 6843816.0 |
| 2005-03-01 11:45:00 | AAPL | Stock | 1.5893 | 1.5946 | 1.5864 | 1.5889 | 10360756.0 |
| 2005-03-01 11:50:00 | AAPL | Stock | 1.5889 | 1.5957 | 1.5882 | 1.5929 | 7475944.0 |
| 2005-03-01 11:55:00 | AAPL | Stock | 1.5932 | 1.5936 | 1.5893 | 1.5893 | 3364816.0 |
| 2005-03-01 12:00:00 | AAPL | Stock | 1.5893 | 1.5893 | 1.5839 | 1.5871 | 6313888.0 |
| 2005-03-01 12:05:00 | AAPL | Stock | 1.5868 | 1.5886 | 1.5846 | 1.5846 | 3727556.0 |
> showing 50 of 201,870 rows — these rows as CSV