PREVIEW / stock_5min / 2004-03-10
file: by_date/stock_5min/2004/2004-03-10.parquet size: 2.4 MB rows: 169,167 symbols: 1,729
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-10 08:00:00 | AAPL | Stock | 0.4848 | 0.4888 | 0.4839 | 0.4839 | 145600.0 |
| 2004-03-10 08:25:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4821 | 0.4821 | 5600.0 |
| 2004-03-10 08:50:00 | AAPL | Stock | 0.482 | 0.482 | 0.482 | 0.482 | 5600.0 |
| 2004-03-10 08:55:00 | AAPL | Stock | 0.4841 | 0.4841 | 0.4841 | 0.4841 | 1736000.0 |
| 2004-03-10 09:05:00 | AAPL | Stock | 0.4821 | 0.4836 | 0.4821 | 0.4836 | 162400.0 |
| 2004-03-10 09:15:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4816 | 0.4816 | 251832.0 |
| 2004-03-10 09:20:00 | AAPL | Stock | 0.4813 | 0.4813 | 0.4813 | 0.4813 | 95200.0 |
| 2004-03-10 09:25:00 | AAPL | Stock | 0.4813 | 0.483 | 0.4811 | 0.4821 | 5363176.0 |
| 2004-03-10 09:30:00 | AAPL | Stock | 0.4814 | 0.4866 | 0.4814 | 0.4863 | 16618504.0 |
| 2004-03-10 09:35:00 | AAPL | Stock | 0.4863 | 0.4884 | 0.4846 | 0.4852 | 16087344.0 |
| 2004-03-10 09:40:00 | AAPL | Stock | 0.4848 | 0.4884 | 0.4848 | 0.4857 | 7727496.0 |
| 2004-03-10 09:45:00 | AAPL | Stock | 0.4857 | 0.4889 | 0.4857 | 0.4873 | 8466248.0 |
| 2004-03-10 09:50:00 | AAPL | Stock | 0.4877 | 0.4904 | 0.4868 | 0.488 | 11385976.0 |
| 2004-03-10 09:55:00 | AAPL | Stock | 0.4891 | 0.4911 | 0.488 | 0.4902 | 18480168.0 |
| 2004-03-10 10:00:00 | AAPL | Stock | 0.4902 | 0.4916 | 0.4884 | 0.4913 | 22137360.0 |
| 2004-03-10 10:05:00 | AAPL | Stock | 0.4913 | 0.4982 | 0.4904 | 0.4955 | 46027912.0 |
| 2004-03-10 10:10:00 | AAPL | Stock | 0.4955 | 0.4968 | 0.4943 | 0.4954 | 15035216.0 |
| 2004-03-10 10:15:00 | AAPL | Stock | 0.4954 | 0.4955 | 0.4938 | 0.495 | 12039832.0 |
| 2004-03-10 10:20:00 | AAPL | Stock | 0.495 | 0.4964 | 0.4946 | 0.4957 | 13583136.0 |
| 2004-03-10 10:25:00 | AAPL | Stock | 0.4957 | 0.5 | 0.4955 | 0.498 | 23774632.0 |
| 2004-03-10 10:30:00 | AAPL | Stock | 0.4979 | 0.5018 | 0.4977 | 0.5009 | 27877808.0 |
| 2004-03-10 10:35:00 | AAPL | Stock | 0.5009 | 0.5014 | 0.4993 | 0.5007 | 19437544.0 |
| 2004-03-10 10:40:00 | AAPL | Stock | 0.5007 | 0.5007 | 0.4993 | 0.4996 | 14166824.0 |
| 2004-03-10 10:45:00 | AAPL | Stock | 0.5 | 0.5009 | 0.4993 | 0.5 | 17485440.0 |
| 2004-03-10 10:50:00 | AAPL | Stock | 0.5 | 0.5025 | 0.4998 | 0.5002 | 22695680.0 |
| 2004-03-10 10:55:00 | AAPL | Stock | 0.5002 | 0.5009 | 0.4995 | 0.4998 | 13546176.0 |
| 2004-03-10 11:00:00 | AAPL | Stock | 0.4998 | 0.5013 | 0.4998 | 0.5011 | 13306496.0 |
| 2004-03-10 11:05:00 | AAPL | Stock | 0.5009 | 0.502 | 0.5005 | 0.502 | 17005576.0 |
| 2004-03-10 11:10:00 | AAPL | Stock | 0.502 | 0.5025 | 0.5009 | 0.502 | 7952896.0 |
| 2004-03-10 11:15:00 | AAPL | Stock | 0.502 | 0.5023 | 0.5 | 0.5 | 16953272.0 |
| 2004-03-10 11:20:00 | AAPL | Stock | 0.5 | 0.5009 | 0.4998 | 0.5 | 8995280.0 |
| 2004-03-10 11:25:00 | AAPL | Stock | 0.4998 | 0.5002 | 0.498 | 0.4996 | 9288832.0 |
| 2004-03-10 11:30:00 | AAPL | Stock | 0.4996 | 0.5007 | 0.4993 | 0.5005 | 8779400.0 |
| 2004-03-10 11:35:00 | AAPL | Stock | 0.5005 | 0.5013 | 0.4995 | 0.5 | 12697160.0 |
| 2004-03-10 11:40:00 | AAPL | Stock | 0.4998 | 0.5002 | 0.4984 | 0.4989 | 16298856.0 |
| 2004-03-10 11:45:00 | AAPL | Stock | 0.4989 | 0.5 | 0.4973 | 0.4988 | 8917272.0 |
| 2004-03-10 11:50:00 | AAPL | Stock | 0.4984 | 0.4988 | 0.4973 | 0.498 | 5849816.0 |
| 2004-03-10 11:55:00 | AAPL | Stock | 0.4977 | 0.4982 | 0.4973 | 0.4982 | 11381160.0 |
| 2004-03-10 12:00:00 | AAPL | Stock | 0.4982 | 0.4982 | 0.4963 | 0.4966 | 9975168.0 |
| 2004-03-10 12:05:00 | AAPL | Stock | 0.4968 | 0.4982 | 0.4968 | 0.4973 | 5282648.0 |
| 2004-03-10 12:10:00 | AAPL | Stock | 0.4971 | 0.4984 | 0.4968 | 0.498 | 9455040.0 |
| 2004-03-10 12:15:00 | AAPL | Stock | 0.4979 | 0.4988 | 0.4979 | 0.4979 | 8100008.0 |
| 2004-03-10 12:20:00 | AAPL | Stock | 0.4979 | 0.498 | 0.4973 | 0.4975 | 5582416.0 |
| 2004-03-10 12:25:00 | AAPL | Stock | 0.4975 | 0.4977 | 0.4973 | 0.4973 | 1282512.0 |
| 2004-03-10 12:30:00 | AAPL | Stock | 0.4973 | 0.4973 | 0.4964 | 0.4964 | 13285048.0 |
| 2004-03-10 12:35:00 | AAPL | Stock | 0.4964 | 0.4968 | 0.4963 | 0.4964 | 3444056.0 |
| 2004-03-10 12:40:00 | AAPL | Stock | 0.4966 | 0.4982 | 0.4964 | 0.498 | 7362264.0 |
| 2004-03-10 12:45:00 | AAPL | Stock | 0.4977 | 0.4979 | 0.4964 | 0.4973 | 6280120.0 |
| 2004-03-10 12:50:00 | AAPL | Stock | 0.4975 | 0.4984 | 0.4966 | 0.4968 | 2497824.0 |
| 2004-03-10 12:55:00 | AAPL | Stock | 0.4968 | 0.497 | 0.4961 | 0.4961 | 3887632.0 |
> showing 50 of 169,167 rows — these rows as CSV