PREVIEW / stock_5min / 2009-07-15
file: by_date/stock_5min/2009/2009-07-15.parquet size: 4.7 MB rows: 324,739 symbols: 3,364
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-15 06:00:00 | AAPL | Stock | 5.1607 | 5.1607 | 5.1607 | 5.1607 | 2800.0 |
| 2009-07-15 07:00:00 | AAPL | Stock | 5.1686 | 5.1686 | 5.1686 | 5.1686 | 5600.0 |
| 2009-07-15 07:05:00 | AAPL | Stock | 5.1607 | 5.1607 | 5.1607 | 5.1607 | 3164.0 |
| 2009-07-15 07:20:00 | AAPL | Stock | 5.1607 | 5.1607 | 5.1607 | 5.1607 | 24500.0 |
| 2009-07-15 07:25:00 | AAPL | Stock | 5.1507 | 5.1604 | 5.1507 | 5.1604 | 5600.0 |
| 2009-07-15 07:40:00 | AAPL | Stock | 5.1604 | 5.1607 | 5.1604 | 5.1607 | 44800.0 |
| 2009-07-15 07:50:00 | AAPL | Stock | 5.1518 | 5.1521 | 5.1464 | 5.1464 | 112980.0 |
| 2009-07-15 07:55:00 | AAPL | Stock | 5.1464 | 5.1468 | 5.1361 | 5.1368 | 48216.0 |
| 2009-07-15 08:00:00 | AAPL | Stock | 5.1496 | 5.1561 | 5.1429 | 5.1561 | 188076.0 |
| 2009-07-15 08:05:00 | AAPL | Stock | 5.1561 | 5.1607 | 5.1561 | 5.1607 | 69160.0 |
| 2009-07-15 08:10:00 | AAPL | Stock | 5.1575 | 5.16 | 5.1571 | 5.1571 | 38780.0 |
| 2009-07-15 08:15:00 | AAPL | Stock | 5.1593 | 5.1607 | 5.1568 | 5.1607 | 122220.0 |
| 2009-07-15 08:20:00 | AAPL | Stock | 5.1607 | 5.1621 | 5.1571 | 5.1579 | 107408.0 |
| 2009-07-15 08:25:00 | AAPL | Stock | 5.1607 | 5.1679 | 5.1554 | 5.1554 | 134400.0 |
| 2009-07-15 08:30:00 | AAPL | Stock | 5.1604 | 5.1689 | 5.1596 | 5.1643 | 166516.0 |
| 2009-07-15 08:35:00 | AAPL | Stock | 5.1643 | 5.1661 | 5.1643 | 5.1643 | 37520.0 |
| 2009-07-15 08:40:00 | AAPL | Stock | 5.165 | 5.165 | 5.1579 | 5.1579 | 145180.0 |
| 2009-07-15 08:45:00 | AAPL | Stock | 5.1589 | 5.1625 | 5.1561 | 5.1625 | 89768.0 |
| 2009-07-15 08:50:00 | AAPL | Stock | 5.1636 | 5.1654 | 5.1636 | 5.1643 | 159516.0 |
| 2009-07-15 08:55:00 | AAPL | Stock | 5.1643 | 5.1679 | 5.1643 | 5.1679 | 113008.0 |
| 2009-07-15 09:00:00 | AAPL | Stock | 5.1661 | 5.1721 | 5.1661 | 5.1696 | 375844.0 |
| 2009-07-15 09:05:00 | AAPL | Stock | 5.1711 | 5.175 | 5.1711 | 5.1746 | 309120.0 |
| 2009-07-15 09:10:00 | AAPL | Stock | 5.175 | 5.175 | 5.1718 | 5.1732 | 101388.0 |
| 2009-07-15 09:15:00 | AAPL | Stock | 5.1732 | 5.1757 | 5.1718 | 5.1732 | 184800.0 |
| 2009-07-15 09:20:00 | AAPL | Stock | 5.1768 | 5.1871 | 5.1746 | 5.1746 | 633052.0 |
| 2009-07-15 09:25:00 | AAPL | Stock | 5.1786 | 5.1814 | 5.1718 | 5.1718 | 1285228.0 |
| 2009-07-15 09:30:00 | AAPL | Stock | 5.18 | 5.18 | 5.1543 | 5.165 | 23090648.0 |
| 2009-07-15 09:35:00 | AAPL | Stock | 5.1646 | 5.1875 | 5.1625 | 5.1861 | 18063696.0 |
| 2009-07-15 09:40:00 | AAPL | Stock | 5.1871 | 5.1982 | 5.1861 | 5.1929 | 16672488.0 |
| 2009-07-15 09:45:00 | AAPL | Stock | 5.1929 | 5.1943 | 5.1811 | 5.1854 | 8894760.0 |
| 2009-07-15 09:50:00 | AAPL | Stock | 5.1854 | 5.1857 | 5.1732 | 5.1768 | 11986492.0 |
| 2009-07-15 09:55:00 | AAPL | Stock | 5.1771 | 5.1904 | 5.175 | 5.175 | 11021108.0 |
| 2009-07-15 10:00:00 | AAPL | Stock | 5.175 | 5.1839 | 5.1704 | 5.1707 | 9022132.0 |
| 2009-07-15 10:05:00 | AAPL | Stock | 5.1711 | 5.1775 | 5.1704 | 5.1771 | 6276060.0 |
| 2009-07-15 10:10:00 | AAPL | Stock | 5.1775 | 5.1875 | 5.1725 | 5.1871 | 5768280.0 |
| 2009-07-15 10:15:00 | AAPL | Stock | 5.1875 | 5.1893 | 5.1836 | 5.1882 | 5371520.0 |
| 2009-07-15 10:20:00 | AAPL | Stock | 5.1882 | 5.1907 | 5.1768 | 5.1875 | 6812428.0 |
| 2009-07-15 10:25:00 | AAPL | Stock | 5.1875 | 5.1911 | 5.1804 | 5.1832 | 6015660.0 |
| 2009-07-15 10:30:00 | AAPL | Stock | 5.1836 | 5.1868 | 5.18 | 5.1857 | 4054848.0 |
| 2009-07-15 10:35:00 | AAPL | Stock | 5.1857 | 5.1911 | 5.1846 | 5.1861 | 5314232.0 |
| 2009-07-15 10:40:00 | AAPL | Stock | 5.1859 | 5.1914 | 5.1836 | 5.1857 | 4100628.0 |
| 2009-07-15 10:45:00 | AAPL | Stock | 5.1857 | 5.1875 | 5.1843 | 5.1857 | 2961336.0 |
| 2009-07-15 10:50:00 | AAPL | Stock | 5.1857 | 5.1904 | 5.1839 | 5.1854 | 4244576.0 |
| 2009-07-15 10:55:00 | AAPL | Stock | 5.1857 | 5.1871 | 5.1796 | 5.1843 | 3332756.0 |
| 2009-07-15 11:00:00 | AAPL | Stock | 5.1839 | 5.1889 | 5.1829 | 5.1879 | 3870076.0 |
| 2009-07-15 11:05:00 | AAPL | Stock | 5.1882 | 5.1939 | 5.1864 | 5.1932 | 3377164.0 |
| 2009-07-15 11:10:00 | AAPL | Stock | 5.1936 | 5.2 | 5.1918 | 5.1949 | 7514556.0 |
| 2009-07-15 11:15:00 | AAPL | Stock | 5.1943 | 5.2096 | 5.1943 | 5.2096 | 8393028.0 |
| 2009-07-15 11:20:00 | AAPL | Stock | 5.2097 | 5.2143 | 5.205 | 5.2125 | 8716316.0 |
| 2009-07-15 11:25:00 | AAPL | Stock | 5.2125 | 5.2168 | 5.2096 | 5.2161 | 9921324.0 |
> showing 50 of 324,739 rows — these rows as CSV