PREVIEW / stock_5min / 2010-08-06
file: by_date/stock_5min/2010/2010-08-06.parquet size: 4.6 MB rows: 315,632 symbols: 3,455
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-06 07:25:00 | AAPL | Stock | 9.3479 | 9.3479 | 9.3479 | 9.3479 | 3360.0 |
| 2010-08-06 08:00:00 | AAPL | Stock | 9.3432 | 9.3529 | 9.3357 | 9.3361 | 37352.0 |
| 2010-08-06 08:05:00 | AAPL | Stock | 9.3371 | 9.3432 | 9.3368 | 9.3368 | 16800.0 |
| 2010-08-06 08:10:00 | AAPL | Stock | 9.3364 | 9.3364 | 9.3157 | 9.3157 | 83776.0 |
| 2010-08-06 08:15:00 | AAPL | Stock | 9.3207 | 9.3332 | 9.3207 | 9.33 | 79968.0 |
| 2010-08-06 08:20:00 | AAPL | Stock | 9.3214 | 9.3286 | 9.3214 | 9.3268 | 32200.0 |
| 2010-08-06 08:25:00 | AAPL | Stock | 9.3286 | 9.3286 | 9.3175 | 9.3214 | 185444.0 |
| 2010-08-06 08:30:00 | AAPL | Stock | 9.3214 | 9.3339 | 9.2732 | 9.3021 | 1336160.0 |
| 2010-08-06 08:35:00 | AAPL | Stock | 9.3018 | 9.3111 | 9.2729 | 9.2846 | 1309364.0 |
| 2010-08-06 08:40:00 | AAPL | Stock | 9.2825 | 9.2932 | 9.275 | 9.2857 | 539924.0 |
| 2010-08-06 08:45:00 | AAPL | Stock | 9.2904 | 9.3025 | 9.2857 | 9.2968 | 770028.0 |
| 2010-08-06 08:50:00 | AAPL | Stock | 9.2957 | 9.3004 | 9.2943 | 9.2968 | 233352.0 |
| 2010-08-06 08:55:00 | AAPL | Stock | 9.2975 | 9.2986 | 9.29 | 9.2911 | 112000.0 |
| 2010-08-06 09:00:00 | AAPL | Stock | 9.2904 | 9.2911 | 9.2743 | 9.275 | 785400.0 |
| 2010-08-06 09:05:00 | AAPL | Stock | 9.275 | 9.2829 | 9.2736 | 9.2807 | 312704.0 |
| 2010-08-06 09:10:00 | AAPL | Stock | 9.2818 | 9.2832 | 9.2589 | 9.2604 | 761628.0 |
| 2010-08-06 09:15:00 | AAPL | Stock | 9.2618 | 9.275 | 9.2554 | 9.2739 | 503356.0 |
| 2010-08-06 09:20:00 | AAPL | Stock | 9.2714 | 9.2768 | 9.2675 | 9.2768 | 350700.0 |
| 2010-08-06 09:25:00 | AAPL | Stock | 9.2768 | 9.3214 | 9.2729 | 9.2746 | 292068.0 |
| 2010-08-06 09:30:00 | AAPL | Stock | 9.2757 | 9.2825 | 9.2357 | 9.2711 | 16179800.0 |
| 2010-08-06 09:35:00 | AAPL | Stock | 9.2726 | 9.295 | 9.2571 | 9.2643 | 10711652.0 |
| 2010-08-06 09:40:00 | AAPL | Stock | 9.2654 | 9.295 | 9.2643 | 9.2843 | 8403640.0 |
| 2010-08-06 09:45:00 | AAPL | Stock | 9.2854 | 9.2946 | 9.2779 | 9.2818 | 8954624.0 |
| 2010-08-06 09:50:00 | AAPL | Stock | 9.2814 | 9.3107 | 9.2782 | 9.3075 | 8622012.0 |
| 2010-08-06 09:55:00 | AAPL | Stock | 9.3061 | 9.3332 | 9.3004 | 9.3304 | 11603480.0 |
| 2010-08-06 10:00:00 | AAPL | Stock | 9.3289 | 9.3389 | 9.3104 | 9.3182 | 9893856.0 |
| 2010-08-06 10:05:00 | AAPL | Stock | 9.3207 | 9.3329 | 9.3064 | 9.31 | 5866532.0 |
| 2010-08-06 10:10:00 | AAPL | Stock | 9.31 | 9.31 | 9.2975 | 9.2982 | 5840772.0 |
| 2010-08-06 10:15:00 | AAPL | Stock | 9.2979 | 9.3135 | 9.2964 | 9.3004 | 5180728.0 |
| 2010-08-06 10:20:00 | AAPL | Stock | 9.3018 | 9.3132 | 9.2946 | 9.3093 | 4743648.0 |
| 2010-08-06 10:25:00 | AAPL | Stock | 9.3096 | 9.3154 | 9.2982 | 9.31 | 2672852.0 |
| 2010-08-06 10:30:00 | AAPL | Stock | 9.31 | 9.3171 | 9.3068 | 9.3139 | 2923200.0 |
| 2010-08-06 10:35:00 | AAPL | Stock | 9.3146 | 9.326 | 9.2957 | 9.3026 | 7139916.0 |
| 2010-08-06 10:40:00 | AAPL | Stock | 9.3007 | 9.3032 | 9.2768 | 9.2789 | 9905644.0 |
| 2010-08-06 10:45:00 | AAPL | Stock | 9.2789 | 9.2793 | 9.2536 | 9.262 | 13891864.0 |
| 2010-08-06 10:50:00 | AAPL | Stock | 9.2635 | 9.2682 | 9.2468 | 9.2575 | 11631564.0 |
| 2010-08-06 10:55:00 | AAPL | Stock | 9.2586 | 9.2632 | 9.2296 | 9.2364 | 13560540.0 |
| 2010-08-06 11:00:00 | AAPL | Stock | 9.2346 | 9.2479 | 9.2286 | 9.2396 | 10697764.0 |
| 2010-08-06 11:05:00 | AAPL | Stock | 9.2396 | 9.2443 | 9.2196 | 9.2354 | 7691964.0 |
| 2010-08-06 11:10:00 | AAPL | Stock | 9.2375 | 9.2489 | 9.2343 | 9.2363 | 7247884.0 |
| 2010-08-06 11:15:00 | AAPL | Stock | 9.2361 | 9.2486 | 9.2343 | 9.2371 | 3828216.0 |
| 2010-08-06 11:20:00 | AAPL | Stock | 9.2371 | 9.2575 | 9.2368 | 9.2546 | 4542524.0 |
| 2010-08-06 11:25:00 | AAPL | Stock | 9.2525 | 9.2543 | 9.2389 | 9.2443 | 3967880.0 |
| 2010-08-06 11:30:00 | AAPL | Stock | 9.2436 | 9.2486 | 9.2336 | 9.2371 | 4078816.0 |
| 2010-08-06 11:35:00 | AAPL | Stock | 9.2382 | 9.2532 | 9.2332 | 9.2509 | 3066700.0 |
| 2010-08-06 11:40:00 | AAPL | Stock | 9.2514 | 9.2614 | 9.2475 | 9.2504 | 4577412.0 |
| 2010-08-06 11:45:00 | AAPL | Stock | 9.25 | 9.2561 | 9.2457 | 9.2546 | 3253936.0 |
| 2010-08-06 11:50:00 | AAPL | Stock | 9.2546 | 9.2614 | 9.2489 | 9.2554 | 2886884.0 |
| 2010-08-06 11:55:00 | AAPL | Stock | 9.2543 | 9.2543 | 9.2436 | 9.2479 | 2402120.0 |
| 2010-08-06 12:00:00 | AAPL | Stock | 9.2486 | 9.2521 | 9.2414 | 9.2461 | 1703324.0 |
> showing 50 of 315,632 rows — these rows as CSV