PREVIEW / stock_5min / 2011-12-23
file: by_date/stock_5min/2011/2011-12-23.parquet size: 4.5 MB rows: 305,527 symbols: 3,569
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-23 04:05:00 | AAPL | Stock | 14.2657 | 14.2657 | 14.2657 | 14.2657 | 5600.0 |
| 2011-12-23 04:25:00 | AAPL | Stock | 14.2657 | 14.2657 | 14.2657 | 14.2657 | 3080.0 |
| 2011-12-23 04:55:00 | AAPL | Stock | 14.2411 | 14.2411 | 14.2411 | 14.2411 | 2800.0 |
| 2011-12-23 05:20:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-12-23 05:25:00 | AAPL | Stock | 14.2457 | 14.2457 | 14.2457 | 14.2457 | 2800.0 |
| 2011-12-23 05:30:00 | AAPL | Stock | 14.2457 | 14.2457 | 14.2457 | 14.2457 | 5600.0 |
| 2011-12-23 07:05:00 | AAPL | Stock | 14.2614 | 14.2614 | 14.2607 | 14.2607 | 6020.0 |
| 2011-12-23 07:10:00 | AAPL | Stock | 14.2639 | 14.2643 | 14.2639 | 14.2643 | 5600.0 |
| 2011-12-23 07:15:00 | AAPL | Stock | 14.2657 | 14.2675 | 14.2657 | 14.2675 | 50120.0 |
| 2011-12-23 07:20:00 | AAPL | Stock | 14.2675 | 14.2732 | 14.2675 | 14.2732 | 19880.0 |
| 2011-12-23 07:25:00 | AAPL | Stock | 14.2754 | 14.2889 | 14.2714 | 14.2804 | 243068.0 |
| 2011-12-23 07:30:00 | AAPL | Stock | 14.2768 | 14.2786 | 14.2768 | 14.2786 | 6160.0 |
| 2011-12-23 07:35:00 | AAPL | Stock | 14.2768 | 14.2768 | 14.275 | 14.275 | 24752.0 |
| 2011-12-23 07:40:00 | AAPL | Stock | 14.2714 | 14.275 | 14.2714 | 14.275 | 27440.0 |
| 2011-12-23 07:45:00 | AAPL | Stock | 14.2818 | 14.2818 | 14.2814 | 14.2818 | 30800.0 |
| 2011-12-23 07:50:00 | AAPL | Stock | 14.2818 | 14.2846 | 14.2818 | 14.2846 | 33320.0 |
| 2011-12-23 07:55:00 | AAPL | Stock | 14.2854 | 14.2854 | 14.285 | 14.2854 | 8400.0 |
| 2011-12-23 08:00:00 | AAPL | Stock | 14.2736 | 14.2904 | 14.2736 | 14.2857 | 533876.0 |
| 2011-12-23 08:05:00 | AAPL | Stock | 14.2861 | 14.2896 | 14.285 | 14.2871 | 238532.0 |
| 2011-12-23 08:10:00 | AAPL | Stock | 14.2871 | 14.3004 | 14.2871 | 14.2964 | 324548.0 |
| 2011-12-23 08:15:00 | AAPL | Stock | 14.2993 | 14.3004 | 14.2936 | 14.2982 | 245812.0 |
| 2011-12-23 08:20:00 | AAPL | Stock | 14.3 | 14.3 | 14.2861 | 14.2861 | 156828.0 |
| 2011-12-23 08:25:00 | AAPL | Stock | 14.2918 | 14.3036 | 14.2889 | 14.2932 | 135352.0 |
| 2011-12-23 08:30:00 | AAPL | Stock | 14.3014 | 14.3018 | 14.2821 | 14.2875 | 171920.0 |
| 2011-12-23 08:35:00 | AAPL | Stock | 14.2879 | 14.2879 | 14.28 | 14.2829 | 148848.0 |
| 2011-12-23 08:40:00 | AAPL | Stock | 14.2821 | 14.2854 | 14.2682 | 14.2786 | 242900.0 |
| 2011-12-23 08:45:00 | AAPL | Stock | 14.28 | 14.28 | 14.2661 | 14.2661 | 140028.0 |
| 2011-12-23 08:50:00 | AAPL | Stock | 14.2679 | 14.2729 | 14.2661 | 14.2729 | 195412.0 |
| 2011-12-23 08:55:00 | AAPL | Stock | 14.2661 | 14.2729 | 14.2639 | 14.2725 | 71764.0 |
| 2011-12-23 09:00:00 | AAPL | Stock | 14.2729 | 14.2857 | 14.2729 | 14.2818 | 233044.0 |
| 2011-12-23 09:05:00 | AAPL | Stock | 14.2857 | 14.2868 | 14.2857 | 14.2857 | 106820.0 |
| 2011-12-23 09:10:00 | AAPL | Stock | 14.2804 | 14.285 | 14.2789 | 14.2789 | 44800.0 |
| 2011-12-23 09:15:00 | AAPL | Stock | 14.2789 | 14.2804 | 14.2768 | 14.2768 | 36120.0 |
| 2011-12-23 09:20:00 | AAPL | Stock | 14.2779 | 14.2779 | 14.2736 | 14.275 | 14000.0 |
| 2011-12-23 09:25:00 | AAPL | Stock | 14.2754 | 14.2786 | 14.2679 | 14.2786 | 166348.0 |
| 2011-12-23 09:30:00 | AAPL | Stock | 14.2746 | 14.285 | 14.2677 | 14.2825 | 9169608.0 |
| 2011-12-23 09:35:00 | AAPL | Stock | 14.2825 | 14.3132 | 14.2786 | 14.2964 | 14734356.0 |
| 2011-12-23 09:40:00 | AAPL | Stock | 14.2975 | 14.2979 | 14.2807 | 14.2911 | 5883752.0 |
| 2011-12-23 09:45:00 | AAPL | Stock | 14.2918 | 14.2929 | 14.2821 | 14.2893 | 4140836.0 |
| 2011-12-23 09:50:00 | AAPL | Stock | 14.2893 | 14.3032 | 14.2846 | 14.2986 | 4271792.0 |
| 2011-12-23 09:55:00 | AAPL | Stock | 14.3 | 14.3018 | 14.2882 | 14.2896 | 3576832.0 |
| 2011-12-23 10:00:00 | AAPL | Stock | 14.2889 | 14.3 | 14.2861 | 14.2964 | 3375316.0 |
| 2011-12-23 10:05:00 | AAPL | Stock | 14.2964 | 14.3029 | 14.2857 | 14.2889 | 4691540.0 |
| 2011-12-23 10:10:00 | AAPL | Stock | 14.2889 | 14.2936 | 14.2821 | 14.2904 | 3602844.0 |
| 2011-12-23 10:15:00 | AAPL | Stock | 14.2888 | 14.2911 | 14.2714 | 14.2736 | 4506236.0 |
| 2011-12-23 10:20:00 | AAPL | Stock | 14.2757 | 14.2911 | 14.2739 | 14.2786 | 2885708.0 |
| 2011-12-23 10:25:00 | AAPL | Stock | 14.2786 | 14.2875 | 14.2786 | 14.2854 | 1415904.0 |
| 2011-12-23 10:30:00 | AAPL | Stock | 14.2836 | 14.2904 | 14.2818 | 14.2886 | 2058420.0 |
| 2011-12-23 10:35:00 | AAPL | Stock | 14.2879 | 14.2946 | 14.2871 | 14.2939 | 1881376.0 |
| 2011-12-23 10:40:00 | AAPL | Stock | 14.2929 | 14.2946 | 14.2857 | 14.2893 | 1660120.0 |
> showing 50 of 305,527 rows — these rows as CSV