PREVIEW / stock_5min / 2009-01-30
file: by_date/stock_5min/2009/2009-01-30.parquet size: 4.3 MB rows: 298,865 symbols: 3,293
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-01-30 07:25:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.3039 | 3.3039 | 2800.0 |
| 2009-01-30 08:00:00 | AAPL | Stock | 3.2946 | 3.2982 | 3.2821 | 3.2939 | 259252.0 |
| 2009-01-30 08:05:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2857 | 3.2857 | 28000.0 |
| 2009-01-30 08:10:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2786 | 3.2836 | 356356.0 |
| 2009-01-30 08:15:00 | AAPL | Stock | 3.2857 | 3.2886 | 3.285 | 3.2886 | 52248.0 |
| 2009-01-30 08:20:00 | AAPL | Stock | 3.2886 | 3.2886 | 3.2861 | 3.2886 | 46480.0 |
| 2009-01-30 08:25:00 | AAPL | Stock | 3.2929 | 3.2996 | 3.2929 | 3.2996 | 29484.0 |
| 2009-01-30 08:30:00 | AAPL | Stock | 3.3 | 3.3475 | 3.3 | 3.3304 | 1135680.0 |
| 2009-01-30 08:35:00 | AAPL | Stock | 3.3318 | 3.3336 | 3.3221 | 3.3261 | 200732.0 |
| 2009-01-30 08:40:00 | AAPL | Stock | 3.3275 | 3.3275 | 3.3071 | 3.31 | 596988.0 |
| 2009-01-30 08:45:00 | AAPL | Stock | 3.3139 | 3.3143 | 3.3125 | 3.3136 | 194208.0 |
| 2009-01-30 08:50:00 | AAPL | Stock | 3.3143 | 3.3146 | 3.3089 | 3.3146 | 217476.0 |
| 2009-01-30 08:55:00 | AAPL | Stock | 3.3125 | 3.3143 | 3.3036 | 3.3057 | 206780.0 |
| 2009-01-30 09:00:00 | AAPL | Stock | 3.3057 | 3.3071 | 3.3 | 3.3046 | 151396.0 |
| 2009-01-30 09:05:00 | AAPL | Stock | 3.305 | 3.3104 | 3.305 | 3.3054 | 84000.0 |
| 2009-01-30 09:10:00 | AAPL | Stock | 3.3061 | 3.3143 | 3.3057 | 3.3111 | 96656.0 |
| 2009-01-30 09:15:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3004 | 3.3018 | 197400.0 |
| 2009-01-30 09:20:00 | AAPL | Stock | 3.3 | 3.3014 | 3.2946 | 3.3014 | 283360.0 |
| 2009-01-30 09:25:00 | AAPL | Stock | 3.3018 | 3.3061 | 3.2993 | 3.3061 | 56000.0 |
| 2009-01-30 09:30:00 | AAPL | Stock | 3.3061 | 3.3357 | 3.3052 | 3.3211 | 20507424.0 |
| 2009-01-30 09:35:00 | AAPL | Stock | 3.3211 | 3.3382 | 3.3196 | 3.3329 | 11007248.0 |
| 2009-01-30 09:40:00 | AAPL | Stock | 3.3329 | 3.3436 | 3.3325 | 3.3339 | 9030980.0 |
| 2009-01-30 09:45:00 | AAPL | Stock | 3.3339 | 3.3357 | 3.3111 | 3.3132 | 11931892.0 |
| 2009-01-30 09:50:00 | AAPL | Stock | 3.3136 | 3.3189 | 3.2946 | 3.2946 | 17030020.0 |
| 2009-01-30 09:55:00 | AAPL | Stock | 3.2954 | 3.2989 | 3.2764 | 3.2771 | 16140348.0 |
| 2009-01-30 10:00:00 | AAPL | Stock | 3.2768 | 3.2875 | 3.27 | 3.2775 | 16143596.0 |
| 2009-01-30 10:05:00 | AAPL | Stock | 3.2771 | 3.2804 | 3.27 | 3.2771 | 10507980.0 |
| 2009-01-30 10:10:00 | AAPL | Stock | 3.2768 | 3.2789 | 3.2589 | 3.2668 | 13205892.0 |
| 2009-01-30 10:15:00 | AAPL | Stock | 3.2668 | 3.2796 | 3.2639 | 3.2675 | 8271620.0 |
| 2009-01-30 10:20:00 | AAPL | Stock | 3.2679 | 3.2768 | 3.2657 | 3.2736 | 6261220.0 |
| 2009-01-30 10:25:00 | AAPL | Stock | 3.2736 | 3.2764 | 3.26 | 3.2611 | 7442148.0 |
| 2009-01-30 10:30:00 | AAPL | Stock | 3.2607 | 3.2668 | 3.2525 | 3.2607 | 10513048.0 |
| 2009-01-30 10:35:00 | AAPL | Stock | 3.2607 | 3.2707 | 3.2607 | 3.2675 | 7528920.0 |
| 2009-01-30 10:40:00 | AAPL | Stock | 3.2672 | 3.275 | 3.2661 | 3.2714 | 8510740.0 |
| 2009-01-30 10:45:00 | AAPL | Stock | 3.2714 | 3.2732 | 3.2561 | 3.2575 | 7737492.0 |
| 2009-01-30 10:50:00 | AAPL | Stock | 3.2568 | 3.2604 | 3.2475 | 3.2604 | 8061788.0 |
| 2009-01-30 10:55:00 | AAPL | Stock | 3.2593 | 3.2657 | 3.2586 | 3.2632 | 4301752.0 |
| 2009-01-30 11:00:00 | AAPL | Stock | 3.2629 | 3.275 | 3.2625 | 3.2736 | 6486424.0 |
| 2009-01-30 11:05:00 | AAPL | Stock | 3.2736 | 3.2764 | 3.2693 | 3.2732 | 6599236.0 |
| 2009-01-30 11:10:00 | AAPL | Stock | 3.2729 | 3.2743 | 3.2639 | 3.2693 | 5601092.0 |
| 2009-01-30 11:15:00 | AAPL | Stock | 3.2686 | 3.27 | 3.2575 | 3.2575 | 5998552.0 |
| 2009-01-30 11:20:00 | AAPL | Stock | 3.2582 | 3.26 | 3.2525 | 3.2546 | 5509336.0 |
| 2009-01-30 11:25:00 | AAPL | Stock | 3.2539 | 3.2564 | 3.2468 | 3.2529 | 5201140.0 |
| 2009-01-30 11:30:00 | AAPL | Stock | 3.2529 | 3.2557 | 3.2494 | 3.2536 | 3452456.0 |
| 2009-01-30 11:35:00 | AAPL | Stock | 3.2539 | 3.2575 | 3.2504 | 3.2511 | 4310432.0 |
| 2009-01-30 11:40:00 | AAPL | Stock | 3.2518 | 3.2571 | 3.2518 | 3.2532 | 2959068.0 |
| 2009-01-30 11:45:00 | AAPL | Stock | 3.2529 | 3.2546 | 3.2436 | 3.2514 | 7812896.0 |
| 2009-01-30 11:50:00 | AAPL | Stock | 3.2514 | 3.2571 | 3.2507 | 3.2571 | 2328368.0 |
| 2009-01-30 11:55:00 | AAPL | Stock | 3.2571 | 3.2604 | 3.2532 | 3.2539 | 4102980.0 |
| 2009-01-30 12:00:00 | AAPL | Stock | 3.2543 | 3.2554 | 3.2364 | 3.2375 | 6188840.0 |
> showing 50 of 298,865 rows — these rows as CSV