PREVIEW / stock_5min / 2013-04-11
file: by_date/stock_5min/2013/2013-04-11.parquet size: 5.0 MB rows: 329,657 symbols: 3,465
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-04-11 04:00:00 | AAPL | Stock | 15.5421 | 15.5421 | 15.5357 | 15.5357 | 11200.0 |
| 2013-04-11 04:30:00 | AAPL | Stock | 15.5268 | 15.5268 | 15.5268 | 15.5268 | 2800.0 |
| 2013-04-11 04:50:00 | AAPL | Stock | 15.5675 | 15.5714 | 15.5675 | 15.5714 | 11200.0 |
| 2013-04-11 05:30:00 | AAPL | Stock | 15.5504 | 15.5504 | 15.5489 | 15.5489 | 15484.0 |
| 2013-04-11 05:50:00 | AAPL | Stock | 15.5707 | 15.5707 | 15.5707 | 15.5707 | 11592.0 |
| 2013-04-11 06:20:00 | AAPL | Stock | 15.5811 | 15.5811 | 15.5811 | 15.5811 | 2800.0 |
| 2013-04-11 06:35:00 | AAPL | Stock | 15.5736 | 15.5743 | 15.5736 | 15.5736 | 30800.0 |
| 2013-04-11 06:50:00 | AAPL | Stock | 15.5604 | 15.5604 | 15.5486 | 15.5486 | 28840.0 |
| 2013-04-11 07:10:00 | AAPL | Stock | 15.5414 | 15.5414 | 15.5357 | 15.5357 | 20160.0 |
| 2013-04-11 07:15:00 | AAPL | Stock | 15.5357 | 15.5361 | 15.5336 | 15.5336 | 30072.0 |
| 2013-04-11 07:20:00 | AAPL | Stock | 15.5029 | 15.5036 | 15.4879 | 15.4964 | 57092.0 |
| 2013-04-11 07:25:00 | AAPL | Stock | 15.4911 | 15.4986 | 15.4861 | 15.4911 | 93800.0 |
| 2013-04-11 07:30:00 | AAPL | Stock | 15.4911 | 15.4914 | 15.4875 | 15.4875 | 40628.0 |
| 2013-04-11 07:35:00 | AAPL | Stock | 15.4821 | 15.4821 | 15.4464 | 15.4639 | 92148.0 |
| 2013-04-11 07:40:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4179 | 15.4296 | 221900.0 |
| 2013-04-11 07:45:00 | AAPL | Stock | 15.4564 | 15.4564 | 15.4329 | 15.4414 | 42532.0 |
| 2013-04-11 07:50:00 | AAPL | Stock | 15.4479 | 15.4725 | 15.4479 | 15.4539 | 238560.0 |
| 2013-04-11 07:55:00 | AAPL | Stock | 15.4579 | 15.4639 | 15.4536 | 15.4564 | 54908.0 |
| 2013-04-11 08:00:00 | AAPL | Stock | 15.4639 | 15.5361 | 15.4482 | 15.4825 | 247632.0 |
| 2013-04-11 08:05:00 | AAPL | Stock | 15.4821 | 15.4918 | 15.4804 | 15.4875 | 112784.0 |
| 2013-04-11 08:10:00 | AAPL | Stock | 15.4889 | 15.5 | 15.4786 | 15.4786 | 242144.0 |
| 2013-04-11 08:15:00 | AAPL | Stock | 15.4854 | 15.4854 | 15.4575 | 15.4704 | 133420.0 |
| 2013-04-11 08:20:00 | AAPL | Stock | 15.4704 | 15.49 | 15.4654 | 15.4893 | 151340.0 |
| 2013-04-11 08:25:00 | AAPL | Stock | 15.4846 | 15.4886 | 15.4689 | 15.4689 | 100800.0 |
| 2013-04-11 08:30:00 | AAPL | Stock | 15.4789 | 15.5064 | 15.4754 | 15.5 | 294840.0 |
| 2013-04-11 08:35:00 | AAPL | Stock | 15.5064 | 15.5189 | 15.5057 | 15.5107 | 182056.0 |
| 2013-04-11 08:40:00 | AAPL | Stock | 15.5107 | 15.5107 | 15.4861 | 15.4861 | 265972.0 |
| 2013-04-11 08:45:00 | AAPL | Stock | 15.5 | 15.5 | 15.4864 | 15.4936 | 297164.0 |
| 2013-04-11 08:50:00 | AAPL | Stock | 15.4929 | 15.4964 | 15.4929 | 15.4929 | 117376.0 |
| 2013-04-11 08:55:00 | AAPL | Stock | 15.4943 | 15.4943 | 15.4643 | 15.4693 | 207312.0 |
| 2013-04-11 09:00:00 | AAPL | Stock | 15.4761 | 15.4786 | 15.45 | 15.45 | 136164.0 |
| 2013-04-11 09:05:00 | AAPL | Stock | 15.4518 | 15.4679 | 15.4482 | 15.4589 | 151872.0 |
| 2013-04-11 09:10:00 | AAPL | Stock | 15.4664 | 15.4911 | 15.4589 | 15.4911 | 182336.0 |
| 2013-04-11 09:15:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.4821 | 15.4857 | 115920.0 |
| 2013-04-11 09:20:00 | AAPL | Stock | 15.49 | 15.4904 | 15.4814 | 15.4879 | 176876.0 |
| 2013-04-11 09:25:00 | AAPL | Stock | 15.4836 | 15.4975 | 15.4732 | 15.4807 | 337036.0 |
| 2013-04-11 09:30:00 | AAPL | Stock | 15.4854 | 15.4964 | 15.4196 | 15.4196 | 14059808.0 |
| 2013-04-11 09:35:00 | AAPL | Stock | 15.4221 | 15.4636 | 15.4 | 15.4314 | 10954608.0 |
| 2013-04-11 09:40:00 | AAPL | Stock | 15.4318 | 15.4425 | 15.4011 | 15.4175 | 7481852.0 |
| 2013-04-11 09:45:00 | AAPL | Stock | 15.4161 | 15.4482 | 15.4086 | 15.4132 | 5516616.0 |
| 2013-04-11 09:50:00 | AAPL | Stock | 15.4139 | 15.4418 | 15.4061 | 15.4321 | 5924100.0 |
| 2013-04-11 09:55:00 | AAPL | Stock | 15.4325 | 15.4761 | 15.4011 | 15.4707 | 9561076.0 |
| 2013-04-11 10:00:00 | AAPL | Stock | 15.4707 | 15.4725 | 15.4357 | 15.4407 | 6128080.0 |
| 2013-04-11 10:05:00 | AAPL | Stock | 15.445 | 15.46 | 15.4379 | 15.4484 | 2408308.0 |
| 2013-04-11 10:10:00 | AAPL | Stock | 15.4504 | 15.4629 | 15.4236 | 15.4405 | 3797556.0 |
| 2013-04-11 10:15:00 | AAPL | Stock | 15.4418 | 15.4418 | 15.4204 | 15.4393 | 3786020.0 |
| 2013-04-11 10:20:00 | AAPL | Stock | 15.4364 | 15.4411 | 15.4154 | 15.4282 | 3270232.0 |
| 2013-04-11 10:25:00 | AAPL | Stock | 15.4236 | 15.4518 | 15.4207 | 15.4371 | 3096548.0 |
| 2013-04-11 10:30:00 | AAPL | Stock | 15.4375 | 15.4614 | 15.43 | 15.4439 | 2754164.0 |
| 2013-04-11 10:35:00 | AAPL | Stock | 15.4464 | 15.5075 | 15.4375 | 15.5071 | 6000484.0 |
> showing 50 of 329,657 rows — these rows as CSV