PREVIEW / stock_5min / 2010-06-04
file: by_date/stock_5min/2010/2010-06-04.parquet size: 4.9 MB rows: 335,359 symbols: 3,472
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-04 04:25:00 | AAPL | Stock | 9.4279 | 9.4279 | 9.4279 | 9.4279 | 8400.0 |
| 2010-06-04 05:05:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 23772.0 |
| 2010-06-04 06:00:00 | AAPL | Stock | 9.4375 | 9.4375 | 9.4375 | 9.4375 | 2800.0 |
| 2010-06-04 06:10:00 | AAPL | Stock | 9.4375 | 9.4554 | 9.4375 | 9.4554 | 8400.0 |
| 2010-06-04 06:35:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4196 | 9.4196 | 13160.0 |
| 2010-06-04 06:50:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4071 | 9.4071 | 19740.0 |
| 2010-06-04 07:00:00 | AAPL | Stock | 9.4018 | 9.4182 | 9.3929 | 9.3929 | 70000.0 |
| 2010-06-04 07:05:00 | AAPL | Stock | 9.3539 | 9.3539 | 9.3539 | 9.3539 | 5600.0 |
| 2010-06-04 07:10:00 | AAPL | Stock | 9.3871 | 9.3871 | 9.3679 | 9.3679 | 22400.0 |
| 2010-06-04 07:15:00 | AAPL | Stock | 9.3661 | 9.3661 | 9.3661 | 9.3661 | 12852.0 |
| 2010-06-04 07:20:00 | AAPL | Stock | 9.3661 | 9.3661 | 9.3661 | 9.3661 | 5600.0 |
| 2010-06-04 07:30:00 | AAPL | Stock | 9.3661 | 9.3661 | 9.3564 | 9.3564 | 13300.0 |
| 2010-06-04 07:35:00 | AAPL | Stock | 9.3571 | 9.3571 | 9.3518 | 9.3539 | 25900.0 |
| 2010-06-04 07:40:00 | AAPL | Stock | 9.3396 | 9.3439 | 9.31 | 9.3439 | 48608.0 |
| 2010-06-04 07:45:00 | AAPL | Stock | 9.3214 | 9.3214 | 9.3211 | 9.3214 | 19600.0 |
| 2010-06-04 07:50:00 | AAPL | Stock | 9.3211 | 9.3321 | 9.3211 | 9.3321 | 8400.0 |
| 2010-06-04 07:55:00 | AAPL | Stock | 9.3286 | 9.3557 | 9.3179 | 9.3179 | 248500.0 |
| 2010-06-04 08:00:00 | AAPL | Stock | 9.3214 | 9.3532 | 9.3214 | 9.3532 | 203168.0 |
| 2010-06-04 08:05:00 | AAPL | Stock | 9.3521 | 9.3607 | 9.3518 | 9.3579 | 314356.0 |
| 2010-06-04 08:10:00 | AAPL | Stock | 9.3568 | 9.3611 | 9.35 | 9.36 | 161700.0 |
| 2010-06-04 08:15:00 | AAPL | Stock | 9.3643 | 9.3643 | 9.3518 | 9.3607 | 327992.0 |
| 2010-06-04 08:20:00 | AAPL | Stock | 9.3607 | 9.3661 | 9.3571 | 9.3579 | 196532.0 |
| 2010-06-04 08:25:00 | AAPL | Stock | 9.3607 | 9.3607 | 9.3504 | 9.3586 | 196448.0 |
| 2010-06-04 08:30:00 | AAPL | Stock | 9.3511 | 9.3511 | 9.2418 | 9.2614 | 3205832.0 |
| 2010-06-04 08:35:00 | AAPL | Stock | 9.2643 | 9.2654 | 9.2146 | 9.2429 | 2785804.0 |
| 2010-06-04 08:40:00 | AAPL | Stock | 9.2429 | 9.2571 | 9.2286 | 9.2507 | 1296680.0 |
| 2010-06-04 08:45:00 | AAPL | Stock | 9.2543 | 9.2636 | 9.2418 | 9.2418 | 951076.0 |
| 2010-06-04 08:50:00 | AAPL | Stock | 9.2436 | 9.2496 | 9.2339 | 9.2375 | 776944.0 |
| 2010-06-04 08:55:00 | AAPL | Stock | 9.2368 | 9.2368 | 9.2236 | 9.2357 | 792204.0 |
| 2010-06-04 09:00:00 | AAPL | Stock | 9.2368 | 9.2387 | 9.2254 | 9.2286 | 364700.0 |
| 2010-06-04 09:05:00 | AAPL | Stock | 9.2259 | 9.2311 | 9.2054 | 9.2143 | 892024.0 |
| 2010-06-04 09:10:00 | AAPL | Stock | 9.2136 | 9.2175 | 9.2029 | 9.2057 | 706356.0 |
| 2010-06-04 09:15:00 | AAPL | Stock | 9.2061 | 9.2082 | 9.185 | 9.1911 | 680428.0 |
| 2010-06-04 09:20:00 | AAPL | Stock | 9.1946 | 9.2032 | 9.1821 | 9.2032 | 788816.0 |
| 2010-06-04 09:25:00 | AAPL | Stock | 9.1971 | 9.2246 | 9.1964 | 9.2207 | 762496.0 |
| 2010-06-04 09:30:00 | AAPL | Stock | 9.2218 | 9.2675 | 9.1821 | 9.26 | 33156928.0 |
| 2010-06-04 09:35:00 | AAPL | Stock | 9.2589 | 9.2854 | 9.2571 | 9.2629 | 17649772.0 |
| 2010-06-04 09:40:00 | AAPL | Stock | 9.2639 | 9.2818 | 9.2557 | 9.2639 | 14728840.0 |
| 2010-06-04 09:45:00 | AAPL | Stock | 9.2657 | 9.3264 | 9.2511 | 9.3261 | 22621144.0 |
| 2010-06-04 09:50:00 | AAPL | Stock | 9.325 | 9.3514 | 9.3154 | 9.3332 | 22079148.0 |
| 2010-06-04 09:55:00 | AAPL | Stock | 9.3332 | 9.3525 | 9.3161 | 9.32 | 14342944.0 |
| 2010-06-04 10:00:00 | AAPL | Stock | 9.3196 | 9.3211 | 9.2929 | 9.3025 | 12088272.0 |
| 2010-06-04 10:05:00 | AAPL | Stock | 9.3031 | 9.3285 | 9.295 | 9.3254 | 8624224.0 |
| 2010-06-04 10:10:00 | AAPL | Stock | 9.3268 | 9.3536 | 9.3182 | 9.3486 | 14169568.0 |
| 2010-06-04 10:15:00 | AAPL | Stock | 9.3473 | 9.35 | 9.3286 | 9.3445 | 9716028.0 |
| 2010-06-04 10:20:00 | AAPL | Stock | 9.3446 | 9.3464 | 9.3275 | 9.3371 | 8760360.0 |
| 2010-06-04 10:25:00 | AAPL | Stock | 9.3371 | 9.3443 | 9.3214 | 9.3346 | 10290448.0 |
| 2010-06-04 10:30:00 | AAPL | Stock | 9.3343 | 9.3352 | 9.3079 | 9.31 | 10086160.0 |
| 2010-06-04 10:35:00 | AAPL | Stock | 9.3102 | 9.3296 | 9.3071 | 9.3268 | 5824504.0 |
| 2010-06-04 10:40:00 | AAPL | Stock | 9.3286 | 9.3393 | 9.3204 | 9.3286 | 5734764.0 |
> showing 50 of 335,359 rows — these rows as CSV