PREVIEW / stock_5min / 2009-11-24
file: by_date/stock_5min/2009/2009-11-24.parquet size: 4.5 MB rows: 310,736 symbols: 3,416
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-24 05:15:00 | AAPL | Stock | 7.3514 | 7.3514 | 7.3514 | 7.3514 | 40040.0 |
| 2009-11-24 05:25:00 | AAPL | Stock | 7.3054 | 7.3054 | 7.3054 | 7.3054 | 3472.0 |
| 2009-11-24 07:25:00 | AAPL | Stock | 7.3468 | 7.3468 | 7.3468 | 7.3468 | 11200.0 |
| 2009-11-24 07:30:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-11-24 07:35:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 8400.0 |
| 2009-11-24 07:40:00 | AAPL | Stock | 7.35 | 7.35 | 7.3418 | 7.3418 | 15400.0 |
| 2009-11-24 07:50:00 | AAPL | Stock | 7.3421 | 7.3421 | 7.3421 | 7.3421 | 2800.0 |
| 2009-11-24 07:55:00 | AAPL | Stock | 7.3418 | 7.3418 | 7.3418 | 7.3418 | 25200.0 |
| 2009-11-24 08:00:00 | AAPL | Stock | 7.3396 | 7.3493 | 7.3396 | 7.3493 | 10920.0 |
| 2009-11-24 08:05:00 | AAPL | Stock | 7.3471 | 7.3482 | 7.3471 | 7.3475 | 14756.0 |
| 2009-11-24 08:10:00 | AAPL | Stock | 7.3471 | 7.3482 | 7.3429 | 7.3429 | 25564.0 |
| 2009-11-24 08:15:00 | AAPL | Stock | 7.3396 | 7.3396 | 7.3211 | 7.3214 | 231532.0 |
| 2009-11-24 08:20:00 | AAPL | Stock | 7.3214 | 7.3214 | 7.3143 | 7.3179 | 169848.0 |
| 2009-11-24 08:25:00 | AAPL | Stock | 7.3179 | 7.3282 | 7.3175 | 7.3282 | 139832.0 |
| 2009-11-24 08:30:00 | AAPL | Stock | 7.3268 | 7.3282 | 7.3179 | 7.3271 | 275212.0 |
| 2009-11-24 08:35:00 | AAPL | Stock | 7.325 | 7.3275 | 7.3232 | 7.3236 | 114968.0 |
| 2009-11-24 08:40:00 | AAPL | Stock | 7.325 | 7.325 | 7.3236 | 7.3236 | 22876.0 |
| 2009-11-24 08:45:00 | AAPL | Stock | 7.3268 | 7.3321 | 7.3268 | 7.3321 | 38080.0 |
| 2009-11-24 08:50:00 | AAPL | Stock | 7.3293 | 7.3321 | 7.3289 | 7.33 | 86996.0 |
| 2009-11-24 08:55:00 | AAPL | Stock | 7.3321 | 7.3339 | 7.3293 | 7.3321 | 63000.0 |
| 2009-11-24 09:00:00 | AAPL | Stock | 7.3343 | 7.3389 | 7.3325 | 7.3386 | 150500.0 |
| 2009-11-24 09:05:00 | AAPL | Stock | 7.3386 | 7.3411 | 7.3354 | 7.3404 | 151480.0 |
| 2009-11-24 09:10:00 | AAPL | Stock | 7.3429 | 7.3432 | 7.3379 | 7.3379 | 76300.0 |
| 2009-11-24 09:15:00 | AAPL | Stock | 7.3332 | 7.3357 | 7.3329 | 7.3357 | 40096.0 |
| 2009-11-24 09:20:00 | AAPL | Stock | 7.3361 | 7.3361 | 7.3332 | 7.335 | 36400.0 |
| 2009-11-24 09:25:00 | AAPL | Stock | 7.3354 | 7.3386 | 7.3336 | 7.3336 | 138376.0 |
| 2009-11-24 09:30:00 | AAPL | Stock | 7.3332 | 7.3332 | 7.3071 | 7.3089 | 14152124.0 |
| 2009-11-24 09:35:00 | AAPL | Stock | 7.3075 | 7.3107 | 7.2857 | 7.2929 | 13256040.0 |
| 2009-11-24 09:40:00 | AAPL | Stock | 7.2936 | 7.3132 | 7.2871 | 7.2879 | 8924132.0 |
| 2009-11-24 09:45:00 | AAPL | Stock | 7.2882 | 7.2903 | 7.265 | 7.265 | 12760244.0 |
| 2009-11-24 09:50:00 | AAPL | Stock | 7.265 | 7.2679 | 7.2464 | 7.2621 | 14310296.0 |
| 2009-11-24 09:55:00 | AAPL | Stock | 7.2621 | 7.2689 | 7.25 | 7.2564 | 8666336.0 |
| 2009-11-24 10:00:00 | AAPL | Stock | 7.2571 | 7.2799 | 7.25 | 7.2579 | 14563080.0 |
| 2009-11-24 10:05:00 | AAPL | Stock | 7.2589 | 7.2657 | 7.2518 | 7.2586 | 7367192.0 |
| 2009-11-24 10:10:00 | AAPL | Stock | 7.2582 | 7.2771 | 7.2518 | 7.2736 | 7448448.0 |
| 2009-11-24 10:15:00 | AAPL | Stock | 7.2736 | 7.2757 | 7.2614 | 7.2614 | 4053896.0 |
| 2009-11-24 10:20:00 | AAPL | Stock | 7.2636 | 7.2732 | 7.2618 | 7.2721 | 2924936.0 |
| 2009-11-24 10:25:00 | AAPL | Stock | 7.2721 | 7.2736 | 7.2629 | 7.2647 | 2458120.0 |
| 2009-11-24 10:30:00 | AAPL | Stock | 7.2654 | 7.2732 | 7.2607 | 7.2693 | 3704960.0 |
| 2009-11-24 10:35:00 | AAPL | Stock | 7.2693 | 7.2811 | 7.2643 | 7.2804 | 4545296.0 |
| 2009-11-24 10:40:00 | AAPL | Stock | 7.2804 | 7.2857 | 7.2768 | 7.2857 | 6858012.0 |
| 2009-11-24 10:45:00 | AAPL | Stock | 7.2846 | 7.2946 | 7.2846 | 7.2893 | 5443536.0 |
| 2009-11-24 10:50:00 | AAPL | Stock | 7.2904 | 7.2943 | 7.2825 | 7.2861 | 4412604.0 |
| 2009-11-24 10:55:00 | AAPL | Stock | 7.2871 | 7.29 | 7.2857 | 7.2864 | 1805580.0 |
| 2009-11-24 11:00:00 | AAPL | Stock | 7.2862 | 7.2893 | 7.2821 | 7.2875 | 1936172.0 |
| 2009-11-24 11:05:00 | AAPL | Stock | 7.2868 | 7.2939 | 7.2857 | 7.2929 | 2367708.0 |
| 2009-11-24 11:10:00 | AAPL | Stock | 7.2932 | 7.2939 | 7.2761 | 7.2775 | 4476696.0 |
| 2009-11-24 11:15:00 | AAPL | Stock | 7.2782 | 7.2789 | 7.262 | 7.2643 | 5056940.0 |
| 2009-11-24 11:20:00 | AAPL | Stock | 7.2636 | 7.2718 | 7.2629 | 7.2713 | 2826880.0 |
| 2009-11-24 11:25:00 | AAPL | Stock | 7.2707 | 7.2707 | 7.2596 | 7.2614 | 3332084.0 |
> showing 50 of 310,736 rows — these rows as CSV