PREVIEW / stock_5min / 2013-06-26
file: by_date/stock_5min/2013/2013-06-26.parquet size: 5.2 MB rows: 346,216 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 |
|---|---|---|---|---|---|---|---|
| 2013-06-26 04:40:00 | AAPL | Stock | 14.4139 | 14.4139 | 14.4139 | 14.4139 | 8400.0 |
| 2013-06-26 04:45:00 | AAPL | Stock | 14.4361 | 14.4361 | 14.4361 | 14.4361 | 2800.0 |
| 2013-06-26 04:55:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4107 | 14.4107 | 9240.0 |
| 2013-06-26 05:55:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 5600.0 |
| 2013-06-26 06:00:00 | AAPL | Stock | 14.4361 | 14.4414 | 14.4361 | 14.4414 | 29288.0 |
| 2013-06-26 06:10:00 | AAPL | Stock | 14.4414 | 14.4414 | 14.4414 | 14.4414 | 2800.0 |
| 2013-06-26 06:15:00 | AAPL | Stock | 14.4546 | 14.4554 | 14.4546 | 14.4554 | 26600.0 |
| 2013-06-26 06:20:00 | AAPL | Stock | 14.4511 | 14.4511 | 14.4511 | 14.4511 | 2800.0 |
| 2013-06-26 06:25:00 | AAPL | Stock | 14.4511 | 14.4511 | 14.4511 | 14.4511 | 11200.0 |
| 2013-06-26 06:45:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 2800.0 |
| 2013-06-26 07:05:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4175 | 14.4175 | 42000.0 |
| 2013-06-26 07:10:00 | AAPL | Stock | 14.4146 | 14.4286 | 14.4111 | 14.4286 | 19600.0 |
| 2013-06-26 07:20:00 | AAPL | Stock | 14.4107 | 14.4321 | 14.4107 | 14.4286 | 42700.0 |
| 2013-06-26 07:25:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 3640.0 |
| 2013-06-26 07:30:00 | AAPL | Stock | 14.4286 | 14.4357 | 14.4286 | 14.4357 | 5600.0 |
| 2013-06-26 07:35:00 | AAPL | Stock | 14.4407 | 14.4407 | 14.4407 | 14.4407 | 2800.0 |
| 2013-06-26 07:50:00 | AAPL | Stock | 14.4336 | 14.4336 | 14.4336 | 14.4336 | 2800.0 |
| 2013-06-26 07:55:00 | AAPL | Stock | 14.4339 | 14.4343 | 14.4214 | 14.4286 | 131908.0 |
| 2013-06-26 08:00:00 | AAPL | Stock | 14.4264 | 14.4429 | 14.4111 | 14.4193 | 113904.0 |
| 2013-06-26 08:05:00 | AAPL | Stock | 14.41 | 14.4157 | 14.41 | 14.4125 | 14000.0 |
| 2013-06-26 08:10:00 | AAPL | Stock | 14.4071 | 14.4071 | 14.3857 | 14.4 | 72100.0 |
| 2013-06-26 08:15:00 | AAPL | Stock | 14.3929 | 14.4143 | 14.3914 | 14.4 | 106400.0 |
| 2013-06-26 08:20:00 | AAPL | Stock | 14.4039 | 14.4107 | 14.4025 | 14.4054 | 86800.0 |
| 2013-06-26 08:25:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4071 | 14.4071 | 14000.0 |
| 2013-06-26 08:30:00 | AAPL | Stock | 14.3893 | 14.3929 | 14.3832 | 14.3929 | 25200.0 |
| 2013-06-26 08:35:00 | AAPL | Stock | 14.4104 | 14.4104 | 14.3761 | 14.3768 | 48692.0 |
| 2013-06-26 08:40:00 | AAPL | Stock | 14.3764 | 14.3839 | 14.3661 | 14.3761 | 89880.0 |
| 2013-06-26 08:45:00 | AAPL | Stock | 14.3821 | 14.3821 | 14.3689 | 14.3775 | 24360.0 |
| 2013-06-26 08:50:00 | AAPL | Stock | 14.3754 | 14.3804 | 14.3714 | 14.3804 | 11200.0 |
| 2013-06-26 08:55:00 | AAPL | Stock | 14.3814 | 14.3893 | 14.3814 | 14.3893 | 17360.0 |
| 2013-06-26 09:00:00 | AAPL | Stock | 14.3825 | 14.4014 | 14.3821 | 14.4014 | 28000.0 |
| 2013-06-26 09:05:00 | AAPL | Stock | 14.3929 | 14.3939 | 14.3875 | 14.3939 | 69272.0 |
| 2013-06-26 09:10:00 | AAPL | Stock | 14.395 | 14.4036 | 14.395 | 14.4036 | 95200.0 |
| 2013-06-26 09:15:00 | AAPL | Stock | 14.4025 | 14.4107 | 14.4025 | 14.4107 | 50540.0 |
| 2013-06-26 09:20:00 | AAPL | Stock | 14.4107 | 14.4175 | 14.4107 | 14.4175 | 84028.0 |
| 2013-06-26 09:25:00 | AAPL | Stock | 14.4196 | 14.4314 | 14.4132 | 14.4143 | 105112.0 |
| 2013-06-26 09:30:00 | AAPL | Stock | 14.4179 | 14.4568 | 14.3789 | 14.4021 | 11635876.0 |
| 2013-06-26 09:35:00 | AAPL | Stock | 14.4021 | 14.4071 | 14.3307 | 14.3365 | 10217144.0 |
| 2013-06-26 09:40:00 | AAPL | Stock | 14.3354 | 14.3404 | 14.2857 | 14.2857 | 12846344.0 |
| 2013-06-26 09:45:00 | AAPL | Stock | 14.2857 | 14.3204 | 14.2779 | 14.3143 | 10283644.0 |
| 2013-06-26 09:50:00 | AAPL | Stock | 14.3186 | 14.3329 | 14.2893 | 14.3021 | 5196548.0 |
| 2013-06-26 09:55:00 | AAPL | Stock | 14.2992 | 14.3179 | 14.2821 | 14.295 | 6179292.0 |
| 2013-06-26 10:00:00 | AAPL | Stock | 14.2943 | 14.3482 | 14.2875 | 14.3179 | 7820036.0 |
| 2013-06-26 10:05:00 | AAPL | Stock | 14.3212 | 14.3304 | 14.2439 | 14.2586 | 11626580.0 |
| 2013-06-26 10:10:00 | AAPL | Stock | 14.2612 | 14.275 | 14.2479 | 14.2743 | 5216764.0 |
| 2013-06-26 10:15:00 | AAPL | Stock | 14.271 | 14.272 | 14.22 | 14.2504 | 8027124.0 |
| 2013-06-26 10:20:00 | AAPL | Stock | 14.2493 | 14.2996 | 14.245 | 14.2779 | 7237216.0 |
| 2013-06-26 10:25:00 | AAPL | Stock | 14.2768 | 14.2857 | 14.2557 | 14.2621 | 3013836.0 |
| 2013-06-26 10:30:00 | AAPL | Stock | 14.2621 | 14.275 | 14.25 | 14.2636 | 3092852.0 |
| 2013-06-26 10:35:00 | AAPL | Stock | 14.2636 | 14.2818 | 14.2571 | 14.2679 | 2933364.0 |
> showing 50 of 346,216 rows — these rows as CSV