PREVIEW / stock_5min / 2006-01-03
file: by_date/stock_5min/2006/2006-01-03.parquet size: 3.1 MB rows: 221,529 symbols: 2,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 |
|---|---|---|---|---|---|---|---|
| 2006-01-03 06:35:00 | AAPL | Stock | 2.5839 | 2.5839 | 2.5839 | 2.5839 | 2800.0 |
| 2006-01-03 07:10:00 | AAPL | Stock | 2.5886 | 2.5886 | 2.5886 | 2.5886 | 2800.0 |
| 2006-01-03 07:15:00 | AAPL | Stock | 2.5896 | 2.5896 | 2.5896 | 2.5896 | 19600.0 |
| 2006-01-03 07:30:00 | AAPL | Stock | 2.5946 | 2.5964 | 2.5946 | 2.5964 | 25200.0 |
| 2006-01-03 07:35:00 | AAPL | Stock | 2.5932 | 2.5939 | 2.5932 | 2.5939 | 19600.0 |
| 2006-01-03 07:55:00 | AAPL | Stock | 2.5964 | 2.5964 | 2.5964 | 2.5964 | 19600.0 |
| 2006-01-03 08:00:00 | AAPL | Stock | 2.5932 | 2.6036 | 2.5886 | 2.6036 | 470120.0 |
| 2006-01-03 08:05:00 | AAPL | Stock | 2.6014 | 2.6036 | 2.5675 | 2.5986 | 323344.0 |
| 2006-01-03 08:10:00 | AAPL | Stock | 2.6 | 2.6054 | 2.5675 | 2.5982 | 1462412.0 |
| 2006-01-03 08:15:00 | AAPL | Stock | 2.5964 | 2.5982 | 2.5911 | 2.5911 | 103600.0 |
| 2006-01-03 08:20:00 | AAPL | Stock | 2.5946 | 2.5964 | 2.5929 | 2.5929 | 193200.0 |
| 2006-01-03 08:25:00 | AAPL | Stock | 2.5943 | 2.5943 | 2.5914 | 2.5932 | 113400.0 |
| 2006-01-03 08:30:00 | AAPL | Stock | 2.5936 | 2.5943 | 2.5929 | 2.5929 | 235200.0 |
| 2006-01-03 08:35:00 | AAPL | Stock | 2.5939 | 2.5939 | 2.5914 | 2.5914 | 148792.0 |
| 2006-01-03 08:40:00 | AAPL | Stock | 2.5914 | 2.5929 | 2.5911 | 2.5925 | 28672.0 |
| 2006-01-03 08:45:00 | AAPL | Stock | 2.5914 | 2.5925 | 2.5857 | 2.5893 | 476700.0 |
| 2006-01-03 08:50:00 | AAPL | Stock | 2.5893 | 2.59 | 2.5889 | 2.5893 | 371224.0 |
| 2006-01-03 08:55:00 | AAPL | Stock | 2.5893 | 2.5907 | 2.5889 | 2.5907 | 431200.0 |
| 2006-01-03 09:00:00 | AAPL | Stock | 2.5914 | 2.5918 | 2.5907 | 2.5918 | 56728.0 |
| 2006-01-03 09:05:00 | AAPL | Stock | 2.5911 | 2.5925 | 2.5904 | 2.5925 | 190400.0 |
| 2006-01-03 09:10:00 | AAPL | Stock | 2.5925 | 2.5943 | 2.5921 | 2.5943 | 82572.0 |
| 2006-01-03 09:15:00 | AAPL | Stock | 2.5929 | 2.5932 | 2.5914 | 2.5914 | 21000.0 |
| 2006-01-03 09:20:00 | AAPL | Stock | 2.5914 | 2.5914 | 2.5889 | 2.5889 | 809200.0 |
| 2006-01-03 09:25:00 | AAPL | Stock | 2.5889 | 2.5932 | 2.5832 | 2.5843 | 2385852.0 |
| 2006-01-03 09:30:00 | AAPL | Stock | 2.585 | 2.5957 | 2.5804 | 2.5907 | 34277460.0 |
| 2006-01-03 09:35:00 | AAPL | Stock | 2.5907 | 2.5982 | 2.5904 | 2.5964 | 22366596.0 |
| 2006-01-03 09:40:00 | AAPL | Stock | 2.5968 | 2.6089 | 2.5961 | 2.6064 | 24446856.0 |
| 2006-01-03 09:45:00 | AAPL | Stock | 2.6064 | 2.6186 | 2.6061 | 2.6179 | 21022372.0 |
| 2006-01-03 09:50:00 | AAPL | Stock | 2.6182 | 2.6232 | 2.6057 | 2.6068 | 18534376.0 |
| 2006-01-03 09:55:00 | AAPL | Stock | 2.6068 | 2.6282 | 2.6046 | 2.6275 | 16143008.0 |
| 2006-01-03 10:00:00 | AAPL | Stock | 2.6279 | 2.6339 | 2.6032 | 2.6243 | 21618716.0 |
| 2006-01-03 10:05:00 | AAPL | Stock | 2.6243 | 2.6286 | 2.6118 | 2.6136 | 18680648.0 |
| 2006-01-03 10:10:00 | AAPL | Stock | 2.6136 | 2.6175 | 2.6 | 2.6075 | 27632444.0 |
| 2006-01-03 10:15:00 | AAPL | Stock | 2.6086 | 2.6136 | 2.6029 | 2.6029 | 11377128.0 |
| 2006-01-03 10:20:00 | AAPL | Stock | 2.6029 | 2.6239 | 2.5979 | 2.5996 | 10129672.0 |
| 2006-01-03 10:25:00 | AAPL | Stock | 2.5996 | 2.6014 | 2.5921 | 2.5957 | 11587856.0 |
| 2006-01-03 10:30:00 | AAPL | Stock | 2.5954 | 2.6029 | 2.5936 | 2.5982 | 13944112.0 |
| 2006-01-03 10:35:00 | AAPL | Stock | 2.5982 | 2.6025 | 2.5886 | 2.5932 | 9425388.0 |
| 2006-01-03 10:40:00 | AAPL | Stock | 2.5936 | 2.605 | 2.5932 | 2.6021 | 9662212.0 |
| 2006-01-03 10:45:00 | AAPL | Stock | 2.6021 | 2.6061 | 2.5986 | 2.6046 | 8270948.0 |
| 2006-01-03 10:50:00 | AAPL | Stock | 2.6046 | 2.6118 | 2.6007 | 2.6014 | 5560772.0 |
| 2006-01-03 10:55:00 | AAPL | Stock | 2.6011 | 2.6039 | 2.5982 | 2.5996 | 7788200.0 |
| 2006-01-03 11:00:00 | AAPL | Stock | 2.5999 | 2.6004 | 2.5957 | 2.5961 | 8283044.0 |
| 2006-01-03 11:05:00 | AAPL | Stock | 2.5954 | 2.6171 | 2.5943 | 2.5993 | 4488512.0 |
| 2006-01-03 11:10:00 | AAPL | Stock | 2.5996 | 2.6025 | 2.5961 | 2.6021 | 3551296.0 |
| 2006-01-03 11:15:00 | AAPL | Stock | 2.6025 | 2.6057 | 2.6004 | 2.6036 | 7927752.0 |
| 2006-01-03 11:20:00 | AAPL | Stock | 2.6036 | 2.6071 | 2.6036 | 2.6043 | 5884592.0 |
| 2006-01-03 11:25:00 | AAPL | Stock | 2.6039 | 2.615 | 2.6021 | 2.6043 | 5578440.0 |
| 2006-01-03 11:30:00 | AAPL | Stock | 2.6046 | 2.6154 | 2.6036 | 2.6061 | 14424732.0 |
| 2006-01-03 11:35:00 | AAPL | Stock | 2.6064 | 2.6136 | 2.6061 | 2.6132 | 9340352.0 |
> showing 50 of 221,529 rows — these rows as CSV