PREVIEW / stock_5min / 2000-04-10
file: by_date/stock_5min/2000/2000-04-10.parquet size: 1.2 MB rows: 86,763 symbols: 1,157
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-04-10 09:30:00 | AAPL | Stock | 1.1758 | 1.1758 | 1.1641 | 1.1646 | 5174400.0 |
| 2000-04-10 09:35:00 | AAPL | Stock | 1.1641 | 1.1696 | 1.1607 | 1.1618 | 4379200.0 |
| 2000-04-10 09:40:00 | AAPL | Stock | 1.1618 | 1.1618 | 1.1512 | 1.1529 | 6484800.0 |
| 2000-04-10 09:45:00 | AAPL | Stock | 1.1518 | 1.1563 | 1.1451 | 1.156 | 2844800.0 |
| 2000-04-10 09:50:00 | AAPL | Stock | 1.1563 | 1.1571 | 1.1451 | 1.1563 | 2072000.0 |
| 2000-04-10 09:55:00 | AAPL | Stock | 1.1546 | 1.1652 | 1.1507 | 1.1652 | 3248000.0 |
| 2000-04-10 10:00:00 | AAPL | Stock | 1.1635 | 1.1685 | 1.1563 | 1.1646 | 3001600.0 |
| 2000-04-10 10:05:00 | AAPL | Stock | 1.1652 | 1.1685 | 1.1585 | 1.1685 | 2878400.0 |
| 2000-04-10 10:10:00 | AAPL | Stock | 1.1657 | 1.1713 | 1.1641 | 1.1696 | 3830400.0 |
| 2000-04-10 10:15:00 | AAPL | Stock | 1.1685 | 1.1853 | 1.1685 | 1.1842 | 6484800.0 |
| 2000-04-10 10:20:00 | AAPL | Stock | 1.183 | 1.1842 | 1.1674 | 1.1694 | 3270400.0 |
| 2000-04-10 10:25:00 | AAPL | Stock | 1.1674 | 1.1702 | 1.1535 | 1.1535 | 5264000.0 |
| 2000-04-10 10:30:00 | AAPL | Stock | 1.154 | 1.1618 | 1.1529 | 1.1613 | 2654400.0 |
| 2000-04-10 10:35:00 | AAPL | Stock | 1.1618 | 1.1618 | 1.1579 | 1.1618 | 5432000.0 |
| 2000-04-10 10:40:00 | AAPL | Stock | 1.1616 | 1.1663 | 1.154 | 1.1585 | 8030400.0 |
| 2000-04-10 10:45:00 | AAPL | Stock | 1.1604 | 1.1629 | 1.1518 | 1.1568 | 3416000.0 |
| 2000-04-10 10:50:00 | AAPL | Stock | 1.1563 | 1.1618 | 1.1557 | 1.1618 | 2172800.0 |
| 2000-04-10 10:55:00 | AAPL | Stock | 1.1618 | 1.1652 | 1.1596 | 1.1607 | 1926400.0 |
| 2000-04-10 11:00:00 | AAPL | Stock | 1.1602 | 1.1685 | 1.159 | 1.159 | 4491200.0 |
| 2000-04-10 11:05:00 | AAPL | Stock | 1.159 | 1.1671 | 1.1585 | 1.1618 | 2609600.0 |
| 2000-04-10 11:10:00 | AAPL | Stock | 1.1618 | 1.1641 | 1.1613 | 1.1629 | 1019200.0 |
| 2000-04-10 11:15:00 | AAPL | Stock | 1.1629 | 1.1641 | 1.1618 | 1.1641 | 470400.0 |
| 2000-04-10 11:20:00 | AAPL | Stock | 1.1629 | 1.1629 | 1.1574 | 1.1574 | 1355200.0 |
| 2000-04-10 11:25:00 | AAPL | Stock | 1.1596 | 1.1596 | 1.1551 | 1.1551 | 2452800.0 |
| 2000-04-10 11:30:00 | AAPL | Stock | 1.1557 | 1.1624 | 1.1551 | 1.159 | 2833600.0 |
| 2000-04-10 11:35:00 | AAPL | Stock | 1.159 | 1.1607 | 1.1585 | 1.1596 | 246400.0 |
| 2000-04-10 11:40:00 | AAPL | Stock | 1.1602 | 1.161 | 1.1596 | 1.1607 | 828800.0 |
| 2000-04-10 11:45:00 | AAPL | Stock | 1.1607 | 1.1702 | 1.1607 | 1.1652 | 2396800.0 |
| 2000-04-10 11:50:00 | AAPL | Stock | 1.1652 | 1.168 | 1.1646 | 1.1646 | 515200.0 |
| 2000-04-10 11:55:00 | AAPL | Stock | 1.1646 | 1.1652 | 1.1624 | 1.1624 | 873600.0 |
| 2000-04-10 12:00:00 | AAPL | Stock | 1.1624 | 1.1624 | 1.1607 | 1.1607 | 1008000.0 |
| 2000-04-10 12:05:00 | AAPL | Stock | 1.1618 | 1.1618 | 1.1607 | 1.1618 | 1366400.0 |
| 2000-04-10 12:10:00 | AAPL | Stock | 1.1618 | 1.1618 | 1.1607 | 1.1607 | 660800.0 |
| 2000-04-10 12:15:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1585 | 1.159 | 470400.0 |
| 2000-04-10 12:20:00 | AAPL | Stock | 1.159 | 1.1607 | 1.1568 | 1.1568 | 1388800.0 |
| 2000-04-10 12:25:00 | AAPL | Stock | 1.1574 | 1.159 | 1.1563 | 1.1574 | 291200.0 |
| 2000-04-10 12:30:00 | AAPL | Stock | 1.1579 | 1.1579 | 1.1557 | 1.1563 | 526400.0 |
| 2000-04-10 12:35:00 | AAPL | Stock | 1.1568 | 1.1607 | 1.1568 | 1.1579 | 739200.0 |
| 2000-04-10 12:40:00 | AAPL | Stock | 1.1579 | 1.1579 | 1.1529 | 1.1535 | 873600.0 |
| 2000-04-10 12:45:00 | AAPL | Stock | 1.1579 | 1.1579 | 1.1518 | 1.1518 | 1982400.0 |
| 2000-04-10 12:50:00 | AAPL | Stock | 1.1526 | 1.1546 | 1.1507 | 1.1518 | 2497600.0 |
| 2000-04-10 12:55:00 | AAPL | Stock | 1.1518 | 1.1529 | 1.1501 | 1.1523 | 1411200.0 |
| 2000-04-10 13:00:00 | AAPL | Stock | 1.1507 | 1.1523 | 1.1496 | 1.1521 | 1579200.0 |
| 2000-04-10 13:05:00 | AAPL | Stock | 1.1521 | 1.1521 | 1.1473 | 1.149 | 1993600.0 |
| 2000-04-10 13:10:00 | AAPL | Stock | 1.1507 | 1.1518 | 1.144 | 1.144 | 2464000.0 |
| 2000-04-10 13:15:00 | AAPL | Stock | 1.1443 | 1.1459 | 1.135 | 1.1362 | 5723200.0 |
| 2000-04-10 13:20:00 | AAPL | Stock | 1.1362 | 1.1403 | 1.1339 | 1.1401 | 2508800.0 |
| 2000-04-10 13:25:00 | AAPL | Stock | 1.1406 | 1.1462 | 1.1384 | 1.139 | 1489600.0 |
| 2000-04-10 13:30:00 | AAPL | Stock | 1.1384 | 1.1395 | 1.1373 | 1.1384 | 1209600.0 |
| 2000-04-10 13:35:00 | AAPL | Stock | 1.1378 | 1.1395 | 1.1295 | 1.1295 | 3550400.0 |
> showing 50 of 86,763 rows — these rows as CSV