PREVIEW / stock_5min / 2013-08-09
file: by_date/stock_5min/2013/2013-08-09.parquet size: 5.0 MB rows: 331,199 symbols: 3,522
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-09 04:20:00 | AAPL | Stock | 16.4446 | 16.4446 | 16.4446 | 16.4446 | 10640.0 |
| 2013-08-09 05:05:00 | AAPL | Stock | 16.4268 | 16.4268 | 16.3786 | 16.3786 | 11032.0 |
| 2013-08-09 07:00:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 3220.0 |
| 2013-08-09 07:25:00 | AAPL | Stock | 16.3896 | 16.3896 | 16.3896 | 16.3896 | 5600.0 |
| 2013-08-09 07:40:00 | AAPL | Stock | 16.4071 | 16.4143 | 16.4036 | 16.4143 | 43652.0 |
| 2013-08-09 07:50:00 | AAPL | Stock | 16.415 | 16.425 | 16.4143 | 16.425 | 33600.0 |
| 2013-08-09 07:55:00 | AAPL | Stock | 16.4175 | 16.4175 | 16.4161 | 16.4161 | 5600.0 |
| 2013-08-09 08:00:00 | AAPL | Stock | 16.3679 | 16.4161 | 16.3661 | 16.4089 | 84616.0 |
| 2013-08-09 08:05:00 | AAPL | Stock | 16.4014 | 16.4014 | 16.3857 | 16.3857 | 57400.0 |
| 2013-08-09 08:10:00 | AAPL | Stock | 16.3925 | 16.3929 | 16.3789 | 16.3925 | 60900.0 |
| 2013-08-09 08:15:00 | AAPL | Stock | 16.4089 | 16.4089 | 16.4089 | 16.4089 | 2800.0 |
| 2013-08-09 08:20:00 | AAPL | Stock | 16.4089 | 16.4089 | 16.4089 | 16.4089 | 8400.0 |
| 2013-08-09 08:25:00 | AAPL | Stock | 16.4089 | 16.4107 | 16.4086 | 16.4089 | 14000.0 |
| 2013-08-09 08:30:00 | AAPL | Stock | 16.4121 | 16.4121 | 16.3996 | 16.3996 | 28000.0 |
| 2013-08-09 08:45:00 | AAPL | Stock | 16.4104 | 16.4132 | 16.4068 | 16.4132 | 30800.0 |
| 2013-08-09 08:50:00 | AAPL | Stock | 16.4129 | 16.4211 | 16.3971 | 16.3986 | 91924.0 |
| 2013-08-09 08:55:00 | AAPL | Stock | 16.4107 | 16.4132 | 16.4107 | 16.4132 | 16800.0 |
| 2013-08-09 09:00:00 | AAPL | Stock | 16.42 | 16.42 | 16.4179 | 16.4179 | 11200.0 |
| 2013-08-09 09:05:00 | AAPL | Stock | 16.4125 | 16.4143 | 16.41 | 16.41 | 25200.0 |
| 2013-08-09 09:10:00 | AAPL | Stock | 16.4089 | 16.4161 | 16.4071 | 16.4139 | 72212.0 |
| 2013-08-09 09:20:00 | AAPL | Stock | 16.4114 | 16.4179 | 16.4071 | 16.4179 | 56196.0 |
| 2013-08-09 09:25:00 | AAPL | Stock | 16.4182 | 16.4286 | 16.3761 | 16.3804 | 264684.0 |
| 2013-08-09 09:30:00 | AAPL | Stock | 16.3782 | 16.4428 | 16.375 | 16.4389 | 9651404.0 |
| 2013-08-09 09:35:00 | AAPL | Stock | 16.4379 | 16.445 | 16.3929 | 16.3979 | 4851896.0 |
| 2013-08-09 09:40:00 | AAPL | Stock | 16.3979 | 16.4086 | 16.3525 | 16.3796 | 7185864.0 |
| 2013-08-09 09:45:00 | AAPL | Stock | 16.3814 | 16.4271 | 16.3614 | 16.4264 | 6295128.0 |
| 2013-08-09 09:50:00 | AAPL | Stock | 16.4264 | 16.4404 | 16.3696 | 16.3718 | 5944372.0 |
| 2013-08-09 09:55:00 | AAPL | Stock | 16.3739 | 16.3882 | 16.37 | 16.3793 | 8373960.0 |
| 2013-08-09 10:00:00 | AAPL | Stock | 16.3775 | 16.3971 | 16.3725 | 16.3734 | 3737356.0 |
| 2013-08-09 10:05:00 | AAPL | Stock | 16.3732 | 16.3789 | 16.2946 | 16.3239 | 10357676.0 |
| 2013-08-09 10:10:00 | AAPL | Stock | 16.3214 | 16.3311 | 16.3189 | 16.3307 | 4804492.0 |
| 2013-08-09 10:15:00 | AAPL | Stock | 16.3307 | 16.3525 | 16.3261 | 16.3443 | 4283216.0 |
| 2013-08-09 10:20:00 | AAPL | Stock | 16.3443 | 16.3607 | 16.3332 | 16.3464 | 6492640.0 |
| 2013-08-09 10:25:00 | AAPL | Stock | 16.3479 | 16.3496 | 16.3121 | 16.3318 | 4822188.0 |
| 2013-08-09 10:30:00 | AAPL | Stock | 16.3285 | 16.3407 | 16.2971 | 16.3004 | 3522064.0 |
| 2013-08-09 10:35:00 | AAPL | Stock | 16.3 | 16.3018 | 16.2621 | 16.2646 | 8202544.0 |
| 2013-08-09 10:40:00 | AAPL | Stock | 16.2609 | 16.3025 | 16.2571 | 16.3007 | 7901964.0 |
| 2013-08-09 10:45:00 | AAPL | Stock | 16.3004 | 16.3018 | 16.2714 | 16.2739 | 2551136.0 |
| 2013-08-09 10:50:00 | AAPL | Stock | 16.2743 | 16.2796 | 16.2536 | 16.2575 | 3551576.0 |
| 2013-08-09 10:55:00 | AAPL | Stock | 16.2539 | 16.2604 | 16.2268 | 16.2439 | 6366556.0 |
| 2013-08-09 11:00:00 | AAPL | Stock | 16.2446 | 16.2464 | 16.2329 | 16.2371 | 6844684.0 |
| 2013-08-09 11:05:00 | AAPL | Stock | 16.2371 | 16.2529 | 16.2361 | 16.2457 | 3889508.0 |
| 2013-08-09 11:10:00 | AAPL | Stock | 16.2457 | 16.2557 | 16.2364 | 16.2436 | 2690324.0 |
| 2013-08-09 11:15:00 | AAPL | Stock | 16.2436 | 16.2643 | 16.2396 | 16.2464 | 3324412.0 |
| 2013-08-09 11:20:00 | AAPL | Stock | 16.2446 | 16.2454 | 16.2336 | 16.2368 | 3618608.0 |
| 2013-08-09 11:25:00 | AAPL | Stock | 16.2368 | 16.255 | 16.2332 | 16.2546 | 4328772.0 |
| 2013-08-09 11:30:00 | AAPL | Stock | 16.2546 | 16.2696 | 16.2411 | 16.25 | 3080140.0 |
| 2013-08-09 11:35:00 | AAPL | Stock | 16.2517 | 16.2675 | 16.2487 | 16.2643 | 2009252.0 |
| 2013-08-09 11:40:00 | AAPL | Stock | 16.26 | 16.2661 | 16.2518 | 16.2554 | 1990744.0 |
| 2013-08-09 11:45:00 | AAPL | Stock | 16.2538 | 16.2596 | 16.2457 | 16.2559 | 1420580.0 |
> showing 50 of 331,199 rows — these rows as CSV