PREVIEW / stock_5min / 2011-08-24
file: by_date/stock_5min/2011/2011-08-24.parquet size: 4.8 MB rows: 329,210 symbols: 3,501
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-24 04:00:00 | AAPL | Stock | 13.2075 | 13.2368 | 13.2075 | 13.2368 | 11200.0 |
| 2011-08-24 04:05:00 | AAPL | Stock | 13.2457 | 13.2457 | 13.2457 | 13.2457 | 2800.0 |
| 2011-08-24 04:10:00 | AAPL | Stock | 13.2179 | 13.2457 | 13.2179 | 13.2457 | 5600.0 |
| 2011-08-24 04:20:00 | AAPL | Stock | 13.2507 | 13.2714 | 13.2507 | 13.2714 | 8400.0 |
| 2011-08-24 04:40:00 | AAPL | Stock | 13.2714 | 13.2714 | 13.2714 | 13.2714 | 2800.0 |
| 2011-08-24 05:00:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 2800.0 |
| 2011-08-24 05:05:00 | AAPL | Stock | 13.3207 | 13.3214 | 13.3207 | 13.3214 | 5600.0 |
| 2011-08-24 05:55:00 | AAPL | Stock | 13.3304 | 13.3304 | 13.3304 | 13.3304 | 2800.0 |
| 2011-08-24 06:00:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.3036 | 13.3036 | 11200.0 |
| 2011-08-24 06:05:00 | AAPL | Stock | 13.29 | 13.2918 | 13.29 | 13.2918 | 5600.0 |
| 2011-08-24 06:10:00 | AAPL | Stock | 13.2864 | 13.2864 | 13.2839 | 13.2839 | 5600.0 |
| 2011-08-24 06:15:00 | AAPL | Stock | 13.2907 | 13.2907 | 13.2907 | 13.2907 | 2800.0 |
| 2011-08-24 06:25:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 2800.0 |
| 2011-08-24 06:40:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 2800.0 |
| 2011-08-24 06:45:00 | AAPL | Stock | 13.3032 | 13.3032 | 13.2786 | 13.2786 | 5600.0 |
| 2011-08-24 06:55:00 | AAPL | Stock | 13.2786 | 13.2786 | 13.2536 | 13.2536 | 47096.0 |
| 2011-08-24 07:00:00 | AAPL | Stock | 13.255 | 13.255 | 13.2264 | 13.2418 | 63700.0 |
| 2011-08-24 07:05:00 | AAPL | Stock | 13.2411 | 13.2411 | 13.2411 | 13.2411 | 2800.0 |
| 2011-08-24 07:10:00 | AAPL | Stock | 13.2361 | 13.2857 | 13.2339 | 13.2857 | 80220.0 |
| 2011-08-24 07:15:00 | AAPL | Stock | 13.2857 | 13.295 | 13.2857 | 13.2861 | 38920.0 |
| 2011-08-24 07:20:00 | AAPL | Stock | 13.3032 | 13.3039 | 13.2896 | 13.3036 | 136668.0 |
| 2011-08-24 07:25:00 | AAPL | Stock | 13.3036 | 13.3293 | 13.3 | 13.3179 | 124404.0 |
| 2011-08-24 07:30:00 | AAPL | Stock | 13.3071 | 13.3143 | 13.3064 | 13.3125 | 36400.0 |
| 2011-08-24 07:35:00 | AAPL | Stock | 13.3139 | 13.3229 | 13.3089 | 13.3207 | 73360.0 |
| 2011-08-24 07:40:00 | AAPL | Stock | 13.3286 | 13.3357 | 13.3164 | 13.3164 | 115920.0 |
| 2011-08-24 07:45:00 | AAPL | Stock | 13.3139 | 13.3139 | 13.2929 | 13.2929 | 64568.0 |
| 2011-08-24 07:50:00 | AAPL | Stock | 13.3179 | 13.3196 | 13.3104 | 13.3104 | 8400.0 |
| 2011-08-24 07:55:00 | AAPL | Stock | 13.2932 | 13.2932 | 13.2857 | 13.2857 | 19600.0 |
| 2011-08-24 08:00:00 | AAPL | Stock | 13.2868 | 13.2964 | 13.2318 | 13.2343 | 546700.0 |
| 2011-08-24 08:05:00 | AAPL | Stock | 13.2393 | 13.2482 | 13.2239 | 13.2311 | 364308.0 |
| 2011-08-24 08:10:00 | AAPL | Stock | 13.2364 | 13.2421 | 13.2261 | 13.2421 | 157724.0 |
| 2011-08-24 08:15:00 | AAPL | Stock | 13.2343 | 13.2679 | 13.2321 | 13.2482 | 350812.0 |
| 2011-08-24 08:20:00 | AAPL | Stock | 13.2482 | 13.2629 | 13.2464 | 13.2539 | 239540.0 |
| 2011-08-24 08:25:00 | AAPL | Stock | 13.2614 | 13.265 | 13.2357 | 13.2357 | 302876.0 |
| 2011-08-24 08:30:00 | AAPL | Stock | 13.2425 | 13.3193 | 13.2425 | 13.3125 | 992852.0 |
| 2011-08-24 08:35:00 | AAPL | Stock | 13.3193 | 13.3293 | 13.2954 | 13.3125 | 528920.0 |
| 2011-08-24 08:40:00 | AAPL | Stock | 13.3121 | 13.3354 | 13.3082 | 13.3286 | 594692.0 |
| 2011-08-24 08:45:00 | AAPL | Stock | 13.325 | 13.3318 | 13.3143 | 13.3214 | 494312.0 |
| 2011-08-24 08:50:00 | AAPL | Stock | 13.3189 | 13.3357 | 13.3146 | 13.3329 | 372372.0 |
| 2011-08-24 08:55:00 | AAPL | Stock | 13.3329 | 13.3411 | 13.33 | 13.3361 | 270620.0 |
| 2011-08-24 09:00:00 | AAPL | Stock | 13.3386 | 13.3439 | 13.325 | 13.3286 | 599032.0 |
| 2011-08-24 09:05:00 | AAPL | Stock | 13.3282 | 13.3371 | 13.3218 | 13.3336 | 364644.0 |
| 2011-08-24 09:10:00 | AAPL | Stock | 13.3336 | 13.3429 | 13.3325 | 13.3325 | 359688.0 |
| 2011-08-24 09:15:00 | AAPL | Stock | 13.3332 | 13.3425 | 13.3236 | 13.3425 | 217672.0 |
| 2011-08-24 09:20:00 | AAPL | Stock | 13.3375 | 13.3429 | 13.3332 | 13.3357 | 176540.0 |
| 2011-08-24 09:25:00 | AAPL | Stock | 13.3307 | 13.3375 | 13.3239 | 13.3282 | 74340.0 |
| 2011-08-24 09:30:00 | AAPL | Stock | 13.333 | 13.4528 | 13.3043 | 13.434 | 22006880.0 |
| 2011-08-24 09:35:00 | AAPL | Stock | 13.4311 | 13.4414 | 13.3929 | 13.4018 | 16847236.0 |
| 2011-08-24 09:40:00 | AAPL | Stock | 13.4046 | 13.4429 | 13.3996 | 13.4382 | 11696776.0 |
| 2011-08-24 09:45:00 | AAPL | Stock | 13.4389 | 13.4411 | 13.4107 | 13.4264 | 13487264.0 |
> showing 50 of 329,210 rows — these rows as CSV