PREVIEW / stock_5min / 2000-04-03
file: by_date/stock_5min/2000/2000-04-03.parquet size: 1.2 MB rows: 88,969 symbols: 1,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 |
|---|---|---|---|---|---|---|---|
| 2000-04-03 09:30:00 | AAPL | Stock | 1.2098 | 1.231 | 1.2054 | 1.2277 | 7369600.0 |
| 2000-04-03 09:35:00 | AAPL | Stock | 1.2254 | 1.2455 | 1.2126 | 1.2444 | 8108800.0 |
| 2000-04-03 09:40:00 | AAPL | Stock | 1.2444 | 1.245 | 1.2327 | 1.236 | 3808000.0 |
| 2000-04-03 09:45:00 | AAPL | Stock | 1.2355 | 1.236 | 1.2277 | 1.2333 | 7728000.0 |
| 2000-04-03 09:50:00 | AAPL | Stock | 1.2333 | 1.2344 | 1.2232 | 1.2232 | 4155200.0 |
| 2000-04-03 09:55:00 | AAPL | Stock | 1.2271 | 1.2299 | 1.2221 | 1.2254 | 3404800.0 |
| 2000-04-03 10:00:00 | AAPL | Stock | 1.2232 | 1.2294 | 1.2042 | 1.2042 | 7134400.0 |
| 2000-04-03 10:05:00 | AAPL | Stock | 1.2054 | 1.2054 | 1.1875 | 1.1875 | 11088000.0 |
| 2000-04-03 10:10:00 | AAPL | Stock | 1.1881 | 1.202 | 1.1853 | 1.1886 | 6630400.0 |
| 2000-04-03 10:15:00 | AAPL | Stock | 1.1864 | 1.1892 | 1.1786 | 1.1791 | 4032000.0 |
| 2000-04-03 10:20:00 | AAPL | Stock | 1.1791 | 1.2042 | 1.1786 | 1.2031 | 6619200.0 |
| 2000-04-03 10:25:00 | AAPL | Stock | 1.2026 | 1.2042 | 1.1964 | 1.1964 | 3886400.0 |
| 2000-04-03 10:30:00 | AAPL | Stock | 1.1959 | 1.202 | 1.192 | 1.1948 | 4603200.0 |
| 2000-04-03 10:35:00 | AAPL | Stock | 1.1942 | 1.1964 | 1.1858 | 1.1858 | 4200000.0 |
| 2000-04-03 10:40:00 | AAPL | Stock | 1.1864 | 1.1864 | 1.1763 | 1.1769 | 4267200.0 |
| 2000-04-03 10:45:00 | AAPL | Stock | 1.1775 | 1.1942 | 1.1747 | 1.1853 | 5062400.0 |
| 2000-04-03 10:50:00 | AAPL | Stock | 1.1853 | 1.192 | 1.1853 | 1.1914 | 3091200.0 |
| 2000-04-03 10:55:00 | AAPL | Stock | 1.1897 | 1.1987 | 1.183 | 1.192 | 4435200.0 |
| 2000-04-03 11:00:00 | AAPL | Stock | 1.192 | 1.1931 | 1.1786 | 1.1847 | 3281600.0 |
| 2000-04-03 11:05:00 | AAPL | Stock | 1.1858 | 1.1964 | 1.1836 | 1.195 | 2217600.0 |
| 2000-04-03 11:10:00 | AAPL | Stock | 1.1959 | 1.2003 | 1.1886 | 1.1886 | 2576000.0 |
| 2000-04-03 11:15:00 | AAPL | Stock | 1.1886 | 1.1908 | 1.1802 | 1.1836 | 1657600.0 |
| 2000-04-03 11:20:00 | AAPL | Stock | 1.1847 | 1.192 | 1.1708 | 1.173 | 4502400.0 |
| 2000-04-03 11:25:00 | AAPL | Stock | 1.1708 | 1.1758 | 1.1563 | 1.1563 | 6462400.0 |
| 2000-04-03 11:30:00 | AAPL | Stock | 1.1563 | 1.1685 | 1.1557 | 1.1674 | 5219200.0 |
| 2000-04-03 11:35:00 | AAPL | Stock | 1.1685 | 1.1722 | 1.1607 | 1.1696 | 1982400.0 |
| 2000-04-03 11:40:00 | AAPL | Stock | 1.1708 | 1.1786 | 1.1702 | 1.1786 | 6787200.0 |
| 2000-04-03 11:45:00 | AAPL | Stock | 1.1786 | 1.1802 | 1.1752 | 1.1775 | 4491200.0 |
| 2000-04-03 11:50:00 | AAPL | Stock | 1.178 | 1.1786 | 1.1758 | 1.178 | 2374400.0 |
| 2000-04-03 11:55:00 | AAPL | Stock | 1.178 | 1.1825 | 1.1708 | 1.1719 | 3046400.0 |
| 2000-04-03 12:00:00 | AAPL | Stock | 1.1741 | 1.178 | 1.1657 | 1.1775 | 2083200.0 |
| 2000-04-03 12:05:00 | AAPL | Stock | 1.1786 | 1.183 | 1.1741 | 1.1741 | 1668800.0 |
| 2000-04-03 12:10:00 | AAPL | Stock | 1.1741 | 1.1897 | 1.1741 | 1.1886 | 2150400.0 |
| 2000-04-03 12:15:00 | AAPL | Stock | 1.1892 | 1.1897 | 1.1808 | 1.1858 | 907200.0 |
| 2000-04-03 12:20:00 | AAPL | Stock | 1.1858 | 1.1881 | 1.1847 | 1.1858 | 1736000.0 |
| 2000-04-03 12:25:00 | AAPL | Stock | 1.1853 | 1.1875 | 1.1808 | 1.1858 | 2184000.0 |
| 2000-04-03 12:30:00 | AAPL | Stock | 1.1864 | 1.1875 | 1.1786 | 1.1786 | 1142400.0 |
| 2000-04-03 12:35:00 | AAPL | Stock | 1.1797 | 1.1797 | 1.1702 | 1.178 | 1814400.0 |
| 2000-04-03 12:40:00 | AAPL | Stock | 1.178 | 1.1797 | 1.1735 | 1.1797 | 974400.0 |
| 2000-04-03 12:45:00 | AAPL | Stock | 1.1758 | 1.1808 | 1.1741 | 1.1808 | 448000.0 |
| 2000-04-03 12:50:00 | AAPL | Stock | 1.1808 | 1.1808 | 1.1769 | 1.1808 | 593600.0 |
| 2000-04-03 12:55:00 | AAPL | Stock | 1.1808 | 1.1892 | 1.1808 | 1.1869 | 1590400.0 |
| 2000-04-03 13:00:00 | AAPL | Stock | 1.1869 | 1.1892 | 1.1869 | 1.1875 | 806400.0 |
| 2000-04-03 13:05:00 | AAPL | Stock | 1.1847 | 1.1869 | 1.1836 | 1.1836 | 728000.0 |
| 2000-04-03 13:10:00 | AAPL | Stock | 1.183 | 1.1836 | 1.1808 | 1.1836 | 3505600.0 |
| 2000-04-03 13:15:00 | AAPL | Stock | 1.1842 | 1.1842 | 1.1786 | 1.1791 | 425600.0 |
| 2000-04-03 13:20:00 | AAPL | Stock | 1.1786 | 1.1802 | 1.1735 | 1.1741 | 1243200.0 |
| 2000-04-03 13:25:00 | AAPL | Stock | 1.1735 | 1.1786 | 1.1735 | 1.1741 | 2284800.0 |
| 2000-04-03 13:30:00 | AAPL | Stock | 1.1747 | 1.1786 | 1.1741 | 1.1786 | 1444800.0 |
| 2000-04-03 13:35:00 | AAPL | Stock | 1.1777 | 1.1777 | 1.1635 | 1.1747 | 2800000.0 |
> showing 50 of 88,969 rows — these rows as CSV