PREVIEW / stock_5min / 2004-07-29
file: by_date/stock_5min/2004/2004-07-29.parquet size: 2.4 MB rows: 178,320 symbols: 1,813
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-29 08:50:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5764 | 0.5764 | 168000.0 |
| 2004-07-29 09:15:00 | AAPL | Stock | 0.5798 | 0.5798 | 0.5798 | 0.5798 | 22400.0 |
| 2004-07-29 09:20:00 | AAPL | Stock | 0.5798 | 0.5798 | 0.5798 | 0.5798 | 52640.0 |
| 2004-07-29 09:25:00 | AAPL | Stock | 0.5804 | 0.5814 | 0.58 | 0.5814 | 312032.0 |
| 2004-07-29 09:30:00 | AAPL | Stock | 0.5804 | 0.5818 | 0.5798 | 0.5813 | 5634440.0 |
| 2004-07-29 09:35:00 | AAPL | Stock | 0.5813 | 0.582 | 0.5805 | 0.582 | 6342056.0 |
| 2004-07-29 09:40:00 | AAPL | Stock | 0.5816 | 0.5821 | 0.5809 | 0.5813 | 2207184.0 |
| 2004-07-29 09:45:00 | AAPL | Stock | 0.5814 | 0.5816 | 0.5807 | 0.5809 | 2583896.0 |
| 2004-07-29 09:50:00 | AAPL | Stock | 0.5809 | 0.5813 | 0.5802 | 0.5807 | 2196208.0 |
| 2004-07-29 09:55:00 | AAPL | Stock | 0.5807 | 0.5811 | 0.5796 | 0.5802 | 4164776.0 |
| 2004-07-29 10:00:00 | AAPL | Stock | 0.5805 | 0.5811 | 0.5796 | 0.58 | 3576104.0 |
| 2004-07-29 10:05:00 | AAPL | Stock | 0.5802 | 0.5811 | 0.58 | 0.5811 | 4015816.0 |
| 2004-07-29 10:10:00 | AAPL | Stock | 0.5809 | 0.5813 | 0.5807 | 0.5809 | 2716616.0 |
| 2004-07-29 10:15:00 | AAPL | Stock | 0.5809 | 0.5811 | 0.5798 | 0.58 | 7974008.0 |
| 2004-07-29 10:20:00 | AAPL | Stock | 0.58 | 0.5804 | 0.5788 | 0.5791 | 5401088.0 |
| 2004-07-29 10:25:00 | AAPL | Stock | 0.5789 | 0.5791 | 0.5775 | 0.5784 | 2164512.0 |
| 2004-07-29 10:30:00 | AAPL | Stock | 0.578 | 0.5789 | 0.578 | 0.5784 | 2726976.0 |
| 2004-07-29 10:35:00 | AAPL | Stock | 0.5786 | 0.5788 | 0.5768 | 0.577 | 1037400.0 |
| 2004-07-29 10:40:00 | AAPL | Stock | 0.5768 | 0.577 | 0.5743 | 0.5748 | 3180072.0 |
| 2004-07-29 10:45:00 | AAPL | Stock | 0.575 | 0.5759 | 0.5738 | 0.5759 | 2801400.0 |
| 2004-07-29 10:50:00 | AAPL | Stock | 0.5759 | 0.5764 | 0.575 | 0.5754 | 2516472.0 |
| 2004-07-29 10:55:00 | AAPL | Stock | 0.5755 | 0.5789 | 0.5754 | 0.5779 | 3692136.0 |
| 2004-07-29 11:00:00 | AAPL | Stock | 0.5777 | 0.5786 | 0.5759 | 0.578 | 1796928.0 |
| 2004-07-29 11:05:00 | AAPL | Stock | 0.5779 | 0.5782 | 0.5759 | 0.5759 | 1656592.0 |
| 2004-07-29 11:10:00 | AAPL | Stock | 0.5759 | 0.5777 | 0.5759 | 0.5768 | 3442600.0 |
| 2004-07-29 11:15:00 | AAPL | Stock | 0.5771 | 0.5777 | 0.577 | 0.5771 | 1254960.0 |
| 2004-07-29 11:20:00 | AAPL | Stock | 0.5773 | 0.5777 | 0.5759 | 0.5759 | 1098832.0 |
| 2004-07-29 11:25:00 | AAPL | Stock | 0.5759 | 0.5761 | 0.5745 | 0.5754 | 865200.0 |
| 2004-07-29 11:30:00 | AAPL | Stock | 0.5755 | 0.5757 | 0.5743 | 0.575 | 1043056.0 |
| 2004-07-29 11:35:00 | AAPL | Stock | 0.5752 | 0.5766 | 0.575 | 0.5759 | 822080.0 |
| 2004-07-29 11:40:00 | AAPL | Stock | 0.5761 | 0.5764 | 0.5746 | 0.5755 | 1119104.0 |
| 2004-07-29 11:45:00 | AAPL | Stock | 0.5755 | 0.5773 | 0.5754 | 0.5773 | 1187256.0 |
| 2004-07-29 11:50:00 | AAPL | Stock | 0.577 | 0.5773 | 0.5764 | 0.5768 | 606760.0 |
| 2004-07-29 11:55:00 | AAPL | Stock | 0.5768 | 0.577 | 0.5745 | 0.5746 | 1625120.0 |
| 2004-07-29 12:00:00 | AAPL | Stock | 0.5746 | 0.5748 | 0.5745 | 0.5745 | 1365840.0 |
| 2004-07-29 12:05:00 | AAPL | Stock | 0.5745 | 0.5752 | 0.5741 | 0.5751 | 2610440.0 |
| 2004-07-29 12:10:00 | AAPL | Stock | 0.575 | 0.5752 | 0.5746 | 0.5748 | 522200.0 |
| 2004-07-29 12:15:00 | AAPL | Stock | 0.5752 | 0.5768 | 0.575 | 0.5766 | 1832040.0 |
| 2004-07-29 12:20:00 | AAPL | Stock | 0.5766 | 0.5802 | 0.5766 | 0.5797 | 4051488.0 |
| 2004-07-29 12:25:00 | AAPL | Stock | 0.58 | 0.58 | 0.5789 | 0.5791 | 1539048.0 |
| 2004-07-29 12:30:00 | AAPL | Stock | 0.5791 | 0.5816 | 0.5791 | 0.5807 | 5340776.0 |
| 2004-07-29 12:35:00 | AAPL | Stock | 0.5807 | 0.583 | 0.5807 | 0.5827 | 3770424.0 |
| 2004-07-29 12:40:00 | AAPL | Stock | 0.5829 | 0.583 | 0.5818 | 0.5827 | 1375080.0 |
| 2004-07-29 12:45:00 | AAPL | Stock | 0.5828 | 0.5828 | 0.5821 | 0.5825 | 2201248.0 |
| 2004-07-29 12:50:00 | AAPL | Stock | 0.5823 | 0.5825 | 0.5823 | 0.5823 | 2153536.0 |
| 2004-07-29 12:55:00 | AAPL | Stock | 0.5823 | 0.5823 | 0.5811 | 0.5821 | 1655640.0 |
| 2004-07-29 13:00:00 | AAPL | Stock | 0.5823 | 0.5825 | 0.5818 | 0.5823 | 933184.0 |
| 2004-07-29 13:05:00 | AAPL | Stock | 0.5825 | 0.5848 | 0.5823 | 0.5846 | 6768944.0 |
| 2004-07-29 13:10:00 | AAPL | Stock | 0.5846 | 0.5861 | 0.5836 | 0.5843 | 7627088.0 |
| 2004-07-29 13:15:00 | AAPL | Stock | 0.5845 | 0.5845 | 0.5829 | 0.5829 | 1897448.0 |
> showing 50 of 178,320 rows — these rows as CSV