PREVIEW / stock_5min / 2008-09-10
file: by_date/stock_5min/2008/2008-09-10.parquet size: 4.5 MB rows: 319,491 symbols: 3,314
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-09-10 04:15:00 | AAPL | Stock | 5.4357 | 5.4357 | 5.4357 | 5.4357 | 3444.0 |
| 2008-09-10 04:30:00 | AAPL | Stock | 5.4943 | 5.4943 | 5.4943 | 5.4943 | 2800.0 |
| 2008-09-10 05:20:00 | AAPL | Stock | 5.4736 | 5.4736 | 5.4732 | 5.4732 | 8400.0 |
| 2008-09-10 07:05:00 | AAPL | Stock | 5.4554 | 5.4554 | 5.4554 | 5.4554 | 8400.0 |
| 2008-09-10 07:15:00 | AAPL | Stock | 5.4611 | 5.4925 | 5.4539 | 5.4739 | 84000.0 |
| 2008-09-10 07:25:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4604 | 5.4604 | 64400.0 |
| 2008-09-10 07:30:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4643 | 5.4643 | 117600.0 |
| 2008-09-10 07:35:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4607 | 5.4643 | 33600.0 |
| 2008-09-10 07:40:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4464 | 5.4464 | 80640.0 |
| 2008-09-10 07:45:00 | AAPL | Stock | 5.4464 | 5.4571 | 5.4464 | 5.4571 | 98000.0 |
| 2008-09-10 07:50:00 | AAPL | Stock | 5.4571 | 5.4643 | 5.4489 | 5.45 | 86408.0 |
| 2008-09-10 07:55:00 | AAPL | Stock | 5.45 | 5.45 | 5.4429 | 5.4475 | 63840.0 |
| 2008-09-10 08:00:00 | AAPL | Stock | 5.4529 | 5.4529 | 5.4214 | 5.4221 | 255976.0 |
| 2008-09-10 08:05:00 | AAPL | Stock | 5.4275 | 5.4329 | 5.4275 | 5.4286 | 150640.0 |
| 2008-09-10 08:10:00 | AAPL | Stock | 5.425 | 5.425 | 5.4214 | 5.4214 | 100240.0 |
| 2008-09-10 08:15:00 | AAPL | Stock | 5.42 | 5.42 | 5.4054 | 5.4054 | 93800.0 |
| 2008-09-10 08:20:00 | AAPL | Stock | 5.4061 | 5.4286 | 5.4061 | 5.4286 | 140000.0 |
| 2008-09-10 08:25:00 | AAPL | Stock | 5.4286 | 5.4425 | 5.4286 | 5.4357 | 389900.0 |
| 2008-09-10 08:30:00 | AAPL | Stock | 5.4354 | 5.4464 | 5.4286 | 5.4464 | 309680.0 |
| 2008-09-10 08:35:00 | AAPL | Stock | 5.4411 | 5.4464 | 5.4389 | 5.4443 | 211372.0 |
| 2008-09-10 08:40:00 | AAPL | Stock | 5.4489 | 5.4543 | 5.4414 | 5.4414 | 128800.0 |
| 2008-09-10 08:45:00 | AAPL | Stock | 5.4468 | 5.4468 | 5.4411 | 5.4443 | 123116.0 |
| 2008-09-10 08:50:00 | AAPL | Stock | 5.4429 | 5.4429 | 5.4375 | 5.4393 | 383824.0 |
| 2008-09-10 08:55:00 | AAPL | Stock | 5.4393 | 5.4496 | 5.4389 | 5.4496 | 162428.0 |
| 2008-09-10 09:00:00 | AAPL | Stock | 5.4532 | 5.4539 | 5.4464 | 5.4529 | 37100.0 |
| 2008-09-10 09:05:00 | AAPL | Stock | 5.4489 | 5.4489 | 5.4375 | 5.44 | 80976.0 |
| 2008-09-10 09:10:00 | AAPL | Stock | 5.4429 | 5.4464 | 5.4429 | 5.4436 | 18200.0 |
| 2008-09-10 09:15:00 | AAPL | Stock | 5.4461 | 5.4475 | 5.4396 | 5.4396 | 40908.0 |
| 2008-09-10 09:20:00 | AAPL | Stock | 5.4439 | 5.4446 | 5.4407 | 5.4407 | 12600.0 |
| 2008-09-10 09:25:00 | AAPL | Stock | 5.4407 | 5.4464 | 5.4339 | 5.4457 | 341600.0 |
| 2008-09-10 09:30:00 | AAPL | Stock | 5.4457 | 5.4457 | 5.3692 | 5.3875 | 25020604.0 |
| 2008-09-10 09:35:00 | AAPL | Stock | 5.3896 | 5.3993 | 5.3261 | 5.3454 | 25730068.0 |
| 2008-09-10 09:40:00 | AAPL | Stock | 5.3443 | 5.3761 | 5.3143 | 5.3643 | 26916400.0 |
| 2008-09-10 09:45:00 | AAPL | Stock | 5.3639 | 5.3768 | 5.3275 | 5.3729 | 16993620.0 |
| 2008-09-10 09:50:00 | AAPL | Stock | 5.3732 | 5.4071 | 5.3621 | 5.3822 | 21548604.0 |
| 2008-09-10 09:55:00 | AAPL | Stock | 5.3825 | 5.3825 | 5.35 | 5.3686 | 16596104.0 |
| 2008-09-10 10:00:00 | AAPL | Stock | 5.3686 | 5.4325 | 5.3561 | 5.4325 | 24747660.0 |
| 2008-09-10 10:05:00 | AAPL | Stock | 5.4302 | 5.4596 | 5.4136 | 5.4532 | 23239384.0 |
| 2008-09-10 10:10:00 | AAPL | Stock | 5.4532 | 5.4543 | 5.4118 | 5.4189 | 18430160.0 |
| 2008-09-10 10:15:00 | AAPL | Stock | 5.4189 | 5.4271 | 5.4004 | 5.4236 | 12006008.0 |
| 2008-09-10 10:20:00 | AAPL | Stock | 5.4232 | 5.4286 | 5.3968 | 5.4039 | 11146268.0 |
| 2008-09-10 10:25:00 | AAPL | Stock | 5.4046 | 5.4368 | 5.3929 | 5.4279 | 10625328.0 |
| 2008-09-10 10:30:00 | AAPL | Stock | 5.4279 | 5.4286 | 5.4118 | 5.4154 | 8364160.0 |
| 2008-09-10 10:35:00 | AAPL | Stock | 5.4154 | 5.4386 | 5.4089 | 5.4293 | 12604144.0 |
| 2008-09-10 10:40:00 | AAPL | Stock | 5.4286 | 5.4296 | 5.4071 | 5.4191 | 8090712.0 |
| 2008-09-10 10:45:00 | AAPL | Stock | 5.4196 | 5.4248 | 5.3843 | 5.3946 | 12297236.0 |
| 2008-09-10 10:50:00 | AAPL | Stock | 5.3943 | 5.4104 | 5.3696 | 5.37 | 10322592.0 |
| 2008-09-10 10:55:00 | AAPL | Stock | 5.37 | 5.3911 | 5.3625 | 5.3836 | 10149692.0 |
| 2008-09-10 11:00:00 | AAPL | Stock | 5.3839 | 5.3929 | 5.3671 | 5.3836 | 8959692.0 |
| 2008-09-10 11:05:00 | AAPL | Stock | 5.3846 | 5.3929 | 5.3679 | 5.3896 | 8939140.0 |
> showing 50 of 319,491 rows — these rows as CSV