PREVIEW / stock_5min / 2008-09-26
file: by_date/stock_5min/2008/2008-09-26.parquet size: 4.4 MB rows: 316,921 symbols: 3,334
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-26 05:10:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5429 | 4.5429 | 8400.0 |
| 2008-09-26 06:05:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5536 | 4.5536 | 2800.0 |
| 2008-09-26 06:15:00 | AAPL | Stock | 4.5554 | 4.5554 | 4.5554 | 4.5554 | 2800.0 |
| 2008-09-26 06:20:00 | AAPL | Stock | 4.5414 | 4.5414 | 4.5357 | 4.5357 | 14000.0 |
| 2008-09-26 06:35:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5357 | 4.5357 | 2800.0 |
| 2008-09-26 06:55:00 | AAPL | Stock | 4.5054 | 4.5054 | 4.4714 | 4.5 | 103908.0 |
| 2008-09-26 07:00:00 | AAPL | Stock | 4.5 | 4.5 | 4.4761 | 4.4761 | 183260.0 |
| 2008-09-26 07:05:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 14000.0 |
| 2008-09-26 07:10:00 | AAPL | Stock | 4.4832 | 4.5 | 4.4832 | 4.5 | 29400.0 |
| 2008-09-26 07:15:00 | AAPL | Stock | 4.4911 | 4.4929 | 4.4911 | 4.4911 | 16800.0 |
| 2008-09-26 07:20:00 | AAPL | Stock | 4.4821 | 4.5 | 4.4764 | 4.5 | 50120.0 |
| 2008-09-26 07:25:00 | AAPL | Stock | 4.5 | 4.5 | 4.4839 | 4.5 | 38948.0 |
| 2008-09-26 07:35:00 | AAPL | Stock | 4.5 | 4.5 | 4.495 | 4.495 | 201180.0 |
| 2008-09-26 07:40:00 | AAPL | Stock | 4.4996 | 4.5 | 4.4964 | 4.4964 | 131964.0 |
| 2008-09-26 07:45:00 | AAPL | Stock | 4.5 | 4.5 | 4.4918 | 4.5 | 108780.0 |
| 2008-09-26 07:50:00 | AAPL | Stock | 4.4989 | 4.5 | 4.4825 | 4.4825 | 190232.0 |
| 2008-09-26 07:55:00 | AAPL | Stock | 4.4764 | 4.4943 | 4.4764 | 4.4943 | 36400.0 |
| 2008-09-26 08:00:00 | AAPL | Stock | 4.4825 | 4.5036 | 4.4757 | 4.4839 | 581028.0 |
| 2008-09-26 08:05:00 | AAPL | Stock | 4.4921 | 4.4921 | 4.4518 | 4.4518 | 1030680.0 |
| 2008-09-26 08:10:00 | AAPL | Stock | 4.4568 | 4.4643 | 4.4518 | 4.4571 | 360556.0 |
| 2008-09-26 08:15:00 | AAPL | Stock | 4.4639 | 4.4782 | 4.4589 | 4.4661 | 451948.0 |
| 2008-09-26 08:20:00 | AAPL | Stock | 4.4679 | 4.4721 | 4.4518 | 4.4554 | 251692.0 |
| 2008-09-26 08:25:00 | AAPL | Stock | 4.4607 | 4.4646 | 4.4554 | 4.4589 | 485212.0 |
| 2008-09-26 08:30:00 | AAPL | Stock | 4.4589 | 4.5437 | 4.4518 | 4.4554 | 1661772.0 |
| 2008-09-26 08:35:00 | AAPL | Stock | 4.4586 | 4.4714 | 4.4429 | 4.4429 | 1113868.0 |
| 2008-09-26 08:40:00 | AAPL | Stock | 4.4432 | 4.4432 | 4.4243 | 4.4286 | 1468824.0 |
| 2008-09-26 08:45:00 | AAPL | Stock | 4.4289 | 4.4589 | 4.4229 | 4.4518 | 1067136.0 |
| 2008-09-26 08:50:00 | AAPL | Stock | 4.4518 | 4.4532 | 4.4421 | 4.4429 | 247296.0 |
| 2008-09-26 08:55:00 | AAPL | Stock | 4.4429 | 4.4464 | 4.4275 | 4.4275 | 1415932.0 |
| 2008-09-26 09:00:00 | AAPL | Stock | 4.4321 | 4.4561 | 4.4232 | 4.4464 | 1976072.0 |
| 2008-09-26 09:05:00 | AAPL | Stock | 4.4486 | 4.4711 | 4.4486 | 4.4579 | 1420272.0 |
| 2008-09-26 09:10:00 | AAPL | Stock | 4.4589 | 4.4643 | 4.4389 | 4.4579 | 719740.0 |
| 2008-09-26 09:15:00 | AAPL | Stock | 4.4579 | 4.4732 | 4.4579 | 4.4714 | 633948.0 |
| 2008-09-26 09:20:00 | AAPL | Stock | 4.4754 | 4.4789 | 4.4607 | 4.4607 | 584080.0 |
| 2008-09-26 09:25:00 | AAPL | Stock | 4.46 | 4.4686 | 4.4557 | 4.4618 | 740152.0 |
| 2008-09-26 09:30:00 | AAPL | Stock | 4.4611 | 4.4875 | 4.3929 | 4.4142 | 45199252.0 |
| 2008-09-26 09:35:00 | AAPL | Stock | 4.4139 | 4.5179 | 4.4004 | 4.4893 | 36820476.0 |
| 2008-09-26 09:40:00 | AAPL | Stock | 4.4882 | 4.5486 | 4.4757 | 4.5007 | 40384876.0 |
| 2008-09-26 09:45:00 | AAPL | Stock | 4.5025 | 4.5332 | 4.4857 | 4.5204 | 22272068.0 |
| 2008-09-26 09:50:00 | AAPL | Stock | 4.52 | 4.5311 | 4.4929 | 4.5168 | 20523356.0 |
| 2008-09-26 09:55:00 | AAPL | Stock | 4.5154 | 4.5536 | 4.4964 | 4.5064 | 22188712.0 |
| 2008-09-26 10:00:00 | AAPL | Stock | 4.5061 | 4.5404 | 4.495 | 4.5146 | 20479424.0 |
| 2008-09-26 10:05:00 | AAPL | Stock | 4.5143 | 4.5164 | 4.4879 | 4.4964 | 18042108.0 |
| 2008-09-26 10:10:00 | AAPL | Stock | 4.4979 | 4.5004 | 4.4689 | 4.4839 | 20405504.0 |
| 2008-09-26 10:15:00 | AAPL | Stock | 4.4839 | 4.4875 | 4.4618 | 4.4736 | 19553492.0 |
| 2008-09-26 10:20:00 | AAPL | Stock | 4.4743 | 4.4954 | 4.4682 | 4.4736 | 17951500.0 |
| 2008-09-26 10:25:00 | AAPL | Stock | 4.4736 | 4.4764 | 4.4561 | 4.4664 | 18455528.0 |
| 2008-09-26 10:30:00 | AAPL | Stock | 4.4664 | 4.4768 | 4.4539 | 4.4718 | 13761524.0 |
| 2008-09-26 10:35:00 | AAPL | Stock | 4.4714 | 4.4904 | 4.46 | 4.4893 | 12139736.0 |
| 2008-09-26 10:40:00 | AAPL | Stock | 4.49 | 4.5068 | 4.4776 | 4.4854 | 14470484.0 |
> showing 50 of 316,921 rows — these rows as CSV