PREVIEW / stock_5min / 2010-10-21
file: by_date/stock_5min/2010/2010-10-21.parquet size: 4.8 MB rows: 326,150 symbols: 3,488
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-21 04:20:00 | AAPL | Stock | 11.1607 | 11.1607 | 11.1607 | 11.1607 | 2800.0 |
| 2010-10-21 04:30:00 | AAPL | Stock | 11.1786 | 11.1875 | 11.1786 | 11.1875 | 5600.0 |
| 2010-10-21 05:00:00 | AAPL | Stock | 11.1525 | 11.1525 | 11.1525 | 11.1525 | 16800.0 |
| 2010-10-21 05:10:00 | AAPL | Stock | 11.1546 | 11.1546 | 11.1546 | 11.1546 | 2800.0 |
| 2010-10-21 05:35:00 | AAPL | Stock | 11.145 | 11.145 | 11.145 | 11.145 | 8400.0 |
| 2010-10-21 06:00:00 | AAPL | Stock | 11.1429 | 11.1464 | 11.1429 | 11.1464 | 20944.0 |
| 2010-10-21 06:15:00 | AAPL | Stock | 11.1429 | 11.1429 | 11.1429 | 11.1429 | 2800.0 |
| 2010-10-21 06:30:00 | AAPL | Stock | 11.15 | 11.1604 | 11.15 | 11.1604 | 5600.0 |
| 2010-10-21 06:35:00 | AAPL | Stock | 11.1604 | 11.1604 | 11.1604 | 11.1604 | 5600.0 |
| 2010-10-21 06:40:00 | AAPL | Stock | 11.1604 | 11.1604 | 11.1604 | 11.1604 | 2800.0 |
| 2010-10-21 06:45:00 | AAPL | Stock | 11.1571 | 11.1571 | 11.1571 | 11.1571 | 5600.0 |
| 2010-10-21 06:50:00 | AAPL | Stock | 11.1604 | 11.1604 | 11.1604 | 11.1604 | 5600.0 |
| 2010-10-21 07:00:00 | AAPL | Stock | 11.1604 | 11.1604 | 11.16 | 11.16 | 12908.0 |
| 2010-10-21 07:05:00 | AAPL | Stock | 11.1504 | 11.1786 | 11.1504 | 11.175 | 84980.0 |
| 2010-10-21 07:10:00 | AAPL | Stock | 11.1746 | 11.1746 | 11.1746 | 11.1746 | 5600.0 |
| 2010-10-21 07:15:00 | AAPL | Stock | 11.175 | 11.175 | 11.1743 | 11.1746 | 28504.0 |
| 2010-10-21 07:20:00 | AAPL | Stock | 11.18 | 11.1804 | 11.18 | 11.1804 | 28000.0 |
| 2010-10-21 07:25:00 | AAPL | Stock | 11.1504 | 11.1504 | 11.1504 | 11.1504 | 2800.0 |
| 2010-10-21 07:30:00 | AAPL | Stock | 11.1746 | 11.1843 | 11.1746 | 11.1843 | 168000.0 |
| 2010-10-21 07:35:00 | AAPL | Stock | 11.1968 | 11.2118 | 11.18 | 11.205 | 187320.0 |
| 2010-10-21 07:40:00 | AAPL | Stock | 11.2018 | 11.2143 | 11.1982 | 11.2107 | 121044.0 |
| 2010-10-21 07:45:00 | AAPL | Stock | 11.2104 | 11.2107 | 11.2036 | 11.2064 | 81116.0 |
| 2010-10-21 07:50:00 | AAPL | Stock | 11.2043 | 11.2043 | 11.1964 | 11.1986 | 47600.0 |
| 2010-10-21 07:55:00 | AAPL | Stock | 11.1839 | 11.1986 | 11.1804 | 11.1957 | 87360.0 |
| 2010-10-21 08:00:00 | AAPL | Stock | 11.1711 | 11.1868 | 11.1629 | 11.1746 | 648200.0 |
| 2010-10-21 08:05:00 | AAPL | Stock | 11.1775 | 11.1779 | 11.1475 | 11.1607 | 727776.0 |
| 2010-10-21 08:10:00 | AAPL | Stock | 11.1571 | 11.1764 | 11.1564 | 11.1643 | 361900.0 |
| 2010-10-21 08:15:00 | AAPL | Stock | 11.1643 | 11.1643 | 11.1582 | 11.1643 | 139020.0 |
| 2010-10-21 08:20:00 | AAPL | Stock | 11.1671 | 11.1696 | 11.1643 | 11.1679 | 169120.0 |
| 2010-10-21 08:25:00 | AAPL | Stock | 11.1679 | 11.1721 | 11.1618 | 11.1721 | 168784.0 |
| 2010-10-21 08:30:00 | AAPL | Stock | 11.1664 | 11.1814 | 11.1661 | 11.1729 | 869624.0 |
| 2010-10-21 08:35:00 | AAPL | Stock | 11.1764 | 11.1764 | 11.1607 | 11.1607 | 543032.0 |
| 2010-10-21 08:40:00 | AAPL | Stock | 11.1621 | 11.1829 | 11.1607 | 11.1821 | 370804.0 |
| 2010-10-21 08:45:00 | AAPL | Stock | 11.1839 | 11.1893 | 11.0904 | 11.1857 | 532140.0 |
| 2010-10-21 08:50:00 | AAPL | Stock | 11.1839 | 11.1846 | 11.1686 | 11.1839 | 692664.0 |
| 2010-10-21 08:55:00 | AAPL | Stock | 11.1836 | 11.185 | 11.1789 | 11.1843 | 362124.0 |
| 2010-10-21 09:00:00 | AAPL | Stock | 11.1843 | 11.1854 | 11.1714 | 11.1721 | 270648.0 |
| 2010-10-21 09:05:00 | AAPL | Stock | 11.1714 | 11.1746 | 11.1657 | 11.1661 | 189560.0 |
| 2010-10-21 09:10:00 | AAPL | Stock | 11.1664 | 11.1729 | 11.1636 | 11.1721 | 193564.0 |
| 2010-10-21 09:15:00 | AAPL | Stock | 11.1711 | 11.1786 | 11.1679 | 11.1779 | 154840.0 |
| 2010-10-21 09:20:00 | AAPL | Stock | 11.1786 | 11.1786 | 11.1736 | 11.1786 | 63560.0 |
| 2010-10-21 09:25:00 | AAPL | Stock | 11.1779 | 11.1779 | 11.1554 | 11.1561 | 308000.0 |
| 2010-10-21 09:30:00 | AAPL | Stock | 11.1564 | 11.1586 | 11.1114 | 11.1368 | 20142276.0 |
| 2010-10-21 09:35:00 | AAPL | Stock | 11.1364 | 11.1829 | 11.1254 | 11.1775 | 17493448.0 |
| 2010-10-21 09:40:00 | AAPL | Stock | 11.1766 | 11.2407 | 11.1743 | 11.2121 | 25872756.0 |
| 2010-10-21 09:45:00 | AAPL | Stock | 11.2139 | 11.2214 | 11.1893 | 11.2039 | 15045128.0 |
| 2010-10-21 09:50:00 | AAPL | Stock | 11.2057 | 11.2079 | 11.1818 | 11.1929 | 8520960.0 |
| 2010-10-21 09:55:00 | AAPL | Stock | 11.1904 | 11.2125 | 11.1886 | 11.2039 | 6084708.0 |
| 2010-10-21 10:00:00 | AAPL | Stock | 11.1996 | 11.2021 | 11.1643 | 11.1857 | 12173336.0 |
| 2010-10-21 10:05:00 | AAPL | Stock | 11.1854 | 11.225 | 11.1725 | 11.2193 | 13535564.0 |
> showing 50 of 326,150 rows — these rows as CSV