PREVIEW / stock_5min / 2004-09-10
file: by_date/stock_5min/2004/2004-09-10.parquet size: 2.4 MB rows: 173,859 symbols: 1,824
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-09-10 08:25:00 | AAPL | Stock | 0.6375 | 0.6375 | 0.6375 | 0.6375 | 33600.0 |
| 2004-09-10 08:45:00 | AAPL | Stock | 0.6375 | 0.6375 | 0.6375 | 0.6375 | 94080.0 |
| 2004-09-10 08:55:00 | AAPL | Stock | 0.6375 | 0.6375 | 0.6375 | 0.6375 | 94080.0 |
| 2004-09-10 09:15:00 | AAPL | Stock | 0.6366 | 0.6368 | 0.6366 | 0.6368 | 75152.0 |
| 2004-09-10 09:25:00 | AAPL | Stock | 0.6357 | 0.638 | 0.6357 | 0.6368 | 604800.0 |
| 2004-09-10 09:30:00 | AAPL | Stock | 0.6372 | 0.647 | 0.6364 | 0.6468 | 9608928.0 |
| 2004-09-10 09:35:00 | AAPL | Stock | 0.6468 | 0.6468 | 0.6402 | 0.6407 | 12691784.0 |
| 2004-09-10 09:40:00 | AAPL | Stock | 0.6407 | 0.6429 | 0.6402 | 0.6421 | 6599264.0 |
| 2004-09-10 09:45:00 | AAPL | Stock | 0.6416 | 0.642 | 0.6402 | 0.6405 | 6290592.0 |
| 2004-09-10 09:50:00 | AAPL | Stock | 0.6405 | 0.645 | 0.6391 | 0.6432 | 9592296.0 |
| 2004-09-10 09:55:00 | AAPL | Stock | 0.6432 | 0.6446 | 0.6429 | 0.6429 | 5462800.0 |
| 2004-09-10 10:00:00 | AAPL | Stock | 0.643 | 0.6432 | 0.6411 | 0.6416 | 2602656.0 |
| 2004-09-10 10:05:00 | AAPL | Stock | 0.6416 | 0.6439 | 0.6411 | 0.6413 | 6731704.0 |
| 2004-09-10 10:10:00 | AAPL | Stock | 0.6413 | 0.6429 | 0.6411 | 0.6429 | 6241536.0 |
| 2004-09-10 10:15:00 | AAPL | Stock | 0.6429 | 0.6438 | 0.6425 | 0.6438 | 5714576.0 |
| 2004-09-10 10:20:00 | AAPL | Stock | 0.6438 | 0.6438 | 0.6414 | 0.6418 | 5525800.0 |
| 2004-09-10 10:25:00 | AAPL | Stock | 0.6418 | 0.6438 | 0.6418 | 0.6425 | 4610536.0 |
| 2004-09-10 10:30:00 | AAPL | Stock | 0.6425 | 0.6438 | 0.6425 | 0.6436 | 2005192.0 |
| 2004-09-10 10:35:00 | AAPL | Stock | 0.6434 | 0.6457 | 0.6434 | 0.6446 | 7627760.0 |
| 2004-09-10 10:40:00 | AAPL | Stock | 0.6445 | 0.6446 | 0.642 | 0.6427 | 3624544.0 |
| 2004-09-10 10:45:00 | AAPL | Stock | 0.6429 | 0.6438 | 0.6416 | 0.6418 | 4695320.0 |
| 2004-09-10 10:50:00 | AAPL | Stock | 0.6418 | 0.6427 | 0.6405 | 0.6418 | 3037216.0 |
| 2004-09-10 10:55:00 | AAPL | Stock | 0.642 | 0.642 | 0.6416 | 0.642 | 1892632.0 |
| 2004-09-10 11:00:00 | AAPL | Stock | 0.642 | 0.642 | 0.6409 | 0.6411 | 2973544.0 |
| 2004-09-10 11:05:00 | AAPL | Stock | 0.6411 | 0.6427 | 0.6411 | 0.6421 | 4424280.0 |
| 2004-09-10 11:10:00 | AAPL | Stock | 0.6423 | 0.6429 | 0.6416 | 0.6427 | 4383680.0 |
| 2004-09-10 11:15:00 | AAPL | Stock | 0.6427 | 0.643 | 0.6418 | 0.6421 | 4010328.0 |
| 2004-09-10 11:20:00 | AAPL | Stock | 0.642 | 0.642 | 0.6418 | 0.642 | 2657648.0 |
| 2004-09-10 11:25:00 | AAPL | Stock | 0.642 | 0.6423 | 0.6413 | 0.642 | 3659600.0 |
| 2004-09-10 11:30:00 | AAPL | Stock | 0.6418 | 0.6421 | 0.6418 | 0.6421 | 834120.0 |
| 2004-09-10 11:35:00 | AAPL | Stock | 0.6421 | 0.6425 | 0.642 | 0.6423 | 3375120.0 |
| 2004-09-10 11:40:00 | AAPL | Stock | 0.6423 | 0.6423 | 0.6418 | 0.642 | 1969968.0 |
| 2004-09-10 11:45:00 | AAPL | Stock | 0.6418 | 0.642 | 0.6413 | 0.6413 | 1426040.0 |
| 2004-09-10 11:50:00 | AAPL | Stock | 0.6411 | 0.6418 | 0.6407 | 0.6414 | 918288.0 |
| 2004-09-10 11:55:00 | AAPL | Stock | 0.6414 | 0.6414 | 0.6402 | 0.6411 | 2373336.0 |
| 2004-09-10 12:00:00 | AAPL | Stock | 0.6409 | 0.6411 | 0.6398 | 0.6399 | 2240280.0 |
| 2004-09-10 12:05:00 | AAPL | Stock | 0.64 | 0.6407 | 0.64 | 0.6407 | 994112.0 |
| 2004-09-10 12:10:00 | AAPL | Stock | 0.6407 | 0.6411 | 0.6393 | 0.6393 | 3104192.0 |
| 2004-09-10 12:15:00 | AAPL | Stock | 0.6393 | 0.6393 | 0.6382 | 0.6384 | 2201136.0 |
| 2004-09-10 12:20:00 | AAPL | Stock | 0.6382 | 0.6384 | 0.6371 | 0.6371 | 2139648.0 |
| 2004-09-10 12:25:00 | AAPL | Stock | 0.6371 | 0.6377 | 0.637 | 0.6371 | 2320920.0 |
| 2004-09-10 12:30:00 | AAPL | Stock | 0.6373 | 0.6373 | 0.6359 | 0.6361 | 3526992.0 |
| 2004-09-10 12:35:00 | AAPL | Stock | 0.6361 | 0.6373 | 0.6359 | 0.6373 | 2181704.0 |
| 2004-09-10 12:40:00 | AAPL | Stock | 0.6373 | 0.6384 | 0.6371 | 0.6384 | 1674848.0 |
| 2004-09-10 12:45:00 | AAPL | Stock | 0.6382 | 0.6393 | 0.638 | 0.638 | 3379880.0 |
| 2004-09-10 12:50:00 | AAPL | Stock | 0.6382 | 0.6386 | 0.638 | 0.6386 | 2063320.0 |
| 2004-09-10 12:55:00 | AAPL | Stock | 0.6386 | 0.6402 | 0.6386 | 0.6396 | 5747728.0 |
| 2004-09-10 13:00:00 | AAPL | Stock | 0.6397 | 0.6405 | 0.6396 | 0.6404 | 1875888.0 |
| 2004-09-10 13:05:00 | AAPL | Stock | 0.6404 | 0.6405 | 0.6398 | 0.6398 | 1177848.0 |
| 2004-09-10 13:10:00 | AAPL | Stock | 0.64 | 0.64 | 0.6361 | 0.6375 | 3830568.0 |
> showing 50 of 173,859 rows — these rows as CSV