PREVIEW / stock_5min / 2010-11-04
file: by_date/stock_5min/2010/2010-11-04.parquet size: 5.1 MB rows: 344,462 symbols: 3,518
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-11-04 04:00:00 | AAPL | Stock | 11.1907 | 11.1961 | 11.1789 | 11.1961 | 14280.0 |
| 2010-11-04 04:20:00 | AAPL | Stock | 11.2143 | 11.2143 | 11.2143 | 11.2143 | 2800.0 |
| 2010-11-04 04:45:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 2800.0 |
| 2010-11-04 06:35:00 | AAPL | Stock | 11.2554 | 11.2554 | 11.2554 | 11.2554 | 5600.0 |
| 2010-11-04 07:00:00 | AAPL | Stock | 11.2668 | 11.2775 | 11.2668 | 11.2675 | 22400.0 |
| 2010-11-04 07:05:00 | AAPL | Stock | 11.27 | 11.275 | 11.2679 | 11.2679 | 15400.0 |
| 2010-11-04 07:10:00 | AAPL | Stock | 11.2571 | 11.2589 | 11.2571 | 11.2571 | 11200.0 |
| 2010-11-04 07:15:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2643 | 11.2679 | 35980.0 |
| 2010-11-04 07:20:00 | AAPL | Stock | 11.2668 | 11.2668 | 11.2357 | 11.2357 | 167636.0 |
| 2010-11-04 07:25:00 | AAPL | Stock | 11.2393 | 11.2393 | 11.2393 | 11.2393 | 17640.0 |
| 2010-11-04 07:30:00 | AAPL | Stock | 11.2396 | 11.245 | 11.2375 | 11.2436 | 28000.0 |
| 2010-11-04 07:35:00 | AAPL | Stock | 11.2446 | 11.2446 | 11.2404 | 11.2443 | 8400.0 |
| 2010-11-04 07:40:00 | AAPL | Stock | 11.2404 | 11.2432 | 11.2386 | 11.2432 | 19040.0 |
| 2010-11-04 07:45:00 | AAPL | Stock | 11.2429 | 11.2443 | 11.2364 | 11.2443 | 70000.0 |
| 2010-11-04 07:50:00 | AAPL | Stock | 11.2425 | 11.2443 | 11.2425 | 11.2443 | 19600.0 |
| 2010-11-04 07:55:00 | AAPL | Stock | 11.2436 | 11.2464 | 11.2429 | 11.2464 | 42000.0 |
| 2010-11-04 08:00:00 | AAPL | Stock | 11.2464 | 11.2571 | 11.245 | 11.25 | 934220.0 |
| 2010-11-04 08:05:00 | AAPL | Stock | 11.2525 | 11.2529 | 11.2464 | 11.2496 | 196476.0 |
| 2010-11-04 08:10:00 | AAPL | Stock | 11.25 | 11.255 | 11.2439 | 11.2521 | 257852.0 |
| 2010-11-04 08:15:00 | AAPL | Stock | 11.2536 | 11.2579 | 11.2521 | 11.2557 | 446768.0 |
| 2010-11-04 08:20:00 | AAPL | Stock | 11.2571 | 11.2596 | 11.2571 | 11.2589 | 260960.0 |
| 2010-11-04 08:25:00 | AAPL | Stock | 11.2593 | 11.2657 | 11.2561 | 11.2657 | 339136.0 |
| 2010-11-04 08:30:00 | AAPL | Stock | 11.2657 | 11.2679 | 11.2539 | 11.2679 | 283024.0 |
| 2010-11-04 08:35:00 | AAPL | Stock | 11.2679 | 11.2764 | 11.2639 | 11.2764 | 648984.0 |
| 2010-11-04 08:40:00 | AAPL | Stock | 11.2761 | 11.2825 | 11.275 | 11.2786 | 351260.0 |
| 2010-11-04 08:45:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.2707 | 11.2786 | 424284.0 |
| 2010-11-04 08:50:00 | AAPL | Stock | 11.2775 | 11.2889 | 11.275 | 11.2879 | 492464.0 |
| 2010-11-04 08:55:00 | AAPL | Stock | 11.2875 | 11.2943 | 11.2821 | 11.2854 | 663292.0 |
| 2010-11-04 09:00:00 | AAPL | Stock | 11.285 | 11.2889 | 11.2821 | 11.2875 | 274176.0 |
| 2010-11-04 09:05:00 | AAPL | Stock | 11.2871 | 11.2886 | 11.2736 | 11.275 | 820764.0 |
| 2010-11-04 09:10:00 | AAPL | Stock | 11.2771 | 11.2786 | 11.2689 | 11.2714 | 147560.0 |
| 2010-11-04 09:15:00 | AAPL | Stock | 11.2743 | 11.2857 | 11.2732 | 11.2807 | 253652.0 |
| 2010-11-04 09:20:00 | AAPL | Stock | 11.2814 | 11.2832 | 11.2786 | 11.2804 | 111020.0 |
| 2010-11-04 09:25:00 | AAPL | Stock | 11.2793 | 11.2818 | 11.2643 | 11.2654 | 1413608.0 |
| 2010-11-04 09:30:00 | AAPL | Stock | 11.2661 | 11.2857 | 11.2511 | 11.2843 | 24227196.0 |
| 2010-11-04 09:35:00 | AAPL | Stock | 11.2848 | 11.3168 | 11.2693 | 11.3157 | 22529276.0 |
| 2010-11-04 09:40:00 | AAPL | Stock | 11.3154 | 11.3443 | 11.315 | 11.3243 | 19485060.0 |
| 2010-11-04 09:45:00 | AAPL | Stock | 11.3246 | 11.3261 | 11.3154 | 11.3182 | 12606272.0 |
| 2010-11-04 09:50:00 | AAPL | Stock | 11.319 | 11.3418 | 11.3157 | 11.3286 | 11621708.0 |
| 2010-11-04 09:55:00 | AAPL | Stock | 11.3293 | 11.3332 | 11.3229 | 11.3287 | 6539120.0 |
| 2010-11-04 10:00:00 | AAPL | Stock | 11.3298 | 11.3339 | 11.2946 | 11.3036 | 12397560.0 |
| 2010-11-04 10:05:00 | AAPL | Stock | 11.3036 | 11.3079 | 11.2932 | 11.3014 | 7370524.0 |
| 2010-11-04 10:10:00 | AAPL | Stock | 11.3014 | 11.3161 | 11.2975 | 11.3143 | 6232604.0 |
| 2010-11-04 10:15:00 | AAPL | Stock | 11.3146 | 11.325 | 11.3107 | 11.32 | 7390348.0 |
| 2010-11-04 10:20:00 | AAPL | Stock | 11.3196 | 11.325 | 11.3075 | 11.3246 | 6486564.0 |
| 2010-11-04 10:25:00 | AAPL | Stock | 11.3229 | 11.3268 | 11.3125 | 11.3176 | 6205864.0 |
| 2010-11-04 10:30:00 | AAPL | Stock | 11.3175 | 11.3332 | 11.3143 | 11.3321 | 6651316.0 |
| 2010-11-04 10:35:00 | AAPL | Stock | 11.3321 | 11.3393 | 11.3268 | 11.3368 | 6431740.0 |
| 2010-11-04 10:40:00 | AAPL | Stock | 11.3368 | 11.3571 | 11.3343 | 11.3568 | 16601536.0 |
| 2010-11-04 10:45:00 | AAPL | Stock | 11.3557 | 11.3857 | 11.3471 | 11.3829 | 17527188.0 |
> showing 50 of 344,462 rows — these rows as CSV