PREVIEW / stock_5min / 2008-05-27
file: by_date/stock_5min/2008/2008-05-27.parquet size: 4.4 MB rows: 320,229 symbols: 3,307
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-05-27 07:00:00 | AAPL | Stock | 6.4846 | 6.4846 | 6.4846 | 6.4846 | 27720.0 |
| 2008-05-27 07:15:00 | AAPL | Stock | 6.4818 | 6.4818 | 6.4818 | 6.4818 | 2800.0 |
| 2008-05-27 07:30:00 | AAPL | Stock | 6.4839 | 6.4846 | 6.4839 | 6.4846 | 20384.0 |
| 2008-05-27 07:40:00 | AAPL | Stock | 6.4893 | 6.4893 | 6.4893 | 6.4893 | 2800.0 |
| 2008-05-27 07:45:00 | AAPL | Stock | 6.4857 | 6.4857 | 6.4857 | 6.4857 | 30800.0 |
| 2008-05-27 07:50:00 | AAPL | Stock | 6.4893 | 6.4893 | 6.4893 | 6.4893 | 5600.0 |
| 2008-05-27 08:00:00 | AAPL | Stock | 6.4793 | 6.4979 | 6.4789 | 6.4964 | 615664.0 |
| 2008-05-27 08:05:00 | AAPL | Stock | 6.4929 | 6.5 | 6.4907 | 6.495 | 362264.0 |
| 2008-05-27 08:10:00 | AAPL | Stock | 6.5 | 6.5068 | 6.4946 | 6.4964 | 330204.0 |
| 2008-05-27 08:15:00 | AAPL | Stock | 6.4961 | 6.4961 | 6.4893 | 6.4893 | 139300.0 |
| 2008-05-27 08:20:00 | AAPL | Stock | 6.4896 | 6.4896 | 6.4789 | 6.4818 | 322196.0 |
| 2008-05-27 08:25:00 | AAPL | Stock | 6.4821 | 6.4857 | 6.4732 | 6.4779 | 121324.0 |
| 2008-05-27 08:30:00 | AAPL | Stock | 6.4786 | 6.4839 | 6.4786 | 6.4839 | 59052.0 |
| 2008-05-27 08:35:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4814 | 6.4814 | 29064.0 |
| 2008-05-27 08:40:00 | AAPL | Stock | 6.4821 | 6.4839 | 6.4814 | 6.4839 | 113932.0 |
| 2008-05-27 08:45:00 | AAPL | Stock | 6.4857 | 6.4929 | 6.4843 | 6.4929 | 97776.0 |
| 2008-05-27 08:50:00 | AAPL | Stock | 6.4929 | 6.4946 | 6.4882 | 6.4882 | 71456.0 |
| 2008-05-27 08:55:00 | AAPL | Stock | 6.4882 | 6.4946 | 6.4882 | 6.4946 | 83580.0 |
| 2008-05-27 09:00:00 | AAPL | Stock | 6.495 | 6.4986 | 6.4871 | 6.4982 | 394856.0 |
| 2008-05-27 09:05:00 | AAPL | Stock | 6.4979 | 6.5071 | 6.4968 | 6.5018 | 367416.0 |
| 2008-05-27 09:10:00 | AAPL | Stock | 6.5057 | 6.5146 | 6.5039 | 6.5104 | 627956.0 |
| 2008-05-27 09:15:00 | AAPL | Stock | 6.5089 | 6.5132 | 6.5057 | 6.5132 | 170912.0 |
| 2008-05-27 09:20:00 | AAPL | Stock | 6.5111 | 6.5132 | 6.5107 | 6.5107 | 82124.0 |
| 2008-05-27 09:25:00 | AAPL | Stock | 6.5089 | 6.5282 | 6.5068 | 6.5279 | 1406160.0 |
| 2008-05-27 09:30:00 | AAPL | Stock | 6.5271 | 6.5429 | 6.5146 | 6.5318 | 30162832.0 |
| 2008-05-27 09:35:00 | AAPL | Stock | 6.5318 | 6.5707 | 6.5311 | 6.5611 | 23450364.0 |
| 2008-05-27 09:40:00 | AAPL | Stock | 6.5611 | 6.5632 | 6.5379 | 6.545 | 16679208.0 |
| 2008-05-27 09:45:00 | AAPL | Stock | 6.5454 | 6.5804 | 6.5454 | 6.56 | 18364976.0 |
| 2008-05-27 09:50:00 | AAPL | Stock | 6.5621 | 6.57 | 6.55 | 6.5629 | 12071892.0 |
| 2008-05-27 09:55:00 | AAPL | Stock | 6.5629 | 6.5679 | 6.5536 | 6.5614 | 10394832.0 |
| 2008-05-27 10:00:00 | AAPL | Stock | 6.5629 | 6.5804 | 6.5493 | 6.5693 | 20294148.0 |
| 2008-05-27 10:05:00 | AAPL | Stock | 6.5693 | 6.5793 | 6.565 | 6.5732 | 13228936.0 |
| 2008-05-27 10:10:00 | AAPL | Stock | 6.573 | 6.5757 | 6.5643 | 6.5664 | 12798240.0 |
| 2008-05-27 10:15:00 | AAPL | Stock | 6.5668 | 6.5746 | 6.5607 | 6.5629 | 13554716.0 |
| 2008-05-27 10:20:00 | AAPL | Stock | 6.5636 | 6.5746 | 6.5589 | 6.5729 | 9842868.0 |
| 2008-05-27 10:25:00 | AAPL | Stock | 6.5729 | 6.575 | 6.5632 | 6.5746 | 7787836.0 |
| 2008-05-27 10:30:00 | AAPL | Stock | 6.5739 | 6.5886 | 6.5625 | 6.5625 | 18174800.0 |
| 2008-05-27 10:35:00 | AAPL | Stock | 6.5632 | 6.5693 | 6.5564 | 6.5575 | 10240440.0 |
| 2008-05-27 10:40:00 | AAPL | Stock | 6.5566 | 6.5732 | 6.5546 | 6.5643 | 9851716.0 |
| 2008-05-27 10:45:00 | AAPL | Stock | 6.5643 | 6.5714 | 6.5611 | 6.5664 | 5514824.0 |
| 2008-05-27 10:50:00 | AAPL | Stock | 6.5663 | 6.5679 | 6.56 | 6.5654 | 4899580.0 |
| 2008-05-27 10:55:00 | AAPL | Stock | 6.5652 | 6.5789 | 6.5643 | 6.5725 | 7955108.0 |
| 2008-05-27 11:00:00 | AAPL | Stock | 6.5729 | 6.5821 | 6.5679 | 6.5796 | 8771672.0 |
| 2008-05-27 11:05:00 | AAPL | Stock | 6.5789 | 6.58 | 6.5589 | 6.5654 | 9337748.0 |
| 2008-05-27 11:10:00 | AAPL | Stock | 6.5654 | 6.5657 | 6.5511 | 6.5532 | 9434460.0 |
| 2008-05-27 11:15:00 | AAPL | Stock | 6.5521 | 6.5543 | 6.5393 | 6.5454 | 12163956.0 |
| 2008-05-27 11:20:00 | AAPL | Stock | 6.5457 | 6.55 | 6.5357 | 6.5393 | 10133424.0 |
| 2008-05-27 11:25:00 | AAPL | Stock | 6.5393 | 6.5514 | 6.5364 | 6.5432 | 6410516.0 |
| 2008-05-27 11:30:00 | AAPL | Stock | 6.5432 | 6.5443 | 6.5307 | 6.5314 | 8976856.0 |
| 2008-05-27 11:35:00 | AAPL | Stock | 6.5318 | 6.5429 | 6.5314 | 6.5346 | 7743372.0 |
> showing 50 of 320,229 rows — these rows as CSV