PREVIEW / stock_5min / 2008-10-21
file: by_date/stock_5min/2008/2008-10-21.parquet size: 4.4 MB rows: 317,574 symbols: 3,339
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-21 04:40:00 | AAPL | Stock | 3.4675 | 3.4675 | 3.4675 | 3.4675 | 5600.0 |
| 2008-10-21 05:45:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 2800.0 |
| 2008-10-21 06:00:00 | AAPL | Stock | 3.4846 | 3.4846 | 3.4846 | 3.4846 | 22400.0 |
| 2008-10-21 06:05:00 | AAPL | Stock | 3.5118 | 3.5118 | 3.5118 | 3.5118 | 4200.0 |
| 2008-10-21 07:00:00 | AAPL | Stock | 3.5 | 3.5107 | 3.4996 | 3.4996 | 65800.0 |
| 2008-10-21 07:10:00 | AAPL | Stock | 3.4846 | 3.4846 | 3.4643 | 3.4643 | 24836.0 |
| 2008-10-21 07:15:00 | AAPL | Stock | 3.4575 | 3.4643 | 3.4571 | 3.4643 | 14000.0 |
| 2008-10-21 07:25:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4804 | 3.4804 | 2800.0 |
| 2008-10-21 07:30:00 | AAPL | Stock | 3.4814 | 3.4814 | 3.4814 | 3.4814 | 25200.0 |
| 2008-10-21 07:40:00 | AAPL | Stock | 3.475 | 3.475 | 3.4643 | 3.4643 | 168000.0 |
| 2008-10-21 07:45:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 16100.0 |
| 2008-10-21 07:50:00 | AAPL | Stock | 3.4732 | 3.4793 | 3.465 | 3.4786 | 187600.0 |
| 2008-10-21 07:55:00 | AAPL | Stock | 3.4786 | 3.4796 | 3.4661 | 3.4786 | 70000.0 |
| 2008-10-21 08:00:00 | AAPL | Stock | 3.4786 | 3.5204 | 3.4786 | 3.5089 | 763868.0 |
| 2008-10-21 08:05:00 | AAPL | Stock | 3.5136 | 3.5136 | 3.49 | 3.49 | 513268.0 |
| 2008-10-21 08:10:00 | AAPL | Stock | 3.4982 | 3.4982 | 3.4739 | 3.4786 | 178584.0 |
| 2008-10-21 08:15:00 | AAPL | Stock | 3.4814 | 3.4821 | 3.4686 | 3.4821 | 434980.0 |
| 2008-10-21 08:20:00 | AAPL | Stock | 3.4825 | 3.4886 | 3.4782 | 3.4886 | 315196.0 |
| 2008-10-21 08:25:00 | AAPL | Stock | 3.4825 | 3.4882 | 3.4821 | 3.4836 | 220528.0 |
| 2008-10-21 08:30:00 | AAPL | Stock | 3.4836 | 3.4836 | 3.4821 | 3.4821 | 100380.0 |
| 2008-10-21 08:35:00 | AAPL | Stock | 3.4793 | 3.4875 | 3.4754 | 3.4839 | 273588.0 |
| 2008-10-21 08:40:00 | AAPL | Stock | 3.4821 | 3.4993 | 3.4821 | 3.4893 | 263592.0 |
| 2008-10-21 08:45:00 | AAPL | Stock | 3.4889 | 3.4893 | 3.4571 | 3.4636 | 1409296.0 |
| 2008-10-21 08:50:00 | AAPL | Stock | 3.4618 | 3.4643 | 3.4386 | 3.4446 | 958440.0 |
| 2008-10-21 08:55:00 | AAPL | Stock | 3.4439 | 3.4625 | 3.4429 | 3.4557 | 473088.0 |
| 2008-10-21 09:00:00 | AAPL | Stock | 3.4593 | 3.4786 | 3.45 | 3.4536 | 890260.0 |
| 2008-10-21 09:05:00 | AAPL | Stock | 3.4536 | 3.4536 | 3.4414 | 3.4414 | 376264.0 |
| 2008-10-21 09:10:00 | AAPL | Stock | 3.4454 | 3.4461 | 3.4414 | 3.4443 | 151732.0 |
| 2008-10-21 09:15:00 | AAPL | Stock | 3.4439 | 3.4461 | 3.4407 | 3.4439 | 151200.0 |
| 2008-10-21 09:20:00 | AAPL | Stock | 3.4446 | 3.4496 | 3.4429 | 3.4482 | 165284.0 |
| 2008-10-21 09:25:00 | AAPL | Stock | 3.4482 | 3.4754 | 3.4468 | 3.4618 | 1088808.0 |
| 2008-10-21 09:30:00 | AAPL | Stock | 3.4593 | 3.4636 | 3.4182 | 3.4311 | 32373488.0 |
| 2008-10-21 09:35:00 | AAPL | Stock | 3.4311 | 3.4454 | 3.4143 | 3.4296 | 35074788.0 |
| 2008-10-21 09:40:00 | AAPL | Stock | 3.4296 | 3.4471 | 3.4107 | 3.4407 | 31847788.0 |
| 2008-10-21 09:45:00 | AAPL | Stock | 3.4407 | 3.4471 | 3.4214 | 3.4293 | 26077296.0 |
| 2008-10-21 09:50:00 | AAPL | Stock | 3.43 | 3.4604 | 3.4218 | 3.4561 | 24652880.0 |
| 2008-10-21 09:55:00 | AAPL | Stock | 3.4554 | 3.4643 | 3.4421 | 3.4607 | 26735268.0 |
| 2008-10-21 10:00:00 | AAPL | Stock | 3.4604 | 3.4696 | 3.4464 | 3.4561 | 24800804.0 |
| 2008-10-21 10:05:00 | AAPL | Stock | 3.4561 | 3.4821 | 3.4532 | 3.4804 | 23994740.0 |
| 2008-10-21 10:10:00 | AAPL | Stock | 3.4804 | 3.4964 | 3.4696 | 3.4725 | 30146564.0 |
| 2008-10-21 10:15:00 | AAPL | Stock | 3.4729 | 3.4875 | 3.4593 | 3.4704 | 21629664.0 |
| 2008-10-21 10:20:00 | AAPL | Stock | 3.4707 | 3.4729 | 3.4518 | 3.4614 | 18386396.0 |
| 2008-10-21 10:25:00 | AAPL | Stock | 3.4614 | 3.4618 | 3.4375 | 3.4379 | 18329808.0 |
| 2008-10-21 10:30:00 | AAPL | Stock | 3.4393 | 3.4432 | 3.4214 | 3.4271 | 22282204.0 |
| 2008-10-21 10:35:00 | AAPL | Stock | 3.4275 | 3.4364 | 3.4232 | 3.425 | 14773444.0 |
| 2008-10-21 10:40:00 | AAPL | Stock | 3.4246 | 3.4379 | 3.4036 | 3.4093 | 22707888.0 |
| 2008-10-21 10:45:00 | AAPL | Stock | 3.4093 | 3.4143 | 3.3939 | 3.4054 | 22989260.0 |
| 2008-10-21 10:50:00 | AAPL | Stock | 3.4067 | 3.4139 | 3.3957 | 3.408 | 15959328.0 |
| 2008-10-21 10:55:00 | AAPL | Stock | 3.4079 | 3.4125 | 3.3939 | 3.3971 | 17666180.0 |
| 2008-10-21 11:00:00 | AAPL | Stock | 3.3975 | 3.4179 | 3.3962 | 3.4136 | 17830792.0 |
> showing 50 of 317,574 rows — these rows as CSV