PREVIEW / stock_5min / 2013-10-10
file: by_date/stock_5min/2013/2013-10-10.parquet size: 5.3 MB rows: 347,884 symbols: 3,537
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-10-10 04:05:00 | AAPL | Stock | 17.4707 | 17.4707 | 17.4707 | 17.4707 | 3416.0 |
| 2013-10-10 04:10:00 | AAPL | Stock | 17.5064 | 17.5064 | 17.5064 | 17.5064 | 2800.0 |
| 2013-10-10 04:55:00 | AAPL | Stock | 17.5004 | 17.5011 | 17.5004 | 17.5011 | 17500.0 |
| 2013-10-10 05:00:00 | AAPL | Stock | 17.5068 | 17.5068 | 17.5 | 17.5 | 10360.0 |
| 2013-10-10 05:10:00 | AAPL | Stock | 17.4864 | 17.4864 | 17.4857 | 17.4857 | 31080.0 |
| 2013-10-10 05:25:00 | AAPL | Stock | 17.4996 | 17.5 | 17.4996 | 17.4996 | 30800.0 |
| 2013-10-10 05:30:00 | AAPL | Stock | 17.4857 | 17.4857 | 17.4857 | 17.4857 | 25480.0 |
| 2013-10-10 05:35:00 | AAPL | Stock | 17.4732 | 17.4732 | 17.4732 | 17.4732 | 3080.0 |
| 2013-10-10 05:40:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 28000.0 |
| 2013-10-10 05:45:00 | AAPL | Stock | 17.4946 | 17.4946 | 17.4946 | 17.4946 | 2800.0 |
| 2013-10-10 06:00:00 | AAPL | Stock | 17.4821 | 17.4821 | 17.4821 | 17.4821 | 2800.0 |
| 2013-10-10 06:05:00 | AAPL | Stock | 17.5 | 17.5 | 17.4821 | 17.4821 | 33460.0 |
| 2013-10-10 06:15:00 | AAPL | Stock | 17.4993 | 17.4993 | 17.4993 | 17.4993 | 2828.0 |
| 2013-10-10 06:25:00 | AAPL | Stock | 17.5 | 17.5 | 17.4993 | 17.5 | 25200.0 |
| 2013-10-10 06:30:00 | AAPL | Stock | 17.5 | 17.5 | 17.4996 | 17.5 | 90692.0 |
| 2013-10-10 06:40:00 | AAPL | Stock | 17.5 | 17.5179 | 17.5 | 17.5179 | 41412.0 |
| 2013-10-10 06:50:00 | AAPL | Stock | 17.5089 | 17.5089 | 17.5004 | 17.5004 | 11900.0 |
| 2013-10-10 06:55:00 | AAPL | Stock | 17.5143 | 17.5146 | 17.5143 | 17.5146 | 8400.0 |
| 2013-10-10 07:00:00 | AAPL | Stock | 17.5104 | 17.5179 | 17.5039 | 17.5132 | 113260.0 |
| 2013-10-10 07:05:00 | AAPL | Stock | 17.5132 | 17.5268 | 17.5118 | 17.5214 | 152348.0 |
| 2013-10-10 07:10:00 | AAPL | Stock | 17.5257 | 17.5257 | 17.5114 | 17.5243 | 52696.0 |
| 2013-10-10 07:15:00 | AAPL | Stock | 17.5239 | 17.5357 | 17.5196 | 17.5357 | 212240.0 |
| 2013-10-10 07:20:00 | AAPL | Stock | 17.5361 | 17.5361 | 17.5318 | 17.5357 | 58100.0 |
| 2013-10-10 07:25:00 | AAPL | Stock | 17.5354 | 17.5511 | 17.5314 | 17.55 | 205660.0 |
| 2013-10-10 07:30:00 | AAPL | Stock | 17.5489 | 17.5529 | 17.5421 | 17.5454 | 80136.0 |
| 2013-10-10 07:35:00 | AAPL | Stock | 17.5457 | 17.5532 | 17.5429 | 17.5532 | 38976.0 |
| 2013-10-10 07:40:00 | AAPL | Stock | 17.5529 | 17.5625 | 17.5457 | 17.5625 | 372820.0 |
| 2013-10-10 07:45:00 | AAPL | Stock | 17.5539 | 17.5643 | 17.5536 | 17.5536 | 153104.0 |
| 2013-10-10 07:50:00 | AAPL | Stock | 17.5471 | 17.5607 | 17.5471 | 17.5579 | 37380.0 |
| 2013-10-10 07:55:00 | AAPL | Stock | 17.5532 | 17.5579 | 17.5464 | 17.5557 | 331632.0 |
| 2013-10-10 08:00:00 | AAPL | Stock | 17.5529 | 17.5668 | 17.3571 | 17.5529 | 670684.0 |
| 2013-10-10 08:05:00 | AAPL | Stock | 17.56 | 17.5643 | 17.5557 | 17.5586 | 637588.0 |
| 2013-10-10 08:10:00 | AAPL | Stock | 17.5607 | 17.5632 | 17.5543 | 17.5543 | 120960.0 |
| 2013-10-10 08:15:00 | AAPL | Stock | 17.5589 | 17.5607 | 17.5529 | 17.555 | 757232.0 |
| 2013-10-10 08:20:00 | AAPL | Stock | 17.555 | 17.555 | 17.5396 | 17.5436 | 452032.0 |
| 2013-10-10 08:25:00 | AAPL | Stock | 17.5411 | 17.5446 | 17.5396 | 17.5446 | 229264.0 |
| 2013-10-10 08:30:00 | AAPL | Stock | 17.5421 | 17.5564 | 17.5268 | 17.5268 | 591668.0 |
| 2013-10-10 08:35:00 | AAPL | Stock | 17.5268 | 17.5479 | 17.5257 | 17.5479 | 186984.0 |
| 2013-10-10 08:40:00 | AAPL | Stock | 17.5357 | 17.5536 | 17.5357 | 17.5361 | 86884.0 |
| 2013-10-10 08:45:00 | AAPL | Stock | 17.5429 | 17.5439 | 17.5396 | 17.5425 | 29932.0 |
| 2013-10-10 08:50:00 | AAPL | Stock | 17.5432 | 17.5432 | 17.5329 | 17.5329 | 53200.0 |
| 2013-10-10 08:55:00 | AAPL | Stock | 17.5354 | 17.5411 | 17.5354 | 17.5393 | 94360.0 |
| 2013-10-10 09:00:00 | AAPL | Stock | 17.5379 | 17.5661 | 17.5371 | 17.5625 | 276220.0 |
| 2013-10-10 09:05:00 | AAPL | Stock | 17.5625 | 17.5643 | 17.5575 | 17.5643 | 290724.0 |
| 2013-10-10 09:10:00 | AAPL | Stock | 17.5671 | 17.5671 | 17.5593 | 17.5661 | 248052.0 |
| 2013-10-10 09:15:00 | AAPL | Stock | 17.5629 | 17.5661 | 17.5629 | 17.5646 | 72240.0 |
| 2013-10-10 09:20:00 | AAPL | Stock | 17.5657 | 17.5804 | 17.5629 | 17.5679 | 775768.0 |
| 2013-10-10 09:25:00 | AAPL | Stock | 17.5679 | 17.5696 | 17.5311 | 17.5482 | 944888.0 |
| 2013-10-10 09:30:00 | AAPL | Stock | 17.5454 | 17.5568 | 17.4557 | 17.4721 | 20328420.0 |
| 2013-10-10 09:35:00 | AAPL | Stock | 17.4714 | 17.4914 | 17.4379 | 17.4429 | 7943236.0 |
> showing 50 of 347,884 rows — these rows as CSV