PREVIEW / stock_5min / 2013-06-13
file: by_date/stock_5min/2013/2013-06-13.parquet size: 5.1 MB rows: 338,363 symbols: 3,488
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-06-13 04:00:00 | AAPL | Stock | 15.4214 | 15.4257 | 15.2696 | 15.4257 | 38444.0 |
| 2013-06-13 04:30:00 | AAPL | Stock | 15.3168 | 15.3168 | 15.3168 | 15.3168 | 2800.0 |
| 2013-06-13 04:35:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.3036 | 15.3036 | 2800.0 |
| 2013-06-13 05:00:00 | AAPL | Stock | 15.2896 | 15.2896 | 15.2896 | 15.2896 | 2800.0 |
| 2013-06-13 05:10:00 | AAPL | Stock | 15.3164 | 15.3164 | 15.3164 | 15.3164 | 17780.0 |
| 2013-06-13 05:20:00 | AAPL | Stock | 15.3093 | 15.3214 | 15.2946 | 15.3214 | 35000.0 |
| 2013-06-13 05:25:00 | AAPL | Stock | 15.3243 | 15.3243 | 15.3243 | 15.3243 | 14000.0 |
| 2013-06-13 05:30:00 | AAPL | Stock | 15.3243 | 15.3243 | 15.3214 | 15.3214 | 16800.0 |
| 2013-06-13 05:40:00 | AAPL | Stock | 15.3282 | 15.3286 | 15.3282 | 15.3286 | 5600.0 |
| 2013-06-13 06:30:00 | AAPL | Stock | 15.3896 | 15.3896 | 15.3882 | 15.3882 | 8400.0 |
| 2013-06-13 06:40:00 | AAPL | Stock | 15.3904 | 15.3904 | 15.3904 | 15.3904 | 5320.0 |
| 2013-06-13 06:45:00 | AAPL | Stock | 15.3829 | 15.3829 | 15.3829 | 15.3829 | 13692.0 |
| 2013-06-13 06:50:00 | AAPL | Stock | 15.3814 | 15.3814 | 15.3814 | 15.3814 | 2800.0 |
| 2013-06-13 07:00:00 | AAPL | Stock | 15.3879 | 15.3889 | 15.375 | 15.3771 | 56000.0 |
| 2013-06-13 07:05:00 | AAPL | Stock | 15.37 | 15.3836 | 15.3571 | 15.3586 | 47600.0 |
| 2013-06-13 07:10:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 2800.0 |
| 2013-06-13 07:15:00 | AAPL | Stock | 15.3536 | 15.3661 | 15.3536 | 15.3661 | 66192.0 |
| 2013-06-13 07:20:00 | AAPL | Stock | 15.3661 | 15.3668 | 15.3661 | 15.3668 | 8400.0 |
| 2013-06-13 07:30:00 | AAPL | Stock | 15.3682 | 15.3682 | 15.3486 | 15.3486 | 81088.0 |
| 2013-06-13 07:35:00 | AAPL | Stock | 15.3668 | 15.3839 | 15.3668 | 15.3836 | 64400.0 |
| 2013-06-13 07:40:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 30912.0 |
| 2013-06-13 07:50:00 | AAPL | Stock | 15.3832 | 15.3929 | 15.3818 | 15.3929 | 25200.0 |
| 2013-06-13 07:55:00 | AAPL | Stock | 15.3771 | 15.4096 | 15.3771 | 15.3821 | 35000.0 |
| 2013-06-13 08:00:00 | AAPL | Stock | 15.3804 | 15.5 | 15.3482 | 15.3854 | 231560.0 |
| 2013-06-13 08:05:00 | AAPL | Stock | 15.3857 | 15.3875 | 15.375 | 15.3857 | 138824.0 |
| 2013-06-13 08:10:00 | AAPL | Stock | 15.3871 | 15.3871 | 15.3804 | 15.3821 | 44548.0 |
| 2013-06-13 08:15:00 | AAPL | Stock | 15.3786 | 15.3821 | 15.3643 | 15.3671 | 119532.0 |
| 2013-06-13 08:20:00 | AAPL | Stock | 15.3714 | 15.3893 | 15.3646 | 15.3893 | 215180.0 |
| 2013-06-13 08:25:00 | AAPL | Stock | 15.3911 | 15.4011 | 15.3911 | 15.3929 | 197092.0 |
| 2013-06-13 08:30:00 | AAPL | Stock | 15.3929 | 15.4643 | 15.3929 | 15.4643 | 504644.0 |
| 2013-06-13 08:35:00 | AAPL | Stock | 15.4575 | 15.465 | 15.4296 | 15.4354 | 511112.0 |
| 2013-06-13 08:40:00 | AAPL | Stock | 15.4289 | 15.4621 | 15.4289 | 15.4511 | 325976.0 |
| 2013-06-13 08:45:00 | AAPL | Stock | 15.4554 | 15.4714 | 15.4554 | 15.4714 | 195972.0 |
| 2013-06-13 08:50:00 | AAPL | Stock | 15.4714 | 15.4986 | 15.4714 | 15.4875 | 397040.0 |
| 2013-06-13 08:55:00 | AAPL | Stock | 15.4882 | 15.5357 | 15.4879 | 15.52 | 883624.0 |
| 2013-06-13 09:00:00 | AAPL | Stock | 15.5196 | 15.5293 | 15.5054 | 15.5054 | 237216.0 |
| 2013-06-13 09:05:00 | AAPL | Stock | 15.5039 | 15.5068 | 15.4929 | 15.5 | 176092.0 |
| 2013-06-13 09:10:00 | AAPL | Stock | 15.5 | 15.5 | 15.4654 | 15.4714 | 181048.0 |
| 2013-06-13 09:15:00 | AAPL | Stock | 15.4711 | 15.4982 | 15.4711 | 15.4979 | 119560.0 |
| 2013-06-13 09:20:00 | AAPL | Stock | 15.495 | 15.5 | 15.48 | 15.4975 | 268632.0 |
| 2013-06-13 09:25:00 | AAPL | Stock | 15.4943 | 15.4975 | 15.4375 | 15.4375 | 837116.0 |
| 2013-06-13 09:30:00 | AAPL | Stock | 15.4411 | 15.5143 | 15.4211 | 15.46 | 15666308.0 |
| 2013-06-13 09:35:00 | AAPL | Stock | 15.4532 | 15.46 | 15.3757 | 15.4171 | 9255260.0 |
| 2013-06-13 09:40:00 | AAPL | Stock | 15.4136 | 15.5243 | 15.4043 | 15.5 | 13422668.0 |
| 2013-06-13 09:45:00 | AAPL | Stock | 15.5 | 15.5107 | 15.4486 | 15.4643 | 7397824.0 |
| 2013-06-13 09:50:00 | AAPL | Stock | 15.4596 | 15.4918 | 15.455 | 15.4761 | 6575296.0 |
| 2013-06-13 09:55:00 | AAPL | Stock | 15.4746 | 15.4811 | 15.4536 | 15.4579 | 3692304.0 |
| 2013-06-13 10:00:00 | AAPL | Stock | 15.4636 | 15.4636 | 15.4061 | 15.4457 | 7514752.0 |
| 2013-06-13 10:05:00 | AAPL | Stock | 15.4511 | 15.4604 | 15.3286 | 15.3286 | 10632720.0 |
| 2013-06-13 10:10:00 | AAPL | Stock | 15.3293 | 15.3589 | 15.3186 | 15.3251 | 9325400.0 |
> showing 50 of 338,363 rows — these rows as CSV