PREVIEW / stock_5min / 2007-02-26
file: by_date/stock_5min/2007/2007-02-26.parquet size: 3.4 MB rows: 243,605 symbols: 2,521
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-26 05:35:00 | AAPL | Stock | 3.1914 | 3.1921 | 3.1914 | 3.1921 | 16744.0 |
| 2007-02-26 05:45:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1929 | 3.1929 | 10584.0 |
| 2007-02-26 06:35:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1929 | 3.1929 | 20216.0 |
| 2007-02-26 07:35:00 | AAPL | Stock | 3.1961 | 3.1961 | 3.1961 | 3.1961 | 28000.0 |
| 2007-02-26 07:40:00 | AAPL | Stock | 3.2025 | 3.2229 | 3.2025 | 3.2229 | 169204.0 |
| 2007-02-26 07:45:00 | AAPL | Stock | 3.2179 | 3.2304 | 3.2179 | 3.2304 | 431424.0 |
| 2007-02-26 07:50:00 | AAPL | Stock | 3.2304 | 3.2393 | 3.23 | 3.2357 | 236600.0 |
| 2007-02-26 07:55:00 | AAPL | Stock | 3.2254 | 3.2257 | 3.2232 | 3.2257 | 14000.0 |
| 2007-02-26 08:00:00 | AAPL | Stock | 3.2239 | 3.2268 | 3.1964 | 3.2143 | 845908.0 |
| 2007-02-26 08:05:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2107 | 3.2143 | 423388.0 |
| 2007-02-26 08:10:00 | AAPL | Stock | 3.2168 | 3.2179 | 3.2161 | 3.2161 | 159040.0 |
| 2007-02-26 08:15:00 | AAPL | Stock | 3.2171 | 3.2182 | 3.2132 | 3.2132 | 346920.0 |
| 2007-02-26 08:20:00 | AAPL | Stock | 3.2132 | 3.2139 | 3.2129 | 3.2139 | 317100.0 |
| 2007-02-26 08:25:00 | AAPL | Stock | 3.2139 | 3.2139 | 3.21 | 3.2125 | 313460.0 |
| 2007-02-26 08:30:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2107 | 3.2143 | 288372.0 |
| 2007-02-26 08:35:00 | AAPL | Stock | 3.2118 | 3.2118 | 3.2107 | 3.2111 | 71960.0 |
| 2007-02-26 08:40:00 | AAPL | Stock | 3.2129 | 3.2139 | 3.2129 | 3.2139 | 44800.0 |
| 2007-02-26 08:45:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2136 | 3.2136 | 56000.0 |
| 2007-02-26 08:50:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.21 | 3.21 | 114240.0 |
| 2007-02-26 08:55:00 | AAPL | Stock | 3.2082 | 3.2096 | 3.2082 | 3.2086 | 105756.0 |
| 2007-02-26 09:00:00 | AAPL | Stock | 3.2086 | 3.2086 | 3.2071 | 3.2071 | 47600.0 |
| 2007-02-26 09:05:00 | AAPL | Stock | 3.2071 | 3.2118 | 3.2064 | 3.2107 | 235256.0 |
| 2007-02-26 09:10:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 90580.0 |
| 2007-02-26 09:15:00 | AAPL | Stock | 3.2096 | 3.2096 | 3.2018 | 3.2036 | 644168.0 |
| 2007-02-26 09:20:00 | AAPL | Stock | 3.2036 | 3.2086 | 3.2036 | 3.2086 | 287840.0 |
| 2007-02-26 09:25:00 | AAPL | Stock | 3.2086 | 3.2089 | 3.2057 | 3.2079 | 430444.0 |
| 2007-02-26 09:30:00 | AAPL | Stock | 3.2089 | 3.2143 | 3.1929 | 3.193 | 17579492.0 |
| 2007-02-26 09:35:00 | AAPL | Stock | 3.1932 | 3.1971 | 3.1821 | 3.1829 | 16375548.0 |
| 2007-02-26 09:40:00 | AAPL | Stock | 3.1825 | 3.1857 | 3.175 | 3.1825 | 17864056.0 |
| 2007-02-26 09:45:00 | AAPL | Stock | 3.1821 | 3.1921 | 3.1814 | 3.1857 | 13854176.0 |
| 2007-02-26 09:50:00 | AAPL | Stock | 3.1857 | 3.1877 | 3.1661 | 3.1686 | 16446388.0 |
| 2007-02-26 09:55:00 | AAPL | Stock | 3.1689 | 3.1804 | 3.1643 | 3.1693 | 16761808.0 |
| 2007-02-26 10:00:00 | AAPL | Stock | 3.1686 | 3.1714 | 3.1607 | 3.1607 | 11548096.0 |
| 2007-02-26 10:05:00 | AAPL | Stock | 3.1607 | 3.1643 | 3.1521 | 3.1607 | 19022752.0 |
| 2007-02-26 10:10:00 | AAPL | Stock | 3.1604 | 3.1707 | 3.1593 | 3.17 | 12921048.0 |
| 2007-02-26 10:15:00 | AAPL | Stock | 3.17 | 3.1704 | 3.1636 | 3.1654 | 7391104.0 |
| 2007-02-26 10:20:00 | AAPL | Stock | 3.1657 | 3.1661 | 3.1571 | 3.1607 | 10377500.0 |
| 2007-02-26 10:25:00 | AAPL | Stock | 3.1611 | 3.1657 | 3.1534 | 3.1564 | 7036204.0 |
| 2007-02-26 10:30:00 | AAPL | Stock | 3.1561 | 3.1564 | 3.1471 | 3.1536 | 9829344.0 |
| 2007-02-26 10:35:00 | AAPL | Stock | 3.1539 | 3.1589 | 3.1482 | 3.1567 | 6371512.0 |
| 2007-02-26 10:40:00 | AAPL | Stock | 3.1568 | 3.1568 | 3.1375 | 3.1407 | 15146684.0 |
| 2007-02-26 10:45:00 | AAPL | Stock | 3.1407 | 3.1514 | 3.1393 | 3.1507 | 11179588.0 |
| 2007-02-26 10:50:00 | AAPL | Stock | 3.1507 | 3.1589 | 3.15 | 3.1525 | 7382928.0 |
| 2007-02-26 10:55:00 | AAPL | Stock | 3.1525 | 3.1625 | 3.1518 | 3.1571 | 7241528.0 |
| 2007-02-26 11:00:00 | AAPL | Stock | 3.1571 | 3.165 | 3.1546 | 3.1553 | 8946560.0 |
| 2007-02-26 11:05:00 | AAPL | Stock | 3.155 | 3.1625 | 3.1525 | 3.1618 | 7188300.0 |
| 2007-02-26 11:10:00 | AAPL | Stock | 3.1618 | 3.1643 | 3.1568 | 3.1607 | 6302184.0 |
| 2007-02-26 11:15:00 | AAPL | Stock | 3.1607 | 3.1772 | 3.1543 | 3.1593 | 4420444.0 |
| 2007-02-26 11:20:00 | AAPL | Stock | 3.1593 | 3.1736 | 3.155 | 3.1568 | 3612364.0 |
| 2007-02-26 11:25:00 | AAPL | Stock | 3.1568 | 3.1582 | 3.1518 | 3.1536 | 4104996.0 |
> showing 50 of 243,605 rows — these rows as CSV