PREVIEW / stock_5min / 2005-04-07
file: by_date/stock_5min/2005/2005-04-07.parquet size: 2.6 MB rows: 189,420 symbols: 1,948
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-07 08:00:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5161 | 1.5179 | 450100.0 |
| 2005-04-07 08:05:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5139 | 1.5139 | 56000.0 |
| 2005-04-07 08:15:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 25200.0 |
| 2005-04-07 08:20:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5161 | 1.5161 | 81200.0 |
| 2005-04-07 08:30:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5143 | 1.5143 | 26600.0 |
| 2005-04-07 08:35:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 44800.0 |
| 2005-04-07 08:40:00 | AAPL | Stock | 1.5139 | 1.5139 | 1.5139 | 1.5139 | 14000.0 |
| 2005-04-07 08:45:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5125 | 1.5125 | 85680.0 |
| 2005-04-07 08:50:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5107 | 1.5111 | 34300.0 |
| 2005-04-07 08:55:00 | AAPL | Stock | 1.5111 | 1.5111 | 1.5107 | 1.5107 | 33600.0 |
| 2005-04-07 09:00:00 | AAPL | Stock | 1.5118 | 1.5143 | 1.5118 | 1.5139 | 44800.0 |
| 2005-04-07 09:05:00 | AAPL | Stock | 1.5136 | 1.5139 | 1.5132 | 1.5132 | 74200.0 |
| 2005-04-07 09:10:00 | AAPL | Stock | 1.5132 | 1.5132 | 1.5125 | 1.5132 | 22400.0 |
| 2005-04-07 09:15:00 | AAPL | Stock | 1.5118 | 1.5118 | 1.505 | 1.51 | 130200.0 |
| 2005-04-07 09:20:00 | AAPL | Stock | 1.5107 | 1.5125 | 1.5096 | 1.51 | 410032.0 |
| 2005-04-07 09:25:00 | AAPL | Stock | 1.5111 | 1.5175 | 1.5107 | 1.5125 | 874300.0 |
| 2005-04-07 09:30:00 | AAPL | Stock | 1.5118 | 1.5161 | 1.5089 | 1.5104 | 10919020.0 |
| 2005-04-07 09:35:00 | AAPL | Stock | 1.5118 | 1.5207 | 1.5118 | 1.5204 | 10323908.0 |
| 2005-04-07 09:40:00 | AAPL | Stock | 1.5204 | 1.5207 | 1.5114 | 1.5139 | 12008416.0 |
| 2005-04-07 09:45:00 | AAPL | Stock | 1.5143 | 1.5196 | 1.5121 | 1.5165 | 6168008.0 |
| 2005-04-07 09:50:00 | AAPL | Stock | 1.5179 | 1.5239 | 1.5164 | 1.5218 | 11359320.0 |
| 2005-04-07 09:55:00 | AAPL | Stock | 1.5218 | 1.5264 | 1.5196 | 1.5236 | 11206468.0 |
| 2005-04-07 10:00:00 | AAPL | Stock | 1.5239 | 1.5261 | 1.5221 | 1.5243 | 8014272.0 |
| 2005-04-07 10:05:00 | AAPL | Stock | 1.5246 | 1.5268 | 1.5221 | 1.5221 | 5252716.0 |
| 2005-04-07 10:10:00 | AAPL | Stock | 1.5225 | 1.5261 | 1.5211 | 1.5257 | 6416872.0 |
| 2005-04-07 10:15:00 | AAPL | Stock | 1.5257 | 1.5261 | 1.5236 | 1.5243 | 6037836.0 |
| 2005-04-07 10:20:00 | AAPL | Stock | 1.5243 | 1.5254 | 1.5214 | 1.5246 | 5230400.0 |
| 2005-04-07 10:25:00 | AAPL | Stock | 1.525 | 1.525 | 1.5214 | 1.5221 | 5432392.0 |
| 2005-04-07 10:30:00 | AAPL | Stock | 1.5221 | 1.5282 | 1.5218 | 1.5254 | 11646740.0 |
| 2005-04-07 10:35:00 | AAPL | Stock | 1.5254 | 1.5264 | 1.5246 | 1.525 | 7220724.0 |
| 2005-04-07 10:40:00 | AAPL | Stock | 1.5254 | 1.5275 | 1.525 | 1.525 | 4505480.0 |
| 2005-04-07 10:45:00 | AAPL | Stock | 1.525 | 1.5264 | 1.525 | 1.5254 | 4132184.0 |
| 2005-04-07 10:50:00 | AAPL | Stock | 1.5254 | 1.5271 | 1.525 | 1.5257 | 4376456.0 |
| 2005-04-07 10:55:00 | AAPL | Stock | 1.5254 | 1.5264 | 1.525 | 1.5253 | 3421628.0 |
| 2005-04-07 11:00:00 | AAPL | Stock | 1.5254 | 1.5293 | 1.5246 | 1.5293 | 6696984.0 |
| 2005-04-07 11:05:00 | AAPL | Stock | 1.5293 | 1.5339 | 1.5282 | 1.5336 | 12845980.0 |
| 2005-04-07 11:10:00 | AAPL | Stock | 1.5332 | 1.5336 | 1.5307 | 1.5311 | 4662280.0 |
| 2005-04-07 11:15:00 | AAPL | Stock | 1.5311 | 1.5314 | 1.5275 | 1.5282 | 4844672.0 |
| 2005-04-07 11:20:00 | AAPL | Stock | 1.5282 | 1.53 | 1.5275 | 1.5296 | 3830204.0 |
| 2005-04-07 11:25:00 | AAPL | Stock | 1.5296 | 1.53 | 1.5275 | 1.5275 | 2706480.0 |
| 2005-04-07 11:30:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.5268 | 1.5268 | 3601024.0 |
| 2005-04-07 11:35:00 | AAPL | Stock | 1.5268 | 1.5286 | 1.5268 | 1.5282 | 2059624.0 |
| 2005-04-07 11:40:00 | AAPL | Stock | 1.5282 | 1.5286 | 1.5268 | 1.5279 | 3206616.0 |
| 2005-04-07 11:45:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5268 | 1.5268 | 3097612.0 |
| 2005-04-07 11:50:00 | AAPL | Stock | 1.5268 | 1.5279 | 1.5254 | 1.5257 | 4906916.0 |
| 2005-04-07 11:55:00 | AAPL | Stock | 1.5254 | 1.5275 | 1.525 | 1.5271 | 4118016.0 |
| 2005-04-07 12:00:00 | AAPL | Stock | 1.5271 | 1.5275 | 1.5257 | 1.5275 | 2177168.0 |
| 2005-04-07 12:05:00 | AAPL | Stock | 1.5275 | 1.5296 | 1.5261 | 1.5296 | 3654252.0 |
| 2005-04-07 12:10:00 | AAPL | Stock | 1.5293 | 1.53 | 1.5261 | 1.5268 | 6480348.0 |
| 2005-04-07 12:15:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.525 | 1.5257 | 2524368.0 |
> showing 50 of 189,420 rows — these rows as CSV