PREVIEW / stock_1min / 2007-12-31
file: by_date/stock_1min/2007/2007-12-31.parquet size: 12.5 MB rows: 1,026,444 symbols: 2,685
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-12-31 07:25:00 | AAPL | Stock | 7.1379 | 7.1379 | 7.1379 | 7.1379 | 2800.0 |
| 2007-12-31 07:57:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 28000.0 |
| 2007-12-31 08:00:00 | AAPL | Stock | 7.1429 | 7.1607 | 7.1429 | 7.1607 | 119700.0 |
| 2007-12-31 08:01:00 | AAPL | Stock | 7.1604 | 7.1693 | 7.1604 | 7.1679 | 271488.0 |
| 2007-12-31 08:02:00 | AAPL | Stock | 7.1632 | 7.1696 | 7.1618 | 7.1643 | 327600.0 |
| 2007-12-31 08:03:00 | AAPL | Stock | 7.1654 | 7.1675 | 7.1625 | 7.1675 | 274120.0 |
| 2007-12-31 08:04:00 | AAPL | Stock | 7.1675 | 7.1679 | 7.1675 | 7.1679 | 49980.0 |
| 2007-12-31 08:05:00 | AAPL | Stock | 7.1679 | 7.1679 | 7.1636 | 7.1675 | 103600.0 |
| 2007-12-31 08:06:00 | AAPL | Stock | 7.1679 | 7.1679 | 7.1679 | 7.1679 | 23800.0 |
| 2007-12-31 08:07:00 | AAPL | Stock | 7.1679 | 7.1679 | 7.1646 | 7.1646 | 19600.0 |
| 2007-12-31 08:08:00 | AAPL | Stock | 7.1654 | 7.1679 | 7.1629 | 7.1632 | 112700.0 |
| 2007-12-31 08:09:00 | AAPL | Stock | 7.1625 | 7.1632 | 7.1607 | 7.1607 | 49112.0 |
| 2007-12-31 08:10:00 | AAPL | Stock | 7.1625 | 7.1646 | 7.1607 | 7.1636 | 44100.0 |
| 2007-12-31 08:11:00 | AAPL | Stock | 7.1611 | 7.1643 | 7.1611 | 7.1643 | 30884.0 |
| 2007-12-31 08:12:00 | AAPL | Stock | 7.1643 | 7.165 | 7.1629 | 7.165 | 42000.0 |
| 2007-12-31 08:13:00 | AAPL | Stock | 7.165 | 7.165 | 7.165 | 7.165 | 5600.0 |
| 2007-12-31 08:14:00 | AAPL | Stock | 7.1643 | 7.1654 | 7.1625 | 7.1625 | 105616.0 |
| 2007-12-31 08:15:00 | AAPL | Stock | 7.1625 | 7.1625 | 7.1554 | 7.1554 | 53200.0 |
| 2007-12-31 08:16:00 | AAPL | Stock | 7.1554 | 7.1554 | 7.1554 | 7.1554 | 14000.0 |
| 2007-12-31 08:17:00 | AAPL | Stock | 7.1557 | 7.1607 | 7.1557 | 7.1607 | 61600.0 |
| 2007-12-31 08:18:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1604 | 7.1604 | 32200.0 |
| 2007-12-31 08:19:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1607 | 7.1607 | 3920.0 |
| 2007-12-31 08:20:00 | AAPL | Stock | 7.1582 | 7.1582 | 7.1582 | 7.1582 | 21000.0 |
| 2007-12-31 08:21:00 | AAPL | Stock | 7.1596 | 7.1596 | 7.1596 | 7.1596 | 14000.0 |
| 2007-12-31 08:22:00 | AAPL | Stock | 7.1596 | 7.1629 | 7.1596 | 7.1614 | 229544.0 |
| 2007-12-31 08:23:00 | AAPL | Stock | 7.1611 | 7.1639 | 7.1607 | 7.1639 | 120400.0 |
| 2007-12-31 08:24:00 | AAPL | Stock | 7.1611 | 7.1625 | 7.1607 | 7.1625 | 71400.0 |
| 2007-12-31 08:25:00 | AAPL | Stock | 7.1607 | 7.1611 | 7.1607 | 7.1607 | 46200.0 |
| 2007-12-31 08:26:00 | AAPL | Stock | 7.1604 | 7.1611 | 7.1604 | 7.1607 | 35168.0 |
| 2007-12-31 08:27:00 | AAPL | Stock | 7.1575 | 7.1589 | 7.1575 | 7.1579 | 26600.0 |
| 2007-12-31 08:28:00 | AAPL | Stock | 7.1554 | 7.1621 | 7.1554 | 7.1621 | 210560.0 |
| 2007-12-31 08:29:00 | AAPL | Stock | 7.1604 | 7.1607 | 7.1604 | 7.1607 | 39368.0 |
| 2007-12-31 08:30:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1607 | 7.1607 | 16968.0 |
| 2007-12-31 08:31:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1582 | 7.1582 | 9800.0 |
| 2007-12-31 08:32:00 | AAPL | Stock | 7.1564 | 7.1604 | 7.1557 | 7.1557 | 184800.0 |
| 2007-12-31 08:33:00 | AAPL | Stock | 7.1543 | 7.1543 | 7.1482 | 7.1482 | 31500.0 |
| 2007-12-31 08:34:00 | AAPL | Stock | 7.1539 | 7.1543 | 7.1429 | 7.1539 | 154980.0 |
| 2007-12-31 08:35:00 | AAPL | Stock | 7.1482 | 7.1482 | 7.1446 | 7.1446 | 26320.0 |
| 2007-12-31 08:37:00 | AAPL | Stock | 7.1493 | 7.1496 | 7.1482 | 7.1482 | 33600.0 |
| 2007-12-31 08:38:00 | AAPL | Stock | 7.1504 | 7.1507 | 7.1504 | 7.1507 | 7000.0 |
| 2007-12-31 08:39:00 | AAPL | Stock | 7.1511 | 7.1511 | 7.1511 | 7.1511 | 14000.0 |
| 2007-12-31 08:40:00 | AAPL | Stock | 7.15 | 7.15 | 7.15 | 7.15 | 14000.0 |
| 2007-12-31 08:41:00 | AAPL | Stock | 7.1493 | 7.1493 | 7.1479 | 7.1479 | 25200.0 |
| 2007-12-31 08:42:00 | AAPL | Stock | 7.1504 | 7.1504 | 7.1504 | 7.1504 | 8400.0 |
| 2007-12-31 08:43:00 | AAPL | Stock | 7.1493 | 7.1493 | 7.1479 | 7.1479 | 13888.0 |
| 2007-12-31 08:45:00 | AAPL | Stock | 7.15 | 7.1514 | 7.15 | 7.1514 | 42000.0 |
| 2007-12-31 08:47:00 | AAPL | Stock | 7.1482 | 7.1482 | 7.1482 | 7.1482 | 15400.0 |
| 2007-12-31 08:49:00 | AAPL | Stock | 7.1482 | 7.1482 | 7.1468 | 7.1468 | 30940.0 |
| 2007-12-31 08:50:00 | AAPL | Stock | 7.1468 | 7.1482 | 7.1432 | 7.1482 | 66080.0 |
| 2007-12-31 08:51:00 | AAPL | Stock | 7.1482 | 7.1482 | 7.1479 | 7.1479 | 8400.0 |
> showing 50 of 1,026,444 rows — these rows as CSV