PREVIEW / stock_5min / 2007-06-01
file: by_date/stock_5min/2007/2007-06-01.parquet size: 3.4 MB rows: 247,601 symbols: 2,650
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-01 07:10:00 | AAPL | Stock | 4.3168 | 4.3168 | 4.3168 | 4.3168 | 9800.0 |
| 2007-06-01 07:35:00 | AAPL | Stock | 4.3196 | 4.3196 | 4.3196 | 4.3196 | 21000.0 |
| 2007-06-01 07:55:00 | AAPL | Stock | 4.3107 | 4.3143 | 4.3107 | 4.3143 | 9520.0 |
| 2007-06-01 08:00:00 | AAPL | Stock | 4.3136 | 4.3204 | 4.3107 | 4.3161 | 375676.0 |
| 2007-06-01 08:05:00 | AAPL | Stock | 4.3196 | 4.325 | 4.3182 | 4.325 | 517580.0 |
| 2007-06-01 08:10:00 | AAPL | Stock | 4.325 | 4.3457 | 4.325 | 4.3357 | 1302840.0 |
| 2007-06-01 08:15:00 | AAPL | Stock | 4.3361 | 4.3375 | 4.3282 | 4.3321 | 456512.0 |
| 2007-06-01 08:20:00 | AAPL | Stock | 4.3321 | 4.3379 | 4.3311 | 4.335 | 287560.0 |
| 2007-06-01 08:25:00 | AAPL | Stock | 4.3346 | 4.335 | 4.3314 | 4.3329 | 143500.0 |
| 2007-06-01 08:30:00 | AAPL | Stock | 4.3325 | 4.345 | 4.3314 | 4.345 | 476644.0 |
| 2007-06-01 08:35:00 | AAPL | Stock | 4.3429 | 4.3457 | 4.3396 | 4.3443 | 755132.0 |
| 2007-06-01 08:40:00 | AAPL | Stock | 4.3436 | 4.3446 | 4.3414 | 4.3414 | 496804.0 |
| 2007-06-01 08:45:00 | AAPL | Stock | 4.3421 | 4.3421 | 4.3354 | 4.3375 | 907620.0 |
| 2007-06-01 08:50:00 | AAPL | Stock | 4.3371 | 4.3414 | 4.3357 | 4.3361 | 486948.0 |
| 2007-06-01 08:55:00 | AAPL | Stock | 4.3357 | 4.3382 | 4.3357 | 4.3368 | 433160.0 |
| 2007-06-01 09:00:00 | AAPL | Stock | 4.3357 | 4.3357 | 4.3304 | 4.3321 | 350560.0 |
| 2007-06-01 09:05:00 | AAPL | Stock | 4.3329 | 4.3329 | 4.3232 | 4.3304 | 763644.0 |
| 2007-06-01 09:10:00 | AAPL | Stock | 4.3286 | 4.3304 | 4.3286 | 4.3304 | 388080.0 |
| 2007-06-01 09:15:00 | AAPL | Stock | 4.3304 | 4.3321 | 4.3225 | 4.3282 | 458472.0 |
| 2007-06-01 09:20:00 | AAPL | Stock | 4.3286 | 4.3286 | 4.3279 | 4.3279 | 115220.0 |
| 2007-06-01 09:25:00 | AAPL | Stock | 4.3286 | 4.3289 | 4.3204 | 4.3268 | 1148196.0 |
| 2007-06-01 09:30:00 | AAPL | Stock | 4.3246 | 4.3282 | 4.2939 | 4.3164 | 35909272.0 |
| 2007-06-01 09:35:00 | AAPL | Stock | 4.3175 | 4.3254 | 4.2964 | 4.3004 | 21058800.0 |
| 2007-06-01 09:40:00 | AAPL | Stock | 4.3 | 4.3036 | 4.2679 | 4.2789 | 36914108.0 |
| 2007-06-01 09:45:00 | AAPL | Stock | 4.2798 | 4.2857 | 4.2739 | 4.275 | 21259812.0 |
| 2007-06-01 09:50:00 | AAPL | Stock | 4.2748 | 4.2796 | 4.2432 | 4.2586 | 38384080.0 |
| 2007-06-01 09:55:00 | AAPL | Stock | 4.2586 | 4.2743 | 4.2532 | 4.2743 | 19823720.0 |
| 2007-06-01 10:00:00 | AAPL | Stock | 4.2732 | 4.3246 | 4.2621 | 4.285 | 22281392.0 |
| 2007-06-01 10:05:00 | AAPL | Stock | 4.285 | 4.2986 | 4.2821 | 4.295 | 23805432.0 |
| 2007-06-01 10:10:00 | AAPL | Stock | 4.295 | 4.2989 | 4.275 | 4.2796 | 18420136.0 |
| 2007-06-01 10:15:00 | AAPL | Stock | 4.2804 | 4.2882 | 4.2786 | 4.2839 | 11277224.0 |
| 2007-06-01 10:20:00 | AAPL | Stock | 4.2839 | 4.2846 | 4.2761 | 4.2786 | 12463668.0 |
| 2007-06-01 10:25:00 | AAPL | Stock | 4.2786 | 4.2818 | 4.2693 | 4.2782 | 14636104.0 |
| 2007-06-01 10:30:00 | AAPL | Stock | 4.2781 | 4.2843 | 4.2732 | 4.2839 | 11141480.0 |
| 2007-06-01 10:35:00 | AAPL | Stock | 4.2836 | 4.2839 | 4.275 | 4.276 | 8943424.0 |
| 2007-06-01 10:40:00 | AAPL | Stock | 4.2757 | 4.2771 | 4.2661 | 4.2736 | 15093456.0 |
| 2007-06-01 10:45:00 | AAPL | Stock | 4.2732 | 4.2761 | 4.2629 | 4.2639 | 14352240.0 |
| 2007-06-01 10:50:00 | AAPL | Stock | 4.2643 | 4.2768 | 4.2579 | 4.2629 | 11648924.0 |
| 2007-06-01 10:55:00 | AAPL | Stock | 4.2629 | 4.2679 | 4.2618 | 4.265 | 7779940.0 |
| 2007-06-01 11:00:00 | AAPL | Stock | 4.2657 | 4.2675 | 4.2571 | 4.2664 | 9566984.0 |
| 2007-06-01 11:05:00 | AAPL | Stock | 4.2664 | 4.2761 | 4.265 | 4.2739 | 8328740.0 |
| 2007-06-01 11:10:00 | AAPL | Stock | 4.2736 | 4.2782 | 4.2707 | 4.2746 | 6673380.0 |
| 2007-06-01 11:15:00 | AAPL | Stock | 4.2746 | 4.2821 | 4.2746 | 4.2789 | 7285068.0 |
| 2007-06-01 11:20:00 | AAPL | Stock | 4.2793 | 4.2799 | 4.2693 | 4.2707 | 7971404.0 |
| 2007-06-01 11:25:00 | AAPL | Stock | 4.2711 | 4.2768 | 4.2707 | 4.2732 | 4036116.0 |
| 2007-06-01 11:30:00 | AAPL | Stock | 4.2732 | 4.2754 | 4.2679 | 4.2696 | 5454344.0 |
| 2007-06-01 11:35:00 | AAPL | Stock | 4.2696 | 4.2711 | 4.2654 | 4.2682 | 6031256.0 |
| 2007-06-01 11:40:00 | AAPL | Stock | 4.2686 | 4.2693 | 4.2639 | 4.2654 | 7837060.0 |
| 2007-06-01 11:45:00 | AAPL | Stock | 4.265 | 4.2668 | 4.2557 | 4.2589 | 11743928.0 |
| 2007-06-01 11:50:00 | AAPL | Stock | 4.2593 | 4.2614 | 4.2536 | 4.2539 | 10160332.0 |
> showing 50 of 247,601 rows — these rows as CSV