PREVIEW / stock_5min / 2004-03-01
file: by_date/stock_5min/2004/2004-03-01.parquet size: 2.4 MB rows: 172,404 symbols: 1,729
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-03-01 08:00:00 | AAPL | Stock | 0.4273 | 0.4273 | 0.4273 | 0.4273 | 2144800.0 |
| 2004-03-01 08:25:00 | AAPL | Stock | 0.4271 | 0.4271 | 0.4271 | 0.4271 | 89600.0 |
| 2004-03-01 08:30:00 | AAPL | Stock | 0.4277 | 0.4313 | 0.4277 | 0.4313 | 100800.0 |
| 2004-03-01 08:35:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4313 | 0.4313 | 39200.0 |
| 2004-03-01 08:40:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4305 | 0.4305 | 84000.0 |
| 2004-03-01 08:45:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4313 | 0.4313 | 112000.0 |
| 2004-03-01 09:00:00 | AAPL | Stock | 0.4304 | 0.4313 | 0.4304 | 0.4313 | 56000.0 |
| 2004-03-01 09:10:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4313 | 0.4313 | 280000.0 |
| 2004-03-01 09:15:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4307 | 0.4313 | 95200.0 |
| 2004-03-01 09:20:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4307 | 0.4307 | 224000.0 |
| 2004-03-01 09:25:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4296 | 0.43 | 1512000.0 |
| 2004-03-01 09:30:00 | AAPL | Stock | 0.4304 | 0.4339 | 0.4295 | 0.4334 | 9961280.0 |
| 2004-03-01 09:35:00 | AAPL | Stock | 0.4334 | 0.4339 | 0.4295 | 0.4307 | 6893768.0 |
| 2004-03-01 09:40:00 | AAPL | Stock | 0.4304 | 0.4309 | 0.4284 | 0.4286 | 10974376.0 |
| 2004-03-01 09:45:00 | AAPL | Stock | 0.4286 | 0.4296 | 0.4284 | 0.4286 | 8958600.0 |
| 2004-03-01 09:50:00 | AAPL | Stock | 0.4293 | 0.4295 | 0.4282 | 0.4284 | 4736704.0 |
| 2004-03-01 09:55:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4263 | 0.4273 | 6154176.0 |
| 2004-03-01 10:00:00 | AAPL | Stock | 0.4271 | 0.4284 | 0.4266 | 0.4284 | 2979816.0 |
| 2004-03-01 10:05:00 | AAPL | Stock | 0.4284 | 0.4289 | 0.4275 | 0.4288 | 2237536.0 |
| 2004-03-01 10:10:00 | AAPL | Stock | 0.4286 | 0.4288 | 0.4271 | 0.4282 | 1356544.0 |
| 2004-03-01 10:15:00 | AAPL | Stock | 0.4284 | 0.4288 | 0.428 | 0.4288 | 2527168.0 |
| 2004-03-01 10:20:00 | AAPL | Stock | 0.4289 | 0.4302 | 0.4286 | 0.4289 | 3667440.0 |
| 2004-03-01 10:25:00 | AAPL | Stock | 0.4288 | 0.4293 | 0.4282 | 0.4284 | 3132472.0 |
| 2004-03-01 10:30:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4282 | 0.4284 | 1924944.0 |
| 2004-03-01 10:35:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4282 | 0.4282 | 1906464.0 |
| 2004-03-01 10:40:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4274 | 0.4282 | 3779608.0 |
| 2004-03-01 10:45:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4279 | 0.4282 | 6635048.0 |
| 2004-03-01 10:50:00 | AAPL | Stock | 0.428 | 0.4288 | 0.4275 | 0.4277 | 1480360.0 |
| 2004-03-01 10:55:00 | AAPL | Stock | 0.4279 | 0.43 | 0.4271 | 0.4271 | 3307920.0 |
| 2004-03-01 11:00:00 | AAPL | Stock | 0.4279 | 0.4281 | 0.4268 | 0.4273 | 2982896.0 |
| 2004-03-01 11:05:00 | AAPL | Stock | 0.4273 | 0.4279 | 0.4268 | 0.4277 | 2773288.0 |
| 2004-03-01 11:10:00 | AAPL | Stock | 0.4273 | 0.4282 | 0.4268 | 0.4277 | 2343152.0 |
| 2004-03-01 11:15:00 | AAPL | Stock | 0.4279 | 0.4279 | 0.4271 | 0.4275 | 775936.0 |
| 2004-03-01 11:20:00 | AAPL | Stock | 0.4275 | 0.4278 | 0.4268 | 0.4275 | 2716560.0 |
| 2004-03-01 11:25:00 | AAPL | Stock | 0.4277 | 0.428 | 0.4275 | 0.4277 | 886424.0 |
| 2004-03-01 11:30:00 | AAPL | Stock | 0.4275 | 0.4281 | 0.4275 | 0.4275 | 1342712.0 |
| 2004-03-01 11:35:00 | AAPL | Stock | 0.4279 | 0.4282 | 0.4275 | 0.428 | 1536472.0 |
| 2004-03-01 11:40:00 | AAPL | Stock | 0.428 | 0.4282 | 0.4277 | 0.4282 | 1663256.0 |
| 2004-03-01 11:45:00 | AAPL | Stock | 0.428 | 0.428 | 0.4275 | 0.428 | 2363592.0 |
| 2004-03-01 11:50:00 | AAPL | Stock | 0.428 | 0.4286 | 0.4279 | 0.4286 | 3114216.0 |
| 2004-03-01 11:55:00 | AAPL | Stock | 0.4286 | 0.4289 | 0.4284 | 0.4289 | 2496760.0 |
| 2004-03-01 12:00:00 | AAPL | Stock | 0.4289 | 0.4296 | 0.4284 | 0.4291 | 4418960.0 |
| 2004-03-01 12:05:00 | AAPL | Stock | 0.4289 | 0.4293 | 0.4289 | 0.4289 | 1604624.0 |
| 2004-03-01 12:10:00 | AAPL | Stock | 0.4291 | 0.4295 | 0.4289 | 0.4291 | 4403952.0 |
| 2004-03-01 12:15:00 | AAPL | Stock | 0.4293 | 0.4293 | 0.4284 | 0.4284 | 2142112.0 |
| 2004-03-01 12:20:00 | AAPL | Stock | 0.4284 | 0.4288 | 0.4277 | 0.428 | 1305640.0 |
| 2004-03-01 12:25:00 | AAPL | Stock | 0.4275 | 0.4277 | 0.4271 | 0.4275 | 1602776.0 |
| 2004-03-01 12:30:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4273 | 0.4275 | 716072.0 |
| 2004-03-01 12:35:00 | AAPL | Stock | 0.4273 | 0.4275 | 0.427 | 0.4275 | 1673672.0 |
| 2004-03-01 12:40:00 | AAPL | Stock | 0.4275 | 0.4277 | 0.4273 | 0.4277 | 967960.0 |
> showing 50 of 172,404 rows — these rows as CSV