PREVIEW / stock_5min / 2002-01-31
file: by_date/stock_5min/2002/2002-01-31.parquet size: 1.7 MB rows: 120,004 symbols: 1,352
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-31 08:00:00 | AAPL | Stock | 0.4352 | 0.4352 | 0.4296 | 0.4296 | 308000.0 |
| 2002-01-31 08:15:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4313 | 0.4313 | 22400.0 |
| 2002-01-31 08:20:00 | AAPL | Stock | 0.4307 | 0.4307 | 0.4307 | 0.4307 | 5600.0 |
| 2002-01-31 08:25:00 | AAPL | Stock | 0.4307 | 0.4307 | 0.4307 | 0.4307 | 11200.0 |
| 2002-01-31 08:30:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4304 | 0.4304 | 33600.0 |
| 2002-01-31 08:35:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4303 | 0.4304 | 56000.0 |
| 2002-01-31 08:40:00 | AAPL | Stock | 0.4311 | 0.4311 | 0.4311 | 0.4311 | 5600.0 |
| 2002-01-31 08:45:00 | AAPL | Stock | 0.4298 | 0.4298 | 0.4295 | 0.4295 | 95200.0 |
| 2002-01-31 08:55:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4304 | 0.4304 | 112000.0 |
| 2002-01-31 09:00:00 | AAPL | Stock | 0.4304 | 0.4309 | 0.4304 | 0.4309 | 296800.0 |
| 2002-01-31 09:10:00 | AAPL | Stock | 0.4304 | 0.4309 | 0.4304 | 0.4309 | 1192800.0 |
| 2002-01-31 09:15:00 | AAPL | Stock | 0.4309 | 0.4309 | 0.4309 | 0.4309 | 1691200.0 |
| 2002-01-31 09:20:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4313 | 0.4313 | 162400.0 |
| 2002-01-31 09:25:00 | AAPL | Stock | 0.4321 | 0.4321 | 0.4313 | 0.4313 | 347200.0 |
| 2002-01-31 09:30:00 | AAPL | Stock | 0.4314 | 0.4336 | 0.4309 | 0.433 | 18631200.0 |
| 2002-01-31 09:35:00 | AAPL | Stock | 0.4329 | 0.4336 | 0.4305 | 0.4323 | 14795200.0 |
| 2002-01-31 09:40:00 | AAPL | Stock | 0.4327 | 0.4338 | 0.4323 | 0.4332 | 14896000.0 |
| 2002-01-31 09:45:00 | AAPL | Stock | 0.4334 | 0.435 | 0.433 | 0.4339 | 21000000.0 |
| 2002-01-31 09:50:00 | AAPL | Stock | 0.4339 | 0.4348 | 0.4329 | 0.4339 | 7067200.0 |
| 2002-01-31 09:55:00 | AAPL | Stock | 0.4341 | 0.4348 | 0.4332 | 0.4339 | 4900000.0 |
| 2002-01-31 10:00:00 | AAPL | Stock | 0.4343 | 0.4354 | 0.433 | 0.4343 | 6451200.0 |
| 2002-01-31 10:05:00 | AAPL | Stock | 0.4341 | 0.4343 | 0.4321 | 0.4327 | 18984000.0 |
| 2002-01-31 10:10:00 | AAPL | Stock | 0.4323 | 0.4339 | 0.4321 | 0.4336 | 10281600.0 |
| 2002-01-31 10:15:00 | AAPL | Stock | 0.4336 | 0.4354 | 0.4332 | 0.435 | 5325600.0 |
| 2002-01-31 10:20:00 | AAPL | Stock | 0.4346 | 0.4354 | 0.4339 | 0.4343 | 5320000.0 |
| 2002-01-31 10:25:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4331 | 0.4336 | 7352800.0 |
| 2002-01-31 10:30:00 | AAPL | Stock | 0.4336 | 0.4346 | 0.4332 | 0.4346 | 2654400.0 |
| 2002-01-31 10:35:00 | AAPL | Stock | 0.4343 | 0.435 | 0.4339 | 0.4343 | 3444000.0 |
| 2002-01-31 10:40:00 | AAPL | Stock | 0.4345 | 0.4348 | 0.4338 | 0.4338 | 3276000.0 |
| 2002-01-31 10:45:00 | AAPL | Stock | 0.4338 | 0.4339 | 0.4321 | 0.4327 | 2430400.0 |
| 2002-01-31 10:50:00 | AAPL | Stock | 0.4325 | 0.4327 | 0.4307 | 0.4327 | 3600800.0 |
| 2002-01-31 10:55:00 | AAPL | Stock | 0.4327 | 0.4334 | 0.4316 | 0.4329 | 2828000.0 |
| 2002-01-31 11:00:00 | AAPL | Stock | 0.4327 | 0.4339 | 0.4327 | 0.4336 | 1803200.0 |
| 2002-01-31 11:05:00 | AAPL | Stock | 0.4336 | 0.4336 | 0.4321 | 0.4321 | 3998400.0 |
| 2002-01-31 11:10:00 | AAPL | Stock | 0.432 | 0.4339 | 0.432 | 0.4338 | 2049600.0 |
| 2002-01-31 11:15:00 | AAPL | Stock | 0.4338 | 0.4338 | 0.4314 | 0.4323 | 1680000.0 |
| 2002-01-31 11:20:00 | AAPL | Stock | 0.4314 | 0.4336 | 0.4314 | 0.4334 | 2766400.0 |
| 2002-01-31 11:25:00 | AAPL | Stock | 0.4334 | 0.4338 | 0.4332 | 0.4336 | 2676800.0 |
| 2002-01-31 11:30:00 | AAPL | Stock | 0.4336 | 0.4348 | 0.4336 | 0.4345 | 2189600.0 |
| 2002-01-31 11:35:00 | AAPL | Stock | 0.4345 | 0.4355 | 0.4339 | 0.4343 | 7756000.0 |
| 2002-01-31 11:40:00 | AAPL | Stock | 0.4346 | 0.4371 | 0.4341 | 0.4348 | 13462400.0 |
| 2002-01-31 11:45:00 | AAPL | Stock | 0.4346 | 0.4348 | 0.4339 | 0.4345 | 7722400.0 |
| 2002-01-31 11:50:00 | AAPL | Stock | 0.4345 | 0.4348 | 0.4332 | 0.4339 | 8758400.0 |
| 2002-01-31 11:55:00 | AAPL | Stock | 0.4339 | 0.4355 | 0.4336 | 0.4348 | 12689600.0 |
| 2002-01-31 12:00:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4339 | 0.4348 | 4664800.0 |
| 2002-01-31 12:05:00 | AAPL | Stock | 0.435 | 0.4355 | 0.4346 | 0.435 | 1993600.0 |
| 2002-01-31 12:10:00 | AAPL | Stock | 0.4348 | 0.4352 | 0.4343 | 0.435 | 1136800.0 |
| 2002-01-31 12:15:00 | AAPL | Stock | 0.435 | 0.4363 | 0.435 | 0.435 | 3623200.0 |
| 2002-01-31 12:20:00 | AAPL | Stock | 0.4354 | 0.4355 | 0.4338 | 0.4341 | 2385600.0 |
| 2002-01-31 12:25:00 | AAPL | Stock | 0.4339 | 0.4341 | 0.4336 | 0.4338 | 3880800.0 |
> showing 50 of 120,004 rows — these rows as CSV