PREVIEW / stock_5min / 2010-03-04
file: by_date/stock_5min/2010/2010-03-04.parquet size: 4.6 MB rows: 316,384 symbols: 3,446
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-04 07:25:00 | AAPL | Stock | 7.4836 | 7.4839 | 7.4836 | 7.4836 | 53284.0 |
| 2010-03-04 07:30:00 | AAPL | Stock | 7.4836 | 7.4836 | 7.4818 | 7.4818 | 16800.0 |
| 2010-03-04 07:45:00 | AAPL | Stock | 7.4704 | 7.4836 | 7.4704 | 7.4836 | 5600.0 |
| 2010-03-04 07:55:00 | AAPL | Stock | 7.4711 | 7.4711 | 7.4711 | 7.4711 | 2800.0 |
| 2010-03-04 08:00:00 | AAPL | Stock | 7.475 | 7.4793 | 7.4732 | 7.4793 | 42000.0 |
| 2010-03-04 08:05:00 | AAPL | Stock | 7.4768 | 7.4782 | 7.4768 | 7.4768 | 33600.0 |
| 2010-03-04 08:10:00 | AAPL | Stock | 7.4711 | 7.4711 | 7.4646 | 7.4696 | 60200.0 |
| 2010-03-04 08:20:00 | AAPL | Stock | 7.4696 | 7.4696 | 7.4607 | 7.4643 | 61348.0 |
| 2010-03-04 08:25:00 | AAPL | Stock | 7.4679 | 7.4693 | 7.4643 | 7.4693 | 19600.0 |
| 2010-03-04 08:30:00 | AAPL | Stock | 7.475 | 7.4782 | 7.4693 | 7.4779 | 169708.0 |
| 2010-03-04 08:35:00 | AAPL | Stock | 7.4771 | 7.4782 | 7.4736 | 7.4782 | 98000.0 |
| 2010-03-04 08:40:00 | AAPL | Stock | 7.4782 | 7.4839 | 7.4782 | 7.4786 | 261100.0 |
| 2010-03-04 08:45:00 | AAPL | Stock | 7.4768 | 7.4768 | 7.4768 | 7.4768 | 11900.0 |
| 2010-03-04 08:50:00 | AAPL | Stock | 7.48 | 7.4832 | 7.4786 | 7.4821 | 174440.0 |
| 2010-03-04 08:55:00 | AAPL | Stock | 7.4821 | 7.4839 | 7.4821 | 7.4839 | 136612.0 |
| 2010-03-04 09:00:00 | AAPL | Stock | 7.4839 | 7.4839 | 7.4832 | 7.4832 | 23800.0 |
| 2010-03-04 09:05:00 | AAPL | Stock | 7.4832 | 7.4879 | 7.4814 | 7.4879 | 84056.0 |
| 2010-03-04 09:10:00 | AAPL | Stock | 7.4864 | 7.4879 | 7.4846 | 7.4864 | 104860.0 |
| 2010-03-04 09:15:00 | AAPL | Stock | 7.4879 | 7.4882 | 7.4739 | 7.4811 | 183260.0 |
| 2010-03-04 09:20:00 | AAPL | Stock | 7.4811 | 7.4839 | 7.4807 | 7.4829 | 33600.0 |
| 2010-03-04 09:25:00 | AAPL | Stock | 7.4807 | 7.4818 | 7.4779 | 7.4779 | 31500.0 |
| 2010-03-04 09:30:00 | AAPL | Stock | 7.4761 | 7.4904 | 7.4725 | 7.4754 | 7483672.0 |
| 2010-03-04 09:35:00 | AAPL | Stock | 7.475 | 7.4768 | 7.4554 | 7.4604 | 9833096.0 |
| 2010-03-04 09:40:00 | AAPL | Stock | 7.46 | 7.4743 | 7.4511 | 7.4707 | 9817472.0 |
| 2010-03-04 09:45:00 | AAPL | Stock | 7.4704 | 7.4814 | 7.4689 | 7.4739 | 9130184.0 |
| 2010-03-04 09:50:00 | AAPL | Stock | 7.4721 | 7.5136 | 7.4721 | 7.5111 | 17422608.0 |
| 2010-03-04 09:55:00 | AAPL | Stock | 7.5121 | 7.5329 | 7.5104 | 7.525 | 18473728.0 |
| 2010-03-04 10:00:00 | AAPL | Stock | 7.525 | 7.5257 | 7.5107 | 7.5214 | 12034344.0 |
| 2010-03-04 10:05:00 | AAPL | Stock | 7.5218 | 7.5264 | 7.5 | 7.5039 | 9970100.0 |
| 2010-03-04 10:10:00 | AAPL | Stock | 7.5043 | 7.5093 | 7.4964 | 7.505 | 6232660.0 |
| 2010-03-04 10:15:00 | AAPL | Stock | 7.5043 | 7.5057 | 7.4911 | 7.4969 | 8828036.0 |
| 2010-03-04 10:20:00 | AAPL | Stock | 7.4961 | 7.5046 | 7.4811 | 7.5009 | 6052984.0 |
| 2010-03-04 10:25:00 | AAPL | Stock | 7.5011 | 7.5068 | 7.4977 | 7.5032 | 6054972.0 |
| 2010-03-04 10:30:00 | AAPL | Stock | 7.5043 | 7.505 | 7.4757 | 7.4821 | 9115288.0 |
| 2010-03-04 10:35:00 | AAPL | Stock | 7.4821 | 7.4921 | 7.475 | 7.4771 | 8371384.0 |
| 2010-03-04 10:40:00 | AAPL | Stock | 7.4779 | 7.4864 | 7.4661 | 7.4861 | 6449940.0 |
| 2010-03-04 10:45:00 | AAPL | Stock | 7.4864 | 7.4868 | 7.4807 | 7.4868 | 2434824.0 |
| 2010-03-04 10:50:00 | AAPL | Stock | 7.4864 | 7.4868 | 7.4757 | 7.4839 | 3458616.0 |
| 2010-03-04 10:55:00 | AAPL | Stock | 7.4842 | 7.495 | 7.4839 | 7.4893 | 3761044.0 |
| 2010-03-04 11:00:00 | AAPL | Stock | 7.4907 | 7.5093 | 7.4875 | 7.5036 | 4744544.0 |
| 2010-03-04 11:05:00 | AAPL | Stock | 7.5036 | 7.5074 | 7.4986 | 7.5064 | 3829728.0 |
| 2010-03-04 11:10:00 | AAPL | Stock | 7.5068 | 7.5118 | 7.5004 | 7.5017 | 3464888.0 |
| 2010-03-04 11:15:00 | AAPL | Stock | 7.5018 | 7.5121 | 7.4993 | 7.5111 | 4587072.0 |
| 2010-03-04 11:20:00 | AAPL | Stock | 7.5111 | 7.5125 | 7.5061 | 7.5093 | 3194800.0 |
| 2010-03-04 11:25:00 | AAPL | Stock | 7.5104 | 7.5125 | 7.5014 | 7.5054 | 3343480.0 |
| 2010-03-04 11:30:00 | AAPL | Stock | 7.5054 | 7.5086 | 7.4968 | 7.4996 | 3927364.0 |
| 2010-03-04 11:35:00 | AAPL | Stock | 7.5 | 7.5043 | 7.4954 | 7.5014 | 2409652.0 |
| 2010-03-04 11:40:00 | AAPL | Stock | 7.5014 | 7.5029 | 7.4946 | 7.4952 | 1443624.0 |
| 2010-03-04 11:45:00 | AAPL | Stock | 7.4946 | 7.5071 | 7.4929 | 7.5021 | 2604644.0 |
| 2010-03-04 11:50:00 | AAPL | Stock | 7.5025 | 7.5125 | 7.4986 | 7.5122 | 2299472.0 |
> showing 50 of 316,384 rows — these rows as CSV