PREVIEW / stock_5min / 2007-06-14
file: by_date/stock_5min/2007/2007-06-14.parquet size: 3.9 MB rows: 290,991 symbols: 3,028
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-06-14 09:30:00 | AAPL | Stock | 4.1857 | 4.1861 | 4.1579 | 4.1789 | 39335772.0 |
| 2007-06-14 09:35:00 | AAPL | Stock | 4.1789 | 4.1875 | 4.1721 | 4.18 | 25272492.0 |
| 2007-06-14 09:40:00 | AAPL | Stock | 4.1793 | 4.2243 | 4.1786 | 4.2175 | 45622948.0 |
| 2007-06-14 09:45:00 | AAPL | Stock | 4.2175 | 4.2604 | 4.2111 | 4.2589 | 50875832.0 |
| 2007-06-14 09:50:00 | AAPL | Stock | 4.2589 | 4.2593 | 4.2304 | 4.2368 | 37009028.0 |
| 2007-06-14 09:55:00 | AAPL | Stock | 4.2357 | 4.25 | 4.2311 | 4.2475 | 22976520.0 |
| 2007-06-14 10:00:00 | AAPL | Stock | 4.2475 | 4.2554 | 4.2339 | 4.2414 | 27914740.0 |
| 2007-06-14 10:05:00 | AAPL | Stock | 4.2418 | 4.2439 | 4.2257 | 4.2289 | 19487608.0 |
| 2007-06-14 10:10:00 | AAPL | Stock | 4.2293 | 4.2314 | 4.2214 | 4.2254 | 19111344.0 |
| 2007-06-14 10:15:00 | AAPL | Stock | 4.2257 | 4.2446 | 4.2254 | 4.2314 | 17611440.0 |
| 2007-06-14 10:20:00 | AAPL | Stock | 4.2318 | 4.2332 | 4.2214 | 4.2279 | 13691412.0 |
| 2007-06-14 10:25:00 | AAPL | Stock | 4.2275 | 4.2354 | 4.2232 | 4.235 | 11840612.0 |
| 2007-06-14 10:30:00 | AAPL | Stock | 4.2354 | 4.245 | 4.2304 | 4.2439 | 17739876.0 |
| 2007-06-14 10:35:00 | AAPL | Stock | 4.2439 | 4.2489 | 4.2368 | 4.2421 | 13639920.0 |
| 2007-06-14 10:40:00 | AAPL | Stock | 4.2421 | 4.2464 | 4.2329 | 4.2329 | 11513292.0 |
| 2007-06-14 10:45:00 | AAPL | Stock | 4.2329 | 4.2379 | 4.2179 | 4.22 | 16324952.0 |
| 2007-06-14 10:50:00 | AAPL | Stock | 4.2196 | 4.2286 | 4.2171 | 4.2275 | 15228108.0 |
| 2007-06-14 10:55:00 | AAPL | Stock | 4.2275 | 4.2304 | 4.2204 | 4.2214 | 8715588.0 |
| 2007-06-14 11:00:00 | AAPL | Stock | 4.2218 | 4.2307 | 4.2214 | 4.2304 | 7883932.0 |
| 2007-06-14 11:05:00 | AAPL | Stock | 4.2293 | 4.2321 | 4.225 | 4.2261 | 9304428.0 |
| 2007-06-14 11:10:00 | AAPL | Stock | 4.2257 | 4.24 | 4.2257 | 4.2329 | 13718572.0 |
| 2007-06-14 11:15:00 | AAPL | Stock | 4.2329 | 4.2393 | 4.2311 | 4.2345 | 9108008.0 |
| 2007-06-14 11:20:00 | AAPL | Stock | 4.2346 | 4.2375 | 4.2268 | 4.2314 | 8136940.0 |
| 2007-06-14 11:25:00 | AAPL | Stock | 4.2314 | 4.2364 | 4.2304 | 4.2346 | 5108936.0 |
| 2007-06-14 11:30:00 | AAPL | Stock | 4.2343 | 4.2443 | 4.2343 | 4.2382 | 11092060.0 |
| 2007-06-14 11:35:00 | AAPL | Stock | 4.2382 | 4.2389 | 4.2304 | 4.2336 | 6404216.0 |
| 2007-06-14 11:40:00 | AAPL | Stock | 4.2336 | 4.2368 | 4.2314 | 4.2354 | 5082448.0 |
| 2007-06-14 11:45:00 | AAPL | Stock | 4.2355 | 4.2357 | 4.2218 | 4.2225 | 8722308.0 |
| 2007-06-14 11:50:00 | AAPL | Stock | 4.2221 | 4.23 | 4.2214 | 4.2271 | 10267460.0 |
| 2007-06-14 11:55:00 | AAPL | Stock | 4.2275 | 4.2275 | 4.2171 | 4.2225 | 8989652.0 |
| 2007-06-14 12:00:00 | AAPL | Stock | 4.2225 | 4.2286 | 4.2218 | 4.2264 | 5205284.0 |
| 2007-06-14 12:05:00 | AAPL | Stock | 4.2279 | 4.2293 | 4.2211 | 4.2268 | 5709032.0 |
| 2007-06-14 12:10:00 | AAPL | Stock | 4.2267 | 4.2329 | 4.2264 | 4.23 | 4927132.0 |
| 2007-06-14 12:15:00 | AAPL | Stock | 4.23 | 4.2318 | 4.2261 | 4.2289 | 3879708.0 |
| 2007-06-14 12:20:00 | AAPL | Stock | 4.2289 | 4.2304 | 4.2232 | 4.2236 | 4753700.0 |
| 2007-06-14 12:25:00 | AAPL | Stock | 4.2232 | 4.2307 | 4.2221 | 4.2293 | 4161360.0 |
| 2007-06-14 12:30:00 | AAPL | Stock | 4.2293 | 4.2354 | 4.2286 | 4.2321 | 5789616.0 |
| 2007-06-14 12:35:00 | AAPL | Stock | 4.2321 | 4.2343 | 4.2289 | 4.2336 | 3622388.0 |
| 2007-06-14 12:40:00 | AAPL | Stock | 4.2336 | 4.2429 | 4.2318 | 4.2393 | 7097216.0 |
| 2007-06-14 12:45:00 | AAPL | Stock | 4.2393 | 4.2471 | 4.2393 | 4.2449 | 8669304.0 |
| 2007-06-14 12:50:00 | AAPL | Stock | 4.2443 | 4.2446 | 4.2364 | 4.2389 | 5878404.0 |
| 2007-06-14 12:55:00 | AAPL | Stock | 4.2389 | 4.2457 | 4.2379 | 4.2418 | 5578608.0 |
| 2007-06-14 13:00:00 | AAPL | Stock | 4.2418 | 4.2557 | 4.2393 | 4.255 | 13225072.0 |
| 2007-06-14 13:05:00 | AAPL | Stock | 4.2546 | 4.2589 | 4.25 | 4.2575 | 13155716.0 |
| 2007-06-14 13:10:00 | AAPL | Stock | 4.2571 | 4.2661 | 4.2568 | 4.2614 | 18317320.0 |
| 2007-06-14 13:15:00 | AAPL | Stock | 4.2611 | 4.2625 | 4.2518 | 4.2518 | 9689736.0 |
| 2007-06-14 13:20:00 | AAPL | Stock | 4.2525 | 4.2554 | 4.2504 | 4.2504 | 7071316.0 |
| 2007-06-14 13:25:00 | AAPL | Stock | 4.2506 | 4.2521 | 4.25 | 4.25 | 8202180.0 |
| 2007-06-14 13:30:00 | AAPL | Stock | 4.2504 | 4.2507 | 4.2393 | 4.2436 | 12498136.0 |
| 2007-06-14 13:35:00 | AAPL | Stock | 4.2439 | 4.2439 | 4.2315 | 4.2421 | 9099748.0 |
> showing 50 of 290,991 rows — these rows as CSV