PREVIEW / stock_5min / 2012-11-14
file: by_date/stock_5min/2012/2012-11-14.parquet size: 5.0 MB rows: 335,489 symbols: 3,478
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-14 04:00:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 2800.0 |
| 2012-11-14 04:15:00 | AAPL | Stock | 19.55 | 19.55 | 19.55 | 19.55 | 7560.0 |
| 2012-11-14 05:05:00 | AAPL | Stock | 19.5696 | 19.5696 | 19.5696 | 19.5696 | 4200.0 |
| 2012-11-14 05:15:00 | AAPL | Stock | 19.5536 | 19.5536 | 19.5536 | 19.5536 | 8400.0 |
| 2012-11-14 05:20:00 | AAPL | Stock | 19.5411 | 19.5411 | 19.5411 | 19.5411 | 2800.0 |
| 2012-11-14 05:30:00 | AAPL | Stock | 19.5268 | 19.5268 | 19.5268 | 19.5268 | 5600.0 |
| 2012-11-14 05:35:00 | AAPL | Stock | 19.5089 | 19.5089 | 19.5089 | 19.5089 | 5600.0 |
| 2012-11-14 05:40:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5114 | 19.5114 | 23800.0 |
| 2012-11-14 05:55:00 | AAPL | Stock | 19.5143 | 19.5143 | 19.5 | 19.5 | 58520.0 |
| 2012-11-14 06:00:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 2800.0 |
| 2012-11-14 06:15:00 | AAPL | Stock | 19.5004 | 19.5004 | 19.5004 | 19.5004 | 2800.0 |
| 2012-11-14 07:00:00 | AAPL | Stock | 19.4946 | 19.4946 | 19.4946 | 19.4946 | 2800.0 |
| 2012-11-14 07:10:00 | AAPL | Stock | 19.4732 | 19.4889 | 19.4696 | 19.4889 | 25200.0 |
| 2012-11-14 07:15:00 | AAPL | Stock | 19.4911 | 19.4954 | 19.4875 | 19.4875 | 47600.0 |
| 2012-11-14 07:20:00 | AAPL | Stock | 19.4725 | 19.4725 | 19.4643 | 19.4643 | 18340.0 |
| 2012-11-14 07:25:00 | AAPL | Stock | 19.4632 | 19.4732 | 19.4554 | 19.4554 | 79660.0 |
| 2012-11-14 07:30:00 | AAPL | Stock | 19.4539 | 19.4643 | 19.4332 | 19.4332 | 55160.0 |
| 2012-11-14 07:35:00 | AAPL | Stock | 19.4496 | 19.4625 | 19.4464 | 19.4625 | 16800.0 |
| 2012-11-14 07:40:00 | AAPL | Stock | 19.4568 | 19.4568 | 19.4461 | 19.4464 | 36400.0 |
| 2012-11-14 07:45:00 | AAPL | Stock | 19.445 | 19.4532 | 19.4429 | 19.4464 | 56336.0 |
| 2012-11-14 07:50:00 | AAPL | Stock | 19.4518 | 19.4518 | 19.4375 | 19.4375 | 47600.0 |
| 2012-11-14 07:55:00 | AAPL | Stock | 19.4379 | 19.4379 | 19.4379 | 19.4379 | 2800.0 |
| 2012-11-14 08:00:00 | AAPL | Stock | 19.4514 | 19.4643 | 19.4357 | 19.4457 | 170100.0 |
| 2012-11-14 08:05:00 | AAPL | Stock | 19.4411 | 19.4514 | 19.44 | 19.4496 | 72408.0 |
| 2012-11-14 08:10:00 | AAPL | Stock | 19.4493 | 19.4514 | 19.4464 | 19.4464 | 37800.0 |
| 2012-11-14 08:15:00 | AAPL | Stock | 19.4464 | 19.4571 | 19.4393 | 19.4571 | 131544.0 |
| 2012-11-14 08:20:00 | AAPL | Stock | 19.4643 | 19.4875 | 19.4493 | 19.48 | 134176.0 |
| 2012-11-14 08:25:00 | AAPL | Stock | 19.4725 | 19.4786 | 19.4643 | 19.465 | 62636.0 |
| 2012-11-14 08:30:00 | AAPL | Stock | 19.4689 | 19.4771 | 19.4571 | 19.4571 | 242704.0 |
| 2012-11-14 08:35:00 | AAPL | Stock | 19.4575 | 19.4732 | 19.4571 | 19.4607 | 109760.0 |
| 2012-11-14 08:40:00 | AAPL | Stock | 19.4639 | 19.4661 | 19.4568 | 19.4568 | 257376.0 |
| 2012-11-14 08:45:00 | AAPL | Stock | 19.4536 | 19.4739 | 19.4514 | 19.4739 | 91000.0 |
| 2012-11-14 08:50:00 | AAPL | Stock | 19.4736 | 19.49 | 19.4736 | 19.485 | 72324.0 |
| 2012-11-14 08:55:00 | AAPL | Stock | 19.4857 | 19.4875 | 19.4821 | 19.4857 | 77560.0 |
| 2012-11-14 09:00:00 | AAPL | Stock | 19.4871 | 19.4871 | 19.4721 | 19.4721 | 68908.0 |
| 2012-11-14 09:05:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4714 | 19.4814 | 91616.0 |
| 2012-11-14 09:10:00 | AAPL | Stock | 19.4821 | 19.4961 | 19.475 | 19.4761 | 322280.0 |
| 2012-11-14 09:15:00 | AAPL | Stock | 19.4825 | 19.4875 | 19.4736 | 19.4821 | 140644.0 |
| 2012-11-14 09:20:00 | AAPL | Stock | 19.4821 | 19.4857 | 19.4668 | 19.4821 | 306908.0 |
| 2012-11-14 09:25:00 | AAPL | Stock | 19.4821 | 19.4914 | 19.4643 | 19.4643 | 190260.0 |
| 2012-11-14 09:30:00 | AAPL | Stock | 19.4796 | 19.4943 | 19.4036 | 19.4342 | 17047800.0 |
| 2012-11-14 09:35:00 | AAPL | Stock | 19.4332 | 19.5518 | 19.4289 | 19.5248 | 13590388.0 |
| 2012-11-14 09:40:00 | AAPL | Stock | 19.5214 | 19.5218 | 19.4307 | 19.4543 | 8274168.0 |
| 2012-11-14 09:45:00 | AAPL | Stock | 19.4611 | 19.5407 | 19.454 | 19.5146 | 6513752.0 |
| 2012-11-14 09:50:00 | AAPL | Stock | 19.5154 | 19.5182 | 19.3979 | 19.425 | 7708484.0 |
| 2012-11-14 09:55:00 | AAPL | Stock | 19.42 | 19.4368 | 19.3757 | 19.4204 | 8458576.0 |
| 2012-11-14 10:00:00 | AAPL | Stock | 19.415 | 19.4632 | 19.3804 | 19.4361 | 5153260.0 |
| 2012-11-14 10:05:00 | AAPL | Stock | 19.4418 | 19.4729 | 19.3964 | 19.4418 | 6563928.0 |
| 2012-11-14 10:10:00 | AAPL | Stock | 19.4407 | 19.4618 | 19.3757 | 19.4079 | 7671608.0 |
| 2012-11-14 10:15:00 | AAPL | Stock | 19.4079 | 19.435 | 19.3482 | 19.4025 | 7162568.0 |
> showing 50 of 335,489 rows — these rows as CSV