PREVIEW / stock_5min / 2006-09-12
file: by_date/stock_5min/2006/2006-09-12.parquet size: 3.1 MB rows: 227,555 symbols: 2,351
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-12 07:25:00 | AAPL | Stock | 2.5789 | 2.5821 | 2.575 | 2.5821 | 106400.0 |
| 2006-09-12 07:45:00 | AAPL | Stock | 2.5875 | 2.5893 | 2.5875 | 2.5893 | 28000.0 |
| 2006-09-12 07:55:00 | AAPL | Stock | 2.5893 | 2.5893 | 2.5893 | 2.5893 | 5600.0 |
| 2006-09-12 08:00:00 | AAPL | Stock | 2.5875 | 2.5911 | 2.5839 | 2.5911 | 370664.0 |
| 2006-09-12 08:05:00 | AAPL | Stock | 2.5896 | 2.5911 | 2.5893 | 2.5893 | 169204.0 |
| 2006-09-12 08:10:00 | AAPL | Stock | 2.5893 | 2.6061 | 2.5875 | 2.6 | 1002568.0 |
| 2006-09-12 08:15:00 | AAPL | Stock | 2.6007 | 2.6014 | 2.5964 | 2.5964 | 517860.0 |
| 2006-09-12 08:20:00 | AAPL | Stock | 2.5964 | 2.5982 | 2.5964 | 2.5964 | 170688.0 |
| 2006-09-12 08:25:00 | AAPL | Stock | 2.5964 | 2.5964 | 2.5932 | 2.5946 | 182000.0 |
| 2006-09-12 08:30:00 | AAPL | Stock | 2.5946 | 2.5979 | 2.5946 | 2.5946 | 250180.0 |
| 2006-09-12 08:35:00 | AAPL | Stock | 2.5982 | 2.6 | 2.5968 | 2.5982 | 269136.0 |
| 2006-09-12 08:40:00 | AAPL | Stock | 2.5993 | 2.6 | 2.5982 | 2.5986 | 168840.0 |
| 2006-09-12 08:45:00 | AAPL | Stock | 2.5982 | 2.6 | 2.5979 | 2.5989 | 200984.0 |
| 2006-09-12 08:50:00 | AAPL | Stock | 2.5989 | 2.6 | 2.5982 | 2.5996 | 156800.0 |
| 2006-09-12 08:55:00 | AAPL | Stock | 2.6 | 2.6 | 2.5957 | 2.5979 | 327292.0 |
| 2006-09-12 09:00:00 | AAPL | Stock | 2.5964 | 2.5979 | 2.5921 | 2.5921 | 458248.0 |
| 2006-09-12 09:05:00 | AAPL | Stock | 2.5921 | 2.5925 | 2.5893 | 2.5925 | 690620.0 |
| 2006-09-12 09:10:00 | AAPL | Stock | 2.5936 | 2.5954 | 2.5921 | 2.5943 | 225400.0 |
| 2006-09-12 09:15:00 | AAPL | Stock | 2.5943 | 2.5964 | 2.5911 | 2.5918 | 865200.0 |
| 2006-09-12 09:20:00 | AAPL | Stock | 2.5918 | 2.6 | 2.5911 | 2.5957 | 1692600.0 |
| 2006-09-12 09:25:00 | AAPL | Stock | 2.595 | 2.6007 | 2.5914 | 2.6007 | 1147524.0 |
| 2006-09-12 09:30:00 | AAPL | Stock | 2.6004 | 2.6064 | 2.585 | 2.6018 | 33214860.0 |
| 2006-09-12 09:35:00 | AAPL | Stock | 2.6018 | 2.6036 | 2.5825 | 2.5826 | 23554132.0 |
| 2006-09-12 09:40:00 | AAPL | Stock | 2.5829 | 2.585 | 2.5707 | 2.5707 | 30777320.0 |
| 2006-09-12 09:45:00 | AAPL | Stock | 2.5707 | 2.5893 | 2.57 | 2.5871 | 20246716.0 |
| 2006-09-12 09:50:00 | AAPL | Stock | 2.5871 | 2.5975 | 2.5768 | 2.5918 | 19643120.0 |
| 2006-09-12 09:55:00 | AAPL | Stock | 2.5925 | 2.5929 | 2.5829 | 2.5843 | 11809000.0 |
| 2006-09-12 10:00:00 | AAPL | Stock | 2.585 | 2.5996 | 2.5843 | 2.595 | 12574156.0 |
| 2006-09-12 10:05:00 | AAPL | Stock | 2.5946 | 2.6039 | 2.5939 | 2.5982 | 14296212.0 |
| 2006-09-12 10:10:00 | AAPL | Stock | 2.5982 | 2.6025 | 2.5904 | 2.5939 | 13834408.0 |
| 2006-09-12 10:15:00 | AAPL | Stock | 2.5936 | 2.6157 | 2.5929 | 2.6107 | 24046932.0 |
| 2006-09-12 10:20:00 | AAPL | Stock | 2.6104 | 2.6218 | 2.6086 | 2.6207 | 25128796.0 |
| 2006-09-12 10:25:00 | AAPL | Stock | 2.6204 | 2.6232 | 2.6118 | 2.615 | 21863184.0 |
| 2006-09-12 10:30:00 | AAPL | Stock | 2.6139 | 2.62 | 2.6121 | 2.6175 | 16018856.0 |
| 2006-09-12 10:35:00 | AAPL | Stock | 2.6171 | 2.6232 | 2.6104 | 2.6125 | 14621768.0 |
| 2006-09-12 10:40:00 | AAPL | Stock | 2.6125 | 2.6132 | 2.6071 | 2.6111 | 13411188.0 |
| 2006-09-12 10:45:00 | AAPL | Stock | 2.6111 | 2.615 | 2.6071 | 2.6086 | 13242040.0 |
| 2006-09-12 10:50:00 | AAPL | Stock | 2.6086 | 2.6121 | 2.6039 | 2.6061 | 11807068.0 |
| 2006-09-12 10:55:00 | AAPL | Stock | 2.6061 | 2.6132 | 2.6021 | 2.6128 | 11945024.0 |
| 2006-09-12 11:00:00 | AAPL | Stock | 2.6131 | 2.6154 | 2.6111 | 2.6118 | 9954812.0 |
| 2006-09-12 11:05:00 | AAPL | Stock | 2.6121 | 2.6157 | 2.6064 | 2.6096 | 12261984.0 |
| 2006-09-12 11:10:00 | AAPL | Stock | 2.6096 | 2.6121 | 2.6086 | 2.6089 | 6131104.0 |
| 2006-09-12 11:15:00 | AAPL | Stock | 2.6093 | 2.6093 | 2.6054 | 2.6068 | 7228844.0 |
| 2006-09-12 11:20:00 | AAPL | Stock | 2.6064 | 2.6068 | 2.6011 | 2.6018 | 11107628.0 |
| 2006-09-12 11:25:00 | AAPL | Stock | 2.6021 | 2.6054 | 2.6011 | 2.6018 | 12399940.0 |
| 2006-09-12 11:30:00 | AAPL | Stock | 2.6018 | 2.6071 | 2.6014 | 2.6057 | 13234872.0 |
| 2006-09-12 11:35:00 | AAPL | Stock | 2.6057 | 2.6125 | 2.6057 | 2.6118 | 9153844.0 |
| 2006-09-12 11:40:00 | AAPL | Stock | 2.6118 | 2.6129 | 2.6071 | 2.6079 | 5267248.0 |
| 2006-09-12 11:45:00 | AAPL | Stock | 2.6075 | 2.6079 | 2.5968 | 2.5992 | 12390448.0 |
| 2006-09-12 11:50:00 | AAPL | Stock | 2.5993 | 2.6054 | 2.5982 | 2.6049 | 7722820.0 |
> showing 50 of 227,555 rows — these rows as CSV