PREVIEW / stock_5min / 2004-07-06
file: by_date/stock_5min/2004/2004-07-06.parquet size: 2.5 MB rows: 181,984 symbols: 1,795
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-06 08:00:00 | AAPL | Stock | 0.5532 | 0.5534 | 0.5509 | 0.5534 | 28000.0 |
| 2004-07-06 08:15:00 | AAPL | Stock | 0.5511 | 0.5511 | 0.5509 | 0.5509 | 65800.0 |
| 2004-07-06 08:20:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 11200.0 |
| 2004-07-06 08:50:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 11200.0 |
| 2004-07-06 08:55:00 | AAPL | Stock | 0.5529 | 0.5529 | 0.5529 | 0.5529 | 84000.0 |
| 2004-07-06 09:00:00 | AAPL | Stock | 0.552 | 0.552 | 0.5518 | 0.5518 | 168000.0 |
| 2004-07-06 09:10:00 | AAPL | Stock | 0.5527 | 0.5547 | 0.5509 | 0.5509 | 352800.0 |
| 2004-07-06 09:20:00 | AAPL | Stock | 0.5518 | 0.5518 | 0.5518 | 0.5518 | 128800.0 |
| 2004-07-06 09:25:00 | AAPL | Stock | 0.5527 | 0.5579 | 0.5518 | 0.5571 | 1769320.0 |
| 2004-07-06 09:30:00 | AAPL | Stock | 0.5554 | 0.5588 | 0.5523 | 0.5561 | 14711592.0 |
| 2004-07-06 09:35:00 | AAPL | Stock | 0.5561 | 0.5564 | 0.5543 | 0.5548 | 5423712.0 |
| 2004-07-06 09:40:00 | AAPL | Stock | 0.5548 | 0.5551 | 0.5529 | 0.5539 | 6018096.0 |
| 2004-07-06 09:45:00 | AAPL | Stock | 0.5536 | 0.5545 | 0.5521 | 0.5538 | 3816568.0 |
| 2004-07-06 09:50:00 | AAPL | Stock | 0.5538 | 0.5559 | 0.5536 | 0.5552 | 6034840.0 |
| 2004-07-06 09:55:00 | AAPL | Stock | 0.555 | 0.5571 | 0.5548 | 0.557 | 7127568.0 |
| 2004-07-06 10:00:00 | AAPL | Stock | 0.5571 | 0.5573 | 0.5557 | 0.5573 | 7217896.0 |
| 2004-07-06 10:05:00 | AAPL | Stock | 0.5573 | 0.5577 | 0.5554 | 0.5573 | 3264576.0 |
| 2004-07-06 10:10:00 | AAPL | Stock | 0.5575 | 0.5588 | 0.5568 | 0.558 | 6875512.0 |
| 2004-07-06 10:15:00 | AAPL | Stock | 0.558 | 0.56 | 0.5571 | 0.5589 | 5759600.0 |
| 2004-07-06 10:20:00 | AAPL | Stock | 0.5598 | 0.5607 | 0.558 | 0.5602 | 6093304.0 |
| 2004-07-06 10:25:00 | AAPL | Stock | 0.5602 | 0.5611 | 0.5595 | 0.5602 | 4646656.0 |
| 2004-07-06 10:30:00 | AAPL | Stock | 0.5604 | 0.5604 | 0.5596 | 0.5598 | 4042584.0 |
| 2004-07-06 10:35:00 | AAPL | Stock | 0.5598 | 0.5607 | 0.5595 | 0.56 | 7084784.0 |
| 2004-07-06 10:40:00 | AAPL | Stock | 0.5598 | 0.5602 | 0.5596 | 0.56 | 3613064.0 |
| 2004-07-06 10:45:00 | AAPL | Stock | 0.5598 | 0.5602 | 0.5593 | 0.5593 | 4034688.0 |
| 2004-07-06 10:50:00 | AAPL | Stock | 0.5595 | 0.5596 | 0.558 | 0.5582 | 7296128.0 |
| 2004-07-06 10:55:00 | AAPL | Stock | 0.5586 | 0.5588 | 0.5563 | 0.5564 | 4739168.0 |
| 2004-07-06 11:00:00 | AAPL | Stock | 0.5564 | 0.5577 | 0.5563 | 0.5566 | 6386352.0 |
| 2004-07-06 11:05:00 | AAPL | Stock | 0.5566 | 0.5566 | 0.5536 | 0.5541 | 9125872.0 |
| 2004-07-06 11:10:00 | AAPL | Stock | 0.5538 | 0.5563 | 0.5536 | 0.5563 | 7095312.0 |
| 2004-07-06 11:15:00 | AAPL | Stock | 0.5563 | 0.557 | 0.5555 | 0.5563 | 3107888.0 |
| 2004-07-06 11:20:00 | AAPL | Stock | 0.5563 | 0.5586 | 0.5561 | 0.5579 | 4723208.0 |
| 2004-07-06 11:25:00 | AAPL | Stock | 0.5579 | 0.5584 | 0.5577 | 0.558 | 2799104.0 |
| 2004-07-06 11:30:00 | AAPL | Stock | 0.5582 | 0.5589 | 0.5582 | 0.5584 | 2634072.0 |
| 2004-07-06 11:35:00 | AAPL | Stock | 0.5584 | 0.5584 | 0.5573 | 0.5575 | 2346736.0 |
| 2004-07-06 11:40:00 | AAPL | Stock | 0.5575 | 0.5584 | 0.5571 | 0.5573 | 2902592.0 |
| 2004-07-06 11:45:00 | AAPL | Stock | 0.5573 | 0.5575 | 0.5568 | 0.557 | 2556288.0 |
| 2004-07-06 11:50:00 | AAPL | Stock | 0.5568 | 0.5568 | 0.5543 | 0.5543 | 4489408.0 |
| 2004-07-06 11:55:00 | AAPL | Stock | 0.5546 | 0.5566 | 0.5543 | 0.5561 | 3801952.0 |
| 2004-07-06 12:00:00 | AAPL | Stock | 0.5561 | 0.5566 | 0.5552 | 0.5564 | 2854488.0 |
| 2004-07-06 12:05:00 | AAPL | Stock | 0.5564 | 0.5564 | 0.5552 | 0.5554 | 2407384.0 |
| 2004-07-06 12:10:00 | AAPL | Stock | 0.5552 | 0.5566 | 0.5548 | 0.5557 | 2476208.0 |
| 2004-07-06 12:15:00 | AAPL | Stock | 0.5557 | 0.5557 | 0.555 | 0.555 | 2602208.0 |
| 2004-07-06 12:20:00 | AAPL | Stock | 0.555 | 0.5566 | 0.555 | 0.5566 | 2178176.0 |
| 2004-07-06 12:25:00 | AAPL | Stock | 0.5566 | 0.5566 | 0.5555 | 0.5555 | 1849456.0 |
| 2004-07-06 12:30:00 | AAPL | Stock | 0.5555 | 0.5557 | 0.5552 | 0.5552 | 1507520.0 |
| 2004-07-06 12:35:00 | AAPL | Stock | 0.5552 | 0.5566 | 0.5552 | 0.5566 | 2223256.0 |
| 2004-07-06 12:40:00 | AAPL | Stock | 0.5566 | 0.5566 | 0.5561 | 0.5561 | 1433320.0 |
| 2004-07-06 12:45:00 | AAPL | Stock | 0.5559 | 0.5561 | 0.5546 | 0.5546 | 1345792.0 |
| 2004-07-06 12:50:00 | AAPL | Stock | 0.5546 | 0.5555 | 0.5545 | 0.5552 | 1255520.0 |
> showing 50 of 181,984 rows — these rows as CSV