PREVIEW / stock_5min / 2004-07-07
file: by_date/stock_5min/2004/2004-07-07.parquet size: 2.4 MB rows: 178,204 symbols: 1,796
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-07-07 08:55:00 | AAPL | Stock | 0.5529 | 0.5529 | 0.5529 | 0.5529 | 476000.0 |
| 2004-07-07 09:05:00 | AAPL | Stock | 0.5534 | 0.5534 | 0.5534 | 0.5534 | 134400.0 |
| 2004-07-07 09:10:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5527 | 0.5527 | 56000.0 |
| 2004-07-07 09:15:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5527 | 0.5527 | 4625600.0 |
| 2004-07-07 09:20:00 | AAPL | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 84000.0 |
| 2004-07-07 09:25:00 | AAPL | Stock | 0.5518 | 0.5534 | 0.5498 | 0.5532 | 323232.0 |
| 2004-07-07 09:30:00 | AAPL | Stock | 0.5502 | 0.5563 | 0.5496 | 0.5557 | 10255168.0 |
| 2004-07-07 09:35:00 | AAPL | Stock | 0.5555 | 0.56 | 0.5552 | 0.5584 | 7140168.0 |
| 2004-07-07 09:40:00 | AAPL | Stock | 0.5584 | 0.5593 | 0.5559 | 0.5568 | 8351280.0 |
| 2004-07-07 09:45:00 | AAPL | Stock | 0.5566 | 0.5584 | 0.5555 | 0.5555 | 4008032.0 |
| 2004-07-07 09:50:00 | AAPL | Stock | 0.5555 | 0.5573 | 0.5538 | 0.5538 | 5263104.0 |
| 2004-07-07 09:55:00 | AAPL | Stock | 0.5545 | 0.5573 | 0.5545 | 0.5563 | 4204536.0 |
| 2004-07-07 10:00:00 | AAPL | Stock | 0.5563 | 0.5586 | 0.5563 | 0.5573 | 3657808.0 |
| 2004-07-07 10:05:00 | AAPL | Stock | 0.5571 | 0.5577 | 0.5564 | 0.5577 | 2871008.0 |
| 2004-07-07 10:10:00 | AAPL | Stock | 0.5575 | 0.5577 | 0.557 | 0.5573 | 1281840.0 |
| 2004-07-07 10:15:00 | AAPL | Stock | 0.5571 | 0.5575 | 0.5561 | 0.5568 | 3452792.0 |
| 2004-07-07 10:20:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5559 | 0.5559 | 3824912.0 |
| 2004-07-07 10:25:00 | AAPL | Stock | 0.5561 | 0.5566 | 0.5552 | 0.5554 | 6511680.0 |
| 2004-07-07 10:30:00 | AAPL | Stock | 0.555 | 0.5552 | 0.5536 | 0.5539 | 4263504.0 |
| 2004-07-07 10:35:00 | AAPL | Stock | 0.5543 | 0.5545 | 0.5536 | 0.5545 | 7149744.0 |
| 2004-07-07 10:40:00 | AAPL | Stock | 0.5543 | 0.5548 | 0.5536 | 0.5539 | 1659336.0 |
| 2004-07-07 10:45:00 | AAPL | Stock | 0.5538 | 0.5538 | 0.5514 | 0.552 | 4110960.0 |
| 2004-07-07 10:50:00 | AAPL | Stock | 0.5516 | 0.5521 | 0.5482 | 0.5486 | 5765144.0 |
| 2004-07-07 10:55:00 | AAPL | Stock | 0.5484 | 0.5496 | 0.5484 | 0.5493 | 2872072.0 |
| 2004-07-07 11:00:00 | AAPL | Stock | 0.5493 | 0.5495 | 0.5479 | 0.5482 | 4403056.0 |
| 2004-07-07 11:05:00 | AAPL | Stock | 0.5486 | 0.5486 | 0.5482 | 0.5482 | 2712528.0 |
| 2004-07-07 11:10:00 | AAPL | Stock | 0.5482 | 0.5489 | 0.5464 | 0.5464 | 4876928.0 |
| 2004-07-07 11:15:00 | AAPL | Stock | 0.5463 | 0.5488 | 0.5452 | 0.5454 | 7972608.0 |
| 2004-07-07 11:20:00 | AAPL | Stock | 0.5455 | 0.5463 | 0.5454 | 0.5455 | 3345328.0 |
| 2004-07-07 11:25:00 | AAPL | Stock | 0.5457 | 0.5457 | 0.5429 | 0.5436 | 6669208.0 |
| 2004-07-07 11:30:00 | AAPL | Stock | 0.5438 | 0.5441 | 0.542 | 0.5427 | 9910880.0 |
| 2004-07-07 11:35:00 | AAPL | Stock | 0.5427 | 0.5432 | 0.542 | 0.5425 | 5482960.0 |
| 2004-07-07 11:40:00 | AAPL | Stock | 0.5425 | 0.5427 | 0.5411 | 0.5414 | 4321688.0 |
| 2004-07-07 11:45:00 | AAPL | Stock | 0.5413 | 0.5414 | 0.54 | 0.5402 | 17043152.0 |
| 2004-07-07 11:50:00 | AAPL | Stock | 0.5402 | 0.5414 | 0.5402 | 0.5405 | 5278560.0 |
| 2004-07-07 11:55:00 | AAPL | Stock | 0.5405 | 0.5416 | 0.5396 | 0.5414 | 16481696.0 |
| 2004-07-07 12:00:00 | AAPL | Stock | 0.5416 | 0.542 | 0.5407 | 0.5409 | 6210960.0 |
| 2004-07-07 12:05:00 | AAPL | Stock | 0.5409 | 0.5411 | 0.5404 | 0.5411 | 3490592.0 |
| 2004-07-07 12:10:00 | AAPL | Stock | 0.5411 | 0.5411 | 0.5404 | 0.5411 | 3867136.0 |
| 2004-07-07 12:15:00 | AAPL | Stock | 0.5411 | 0.5411 | 0.5402 | 0.5402 | 2770488.0 |
| 2004-07-07 12:20:00 | AAPL | Stock | 0.5402 | 0.5404 | 0.5398 | 0.5402 | 2879856.0 |
| 2004-07-07 12:25:00 | AAPL | Stock | 0.5398 | 0.5402 | 0.538 | 0.5386 | 7416752.0 |
| 2004-07-07 12:30:00 | AAPL | Stock | 0.5382 | 0.5391 | 0.538 | 0.5388 | 6019384.0 |
| 2004-07-07 12:35:00 | AAPL | Stock | 0.5388 | 0.5391 | 0.5384 | 0.5389 | 4612496.0 |
| 2004-07-07 12:40:00 | AAPL | Stock | 0.5389 | 0.5414 | 0.5389 | 0.5413 | 5370568.0 |
| 2004-07-07 12:45:00 | AAPL | Stock | 0.5416 | 0.5418 | 0.5407 | 0.5411 | 1727320.0 |
| 2004-07-07 12:50:00 | AAPL | Stock | 0.5411 | 0.5411 | 0.5402 | 0.5405 | 1226232.0 |
| 2004-07-07 12:55:00 | AAPL | Stock | 0.5404 | 0.5416 | 0.5404 | 0.5413 | 2653056.0 |
| 2004-07-07 13:00:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5405 | 0.5411 | 2515128.0 |
| 2004-07-07 13:05:00 | AAPL | Stock | 0.5411 | 0.5413 | 0.5409 | 0.5413 | 2109016.0 |
> showing 50 of 178,204 rows — these rows as CSV