PREVIEW / stock_5min / 2008-10-27
file: by_date/stock_5min/2008/2008-10-27.parquet size: 4.3 MB rows: 309,847 symbols: 3,336
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-27 07:10:00 | AAPL | Stock | 3.3536 | 3.3571 | 3.3536 | 3.3571 | 42000.0 |
| 2008-10-27 07:15:00 | AAPL | Stock | 3.3596 | 3.3596 | 3.3596 | 3.3596 | 12320.0 |
| 2008-10-27 07:20:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.34 | 3.34 | 16800.0 |
| 2008-10-27 07:35:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 12180.0 |
| 2008-10-27 07:40:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3554 | 3.3554 | 25200.0 |
| 2008-10-27 07:45:00 | AAPL | Stock | 3.3629 | 3.3629 | 3.3629 | 3.3629 | 22400.0 |
| 2008-10-27 07:55:00 | AAPL | Stock | 3.3629 | 3.3679 | 3.3571 | 3.3679 | 126000.0 |
| 2008-10-27 08:00:00 | AAPL | Stock | 3.3711 | 3.3732 | 3.3571 | 3.3571 | 168028.0 |
| 2008-10-27 08:05:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3429 | 3.3429 | 367640.0 |
| 2008-10-27 08:10:00 | AAPL | Stock | 3.3429 | 3.3743 | 3.3425 | 3.3743 | 298872.0 |
| 2008-10-27 08:15:00 | AAPL | Stock | 3.3786 | 3.3829 | 3.3743 | 3.3743 | 207172.0 |
| 2008-10-27 08:20:00 | AAPL | Stock | 3.3714 | 3.3754 | 3.3571 | 3.365 | 140700.0 |
| 2008-10-27 08:25:00 | AAPL | Stock | 3.3596 | 3.3625 | 3.3543 | 3.3625 | 441084.0 |
| 2008-10-27 08:30:00 | AAPL | Stock | 3.3643 | 3.3743 | 3.3618 | 3.3693 | 183680.0 |
| 2008-10-27 08:35:00 | AAPL | Stock | 3.3689 | 3.3689 | 3.3571 | 3.3654 | 250768.0 |
| 2008-10-27 08:40:00 | AAPL | Stock | 3.3668 | 3.3804 | 3.3664 | 3.3786 | 198184.0 |
| 2008-10-27 08:45:00 | AAPL | Stock | 3.3796 | 3.3925 | 3.3732 | 3.3925 | 320124.0 |
| 2008-10-27 08:50:00 | AAPL | Stock | 3.3921 | 3.4068 | 3.3796 | 3.3939 | 356216.0 |
| 2008-10-27 08:55:00 | AAPL | Stock | 3.3939 | 3.4236 | 3.3939 | 3.4221 | 315112.0 |
| 2008-10-27 09:00:00 | AAPL | Stock | 3.4204 | 3.4375 | 3.4204 | 3.4282 | 494536.0 |
| 2008-10-27 09:05:00 | AAPL | Stock | 3.4279 | 3.4321 | 3.4139 | 3.4175 | 359632.0 |
| 2008-10-27 09:10:00 | AAPL | Stock | 3.4193 | 3.4286 | 3.4182 | 3.4254 | 303800.0 |
| 2008-10-27 09:15:00 | AAPL | Stock | 3.4254 | 3.4254 | 3.4204 | 3.4204 | 84000.0 |
| 2008-10-27 09:20:00 | AAPL | Stock | 3.4182 | 3.4311 | 3.4161 | 3.4271 | 609280.0 |
| 2008-10-27 09:25:00 | AAPL | Stock | 3.4286 | 3.4293 | 3.3968 | 3.4 | 1240484.0 |
| 2008-10-27 09:30:00 | AAPL | Stock | 3.4 | 3.4643 | 3.3929 | 3.4589 | 28446544.0 |
| 2008-10-27 09:35:00 | AAPL | Stock | 3.4586 | 3.4675 | 3.4189 | 3.4618 | 25998028.0 |
| 2008-10-27 09:40:00 | AAPL | Stock | 3.4571 | 3.4746 | 3.4386 | 3.4729 | 31937472.0 |
| 2008-10-27 09:45:00 | AAPL | Stock | 3.4725 | 3.4761 | 3.4293 | 3.4321 | 24389876.0 |
| 2008-10-27 09:50:00 | AAPL | Stock | 3.4329 | 3.4464 | 3.4179 | 3.4439 | 22130220.0 |
| 2008-10-27 09:55:00 | AAPL | Stock | 3.4432 | 3.4532 | 3.4275 | 3.4496 | 23610832.0 |
| 2008-10-27 10:00:00 | AAPL | Stock | 3.4489 | 3.4868 | 3.445 | 3.4736 | 32202408.0 |
| 2008-10-27 10:05:00 | AAPL | Stock | 3.4746 | 3.4821 | 3.44 | 3.4493 | 20733524.0 |
| 2008-10-27 10:10:00 | AAPL | Stock | 3.4468 | 3.4571 | 3.4275 | 3.4293 | 16856224.0 |
| 2008-10-27 10:15:00 | AAPL | Stock | 3.4289 | 3.4429 | 3.4046 | 3.4064 | 18435564.0 |
| 2008-10-27 10:20:00 | AAPL | Stock | 3.4054 | 3.435 | 3.4046 | 3.4196 | 18177992.0 |
| 2008-10-27 10:25:00 | AAPL | Stock | 3.4196 | 3.4375 | 3.41 | 3.4107 | 17633084.0 |
| 2008-10-27 10:30:00 | AAPL | Stock | 3.4111 | 3.4211 | 3.3886 | 3.3971 | 19978196.0 |
| 2008-10-27 10:35:00 | AAPL | Stock | 3.3971 | 3.4054 | 3.3771 | 3.3925 | 18876480.0 |
| 2008-10-27 10:40:00 | AAPL | Stock | 3.3929 | 3.4014 | 3.3661 | 3.3807 | 17221148.0 |
| 2008-10-27 10:45:00 | AAPL | Stock | 3.38 | 3.4 | 3.3749 | 3.3921 | 13505044.0 |
| 2008-10-27 10:50:00 | AAPL | Stock | 3.3911 | 3.4089 | 3.3839 | 3.3857 | 15107204.0 |
| 2008-10-27 10:55:00 | AAPL | Stock | 3.3846 | 3.415 | 3.3839 | 3.4107 | 11867184.0 |
| 2008-10-27 11:00:00 | AAPL | Stock | 3.4107 | 3.415 | 3.3911 | 3.3946 | 11177432.0 |
| 2008-10-27 11:05:00 | AAPL | Stock | 3.3943 | 3.4286 | 3.3864 | 3.4193 | 13862408.0 |
| 2008-10-27 11:10:00 | AAPL | Stock | 3.4196 | 3.4357 | 3.4086 | 3.4357 | 14724304.0 |
| 2008-10-27 11:15:00 | AAPL | Stock | 3.4357 | 3.4382 | 3.4114 | 3.4139 | 14447692.0 |
| 2008-10-27 11:20:00 | AAPL | Stock | 3.415 | 3.4264 | 3.3996 | 3.4086 | 10627064.0 |
| 2008-10-27 11:25:00 | AAPL | Stock | 3.4082 | 3.415 | 3.3929 | 3.4139 | 9674448.0 |
| 2008-10-27 11:30:00 | AAPL | Stock | 3.4136 | 3.4175 | 3.375 | 3.3843 | 15482068.0 |
> showing 50 of 309,847 rows — these rows as CSV