PREVIEW / stock_5min / 2008-08-25
file: by_date/stock_5min/2008/2008-08-25.parquet size: 4.2 MB rows: 306,288 symbols: 3,301
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-25 06:45:00 | AAPL | Stock | 6.3086 | 6.3086 | 6.3086 | 6.3086 | 2800.0 |
| 2008-08-25 07:40:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 5600.0 |
| 2008-08-25 07:50:00 | AAPL | Stock | 6.3032 | 6.3046 | 6.3032 | 6.3036 | 54600.0 |
| 2008-08-25 07:55:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 5600.0 |
| 2008-08-25 08:00:00 | AAPL | Stock | 6.3107 | 6.3114 | 6.3104 | 6.3107 | 174328.0 |
| 2008-08-25 08:05:00 | AAPL | Stock | 6.3121 | 6.3125 | 6.3036 | 6.3064 | 106316.0 |
| 2008-08-25 08:10:00 | AAPL | Stock | 6.3064 | 6.3104 | 6.2918 | 6.2929 | 205492.0 |
| 2008-08-25 08:15:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2875 | 6.2875 | 84028.0 |
| 2008-08-25 08:20:00 | AAPL | Stock | 6.2893 | 6.2964 | 6.2893 | 6.2964 | 19600.0 |
| 2008-08-25 08:25:00 | AAPL | Stock | 6.2961 | 6.2964 | 6.2893 | 6.2893 | 18200.0 |
| 2008-08-25 08:30:00 | AAPL | Stock | 6.2893 | 6.2893 | 6.2857 | 6.2857 | 30184.0 |
| 2008-08-25 08:35:00 | AAPL | Stock | 6.2839 | 6.2868 | 6.2839 | 6.2857 | 58800.0 |
| 2008-08-25 08:40:00 | AAPL | Stock | 6.2864 | 6.2864 | 6.2818 | 6.2836 | 132132.0 |
| 2008-08-25 08:45:00 | AAPL | Stock | 6.2843 | 6.285 | 6.2821 | 6.285 | 160440.0 |
| 2008-08-25 08:50:00 | AAPL | Stock | 6.2821 | 6.2857 | 6.2821 | 6.2821 | 78204.0 |
| 2008-08-25 08:55:00 | AAPL | Stock | 6.2846 | 6.2857 | 6.2846 | 6.2857 | 13860.0 |
| 2008-08-25 09:00:00 | AAPL | Stock | 6.2857 | 6.2889 | 6.2857 | 6.2857 | 139048.0 |
| 2008-08-25 09:05:00 | AAPL | Stock | 6.2857 | 6.2886 | 6.2857 | 6.2861 | 25200.0 |
| 2008-08-25 09:10:00 | AAPL | Stock | 6.2889 | 6.2925 | 6.2889 | 6.2889 | 41720.0 |
| 2008-08-25 09:15:00 | AAPL | Stock | 6.2929 | 6.2954 | 6.2929 | 6.2954 | 11200.0 |
| 2008-08-25 09:20:00 | AAPL | Stock | 6.2964 | 6.3 | 6.2964 | 6.2979 | 16240.0 |
| 2008-08-25 09:25:00 | AAPL | Stock | 6.2968 | 6.2993 | 6.2814 | 6.2836 | 659400.0 |
| 2008-08-25 09:30:00 | AAPL | Stock | 6.285 | 6.2939 | 6.2643 | 6.2728 | 16385460.0 |
| 2008-08-25 09:35:00 | AAPL | Stock | 6.2714 | 6.2754 | 6.2429 | 6.2593 | 14141344.0 |
| 2008-08-25 09:40:00 | AAPL | Stock | 6.2607 | 6.2786 | 6.2557 | 6.2654 | 7915404.0 |
| 2008-08-25 09:45:00 | AAPL | Stock | 6.2644 | 6.2714 | 6.25 | 6.2571 | 7490392.0 |
| 2008-08-25 09:50:00 | AAPL | Stock | 6.2575 | 6.2636 | 6.2475 | 6.2489 | 6084428.0 |
| 2008-08-25 09:55:00 | AAPL | Stock | 6.2504 | 6.2695 | 6.2464 | 6.2586 | 7907732.0 |
| 2008-08-25 10:00:00 | AAPL | Stock | 6.26 | 6.2714 | 6.2511 | 6.2586 | 7831544.0 |
| 2008-08-25 10:05:00 | AAPL | Stock | 6.2586 | 6.2761 | 6.2582 | 6.27 | 8333528.0 |
| 2008-08-25 10:10:00 | AAPL | Stock | 6.27 | 6.2786 | 6.2621 | 6.2661 | 5928188.0 |
| 2008-08-25 10:15:00 | AAPL | Stock | 6.2664 | 6.2746 | 6.2643 | 6.2671 | 4333896.0 |
| 2008-08-25 10:20:00 | AAPL | Stock | 6.2679 | 6.2689 | 6.2521 | 6.2546 | 5235076.0 |
| 2008-08-25 10:25:00 | AAPL | Stock | 6.2543 | 6.2661 | 6.25 | 6.26 | 4712792.0 |
| 2008-08-25 10:30:00 | AAPL | Stock | 6.2611 | 6.2636 | 6.2482 | 6.2561 | 6040020.0 |
| 2008-08-25 10:35:00 | AAPL | Stock | 6.2561 | 6.2568 | 6.2286 | 6.2304 | 8636040.0 |
| 2008-08-25 10:40:00 | AAPL | Stock | 6.2311 | 6.2375 | 6.2161 | 6.2368 | 12384708.0 |
| 2008-08-25 10:45:00 | AAPL | Stock | 6.2368 | 6.2375 | 6.2236 | 6.2271 | 4148788.0 |
| 2008-08-25 10:50:00 | AAPL | Stock | 6.2264 | 6.2275 | 6.2096 | 6.2139 | 8636796.0 |
| 2008-08-25 10:55:00 | AAPL | Stock | 6.2143 | 6.2175 | 6.205 | 6.2071 | 5292812.0 |
| 2008-08-25 11:00:00 | AAPL | Stock | 6.2061 | 6.2157 | 6.1986 | 6.2139 | 7323652.0 |
| 2008-08-25 11:05:00 | AAPL | Stock | 6.2136 | 6.2225 | 6.2136 | 6.2193 | 4536028.0 |
| 2008-08-25 11:10:00 | AAPL | Stock | 6.2196 | 6.225 | 6.2107 | 6.2116 | 5765284.0 |
| 2008-08-25 11:15:00 | AAPL | Stock | 6.2129 | 6.2257 | 6.21 | 6.2239 | 3791620.0 |
| 2008-08-25 11:20:00 | AAPL | Stock | 6.2246 | 6.2279 | 6.2157 | 6.2196 | 3655372.0 |
| 2008-08-25 11:25:00 | AAPL | Stock | 6.2204 | 6.2261 | 6.2193 | 6.2225 | 2902284.0 |
| 2008-08-25 11:30:00 | AAPL | Stock | 6.2218 | 6.2264 | 6.2121 | 6.2193 | 3636584.0 |
| 2008-08-25 11:35:00 | AAPL | Stock | 6.2196 | 6.2246 | 6.2143 | 6.2232 | 2384480.0 |
| 2008-08-25 11:40:00 | AAPL | Stock | 6.2239 | 6.225 | 6.2143 | 6.2154 | 2612372.0 |
| 2008-08-25 11:45:00 | AAPL | Stock | 6.2157 | 6.2168 | 6.2075 | 6.2139 | 3265696.0 |
> showing 50 of 306,288 rows — these rows as CSV