PREVIEW / stock_1min / 2007-03-09
file: by_date/stock_1min/2007/2007-03-09.parquet size: 9.4 MB rows: 771,415 symbols: 2,055
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-09 04:56:00 | AAPL | Stock | 3.1561 | 3.1561 | 3.1561 | 3.1561 | 2800.0 |
| 2007-03-09 07:34:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1518 | 3.1518 | 5600.0 |
| 2007-03-09 07:36:00 | AAPL | Stock | 3.1468 | 3.1518 | 3.1464 | 3.1464 | 142800.0 |
| 2007-03-09 07:59:00 | AAPL | Stock | 3.1514 | 3.1518 | 3.1514 | 3.1518 | 28000.0 |
| 2007-03-09 08:00:00 | AAPL | Stock | 3.1514 | 3.1514 | 3.1514 | 3.1514 | 2800.0 |
| 2007-03-09 08:01:00 | AAPL | Stock | 3.1514 | 3.1518 | 3.1514 | 3.1518 | 14000.0 |
| 2007-03-09 08:03:00 | AAPL | Stock | 3.1511 | 3.1511 | 3.1511 | 3.1511 | 5600.0 |
| 2007-03-09 08:04:00 | AAPL | Stock | 3.1489 | 3.1518 | 3.1486 | 3.1486 | 87360.0 |
| 2007-03-09 08:06:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1475 | 3.1475 | 38360.0 |
| 2007-03-09 08:07:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 56000.0 |
| 2007-03-09 08:08:00 | AAPL | Stock | 3.1464 | 3.1482 | 3.1464 | 3.1482 | 56000.0 |
| 2007-03-09 08:09:00 | AAPL | Stock | 3.1454 | 3.1464 | 3.1446 | 3.1464 | 65100.0 |
| 2007-03-09 08:12:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 5600.0 |
| 2007-03-09 08:14:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 13300.0 |
| 2007-03-09 08:16:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 22400.0 |
| 2007-03-09 08:18:00 | AAPL | Stock | 3.1468 | 3.1468 | 3.1468 | 3.1468 | 3360.0 |
| 2007-03-09 08:21:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 32900.0 |
| 2007-03-09 08:23:00 | AAPL | Stock | 3.1471 | 3.1471 | 3.1471 | 3.1471 | 16800.0 |
| 2007-03-09 08:27:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 25200.0 |
| 2007-03-09 08:28:00 | AAPL | Stock | 3.1454 | 3.1454 | 3.145 | 3.145 | 14000.0 |
| 2007-03-09 08:30:00 | AAPL | Stock | 3.1461 | 3.1554 | 3.1461 | 3.1554 | 351820.0 |
| 2007-03-09 08:31:00 | AAPL | Stock | 3.1536 | 3.1596 | 3.1518 | 3.1571 | 399812.0 |
| 2007-03-09 08:32:00 | AAPL | Stock | 3.1571 | 3.1639 | 3.1557 | 3.1639 | 218400.0 |
| 2007-03-09 08:33:00 | AAPL | Stock | 3.1636 | 3.1654 | 3.1621 | 3.1625 | 456400.0 |
| 2007-03-09 08:34:00 | AAPL | Stock | 3.1618 | 3.1679 | 3.1618 | 3.1661 | 308000.0 |
| 2007-03-09 08:35:00 | AAPL | Stock | 3.1671 | 3.1675 | 3.1636 | 3.1636 | 254100.0 |
| 2007-03-09 08:36:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1596 | 3.1596 | 188300.0 |
| 2007-03-09 08:37:00 | AAPL | Stock | 3.1596 | 3.1643 | 3.1596 | 3.1607 | 72800.0 |
| 2007-03-09 08:38:00 | AAPL | Stock | 3.1618 | 3.1625 | 3.1607 | 3.1611 | 255976.0 |
| 2007-03-09 08:39:00 | AAPL | Stock | 3.1607 | 3.1639 | 3.1607 | 3.1607 | 57400.0 |
| 2007-03-09 08:40:00 | AAPL | Stock | 3.1639 | 3.1639 | 3.1596 | 3.1596 | 258776.0 |
| 2007-03-09 08:41:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 28000.0 |
| 2007-03-09 08:42:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1593 | 3.1596 | 111300.0 |
| 2007-03-09 08:43:00 | AAPL | Stock | 3.1596 | 3.1639 | 3.1593 | 3.1629 | 177520.0 |
| 2007-03-09 08:44:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1589 | 3.1607 | 195300.0 |
| 2007-03-09 08:45:00 | AAPL | Stock | 3.1607 | 3.1625 | 3.1607 | 3.1625 | 140980.0 |
| 2007-03-09 08:46:00 | AAPL | Stock | 3.1625 | 3.1629 | 3.1625 | 3.1625 | 50400.0 |
| 2007-03-09 08:47:00 | AAPL | Stock | 3.1625 | 3.1639 | 3.1625 | 3.1639 | 110320.0 |
| 2007-03-09 08:48:00 | AAPL | Stock | 3.1636 | 3.1639 | 3.1636 | 3.1639 | 63000.0 |
| 2007-03-09 08:49:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1643 | 3.1643 | 8400.0 |
| 2007-03-09 08:51:00 | AAPL | Stock | 3.1639 | 3.1639 | 3.1639 | 3.1639 | 20104.0 |
| 2007-03-09 08:53:00 | AAPL | Stock | 3.1639 | 3.1639 | 3.1639 | 3.1639 | 14000.0 |
| 2007-03-09 08:54:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1625 | 3.1625 | 16800.0 |
| 2007-03-09 08:55:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1625 | 3.1625 | 11200.0 |
| 2007-03-09 08:56:00 | AAPL | Stock | 3.1629 | 3.1632 | 3.1618 | 3.1632 | 11900.0 |
| 2007-03-09 08:57:00 | AAPL | Stock | 3.1625 | 3.1643 | 3.1614 | 3.1643 | 182000.0 |
| 2007-03-09 08:58:00 | AAPL | Stock | 3.1621 | 3.1621 | 3.1621 | 3.1621 | 28000.0 |
| 2007-03-09 08:59:00 | AAPL | Stock | 3.1639 | 3.1643 | 3.1639 | 3.1639 | 123200.0 |
| 2007-03-09 09:00:00 | AAPL | Stock | 3.1639 | 3.1643 | 3.1629 | 3.1643 | 110320.0 |
| 2007-03-09 09:01:00 | AAPL | Stock | 3.1639 | 3.1643 | 3.1639 | 3.1643 | 36400.0 |
> showing 50 of 771,415 rows — these rows as CSV