PREVIEW / stock_1min / 2007-03-12
file: by_date/stock_1min/2007/2007-03-12.parquet size: 9.0 MB rows: 727,050 symbols: 2,060
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-12 05:06:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 8400.0 |
| 2007-03-12 07:05:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 56000.0 |
| 2007-03-12 07:46:00 | AAPL | Stock | 3.1625 | 3.1696 | 3.1625 | 3.1696 | 285600.0 |
| 2007-03-12 07:50:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1643 | 3.1643 | 16800.0 |
| 2007-03-12 07:51:00 | AAPL | Stock | 3.1661 | 3.1693 | 3.1661 | 3.1693 | 53200.0 |
| 2007-03-12 07:52:00 | AAPL | Stock | 3.1682 | 3.1682 | 3.1682 | 3.1682 | 22400.0 |
| 2007-03-12 07:53:00 | AAPL | Stock | 3.1686 | 3.1686 | 3.1686 | 3.1686 | 42000.0 |
| 2007-03-12 07:55:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1643 | 3.1643 | 75600.0 |
| 2007-03-12 08:00:00 | AAPL | Stock | 3.1589 | 3.1607 | 3.1575 | 3.1575 | 60480.0 |
| 2007-03-12 08:01:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 179480.0 |
| 2007-03-12 08:02:00 | AAPL | Stock | 3.1589 | 3.1589 | 3.1589 | 3.1589 | 63588.0 |
| 2007-03-12 08:03:00 | AAPL | Stock | 3.1589 | 3.1589 | 3.1589 | 3.1589 | 58800.0 |
| 2007-03-12 08:06:00 | AAPL | Stock | 3.1564 | 3.1564 | 3.1564 | 3.1564 | 103600.0 |
| 2007-03-12 08:07:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1518 | 3.1518 | 67200.0 |
| 2007-03-12 08:11:00 | AAPL | Stock | 3.1529 | 3.1529 | 3.1529 | 3.1529 | 4200.0 |
| 2007-03-12 08:12:00 | AAPL | Stock | 3.1532 | 3.1532 | 3.1532 | 3.1532 | 56000.0 |
| 2007-03-12 08:14:00 | AAPL | Stock | 3.1521 | 3.1521 | 3.15 | 3.15 | 107800.0 |
| 2007-03-12 08:16:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1489 | 3.1489 | 14000.0 |
| 2007-03-12 08:25:00 | AAPL | Stock | 3.15 | 3.15 | 3.15 | 3.15 | 8400.0 |
| 2007-03-12 08:28:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 47600.0 |
| 2007-03-12 08:29:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 19600.0 |
| 2007-03-12 08:30:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 15820.0 |
| 2007-03-12 08:31:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 29540.0 |
| 2007-03-12 08:32:00 | AAPL | Stock | 3.1432 | 3.1432 | 3.1432 | 3.1432 | 83300.0 |
| 2007-03-12 08:45:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 78400.0 |
| 2007-03-12 08:53:00 | AAPL | Stock | 3.1432 | 3.1432 | 3.1414 | 3.1429 | 28700.0 |
| 2007-03-12 08:55:00 | AAPL | Stock | 3.1457 | 3.1457 | 3.1457 | 3.1457 | 18032.0 |
| 2007-03-12 08:57:00 | AAPL | Stock | 3.1475 | 3.1479 | 3.1475 | 3.1475 | 68600.0 |
| 2007-03-12 08:58:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1475 | 3.1475 | 14000.0 |
| 2007-03-12 08:59:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1475 | 3.1475 | 5600.0 |
| 2007-03-12 09:07:00 | AAPL | Stock | 3.145 | 3.145 | 3.1429 | 3.1429 | 134820.0 |
| 2007-03-12 09:10:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 11200.0 |
| 2007-03-12 09:13:00 | AAPL | Stock | 3.1436 | 3.1436 | 3.1436 | 3.1436 | 14000.0 |
| 2007-03-12 09:14:00 | AAPL | Stock | 3.1436 | 3.1436 | 3.1429 | 3.1429 | 49000.0 |
| 2007-03-12 09:15:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 14140.0 |
| 2007-03-12 09:18:00 | AAPL | Stock | 3.1404 | 3.1404 | 3.14 | 3.14 | 33600.0 |
| 2007-03-12 09:22:00 | AAPL | Stock | 3.1407 | 3.1411 | 3.1407 | 3.1411 | 16800.0 |
| 2007-03-12 09:23:00 | AAPL | Stock | 3.1407 | 3.1414 | 3.1407 | 3.1414 | 56000.0 |
| 2007-03-12 09:24:00 | AAPL | Stock | 3.1411 | 3.1411 | 3.1411 | 3.1411 | 28000.0 |
| 2007-03-12 09:25:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 19600.0 |
| 2007-03-12 09:27:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 10360.0 |
| 2007-03-12 09:29:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1429 | 3.1429 | 39200.0 |
| 2007-03-12 09:30:00 | AAPL | Stock | 3.1429 | 3.1546 | 3.1425 | 3.1479 | 4153940.0 |
| 2007-03-12 09:31:00 | AAPL | Stock | 3.1493 | 3.1529 | 3.1486 | 3.1496 | 1904392.0 |
| 2007-03-12 09:32:00 | AAPL | Stock | 3.1496 | 3.1546 | 3.1493 | 3.1546 | 1550892.0 |
| 2007-03-12 09:33:00 | AAPL | Stock | 3.1539 | 3.1586 | 3.1539 | 3.1579 | 2912812.0 |
| 2007-03-12 09:34:00 | AAPL | Stock | 3.1582 | 3.1632 | 3.1582 | 3.1632 | 2955036.0 |
| 2007-03-12 09:35:00 | AAPL | Stock | 3.1629 | 3.1632 | 3.1579 | 3.1614 | 3227448.0 |
| 2007-03-12 09:36:00 | AAPL | Stock | 3.1614 | 3.1696 | 3.16 | 3.1693 | 4128656.0 |
| 2007-03-12 09:37:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.165 | 3.1675 | 2226672.0 |
> showing 50 of 727,050 rows — these rows as CSV