PREVIEW / stock_5min / 2013-05-09
file: by_date/stock_5min/2013/2013-05-09.parquet size: 5.1 MB rows: 336,580 symbols: 3,494
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-05-09 04:05:00 | AAPL | Stock | 16.5275 | 16.5275 | 16.5139 | 16.5139 | 14000.0 |
| 2013-05-09 04:10:00 | AAPL | Stock | 16.5139 | 16.5264 | 16.5139 | 16.5246 | 19600.0 |
| 2013-05-09 04:20:00 | AAPL | Stock | 16.5182 | 16.5186 | 16.475 | 16.4821 | 27860.0 |
| 2013-05-09 04:50:00 | AAPL | Stock | 16.5036 | 16.5036 | 16.5036 | 16.5036 | 2800.0 |
| 2013-05-09 05:30:00 | AAPL | Stock | 16.4821 | 16.4821 | 16.475 | 16.475 | 8400.0 |
| 2013-05-09 05:40:00 | AAPL | Stock | 16.475 | 16.475 | 16.475 | 16.475 | 2800.0 |
| 2013-05-09 06:05:00 | AAPL | Stock | 16.4671 | 16.4675 | 16.4643 | 16.4643 | 14056.0 |
| 2013-05-09 06:10:00 | AAPL | Stock | 16.4671 | 16.4671 | 16.4671 | 16.4671 | 2800.0 |
| 2013-05-09 06:15:00 | AAPL | Stock | 16.4671 | 16.4671 | 16.4671 | 16.4671 | 2800.0 |
| 2013-05-09 06:20:00 | AAPL | Stock | 16.4671 | 16.4671 | 16.4671 | 16.4671 | 4648.0 |
| 2013-05-09 06:25:00 | AAPL | Stock | 16.4554 | 16.4554 | 16.4357 | 16.4357 | 38920.0 |
| 2013-05-09 06:30:00 | AAPL | Stock | 16.4432 | 16.4454 | 16.4418 | 16.4454 | 18228.0 |
| 2013-05-09 06:45:00 | AAPL | Stock | 16.4439 | 16.4454 | 16.4439 | 16.4454 | 11200.0 |
| 2013-05-09 06:50:00 | AAPL | Stock | 16.4357 | 16.4357 | 16.4107 | 16.4168 | 25200.0 |
| 2013-05-09 06:55:00 | AAPL | Stock | 16.4429 | 16.4429 | 16.4429 | 16.4429 | 2800.0 |
| 2013-05-09 07:00:00 | AAPL | Stock | 16.4357 | 16.4464 | 16.4357 | 16.4464 | 34272.0 |
| 2013-05-09 07:05:00 | AAPL | Stock | 16.4571 | 16.5 | 16.4571 | 16.5 | 74760.0 |
| 2013-05-09 07:10:00 | AAPL | Stock | 16.5071 | 16.5071 | 16.4821 | 16.4911 | 27692.0 |
| 2013-05-09 07:15:00 | AAPL | Stock | 16.5004 | 16.5004 | 16.4821 | 16.4886 | 112532.0 |
| 2013-05-09 07:20:00 | AAPL | Stock | 16.4839 | 16.4925 | 16.4839 | 16.4925 | 38976.0 |
| 2013-05-09 07:25:00 | AAPL | Stock | 16.4911 | 16.4964 | 16.4729 | 16.4821 | 26096.0 |
| 2013-05-09 07:30:00 | AAPL | Stock | 16.4857 | 16.4857 | 16.4857 | 16.4857 | 11200.0 |
| 2013-05-09 07:35:00 | AAPL | Stock | 16.4857 | 16.4861 | 16.4732 | 16.4732 | 92400.0 |
| 2013-05-09 07:40:00 | AAPL | Stock | 16.4718 | 16.4771 | 16.4711 | 16.4771 | 11200.0 |
| 2013-05-09 07:45:00 | AAPL | Stock | 16.4643 | 16.4786 | 16.4643 | 16.4786 | 11200.0 |
| 2013-05-09 07:50:00 | AAPL | Stock | 16.4786 | 16.4786 | 16.4643 | 16.4686 | 277256.0 |
| 2013-05-09 07:55:00 | AAPL | Stock | 16.4696 | 16.4696 | 16.4329 | 16.4446 | 110264.0 |
| 2013-05-09 08:00:00 | AAPL | Stock | 16.445 | 16.4925 | 16.3857 | 16.3929 | 588756.0 |
| 2013-05-09 08:05:00 | AAPL | Stock | 16.4107 | 16.4129 | 16.3929 | 16.4036 | 224840.0 |
| 2013-05-09 08:10:00 | AAPL | Stock | 16.4 | 16.4107 | 16.3964 | 16.4043 | 323512.0 |
| 2013-05-09 08:15:00 | AAPL | Stock | 16.4 | 16.4107 | 16.3929 | 16.4004 | 251580.0 |
| 2013-05-09 08:20:00 | AAPL | Stock | 16.4004 | 16.4218 | 16.4004 | 16.4218 | 192220.0 |
| 2013-05-09 08:25:00 | AAPL | Stock | 16.4214 | 16.4286 | 16.4107 | 16.4218 | 155932.0 |
| 2013-05-09 08:30:00 | AAPL | Stock | 16.4218 | 16.4579 | 16.4218 | 16.4464 | 202048.0 |
| 2013-05-09 08:35:00 | AAPL | Stock | 16.4464 | 16.4714 | 16.4464 | 16.4714 | 489048.0 |
| 2013-05-09 08:40:00 | AAPL | Stock | 16.4646 | 16.4646 | 16.4296 | 16.4529 | 449708.0 |
| 2013-05-09 08:45:00 | AAPL | Stock | 16.4504 | 16.4536 | 16.4243 | 16.4286 | 144256.0 |
| 2013-05-09 08:50:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4196 | 16.4214 | 126000.0 |
| 2013-05-09 08:55:00 | AAPL | Stock | 16.4286 | 16.4354 | 16.4179 | 16.4354 | 93268.0 |
| 2013-05-09 09:00:00 | AAPL | Stock | 16.4357 | 16.4543 | 16.4354 | 16.4511 | 147056.0 |
| 2013-05-09 09:05:00 | AAPL | Stock | 16.4357 | 16.4496 | 16.4354 | 16.4461 | 110040.0 |
| 2013-05-09 09:10:00 | AAPL | Stock | 16.4464 | 16.4464 | 16.4236 | 16.425 | 161840.0 |
| 2013-05-09 09:15:00 | AAPL | Stock | 16.4246 | 16.4268 | 16.4179 | 16.4179 | 196868.0 |
| 2013-05-09 09:20:00 | AAPL | Stock | 16.4154 | 16.425 | 16.4139 | 16.4232 | 398776.0 |
| 2013-05-09 09:25:00 | AAPL | Stock | 16.4225 | 16.425 | 16.4107 | 16.4143 | 228984.0 |
| 2013-05-09 09:30:00 | AAPL | Stock | 16.4218 | 16.475 | 16.3429 | 16.4638 | 20382992.0 |
| 2013-05-09 09:35:00 | AAPL | Stock | 16.4575 | 16.5143 | 16.4575 | 16.5089 | 13302212.0 |
| 2013-05-09 09:40:00 | AAPL | Stock | 16.5054 | 16.5357 | 16.4471 | 16.4475 | 13053012.0 |
| 2013-05-09 09:45:00 | AAPL | Stock | 16.4504 | 16.4743 | 16.3804 | 16.3821 | 12338144.0 |
| 2013-05-09 09:50:00 | AAPL | Stock | 16.3852 | 16.4368 | 16.3761 | 16.4136 | 10582936.0 |
> showing 50 of 336,580 rows — these rows as CSV