PREVIEW / stock_5min / 2004-05-20
file: by_date/stock_5min/2004/2004-05-20.parquet size: 2.4 MB rows: 174,887 symbols: 1,765
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-05-20 08:20:00 | AAPL | Stock | 0.4682 | 0.4682 | 0.4682 | 0.4682 | 28000.0 |
| 2004-05-20 08:25:00 | AAPL | Stock | 0.4723 | 0.4723 | 0.4723 | 0.4723 | 5600.0 |
| 2004-05-20 08:40:00 | AAPL | Stock | 0.4711 | 0.4713 | 0.4711 | 0.4713 | 53200.0 |
| 2004-05-20 08:45:00 | AAPL | Stock | 0.4713 | 0.4713 | 0.4713 | 0.4713 | 16800.0 |
| 2004-05-20 08:50:00 | AAPL | Stock | 0.4714 | 0.4714 | 0.4714 | 0.4714 | 112000.0 |
| 2004-05-20 09:00:00 | AAPL | Stock | 0.4713 | 0.4727 | 0.4713 | 0.4714 | 141400.0 |
| 2004-05-20 09:20:00 | AAPL | Stock | 0.4732 | 0.4732 | 0.4732 | 0.4732 | 378392.0 |
| 2004-05-20 09:25:00 | AAPL | Stock | 0.4732 | 0.4757 | 0.4732 | 0.4757 | 940800.0 |
| 2004-05-20 09:30:00 | AAPL | Stock | 0.4755 | 0.4768 | 0.4727 | 0.4741 | 10253432.0 |
| 2004-05-20 09:35:00 | AAPL | Stock | 0.4743 | 0.4786 | 0.4734 | 0.4786 | 10303720.0 |
| 2004-05-20 09:40:00 | AAPL | Stock | 0.4786 | 0.4786 | 0.4755 | 0.4779 | 6015128.0 |
| 2004-05-20 09:45:00 | AAPL | Stock | 0.4779 | 0.4795 | 0.4779 | 0.4789 | 3027584.0 |
| 2004-05-20 09:50:00 | AAPL | Stock | 0.4789 | 0.4821 | 0.4788 | 0.482 | 8083320.0 |
| 2004-05-20 09:55:00 | AAPL | Stock | 0.4817 | 0.4821 | 0.4804 | 0.4813 | 2997848.0 |
| 2004-05-20 10:00:00 | AAPL | Stock | 0.4813 | 0.4814 | 0.48 | 0.4804 | 4294360.0 |
| 2004-05-20 10:05:00 | AAPL | Stock | 0.4802 | 0.4804 | 0.477 | 0.4786 | 5541648.0 |
| 2004-05-20 10:10:00 | AAPL | Stock | 0.4788 | 0.4795 | 0.4777 | 0.4779 | 1881824.0 |
| 2004-05-20 10:15:00 | AAPL | Stock | 0.4779 | 0.4786 | 0.4773 | 0.4775 | 5543216.0 |
| 2004-05-20 10:20:00 | AAPL | Stock | 0.4775 | 0.4777 | 0.4761 | 0.4766 | 3033296.0 |
| 2004-05-20 10:25:00 | AAPL | Stock | 0.4768 | 0.4773 | 0.4764 | 0.4773 | 2921968.0 |
| 2004-05-20 10:30:00 | AAPL | Stock | 0.4773 | 0.4779 | 0.477 | 0.477 | 3059504.0 |
| 2004-05-20 10:35:00 | AAPL | Stock | 0.4771 | 0.4773 | 0.4761 | 0.4761 | 1698648.0 |
| 2004-05-20 10:40:00 | AAPL | Stock | 0.4761 | 0.4786 | 0.4757 | 0.4786 | 1672944.0 |
| 2004-05-20 10:45:00 | AAPL | Stock | 0.4784 | 0.4795 | 0.4782 | 0.4793 | 1793792.0 |
| 2004-05-20 10:50:00 | AAPL | Stock | 0.4793 | 0.4804 | 0.4793 | 0.4798 | 2244704.0 |
| 2004-05-20 10:55:00 | AAPL | Stock | 0.4796 | 0.4798 | 0.4793 | 0.4795 | 890960.0 |
| 2004-05-20 11:00:00 | AAPL | Stock | 0.4795 | 0.4804 | 0.4795 | 0.48 | 833560.0 |
| 2004-05-20 11:05:00 | AAPL | Stock | 0.4802 | 0.4802 | 0.4795 | 0.4796 | 2207968.0 |
| 2004-05-20 11:10:00 | AAPL | Stock | 0.4795 | 0.48 | 0.4782 | 0.4788 | 2986144.0 |
| 2004-05-20 11:15:00 | AAPL | Stock | 0.4784 | 0.4802 | 0.4784 | 0.4802 | 2491272.0 |
| 2004-05-20 11:20:00 | AAPL | Stock | 0.4802 | 0.4802 | 0.4793 | 0.4795 | 883624.0 |
| 2004-05-20 11:25:00 | AAPL | Stock | 0.4795 | 0.4795 | 0.4791 | 0.4791 | 565600.0 |
| 2004-05-20 11:30:00 | AAPL | Stock | 0.4791 | 0.4791 | 0.478 | 0.4789 | 1820504.0 |
| 2004-05-20 11:35:00 | AAPL | Stock | 0.4789 | 0.4791 | 0.4779 | 0.4782 | 1611736.0 |
| 2004-05-20 11:40:00 | AAPL | Stock | 0.4784 | 0.4784 | 0.478 | 0.478 | 140000.0 |
| 2004-05-20 11:45:00 | AAPL | Stock | 0.4782 | 0.4784 | 0.478 | 0.478 | 520800.0 |
| 2004-05-20 11:50:00 | AAPL | Stock | 0.478 | 0.4786 | 0.4779 | 0.478 | 1017688.0 |
| 2004-05-20 11:55:00 | AAPL | Stock | 0.4782 | 0.4782 | 0.4773 | 0.4773 | 1627248.0 |
| 2004-05-20 12:00:00 | AAPL | Stock | 0.4771 | 0.4773 | 0.4754 | 0.4757 | 2342256.0 |
| 2004-05-20 12:05:00 | AAPL | Stock | 0.4755 | 0.4759 | 0.4748 | 0.4757 | 2311680.0 |
| 2004-05-20 12:10:00 | AAPL | Stock | 0.4757 | 0.4768 | 0.4757 | 0.4764 | 2358048.0 |
| 2004-05-20 12:15:00 | AAPL | Stock | 0.4763 | 0.478 | 0.4759 | 0.4777 | 3384640.0 |
| 2004-05-20 12:20:00 | AAPL | Stock | 0.4777 | 0.4782 | 0.4761 | 0.4761 | 2194416.0 |
| 2004-05-20 12:25:00 | AAPL | Stock | 0.4761 | 0.4764 | 0.4748 | 0.4752 | 1414616.0 |
| 2004-05-20 12:30:00 | AAPL | Stock | 0.4752 | 0.4757 | 0.4741 | 0.4741 | 1595776.0 |
| 2004-05-20 12:35:00 | AAPL | Stock | 0.4743 | 0.4752 | 0.4741 | 0.475 | 2623544.0 |
| 2004-05-20 12:40:00 | AAPL | Stock | 0.475 | 0.4759 | 0.4741 | 0.4746 | 825832.0 |
| 2004-05-20 12:45:00 | AAPL | Stock | 0.4743 | 0.4782 | 0.4741 | 0.4782 | 1726480.0 |
| 2004-05-20 12:50:00 | AAPL | Stock | 0.478 | 0.4784 | 0.4773 | 0.4784 | 1708280.0 |
| 2004-05-20 12:55:00 | AAPL | Stock | 0.4784 | 0.4788 | 0.4782 | 0.4784 | 691824.0 |
> showing 50 of 174,887 rows — these rows as CSV