PREVIEW / stock_1min / 2010-09-07
file: by_date/stock_1min/2010/2010-09-07.parquet size: 12.0 MB rows: 924,118 symbols: 2,810
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-09-07 04:07:00 | AAPL | Stock | 9.1782 | 9.1782 | 9.1782 | 9.1782 | 2800.0 |
| 2010-09-07 04:15:00 | AAPL | Stock | 9.1518 | 9.1518 | 9.1468 | 9.1468 | 16800.0 |
| 2010-09-07 04:22:00 | AAPL | Stock | 9.1468 | 9.1468 | 9.1468 | 9.1468 | 2800.0 |
| 2010-09-07 04:25:00 | AAPL | Stock | 9.1468 | 9.1468 | 9.1468 | 9.1468 | 5600.0 |
| 2010-09-07 04:28:00 | AAPL | Stock | 9.15 | 9.1604 | 9.1343 | 9.1343 | 14000.0 |
| 2010-09-07 04:29:00 | AAPL | Stock | 9.1343 | 9.1343 | 9.1343 | 9.1343 | 11200.0 |
| 2010-09-07 04:38:00 | AAPL | Stock | 9.1271 | 9.1271 | 9.1271 | 9.1271 | 2800.0 |
| 2010-09-07 04:56:00 | AAPL | Stock | 9.1286 | 9.1714 | 9.1286 | 9.1714 | 37800.0 |
| 2010-09-07 05:02:00 | AAPL | Stock | 9.1286 | 9.1286 | 9.1286 | 9.1286 | 4200.0 |
| 2010-09-07 05:03:00 | AAPL | Stock | 9.1286 | 9.1286 | 9.1286 | 9.1286 | 4200.0 |
| 2010-09-07 05:52:00 | AAPL | Stock | 9.1571 | 9.1571 | 9.1571 | 9.1571 | 2800.0 |
| 2010-09-07 06:02:00 | AAPL | Stock | 9.1446 | 9.1446 | 9.1268 | 9.1268 | 14000.0 |
| 2010-09-07 06:11:00 | AAPL | Stock | 9.1336 | 9.1346 | 9.1336 | 9.1346 | 19600.0 |
| 2010-09-07 06:12:00 | AAPL | Stock | 9.1346 | 9.1346 | 9.1346 | 9.1346 | 8400.0 |
| 2010-09-07 06:13:00 | AAPL | Stock | 9.1346 | 9.1346 | 9.1346 | 9.1346 | 25200.0 |
| 2010-09-07 06:28:00 | AAPL | Stock | 9.1518 | 9.1518 | 9.1518 | 9.1518 | 11200.0 |
| 2010-09-07 06:29:00 | AAPL | Stock | 9.1518 | 9.1639 | 9.1518 | 9.1639 | 13860.0 |
| 2010-09-07 06:30:00 | AAPL | Stock | 9.1639 | 9.1639 | 9.1639 | 9.1639 | 2800.0 |
| 2010-09-07 06:32:00 | AAPL | Stock | 9.1589 | 9.1589 | 9.1518 | 9.1589 | 16800.0 |
| 2010-09-07 06:35:00 | AAPL | Stock | 9.1521 | 9.1521 | 9.1521 | 9.1521 | 2800.0 |
| 2010-09-07 06:44:00 | AAPL | Stock | 9.1639 | 9.1639 | 9.1639 | 9.1639 | 14000.0 |
| 2010-09-07 06:45:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1607 | 9.1607 | 2800.0 |
| 2010-09-07 06:48:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1607 | 9.1607 | 14000.0 |
| 2010-09-07 06:58:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 8400.0 |
| 2010-09-07 06:59:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 6020.0 |
| 2010-09-07 07:01:00 | AAPL | Stock | 9.1714 | 9.1714 | 9.1714 | 9.1714 | 8400.0 |
| 2010-09-07 07:02:00 | AAPL | Stock | 9.1714 | 9.1714 | 9.1714 | 9.1714 | 7000.0 |
| 2010-09-07 07:03:00 | AAPL | Stock | 9.1739 | 9.1782 | 9.1739 | 9.1782 | 14000.0 |
| 2010-09-07 07:06:00 | AAPL | Stock | 9.1661 | 9.1782 | 9.1607 | 9.1782 | 46760.0 |
| 2010-09-07 07:07:00 | AAPL | Stock | 9.1782 | 9.1782 | 9.1782 | 9.1782 | 5600.0 |
| 2010-09-07 07:09:00 | AAPL | Stock | 9.1779 | 9.1782 | 9.1779 | 9.1782 | 16800.0 |
| 2010-09-07 07:15:00 | AAPL | Stock | 9.1754 | 9.1754 | 9.1754 | 9.1754 | 5600.0 |
| 2010-09-07 07:16:00 | AAPL | Stock | 9.1754 | 9.1754 | 9.1754 | 9.1754 | 6664.0 |
| 2010-09-07 07:22:00 | AAPL | Stock | 9.1839 | 9.1839 | 9.1839 | 9.1839 | 2800.0 |
| 2010-09-07 07:23:00 | AAPL | Stock | 9.1961 | 9.1961 | 9.1896 | 9.1896 | 19264.0 |
| 2010-09-07 07:26:00 | AAPL | Stock | 9.1864 | 9.1864 | 9.1857 | 9.1857 | 141400.0 |
| 2010-09-07 07:32:00 | AAPL | Stock | 9.1839 | 9.1839 | 9.1839 | 9.1839 | 5600.0 |
| 2010-09-07 07:40:00 | AAPL | Stock | 9.1761 | 9.1761 | 9.1761 | 9.1761 | 4200.0 |
| 2010-09-07 07:44:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.1857 | 9.1857 | 5600.0 |
| 2010-09-07 07:46:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 5600.0 |
| 2010-09-07 07:48:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-09-07 07:58:00 | AAPL | Stock | 9.1875 | 9.1875 | 9.1875 | 9.1875 | 5600.0 |
| 2010-09-07 07:59:00 | AAPL | Stock | 9.1921 | 9.1929 | 9.1921 | 9.1929 | 10080.0 |
| 2010-09-07 08:00:00 | AAPL | Stock | 9.1918 | 9.2036 | 9.1857 | 9.1879 | 66836.0 |
| 2010-09-07 08:01:00 | AAPL | Stock | 9.1875 | 9.2 | 9.1875 | 9.2 | 33600.0 |
| 2010-09-07 08:02:00 | AAPL | Stock | 9.1964 | 9.1964 | 9.1964 | 9.1964 | 5600.0 |
| 2010-09-07 08:03:00 | AAPL | Stock | 9.1946 | 9.2029 | 9.1946 | 9.1975 | 129220.0 |
| 2010-09-07 08:04:00 | AAPL | Stock | 9.2007 | 9.2054 | 9.1982 | 9.2054 | 33600.0 |
| 2010-09-07 08:05:00 | AAPL | Stock | 9.2036 | 9.2096 | 9.2036 | 9.2096 | 72520.0 |
| 2010-09-07 08:06:00 | AAPL | Stock | 9.21 | 9.21 | 9.2071 | 9.2071 | 14000.0 |
> showing 50 of 924,118 rows — these rows as CSV