PREVIEW / stock_5min / 2007-10-19
file: by_date/stock_5min/2007/2007-10-19.parquet size: 4.3 MB rows: 309,458 symbols: 3,151
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-19 04:15:00 | AAPL | Stock | 6.2 | 6.2 | 6.2 | 6.2 | 2800.0 |
| 2007-10-19 06:15:00 | AAPL | Stock | 6.2104 | 6.2104 | 6.2104 | 6.2104 | 2800.0 |
| 2007-10-19 06:45:00 | AAPL | Stock | 6.2104 | 6.2104 | 6.2104 | 6.2104 | 2800.0 |
| 2007-10-19 06:50:00 | AAPL | Stock | 6.2104 | 6.2104 | 6.2104 | 6.2104 | 11200.0 |
| 2007-10-19 07:00:00 | AAPL | Stock | 6.2107 | 6.2107 | 6.2107 | 6.2107 | 14000.0 |
| 2007-10-19 07:20:00 | AAPL | Stock | 6.2164 | 6.2164 | 6.2164 | 6.2164 | 14000.0 |
| 2007-10-19 07:35:00 | AAPL | Stock | 6.2218 | 6.2393 | 6.2179 | 6.2393 | 85400.0 |
| 2007-10-19 07:40:00 | AAPL | Stock | 6.2443 | 6.25 | 6.2357 | 6.2425 | 247884.0 |
| 2007-10-19 07:45:00 | AAPL | Stock | 6.2425 | 6.25 | 6.2425 | 6.25 | 36680.0 |
| 2007-10-19 07:50:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 8260.0 |
| 2007-10-19 07:55:00 | AAPL | Stock | 6.2464 | 6.2479 | 6.2457 | 6.2479 | 18480.0 |
| 2007-10-19 08:00:00 | AAPL | Stock | 6.2479 | 6.25 | 6.2357 | 6.2375 | 812168.0 |
| 2007-10-19 08:05:00 | AAPL | Stock | 6.2371 | 6.2446 | 6.2268 | 6.2268 | 645288.0 |
| 2007-10-19 08:10:00 | AAPL | Stock | 6.2275 | 6.2393 | 6.2264 | 6.2361 | 537040.0 |
| 2007-10-19 08:15:00 | AAPL | Stock | 6.2371 | 6.2461 | 6.2371 | 6.2461 | 904596.0 |
| 2007-10-19 08:20:00 | AAPL | Stock | 6.2418 | 6.2432 | 6.2271 | 6.2271 | 1028356.0 |
| 2007-10-19 08:25:00 | AAPL | Stock | 6.2279 | 6.2411 | 6.2279 | 6.2357 | 477064.0 |
| 2007-10-19 08:30:00 | AAPL | Stock | 6.2364 | 6.2429 | 6.2364 | 6.2418 | 570332.0 |
| 2007-10-19 08:35:00 | AAPL | Stock | 6.2429 | 6.2446 | 6.2321 | 6.2361 | 768040.0 |
| 2007-10-19 08:40:00 | AAPL | Stock | 6.2357 | 6.2386 | 6.2321 | 6.2325 | 300132.0 |
| 2007-10-19 08:45:00 | AAPL | Stock | 6.2332 | 6.2371 | 6.2214 | 6.2314 | 1040816.0 |
| 2007-10-19 08:50:00 | AAPL | Stock | 6.23 | 6.2339 | 6.2268 | 6.2268 | 236320.0 |
| 2007-10-19 08:55:00 | AAPL | Stock | 6.2282 | 6.2304 | 6.2257 | 6.2296 | 213724.0 |
| 2007-10-19 09:00:00 | AAPL | Stock | 6.23 | 6.2375 | 6.2293 | 6.2346 | 293944.0 |
| 2007-10-19 09:05:00 | AAPL | Stock | 6.2375 | 6.2411 | 6.2361 | 6.2389 | 457660.0 |
| 2007-10-19 09:10:00 | AAPL | Stock | 6.2404 | 6.2414 | 6.2336 | 6.2389 | 516488.0 |
| 2007-10-19 09:15:00 | AAPL | Stock | 6.2389 | 6.2404 | 6.2257 | 6.2271 | 565404.0 |
| 2007-10-19 09:20:00 | AAPL | Stock | 6.2289 | 6.23 | 6.215 | 6.2154 | 1306452.0 |
| 2007-10-19 09:25:00 | AAPL | Stock | 6.2171 | 6.2225 | 6.2064 | 6.2214 | 1647016.0 |
| 2007-10-19 09:30:00 | AAPL | Stock | 6.2225 | 6.23 | 6.2143 | 6.23 | 87962812.0 |
| 2007-10-19 09:35:00 | AAPL | Stock | 6.23 | 6.2368 | 6.1846 | 6.1939 | 29731968.0 |
| 2007-10-19 09:40:00 | AAPL | Stock | 6.1939 | 6.2179 | 6.1936 | 6.2104 | 18366320.0 |
| 2007-10-19 09:45:00 | AAPL | Stock | 6.2107 | 6.225 | 6.2064 | 6.2193 | 15704136.0 |
| 2007-10-19 09:50:00 | AAPL | Stock | 6.2189 | 6.225 | 6.2075 | 6.2093 | 14189476.0 |
| 2007-10-19 09:55:00 | AAPL | Stock | 6.209 | 6.2164 | 6.1968 | 6.2143 | 14762216.0 |
| 2007-10-19 10:00:00 | AAPL | Stock | 6.2157 | 6.2204 | 6.1807 | 6.1868 | 18503688.0 |
| 2007-10-19 10:05:00 | AAPL | Stock | 6.1864 | 6.1864 | 6.1393 | 6.1693 | 38008768.0 |
| 2007-10-19 10:10:00 | AAPL | Stock | 6.1714 | 6.1732 | 6.1504 | 6.1568 | 19810756.0 |
| 2007-10-19 10:15:00 | AAPL | Stock | 6.1568 | 6.1661 | 6.1479 | 6.1607 | 16150008.0 |
| 2007-10-19 10:20:00 | AAPL | Stock | 6.1611 | 6.1843 | 6.1564 | 6.1811 | 17687432.0 |
| 2007-10-19 10:25:00 | AAPL | Stock | 6.1817 | 6.1875 | 6.1757 | 6.1875 | 13768720.0 |
| 2007-10-19 10:30:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1625 | 6.1714 | 14819952.0 |
| 2007-10-19 10:35:00 | AAPL | Stock | 6.1714 | 6.1779 | 6.1614 | 6.1625 | 15618232.0 |
| 2007-10-19 10:40:00 | AAPL | Stock | 6.1629 | 6.1632 | 6.1421 | 6.1439 | 21442428.0 |
| 2007-10-19 10:45:00 | AAPL | Stock | 6.1436 | 6.1518 | 6.1143 | 6.1357 | 26692540.0 |
| 2007-10-19 10:50:00 | AAPL | Stock | 6.1354 | 6.1414 | 6.125 | 6.1336 | 12083064.0 |
| 2007-10-19 10:55:00 | AAPL | Stock | 6.1332 | 6.1346 | 6.0893 | 6.0893 | 29122156.0 |
| 2007-10-19 11:00:00 | AAPL | Stock | 6.0914 | 6.1154 | 6.0893 | 6.1043 | 19004664.0 |
| 2007-10-19 11:05:00 | AAPL | Stock | 6.105 | 6.1271 | 6.1046 | 6.1229 | 15844780.0 |
| 2007-10-19 11:10:00 | AAPL | Stock | 6.1229 | 6.14 | 6.1168 | 6.1368 | 14579124.0 |
> showing 50 of 309,458 rows — these rows as CSV