PREVIEW / stock_5min / 2008-02-19
file: by_date/stock_5min/2008/2008-02-19.parquet size: 4.4 MB rows: 320,597 symbols: 3,282
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-02-19 04:20:00 | AAPL | Stock | 4.4854 | 4.4854 | 4.4854 | 4.4854 | 4200.0 |
| 2008-02-19 04:25:00 | AAPL | Stock | 4.4746 | 4.4746 | 4.4746 | 4.4746 | 11200.0 |
| 2008-02-19 05:30:00 | AAPL | Stock | 4.49 | 4.49 | 4.49 | 4.49 | 7000.0 |
| 2008-02-19 06:10:00 | AAPL | Stock | 4.49 | 4.4943 | 4.49 | 4.4943 | 25200.0 |
| 2008-02-19 06:25:00 | AAPL | Stock | 4.4918 | 4.4964 | 4.4918 | 4.4964 | 36400.0 |
| 2008-02-19 06:40:00 | AAPL | Stock | 4.4964 | 4.4996 | 4.4964 | 4.4996 | 39200.0 |
| 2008-02-19 07:00:00 | AAPL | Stock | 4.5086 | 4.5086 | 4.4964 | 4.5071 | 60732.0 |
| 2008-02-19 07:05:00 | AAPL | Stock | 4.5036 | 4.5036 | 4.4982 | 4.4982 | 61600.0 |
| 2008-02-19 07:10:00 | AAPL | Stock | 4.4968 | 4.5 | 4.4968 | 4.5 | 30800.0 |
| 2008-02-19 07:15:00 | AAPL | Stock | 4.5 | 4.5036 | 4.5 | 4.5036 | 30800.0 |
| 2008-02-19 07:20:00 | AAPL | Stock | 4.5071 | 4.5071 | 4.5071 | 4.5071 | 5600.0 |
| 2008-02-19 07:25:00 | AAPL | Stock | 4.5036 | 4.5036 | 4.5036 | 4.5036 | 19600.0 |
| 2008-02-19 07:30:00 | AAPL | Stock | 4.5004 | 4.5004 | 4.4982 | 4.4982 | 12600.0 |
| 2008-02-19 07:35:00 | AAPL | Stock | 4.5007 | 4.5071 | 4.5007 | 4.5071 | 53088.0 |
| 2008-02-19 07:50:00 | AAPL | Stock | 4.5143 | 4.5143 | 4.5089 | 4.5132 | 8400.0 |
| 2008-02-19 07:55:00 | AAPL | Stock | 4.5089 | 4.5175 | 4.5089 | 4.5132 | 206220.0 |
| 2008-02-19 08:00:00 | AAPL | Stock | 4.5132 | 4.5157 | 4.495 | 4.5114 | 836752.0 |
| 2008-02-19 08:05:00 | AAPL | Stock | 4.5125 | 4.5179 | 4.5096 | 4.5125 | 395052.0 |
| 2008-02-19 08:10:00 | AAPL | Stock | 4.5139 | 4.5143 | 4.5071 | 4.5089 | 440860.0 |
| 2008-02-19 08:15:00 | AAPL | Stock | 4.51 | 4.5107 | 4.5054 | 4.5064 | 270480.0 |
| 2008-02-19 08:20:00 | AAPL | Stock | 4.5071 | 4.5118 | 4.5018 | 4.5071 | 561400.0 |
| 2008-02-19 08:25:00 | AAPL | Stock | 4.5079 | 4.5143 | 4.5046 | 4.5071 | 655144.0 |
| 2008-02-19 08:30:00 | AAPL | Stock | 4.5071 | 4.5071 | 4.4936 | 4.5057 | 428876.0 |
| 2008-02-19 08:35:00 | AAPL | Stock | 4.5079 | 4.5089 | 4.5036 | 4.5071 | 289240.0 |
| 2008-02-19 08:40:00 | AAPL | Stock | 4.5082 | 4.5111 | 4.5036 | 4.5043 | 203532.0 |
| 2008-02-19 08:45:00 | AAPL | Stock | 4.5039 | 4.5039 | 4.4964 | 4.5036 | 330484.0 |
| 2008-02-19 08:50:00 | AAPL | Stock | 4.5029 | 4.5036 | 4.4975 | 4.5011 | 195664.0 |
| 2008-02-19 08:55:00 | AAPL | Stock | 4.5 | 4.5036 | 4.4964 | 4.5018 | 430920.0 |
| 2008-02-19 09:00:00 | AAPL | Stock | 4.5011 | 4.5011 | 4.4946 | 4.4946 | 225148.0 |
| 2008-02-19 09:05:00 | AAPL | Stock | 4.4946 | 4.4989 | 4.4946 | 4.4964 | 176792.0 |
| 2008-02-19 09:10:00 | AAPL | Stock | 4.4964 | 4.5036 | 4.4929 | 4.5032 | 551516.0 |
| 2008-02-19 09:15:00 | AAPL | Stock | 4.5018 | 4.5043 | 4.4964 | 4.5043 | 385924.0 |
| 2008-02-19 09:20:00 | AAPL | Stock | 4.505 | 4.505 | 4.4968 | 4.4986 | 250096.0 |
| 2008-02-19 09:25:00 | AAPL | Stock | 4.4968 | 4.505 | 4.4925 | 4.5 | 1375808.0 |
| 2008-02-19 09:30:00 | AAPL | Stock | 4.4989 | 4.5268 | 4.4975 | 4.5161 | 35163912.0 |
| 2008-02-19 09:35:00 | AAPL | Stock | 4.5157 | 4.5157 | 4.4886 | 4.4961 | 24095288.0 |
| 2008-02-19 09:40:00 | AAPL | Stock | 4.4954 | 4.5082 | 4.4911 | 4.5039 | 18052860.0 |
| 2008-02-19 09:45:00 | AAPL | Stock | 4.5036 | 4.5104 | 4.4836 | 4.4961 | 22409632.0 |
| 2008-02-19 09:50:00 | AAPL | Stock | 4.4961 | 4.4968 | 4.4746 | 4.4925 | 23191308.0 |
| 2008-02-19 09:55:00 | AAPL | Stock | 4.4921 | 4.4989 | 4.48 | 4.4854 | 16553516.0 |
| 2008-02-19 10:00:00 | AAPL | Stock | 4.4857 | 4.5011 | 4.4843 | 4.4864 | 15962632.0 |
| 2008-02-19 10:05:00 | AAPL | Stock | 4.4864 | 4.4954 | 4.48 | 4.4911 | 13532820.0 |
| 2008-02-19 10:10:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4764 | 4.4825 | 13676796.0 |
| 2008-02-19 10:15:00 | AAPL | Stock | 4.4829 | 4.4861 | 4.4707 | 4.4757 | 17171252.0 |
| 2008-02-19 10:20:00 | AAPL | Stock | 4.4754 | 4.4807 | 4.4664 | 4.4771 | 15276520.0 |
| 2008-02-19 10:25:00 | AAPL | Stock | 4.4775 | 4.4784 | 4.4618 | 4.4679 | 12718916.0 |
| 2008-02-19 10:30:00 | AAPL | Stock | 4.4675 | 4.4696 | 4.4564 | 4.4657 | 21537600.0 |
| 2008-02-19 10:35:00 | AAPL | Stock | 4.4657 | 4.4721 | 4.4611 | 4.4679 | 10534748.0 |
| 2008-02-19 10:40:00 | AAPL | Stock | 4.4679 | 4.4714 | 4.4575 | 4.4586 | 9520952.0 |
| 2008-02-19 10:45:00 | AAPL | Stock | 4.4586 | 4.4611 | 4.45 | 4.4568 | 16555616.0 |
> showing 50 of 320,597 rows — these rows as CSV