PREVIEW / stock_5min / 2011-01-03
file: by_date/stock_5min/2011/2011-01-03.parquet size: 5.0 MB rows: 343,607 symbols: 3,538
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-03 04:00:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.5714 | 11.5714 | 16800.0 |
| 2011-01-03 04:10:00 | AAPL | Stock | 11.5839 | 11.5839 | 11.5839 | 11.5839 | 2800.0 |
| 2011-01-03 04:15:00 | AAPL | Stock | 11.5929 | 11.5929 | 11.5929 | 11.5929 | 10080.0 |
| 2011-01-03 04:45:00 | AAPL | Stock | 11.5968 | 11.5968 | 11.5968 | 11.5968 | 5600.0 |
| 2011-01-03 05:00:00 | AAPL | Stock | 11.6064 | 11.6064 | 11.6064 | 11.6064 | 2800.0 |
| 2011-01-03 05:35:00 | AAPL | Stock | 11.6371 | 11.6371 | 11.6371 | 11.6371 | 2800.0 |
| 2011-01-03 05:40:00 | AAPL | Stock | 11.6211 | 11.6211 | 11.6179 | 11.6179 | 8400.0 |
| 2011-01-03 05:45:00 | AAPL | Stock | 11.6096 | 11.6096 | 11.6096 | 11.6096 | 2800.0 |
| 2011-01-03 06:20:00 | AAPL | Stock | 11.6339 | 11.6339 | 11.6339 | 11.6339 | 2800.0 |
| 2011-01-03 06:25:00 | AAPL | Stock | 11.62 | 11.62 | 11.62 | 11.62 | 2800.0 |
| 2011-01-03 06:45:00 | AAPL | Stock | 11.6236 | 11.6236 | 11.6236 | 11.6236 | 2800.0 |
| 2011-01-03 06:55:00 | AAPL | Stock | 11.6229 | 11.6229 | 11.6229 | 11.6229 | 5600.0 |
| 2011-01-03 07:00:00 | AAPL | Stock | 11.6143 | 11.6214 | 11.5982 | 11.6143 | 46928.0 |
| 2011-01-03 07:05:00 | AAPL | Stock | 11.6121 | 11.6121 | 11.5893 | 11.5893 | 51828.0 |
| 2011-01-03 07:10:00 | AAPL | Stock | 11.5886 | 11.5893 | 11.585 | 11.5893 | 45332.0 |
| 2011-01-03 07:15:00 | AAPL | Stock | 11.5846 | 11.5893 | 11.5846 | 11.5886 | 22400.0 |
| 2011-01-03 07:20:00 | AAPL | Stock | 11.5893 | 11.5896 | 11.5889 | 11.5896 | 34832.0 |
| 2011-01-03 07:25:00 | AAPL | Stock | 11.5979 | 11.6 | 11.5946 | 11.6 | 17080.0 |
| 2011-01-03 07:30:00 | AAPL | Stock | 11.6007 | 11.6071 | 11.6004 | 11.6071 | 36400.0 |
| 2011-01-03 07:35:00 | AAPL | Stock | 11.6071 | 11.6139 | 11.6071 | 11.6139 | 33600.0 |
| 2011-01-03 07:40:00 | AAPL | Stock | 11.6121 | 11.6143 | 11.6121 | 11.6143 | 75600.0 |
| 2011-01-03 07:45:00 | AAPL | Stock | 11.6236 | 11.6243 | 11.6236 | 11.6239 | 30940.0 |
| 2011-01-03 07:50:00 | AAPL | Stock | 11.6161 | 11.6196 | 11.6143 | 11.6193 | 14000.0 |
| 2011-01-03 07:55:00 | AAPL | Stock | 11.6193 | 11.6321 | 11.6193 | 11.6321 | 104804.0 |
| 2011-01-03 08:00:00 | AAPL | Stock | 11.6182 | 11.6329 | 11.6071 | 11.6143 | 433356.0 |
| 2011-01-03 08:05:00 | AAPL | Stock | 11.6143 | 11.6143 | 11.6107 | 11.6111 | 141820.0 |
| 2011-01-03 08:10:00 | AAPL | Stock | 11.6089 | 11.6143 | 11.6075 | 11.6125 | 89600.0 |
| 2011-01-03 08:15:00 | AAPL | Stock | 11.6107 | 11.6125 | 11.6086 | 11.6125 | 74424.0 |
| 2011-01-03 08:20:00 | AAPL | Stock | 11.6089 | 11.6107 | 11.6061 | 11.6071 | 157472.0 |
| 2011-01-03 08:25:00 | AAPL | Stock | 11.6068 | 11.6107 | 11.5996 | 11.6071 | 414596.0 |
| 2011-01-03 08:30:00 | AAPL | Stock | 11.52 | 11.6061 | 11.52 | 11.5979 | 85288.0 |
| 2011-01-03 08:35:00 | AAPL | Stock | 11.5964 | 11.605 | 11.5932 | 11.6018 | 91364.0 |
| 2011-01-03 08:40:00 | AAPL | Stock | 11.5989 | 11.6 | 11.5936 | 11.5986 | 276416.0 |
| 2011-01-03 08:45:00 | AAPL | Stock | 11.6011 | 11.6046 | 11.6 | 11.6 | 78540.0 |
| 2011-01-03 08:50:00 | AAPL | Stock | 11.5982 | 11.6071 | 11.5964 | 11.6071 | 242060.0 |
| 2011-01-03 08:55:00 | AAPL | Stock | 11.6036 | 11.6071 | 11.6 | 11.6 | 204092.0 |
| 2011-01-03 09:00:00 | AAPL | Stock | 11.6007 | 11.6007 | 11.5961 | 11.5961 | 64400.0 |
| 2011-01-03 09:05:00 | AAPL | Stock | 11.5982 | 11.6057 | 11.52 | 11.6036 | 133420.0 |
| 2011-01-03 09:10:00 | AAPL | Stock | 11.6061 | 11.6121 | 11.6054 | 11.61 | 253988.0 |
| 2011-01-03 09:15:00 | AAPL | Stock | 11.61 | 11.6107 | 11.52 | 11.6054 | 237944.0 |
| 2011-01-03 09:20:00 | AAPL | Stock | 11.605 | 11.6089 | 11.605 | 11.6089 | 190372.0 |
| 2011-01-03 09:25:00 | AAPL | Stock | 11.6089 | 11.6296 | 11.6061 | 11.6296 | 869624.0 |
| 2011-01-03 09:30:00 | AAPL | Stock | 11.63 | 11.6429 | 11.6013 | 11.6207 | 19364688.0 |
| 2011-01-03 09:35:00 | AAPL | Stock | 11.6221 | 11.6693 | 11.6214 | 11.6625 | 14899920.0 |
| 2011-01-03 09:40:00 | AAPL | Stock | 11.6607 | 11.6921 | 11.6561 | 11.6868 | 19191032.0 |
| 2011-01-03 09:45:00 | AAPL | Stock | 11.6871 | 11.7096 | 11.6864 | 11.7075 | 11487952.0 |
| 2011-01-03 09:50:00 | AAPL | Stock | 11.7071 | 11.7096 | 11.6829 | 11.6925 | 10393936.0 |
| 2011-01-03 09:55:00 | AAPL | Stock | 11.6925 | 11.7054 | 11.6914 | 11.6954 | 7286468.0 |
| 2011-01-03 10:00:00 | AAPL | Stock | 11.6952 | 11.7089 | 11.6918 | 11.7071 | 7332304.0 |
| 2011-01-03 10:05:00 | AAPL | Stock | 11.7086 | 11.7264 | 11.7014 | 11.725 | 13619452.0 |
> showing 50 of 343,607 rows — these rows as CSV