PREVIEW / stock_5min / 2004-07-21
file: by_date/stock_5min/2004/2004-07-21.parquet size: 2.5 MB rows: 181,240 symbols: 1,805
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-21 08:00:00 | AAPL | Stock | 0.5782 | 0.5804 | 0.5782 | 0.5786 | 22400.0 |
| 2004-07-21 08:20:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5804 | 0.5804 | 98224.0 |
| 2004-07-21 08:25:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5804 | 0.5804 | 22400.0 |
| 2004-07-21 08:30:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5804 | 0.5804 | 24976.0 |
| 2004-07-21 08:35:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5786 | 0.5786 | 224000.0 |
| 2004-07-21 09:10:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5795 | 0.5795 | 15624.0 |
| 2004-07-21 09:20:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5795 | 0.5795 | 207200.0 |
| 2004-07-21 09:25:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5777 | 0.5777 | 114800.0 |
| 2004-07-21 09:30:00 | AAPL | Stock | 0.5768 | 0.5804 | 0.575 | 0.5798 | 7496832.0 |
| 2004-07-21 09:35:00 | AAPL | Stock | 0.5796 | 0.583 | 0.5795 | 0.5823 | 6765696.0 |
| 2004-07-21 09:40:00 | AAPL | Stock | 0.5823 | 0.5841 | 0.582 | 0.583 | 6919640.0 |
| 2004-07-21 09:45:00 | AAPL | Stock | 0.5827 | 0.5838 | 0.5813 | 0.5816 | 7758016.0 |
| 2004-07-21 09:50:00 | AAPL | Stock | 0.5813 | 0.5821 | 0.5796 | 0.5811 | 6847008.0 |
| 2004-07-21 09:55:00 | AAPL | Stock | 0.5813 | 0.5818 | 0.5798 | 0.5805 | 9792104.0 |
| 2004-07-21 10:00:00 | AAPL | Stock | 0.5804 | 0.5821 | 0.5804 | 0.5821 | 4958296.0 |
| 2004-07-21 10:05:00 | AAPL | Stock | 0.5818 | 0.5827 | 0.5811 | 0.5816 | 4547480.0 |
| 2004-07-21 10:10:00 | AAPL | Stock | 0.5816 | 0.5836 | 0.5813 | 0.5818 | 4476920.0 |
| 2004-07-21 10:15:00 | AAPL | Stock | 0.5816 | 0.5836 | 0.5816 | 0.5836 | 4104744.0 |
| 2004-07-21 10:20:00 | AAPL | Stock | 0.5836 | 0.5836 | 0.5804 | 0.5805 | 4593008.0 |
| 2004-07-21 10:25:00 | AAPL | Stock | 0.5807 | 0.5814 | 0.5804 | 0.5809 | 875672.0 |
| 2004-07-21 10:30:00 | AAPL | Stock | 0.5809 | 0.5809 | 0.5786 | 0.5789 | 3349920.0 |
| 2004-07-21 10:35:00 | AAPL | Stock | 0.5789 | 0.5798 | 0.5763 | 0.577 | 3200232.0 |
| 2004-07-21 10:40:00 | AAPL | Stock | 0.5771 | 0.578 | 0.5741 | 0.5764 | 3212776.0 |
| 2004-07-21 10:45:00 | AAPL | Stock | 0.5766 | 0.5766 | 0.5748 | 0.5757 | 3233888.0 |
| 2004-07-21 10:50:00 | AAPL | Stock | 0.5754 | 0.5764 | 0.5748 | 0.5748 | 3076640.0 |
| 2004-07-21 10:55:00 | AAPL | Stock | 0.5748 | 0.5752 | 0.5745 | 0.5746 | 955080.0 |
| 2004-07-21 11:00:00 | AAPL | Stock | 0.5745 | 0.5746 | 0.5729 | 0.5729 | 3802064.0 |
| 2004-07-21 11:05:00 | AAPL | Stock | 0.5725 | 0.5729 | 0.5714 | 0.572 | 2802296.0 |
| 2004-07-21 11:10:00 | AAPL | Stock | 0.5721 | 0.573 | 0.5716 | 0.5729 | 2286424.0 |
| 2004-07-21 11:15:00 | AAPL | Stock | 0.5729 | 0.5746 | 0.5725 | 0.5734 | 2956296.0 |
| 2004-07-21 11:20:00 | AAPL | Stock | 0.5734 | 0.5759 | 0.5734 | 0.5759 | 2409568.0 |
| 2004-07-21 11:25:00 | AAPL | Stock | 0.5759 | 0.5764 | 0.5754 | 0.5764 | 1322272.0 |
| 2004-07-21 11:30:00 | AAPL | Stock | 0.5763 | 0.5764 | 0.5757 | 0.5761 | 806232.0 |
| 2004-07-21 11:35:00 | AAPL | Stock | 0.5761 | 0.5763 | 0.5752 | 0.5763 | 1116248.0 |
| 2004-07-21 11:40:00 | AAPL | Stock | 0.5761 | 0.5766 | 0.5755 | 0.5763 | 904624.0 |
| 2004-07-21 11:45:00 | AAPL | Stock | 0.5763 | 0.5763 | 0.5748 | 0.5754 | 1071896.0 |
| 2004-07-21 11:50:00 | AAPL | Stock | 0.5755 | 0.5757 | 0.5743 | 0.5743 | 1027152.0 |
| 2004-07-21 11:55:00 | AAPL | Stock | 0.5741 | 0.5743 | 0.5729 | 0.5732 | 1089536.0 |
| 2004-07-21 12:00:00 | AAPL | Stock | 0.5732 | 0.5743 | 0.5725 | 0.5739 | 2114616.0 |
| 2004-07-21 12:05:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5718 | 0.5723 | 1526112.0 |
| 2004-07-21 12:10:00 | AAPL | Stock | 0.5721 | 0.5725 | 0.5716 | 0.5716 | 2035656.0 |
| 2004-07-21 12:15:00 | AAPL | Stock | 0.5716 | 0.5725 | 0.5714 | 0.5718 | 2204384.0 |
| 2004-07-21 12:20:00 | AAPL | Stock | 0.5716 | 0.5732 | 0.5716 | 0.5729 | 1681008.0 |
| 2004-07-21 12:25:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5729 | 0.5729 | 585984.0 |
| 2004-07-21 12:30:00 | AAPL | Stock | 0.5729 | 0.5729 | 0.5718 | 0.5723 | 736736.0 |
| 2004-07-21 12:35:00 | AAPL | Stock | 0.5725 | 0.5736 | 0.5723 | 0.5736 | 1186976.0 |
| 2004-07-21 12:40:00 | AAPL | Stock | 0.5734 | 0.5736 | 0.5723 | 0.5727 | 941024.0 |
| 2004-07-21 12:45:00 | AAPL | Stock | 0.5729 | 0.5745 | 0.5729 | 0.5743 | 874216.0 |
| 2004-07-21 12:50:00 | AAPL | Stock | 0.5745 | 0.5757 | 0.5743 | 0.575 | 3764264.0 |
| 2004-07-21 12:55:00 | AAPL | Stock | 0.575 | 0.575 | 0.5746 | 0.575 | 1075984.0 |
> showing 50 of 181,240 rows — these rows as CSV