PREVIEW / stock_5min / 2008-12-08
file: by_date/stock_5min/2008/2008-12-08.parquet size: 4.5 MB rows: 323,078 symbols: 3,362
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-12-08 06:00:00 | AAPL | Stock | 3.4168 | 3.4168 | 3.4168 | 3.4168 | 2800.0 |
| 2008-12-08 06:05:00 | AAPL | Stock | 3.4168 | 3.4168 | 3.4168 | 3.4168 | 25200.0 |
| 2008-12-08 06:50:00 | AAPL | Stock | 3.4279 | 3.4279 | 3.4279 | 3.4279 | 8400.0 |
| 2008-12-08 06:55:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.4321 | 3.4321 | 5600.0 |
| 2008-12-08 07:00:00 | AAPL | Stock | 3.4311 | 3.4321 | 3.4286 | 3.4286 | 26600.0 |
| 2008-12-08 07:05:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 8820.0 |
| 2008-12-08 07:10:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 11200.0 |
| 2008-12-08 07:15:00 | AAPL | Stock | 3.4314 | 3.4314 | 3.4314 | 3.4314 | 5600.0 |
| 2008-12-08 07:20:00 | AAPL | Stock | 3.4321 | 3.4461 | 3.4321 | 3.4461 | 38304.0 |
| 2008-12-08 07:25:00 | AAPL | Stock | 3.4457 | 3.4461 | 3.4457 | 3.4461 | 41720.0 |
| 2008-12-08 07:30:00 | AAPL | Stock | 3.4464 | 3.4643 | 3.4461 | 3.4536 | 129920.0 |
| 2008-12-08 07:35:00 | AAPL | Stock | 3.45 | 3.4536 | 3.45 | 3.45 | 36400.0 |
| 2008-12-08 07:40:00 | AAPL | Stock | 3.4482 | 3.4482 | 3.4482 | 3.4482 | 17304.0 |
| 2008-12-08 07:45:00 | AAPL | Stock | 3.4482 | 3.4482 | 3.4464 | 3.4464 | 26824.0 |
| 2008-12-08 07:50:00 | AAPL | Stock | 3.45 | 3.4607 | 3.45 | 3.4607 | 113120.0 |
| 2008-12-08 07:55:00 | AAPL | Stock | 3.4607 | 3.4643 | 3.4518 | 3.4518 | 66444.0 |
| 2008-12-08 08:00:00 | AAPL | Stock | 3.4607 | 3.4643 | 3.4411 | 3.4589 | 540484.0 |
| 2008-12-08 08:05:00 | AAPL | Stock | 3.4589 | 3.4711 | 3.4561 | 3.4696 | 218932.0 |
| 2008-12-08 08:10:00 | AAPL | Stock | 3.4711 | 3.4857 | 3.4711 | 3.4857 | 558600.0 |
| 2008-12-08 08:15:00 | AAPL | Stock | 3.4857 | 3.4857 | 3.4786 | 3.4821 | 208236.0 |
| 2008-12-08 08:20:00 | AAPL | Stock | 3.4854 | 3.4857 | 3.4732 | 3.4814 | 138656.0 |
| 2008-12-08 08:25:00 | AAPL | Stock | 3.4779 | 3.4814 | 3.4736 | 3.475 | 120596.0 |
| 2008-12-08 08:30:00 | AAPL | Stock | 3.4786 | 3.4836 | 3.475 | 3.4786 | 421204.0 |
| 2008-12-08 08:35:00 | AAPL | Stock | 3.4814 | 3.4861 | 3.4804 | 3.4861 | 120960.0 |
| 2008-12-08 08:40:00 | AAPL | Stock | 3.4854 | 3.4868 | 3.4821 | 3.4839 | 123200.0 |
| 2008-12-08 08:45:00 | AAPL | Stock | 3.4839 | 3.4861 | 3.475 | 3.4782 | 455280.0 |
| 2008-12-08 08:50:00 | AAPL | Stock | 3.4786 | 3.4839 | 3.4779 | 3.4793 | 178696.0 |
| 2008-12-08 08:55:00 | AAPL | Stock | 3.4786 | 3.4836 | 3.4721 | 3.4768 | 589820.0 |
| 2008-12-08 09:00:00 | AAPL | Stock | 3.4779 | 3.4779 | 3.4714 | 3.4714 | 355460.0 |
| 2008-12-08 09:05:00 | AAPL | Stock | 3.4764 | 3.485 | 3.4761 | 3.4839 | 332332.0 |
| 2008-12-08 09:10:00 | AAPL | Stock | 3.4843 | 3.5 | 3.4839 | 3.4893 | 1254960.0 |
| 2008-12-08 09:15:00 | AAPL | Stock | 3.4879 | 3.4946 | 3.4843 | 3.4879 | 607712.0 |
| 2008-12-08 09:20:00 | AAPL | Stock | 3.4889 | 3.4925 | 3.485 | 3.4868 | 455924.0 |
| 2008-12-08 09:25:00 | AAPL | Stock | 3.4871 | 3.4871 | 3.4596 | 3.4729 | 1821316.0 |
| 2008-12-08 09:30:00 | AAPL | Stock | 3.4743 | 3.4821 | 3.44 | 3.4436 | 33781272.0 |
| 2008-12-08 09:35:00 | AAPL | Stock | 3.4425 | 3.4536 | 3.4214 | 3.4364 | 29956108.0 |
| 2008-12-08 09:40:00 | AAPL | Stock | 3.4354 | 3.4643 | 3.4264 | 3.4464 | 26522692.0 |
| 2008-12-08 09:45:00 | AAPL | Stock | 3.4471 | 3.4639 | 3.4321 | 3.4536 | 21442708.0 |
| 2008-12-08 09:50:00 | AAPL | Stock | 3.4539 | 3.46 | 3.4375 | 3.4439 | 16125592.0 |
| 2008-12-08 09:55:00 | AAPL | Stock | 3.4439 | 3.4693 | 3.4414 | 3.4568 | 17393768.0 |
| 2008-12-08 10:00:00 | AAPL | Stock | 3.4561 | 3.4739 | 3.4489 | 3.4704 | 15725164.0 |
| 2008-12-08 10:05:00 | AAPL | Stock | 3.47 | 3.4996 | 3.4696 | 3.4943 | 24547432.0 |
| 2008-12-08 10:10:00 | AAPL | Stock | 3.4929 | 3.4986 | 3.4796 | 3.4864 | 19772844.0 |
| 2008-12-08 10:15:00 | AAPL | Stock | 3.4879 | 3.4961 | 3.4732 | 3.4825 | 12059824.0 |
| 2008-12-08 10:20:00 | AAPL | Stock | 3.4832 | 3.5004 | 3.4789 | 3.4961 | 15431024.0 |
| 2008-12-08 10:25:00 | AAPL | Stock | 3.4954 | 3.5096 | 3.4914 | 3.5082 | 20209924.0 |
| 2008-12-08 10:30:00 | AAPL | Stock | 3.5086 | 3.5261 | 3.5036 | 3.5236 | 17116400.0 |
| 2008-12-08 10:35:00 | AAPL | Stock | 3.5232 | 3.5339 | 3.52 | 3.5314 | 17245676.0 |
| 2008-12-08 10:40:00 | AAPL | Stock | 3.5314 | 3.5532 | 3.5296 | 3.5525 | 24054240.0 |
| 2008-12-08 10:45:00 | AAPL | Stock | 3.5521 | 3.5625 | 3.5418 | 3.5436 | 23699256.0 |
> showing 50 of 323,078 rows — these rows as CSV