PREVIEW / stock_5min / 2006-12-01
file: by_date/stock_5min/2006/2006-12-01.parquet size: 3.3 MB rows: 241,444 symbols: 2,449
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-01 07:55:00 | AAPL | Stock | 3.2821 | 3.2886 | 3.2821 | 3.2886 | 47460.0 |
| 2006-12-01 08:00:00 | AAPL | Stock | 3.2925 | 3.2929 | 3.2821 | 3.2839 | 432180.0 |
| 2006-12-01 08:05:00 | AAPL | Stock | 3.2839 | 3.2857 | 3.2836 | 3.2857 | 278908.0 |
| 2006-12-01 08:10:00 | AAPL | Stock | 3.2857 | 3.2904 | 3.2839 | 3.2875 | 287896.0 |
| 2006-12-01 08:15:00 | AAPL | Stock | 3.2839 | 3.2857 | 3.2836 | 3.2857 | 72436.0 |
| 2006-12-01 08:20:00 | AAPL | Stock | 3.285 | 3.2857 | 3.2839 | 3.2839 | 40600.0 |
| 2006-12-01 08:25:00 | AAPL | Stock | 3.2836 | 3.2839 | 3.2829 | 3.2832 | 261100.0 |
| 2006-12-01 08:30:00 | AAPL | Stock | 3.2829 | 3.2836 | 3.2736 | 3.2829 | 339248.0 |
| 2006-12-01 08:35:00 | AAPL | Stock | 3.2821 | 3.2821 | 3.2768 | 3.2771 | 201880.0 |
| 2006-12-01 08:40:00 | AAPL | Stock | 3.2754 | 3.2786 | 3.275 | 3.2768 | 120120.0 |
| 2006-12-01 08:45:00 | AAPL | Stock | 3.2768 | 3.2786 | 3.2768 | 3.2786 | 113260.0 |
| 2006-12-01 08:50:00 | AAPL | Stock | 3.2786 | 3.2821 | 3.2786 | 3.2804 | 118580.0 |
| 2006-12-01 08:55:00 | AAPL | Stock | 3.2804 | 3.2818 | 3.2775 | 3.2789 | 189560.0 |
| 2006-12-01 09:00:00 | AAPL | Stock | 3.2786 | 3.28 | 3.2775 | 3.2786 | 155540.0 |
| 2006-12-01 09:05:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2771 | 3.2775 | 78400.0 |
| 2006-12-01 09:10:00 | AAPL | Stock | 3.2775 | 3.2786 | 3.2775 | 3.2786 | 106680.0 |
| 2006-12-01 09:15:00 | AAPL | Stock | 3.2814 | 3.2814 | 3.2789 | 3.2789 | 50400.0 |
| 2006-12-01 09:20:00 | AAPL | Stock | 3.2814 | 3.2818 | 3.2789 | 3.2814 | 151480.0 |
| 2006-12-01 09:25:00 | AAPL | Stock | 3.2804 | 3.2804 | 3.2743 | 3.275 | 806932.0 |
| 2006-12-01 09:30:00 | AAPL | Stock | 3.2786 | 3.29 | 3.2743 | 3.2882 | 15177008.0 |
| 2006-12-01 09:35:00 | AAPL | Stock | 3.2893 | 3.2975 | 3.2861 | 3.2936 | 17385032.0 |
| 2006-12-01 09:40:00 | AAPL | Stock | 3.2929 | 3.2946 | 3.2832 | 3.2868 | 14823228.0 |
| 2006-12-01 09:45:00 | AAPL | Stock | 3.2864 | 3.2889 | 3.2789 | 3.2854 | 9528512.0 |
| 2006-12-01 09:50:00 | AAPL | Stock | 3.285 | 3.2854 | 3.2739 | 3.2768 | 12653284.0 |
| 2006-12-01 09:55:00 | AAPL | Stock | 3.2761 | 3.2793 | 3.2725 | 3.275 | 12818372.0 |
| 2006-12-01 10:00:00 | AAPL | Stock | 3.2757 | 3.2768 | 3.2575 | 3.2625 | 27216168.0 |
| 2006-12-01 10:05:00 | AAPL | Stock | 3.2629 | 3.2718 | 3.255 | 3.2586 | 18047960.0 |
| 2006-12-01 10:10:00 | AAPL | Stock | 3.2586 | 3.2711 | 3.2586 | 3.2682 | 12517960.0 |
| 2006-12-01 10:15:00 | AAPL | Stock | 3.2682 | 3.2729 | 3.2554 | 3.2589 | 15645476.0 |
| 2006-12-01 10:20:00 | AAPL | Stock | 3.2582 | 3.2632 | 3.2554 | 3.2593 | 11326616.0 |
| 2006-12-01 10:25:00 | AAPL | Stock | 3.2593 | 3.2621 | 3.2525 | 3.2589 | 17943996.0 |
| 2006-12-01 10:30:00 | AAPL | Stock | 3.2586 | 3.2607 | 3.2386 | 3.2414 | 22432424.0 |
| 2006-12-01 10:35:00 | AAPL | Stock | 3.2414 | 3.2431 | 3.2179 | 3.2314 | 38538164.0 |
| 2006-12-01 10:40:00 | AAPL | Stock | 3.2314 | 3.2371 | 3.2289 | 3.235 | 16914296.0 |
| 2006-12-01 10:45:00 | AAPL | Stock | 3.235 | 3.2436 | 3.2332 | 3.2421 | 14322476.0 |
| 2006-12-01 10:50:00 | AAPL | Stock | 3.2421 | 3.2511 | 3.2371 | 3.2511 | 13324892.0 |
| 2006-12-01 10:55:00 | AAPL | Stock | 3.2511 | 3.2511 | 3.2436 | 3.2468 | 9004352.0 |
| 2006-12-01 11:00:00 | AAPL | Stock | 3.2468 | 3.2571 | 3.2468 | 3.2526 | 11837812.0 |
| 2006-12-01 11:05:00 | AAPL | Stock | 3.2529 | 3.2539 | 3.2404 | 3.2411 | 11259528.0 |
| 2006-12-01 11:10:00 | AAPL | Stock | 3.2411 | 3.2546 | 3.2404 | 3.2543 | 7848764.0 |
| 2006-12-01 11:15:00 | AAPL | Stock | 3.2539 | 3.2564 | 3.2493 | 3.251 | 7947044.0 |
| 2006-12-01 11:20:00 | AAPL | Stock | 3.2511 | 3.2511 | 3.2432 | 3.2442 | 5591208.0 |
| 2006-12-01 11:25:00 | AAPL | Stock | 3.2439 | 3.2536 | 3.2414 | 3.25 | 7576324.0 |
| 2006-12-01 11:30:00 | AAPL | Stock | 3.2502 | 3.2521 | 3.2443 | 3.2514 | 4856432.0 |
| 2006-12-01 11:35:00 | AAPL | Stock | 3.2514 | 3.2561 | 3.2493 | 3.2546 | 5146344.0 |
| 2006-12-01 11:40:00 | AAPL | Stock | 3.2543 | 3.2611 | 3.2543 | 3.26 | 10407936.0 |
| 2006-12-01 11:45:00 | AAPL | Stock | 3.2604 | 3.265 | 3.2586 | 3.2632 | 12621980.0 |
| 2006-12-01 11:50:00 | AAPL | Stock | 3.2632 | 3.2761 | 3.2632 | 3.2721 | 17453268.0 |
| 2006-12-01 11:55:00 | AAPL | Stock | 3.2721 | 3.2786 | 3.2679 | 3.2754 | 14227192.0 |
| 2006-12-01 12:00:00 | AAPL | Stock | 3.2754 | 3.2796 | 3.27 | 3.271 | 13402592.0 |
> showing 50 of 241,444 rows — these rows as CSV