PREVIEW / stock_1min / 2000-03-31
file: by_date/stock_1min/2000/2000-03-31.parquet size: 2.7 MB rows: 231,142 symbols: 934
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-31 09:30:00 | AAPL | Stock | 1.1378 | 1.1384 | 1.1339 | 1.1345 | 2721600.0 |
| 2000-03-31 09:31:00 | AAPL | Stock | 1.1378 | 1.1378 | 1.1339 | 1.1339 | 1848000.0 |
| 2000-03-31 09:32:00 | AAPL | Stock | 1.1339 | 1.1376 | 1.1339 | 1.1376 | 795200.0 |
| 2000-03-31 09:33:00 | AAPL | Stock | 1.1376 | 1.1378 | 1.1306 | 1.1345 | 2676800.0 |
| 2000-03-31 09:34:00 | AAPL | Stock | 1.1317 | 1.1345 | 1.1306 | 1.1345 | 940800.0 |
| 2000-03-31 09:35:00 | AAPL | Stock | 1.1323 | 1.1417 | 1.1317 | 1.1339 | 1937600.0 |
| 2000-03-31 09:36:00 | AAPL | Stock | 1.1417 | 1.1429 | 1.1356 | 1.1417 | 1433600.0 |
| 2000-03-31 09:37:00 | AAPL | Stock | 1.1429 | 1.1507 | 1.1378 | 1.1496 | 1937600.0 |
| 2000-03-31 09:38:00 | AAPL | Stock | 1.1496 | 1.1515 | 1.1373 | 1.1509 | 1702400.0 |
| 2000-03-31 09:39:00 | AAPL | Stock | 1.1509 | 1.1518 | 1.139 | 1.1512 | 1523200.0 |
| 2000-03-31 09:40:00 | AAPL | Stock | 1.1507 | 1.1557 | 1.1507 | 1.1551 | 2228800.0 |
| 2000-03-31 09:41:00 | AAPL | Stock | 1.1554 | 1.1607 | 1.1518 | 1.1607 | 2217600.0 |
| 2000-03-31 09:42:00 | AAPL | Stock | 1.1607 | 1.1652 | 1.1563 | 1.1652 | 3080000.0 |
| 2000-03-31 09:43:00 | AAPL | Stock | 1.1657 | 1.1696 | 1.1607 | 1.1694 | 2520000.0 |
| 2000-03-31 09:44:00 | AAPL | Stock | 1.1694 | 1.1775 | 1.168 | 1.1775 | 1456000.0 |
| 2000-03-31 09:45:00 | AAPL | Stock | 1.1772 | 1.1775 | 1.1696 | 1.1719 | 2307200.0 |
| 2000-03-31 09:46:00 | AAPL | Stock | 1.1741 | 1.1763 | 1.1719 | 1.1752 | 750400.0 |
| 2000-03-31 09:47:00 | AAPL | Stock | 1.1752 | 1.1763 | 1.1741 | 1.1763 | 3964800.0 |
| 2000-03-31 09:48:00 | AAPL | Stock | 1.1763 | 1.1775 | 1.1752 | 1.1752 | 1937600.0 |
| 2000-03-31 09:49:00 | AAPL | Stock | 1.1752 | 1.1763 | 1.1719 | 1.173 | 3281600.0 |
| 2000-03-31 09:50:00 | AAPL | Stock | 1.1696 | 1.1752 | 1.1652 | 1.1674 | 1512000.0 |
| 2000-03-31 09:51:00 | AAPL | Stock | 1.1691 | 1.1719 | 1.1663 | 1.1716 | 1355200.0 |
| 2000-03-31 09:52:00 | AAPL | Stock | 1.1716 | 1.1719 | 1.1652 | 1.1657 | 1276800.0 |
| 2000-03-31 09:53:00 | AAPL | Stock | 1.1652 | 1.1685 | 1.1607 | 1.1618 | 1164800.0 |
| 2000-03-31 09:54:00 | AAPL | Stock | 1.1607 | 1.1696 | 1.1585 | 1.159 | 2038400.0 |
| 2000-03-31 09:55:00 | AAPL | Stock | 1.1574 | 1.1674 | 1.1574 | 1.166 | 1433600.0 |
| 2000-03-31 09:56:00 | AAPL | Stock | 1.1663 | 1.1685 | 1.1635 | 1.1657 | 3628800.0 |
| 2000-03-31 09:57:00 | AAPL | Stock | 1.1663 | 1.1663 | 1.1621 | 1.1638 | 1433600.0 |
| 2000-03-31 09:58:00 | AAPL | Stock | 1.1641 | 1.1663 | 1.1624 | 1.1663 | 2184000.0 |
| 2000-03-31 09:59:00 | AAPL | Stock | 1.1663 | 1.1663 | 1.1563 | 1.1585 | 3494400.0 |
| 2000-03-31 10:00:00 | AAPL | Stock | 1.1652 | 1.1652 | 1.1563 | 1.1629 | 3964800.0 |
| 2000-03-31 10:01:00 | AAPL | Stock | 1.1635 | 1.1663 | 1.1563 | 1.1618 | 716800.0 |
| 2000-03-31 10:02:00 | AAPL | Stock | 1.1638 | 1.1652 | 1.1618 | 1.1646 | 1568000.0 |
| 2000-03-31 10:03:00 | AAPL | Stock | 1.1657 | 1.1674 | 1.1641 | 1.1657 | 2441600.0 |
| 2000-03-31 10:04:00 | AAPL | Stock | 1.1674 | 1.1696 | 1.1641 | 1.168 | 1187200.0 |
| 2000-03-31 10:05:00 | AAPL | Stock | 1.1691 | 1.1691 | 1.1607 | 1.1618 | 806400.0 |
| 2000-03-31 10:06:00 | AAPL | Stock | 1.1624 | 1.1674 | 1.159 | 1.1671 | 1422400.0 |
| 2000-03-31 10:07:00 | AAPL | Stock | 1.1671 | 1.1719 | 1.1671 | 1.1713 | 3102400.0 |
| 2000-03-31 10:08:00 | AAPL | Stock | 1.1708 | 1.173 | 1.1685 | 1.1722 | 2497600.0 |
| 2000-03-31 10:09:00 | AAPL | Stock | 1.1708 | 1.1724 | 1.1702 | 1.1724 | 571200.0 |
| 2000-03-31 10:10:00 | AAPL | Stock | 1.1719 | 1.1735 | 1.1708 | 1.1735 | 1176000.0 |
| 2000-03-31 10:11:00 | AAPL | Stock | 1.1735 | 1.1735 | 1.1702 | 1.171 | 593600.0 |
| 2000-03-31 10:12:00 | AAPL | Stock | 1.1713 | 1.1713 | 1.1696 | 1.1702 | 2452800.0 |
| 2000-03-31 10:13:00 | AAPL | Stock | 1.1696 | 1.1702 | 1.1669 | 1.1674 | 548800.0 |
| 2000-03-31 10:14:00 | AAPL | Stock | 1.1674 | 1.1674 | 1.1624 | 1.1624 | 817600.0 |
| 2000-03-31 10:15:00 | AAPL | Stock | 1.1624 | 1.1629 | 1.1602 | 1.1618 | 1153600.0 |
| 2000-03-31 10:16:00 | AAPL | Stock | 1.1607 | 1.1629 | 1.1607 | 1.1624 | 929600.0 |
| 2000-03-31 10:17:00 | AAPL | Stock | 1.1629 | 1.1629 | 1.1618 | 1.1629 | 537600.0 |
| 2000-03-31 10:18:00 | AAPL | Stock | 1.1629 | 1.1629 | 1.1607 | 1.1607 | 2374400.0 |
| 2000-03-31 10:19:00 | AAPL | Stock | 1.1607 | 1.1613 | 1.1596 | 1.1607 | 481600.0 |
> showing 50 of 231,142 rows — these rows as CSV