PREVIEW / stock_5min / 2009-04-13
file: by_date/stock_5min/2009/2009-04-13.parquet size: 4.4 MB rows: 307,899 symbols: 3,339
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-04-13 04:15:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 5600.0 |
| 2009-04-13 04:45:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2946 | 4.2946 | 2800.0 |
| 2009-04-13 06:10:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 2800.0 |
| 2009-04-13 06:30:00 | AAPL | Stock | 4.2768 | 4.2768 | 4.2768 | 4.2768 | 2800.0 |
| 2009-04-13 07:05:00 | AAPL | Stock | 4.2679 | 4.2679 | 4.2679 | 4.2679 | 8400.0 |
| 2009-04-13 07:15:00 | AAPL | Stock | 4.25 | 4.25 | 4.25 | 4.25 | 2800.0 |
| 2009-04-13 07:40:00 | AAPL | Stock | 4.2504 | 4.2504 | 4.2504 | 4.2504 | 6440.0 |
| 2009-04-13 07:45:00 | AAPL | Stock | 4.2504 | 4.2596 | 4.2504 | 4.2596 | 24360.0 |
| 2009-04-13 08:00:00 | AAPL | Stock | 4.2646 | 4.2661 | 4.2539 | 4.2657 | 82068.0 |
| 2009-04-13 08:05:00 | AAPL | Stock | 4.2643 | 4.2657 | 4.2643 | 4.2657 | 27748.0 |
| 2009-04-13 08:10:00 | AAPL | Stock | 4.265 | 4.265 | 4.2571 | 4.2579 | 56896.0 |
| 2009-04-13 08:15:00 | AAPL | Stock | 4.2521 | 4.2579 | 4.2514 | 4.2525 | 17220.0 |
| 2009-04-13 08:20:00 | AAPL | Stock | 4.2525 | 4.2732 | 4.2518 | 4.2732 | 128856.0 |
| 2009-04-13 08:25:00 | AAPL | Stock | 4.2732 | 4.2786 | 4.2696 | 4.2768 | 97580.0 |
| 2009-04-13 08:30:00 | AAPL | Stock | 4.2821 | 4.2857 | 4.2732 | 4.2857 | 36232.0 |
| 2009-04-13 08:35:00 | AAPL | Stock | 4.2839 | 4.2839 | 4.2736 | 4.2736 | 15820.0 |
| 2009-04-13 08:40:00 | AAPL | Stock | 4.2757 | 4.2757 | 4.2732 | 4.2732 | 98840.0 |
| 2009-04-13 08:45:00 | AAPL | Stock | 4.2714 | 4.2732 | 4.2679 | 4.2732 | 91336.0 |
| 2009-04-13 08:55:00 | AAPL | Stock | 4.2786 | 4.2786 | 4.2786 | 4.2786 | 2800.0 |
| 2009-04-13 09:00:00 | AAPL | Stock | 4.2821 | 4.2825 | 4.2821 | 4.2825 | 11200.0 |
| 2009-04-13 09:05:00 | AAPL | Stock | 4.2829 | 4.2843 | 4.2768 | 4.2789 | 238700.0 |
| 2009-04-13 09:10:00 | AAPL | Stock | 4.2825 | 4.29 | 4.2804 | 4.29 | 461104.0 |
| 2009-04-13 09:15:00 | AAPL | Stock | 4.2911 | 4.2911 | 4.2786 | 4.2796 | 734328.0 |
| 2009-04-13 09:20:00 | AAPL | Stock | 4.2814 | 4.2843 | 4.2789 | 4.2804 | 162400.0 |
| 2009-04-13 09:25:00 | AAPL | Stock | 4.2811 | 4.2886 | 4.2804 | 4.2857 | 200116.0 |
| 2009-04-13 09:30:00 | AAPL | Stock | 4.2857 | 4.2982 | 4.2675 | 4.2725 | 15553636.0 |
| 2009-04-13 09:35:00 | AAPL | Stock | 4.2721 | 4.3129 | 4.2718 | 4.3039 | 16549792.0 |
| 2009-04-13 09:40:00 | AAPL | Stock | 4.3039 | 4.3043 | 4.2729 | 4.2818 | 11467456.0 |
| 2009-04-13 09:45:00 | AAPL | Stock | 4.2811 | 4.2857 | 4.2679 | 4.27 | 13386184.0 |
| 2009-04-13 09:50:00 | AAPL | Stock | 4.2704 | 4.2707 | 4.2543 | 4.2586 | 11145932.0 |
| 2009-04-13 09:55:00 | AAPL | Stock | 4.2594 | 4.2675 | 4.25 | 4.2646 | 8384936.0 |
| 2009-04-13 10:00:00 | AAPL | Stock | 4.2654 | 4.3111 | 4.2629 | 4.2921 | 12029920.0 |
| 2009-04-13 10:05:00 | AAPL | Stock | 4.2929 | 4.2932 | 4.2818 | 4.2914 | 5639480.0 |
| 2009-04-13 10:10:00 | AAPL | Stock | 4.2918 | 4.3171 | 4.2871 | 4.3082 | 8667652.0 |
| 2009-04-13 10:15:00 | AAPL | Stock | 4.3082 | 4.3175 | 4.3071 | 4.3121 | 7107352.0 |
| 2009-04-13 10:20:00 | AAPL | Stock | 4.3129 | 4.3179 | 4.3079 | 4.3154 | 4971204.0 |
| 2009-04-13 10:25:00 | AAPL | Stock | 4.3146 | 4.3175 | 4.3007 | 4.3032 | 6142248.0 |
| 2009-04-13 10:30:00 | AAPL | Stock | 4.3036 | 4.3057 | 4.2857 | 4.2922 | 5884984.0 |
| 2009-04-13 10:35:00 | AAPL | Stock | 4.2927 | 4.2979 | 4.2871 | 4.2889 | 3691408.0 |
| 2009-04-13 10:40:00 | AAPL | Stock | 4.2882 | 4.2925 | 4.2804 | 4.2814 | 5853204.0 |
| 2009-04-13 10:45:00 | AAPL | Stock | 4.2818 | 4.2861 | 4.2786 | 4.2825 | 5401732.0 |
| 2009-04-13 10:50:00 | AAPL | Stock | 4.2829 | 4.2893 | 4.2732 | 4.2732 | 6162660.0 |
| 2009-04-13 10:55:00 | AAPL | Stock | 4.2736 | 4.2779 | 4.2643 | 4.2681 | 6452236.0 |
| 2009-04-13 11:00:00 | AAPL | Stock | 4.2682 | 4.2689 | 4.2607 | 4.2618 | 4721248.0 |
| 2009-04-13 11:05:00 | AAPL | Stock | 4.2621 | 4.2718 | 4.2611 | 4.265 | 3852016.0 |
| 2009-04-13 11:10:00 | AAPL | Stock | 4.265 | 4.2764 | 4.2643 | 4.2714 | 4420696.0 |
| 2009-04-13 11:15:00 | AAPL | Stock | 4.2718 | 4.2754 | 4.2682 | 4.2714 | 2389072.0 |
| 2009-04-13 11:20:00 | AAPL | Stock | 4.2714 | 4.2764 | 4.2682 | 4.2738 | 2365580.0 |
| 2009-04-13 11:25:00 | AAPL | Stock | 4.2743 | 4.2836 | 4.2721 | 4.2768 | 3286528.0 |
| 2009-04-13 11:30:00 | AAPL | Stock | 4.2771 | 4.2814 | 4.2746 | 4.2764 | 2961644.0 |
> showing 50 of 307,899 rows — these rows as CSV