PREVIEW / stock_5min / 2009-02-06
file: by_date/stock_5min/2009/2009-02-06.parquet size: 4.4 MB rows: 306,085 symbols: 3,318
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-06 04:40:00 | AAPL | Stock | 3.4593 | 3.4593 | 3.4486 | 3.4486 | 19600.0 |
| 2009-02-06 07:20:00 | AAPL | Stock | 3.4707 | 3.4707 | 3.4707 | 3.4707 | 2800.0 |
| 2009-02-06 08:00:00 | AAPL | Stock | 3.4589 | 3.4589 | 3.4504 | 3.4504 | 9716.0 |
| 2009-02-06 08:05:00 | AAPL | Stock | 3.4514 | 3.4514 | 3.4514 | 3.4514 | 2800.0 |
| 2009-02-06 08:10:00 | AAPL | Stock | 3.4514 | 3.4514 | 3.4482 | 3.4482 | 51800.0 |
| 2009-02-06 08:15:00 | AAPL | Stock | 3.4471 | 3.4486 | 3.4436 | 3.4486 | 45780.0 |
| 2009-02-06 08:20:00 | AAPL | Stock | 3.44 | 3.44 | 3.4321 | 3.4393 | 112812.0 |
| 2009-02-06 08:25:00 | AAPL | Stock | 3.4393 | 3.4393 | 3.4393 | 3.4393 | 2800.0 |
| 2009-02-06 08:30:00 | AAPL | Stock | 3.4357 | 3.4643 | 3.4293 | 3.4604 | 282464.0 |
| 2009-02-06 08:35:00 | AAPL | Stock | 3.4625 | 3.4643 | 3.4504 | 3.4529 | 565432.0 |
| 2009-02-06 08:40:00 | AAPL | Stock | 3.4529 | 3.4586 | 3.4529 | 3.4571 | 523600.0 |
| 2009-02-06 08:45:00 | AAPL | Stock | 3.4579 | 3.4582 | 3.4571 | 3.4571 | 13440.0 |
| 2009-02-06 08:50:00 | AAPL | Stock | 3.4568 | 3.4804 | 3.4568 | 3.4764 | 408688.0 |
| 2009-02-06 08:55:00 | AAPL | Stock | 3.4757 | 3.4757 | 3.4679 | 3.47 | 97272.0 |
| 2009-02-06 09:00:00 | AAPL | Stock | 3.4682 | 3.4704 | 3.4636 | 3.4639 | 155960.0 |
| 2009-02-06 09:05:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4489 | 3.4643 | 83944.0 |
| 2009-02-06 09:10:00 | AAPL | Stock | 3.4632 | 3.4675 | 3.4611 | 3.4675 | 152180.0 |
| 2009-02-06 09:15:00 | AAPL | Stock | 3.4668 | 3.4671 | 3.4661 | 3.4664 | 41608.0 |
| 2009-02-06 09:20:00 | AAPL | Stock | 3.4664 | 3.4675 | 3.4643 | 3.4657 | 136388.0 |
| 2009-02-06 09:25:00 | AAPL | Stock | 3.4643 | 3.4675 | 3.4625 | 3.4664 | 168112.0 |
| 2009-02-06 09:30:00 | AAPL | Stock | 3.4682 | 3.4911 | 3.4643 | 3.4868 | 16470524.0 |
| 2009-02-06 09:35:00 | AAPL | Stock | 3.4857 | 3.5111 | 3.4843 | 3.5078 | 21471380.0 |
| 2009-02-06 09:40:00 | AAPL | Stock | 3.5079 | 3.5129 | 3.4854 | 3.4904 | 13526156.0 |
| 2009-02-06 09:45:00 | AAPL | Stock | 3.4904 | 3.5075 | 3.4879 | 3.4921 | 10958248.0 |
| 2009-02-06 09:50:00 | AAPL | Stock | 3.4925 | 3.5007 | 3.4893 | 3.4989 | 7904316.0 |
| 2009-02-06 09:55:00 | AAPL | Stock | 3.4993 | 3.5079 | 3.4986 | 3.5025 | 9518992.0 |
| 2009-02-06 10:00:00 | AAPL | Stock | 3.5025 | 3.5143 | 3.5025 | 3.5057 | 10074288.0 |
| 2009-02-06 10:05:00 | AAPL | Stock | 3.5064 | 3.5082 | 3.4936 | 3.4964 | 10402448.0 |
| 2009-02-06 10:10:00 | AAPL | Stock | 3.4968 | 3.5089 | 3.4968 | 3.5075 | 7303716.0 |
| 2009-02-06 10:15:00 | AAPL | Stock | 3.5071 | 3.5139 | 3.4982 | 3.5004 | 8001336.0 |
| 2009-02-06 10:20:00 | AAPL | Stock | 3.4993 | 3.5007 | 3.4911 | 3.4914 | 7264180.0 |
| 2009-02-06 10:25:00 | AAPL | Stock | 3.4914 | 3.4971 | 3.4893 | 3.4932 | 6807948.0 |
| 2009-02-06 10:30:00 | AAPL | Stock | 3.4932 | 3.5011 | 3.4864 | 3.5005 | 6107892.0 |
| 2009-02-06 10:35:00 | AAPL | Stock | 3.5 | 3.5064 | 3.4986 | 3.5054 | 9151548.0 |
| 2009-02-06 10:40:00 | AAPL | Stock | 3.5054 | 3.5132 | 3.4929 | 3.5121 | 8983772.0 |
| 2009-02-06 10:45:00 | AAPL | Stock | 3.5125 | 3.5268 | 3.5121 | 3.5268 | 11782428.0 |
| 2009-02-06 10:50:00 | AAPL | Stock | 3.5268 | 3.5357 | 3.5261 | 3.5321 | 17706612.0 |
| 2009-02-06 10:55:00 | AAPL | Stock | 3.5325 | 3.5354 | 3.5239 | 3.5282 | 8545348.0 |
| 2009-02-06 11:00:00 | AAPL | Stock | 3.5283 | 3.5317 | 3.5254 | 3.5279 | 6606628.0 |
| 2009-02-06 11:05:00 | AAPL | Stock | 3.5279 | 3.5389 | 3.5257 | 3.5379 | 13512548.0 |
| 2009-02-06 11:10:00 | AAPL | Stock | 3.5382 | 3.5471 | 3.5364 | 3.545 | 12653060.0 |
| 2009-02-06 11:15:00 | AAPL | Stock | 3.545 | 3.55 | 3.5386 | 3.5443 | 10726800.0 |
| 2009-02-06 11:20:00 | AAPL | Stock | 3.5436 | 3.5443 | 3.5329 | 3.5357 | 7997304.0 |
| 2009-02-06 11:25:00 | AAPL | Stock | 3.5354 | 3.5368 | 3.5307 | 3.535 | 4864552.0 |
| 2009-02-06 11:30:00 | AAPL | Stock | 3.5361 | 3.5361 | 3.5286 | 3.5293 | 4280360.0 |
| 2009-02-06 11:35:00 | AAPL | Stock | 3.5293 | 3.5329 | 3.5271 | 3.5275 | 4583684.0 |
| 2009-02-06 11:40:00 | AAPL | Stock | 3.5271 | 3.5436 | 3.5268 | 3.5432 | 7769636.0 |
| 2009-02-06 11:45:00 | AAPL | Stock | 3.5436 | 3.5464 | 3.54 | 3.5404 | 6139588.0 |
| 2009-02-06 11:50:00 | AAPL | Stock | 3.54 | 3.5411 | 3.5332 | 3.5386 | 3513048.0 |
| 2009-02-06 11:55:00 | AAPL | Stock | 3.5386 | 3.5446 | 3.5371 | 3.5379 | 4553920.0 |
> showing 50 of 306,085 rows — these rows as CSV