PREVIEW / stock_5min / 2005-05-13
file: by_date/stock_5min/2005/2005-05-13.parquet size: 2.7 MB rows: 195,944 symbols: 1,975
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-13 07:15:00 | AAPL | Stock | 1.225 | 1.225 | 1.225 | 1.225 | 22400.0 |
| 2005-05-13 08:00:00 | AAPL | Stock | 1.225 | 1.2293 | 1.225 | 1.2286 | 181160.0 |
| 2005-05-13 08:05:00 | AAPL | Stock | 1.2268 | 1.2275 | 1.225 | 1.2268 | 316400.0 |
| 2005-05-13 08:10:00 | AAPL | Stock | 1.2268 | 1.2286 | 1.2261 | 1.2279 | 126000.0 |
| 2005-05-13 08:15:00 | AAPL | Stock | 1.2264 | 1.2264 | 1.2264 | 1.2264 | 16100.0 |
| 2005-05-13 08:20:00 | AAPL | Stock | 1.2264 | 1.2264 | 1.2254 | 1.2254 | 90300.0 |
| 2005-05-13 08:25:00 | AAPL | Stock | 1.2257 | 1.2264 | 1.2257 | 1.2264 | 53900.0 |
| 2005-05-13 08:30:00 | AAPL | Stock | 1.2279 | 1.2282 | 1.2279 | 1.2282 | 86800.0 |
| 2005-05-13 08:35:00 | AAPL | Stock | 1.2282 | 1.2289 | 1.2282 | 1.2286 | 285600.0 |
| 2005-05-13 08:40:00 | AAPL | Stock | 1.2286 | 1.2293 | 1.2268 | 1.2268 | 127540.0 |
| 2005-05-13 08:45:00 | AAPL | Stock | 1.2279 | 1.2293 | 1.2271 | 1.2286 | 131460.0 |
| 2005-05-13 08:50:00 | AAPL | Stock | 1.2293 | 1.2293 | 1.2286 | 1.2286 | 98140.0 |
| 2005-05-13 08:55:00 | AAPL | Stock | 1.2286 | 1.2289 | 1.2279 | 1.2286 | 146104.0 |
| 2005-05-13 09:00:00 | AAPL | Stock | 1.2275 | 1.2286 | 1.2275 | 1.2286 | 42000.0 |
| 2005-05-13 09:05:00 | AAPL | Stock | 1.2293 | 1.2293 | 1.2286 | 1.2286 | 33600.0 |
| 2005-05-13 09:10:00 | AAPL | Stock | 1.2282 | 1.2289 | 1.2282 | 1.2286 | 92400.0 |
| 2005-05-13 09:15:00 | AAPL | Stock | 1.2279 | 1.2286 | 1.2275 | 1.2286 | 122584.0 |
| 2005-05-13 09:20:00 | AAPL | Stock | 1.2286 | 1.2286 | 1.2207 | 1.2236 | 874832.0 |
| 2005-05-13 09:25:00 | AAPL | Stock | 1.2239 | 1.2246 | 1.2168 | 1.2196 | 863912.0 |
| 2005-05-13 09:30:00 | AAPL | Stock | 1.2214 | 1.2279 | 1.2182 | 1.22 | 19765452.0 |
| 2005-05-13 09:35:00 | AAPL | Stock | 1.22 | 1.23 | 1.2196 | 1.23 | 10859072.0 |
| 2005-05-13 09:40:00 | AAPL | Stock | 1.23 | 1.2318 | 1.2261 | 1.2307 | 11316956.0 |
| 2005-05-13 09:45:00 | AAPL | Stock | 1.2307 | 1.2311 | 1.2243 | 1.2257 | 14152628.0 |
| 2005-05-13 09:50:00 | AAPL | Stock | 1.225 | 1.2261 | 1.2196 | 1.2207 | 12123580.0 |
| 2005-05-13 09:55:00 | AAPL | Stock | 1.2207 | 1.2236 | 1.2168 | 1.2207 | 12523420.0 |
| 2005-05-13 10:00:00 | AAPL | Stock | 1.2207 | 1.2225 | 1.2189 | 1.2211 | 8225980.0 |
| 2005-05-13 10:05:00 | AAPL | Stock | 1.2211 | 1.2304 | 1.2211 | 1.2293 | 15169588.0 |
| 2005-05-13 10:10:00 | AAPL | Stock | 1.2289 | 1.2321 | 1.2211 | 1.2321 | 13197072.0 |
| 2005-05-13 10:15:00 | AAPL | Stock | 1.2325 | 1.2357 | 1.2314 | 1.2329 | 15073408.0 |
| 2005-05-13 10:20:00 | AAPL | Stock | 1.2329 | 1.2339 | 1.2304 | 1.2314 | 11527376.0 |
| 2005-05-13 10:25:00 | AAPL | Stock | 1.2314 | 1.2482 | 1.2296 | 1.2318 | 11301752.0 |
| 2005-05-13 10:30:00 | AAPL | Stock | 1.2318 | 1.2339 | 1.2293 | 1.2296 | 9729804.0 |
| 2005-05-13 10:35:00 | AAPL | Stock | 1.23 | 1.2371 | 1.2286 | 1.2368 | 11033428.0 |
| 2005-05-13 10:40:00 | AAPL | Stock | 1.2368 | 1.2443 | 1.2364 | 1.2439 | 19608960.0 |
| 2005-05-13 10:45:00 | AAPL | Stock | 1.2443 | 1.2457 | 1.2414 | 1.2436 | 13206256.0 |
| 2005-05-13 10:50:00 | AAPL | Stock | 1.2436 | 1.2468 | 1.2425 | 1.245 | 9923172.0 |
| 2005-05-13 10:55:00 | AAPL | Stock | 1.245 | 1.2496 | 1.2425 | 1.2489 | 18764004.0 |
| 2005-05-13 11:00:00 | AAPL | Stock | 1.2493 | 1.2496 | 1.2425 | 1.2429 | 10174808.0 |
| 2005-05-13 11:05:00 | AAPL | Stock | 1.2429 | 1.2454 | 1.2411 | 1.2432 | 10146584.0 |
| 2005-05-13 11:10:00 | AAPL | Stock | 1.2436 | 1.2443 | 1.2418 | 1.2439 | 7024640.0 |
| 2005-05-13 11:15:00 | AAPL | Stock | 1.2439 | 1.2439 | 1.2425 | 1.2425 | 5044452.0 |
| 2005-05-13 11:20:00 | AAPL | Stock | 1.2425 | 1.2429 | 1.2414 | 1.2429 | 5894952.0 |
| 2005-05-13 11:25:00 | AAPL | Stock | 1.2425 | 1.2479 | 1.2421 | 1.2475 | 11230380.0 |
| 2005-05-13 11:30:00 | AAPL | Stock | 1.2475 | 1.2482 | 1.2454 | 1.2468 | 7226072.0 |
| 2005-05-13 11:35:00 | AAPL | Stock | 1.2468 | 1.2486 | 1.2457 | 1.2482 | 4976412.0 |
| 2005-05-13 11:40:00 | AAPL | Stock | 1.2482 | 1.2496 | 1.2475 | 1.2475 | 6418020.0 |
| 2005-05-13 11:45:00 | AAPL | Stock | 1.2479 | 1.2514 | 1.2464 | 1.2504 | 17359580.0 |
| 2005-05-13 11:50:00 | AAPL | Stock | 1.2514 | 1.2557 | 1.2504 | 1.2543 | 12679576.0 |
| 2005-05-13 11:55:00 | AAPL | Stock | 1.2543 | 1.2582 | 1.2536 | 1.2543 | 13902812.0 |
| 2005-05-13 12:00:00 | AAPL | Stock | 1.255 | 1.2554 | 1.2518 | 1.2521 | 7164164.0 |
> showing 50 of 195,944 rows — these rows as CSV