PREVIEW / stock_5min / 2004-08-11
file: by_date/stock_5min/2004/2004-08-11.parquet size: 2.4 MB rows: 175,885 symbols: 1,821
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-08-11 08:25:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 5600.0 |
| 2004-08-11 08:45:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.5536 | 0.5536 | 5600.0 |
| 2004-08-11 09:00:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.5536 | 0.5536 | 56000.0 |
| 2004-08-11 09:05:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.5536 | 0.5536 | 56000.0 |
| 2004-08-11 09:25:00 | AAPL | Stock | 0.5538 | 0.5554 | 0.5536 | 0.5554 | 91112.0 |
| 2004-08-11 09:30:00 | AAPL | Stock | 0.5554 | 0.5559 | 0.5525 | 0.5545 | 7938504.0 |
| 2004-08-11 09:35:00 | AAPL | Stock | 0.5543 | 0.5554 | 0.5511 | 0.5513 | 14911624.0 |
| 2004-08-11 09:40:00 | AAPL | Stock | 0.5513 | 0.5518 | 0.5502 | 0.5502 | 5941656.0 |
| 2004-08-11 09:45:00 | AAPL | Stock | 0.5502 | 0.5509 | 0.5493 | 0.5495 | 4769240.0 |
| 2004-08-11 09:50:00 | AAPL | Stock | 0.5493 | 0.55 | 0.5454 | 0.5454 | 7133392.0 |
| 2004-08-11 09:55:00 | AAPL | Stock | 0.5455 | 0.5466 | 0.545 | 0.5457 | 5419456.0 |
| 2004-08-11 10:00:00 | AAPL | Stock | 0.5459 | 0.5461 | 0.5441 | 0.5443 | 7693224.0 |
| 2004-08-11 10:05:00 | AAPL | Stock | 0.5443 | 0.5445 | 0.5427 | 0.5429 | 5168856.0 |
| 2004-08-11 10:10:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5413 | 0.5427 | 5718048.0 |
| 2004-08-11 10:15:00 | AAPL | Stock | 0.5427 | 0.545 | 0.5425 | 0.5445 | 7860664.0 |
| 2004-08-11 10:20:00 | AAPL | Stock | 0.5445 | 0.5466 | 0.5443 | 0.5463 | 5768280.0 |
| 2004-08-11 10:25:00 | AAPL | Stock | 0.5463 | 0.5482 | 0.5463 | 0.5464 | 4643800.0 |
| 2004-08-11 10:30:00 | AAPL | Stock | 0.5464 | 0.5466 | 0.5454 | 0.5454 | 3689392.0 |
| 2004-08-11 10:35:00 | AAPL | Stock | 0.5455 | 0.5466 | 0.545 | 0.5452 | 3021704.0 |
| 2004-08-11 10:40:00 | AAPL | Stock | 0.5452 | 0.5454 | 0.5439 | 0.5448 | 5272400.0 |
| 2004-08-11 10:45:00 | AAPL | Stock | 0.5446 | 0.5459 | 0.5443 | 0.5459 | 2147600.0 |
| 2004-08-11 10:50:00 | AAPL | Stock | 0.5459 | 0.5488 | 0.5459 | 0.5486 | 3747352.0 |
| 2004-08-11 10:55:00 | AAPL | Stock | 0.5488 | 0.5504 | 0.5484 | 0.5491 | 5799248.0 |
| 2004-08-11 11:00:00 | AAPL | Stock | 0.5491 | 0.5504 | 0.5482 | 0.5482 | 4896920.0 |
| 2004-08-11 11:05:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5446 | 0.5446 | 3616760.0 |
| 2004-08-11 11:10:00 | AAPL | Stock | 0.5446 | 0.5455 | 0.5441 | 0.5448 | 3254272.0 |
| 2004-08-11 11:15:00 | AAPL | Stock | 0.5446 | 0.547 | 0.5446 | 0.545 | 4308584.0 |
| 2004-08-11 11:20:00 | AAPL | Stock | 0.545 | 0.5454 | 0.5438 | 0.5438 | 2395904.0 |
| 2004-08-11 11:25:00 | AAPL | Stock | 0.5438 | 0.5441 | 0.5427 | 0.5434 | 1717968.0 |
| 2004-08-11 11:30:00 | AAPL | Stock | 0.5436 | 0.5446 | 0.5427 | 0.5441 | 1894088.0 |
| 2004-08-11 11:35:00 | AAPL | Stock | 0.5439 | 0.545 | 0.5438 | 0.5446 | 1094184.0 |
| 2004-08-11 11:40:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5432 | 0.5432 | 504000.0 |
| 2004-08-11 11:45:00 | AAPL | Stock | 0.5432 | 0.5445 | 0.5432 | 0.5434 | 1443848.0 |
| 2004-08-11 11:50:00 | AAPL | Stock | 0.5438 | 0.5443 | 0.542 | 0.5425 | 1720432.0 |
| 2004-08-11 11:55:00 | AAPL | Stock | 0.5421 | 0.5432 | 0.5411 | 0.5432 | 2780120.0 |
| 2004-08-11 12:00:00 | AAPL | Stock | 0.5432 | 0.5434 | 0.543 | 0.5432 | 3101336.0 |
| 2004-08-11 12:05:00 | AAPL | Stock | 0.5436 | 0.5438 | 0.5413 | 0.542 | 2947000.0 |
| 2004-08-11 12:10:00 | AAPL | Stock | 0.542 | 0.5425 | 0.5416 | 0.542 | 1339632.0 |
| 2004-08-11 12:15:00 | AAPL | Stock | 0.542 | 0.5425 | 0.5418 | 0.5423 | 901992.0 |
| 2004-08-11 12:20:00 | AAPL | Stock | 0.5423 | 0.5423 | 0.5404 | 0.5421 | 2885568.0 |
| 2004-08-11 12:25:00 | AAPL | Stock | 0.5423 | 0.5429 | 0.5414 | 0.5427 | 721896.0 |
| 2004-08-11 12:30:00 | AAPL | Stock | 0.5429 | 0.5434 | 0.5425 | 0.5427 | 2130464.0 |
| 2004-08-11 12:35:00 | AAPL | Stock | 0.5427 | 0.5432 | 0.5425 | 0.5431 | 631512.0 |
| 2004-08-11 12:40:00 | AAPL | Stock | 0.5432 | 0.5434 | 0.5427 | 0.543 | 840056.0 |
| 2004-08-11 12:45:00 | AAPL | Stock | 0.543 | 0.545 | 0.5429 | 0.5448 | 2364936.0 |
| 2004-08-11 12:50:00 | AAPL | Stock | 0.5448 | 0.5463 | 0.5446 | 0.5459 | 2604896.0 |
| 2004-08-11 12:55:00 | AAPL | Stock | 0.5459 | 0.5464 | 0.5459 | 0.5459 | 1316168.0 |
| 2004-08-11 13:00:00 | AAPL | Stock | 0.5459 | 0.5468 | 0.5459 | 0.5463 | 4968320.0 |
| 2004-08-11 13:05:00 | AAPL | Stock | 0.547 | 0.5489 | 0.547 | 0.5479 | 5911472.0 |
| 2004-08-11 13:10:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5468 | 0.5475 | 2523640.0 |
> showing 50 of 175,885 rows — these rows as CSV