PREVIEW / stock_5min / 2010-08-10
file: by_date/stock_5min/2010/2010-08-10.parquet size: 4.7 MB rows: 322,416 symbols: 3,483
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-10 06:05:00 | AAPL | Stock | 9.3161 | 9.3161 | 9.3161 | 9.3161 | 5320.0 |
| 2010-08-10 07:05:00 | AAPL | Stock | 9.3107 | 9.3107 | 9.3107 | 9.3107 | 4284.0 |
| 2010-08-10 07:20:00 | AAPL | Stock | 9.3107 | 9.3107 | 9.3054 | 9.3054 | 5600.0 |
| 2010-08-10 07:25:00 | AAPL | Stock | 9.3036 | 9.3036 | 9.3036 | 9.3036 | 2800.0 |
| 2010-08-10 07:30:00 | AAPL | Stock | 9.3018 | 9.3036 | 9.3 | 9.3 | 19600.0 |
| 2010-08-10 07:35:00 | AAPL | Stock | 9.3004 | 9.3071 | 9.3004 | 9.3071 | 16800.0 |
| 2010-08-10 07:40:00 | AAPL | Stock | 9.3004 | 9.3004 | 9.2975 | 9.2975 | 39760.0 |
| 2010-08-10 07:45:00 | AAPL | Stock | 9.2946 | 9.2946 | 9.2857 | 9.2871 | 64400.0 |
| 2010-08-10 07:50:00 | AAPL | Stock | 9.2871 | 9.2871 | 9.2857 | 9.2857 | 16800.0 |
| 2010-08-10 07:55:00 | AAPL | Stock | 9.2839 | 9.2839 | 9.2821 | 9.2821 | 8400.0 |
| 2010-08-10 08:00:00 | AAPL | Stock | 9.2857 | 9.3014 | 9.2854 | 9.2932 | 236544.0 |
| 2010-08-10 08:05:00 | AAPL | Stock | 9.2932 | 9.3014 | 9.2911 | 9.3014 | 128884.0 |
| 2010-08-10 08:10:00 | AAPL | Stock | 9.3032 | 9.3036 | 9.2946 | 9.2946 | 254296.0 |
| 2010-08-10 08:15:00 | AAPL | Stock | 9.2929 | 9.2946 | 9.2879 | 9.2879 | 26600.0 |
| 2010-08-10 08:20:00 | AAPL | Stock | 9.2879 | 9.2946 | 9.2779 | 9.2804 | 521164.0 |
| 2010-08-10 08:25:00 | AAPL | Stock | 9.2825 | 9.2893 | 9.2825 | 9.2893 | 56000.0 |
| 2010-08-10 08:30:00 | AAPL | Stock | 9.2857 | 9.2893 | 9.2782 | 9.2811 | 232260.0 |
| 2010-08-10 08:35:00 | AAPL | Stock | 9.285 | 9.2868 | 9.2782 | 9.2868 | 127904.0 |
| 2010-08-10 08:40:00 | AAPL | Stock | 9.2839 | 9.2857 | 9.2768 | 9.2843 | 243600.0 |
| 2010-08-10 08:45:00 | AAPL | Stock | 9.2811 | 9.2814 | 9.2786 | 9.2786 | 47600.0 |
| 2010-08-10 08:50:00 | AAPL | Stock | 9.2786 | 9.2786 | 9.2707 | 9.2764 | 180992.0 |
| 2010-08-10 08:55:00 | AAPL | Stock | 9.2786 | 9.285 | 9.2768 | 9.285 | 103600.0 |
| 2010-08-10 09:00:00 | AAPL | Stock | 9.2832 | 9.2929 | 9.2821 | 9.2914 | 272384.0 |
| 2010-08-10 09:05:00 | AAPL | Stock | 9.2925 | 9.2929 | 9.2857 | 9.2857 | 230020.0 |
| 2010-08-10 09:10:00 | AAPL | Stock | 9.2857 | 9.2875 | 9.2821 | 9.2843 | 77000.0 |
| 2010-08-10 09:15:00 | AAPL | Stock | 9.2854 | 9.2871 | 9.2854 | 9.2857 | 56000.0 |
| 2010-08-10 09:20:00 | AAPL | Stock | 9.2843 | 9.2854 | 9.28 | 9.2814 | 161812.0 |
| 2010-08-10 09:25:00 | AAPL | Stock | 9.2804 | 9.2804 | 9.2754 | 9.28 | 281456.0 |
| 2010-08-10 09:30:00 | AAPL | Stock | 9.2804 | 9.2921 | 9.2646 | 9.2821 | 12478312.0 |
| 2010-08-10 09:35:00 | AAPL | Stock | 9.2821 | 9.2996 | 9.2679 | 9.2783 | 12821060.0 |
| 2010-08-10 09:40:00 | AAPL | Stock | 9.2764 | 9.2782 | 9.2429 | 9.2543 | 13898416.0 |
| 2010-08-10 09:45:00 | AAPL | Stock | 9.2543 | 9.2625 | 9.2439 | 9.255 | 9697324.0 |
| 2010-08-10 09:50:00 | AAPL | Stock | 9.255 | 9.2607 | 9.2407 | 9.254 | 9601816.0 |
| 2010-08-10 09:55:00 | AAPL | Stock | 9.2539 | 9.2571 | 9.2361 | 9.2504 | 8862392.0 |
| 2010-08-10 10:00:00 | AAPL | Stock | 9.2479 | 9.2496 | 9.2371 | 9.2386 | 7944832.0 |
| 2010-08-10 10:05:00 | AAPL | Stock | 9.2371 | 9.2554 | 9.2321 | 9.2543 | 12381656.0 |
| 2010-08-10 10:10:00 | AAPL | Stock | 9.2543 | 9.2548 | 9.2429 | 9.25 | 6816460.0 |
| 2010-08-10 10:15:00 | AAPL | Stock | 9.2489 | 9.25 | 9.2457 | 9.2496 | 4972156.0 |
| 2010-08-10 10:20:00 | AAPL | Stock | 9.2496 | 9.2561 | 9.2464 | 9.2534 | 6946324.0 |
| 2010-08-10 10:25:00 | AAPL | Stock | 9.2529 | 9.2568 | 9.2471 | 9.2496 | 5952324.0 |
| 2010-08-10 10:30:00 | AAPL | Stock | 9.2496 | 9.2536 | 9.2332 | 9.2389 | 4969636.0 |
| 2010-08-10 10:35:00 | AAPL | Stock | 9.2393 | 9.2421 | 9.2229 | 9.2239 | 7661528.0 |
| 2010-08-10 10:40:00 | AAPL | Stock | 9.2243 | 9.2379 | 9.2143 | 9.2307 | 11068092.0 |
| 2010-08-10 10:45:00 | AAPL | Stock | 9.2321 | 9.235 | 9.2232 | 9.2232 | 3646216.0 |
| 2010-08-10 10:50:00 | AAPL | Stock | 9.2232 | 9.225 | 9.2164 | 9.2235 | 3537744.0 |
| 2010-08-10 10:55:00 | AAPL | Stock | 9.222 | 9.2232 | 9.2079 | 9.2143 | 10620484.0 |
| 2010-08-10 11:00:00 | AAPL | Stock | 9.215 | 9.2307 | 9.2139 | 9.2246 | 4926012.0 |
| 2010-08-10 11:05:00 | AAPL | Stock | 9.2257 | 9.2271 | 9.2107 | 9.2176 | 4471124.0 |
| 2010-08-10 11:10:00 | AAPL | Stock | 9.2164 | 9.2307 | 9.2157 | 9.2257 | 3539788.0 |
| 2010-08-10 11:15:00 | AAPL | Stock | 9.2264 | 9.2304 | 9.2236 | 9.2275 | 2272900.0 |
> showing 50 of 322,416 rows — these rows as CSV