PREVIEW / stock_5min / 2014-02-27
file: by_date/stock_5min/2014/2014-02-27.parquet size: 5.4 MB rows: 357,209 symbols: 3,541
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-27 04:00:00 | AAPL | Stock | 18.4964 | 18.4964 | 18.4964 | 18.4964 | 2800.0 |
| 2014-02-27 04:10:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 5600.0 |
| 2014-02-27 04:15:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 5600.0 |
| 2014-02-27 04:20:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 16044.0 |
| 2014-02-27 04:25:00 | AAPL | Stock | 18.4161 | 18.4161 | 18.4161 | 18.4161 | 5432.0 |
| 2014-02-27 04:30:00 | AAPL | Stock | 18.5054 | 18.5054 | 18.3929 | 18.3929 | 8400.0 |
| 2014-02-27 04:45:00 | AAPL | Stock | 18.4082 | 18.4082 | 18.3929 | 18.3929 | 20664.0 |
| 2014-02-27 04:55:00 | AAPL | Stock | 18.3768 | 18.3768 | 18.3764 | 18.3764 | 5600.0 |
| 2014-02-27 05:10:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 2800.0 |
| 2014-02-27 06:00:00 | AAPL | Stock | 18.4196 | 18.4196 | 18.4196 | 18.4196 | 2800.0 |
| 2014-02-27 06:05:00 | AAPL | Stock | 18.3946 | 18.3946 | 18.3939 | 18.3939 | 8400.0 |
| 2014-02-27 06:10:00 | AAPL | Stock | 18.3629 | 18.3629 | 18.3629 | 18.3629 | 2800.0 |
| 2014-02-27 06:15:00 | AAPL | Stock | 18.3704 | 18.3704 | 18.3704 | 18.3704 | 2800.0 |
| 2014-02-27 06:25:00 | AAPL | Stock | 18.3746 | 18.3746 | 18.3746 | 18.3746 | 5908.0 |
| 2014-02-27 06:30:00 | AAPL | Stock | 18.3736 | 18.3736 | 18.3736 | 18.3736 | 2800.0 |
| 2014-02-27 06:35:00 | AAPL | Stock | 18.3886 | 18.3886 | 18.3886 | 18.3886 | 5600.0 |
| 2014-02-27 06:40:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2014-02-27 06:55:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 5600.0 |
| 2014-02-27 07:00:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 8400.0 |
| 2014-02-27 07:05:00 | AAPL | Stock | 18.4086 | 18.4275 | 18.4086 | 18.4275 | 18200.0 |
| 2014-02-27 07:15:00 | AAPL | Stock | 18.4 | 18.4 | 18.4 | 18.4 | 5600.0 |
| 2014-02-27 07:20:00 | AAPL | Stock | 18.4071 | 18.4107 | 18.4071 | 18.4107 | 15428.0 |
| 2014-02-27 07:25:00 | AAPL | Stock | 18.4275 | 18.4546 | 18.4211 | 18.4546 | 44940.0 |
| 2014-02-27 07:30:00 | AAPL | Stock | 18.4357 | 18.4357 | 18.4107 | 18.4107 | 99400.0 |
| 2014-02-27 07:35:00 | AAPL | Stock | 18.4107 | 18.4107 | 18.4054 | 18.4054 | 14000.0 |
| 2014-02-27 07:40:00 | AAPL | Stock | 18.4036 | 18.4036 | 18.4036 | 18.4036 | 4536.0 |
| 2014-02-27 07:45:00 | AAPL | Stock | 18.4036 | 18.4036 | 18.4036 | 18.4036 | 17332.0 |
| 2014-02-27 07:50:00 | AAPL | Stock | 18.4093 | 18.4093 | 18.4036 | 18.4036 | 24248.0 |
| 2014-02-27 07:55:00 | AAPL | Stock | 18.4125 | 18.4125 | 18.4104 | 18.4125 | 38948.0 |
| 2014-02-27 08:00:00 | AAPL | Stock | 18.4268 | 18.4268 | 18.375 | 18.4004 | 105364.0 |
| 2014-02-27 08:05:00 | AAPL | Stock | 18.3971 | 18.3971 | 18.3839 | 18.3839 | 189336.0 |
| 2014-02-27 08:10:00 | AAPL | Stock | 18.3968 | 18.4071 | 18.3968 | 18.4071 | 11200.0 |
| 2014-02-27 08:15:00 | AAPL | Stock | 18.4121 | 18.425 | 18.4107 | 18.4107 | 31500.0 |
| 2014-02-27 08:20:00 | AAPL | Stock | 18.4111 | 18.4196 | 18.4111 | 18.4196 | 11620.0 |
| 2014-02-27 08:25:00 | AAPL | Stock | 18.4111 | 18.4286 | 18.4111 | 18.4286 | 112000.0 |
| 2014-02-27 08:30:00 | AAPL | Stock | 18.4364 | 18.4396 | 18.4364 | 18.4393 | 64400.0 |
| 2014-02-27 08:35:00 | AAPL | Stock | 18.4414 | 18.45 | 18.4404 | 18.45 | 71400.0 |
| 2014-02-27 08:40:00 | AAPL | Stock | 18.45 | 18.4554 | 18.4411 | 18.4554 | 135548.0 |
| 2014-02-27 08:45:00 | AAPL | Stock | 18.4554 | 18.4554 | 18.4546 | 18.4554 | 11872.0 |
| 2014-02-27 08:50:00 | AAPL | Stock | 18.4468 | 18.4639 | 18.445 | 18.4621 | 56000.0 |
| 2014-02-27 08:55:00 | AAPL | Stock | 18.4543 | 18.46 | 18.4432 | 18.4464 | 139860.0 |
| 2014-02-27 09:00:00 | AAPL | Stock | 18.4429 | 18.4643 | 18.4429 | 18.4511 | 123228.0 |
| 2014-02-27 09:05:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 4536.0 |
| 2014-02-27 09:10:00 | AAPL | Stock | 18.4714 | 18.4714 | 18.4714 | 18.4714 | 2800.0 |
| 2014-02-27 09:15:00 | AAPL | Stock | 18.4725 | 18.5104 | 18.4725 | 18.4946 | 157276.0 |
| 2014-02-27 09:20:00 | AAPL | Stock | 18.4764 | 18.4821 | 18.4764 | 18.4821 | 55300.0 |
| 2014-02-27 09:25:00 | AAPL | Stock | 18.4818 | 18.4846 | 18.4671 | 18.4771 | 625296.0 |
| 2014-02-27 09:30:00 | AAPL | Stock | 18.4707 | 18.5643 | 18.4693 | 18.5139 | 13576108.0 |
| 2014-02-27 09:35:00 | AAPL | Stock | 18.5193 | 18.5282 | 18.4304 | 18.4845 | 6283340.0 |
| 2014-02-27 09:40:00 | AAPL | Stock | 18.4814 | 18.4986 | 18.4475 | 18.4732 | 3201548.0 |
> showing 50 of 357,209 rows — these rows as CSV