PREVIEW / stock_5min / 2005-12-20
file: by_date/stock_5min/2005/2005-12-20.parquet size: 2.9 MB rows: 210,835 symbols: 2,152
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-20 07:45:00 | AAPL | Stock | 2.5621 | 2.5625 | 2.5621 | 2.5625 | 36400.0 |
| 2005-12-20 08:00:00 | AAPL | Stock | 2.5625 | 2.5639 | 2.5625 | 2.5625 | 202076.0 |
| 2005-12-20 08:05:00 | AAPL | Stock | 2.5611 | 2.5611 | 2.5557 | 2.56 | 18900.0 |
| 2005-12-20 08:10:00 | AAPL | Stock | 2.5561 | 2.5561 | 2.5561 | 2.5561 | 8680.0 |
| 2005-12-20 08:15:00 | AAPL | Stock | 2.5571 | 2.5589 | 2.5564 | 2.5582 | 68600.0 |
| 2005-12-20 08:20:00 | AAPL | Stock | 2.5582 | 2.5596 | 2.5564 | 2.5596 | 56700.0 |
| 2005-12-20 08:25:00 | AAPL | Stock | 2.5596 | 2.5596 | 2.5596 | 2.5596 | 16212.0 |
| 2005-12-20 08:30:00 | AAPL | Stock | 2.5625 | 2.5643 | 2.5607 | 2.5607 | 447020.0 |
| 2005-12-20 08:35:00 | AAPL | Stock | 2.5625 | 2.5643 | 2.5625 | 2.5643 | 54600.0 |
| 2005-12-20 08:40:00 | AAPL | Stock | 2.5618 | 2.5618 | 2.5568 | 2.5586 | 297080.0 |
| 2005-12-20 08:45:00 | AAPL | Stock | 2.56 | 2.56 | 2.5579 | 2.5586 | 98000.0 |
| 2005-12-20 08:50:00 | AAPL | Stock | 2.5607 | 2.5607 | 2.56 | 2.56 | 16800.0 |
| 2005-12-20 08:55:00 | AAPL | Stock | 2.5596 | 2.56 | 2.5571 | 2.5579 | 128772.0 |
| 2005-12-20 09:00:00 | AAPL | Stock | 2.5589 | 2.5589 | 2.5564 | 2.5575 | 56056.0 |
| 2005-12-20 09:05:00 | AAPL | Stock | 2.5589 | 2.5607 | 2.5589 | 2.5607 | 162400.0 |
| 2005-12-20 09:10:00 | AAPL | Stock | 2.5607 | 2.5639 | 2.5607 | 2.5625 | 193816.0 |
| 2005-12-20 09:15:00 | AAPL | Stock | 2.5636 | 2.5636 | 2.5607 | 2.5607 | 59360.0 |
| 2005-12-20 09:20:00 | AAPL | Stock | 2.5629 | 2.5639 | 2.5607 | 2.5607 | 122276.0 |
| 2005-12-20 09:25:00 | AAPL | Stock | 2.56 | 2.5604 | 2.5564 | 2.5564 | 734944.0 |
| 2005-12-20 09:30:00 | AAPL | Stock | 2.558 | 2.5671 | 2.5561 | 2.5611 | 15803452.0 |
| 2005-12-20 09:35:00 | AAPL | Stock | 2.5611 | 2.5707 | 2.56 | 2.5632 | 10050544.0 |
| 2005-12-20 09:40:00 | AAPL | Stock | 2.5632 | 2.5636 | 2.5421 | 2.5486 | 13323716.0 |
| 2005-12-20 09:45:00 | AAPL | Stock | 2.5493 | 2.5571 | 2.5471 | 2.5571 | 9416848.0 |
| 2005-12-20 09:50:00 | AAPL | Stock | 2.5568 | 2.56 | 2.5425 | 2.5461 | 10133032.0 |
| 2005-12-20 09:55:00 | AAPL | Stock | 2.5429 | 2.5521 | 2.5429 | 2.5461 | 7793100.0 |
| 2005-12-20 10:00:00 | AAPL | Stock | 2.5464 | 2.5514 | 2.54 | 2.5496 | 9594060.0 |
| 2005-12-20 10:05:00 | AAPL | Stock | 2.5496 | 2.5554 | 2.5464 | 2.5546 | 7220612.0 |
| 2005-12-20 10:10:00 | AAPL | Stock | 2.555 | 2.5554 | 2.545 | 2.5511 | 5076792.0 |
| 2005-12-20 10:15:00 | AAPL | Stock | 2.5511 | 2.5579 | 2.5489 | 2.5568 | 7648564.0 |
| 2005-12-20 10:20:00 | AAPL | Stock | 2.5568 | 2.5625 | 2.5532 | 2.5607 | 7442372.0 |
| 2005-12-20 10:25:00 | AAPL | Stock | 2.5607 | 2.5611 | 2.5543 | 2.5582 | 10092740.0 |
| 2005-12-20 10:30:00 | AAPL | Stock | 2.5582 | 2.5679 | 2.5582 | 2.5675 | 10150672.0 |
| 2005-12-20 10:35:00 | AAPL | Stock | 2.5677 | 2.5754 | 2.5661 | 2.5686 | 14600292.0 |
| 2005-12-20 10:40:00 | AAPL | Stock | 2.5693 | 2.5704 | 2.5611 | 2.5636 | 6295212.0 |
| 2005-12-20 10:45:00 | AAPL | Stock | 2.5636 | 2.5679 | 2.5618 | 2.5636 | 4062436.0 |
| 2005-12-20 10:50:00 | AAPL | Stock | 2.5636 | 2.5671 | 2.5611 | 2.5671 | 3422888.0 |
| 2005-12-20 10:55:00 | AAPL | Stock | 2.5668 | 2.5714 | 2.5657 | 2.57 | 5714044.0 |
| 2005-12-20 11:00:00 | AAPL | Stock | 2.57 | 2.5714 | 2.5671 | 2.5682 | 4515336.0 |
| 2005-12-20 11:05:00 | AAPL | Stock | 2.5686 | 2.5686 | 2.565 | 2.5664 | 3130876.0 |
| 2005-12-20 11:10:00 | AAPL | Stock | 2.5664 | 2.5775 | 2.5664 | 2.5679 | 3499888.0 |
| 2005-12-20 11:15:00 | AAPL | Stock | 2.5679 | 2.5693 | 2.565 | 2.565 | 3595060.0 |
| 2005-12-20 11:20:00 | AAPL | Stock | 2.5646 | 2.5679 | 2.5632 | 2.5675 | 3956176.0 |
| 2005-12-20 11:25:00 | AAPL | Stock | 2.5679 | 2.5689 | 2.5657 | 2.5664 | 1921220.0 |
| 2005-12-20 11:30:00 | AAPL | Stock | 2.5664 | 2.5704 | 2.5657 | 2.5671 | 3689924.0 |
| 2005-12-20 11:35:00 | AAPL | Stock | 2.5671 | 2.575 | 2.5671 | 2.5732 | 7510916.0 |
| 2005-12-20 11:40:00 | AAPL | Stock | 2.5732 | 2.5746 | 2.5675 | 2.5711 | 5225332.0 |
| 2005-12-20 11:45:00 | AAPL | Stock | 2.5714 | 2.5721 | 2.565 | 2.5657 | 3231368.0 |
| 2005-12-20 11:50:00 | AAPL | Stock | 2.5657 | 2.5689 | 2.5657 | 2.5668 | 3864924.0 |
| 2005-12-20 11:55:00 | AAPL | Stock | 2.5668 | 2.5671 | 2.5614 | 2.5639 | 7854028.0 |
| 2005-12-20 12:00:00 | AAPL | Stock | 2.5643 | 2.5739 | 2.5636 | 2.5736 | 6701212.0 |
> showing 50 of 210,835 rows — these rows as CSV