PREVIEW / stock_1min / 2007-03-07
file: by_date/stock_1min/2007/2007-03-07.parquet size: 9.9 MB rows: 801,422 symbols: 2,063
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-03-07 09:25:00 | AAPL | Stock | 3.1429 | 3.1461 | 3.1429 | 3.1461 | 70700.0 |
| 2007-03-07 09:26:00 | AAPL | Stock | 3.1429 | 3.1464 | 3.1429 | 3.1464 | 198240.0 |
| 2007-03-07 09:27:00 | AAPL | Stock | 3.1457 | 3.1464 | 3.145 | 3.145 | 63000.0 |
| 2007-03-07 09:28:00 | AAPL | Stock | 3.1443 | 3.1443 | 3.1429 | 3.1429 | 50120.0 |
| 2007-03-07 09:29:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1429 | 3.1429 | 225400.0 |
| 2007-03-07 09:30:00 | AAPL | Stock | 3.1446 | 3.1518 | 3.1418 | 3.15 | 6097140.0 |
| 2007-03-07 09:31:00 | AAPL | Stock | 3.1496 | 3.1496 | 3.1393 | 3.1421 | 3444420.0 |
| 2007-03-07 09:32:00 | AAPL | Stock | 3.1418 | 3.1475 | 3.1418 | 3.1473 | 2320472.0 |
| 2007-03-07 09:33:00 | AAPL | Stock | 3.1471 | 3.1554 | 3.1432 | 3.1554 | 3321108.0 |
| 2007-03-07 09:34:00 | AAPL | Stock | 3.1554 | 3.1591 | 3.1479 | 3.1579 | 4827788.0 |
| 2007-03-07 09:35:00 | AAPL | Stock | 3.1579 | 3.1596 | 3.155 | 3.1564 | 4709180.0 |
| 2007-03-07 09:36:00 | AAPL | Stock | 3.1568 | 3.1632 | 3.1561 | 3.1561 | 4981760.0 |
| 2007-03-07 09:37:00 | AAPL | Stock | 3.1568 | 3.1593 | 3.1518 | 3.1564 | 3089548.0 |
| 2007-03-07 09:38:00 | AAPL | Stock | 3.1564 | 3.1575 | 3.1529 | 3.1529 | 2316636.0 |
| 2007-03-07 09:39:00 | AAPL | Stock | 3.1525 | 3.1536 | 3.1468 | 3.1518 | 3783052.0 |
| 2007-03-07 09:40:00 | AAPL | Stock | 3.1514 | 3.1596 | 3.1496 | 3.1596 | 3401020.0 |
| 2007-03-07 09:41:00 | AAPL | Stock | 3.1579 | 3.1596 | 3.1514 | 3.1521 | 2988188.0 |
| 2007-03-07 09:42:00 | AAPL | Stock | 3.1524 | 3.1571 | 3.1521 | 3.1554 | 1824116.0 |
| 2007-03-07 09:43:00 | AAPL | Stock | 3.1554 | 3.1561 | 3.15 | 3.1539 | 2546656.0 |
| 2007-03-07 09:44:00 | AAPL | Stock | 3.1546 | 3.1554 | 3.1521 | 3.1529 | 1598100.0 |
| 2007-03-07 09:45:00 | AAPL | Stock | 3.1528 | 3.155 | 3.1514 | 3.155 | 3120348.0 |
| 2007-03-07 09:46:00 | AAPL | Stock | 3.1546 | 3.1693 | 3.1543 | 3.1656 | 6910260.0 |
| 2007-03-07 09:47:00 | AAPL | Stock | 3.1671 | 3.1775 | 3.1639 | 3.1725 | 7126420.0 |
| 2007-03-07 09:48:00 | AAPL | Stock | 3.1721 | 3.1771 | 3.1679 | 3.1725 | 4705036.0 |
| 2007-03-07 09:49:00 | AAPL | Stock | 3.1725 | 3.1757 | 3.1696 | 3.1725 | 3564484.0 |
| 2007-03-07 09:50:00 | AAPL | Stock | 3.1721 | 3.1739 | 3.1654 | 3.1657 | 4276384.0 |
| 2007-03-07 09:51:00 | AAPL | Stock | 3.1671 | 3.1693 | 3.1646 | 3.1654 | 3783248.0 |
| 2007-03-07 09:52:00 | AAPL | Stock | 3.1654 | 3.1689 | 3.1646 | 3.1675 | 2432248.0 |
| 2007-03-07 09:53:00 | AAPL | Stock | 3.1675 | 3.17 | 3.1646 | 3.1661 | 3300808.0 |
| 2007-03-07 09:54:00 | AAPL | Stock | 3.1661 | 3.1686 | 3.1611 | 3.1637 | 2485476.0 |
| 2007-03-07 09:55:00 | AAPL | Stock | 3.1611 | 3.1636 | 3.1571 | 3.1582 | 3126592.0 |
| 2007-03-07 09:56:00 | AAPL | Stock | 3.1579 | 3.1596 | 3.1514 | 3.155 | 3992072.0 |
| 2007-03-07 09:57:00 | AAPL | Stock | 3.1547 | 3.1586 | 3.1514 | 3.1557 | 3135804.0 |
| 2007-03-07 09:58:00 | AAPL | Stock | 3.1554 | 3.1589 | 3.1554 | 3.1568 | 2859052.0 |
| 2007-03-07 09:59:00 | AAPL | Stock | 3.1568 | 3.1589 | 3.1564 | 3.1589 | 2225272.0 |
| 2007-03-07 10:00:00 | AAPL | Stock | 3.1589 | 3.1632 | 3.1579 | 3.1586 | 3312960.0 |
| 2007-03-07 10:01:00 | AAPL | Stock | 3.1586 | 3.1607 | 3.155 | 3.1607 | 3695524.0 |
| 2007-03-07 10:02:00 | AAPL | Stock | 3.1607 | 3.1632 | 3.1571 | 3.1589 | 2202368.0 |
| 2007-03-07 10:03:00 | AAPL | Stock | 3.1596 | 3.165 | 3.1589 | 3.1628 | 1629012.0 |
| 2007-03-07 10:04:00 | AAPL | Stock | 3.1632 | 3.1664 | 3.1618 | 3.1618 | 2099524.0 |
| 2007-03-07 10:05:00 | AAPL | Stock | 3.1621 | 3.1621 | 3.1564 | 3.1579 | 1811180.0 |
| 2007-03-07 10:06:00 | AAPL | Stock | 3.1579 | 3.1629 | 3.1561 | 3.1618 | 2140068.0 |
| 2007-03-07 10:07:00 | AAPL | Stock | 3.16 | 3.1621 | 3.1589 | 3.1596 | 1483972.0 |
| 2007-03-07 10:08:00 | AAPL | Stock | 3.1593 | 3.16 | 3.1561 | 3.16 | 2239216.0 |
| 2007-03-07 10:09:00 | AAPL | Stock | 3.16 | 3.1625 | 3.1575 | 3.1586 | 1570268.0 |
| 2007-03-07 10:10:00 | AAPL | Stock | 3.1586 | 3.1611 | 3.1579 | 3.1596 | 1422204.0 |
| 2007-03-07 10:11:00 | AAPL | Stock | 3.16 | 3.1632 | 3.1596 | 3.1607 | 2649164.0 |
| 2007-03-07 10:12:00 | AAPL | Stock | 3.1611 | 3.1654 | 3.161 | 3.1636 | 1822744.0 |
| 2007-03-07 10:13:00 | AAPL | Stock | 3.1636 | 3.1636 | 3.1593 | 3.1607 | 964740.0 |
| 2007-03-07 10:14:00 | AAPL | Stock | 3.161 | 3.1632 | 3.1607 | 3.1614 | 640528.0 |
> showing 50 of 801,422 rows — these rows as CSV