PREVIEW / stock_5min / 2004-04-15
file: by_date/stock_5min/2004/2004-04-15.parquet size: 2.4 MB rows: 173,184 symbols: 1,753
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-04-15 08:00:00 | AAPL | Stock | 0.5232 | 0.53 | 0.5182 | 0.5232 | 3109344.0 |
| 2004-04-15 08:05:00 | AAPL | Stock | 0.5238 | 0.5238 | 0.5161 | 0.5161 | 2869216.0 |
| 2004-04-15 08:10:00 | AAPL | Stock | 0.5166 | 0.517 | 0.5113 | 0.5152 | 1850016.0 |
| 2004-04-15 08:15:00 | AAPL | Stock | 0.515 | 0.5152 | 0.5113 | 0.5113 | 1506400.0 |
| 2004-04-15 08:20:00 | AAPL | Stock | 0.5102 | 0.5125 | 0.51 | 0.5125 | 445200.0 |
| 2004-04-15 08:25:00 | AAPL | Stock | 0.5125 | 0.5134 | 0.5123 | 0.5134 | 1998248.0 |
| 2004-04-15 08:30:00 | AAPL | Stock | 0.5134 | 0.5134 | 0.5121 | 0.5125 | 2586080.0 |
| 2004-04-15 08:35:00 | AAPL | Stock | 0.513 | 0.513 | 0.5107 | 0.5107 | 448000.0 |
| 2004-04-15 08:40:00 | AAPL | Stock | 0.5105 | 0.5107 | 0.5089 | 0.5107 | 1892800.0 |
| 2004-04-15 08:45:00 | AAPL | Stock | 0.5107 | 0.5116 | 0.5071 | 0.5071 | 592536.0 |
| 2004-04-15 08:50:00 | AAPL | Stock | 0.5071 | 0.5107 | 0.507 | 0.5107 | 1534064.0 |
| 2004-04-15 08:55:00 | AAPL | Stock | 0.5107 | 0.5107 | 0.5089 | 0.5089 | 1820000.0 |
| 2004-04-15 09:00:00 | AAPL | Stock | 0.5104 | 0.5107 | 0.5095 | 0.5107 | 196000.0 |
| 2004-04-15 09:05:00 | AAPL | Stock | 0.5107 | 0.5107 | 0.5096 | 0.5107 | 772800.0 |
| 2004-04-15 09:10:00 | AAPL | Stock | 0.5123 | 0.5134 | 0.5116 | 0.5118 | 1741600.0 |
| 2004-04-15 09:15:00 | AAPL | Stock | 0.5125 | 0.5125 | 0.5098 | 0.5116 | 2290400.0 |
| 2004-04-15 09:20:00 | AAPL | Stock | 0.5145 | 0.5152 | 0.5114 | 0.512 | 812000.0 |
| 2004-04-15 09:25:00 | AAPL | Stock | 0.5123 | 0.517 | 0.5123 | 0.5134 | 6974016.0 |
| 2004-04-15 09:30:00 | AAPL | Stock | 0.5145 | 0.5196 | 0.5134 | 0.5195 | 78470000.0 |
| 2004-04-15 09:35:00 | AAPL | Stock | 0.5191 | 0.525 | 0.5173 | 0.5214 | 70764344.0 |
| 2004-04-15 09:40:00 | AAPL | Stock | 0.5213 | 0.5241 | 0.5193 | 0.5238 | 36932672.0 |
| 2004-04-15 09:45:00 | AAPL | Stock | 0.5238 | 0.525 | 0.518 | 0.5182 | 38453576.0 |
| 2004-04-15 09:50:00 | AAPL | Stock | 0.518 | 0.5223 | 0.5179 | 0.5216 | 34540968.0 |
| 2004-04-15 09:55:00 | AAPL | Stock | 0.5214 | 0.5241 | 0.5195 | 0.5225 | 31590496.0 |
| 2004-04-15 10:00:00 | AAPL | Stock | 0.5229 | 0.5238 | 0.5211 | 0.5223 | 22302112.0 |
| 2004-04-15 10:05:00 | AAPL | Stock | 0.5221 | 0.5236 | 0.5202 | 0.5211 | 26895904.0 |
| 2004-04-15 10:10:00 | AAPL | Stock | 0.5211 | 0.5268 | 0.5205 | 0.5264 | 36954120.0 |
| 2004-04-15 10:15:00 | AAPL | Stock | 0.5264 | 0.5282 | 0.5223 | 0.5234 | 36057952.0 |
| 2004-04-15 10:20:00 | AAPL | Stock | 0.5234 | 0.5236 | 0.5207 | 0.522 | 30227680.0 |
| 2004-04-15 10:25:00 | AAPL | Stock | 0.5223 | 0.5223 | 0.5186 | 0.5207 | 36961680.0 |
| 2004-04-15 10:30:00 | AAPL | Stock | 0.5207 | 0.5211 | 0.5189 | 0.5191 | 15557080.0 |
| 2004-04-15 10:35:00 | AAPL | Stock | 0.5191 | 0.5191 | 0.5154 | 0.5164 | 27481328.0 |
| 2004-04-15 10:40:00 | AAPL | Stock | 0.5164 | 0.5184 | 0.5159 | 0.5179 | 22979712.0 |
| 2004-04-15 10:45:00 | AAPL | Stock | 0.5179 | 0.5188 | 0.5163 | 0.5177 | 19615008.0 |
| 2004-04-15 10:50:00 | AAPL | Stock | 0.5179 | 0.5195 | 0.5164 | 0.5168 | 19211080.0 |
| 2004-04-15 10:55:00 | AAPL | Stock | 0.5168 | 0.5188 | 0.5163 | 0.518 | 16298688.0 |
| 2004-04-15 11:00:00 | AAPL | Stock | 0.5182 | 0.5186 | 0.5166 | 0.5177 | 17585792.0 |
| 2004-04-15 11:05:00 | AAPL | Stock | 0.5177 | 0.5179 | 0.5168 | 0.5175 | 17437224.0 |
| 2004-04-15 11:10:00 | AAPL | Stock | 0.5173 | 0.5175 | 0.5136 | 0.5136 | 15363152.0 |
| 2004-04-15 11:15:00 | AAPL | Stock | 0.5136 | 0.5155 | 0.5118 | 0.5118 | 25991896.0 |
| 2004-04-15 11:20:00 | AAPL | Stock | 0.5118 | 0.5154 | 0.5107 | 0.5143 | 25726904.0 |
| 2004-04-15 11:25:00 | AAPL | Stock | 0.5143 | 0.5148 | 0.5029 | 0.5138 | 10042984.0 |
| 2004-04-15 11:30:00 | AAPL | Stock | 0.5139 | 0.5154 | 0.5139 | 0.5152 | 11930576.0 |
| 2004-04-15 11:35:00 | AAPL | Stock | 0.515 | 0.5166 | 0.5149 | 0.5159 | 11013576.0 |
| 2004-04-15 11:40:00 | AAPL | Stock | 0.5159 | 0.5161 | 0.5134 | 0.5134 | 7038920.0 |
| 2004-04-15 11:45:00 | AAPL | Stock | 0.5134 | 0.5141 | 0.5113 | 0.5121 | 17697848.0 |
| 2004-04-15 11:50:00 | AAPL | Stock | 0.5123 | 0.5143 | 0.512 | 0.5139 | 13636168.0 |
| 2004-04-15 11:55:00 | AAPL | Stock | 0.5141 | 0.5146 | 0.5132 | 0.5134 | 9703344.0 |
| 2004-04-15 12:00:00 | AAPL | Stock | 0.5138 | 0.5155 | 0.513 | 0.5146 | 6014960.0 |
| 2004-04-15 12:05:00 | AAPL | Stock | 0.5146 | 0.5152 | 0.5102 | 0.5102 | 6436304.0 |
> showing 50 of 173,184 rows — these rows as CSV