PREVIEW / stock_5min / 2004-06-17
file: by_date/stock_5min/2004/2004-06-17.parquet size: 2.4 MB rows: 173,700 symbols: 1,782
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-06-17 08:55:00 | AAPL | Stock | 0.583 | 0.583 | 0.583 | 0.583 | 56000.0 |
| 2004-06-17 09:00:00 | AAPL | Stock | 0.583 | 0.583 | 0.5814 | 0.5814 | 61600.0 |
| 2004-06-17 09:05:00 | AAPL | Stock | 0.5814 | 0.5821 | 0.5813 | 0.5813 | 33600.0 |
| 2004-06-17 09:10:00 | AAPL | Stock | 0.5813 | 0.5814 | 0.5813 | 0.5814 | 100800.0 |
| 2004-06-17 09:15:00 | AAPL | Stock | 0.5814 | 0.5814 | 0.5814 | 0.5814 | 16800.0 |
| 2004-06-17 09:20:00 | AAPL | Stock | 0.5814 | 0.5821 | 0.5805 | 0.5805 | 260400.0 |
| 2004-06-17 09:25:00 | AAPL | Stock | 0.5816 | 0.5816 | 0.5804 | 0.5807 | 1642928.0 |
| 2004-06-17 09:30:00 | AAPL | Stock | 0.5813 | 0.5888 | 0.5804 | 0.5882 | 28875616.0 |
| 2004-06-17 09:35:00 | AAPL | Stock | 0.588 | 0.5909 | 0.5864 | 0.5882 | 23279424.0 |
| 2004-06-17 09:40:00 | AAPL | Stock | 0.5882 | 0.5916 | 0.5866 | 0.587 | 20488104.0 |
| 2004-06-17 09:45:00 | AAPL | Stock | 0.5871 | 0.5879 | 0.5821 | 0.5821 | 19182968.0 |
| 2004-06-17 09:50:00 | AAPL | Stock | 0.5821 | 0.5861 | 0.5821 | 0.5838 | 10329032.0 |
| 2004-06-17 09:55:00 | AAPL | Stock | 0.5839 | 0.5854 | 0.5839 | 0.5848 | 16741088.0 |
| 2004-06-17 10:00:00 | AAPL | Stock | 0.5848 | 0.5852 | 0.5804 | 0.5805 | 14251048.0 |
| 2004-06-17 10:05:00 | AAPL | Stock | 0.5805 | 0.582 | 0.5798 | 0.5809 | 10576328.0 |
| 2004-06-17 10:10:00 | AAPL | Stock | 0.5809 | 0.5809 | 0.5752 | 0.5755 | 13534304.0 |
| 2004-06-17 10:15:00 | AAPL | Stock | 0.5755 | 0.5775 | 0.5752 | 0.5775 | 22471624.0 |
| 2004-06-17 10:20:00 | AAPL | Stock | 0.5775 | 0.5795 | 0.5773 | 0.5791 | 6909056.0 |
| 2004-06-17 10:25:00 | AAPL | Stock | 0.5788 | 0.5807 | 0.5782 | 0.5798 | 5432840.0 |
| 2004-06-17 10:30:00 | AAPL | Stock | 0.5798 | 0.58 | 0.577 | 0.578 | 5178320.0 |
| 2004-06-17 10:35:00 | AAPL | Stock | 0.5782 | 0.5789 | 0.5777 | 0.5786 | 4238752.0 |
| 2004-06-17 10:40:00 | AAPL | Stock | 0.5784 | 0.582 | 0.5784 | 0.5795 | 5436032.0 |
| 2004-06-17 10:45:00 | AAPL | Stock | 0.5795 | 0.5802 | 0.5784 | 0.5788 | 3491880.0 |
| 2004-06-17 10:50:00 | AAPL | Stock | 0.5788 | 0.5825 | 0.5782 | 0.5816 | 5024768.0 |
| 2004-06-17 10:55:00 | AAPL | Stock | 0.582 | 0.5836 | 0.5804 | 0.5807 | 3874976.0 |
| 2004-06-17 11:00:00 | AAPL | Stock | 0.5807 | 0.5809 | 0.5798 | 0.5802 | 3748640.0 |
| 2004-06-17 11:05:00 | AAPL | Stock | 0.5802 | 0.5807 | 0.5777 | 0.5777 | 3952032.0 |
| 2004-06-17 11:10:00 | AAPL | Stock | 0.5777 | 0.5795 | 0.5777 | 0.578 | 1921192.0 |
| 2004-06-17 11:15:00 | AAPL | Stock | 0.578 | 0.5795 | 0.5775 | 0.5779 | 4062688.0 |
| 2004-06-17 11:20:00 | AAPL | Stock | 0.5779 | 0.5786 | 0.5777 | 0.5786 | 1967280.0 |
| 2004-06-17 11:25:00 | AAPL | Stock | 0.5785 | 0.5786 | 0.577 | 0.5784 | 3337880.0 |
| 2004-06-17 11:30:00 | AAPL | Stock | 0.5786 | 0.5788 | 0.5782 | 0.5786 | 3426416.0 |
| 2004-06-17 11:35:00 | AAPL | Stock | 0.5786 | 0.5793 | 0.5786 | 0.5788 | 2723672.0 |
| 2004-06-17 11:40:00 | AAPL | Stock | 0.5786 | 0.5789 | 0.5784 | 0.5786 | 6740216.0 |
| 2004-06-17 11:45:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5777 | 0.578 | 3359944.0 |
| 2004-06-17 11:50:00 | AAPL | Stock | 0.5784 | 0.5788 | 0.5782 | 0.5788 | 13918072.0 |
| 2004-06-17 11:55:00 | AAPL | Stock | 0.5788 | 0.5813 | 0.5786 | 0.5796 | 6477240.0 |
| 2004-06-17 12:00:00 | AAPL | Stock | 0.5795 | 0.5796 | 0.5786 | 0.5791 | 2202200.0 |
| 2004-06-17 12:05:00 | AAPL | Stock | 0.5791 | 0.5798 | 0.5788 | 0.5789 | 1682800.0 |
| 2004-06-17 12:10:00 | AAPL | Stock | 0.5788 | 0.5789 | 0.5788 | 0.5789 | 1676640.0 |
| 2004-06-17 12:15:00 | AAPL | Stock | 0.5789 | 0.5789 | 0.5784 | 0.5789 | 4977840.0 |
| 2004-06-17 12:20:00 | AAPL | Stock | 0.5784 | 0.5789 | 0.5779 | 0.5789 | 2503592.0 |
| 2004-06-17 12:25:00 | AAPL | Stock | 0.5786 | 0.5804 | 0.5786 | 0.5798 | 2092384.0 |
| 2004-06-17 12:30:00 | AAPL | Stock | 0.5798 | 0.58 | 0.5789 | 0.5789 | 805896.0 |
| 2004-06-17 12:35:00 | AAPL | Stock | 0.5789 | 0.5791 | 0.5786 | 0.5788 | 1243424.0 |
| 2004-06-17 12:40:00 | AAPL | Stock | 0.5788 | 0.5791 | 0.5786 | 0.5786 | 1961568.0 |
| 2004-06-17 12:45:00 | AAPL | Stock | 0.5786 | 0.5788 | 0.5786 | 0.5786 | 342272.0 |
| 2004-06-17 12:50:00 | AAPL | Stock | 0.5786 | 0.5793 | 0.5786 | 0.5789 | 1926904.0 |
| 2004-06-17 12:55:00 | AAPL | Stock | 0.5789 | 0.5795 | 0.5788 | 0.5789 | 1120336.0 |
| 2004-06-17 13:00:00 | AAPL | Stock | 0.5789 | 0.5796 | 0.5788 | 0.5795 | 1300880.0 |
> showing 50 of 173,700 rows — these rows as CSV