PREVIEW / stock_5min / 2011-07-05
file: by_date/stock_5min/2011/2011-07-05.parquet size: 4.8 MB rows: 329,740 symbols: 3,526
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-07-05 04:15:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 05:45:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 05:55:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 28000.0 |
| 2011-07-05 06:30:00 | AAPL | Stock | 12.225 | 12.225 | 12.225 | 12.225 | 5600.0 |
| 2011-07-05 06:40:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 06:45:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 07:00:00 | AAPL | Stock | 12.2289 | 12.25 | 12.2289 | 12.2446 | 50400.0 |
| 2011-07-05 07:05:00 | AAPL | Stock | 12.2429 | 12.2532 | 12.2429 | 12.2532 | 32704.0 |
| 2011-07-05 07:10:00 | AAPL | Stock | 12.2218 | 12.2286 | 12.2214 | 12.2286 | 11200.0 |
| 2011-07-05 07:15:00 | AAPL | Stock | 12.2357 | 12.2364 | 12.2189 | 12.2189 | 47600.0 |
| 2011-07-05 07:20:00 | AAPL | Stock | 12.2329 | 12.2329 | 12.2329 | 12.2329 | 16800.0 |
| 2011-07-05 07:35:00 | AAPL | Stock | 12.2446 | 12.2446 | 12.2311 | 12.2314 | 16800.0 |
| 2011-07-05 07:45:00 | AAPL | Stock | 12.2321 | 12.2464 | 12.2314 | 12.2314 | 33180.0 |
| 2011-07-05 07:55:00 | AAPL | Stock | 12.2404 | 12.2404 | 12.2404 | 12.2404 | 2800.0 |
| 2011-07-05 08:00:00 | AAPL | Stock | 12.2496 | 12.2536 | 12.2414 | 12.2504 | 321636.0 |
| 2011-07-05 08:05:00 | AAPL | Stock | 12.2504 | 12.2504 | 12.2489 | 12.25 | 44100.0 |
| 2011-07-05 08:15:00 | AAPL | Stock | 12.25 | 12.2518 | 12.2496 | 12.2518 | 37240.0 |
| 2011-07-05 08:20:00 | AAPL | Stock | 12.2539 | 12.2539 | 12.2461 | 12.2461 | 41300.0 |
| 2011-07-05 08:25:00 | AAPL | Stock | 12.2439 | 12.25 | 12.2436 | 12.25 | 15764.0 |
| 2011-07-05 08:30:00 | AAPL | Stock | 12.2482 | 12.25 | 12.2432 | 12.25 | 13860.0 |
| 2011-07-05 08:35:00 | AAPL | Stock | 12.2464 | 12.25 | 12.2464 | 12.25 | 11200.0 |
| 2011-07-05 08:40:00 | AAPL | Stock | 12.2436 | 12.2446 | 12.2404 | 12.2429 | 47320.0 |
| 2011-07-05 08:50:00 | AAPL | Stock | 12.2493 | 12.2493 | 12.2357 | 12.2357 | 25760.0 |
| 2011-07-05 08:55:00 | AAPL | Stock | 12.2429 | 12.2429 | 12.2429 | 12.2429 | 14728.0 |
| 2011-07-05 09:00:00 | AAPL | Stock | 12.2396 | 12.2411 | 12.2396 | 12.2407 | 14000.0 |
| 2011-07-05 09:05:00 | AAPL | Stock | 12.2411 | 12.2411 | 12.2375 | 12.2375 | 78232.0 |
| 2011-07-05 09:10:00 | AAPL | Stock | 12.2411 | 12.25 | 12.2411 | 12.2486 | 53200.0 |
| 2011-07-05 09:20:00 | AAPL | Stock | 12.2418 | 12.2418 | 12.2393 | 12.2411 | 47180.0 |
| 2011-07-05 09:25:00 | AAPL | Stock | 12.2414 | 12.2496 | 12.2389 | 12.2496 | 297080.0 |
| 2011-07-05 09:30:00 | AAPL | Stock | 12.2464 | 12.3171 | 12.2321 | 12.3168 | 11378640.0 |
| 2011-07-05 09:35:00 | AAPL | Stock | 12.3157 | 12.3729 | 12.3157 | 12.3661 | 14734720.0 |
| 2011-07-05 09:40:00 | AAPL | Stock | 12.3636 | 12.3714 | 12.3364 | 12.3395 | 10543484.0 |
| 2011-07-05 09:45:00 | AAPL | Stock | 12.3407 | 12.3964 | 12.3357 | 12.3907 | 9513616.0 |
| 2011-07-05 09:50:00 | AAPL | Stock | 12.3886 | 12.3939 | 12.375 | 12.3939 | 6155492.0 |
| 2011-07-05 09:55:00 | AAPL | Stock | 12.3939 | 12.4296 | 12.3875 | 12.4109 | 10762864.0 |
| 2011-07-05 10:00:00 | AAPL | Stock | 12.4107 | 12.4368 | 12.4057 | 12.4361 | 6931736.0 |
| 2011-07-05 10:05:00 | AAPL | Stock | 12.4361 | 12.4643 | 12.4304 | 12.4393 | 11889808.0 |
| 2011-07-05 10:10:00 | AAPL | Stock | 12.4393 | 12.4586 | 12.4314 | 12.4414 | 6971664.0 |
| 2011-07-05 10:15:00 | AAPL | Stock | 12.4414 | 12.443 | 12.3904 | 12.3905 | 9624720.0 |
| 2011-07-05 10:20:00 | AAPL | Stock | 12.3904 | 12.4064 | 12.3811 | 12.3822 | 5154016.0 |
| 2011-07-05 10:25:00 | AAPL | Stock | 12.3829 | 12.4 | 12.3796 | 12.3861 | 5900104.0 |
| 2011-07-05 10:30:00 | AAPL | Stock | 12.3861 | 12.4279 | 12.3835 | 12.4175 | 6705496.0 |
| 2011-07-05 10:35:00 | AAPL | Stock | 12.4168 | 12.4286 | 12.4161 | 12.4182 | 3576216.0 |
| 2011-07-05 10:40:00 | AAPL | Stock | 12.4179 | 12.4446 | 12.4114 | 12.4368 | 5222560.0 |
| 2011-07-05 10:45:00 | AAPL | Stock | 12.4377 | 12.4518 | 12.4336 | 12.4364 | 4486552.0 |
| 2011-07-05 10:50:00 | AAPL | Stock | 12.4361 | 12.4393 | 12.4264 | 12.4357 | 4461940.0 |
| 2011-07-05 10:55:00 | AAPL | Stock | 12.435 | 12.4371 | 12.4196 | 12.4225 | 3249512.0 |
| 2011-07-05 11:00:00 | AAPL | Stock | 12.4225 | 12.4314 | 12.4121 | 12.4149 | 3551296.0 |
| 2011-07-05 11:05:00 | AAPL | Stock | 12.4154 | 12.4354 | 12.4096 | 12.4304 | 3869012.0 |
| 2011-07-05 11:10:00 | AAPL | Stock | 12.4286 | 12.4464 | 12.423 | 12.4464 | 3006612.0 |
> showing 50 of 329,740 rows — these rows as CSV