PREVIEW / stock_5min / 2009-10-27
file: by_date/stock_5min/2009/2009-10-27.parquet size: 4.7 MB rows: 321,775 symbols: 3,405
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-27 04:20:00 | AAPL | Stock | 7.2139 | 7.2139 | 7.2139 | 7.2139 | 2800.0 |
| 2009-10-27 06:25:00 | AAPL | Stock | 7.2089 | 7.2089 | 7.2089 | 7.2089 | 5600.0 |
| 2009-10-27 07:00:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.1825 | 7.1825 | 30268.0 |
| 2009-10-27 07:20:00 | AAPL | Stock | 7.2036 | 7.2143 | 7.2036 | 7.2143 | 58240.0 |
| 2009-10-27 07:25:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.1957 | 7.2136 | 39200.0 |
| 2009-10-27 07:40:00 | AAPL | Stock | 7.2132 | 7.2132 | 7.2132 | 7.2132 | 5600.0 |
| 2009-10-27 07:45:00 | AAPL | Stock | 7.2 | 7.2 | 7.2 | 7.2 | 5600.0 |
| 2009-10-27 07:55:00 | AAPL | Stock | 7.1982 | 7.1982 | 7.1982 | 7.1982 | 8400.0 |
| 2009-10-27 08:00:00 | AAPL | Stock | 7.2125 | 7.218 | 7.2029 | 7.2089 | 214760.0 |
| 2009-10-27 08:05:00 | AAPL | Stock | 7.2161 | 7.2218 | 7.2143 | 7.2218 | 75544.0 |
| 2009-10-27 08:10:00 | AAPL | Stock | 7.2161 | 7.2193 | 7.2121 | 7.2121 | 63896.0 |
| 2009-10-27 08:15:00 | AAPL | Stock | 7.2054 | 7.2075 | 7.2036 | 7.2054 | 15512.0 |
| 2009-10-27 08:25:00 | AAPL | Stock | 7.2037 | 7.2037 | 7.2 | 7.2 | 52388.0 |
| 2009-10-27 08:30:00 | AAPL | Stock | 7.2 | 7.2018 | 7.1961 | 7.1964 | 68768.0 |
| 2009-10-27 08:35:00 | AAPL | Stock | 7.1964 | 7.2018 | 7.1961 | 7.2 | 62384.0 |
| 2009-10-27 08:40:00 | AAPL | Stock | 7.2018 | 7.2036 | 7.1996 | 7.2036 | 11200.0 |
| 2009-10-27 08:45:00 | AAPL | Stock | 7.2036 | 7.2046 | 7.2036 | 7.2046 | 14000.0 |
| 2009-10-27 08:50:00 | AAPL | Stock | 7.2004 | 7.2043 | 7.1993 | 7.2004 | 116368.0 |
| 2009-10-27 08:55:00 | AAPL | Stock | 7.2 | 7.2011 | 7.1964 | 7.1964 | 105392.0 |
| 2009-10-27 09:00:00 | AAPL | Stock | 7.1968 | 7.2046 | 7.1968 | 7.2036 | 143892.0 |
| 2009-10-27 09:05:00 | AAPL | Stock | 7.2021 | 7.2111 | 7.2014 | 7.2057 | 98000.0 |
| 2009-10-27 09:10:00 | AAPL | Stock | 7.2104 | 7.2118 | 7.2036 | 7.2071 | 99960.0 |
| 2009-10-27 09:15:00 | AAPL | Stock | 7.2039 | 7.2071 | 7.1982 | 7.1982 | 33600.0 |
| 2009-10-27 09:20:00 | AAPL | Stock | 7.2043 | 7.2046 | 7.2004 | 7.2007 | 35952.0 |
| 2009-10-27 09:25:00 | AAPL | Stock | 7.2029 | 7.2036 | 7.1964 | 7.1975 | 130200.0 |
| 2009-10-27 09:30:00 | AAPL | Stock | 7.2021 | 7.2307 | 7.1879 | 7.2121 | 16681756.0 |
| 2009-10-27 09:35:00 | AAPL | Stock | 7.2121 | 7.2432 | 7.2107 | 7.2282 | 11370604.0 |
| 2009-10-27 09:40:00 | AAPL | Stock | 7.2286 | 7.2379 | 7.2018 | 7.2192 | 8434580.0 |
| 2009-10-27 09:45:00 | AAPL | Stock | 7.2139 | 7.2187 | 7.1761 | 7.1775 | 14195692.0 |
| 2009-10-27 09:50:00 | AAPL | Stock | 7.1775 | 7.21 | 7.1775 | 7.1942 | 8829128.0 |
| 2009-10-27 09:55:00 | AAPL | Stock | 7.1943 | 7.1964 | 7.1386 | 7.1464 | 13760656.0 |
| 2009-10-27 10:00:00 | AAPL | Stock | 7.1368 | 7.1536 | 7.0357 | 7.0679 | 53227328.0 |
| 2009-10-27 10:05:00 | AAPL | Stock | 7.068 | 7.0782 | 7.0304 | 7.0639 | 26552288.0 |
| 2009-10-27 10:10:00 | AAPL | Stock | 7.0639 | 7.1143 | 7.0634 | 7.0986 | 20168316.0 |
| 2009-10-27 10:15:00 | AAPL | Stock | 7.0986 | 7.1057 | 7.0807 | 7.0839 | 10698240.0 |
| 2009-10-27 10:20:00 | AAPL | Stock | 7.0846 | 7.0929 | 7.0639 | 7.0771 | 10833676.0 |
| 2009-10-27 10:25:00 | AAPL | Stock | 7.0793 | 7.1271 | 7.0714 | 7.1261 | 14981932.0 |
| 2009-10-27 10:30:00 | AAPL | Stock | 7.1243 | 7.1286 | 7.1175 | 7.1264 | 8256052.0 |
| 2009-10-27 10:35:00 | AAPL | Stock | 7.1264 | 7.1357 | 7.1179 | 7.1254 | 8772652.0 |
| 2009-10-27 10:40:00 | AAPL | Stock | 7.125 | 7.1686 | 7.125 | 7.1593 | 17857980.0 |
| 2009-10-27 10:45:00 | AAPL | Stock | 7.1593 | 7.1593 | 7.1371 | 7.1475 | 8558620.0 |
| 2009-10-27 10:50:00 | AAPL | Stock | 7.1475 | 7.1493 | 7.1164 | 7.1268 | 8540112.0 |
| 2009-10-27 10:55:00 | AAPL | Stock | 7.125 | 7.1429 | 7.1197 | 7.1425 | 5427604.0 |
| 2009-10-27 11:00:00 | AAPL | Stock | 7.1425 | 7.1432 | 7.1261 | 7.1271 | 4969748.0 |
| 2009-10-27 11:05:00 | AAPL | Stock | 7.1268 | 7.1289 | 7.1089 | 7.1218 | 6028764.0 |
| 2009-10-27 11:10:00 | AAPL | Stock | 7.1218 | 7.1229 | 7.1075 | 7.1179 | 4161500.0 |
| 2009-10-27 11:15:00 | AAPL | Stock | 7.1165 | 7.1176 | 7.0921 | 7.0989 | 7325248.0 |
| 2009-10-27 11:20:00 | AAPL | Stock | 7.0993 | 7.1125 | 7.0936 | 7.1107 | 4959864.0 |
| 2009-10-27 11:25:00 | AAPL | Stock | 7.1096 | 7.1354 | 7.1043 | 7.1321 | 4604656.0 |
| 2009-10-27 11:30:00 | AAPL | Stock | 7.1318 | 7.1336 | 7.1118 | 7.1167 | 4249140.0 |
> showing 50 of 321,775 rows — these rows as CSV