PREVIEW / stock_5min / 2011-05-04
file: by_date/stock_5min/2011/2011-05-04.parquet size: 5.0 MB rows: 336,755 symbols: 3,550
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-04 04:40:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 2800.0 |
| 2011-05-04 05:10:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 2800.0 |
| 2011-05-04 06:00:00 | AAPL | Stock | 12.4579 | 12.4579 | 12.4579 | 12.4579 | 2800.0 |
| 2011-05-04 06:45:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 2800.0 |
| 2011-05-04 07:25:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-05-04 07:45:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 2800.0 |
| 2011-05-04 07:55:00 | AAPL | Stock | 12.4279 | 12.4279 | 12.4279 | 12.4279 | 2800.0 |
| 2011-05-04 08:00:00 | AAPL | Stock | 12.4214 | 12.4357 | 12.4214 | 12.4357 | 65380.0 |
| 2011-05-04 08:05:00 | AAPL | Stock | 12.4368 | 12.4589 | 12.4368 | 12.4514 | 55580.0 |
| 2011-05-04 08:10:00 | AAPL | Stock | 12.4464 | 12.4554 | 12.4393 | 12.4396 | 84000.0 |
| 2011-05-04 08:15:00 | AAPL | Stock | 12.4396 | 12.4468 | 12.4368 | 12.4468 | 59500.0 |
| 2011-05-04 08:20:00 | AAPL | Stock | 12.445 | 12.445 | 12.4396 | 12.4411 | 20020.0 |
| 2011-05-04 08:25:00 | AAPL | Stock | 12.4457 | 12.4554 | 12.4457 | 12.4554 | 58800.0 |
| 2011-05-04 08:30:00 | AAPL | Stock | 12.45 | 12.4514 | 12.45 | 12.4514 | 10668.0 |
| 2011-05-04 08:35:00 | AAPL | Stock | 12.4339 | 12.4471 | 12.4339 | 12.4382 | 76132.0 |
| 2011-05-04 08:40:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 9800.0 |
| 2011-05-04 08:45:00 | AAPL | Stock | 12.4457 | 12.4589 | 12.4457 | 12.4539 | 156604.0 |
| 2011-05-04 08:50:00 | AAPL | Stock | 12.4579 | 12.4582 | 12.4536 | 12.4582 | 40600.0 |
| 2011-05-04 08:55:00 | AAPL | Stock | 12.4564 | 12.4564 | 12.4511 | 12.4518 | 24808.0 |
| 2011-05-04 09:00:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.45 | 12.4518 | 58576.0 |
| 2011-05-04 09:05:00 | AAPL | Stock | 12.4521 | 12.4521 | 12.4486 | 12.4486 | 11200.0 |
| 2011-05-04 09:10:00 | AAPL | Stock | 12.4479 | 12.4493 | 12.4464 | 12.4479 | 133840.0 |
| 2011-05-04 09:15:00 | AAPL | Stock | 12.4464 | 12.4536 | 12.4464 | 12.4532 | 92400.0 |
| 2011-05-04 09:20:00 | AAPL | Stock | 12.4532 | 12.4532 | 12.4532 | 12.4532 | 2800.0 |
| 2011-05-04 09:25:00 | AAPL | Stock | 12.4564 | 12.4589 | 12.4325 | 12.4429 | 133672.0 |
| 2011-05-04 09:30:00 | AAPL | Stock | 12.4379 | 12.4425 | 12.3886 | 12.4232 | 9477972.0 |
| 2011-05-04 09:35:00 | AAPL | Stock | 12.4262 | 12.4893 | 12.4262 | 12.486 | 10672088.0 |
| 2011-05-04 09:40:00 | AAPL | Stock | 12.4857 | 12.5114 | 12.4725 | 12.4947 | 13199368.0 |
| 2011-05-04 09:45:00 | AAPL | Stock | 12.4946 | 12.5471 | 12.4822 | 12.5471 | 14025312.0 |
| 2011-05-04 09:50:00 | AAPL | Stock | 12.5471 | 12.5654 | 12.495 | 12.5032 | 13953688.0 |
| 2011-05-04 09:55:00 | AAPL | Stock | 12.5039 | 12.5429 | 12.4657 | 12.4979 | 14343196.0 |
| 2011-05-04 10:00:00 | AAPL | Stock | 12.4975 | 12.5064 | 12.4464 | 12.505 | 12402740.0 |
| 2011-05-04 10:05:00 | AAPL | Stock | 12.5036 | 12.5046 | 12.4596 | 12.4886 | 7996380.0 |
| 2011-05-04 10:10:00 | AAPL | Stock | 12.4886 | 12.5089 | 12.4774 | 12.4907 | 5883752.0 |
| 2011-05-04 10:15:00 | AAPL | Stock | 12.4907 | 12.5179 | 12.4893 | 12.5129 | 5858580.0 |
| 2011-05-04 10:20:00 | AAPL | Stock | 12.5136 | 12.5357 | 12.5061 | 12.5104 | 6455708.0 |
| 2011-05-04 10:25:00 | AAPL | Stock | 12.51 | 12.53 | 12.5054 | 12.5143 | 3814216.0 |
| 2011-05-04 10:30:00 | AAPL | Stock | 12.5143 | 12.5357 | 12.5075 | 12.5207 | 4167884.0 |
| 2011-05-04 10:35:00 | AAPL | Stock | 12.5221 | 12.5243 | 12.4757 | 12.5043 | 7627004.0 |
| 2011-05-04 10:40:00 | AAPL | Stock | 12.5039 | 12.5107 | 12.4675 | 12.4761 | 4873288.0 |
| 2011-05-04 10:45:00 | AAPL | Stock | 12.4754 | 12.4896 | 12.4589 | 12.4793 | 8332828.0 |
| 2011-05-04 10:50:00 | AAPL | Stock | 12.4793 | 12.5046 | 12.4743 | 12.4914 | 5523448.0 |
| 2011-05-04 10:55:00 | AAPL | Stock | 12.4921 | 12.5071 | 12.4889 | 12.4979 | 4178692.0 |
| 2011-05-04 11:00:00 | AAPL | Stock | 12.4993 | 12.5082 | 12.4732 | 12.4817 | 3541692.0 |
| 2011-05-04 11:05:00 | AAPL | Stock | 12.4818 | 12.4918 | 12.4743 | 12.4796 | 2788016.0 |
| 2011-05-04 11:10:00 | AAPL | Stock | 12.4796 | 12.4982 | 12.475 | 12.4821 | 2835420.0 |
| 2011-05-04 11:15:00 | AAPL | Stock | 12.4819 | 12.4819 | 12.4143 | 12.4275 | 11541068.0 |
| 2011-05-04 11:20:00 | AAPL | Stock | 12.4277 | 12.4439 | 12.4179 | 12.4334 | 3637312.0 |
| 2011-05-04 11:25:00 | AAPL | Stock | 12.4338 | 12.4711 | 12.4226 | 12.4582 | 5403496.0 |
| 2011-05-04 11:30:00 | AAPL | Stock | 12.4579 | 12.4636 | 12.4429 | 12.4589 | 2566452.0 |
> showing 50 of 336,755 rows — these rows as CSV