PREVIEW / stock_5min / 2004-08-13
file: by_date/stock_5min/2004/2004-08-13.parquet size: 2.3 MB rows: 166,566 symbols: 1,820
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-13 08:15:00 | AAPL | Stock | 0.5491 | 0.5491 | 0.5491 | 0.5491 | 11200.0 |
| 2004-08-13 08:25:00 | AAPL | Stock | 0.5491 | 0.5491 | 0.5491 | 0.5491 | 16800.0 |
| 2004-08-13 08:30:00 | AAPL | Stock | 0.5491 | 0.5491 | 0.5491 | 0.5491 | 11200.0 |
| 2004-08-13 08:40:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5482 | 0.5482 | 28000.0 |
| 2004-08-13 09:20:00 | AAPL | Stock | 0.5475 | 0.5475 | 0.5475 | 0.5475 | 33600.0 |
| 2004-08-13 09:25:00 | AAPL | Stock | 0.5475 | 0.5484 | 0.5455 | 0.5464 | 336000.0 |
| 2004-08-13 09:30:00 | AAPL | Stock | 0.5475 | 0.5513 | 0.5464 | 0.5505 | 5692792.0 |
| 2004-08-13 09:35:00 | AAPL | Stock | 0.5509 | 0.5532 | 0.55 | 0.5532 | 6214264.0 |
| 2004-08-13 09:40:00 | AAPL | Stock | 0.5532 | 0.5534 | 0.5523 | 0.5534 | 2532040.0 |
| 2004-08-13 09:45:00 | AAPL | Stock | 0.5534 | 0.5541 | 0.5525 | 0.5525 | 5034512.0 |
| 2004-08-13 09:50:00 | AAPL | Stock | 0.5527 | 0.5568 | 0.5527 | 0.5568 | 5057976.0 |
| 2004-08-13 09:55:00 | AAPL | Stock | 0.557 | 0.5586 | 0.5559 | 0.5563 | 4879392.0 |
| 2004-08-13 10:00:00 | AAPL | Stock | 0.5563 | 0.5568 | 0.5534 | 0.5538 | 3344544.0 |
| 2004-08-13 10:05:00 | AAPL | Stock | 0.5538 | 0.5546 | 0.553 | 0.5534 | 5227208.0 |
| 2004-08-13 10:10:00 | AAPL | Stock | 0.5534 | 0.5536 | 0.5525 | 0.5527 | 2292696.0 |
| 2004-08-13 10:15:00 | AAPL | Stock | 0.5527 | 0.5541 | 0.5527 | 0.5539 | 3803464.0 |
| 2004-08-13 10:20:00 | AAPL | Stock | 0.5538 | 0.5541 | 0.553 | 0.5539 | 3201688.0 |
| 2004-08-13 10:25:00 | AAPL | Stock | 0.5539 | 0.5559 | 0.5538 | 0.5554 | 4636800.0 |
| 2004-08-13 10:30:00 | AAPL | Stock | 0.5554 | 0.5563 | 0.5548 | 0.5548 | 1503376.0 |
| 2004-08-13 10:35:00 | AAPL | Stock | 0.5548 | 0.5554 | 0.5548 | 0.5552 | 916552.0 |
| 2004-08-13 10:40:00 | AAPL | Stock | 0.5552 | 0.5563 | 0.5552 | 0.5561 | 2134440.0 |
| 2004-08-13 10:45:00 | AAPL | Stock | 0.5563 | 0.557 | 0.5555 | 0.5555 | 1828064.0 |
| 2004-08-13 10:50:00 | AAPL | Stock | 0.5557 | 0.5561 | 0.5548 | 0.555 | 1236088.0 |
| 2004-08-13 10:55:00 | AAPL | Stock | 0.555 | 0.5573 | 0.555 | 0.5564 | 2406992.0 |
| 2004-08-13 11:00:00 | AAPL | Stock | 0.5566 | 0.5571 | 0.5564 | 0.5571 | 2000208.0 |
| 2004-08-13 11:05:00 | AAPL | Stock | 0.5571 | 0.5577 | 0.557 | 0.5575 | 5566344.0 |
| 2004-08-13 11:10:00 | AAPL | Stock | 0.5575 | 0.5575 | 0.5566 | 0.5568 | 1573824.0 |
| 2004-08-13 11:15:00 | AAPL | Stock | 0.5568 | 0.557 | 0.5568 | 0.557 | 1158808.0 |
| 2004-08-13 11:20:00 | AAPL | Stock | 0.557 | 0.557 | 0.5568 | 0.557 | 868000.0 |
| 2004-08-13 11:25:00 | AAPL | Stock | 0.5568 | 0.5568 | 0.5559 | 0.5561 | 1597568.0 |
| 2004-08-13 11:30:00 | AAPL | Stock | 0.5561 | 0.5563 | 0.5557 | 0.5559 | 1328936.0 |
| 2004-08-13 11:35:00 | AAPL | Stock | 0.5557 | 0.5561 | 0.5552 | 0.5557 | 4230688.0 |
| 2004-08-13 11:40:00 | AAPL | Stock | 0.5555 | 0.5555 | 0.553 | 0.5532 | 5274360.0 |
| 2004-08-13 11:45:00 | AAPL | Stock | 0.5532 | 0.5536 | 0.5525 | 0.5527 | 3497928.0 |
| 2004-08-13 11:50:00 | AAPL | Stock | 0.5527 | 0.5536 | 0.5525 | 0.5534 | 3888752.0 |
| 2004-08-13 11:55:00 | AAPL | Stock | 0.5534 | 0.5536 | 0.553 | 0.5532 | 3153528.0 |
| 2004-08-13 12:00:00 | AAPL | Stock | 0.5532 | 0.5534 | 0.5525 | 0.5525 | 2809296.0 |
| 2004-08-13 12:05:00 | AAPL | Stock | 0.5525 | 0.5536 | 0.5525 | 0.5527 | 3231312.0 |
| 2004-08-13 12:10:00 | AAPL | Stock | 0.5527 | 0.553 | 0.5493 | 0.5496 | 4082344.0 |
| 2004-08-13 12:15:00 | AAPL | Stock | 0.5498 | 0.5509 | 0.5496 | 0.55 | 2708440.0 |
| 2004-08-13 12:20:00 | AAPL | Stock | 0.55 | 0.5513 | 0.5489 | 0.5491 | 4563440.0 |
| 2004-08-13 12:25:00 | AAPL | Stock | 0.5491 | 0.5493 | 0.5466 | 0.547 | 5794544.0 |
| 2004-08-13 12:30:00 | AAPL | Stock | 0.5473 | 0.5475 | 0.5452 | 0.5471 | 9550128.0 |
| 2004-08-13 12:35:00 | AAPL | Stock | 0.547 | 0.5473 | 0.547 | 0.547 | 3025064.0 |
| 2004-08-13 12:40:00 | AAPL | Stock | 0.547 | 0.5471 | 0.5446 | 0.5457 | 3689168.0 |
| 2004-08-13 12:45:00 | AAPL | Stock | 0.5457 | 0.5464 | 0.5455 | 0.5463 | 2002840.0 |
| 2004-08-13 12:50:00 | AAPL | Stock | 0.5464 | 0.5477 | 0.5464 | 0.547 | 1817816.0 |
| 2004-08-13 12:55:00 | AAPL | Stock | 0.547 | 0.547 | 0.5463 | 0.5463 | 1126664.0 |
| 2004-08-13 13:00:00 | AAPL | Stock | 0.5463 | 0.5464 | 0.5463 | 0.5463 | 877744.0 |
| 2004-08-13 13:05:00 | AAPL | Stock | 0.5463 | 0.5466 | 0.5463 | 0.5466 | 4266248.0 |
> showing 50 of 166,566 rows — these rows as CSV