PREVIEW / stock_5min / 2006-12-07
file: by_date/stock_5min/2006/2006-12-07.parquet size: 3.2 MB rows: 234,207 symbols: 2,460
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-12-07 06:00:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2146 | 3.2146 | 2800.0 |
| 2006-12-07 07:10:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2125 | 3.2125 | 5600.0 |
| 2006-12-07 07:20:00 | AAPL | Stock | 3.215 | 3.215 | 3.215 | 3.215 | 5600.0 |
| 2006-12-07 07:30:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 5600.0 |
| 2006-12-07 07:35:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.2182 | 3.2182 | 11200.0 |
| 2006-12-07 07:45:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.2182 | 3.2182 | 11200.0 |
| 2006-12-07 07:50:00 | AAPL | Stock | 3.2211 | 3.2232 | 3.2211 | 3.2232 | 50400.0 |
| 2006-12-07 07:55:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2168 | 3.2168 | 5600.0 |
| 2006-12-07 08:00:00 | AAPL | Stock | 3.2168 | 3.2232 | 3.2168 | 3.2214 | 259700.0 |
| 2006-12-07 08:05:00 | AAPL | Stock | 3.2214 | 3.2232 | 3.2214 | 3.2229 | 136220.0 |
| 2006-12-07 08:10:00 | AAPL | Stock | 3.2218 | 3.2232 | 3.2214 | 3.2218 | 187740.0 |
| 2006-12-07 08:15:00 | AAPL | Stock | 3.2214 | 3.2218 | 3.2179 | 3.2214 | 114800.0 |
| 2006-12-07 08:20:00 | AAPL | Stock | 3.2179 | 3.22 | 3.2179 | 3.2186 | 95004.0 |
| 2006-12-07 08:25:00 | AAPL | Stock | 3.2189 | 3.2214 | 3.2189 | 3.2196 | 172004.0 |
| 2006-12-07 08:30:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2168 | 3.2179 | 86800.0 |
| 2006-12-07 08:35:00 | AAPL | Stock | 3.2186 | 3.2196 | 3.2186 | 3.2196 | 8400.0 |
| 2006-12-07 08:40:00 | AAPL | Stock | 3.2207 | 3.2214 | 3.2186 | 3.2196 | 65800.0 |
| 2006-12-07 08:45:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2179 | 3.22 | 180600.0 |
| 2006-12-07 08:50:00 | AAPL | Stock | 3.22 | 3.2214 | 3.2196 | 3.2214 | 37520.0 |
| 2006-12-07 08:55:00 | AAPL | Stock | 3.22 | 3.2214 | 3.2196 | 3.22 | 77532.0 |
| 2006-12-07 09:00:00 | AAPL | Stock | 3.2211 | 3.2211 | 3.2204 | 3.2204 | 36400.0 |
| 2006-12-07 09:05:00 | AAPL | Stock | 3.2204 | 3.2229 | 3.2204 | 3.2204 | 324744.0 |
| 2006-12-07 09:10:00 | AAPL | Stock | 3.2207 | 3.2221 | 3.2207 | 3.2214 | 115640.0 |
| 2006-12-07 09:15:00 | AAPL | Stock | 3.2214 | 3.2261 | 3.2214 | 3.2261 | 396480.0 |
| 2006-12-07 09:20:00 | AAPL | Stock | 3.2257 | 3.2268 | 3.2214 | 3.2214 | 647080.0 |
| 2006-12-07 09:25:00 | AAPL | Stock | 3.2229 | 3.2239 | 3.2143 | 3.2154 | 2019836.0 |
| 2006-12-07 09:30:00 | AAPL | Stock | 3.2152 | 3.2321 | 3.2021 | 3.2296 | 37100140.0 |
| 2006-12-07 09:35:00 | AAPL | Stock | 3.2289 | 3.2293 | 3.2111 | 3.2139 | 16947392.0 |
| 2006-12-07 09:40:00 | AAPL | Stock | 3.2146 | 3.215 | 3.1986 | 3.2096 | 19915588.0 |
| 2006-12-07 09:45:00 | AAPL | Stock | 3.2096 | 3.2146 | 3.185 | 3.19 | 25523288.0 |
| 2006-12-07 09:50:00 | AAPL | Stock | 3.1893 | 3.205 | 3.1857 | 3.19 | 16300200.0 |
| 2006-12-07 09:55:00 | AAPL | Stock | 3.1932 | 3.2014 | 3.1857 | 3.1904 | 19730816.0 |
| 2006-12-07 10:00:00 | AAPL | Stock | 3.1907 | 3.1943 | 3.17 | 3.1746 | 32914560.0 |
| 2006-12-07 10:05:00 | AAPL | Stock | 3.175 | 3.1754 | 3.1564 | 3.1643 | 33806752.0 |
| 2006-12-07 10:10:00 | AAPL | Stock | 3.1639 | 3.1739 | 3.1554 | 3.1568 | 25711868.0 |
| 2006-12-07 10:15:00 | AAPL | Stock | 3.1571 | 3.1632 | 3.1446 | 3.1571 | 33269964.0 |
| 2006-12-07 10:20:00 | AAPL | Stock | 3.1571 | 3.1643 | 3.1525 | 3.1539 | 18050116.0 |
| 2006-12-07 10:25:00 | AAPL | Stock | 3.1539 | 3.1629 | 3.1486 | 3.1625 | 11594128.0 |
| 2006-12-07 10:30:00 | AAPL | Stock | 3.1625 | 3.1736 | 3.1579 | 3.1654 | 18320064.0 |
| 2006-12-07 10:35:00 | AAPL | Stock | 3.1657 | 3.1693 | 3.1611 | 3.1679 | 16699452.0 |
| 2006-12-07 10:40:00 | AAPL | Stock | 3.1679 | 3.1707 | 3.1486 | 3.1546 | 18338964.0 |
| 2006-12-07 10:45:00 | AAPL | Stock | 3.1539 | 3.1586 | 3.1496 | 3.1564 | 8820448.0 |
| 2006-12-07 10:50:00 | AAPL | Stock | 3.1564 | 3.1589 | 3.15 | 3.1536 | 10617124.0 |
| 2006-12-07 10:55:00 | AAPL | Stock | 3.1536 | 3.155 | 3.1446 | 3.1465 | 15868132.0 |
| 2006-12-07 11:00:00 | AAPL | Stock | 3.1464 | 3.1511 | 3.1446 | 3.1493 | 14358064.0 |
| 2006-12-07 11:05:00 | AAPL | Stock | 3.1489 | 3.1507 | 3.1282 | 3.1293 | 29857856.0 |
| 2006-12-07 11:10:00 | AAPL | Stock | 3.1294 | 3.1407 | 3.1211 | 3.1381 | 28928508.0 |
| 2006-12-07 11:15:00 | AAPL | Stock | 3.1382 | 3.1443 | 3.1329 | 3.1346 | 18152512.0 |
| 2006-12-07 11:20:00 | AAPL | Stock | 3.1346 | 3.1404 | 3.1329 | 3.1379 | 9064720.0 |
| 2006-12-07 11:25:00 | AAPL | Stock | 3.1379 | 3.1425 | 3.1354 | 3.1396 | 9660392.0 |
> showing 50 of 234,207 rows — these rows as CSV