PREVIEW / stock_5min / 2009-09-11
file: by_date/stock_5min/2009/2009-09-11.parquet size: 4.6 MB rows: 314,190 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-09-11 06:25:00 | AAPL | Stock | 6.1764 | 6.1764 | 6.1764 | 6.1764 | 2800.0 |
| 2009-09-11 06:50:00 | AAPL | Stock | 6.1764 | 6.1786 | 6.1764 | 6.1786 | 6720.0 |
| 2009-09-11 07:10:00 | AAPL | Stock | 6.1796 | 6.1796 | 6.1796 | 6.1796 | 2800.0 |
| 2009-09-11 07:15:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 39060.0 |
| 2009-09-11 07:30:00 | AAPL | Stock | 6.1782 | 6.1782 | 6.1782 | 6.1782 | 5600.0 |
| 2009-09-11 07:35:00 | AAPL | Stock | 6.1907 | 6.1911 | 6.1907 | 6.1907 | 26600.0 |
| 2009-09-11 07:40:00 | AAPL | Stock | 6.1907 | 6.1939 | 6.1907 | 6.1907 | 36400.0 |
| 2009-09-11 07:55:00 | AAPL | Stock | 6.1929 | 6.1939 | 6.1857 | 6.1857 | 22400.0 |
| 2009-09-11 08:00:00 | AAPL | Stock | 6.1875 | 6.1964 | 6.1857 | 6.1929 | 188972.0 |
| 2009-09-11 08:05:00 | AAPL | Stock | 6.1879 | 6.1886 | 6.1836 | 6.1868 | 47768.0 |
| 2009-09-11 08:10:00 | AAPL | Stock | 6.1868 | 6.1875 | 6.1807 | 6.1807 | 90888.0 |
| 2009-09-11 08:15:00 | AAPL | Stock | 6.1807 | 6.1857 | 6.1807 | 6.1857 | 76328.0 |
| 2009-09-11 08:20:00 | AAPL | Stock | 6.1857 | 6.1875 | 6.1825 | 6.1868 | 92008.0 |
| 2009-09-11 08:25:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1854 | 6.1871 | 94640.0 |
| 2009-09-11 08:30:00 | AAPL | Stock | 6.1843 | 6.1886 | 6.1839 | 6.1854 | 42840.0 |
| 2009-09-11 08:35:00 | AAPL | Stock | 6.1836 | 6.1864 | 6.1825 | 6.1839 | 52668.0 |
| 2009-09-11 08:40:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2009-09-11 08:45:00 | AAPL | Stock | 6.1889 | 6.1904 | 6.1875 | 6.1875 | 61320.0 |
| 2009-09-11 08:50:00 | AAPL | Stock | 6.1871 | 6.1871 | 6.1825 | 6.1825 | 39592.0 |
| 2009-09-11 08:55:00 | AAPL | Stock | 6.1643 | 6.1814 | 6.1643 | 6.1796 | 2051616.0 |
| 2009-09-11 09:00:00 | AAPL | Stock | 6.1804 | 6.1857 | 6.1804 | 6.185 | 245280.0 |
| 2009-09-11 09:05:00 | AAPL | Stock | 6.185 | 6.1875 | 6.1825 | 6.1857 | 191800.0 |
| 2009-09-11 09:10:00 | AAPL | Stock | 6.1857 | 6.1882 | 6.1846 | 6.1875 | 705908.0 |
| 2009-09-11 09:15:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1846 | 6.1871 | 67200.0 |
| 2009-09-11 09:20:00 | AAPL | Stock | 6.1854 | 6.1854 | 6.1821 | 6.1821 | 39200.0 |
| 2009-09-11 09:25:00 | AAPL | Stock | 6.1804 | 6.1814 | 6.1725 | 6.1729 | 240800.0 |
| 2009-09-11 09:30:00 | AAPL | Stock | 6.1754 | 6.185 | 6.1279 | 6.1332 | 15503460.0 |
| 2009-09-11 09:35:00 | AAPL | Stock | 6.1321 | 6.1561 | 6.125 | 6.1321 | 12861884.0 |
| 2009-09-11 09:40:00 | AAPL | Stock | 6.1314 | 6.135 | 6.1121 | 6.1175 | 14297920.0 |
| 2009-09-11 09:45:00 | AAPL | Stock | 6.1171 | 6.1289 | 6.1025 | 6.1214 | 15041908.0 |
| 2009-09-11 09:50:00 | AAPL | Stock | 6.1207 | 6.1346 | 6.1146 | 6.1325 | 8614844.0 |
| 2009-09-11 09:55:00 | AAPL | Stock | 6.1343 | 6.1346 | 6.1186 | 6.1271 | 7432712.0 |
| 2009-09-11 10:00:00 | AAPL | Stock | 6.1279 | 6.1346 | 6.1089 | 6.1164 | 9413684.0 |
| 2009-09-11 10:05:00 | AAPL | Stock | 6.1171 | 6.1339 | 6.1136 | 6.1322 | 7902216.0 |
| 2009-09-11 10:10:00 | AAPL | Stock | 6.1332 | 6.1411 | 6.1225 | 6.1271 | 8904308.0 |
| 2009-09-11 10:15:00 | AAPL | Stock | 6.1271 | 6.1507 | 6.1268 | 6.1479 | 7676452.0 |
| 2009-09-11 10:20:00 | AAPL | Stock | 6.1471 | 6.1643 | 6.1471 | 6.1576 | 8524292.0 |
| 2009-09-11 10:25:00 | AAPL | Stock | 6.1575 | 6.1585 | 6.1489 | 6.1536 | 5162696.0 |
| 2009-09-11 10:30:00 | AAPL | Stock | 6.1543 | 6.1625 | 6.1529 | 6.1589 | 4568256.0 |
| 2009-09-11 10:35:00 | AAPL | Stock | 6.1593 | 6.1743 | 6.158 | 6.1689 | 4821208.0 |
| 2009-09-11 10:40:00 | AAPL | Stock | 6.1696 | 6.1725 | 6.1561 | 6.1564 | 5965736.0 |
| 2009-09-11 10:45:00 | AAPL | Stock | 6.1571 | 6.1607 | 6.1507 | 6.1514 | 3027948.0 |
| 2009-09-11 10:50:00 | AAPL | Stock | 6.1514 | 6.1546 | 6.1454 | 6.1514 | 4034884.0 |
| 2009-09-11 10:55:00 | AAPL | Stock | 6.1518 | 6.1543 | 6.145 | 6.1464 | 3277652.0 |
| 2009-09-11 11:00:00 | AAPL | Stock | 6.1468 | 6.1532 | 6.1429 | 6.1532 | 2799468.0 |
| 2009-09-11 11:05:00 | AAPL | Stock | 6.1528 | 6.1589 | 6.1528 | 6.157 | 2363200.0 |
| 2009-09-11 11:10:00 | AAPL | Stock | 6.1586 | 6.1643 | 6.1568 | 6.1592 | 2867284.0 |
| 2009-09-11 11:15:00 | AAPL | Stock | 6.1586 | 6.1621 | 6.1536 | 6.1546 | 2239160.0 |
| 2009-09-11 11:20:00 | AAPL | Stock | 6.155 | 6.1564 | 6.1507 | 6.1539 | 3678836.0 |
| 2009-09-11 11:25:00 | AAPL | Stock | 6.1539 | 6.1554 | 6.1436 | 6.144 | 4076884.0 |
> showing 50 of 314,190 rows — these rows as CSV