PREVIEW / stock_5min / 2008-07-11
file: by_date/stock_5min/2008/2008-07-11.parquet size: 4.5 MB rows: 319,922 symbols: 3,330
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-07-11 06:15:00 | AAPL | Stock | 6.3179 | 6.3179 | 6.3179 | 6.3179 | 11200.0 |
| 2008-07-11 06:45:00 | AAPL | Stock | 6.3179 | 6.3179 | 6.3179 | 6.3179 | 21000.0 |
| 2008-07-11 06:50:00 | AAPL | Stock | 6.3218 | 6.3218 | 6.3071 | 6.3075 | 36400.0 |
| 2008-07-11 06:55:00 | AAPL | Stock | 6.3143 | 6.3143 | 6.3143 | 6.3143 | 2800.0 |
| 2008-07-11 07:00:00 | AAPL | Stock | 6.3071 | 6.3071 | 6.3036 | 6.3071 | 16800.0 |
| 2008-07-11 07:05:00 | AAPL | Stock | 6.3054 | 6.3171 | 6.3036 | 6.3171 | 17780.0 |
| 2008-07-11 07:10:00 | AAPL | Stock | 6.3032 | 6.3107 | 6.2968 | 6.2971 | 75600.0 |
| 2008-07-11 07:15:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2839 | 6.2839 | 75600.0 |
| 2008-07-11 07:20:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2839 | 6.2839 | 19600.0 |
| 2008-07-11 07:25:00 | AAPL | Stock | 6.2839 | 6.2839 | 6.2679 | 6.2682 | 33600.0 |
| 2008-07-11 07:30:00 | AAPL | Stock | 6.2679 | 6.2893 | 6.2679 | 6.2893 | 18200.0 |
| 2008-07-11 07:35:00 | AAPL | Stock | 6.2821 | 6.2821 | 6.2732 | 6.2732 | 58800.0 |
| 2008-07-11 07:40:00 | AAPL | Stock | 6.2732 | 6.275 | 6.2725 | 6.275 | 58800.0 |
| 2008-07-11 07:45:00 | AAPL | Stock | 6.2729 | 6.2729 | 6.2518 | 6.2589 | 104160.0 |
| 2008-07-11 07:50:00 | AAPL | Stock | 6.25 | 6.2589 | 6.25 | 6.2589 | 22456.0 |
| 2008-07-11 07:55:00 | AAPL | Stock | 6.2518 | 6.2589 | 6.2429 | 6.2429 | 38080.0 |
| 2008-07-11 08:00:00 | AAPL | Stock | 6.25 | 6.2821 | 6.25 | 6.2679 | 352604.0 |
| 2008-07-11 08:05:00 | AAPL | Stock | 6.2654 | 6.2654 | 6.2446 | 6.2468 | 135296.0 |
| 2008-07-11 08:10:00 | AAPL | Stock | 6.25 | 6.2675 | 6.2464 | 6.2607 | 155568.0 |
| 2008-07-11 08:15:00 | AAPL | Stock | 6.2589 | 6.2625 | 6.2536 | 6.2571 | 66668.0 |
| 2008-07-11 08:20:00 | AAPL | Stock | 6.26 | 6.26 | 6.25 | 6.2596 | 60760.0 |
| 2008-07-11 08:25:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.2321 | 6.24 | 509264.0 |
| 2008-07-11 08:30:00 | AAPL | Stock | 6.2393 | 6.2604 | 6.2221 | 6.2221 | 684320.0 |
| 2008-07-11 08:35:00 | AAPL | Stock | 6.2221 | 6.2275 | 6.2214 | 6.2271 | 280644.0 |
| 2008-07-11 08:40:00 | AAPL | Stock | 6.2339 | 6.2339 | 6.2218 | 6.2261 | 196168.0 |
| 2008-07-11 08:45:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2161 | 6.2186 | 142100.0 |
| 2008-07-11 08:50:00 | AAPL | Stock | 6.2179 | 6.2321 | 6.2179 | 6.2311 | 150780.0 |
| 2008-07-11 08:55:00 | AAPL | Stock | 6.2314 | 6.2321 | 6.2268 | 6.2268 | 142996.0 |
| 2008-07-11 09:00:00 | AAPL | Stock | 6.2254 | 6.2271 | 6.2143 | 6.2196 | 235200.0 |
| 2008-07-11 09:05:00 | AAPL | Stock | 6.2196 | 6.24 | 6.2168 | 6.24 | 813176.0 |
| 2008-07-11 09:10:00 | AAPL | Stock | 6.2461 | 6.2643 | 6.2461 | 6.2554 | 707420.0 |
| 2008-07-11 09:15:00 | AAPL | Stock | 6.2554 | 6.2832 | 6.2536 | 6.2771 | 422520.0 |
| 2008-07-11 09:20:00 | AAPL | Stock | 6.2729 | 6.2768 | 6.2625 | 6.2643 | 447020.0 |
| 2008-07-11 09:25:00 | AAPL | Stock | 6.2664 | 6.2682 | 6.2536 | 6.2664 | 1041040.0 |
| 2008-07-11 09:30:00 | AAPL | Stock | 6.2668 | 6.275 | 6.1921 | 6.23 | 27919724.0 |
| 2008-07-11 09:35:00 | AAPL | Stock | 6.2296 | 6.2625 | 6.2232 | 6.2423 | 19101964.0 |
| 2008-07-11 09:40:00 | AAPL | Stock | 6.2439 | 6.25 | 6.2082 | 6.2496 | 14071428.0 |
| 2008-07-11 09:45:00 | AAPL | Stock | 6.2496 | 6.2786 | 6.236 | 6.2729 | 17489612.0 |
| 2008-07-11 09:50:00 | AAPL | Stock | 6.2704 | 6.3232 | 6.2689 | 6.3179 | 20731928.0 |
| 2008-07-11 09:55:00 | AAPL | Stock | 6.3125 | 6.3254 | 6.2896 | 6.2957 | 17846500.0 |
| 2008-07-11 10:00:00 | AAPL | Stock | 6.2943 | 6.3214 | 6.2714 | 6.3194 | 14235144.0 |
| 2008-07-11 10:05:00 | AAPL | Stock | 6.3132 | 6.3214 | 6.2818 | 6.3032 | 13464948.0 |
| 2008-07-11 10:10:00 | AAPL | Stock | 6.3039 | 6.3039 | 6.2714 | 6.2829 | 8297716.0 |
| 2008-07-11 10:15:00 | AAPL | Stock | 6.2832 | 6.2836 | 6.2339 | 6.2429 | 15316812.0 |
| 2008-07-11 10:20:00 | AAPL | Stock | 6.2429 | 6.2557 | 6.2221 | 6.2421 | 11977840.0 |
| 2008-07-11 10:25:00 | AAPL | Stock | 6.2421 | 6.2593 | 6.2075 | 6.2318 | 16856252.0 |
| 2008-07-11 10:30:00 | AAPL | Stock | 6.2332 | 6.2571 | 6.2161 | 6.2404 | 10043124.0 |
| 2008-07-11 10:35:00 | AAPL | Stock | 6.2396 | 6.24 | 6.2036 | 6.2229 | 10800580.0 |
| 2008-07-11 10:40:00 | AAPL | Stock | 6.2229 | 6.2464 | 6.2186 | 6.2314 | 7587188.0 |
| 2008-07-11 10:45:00 | AAPL | Stock | 6.2329 | 6.2486 | 6.2232 | 6.2364 | 5995668.0 |
> showing 50 of 319,922 rows — these rows as CSV