PREVIEW / stock_5min / 2013-06-17
file: by_date/stock_5min/2013/2013-06-17.parquet size: 5.2 MB rows: 347,547 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-17 04:00:00 | AAPL | Stock | 15.4361 | 15.4361 | 15.3571 | 15.4 | 19488.0 |
| 2013-06-17 04:05:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.4464 | 15.4464 | 2800.0 |
| 2013-06-17 04:10:00 | AAPL | Stock | 15.4579 | 15.4661 | 15.4579 | 15.4661 | 12068.0 |
| 2013-06-17 04:30:00 | AAPL | Stock | 15.4657 | 15.4657 | 15.4657 | 15.4657 | 2800.0 |
| 2013-06-17 05:50:00 | AAPL | Stock | 15.4664 | 15.4664 | 15.4664 | 15.4664 | 2800.0 |
| 2013-06-17 06:00:00 | AAPL | Stock | 15.4679 | 15.4679 | 15.4679 | 15.4679 | 2800.0 |
| 2013-06-17 06:05:00 | AAPL | Stock | 15.4732 | 15.4732 | 15.4732 | 15.4732 | 2800.0 |
| 2013-06-17 06:25:00 | AAPL | Stock | 15.4664 | 15.4664 | 15.4664 | 15.4664 | 2800.0 |
| 2013-06-17 06:45:00 | AAPL | Stock | 15.4696 | 15.4696 | 15.4696 | 15.4696 | 2800.0 |
| 2013-06-17 06:50:00 | AAPL | Stock | 15.4704 | 15.4704 | 15.4693 | 15.4693 | 5600.0 |
| 2013-06-17 06:55:00 | AAPL | Stock | 15.4664 | 15.4693 | 15.4664 | 15.4693 | 12656.0 |
| 2013-06-17 07:00:00 | AAPL | Stock | 15.4671 | 15.4814 | 15.4671 | 15.4729 | 51800.0 |
| 2013-06-17 07:05:00 | AAPL | Stock | 15.4786 | 15.4789 | 15.4664 | 15.4664 | 30800.0 |
| 2013-06-17 07:10:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4579 | 15.4579 | 12600.0 |
| 2013-06-17 07:15:00 | AAPL | Stock | 15.4564 | 15.4625 | 15.4564 | 15.4625 | 16800.0 |
| 2013-06-17 07:20:00 | AAPL | Stock | 15.4618 | 15.4618 | 15.4618 | 15.4618 | 2800.0 |
| 2013-06-17 07:25:00 | AAPL | Stock | 15.4514 | 15.4554 | 15.4514 | 15.4554 | 5600.0 |
| 2013-06-17 07:30:00 | AAPL | Stock | 15.4514 | 15.4571 | 15.4514 | 15.4571 | 16800.0 |
| 2013-06-17 07:35:00 | AAPL | Stock | 15.4536 | 15.4554 | 15.4357 | 15.4361 | 126700.0 |
| 2013-06-17 07:40:00 | AAPL | Stock | 15.4421 | 15.4679 | 15.4393 | 15.4393 | 166852.0 |
| 2013-06-17 07:45:00 | AAPL | Stock | 15.4375 | 15.4389 | 15.4175 | 15.4179 | 70000.0 |
| 2013-06-17 07:50:00 | AAPL | Stock | 15.42 | 15.4439 | 15.42 | 15.4379 | 99820.0 |
| 2013-06-17 07:55:00 | AAPL | Stock | 15.4446 | 15.4536 | 15.4396 | 15.4396 | 38920.0 |
| 2013-06-17 08:00:00 | AAPL | Stock | 15.4421 | 15.4679 | 15.4179 | 15.4429 | 246904.0 |
| 2013-06-17 08:05:00 | AAPL | Stock | 15.4393 | 15.4414 | 15.4268 | 15.4286 | 215600.0 |
| 2013-06-17 08:10:00 | AAPL | Stock | 15.4214 | 15.4286 | 15.4057 | 15.4057 | 177436.0 |
| 2013-06-17 08:15:00 | AAPL | Stock | 15.4071 | 15.4161 | 15.4011 | 15.4129 | 95844.0 |
| 2013-06-17 08:20:00 | AAPL | Stock | 15.4143 | 15.44 | 15.4143 | 15.44 | 183120.0 |
| 2013-06-17 08:25:00 | AAPL | Stock | 15.4321 | 15.4321 | 15.4218 | 15.4218 | 8400.0 |
| 2013-06-17 08:30:00 | AAPL | Stock | 15.4286 | 15.4625 | 15.4286 | 15.4482 | 208236.0 |
| 2013-06-17 08:35:00 | AAPL | Stock | 15.4514 | 15.4514 | 15.4429 | 15.4461 | 109816.0 |
| 2013-06-17 08:40:00 | AAPL | Stock | 15.45 | 15.45 | 15.4382 | 15.44 | 40600.0 |
| 2013-06-17 08:45:00 | AAPL | Stock | 15.4407 | 15.4446 | 15.4361 | 15.4436 | 52500.0 |
| 2013-06-17 08:50:00 | AAPL | Stock | 15.4364 | 15.4364 | 15.4214 | 15.4268 | 145432.0 |
| 2013-06-17 08:55:00 | AAPL | Stock | 15.4286 | 15.4304 | 15.4236 | 15.4286 | 53200.0 |
| 2013-06-17 09:00:00 | AAPL | Stock | 15.4271 | 15.4286 | 15.4243 | 15.4243 | 68740.0 |
| 2013-06-17 09:05:00 | AAPL | Stock | 15.4246 | 15.4257 | 15.4032 | 15.4039 | 178052.0 |
| 2013-06-17 09:10:00 | AAPL | Stock | 15.405 | 15.4196 | 15.405 | 15.4164 | 11200.0 |
| 2013-06-17 09:15:00 | AAPL | Stock | 15.4175 | 15.4271 | 15.4143 | 15.4268 | 100156.0 |
| 2013-06-17 09:20:00 | AAPL | Stock | 15.4232 | 15.4286 | 15.4196 | 15.4196 | 100240.0 |
| 2013-06-17 09:25:00 | AAPL | Stock | 15.4161 | 15.4193 | 15.4032 | 15.4107 | 239876.0 |
| 2013-06-17 09:30:00 | AAPL | Stock | 15.4086 | 15.4518 | 15.3825 | 15.3957 | 12806528.0 |
| 2013-06-17 09:35:00 | AAPL | Stock | 15.397 | 15.4264 | 15.3701 | 15.3968 | 6865208.0 |
| 2013-06-17 09:40:00 | AAPL | Stock | 15.4035 | 15.4393 | 15.3789 | 15.4343 | 7721560.0 |
| 2013-06-17 09:45:00 | AAPL | Stock | 15.4297 | 15.4457 | 15.3893 | 15.3996 | 6698776.0 |
| 2013-06-17 09:50:00 | AAPL | Stock | 15.4007 | 15.4286 | 15.3954 | 15.4279 | 8132488.0 |
| 2013-06-17 09:55:00 | AAPL | Stock | 15.4282 | 15.4286 | 15.3989 | 15.4057 | 3402756.0 |
| 2013-06-17 10:00:00 | AAPL | Stock | 15.4061 | 15.4136 | 15.3771 | 15.3979 | 6200348.0 |
| 2013-06-17 10:05:00 | AAPL | Stock | 15.3979 | 15.5189 | 15.3936 | 15.5113 | 14276332.0 |
| 2013-06-17 10:10:00 | AAPL | Stock | 15.5061 | 15.5179 | 15.4714 | 15.4925 | 6271664.0 |
> showing 50 of 347,547 rows — these rows as CSV