PREVIEW / stock_5min / 2008-11-07
file: by_date/stock_5min/2008/2008-11-07.parquet size: 4.2 MB rows: 307,529 symbols: 3,282
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-11-07 07:00:00 | AAPL | Stock | 3.6179 | 3.6179 | 3.5896 | 3.5896 | 8400.0 |
| 2008-11-07 07:30:00 | AAPL | Stock | 3.5821 | 3.5821 | 3.5714 | 3.575 | 33600.0 |
| 2008-11-07 07:35:00 | AAPL | Stock | 3.575 | 3.575 | 3.5714 | 3.5714 | 33600.0 |
| 2008-11-07 07:40:00 | AAPL | Stock | 3.575 | 3.575 | 3.575 | 3.575 | 8400.0 |
| 2008-11-07 07:45:00 | AAPL | Stock | 3.5746 | 3.5746 | 3.5707 | 3.5711 | 42000.0 |
| 2008-11-07 07:50:00 | AAPL | Stock | 3.5711 | 3.5786 | 3.5661 | 3.5661 | 43736.0 |
| 2008-11-07 07:55:00 | AAPL | Stock | 3.5643 | 3.5779 | 3.5625 | 3.5625 | 43736.0 |
| 2008-11-07 08:00:00 | AAPL | Stock | 3.5714 | 3.5732 | 3.5582 | 3.5611 | 235956.0 |
| 2008-11-07 08:05:00 | AAPL | Stock | 3.5611 | 3.5611 | 3.5579 | 3.5589 | 126140.0 |
| 2008-11-07 08:10:00 | AAPL | Stock | 3.5604 | 3.5607 | 3.5575 | 3.5593 | 118440.0 |
| 2008-11-07 08:15:00 | AAPL | Stock | 3.5571 | 3.5596 | 3.55 | 3.5596 | 302708.0 |
| 2008-11-07 08:20:00 | AAPL | Stock | 3.5607 | 3.5707 | 3.5482 | 3.5482 | 860748.0 |
| 2008-11-07 08:25:00 | AAPL | Stock | 3.5618 | 3.5679 | 3.5554 | 3.5679 | 98280.0 |
| 2008-11-07 08:30:00 | AAPL | Stock | 3.5614 | 3.5786 | 3.5289 | 3.5521 | 1352204.0 |
| 2008-11-07 08:35:00 | AAPL | Stock | 3.5507 | 3.5639 | 3.5429 | 3.5514 | 511980.0 |
| 2008-11-07 08:40:00 | AAPL | Stock | 3.5514 | 3.5696 | 3.5475 | 3.5679 | 423920.0 |
| 2008-11-07 08:45:00 | AAPL | Stock | 3.5693 | 3.5707 | 3.5554 | 3.5571 | 477764.0 |
| 2008-11-07 08:50:00 | AAPL | Stock | 3.5546 | 3.5546 | 3.5411 | 3.5429 | 486752.0 |
| 2008-11-07 08:55:00 | AAPL | Stock | 3.5432 | 3.5479 | 3.5293 | 3.5293 | 641088.0 |
| 2008-11-07 09:00:00 | AAPL | Stock | 3.5336 | 3.5346 | 3.5221 | 3.5286 | 507976.0 |
| 2008-11-07 09:05:00 | AAPL | Stock | 3.5268 | 3.5493 | 3.5268 | 3.5457 | 401604.0 |
| 2008-11-07 09:10:00 | AAPL | Stock | 3.5468 | 3.5518 | 3.5446 | 3.5496 | 269696.0 |
| 2008-11-07 09:15:00 | AAPL | Stock | 3.55 | 3.5539 | 3.5471 | 3.5536 | 266224.0 |
| 2008-11-07 09:20:00 | AAPL | Stock | 3.5507 | 3.5536 | 3.5486 | 3.5536 | 142800.0 |
| 2008-11-07 09:25:00 | AAPL | Stock | 3.5536 | 3.5546 | 3.5321 | 3.5418 | 982940.0 |
| 2008-11-07 09:30:00 | AAPL | Stock | 3.5418 | 3.5571 | 3.5143 | 3.5411 | 28818972.0 |
| 2008-11-07 09:35:00 | AAPL | Stock | 3.5411 | 3.5411 | 3.4879 | 3.5 | 31643304.0 |
| 2008-11-07 09:40:00 | AAPL | Stock | 3.5 | 3.5111 | 3.4618 | 3.4632 | 28539588.0 |
| 2008-11-07 09:45:00 | AAPL | Stock | 3.4629 | 3.4725 | 3.4239 | 3.4332 | 33767552.0 |
| 2008-11-07 09:50:00 | AAPL | Stock | 3.4339 | 3.4457 | 3.4186 | 3.4439 | 27807416.0 |
| 2008-11-07 09:55:00 | AAPL | Stock | 3.4429 | 3.4514 | 3.4325 | 3.4432 | 20989024.0 |
| 2008-11-07 10:00:00 | AAPL | Stock | 3.4436 | 3.4804 | 3.4418 | 3.4718 | 28261268.0 |
| 2008-11-07 10:05:00 | AAPL | Stock | 3.4718 | 3.4929 | 3.4675 | 3.4864 | 26097400.0 |
| 2008-11-07 10:10:00 | AAPL | Stock | 3.4861 | 3.4898 | 3.4693 | 3.4769 | 21220528.0 |
| 2008-11-07 10:15:00 | AAPL | Stock | 3.4771 | 3.4889 | 3.4636 | 3.4804 | 19865720.0 |
| 2008-11-07 10:20:00 | AAPL | Stock | 3.4804 | 3.5118 | 3.4793 | 3.5014 | 23300984.0 |
| 2008-11-07 10:25:00 | AAPL | Stock | 3.5014 | 3.5161 | 3.4964 | 3.5011 | 19150628.0 |
| 2008-11-07 10:30:00 | AAPL | Stock | 3.5018 | 3.5132 | 3.4954 | 3.4986 | 16603916.0 |
| 2008-11-07 10:35:00 | AAPL | Stock | 3.4981 | 3.5418 | 3.4979 | 3.5389 | 21220584.0 |
| 2008-11-07 10:40:00 | AAPL | Stock | 3.5379 | 3.5589 | 3.5293 | 3.5482 | 19598376.0 |
| 2008-11-07 10:45:00 | AAPL | Stock | 3.5479 | 3.5661 | 3.5364 | 3.5377 | 19755876.0 |
| 2008-11-07 10:50:00 | AAPL | Stock | 3.5375 | 3.5446 | 3.5336 | 3.5421 | 14569912.0 |
| 2008-11-07 10:55:00 | AAPL | Stock | 3.5418 | 3.5507 | 3.5229 | 3.5282 | 13648936.0 |
| 2008-11-07 11:00:00 | AAPL | Stock | 3.5289 | 3.5321 | 3.5071 | 3.5118 | 16570960.0 |
| 2008-11-07 11:05:00 | AAPL | Stock | 3.5118 | 3.5254 | 3.4879 | 3.4907 | 16749992.0 |
| 2008-11-07 11:10:00 | AAPL | Stock | 3.4907 | 3.51 | 3.4893 | 3.5075 | 14423304.0 |
| 2008-11-07 11:15:00 | AAPL | Stock | 3.5068 | 3.5207 | 3.5018 | 3.5089 | 12945268.0 |
| 2008-11-07 11:20:00 | AAPL | Stock | 3.5086 | 3.5118 | 3.4832 | 3.4925 | 15839852.0 |
| 2008-11-07 11:25:00 | AAPL | Stock | 3.4932 | 3.4946 | 3.4704 | 3.4882 | 15901508.0 |
| 2008-11-07 11:30:00 | AAPL | Stock | 3.4875 | 3.4946 | 3.4782 | 3.4861 | 12506844.0 |
> showing 50 of 307,529 rows — these rows as CSV