PREVIEW / stock_5min / 2009-03-17
file: by_date/stock_5min/2009/2009-03-17.parquet size: 4.3 MB rows: 299,545 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-17 08:00:00 | AAPL | Stock | 3.3939 | 3.4196 | 3.3846 | 3.4054 | 47740.0 |
| 2009-03-17 08:05:00 | AAPL | Stock | 3.4054 | 3.4061 | 3.4018 | 3.4018 | 121100.0 |
| 2009-03-17 08:10:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3846 | 3.3846 | 69524.0 |
| 2009-03-17 08:15:00 | AAPL | Stock | 3.3846 | 3.3846 | 3.3846 | 3.3846 | 2800.0 |
| 2009-03-17 08:20:00 | AAPL | Stock | 3.3918 | 3.3939 | 3.3918 | 3.3929 | 30436.0 |
| 2009-03-17 08:25:00 | AAPL | Stock | 3.3929 | 3.3939 | 3.3857 | 3.3861 | 80444.0 |
| 2009-03-17 08:30:00 | AAPL | Stock | 3.3918 | 3.4161 | 3.3918 | 3.4064 | 131376.0 |
| 2009-03-17 08:40:00 | AAPL | Stock | 3.4129 | 3.4143 | 3.4129 | 3.4143 | 8400.0 |
| 2009-03-17 08:45:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4071 | 3.4071 | 25200.0 |
| 2009-03-17 08:50:00 | AAPL | Stock | 3.4021 | 3.4021 | 3.3929 | 3.3943 | 164416.0 |
| 2009-03-17 08:55:00 | AAPL | Stock | 3.3979 | 3.3979 | 3.3936 | 3.3979 | 16800.0 |
| 2009-03-17 09:00:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3936 | 3.3936 | 123424.0 |
| 2009-03-17 09:05:00 | AAPL | Stock | 3.3939 | 3.3957 | 3.3939 | 3.3939 | 8400.0 |
| 2009-03-17 09:10:00 | AAPL | Stock | 3.4 | 3.4036 | 3.3964 | 3.3968 | 96572.0 |
| 2009-03-17 09:15:00 | AAPL | Stock | 3.3954 | 3.3971 | 3.3943 | 3.3964 | 19600.0 |
| 2009-03-17 09:20:00 | AAPL | Stock | 3.4014 | 3.4018 | 3.3968 | 3.3975 | 137200.0 |
| 2009-03-17 09:25:00 | AAPL | Stock | 3.3996 | 3.4061 | 3.3979 | 3.4 | 151200.0 |
| 2009-03-17 09:30:00 | AAPL | Stock | 3.4029 | 3.4382 | 3.3954 | 3.422 | 13080816.0 |
| 2009-03-17 09:35:00 | AAPL | Stock | 3.4257 | 3.4589 | 3.4221 | 3.4529 | 16900352.0 |
| 2009-03-17 09:40:00 | AAPL | Stock | 3.4529 | 3.4625 | 3.4507 | 3.4543 | 14769468.0 |
| 2009-03-17 09:45:00 | AAPL | Stock | 3.4539 | 3.4679 | 3.4482 | 3.4593 | 19261368.0 |
| 2009-03-17 09:50:00 | AAPL | Stock | 3.4602 | 3.4814 | 3.4593 | 3.4768 | 21242144.0 |
| 2009-03-17 09:55:00 | AAPL | Stock | 3.4771 | 3.4925 | 3.4761 | 3.4766 | 17725260.0 |
| 2009-03-17 10:00:00 | AAPL | Stock | 3.4771 | 3.4964 | 3.4771 | 3.4886 | 14214844.0 |
| 2009-03-17 10:05:00 | AAPL | Stock | 3.4882 | 3.4929 | 3.4852 | 3.4921 | 10271072.0 |
| 2009-03-17 10:10:00 | AAPL | Stock | 3.4921 | 3.4986 | 3.48 | 3.4832 | 12431804.0 |
| 2009-03-17 10:15:00 | AAPL | Stock | 3.4836 | 3.4946 | 3.4814 | 3.4818 | 9153368.0 |
| 2009-03-17 10:20:00 | AAPL | Stock | 3.4811 | 3.4946 | 3.4793 | 3.4879 | 7559664.0 |
| 2009-03-17 10:25:00 | AAPL | Stock | 3.4871 | 3.4954 | 3.4811 | 3.4854 | 9665964.0 |
| 2009-03-17 10:30:00 | AAPL | Stock | 3.4861 | 3.4914 | 3.4818 | 3.4829 | 4774140.0 |
| 2009-03-17 10:35:00 | AAPL | Stock | 3.4832 | 3.5 | 3.4825 | 3.4954 | 11347364.0 |
| 2009-03-17 10:40:00 | AAPL | Stock | 3.4961 | 3.5057 | 3.4875 | 3.5014 | 9978892.0 |
| 2009-03-17 10:45:00 | AAPL | Stock | 3.5018 | 3.5075 | 3.4946 | 3.4946 | 8988588.0 |
| 2009-03-17 10:50:00 | AAPL | Stock | 3.4971 | 3.5025 | 3.4907 | 3.4986 | 7807856.0 |
| 2009-03-17 10:55:00 | AAPL | Stock | 3.4986 | 3.5007 | 3.4911 | 3.4921 | 4884656.0 |
| 2009-03-17 11:00:00 | AAPL | Stock | 3.4925 | 3.4925 | 3.4871 | 3.4879 | 5567128.0 |
| 2009-03-17 11:05:00 | AAPL | Stock | 3.4886 | 3.4996 | 3.4875 | 3.4986 | 4891096.0 |
| 2009-03-17 11:10:00 | AAPL | Stock | 3.4982 | 3.5018 | 3.4961 | 3.4996 | 5326720.0 |
| 2009-03-17 11:15:00 | AAPL | Stock | 3.4996 | 3.5036 | 3.4932 | 3.4979 | 5283012.0 |
| 2009-03-17 11:20:00 | AAPL | Stock | 3.4971 | 3.5136 | 3.4957 | 3.5046 | 7151956.0 |
| 2009-03-17 11:25:00 | AAPL | Stock | 3.5046 | 3.5069 | 3.4921 | 3.4979 | 6356700.0 |
| 2009-03-17 11:30:00 | AAPL | Stock | 3.4979 | 3.5011 | 3.4955 | 3.4964 | 5030228.0 |
| 2009-03-17 11:35:00 | AAPL | Stock | 3.4964 | 3.5043 | 3.4962 | 3.5039 | 4081056.0 |
| 2009-03-17 11:40:00 | AAPL | Stock | 3.5039 | 3.5136 | 3.5032 | 3.5057 | 6350232.0 |
| 2009-03-17 11:45:00 | AAPL | Stock | 3.5054 | 3.5114 | 3.5029 | 3.5107 | 4984112.0 |
| 2009-03-17 11:50:00 | AAPL | Stock | 3.5107 | 3.5161 | 3.5054 | 3.5104 | 6387836.0 |
| 2009-03-17 11:55:00 | AAPL | Stock | 3.5107 | 3.5114 | 3.5061 | 3.5075 | 3945844.0 |
| 2009-03-17 12:00:00 | AAPL | Stock | 3.5075 | 3.5175 | 3.5054 | 3.5146 | 8523340.0 |
| 2009-03-17 12:05:00 | AAPL | Stock | 3.5143 | 3.5161 | 3.5086 | 3.5111 | 3530352.0 |
| 2009-03-17 12:10:00 | AAPL | Stock | 3.5109 | 3.5111 | 3.5025 | 3.5054 | 5281584.0 |
> showing 50 of 299,545 rows — these rows as CSV