PREVIEW / stock_5min / 2009-11-12
file: by_date/stock_5min/2009/2009-11-12.parquet size: 4.6 MB rows: 316,175 symbols: 3,401
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-11-12 05:15:00 | AAPL | Stock | 7.2379 | 7.2379 | 7.2379 | 7.2379 | 6888.0 |
| 2009-11-12 05:30:00 | AAPL | Stock | 7.2571 | 7.2571 | 7.2571 | 7.2571 | 2800.0 |
| 2009-11-12 07:15:00 | AAPL | Stock | 7.25 | 7.25 | 7.2296 | 7.2296 | 11200.0 |
| 2009-11-12 07:20:00 | AAPL | Stock | 7.2296 | 7.2296 | 7.2232 | 7.2296 | 29288.0 |
| 2009-11-12 07:25:00 | AAPL | Stock | 7.2296 | 7.2296 | 7.2296 | 7.2296 | 2800.0 |
| 2009-11-12 07:30:00 | AAPL | Stock | 7.2304 | 7.2304 | 7.2296 | 7.2296 | 21280.0 |
| 2009-11-12 07:45:00 | AAPL | Stock | 7.2321 | 7.2321 | 7.2286 | 7.2286 | 5600.0 |
| 2009-11-12 07:50:00 | AAPL | Stock | 7.2239 | 7.2239 | 7.2239 | 7.2239 | 2800.0 |
| 2009-11-12 07:55:00 | AAPL | Stock | 7.2239 | 7.2239 | 7.2239 | 7.2239 | 2800.0 |
| 2009-11-12 08:00:00 | AAPL | Stock | 7.2182 | 7.2371 | 7.2182 | 7.2336 | 61040.0 |
| 2009-11-12 08:05:00 | AAPL | Stock | 7.2336 | 7.2339 | 7.2321 | 7.2321 | 25620.0 |
| 2009-11-12 08:10:00 | AAPL | Stock | 7.2339 | 7.2339 | 7.2321 | 7.2321 | 30772.0 |
| 2009-11-12 08:15:00 | AAPL | Stock | 7.2368 | 7.2429 | 7.2368 | 7.2393 | 33516.0 |
| 2009-11-12 08:20:00 | AAPL | Stock | 7.2464 | 7.2479 | 7.2464 | 7.2464 | 26180.0 |
| 2009-11-12 08:25:00 | AAPL | Stock | 7.2411 | 7.2482 | 7.2411 | 7.2482 | 35196.0 |
| 2009-11-12 08:30:00 | AAPL | Stock | 7.2464 | 7.2529 | 7.2382 | 7.2421 | 109956.0 |
| 2009-11-12 08:35:00 | AAPL | Stock | 7.2362 | 7.2429 | 7.2361 | 7.2429 | 80360.0 |
| 2009-11-12 08:40:00 | AAPL | Stock | 7.2393 | 7.2493 | 7.2336 | 7.2446 | 130760.0 |
| 2009-11-12 08:45:00 | AAPL | Stock | 7.2479 | 7.2493 | 7.2461 | 7.2468 | 53200.0 |
| 2009-11-12 08:50:00 | AAPL | Stock | 7.2464 | 7.2464 | 7.2416 | 7.2464 | 19600.0 |
| 2009-11-12 08:55:00 | AAPL | Stock | 7.2421 | 7.2454 | 7.2391 | 7.2436 | 52220.0 |
| 2009-11-12 09:00:00 | AAPL | Stock | 7.2425 | 7.2439 | 7.2425 | 7.2439 | 16800.0 |
| 2009-11-12 09:05:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2425 | 7.2425 | 16800.0 |
| 2009-11-12 09:10:00 | AAPL | Stock | 7.2425 | 7.2461 | 7.2425 | 7.2461 | 64400.0 |
| 2009-11-12 09:15:00 | AAPL | Stock | 7.2429 | 7.2461 | 7.2425 | 7.2427 | 22400.0 |
| 2009-11-12 09:20:00 | AAPL | Stock | 7.2464 | 7.25 | 7.2432 | 7.25 | 141092.0 |
| 2009-11-12 09:25:00 | AAPL | Stock | 7.2518 | 7.2604 | 7.25 | 7.2604 | 79548.0 |
| 2009-11-12 09:30:00 | AAPL | Stock | 7.2604 | 7.2964 | 7.255 | 7.2846 | 12166896.0 |
| 2009-11-12 09:35:00 | AAPL | Stock | 7.2847 | 7.2914 | 7.2757 | 7.2793 | 7535780.0 |
| 2009-11-12 09:40:00 | AAPL | Stock | 7.2807 | 7.2911 | 7.2786 | 7.2816 | 8330896.0 |
| 2009-11-12 09:45:00 | AAPL | Stock | 7.2786 | 7.2986 | 7.2675 | 7.2968 | 7993860.0 |
| 2009-11-12 09:50:00 | AAPL | Stock | 7.2981 | 7.3125 | 7.2921 | 7.3064 | 10768940.0 |
| 2009-11-12 09:55:00 | AAPL | Stock | 7.3081 | 7.3168 | 7.3046 | 7.3079 | 9251312.0 |
| 2009-11-12 10:00:00 | AAPL | Stock | 7.3089 | 7.3146 | 7.2968 | 7.3025 | 5929812.0 |
| 2009-11-12 10:05:00 | AAPL | Stock | 7.3032 | 7.3057 | 7.2814 | 7.2846 | 6257496.0 |
| 2009-11-12 10:10:00 | AAPL | Stock | 7.2843 | 7.2893 | 7.2714 | 7.2864 | 6786780.0 |
| 2009-11-12 10:15:00 | AAPL | Stock | 7.2868 | 7.2893 | 7.2686 | 7.2696 | 3690428.0 |
| 2009-11-12 10:20:00 | AAPL | Stock | 7.2689 | 7.2814 | 7.2643 | 7.2786 | 5913600.0 |
| 2009-11-12 10:25:00 | AAPL | Stock | 7.2784 | 7.3007 | 7.2764 | 7.2971 | 5393332.0 |
| 2009-11-12 10:30:00 | AAPL | Stock | 7.2968 | 7.3036 | 7.2857 | 7.3025 | 5751984.0 |
| 2009-11-12 10:35:00 | AAPL | Stock | 7.3014 | 7.3054 | 7.2971 | 7.2984 | 3885784.0 |
| 2009-11-12 10:40:00 | AAPL | Stock | 7.2986 | 7.3121 | 7.2936 | 7.3104 | 3669176.0 |
| 2009-11-12 10:45:00 | AAPL | Stock | 7.3114 | 7.3132 | 7.3046 | 7.3046 | 4794412.0 |
| 2009-11-12 10:50:00 | AAPL | Stock | 7.3061 | 7.3104 | 7.2964 | 7.3018 | 4611432.0 |
| 2009-11-12 10:55:00 | AAPL | Stock | 7.3018 | 7.3025 | 7.2832 | 7.2836 | 4616416.0 |
| 2009-11-12 11:00:00 | AAPL | Stock | 7.2836 | 7.2864 | 7.2739 | 7.2857 | 8006936.0 |
| 2009-11-12 11:05:00 | AAPL | Stock | 7.2854 | 7.2857 | 7.2775 | 7.28 | 2284884.0 |
| 2009-11-12 11:10:00 | AAPL | Stock | 7.2804 | 7.2814 | 7.2658 | 7.2679 | 7936068.0 |
| 2009-11-12 11:15:00 | AAPL | Stock | 7.2679 | 7.2804 | 7.2625 | 7.2804 | 5433568.0 |
| 2009-11-12 11:20:00 | AAPL | Stock | 7.28 | 7.2829 | 7.2739 | 7.2825 | 3700200.0 |
> showing 50 of 316,175 rows — these rows as CSV