PREVIEW / stock_5min / 2000-03-31
file: by_date/stock_5min/2000/2000-03-31.parquet size: 1.3 MB rows: 95,157 symbols: 1,153
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.1306 | 1.1345 | 8982400.0 |
| 2000-03-31 09:35:00 | AAPL | Stock | 1.1323 | 1.1518 | 1.1317 | 1.1512 | 8534400.0 |
| 2000-03-31 09:40:00 | AAPL | Stock | 1.1507 | 1.1775 | 1.1507 | 1.1775 | 11502400.0 |
| 2000-03-31 09:45:00 | AAPL | Stock | 1.1772 | 1.1775 | 1.1696 | 1.173 | 12241600.0 |
| 2000-03-31 09:50:00 | AAPL | Stock | 1.1696 | 1.1752 | 1.1585 | 1.159 | 7347200.0 |
| 2000-03-31 09:55:00 | AAPL | Stock | 1.1574 | 1.1685 | 1.1563 | 1.1585 | 12174400.0 |
| 2000-03-31 10:00:00 | AAPL | Stock | 1.1652 | 1.1696 | 1.1563 | 1.168 | 9878400.0 |
| 2000-03-31 10:05:00 | AAPL | Stock | 1.1691 | 1.173 | 1.159 | 1.1724 | 8400000.0 |
| 2000-03-31 10:10:00 | AAPL | Stock | 1.1719 | 1.1735 | 1.1624 | 1.1624 | 5588800.0 |
| 2000-03-31 10:15:00 | AAPL | Stock | 1.1624 | 1.1629 | 1.1596 | 1.1607 | 5476800.0 |
| 2000-03-31 10:20:00 | AAPL | Stock | 1.1613 | 1.1674 | 1.1585 | 1.1671 | 4569600.0 |
| 2000-03-31 10:25:00 | AAPL | Stock | 1.1671 | 1.1674 | 1.159 | 1.159 | 3136000.0 |
| 2000-03-31 10:30:00 | AAPL | Stock | 1.1596 | 1.1646 | 1.1579 | 1.1613 | 5140800.0 |
| 2000-03-31 10:35:00 | AAPL | Stock | 1.1596 | 1.1663 | 1.1585 | 1.1646 | 3964800.0 |
| 2000-03-31 10:40:00 | AAPL | Stock | 1.1646 | 1.1652 | 1.1496 | 1.1496 | 3225600.0 |
| 2000-03-31 10:45:00 | AAPL | Stock | 1.1496 | 1.1518 | 1.1434 | 1.1496 | 4748800.0 |
| 2000-03-31 10:50:00 | AAPL | Stock | 1.1507 | 1.1551 | 1.149 | 1.1529 | 3696000.0 |
| 2000-03-31 10:55:00 | AAPL | Stock | 1.1518 | 1.154 | 1.1479 | 1.1484 | 2968000.0 |
| 2000-03-31 11:00:00 | AAPL | Stock | 1.1484 | 1.1501 | 1.1384 | 1.1434 | 3628800.0 |
| 2000-03-31 11:05:00 | AAPL | Stock | 1.1434 | 1.1434 | 1.1362 | 1.1401 | 3561600.0 |
| 2000-03-31 11:10:00 | AAPL | Stock | 1.1434 | 1.1434 | 1.1295 | 1.1295 | 6115200.0 |
| 2000-03-31 11:15:00 | AAPL | Stock | 1.1295 | 1.1317 | 1.125 | 1.1292 | 3673600.0 |
| 2000-03-31 11:20:00 | AAPL | Stock | 1.1295 | 1.1423 | 1.1261 | 1.1417 | 5376000.0 |
| 2000-03-31 11:25:00 | AAPL | Stock | 1.1417 | 1.1518 | 1.1417 | 1.1479 | 4928000.0 |
| 2000-03-31 11:30:00 | AAPL | Stock | 1.1473 | 1.1479 | 1.1395 | 1.1406 | 3976000.0 |
| 2000-03-31 11:35:00 | AAPL | Stock | 1.1412 | 1.1546 | 1.1401 | 1.1546 | 5051200.0 |
| 2000-03-31 11:40:00 | AAPL | Stock | 1.1529 | 1.1529 | 1.144 | 1.1496 | 2139200.0 |
| 2000-03-31 11:45:00 | AAPL | Stock | 1.1496 | 1.1518 | 1.1434 | 1.1451 | 1142400.0 |
| 2000-03-31 11:50:00 | AAPL | Stock | 1.1451 | 1.1523 | 1.1445 | 1.1451 | 2374400.0 |
| 2000-03-31 11:55:00 | AAPL | Stock | 1.1468 | 1.1468 | 1.1384 | 1.1384 | 3315200.0 |
| 2000-03-31 12:00:00 | AAPL | Stock | 1.1378 | 1.1378 | 1.1334 | 1.1362 | 1052800.0 |
| 2000-03-31 12:05:00 | AAPL | Stock | 1.1345 | 1.1445 | 1.1345 | 1.1445 | 1680000.0 |
| 2000-03-31 12:10:00 | AAPL | Stock | 1.1445 | 1.1509 | 1.1429 | 1.1429 | 1164800.0 |
| 2000-03-31 12:15:00 | AAPL | Stock | 1.1434 | 1.1518 | 1.1412 | 1.1512 | 3292800.0 |
| 2000-03-31 12:20:00 | AAPL | Stock | 1.1507 | 1.1529 | 1.144 | 1.1512 | 1288000.0 |
| 2000-03-31 12:25:00 | AAPL | Stock | 1.149 | 1.1518 | 1.1429 | 1.1445 | 1859200.0 |
| 2000-03-31 12:30:00 | AAPL | Stock | 1.1459 | 1.1512 | 1.1459 | 1.1509 | 1422400.0 |
| 2000-03-31 12:35:00 | AAPL | Stock | 1.1512 | 1.1568 | 1.1507 | 1.1568 | 2520000.0 |
| 2000-03-31 12:40:00 | AAPL | Stock | 1.1574 | 1.159 | 1.154 | 1.159 | 2038400.0 |
| 2000-03-31 12:45:00 | AAPL | Stock | 1.159 | 1.1652 | 1.159 | 1.1652 | 2721600.0 |
| 2000-03-31 12:50:00 | AAPL | Stock | 1.1635 | 1.1652 | 1.1618 | 1.1635 | 1646400.0 |
| 2000-03-31 12:55:00 | AAPL | Stock | 1.1629 | 1.1635 | 1.154 | 1.1602 | 1344000.0 |
| 2000-03-31 13:00:00 | AAPL | Stock | 1.1596 | 1.1607 | 1.1563 | 1.1602 | 996800.0 |
| 2000-03-31 13:05:00 | AAPL | Stock | 1.1596 | 1.1674 | 1.1596 | 1.1652 | 2676800.0 |
| 2000-03-31 13:10:00 | AAPL | Stock | 1.1663 | 1.1674 | 1.1629 | 1.1657 | 1478400.0 |
| 2000-03-31 13:15:00 | AAPL | Stock | 1.1657 | 1.1685 | 1.1652 | 1.1652 | 1344000.0 |
| 2000-03-31 13:20:00 | AAPL | Stock | 1.1641 | 1.1685 | 1.1568 | 1.1629 | 1467200.0 |
| 2000-03-31 13:25:00 | AAPL | Stock | 1.1629 | 1.1685 | 1.1613 | 1.1652 | 470400.0 |
| 2000-03-31 13:30:00 | AAPL | Stock | 1.1652 | 1.1691 | 1.1635 | 1.1635 | 1937600.0 |
| 2000-03-31 13:35:00 | AAPL | Stock | 1.1629 | 1.173 | 1.1618 | 1.1724 | 3147200.0 |
> showing 50 of 95,157 rows — these rows as CSV