PREVIEW / stock_5min / 2005-01-05
file: by_date/stock_5min/2005/2005-01-05.parquet size: 2.8 MB rows: 198,905 symbols: 1,909
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-05 08:00:00 | AAPL | Stock | 1.152 | 1.1563 | 1.1475 | 1.1554 | 952000.0 |
| 2005-01-05 08:05:00 | AAPL | Stock | 1.1563 | 1.1598 | 1.1559 | 1.1563 | 548800.0 |
| 2005-01-05 08:10:00 | AAPL | Stock | 1.1554 | 1.1554 | 1.1554 | 1.1554 | 22400.0 |
| 2005-01-05 08:15:00 | AAPL | Stock | 1.1539 | 1.1554 | 1.1538 | 1.1538 | 78400.0 |
| 2005-01-05 08:20:00 | AAPL | Stock | 1.1538 | 1.158 | 1.1518 | 1.158 | 562800.0 |
| 2005-01-05 08:25:00 | AAPL | Stock | 1.1563 | 1.1563 | 1.1563 | 1.1563 | 70560.0 |
| 2005-01-05 08:30:00 | AAPL | Stock | 1.1577 | 1.158 | 1.1525 | 1.1527 | 347200.0 |
| 2005-01-05 08:35:00 | AAPL | Stock | 1.1536 | 1.1538 | 1.1529 | 1.1529 | 261016.0 |
| 2005-01-05 08:40:00 | AAPL | Stock | 1.1529 | 1.1529 | 1.1518 | 1.1518 | 219968.0 |
| 2005-01-05 08:45:00 | AAPL | Stock | 1.1527 | 1.1527 | 1.15 | 1.1518 | 225400.0 |
| 2005-01-05 08:50:00 | AAPL | Stock | 1.1527 | 1.1527 | 1.1502 | 1.1509 | 179200.0 |
| 2005-01-05 08:55:00 | AAPL | Stock | 1.1518 | 1.1527 | 1.1502 | 1.1502 | 296800.0 |
| 2005-01-05 09:00:00 | AAPL | Stock | 1.1418 | 1.1504 | 1.1418 | 1.1504 | 121072.0 |
| 2005-01-05 09:05:00 | AAPL | Stock | 1.1509 | 1.1521 | 1.1509 | 1.1518 | 786800.0 |
| 2005-01-05 09:10:00 | AAPL | Stock | 1.1518 | 1.1518 | 1.1486 | 1.15 | 158200.0 |
| 2005-01-05 09:15:00 | AAPL | Stock | 1.15 | 1.1518 | 1.15 | 1.1518 | 117600.0 |
| 2005-01-05 09:20:00 | AAPL | Stock | 1.15 | 1.15 | 1.15 | 1.15 | 56000.0 |
| 2005-01-05 09:25:00 | AAPL | Stock | 1.1504 | 1.153 | 1.1488 | 1.1521 | 1151360.0 |
| 2005-01-05 09:30:00 | AAPL | Stock | 1.1491 | 1.1589 | 1.1491 | 1.1534 | 28910896.0 |
| 2005-01-05 09:35:00 | AAPL | Stock | 1.1538 | 1.1571 | 1.1495 | 1.1568 | 21900984.0 |
| 2005-01-05 09:40:00 | AAPL | Stock | 1.1568 | 1.1598 | 1.1555 | 1.1582 | 25666928.0 |
| 2005-01-05 09:45:00 | AAPL | Stock | 1.1582 | 1.1652 | 1.1579 | 1.163 | 42700000.0 |
| 2005-01-05 09:50:00 | AAPL | Stock | 1.163 | 1.1643 | 1.1571 | 1.1575 | 24817856.0 |
| 2005-01-05 09:55:00 | AAPL | Stock | 1.1575 | 1.1584 | 1.1507 | 1.1563 | 20638632.0 |
| 2005-01-05 10:00:00 | AAPL | Stock | 1.1563 | 1.1607 | 1.1557 | 1.1588 | 16775584.0 |
| 2005-01-05 10:05:00 | AAPL | Stock | 1.1584 | 1.1584 | 1.1543 | 1.1554 | 11084864.0 |
| 2005-01-05 10:10:00 | AAPL | Stock | 1.1554 | 1.1602 | 1.1527 | 1.1582 | 11834816.0 |
| 2005-01-05 10:15:00 | AAPL | Stock | 1.1586 | 1.1598 | 1.1575 | 1.1593 | 7552104.0 |
| 2005-01-05 10:20:00 | AAPL | Stock | 1.1593 | 1.1596 | 1.1543 | 1.1568 | 8565648.0 |
| 2005-01-05 10:25:00 | AAPL | Stock | 1.1566 | 1.1575 | 1.1509 | 1.1516 | 10905664.0 |
| 2005-01-05 10:30:00 | AAPL | Stock | 1.1516 | 1.1568 | 1.1507 | 1.1546 | 9418136.0 |
| 2005-01-05 10:35:00 | AAPL | Stock | 1.155 | 1.155 | 1.1466 | 1.15 | 12161464.0 |
| 2005-01-05 10:40:00 | AAPL | Stock | 1.1505 | 1.1516 | 1.1484 | 1.1484 | 10457160.0 |
| 2005-01-05 10:45:00 | AAPL | Stock | 1.1482 | 1.15 | 1.1446 | 1.1475 | 12498808.0 |
| 2005-01-05 10:50:00 | AAPL | Stock | 1.1475 | 1.1491 | 1.1455 | 1.148 | 8235920.0 |
| 2005-01-05 10:55:00 | AAPL | Stock | 1.148 | 1.1496 | 1.1461 | 1.1484 | 6163472.0 |
| 2005-01-05 11:00:00 | AAPL | Stock | 1.1486 | 1.1568 | 1.1482 | 1.1555 | 16110920.0 |
| 2005-01-05 11:05:00 | AAPL | Stock | 1.1554 | 1.1559 | 1.1532 | 1.1552 | 6564152.0 |
| 2005-01-05 11:10:00 | AAPL | Stock | 1.1552 | 1.1554 | 1.1527 | 1.1536 | 4057368.0 |
| 2005-01-05 11:15:00 | AAPL | Stock | 1.1536 | 1.1541 | 1.1527 | 1.1534 | 4620840.0 |
| 2005-01-05 11:20:00 | AAPL | Stock | 1.1532 | 1.1536 | 1.1466 | 1.1475 | 9228856.0 |
| 2005-01-05 11:25:00 | AAPL | Stock | 1.1477 | 1.1507 | 1.1466 | 1.1495 | 5926312.0 |
| 2005-01-05 11:30:00 | AAPL | Stock | 1.1493 | 1.1538 | 1.1486 | 1.15 | 7277592.0 |
| 2005-01-05 11:35:00 | AAPL | Stock | 1.15 | 1.1511 | 1.1488 | 1.1496 | 3155936.0 |
| 2005-01-05 11:40:00 | AAPL | Stock | 1.1496 | 1.15 | 1.1486 | 1.1495 | 3819648.0 |
| 2005-01-05 11:45:00 | AAPL | Stock | 1.1495 | 1.1525 | 1.1493 | 1.1514 | 4718784.0 |
| 2005-01-05 11:50:00 | AAPL | Stock | 1.1514 | 1.1518 | 1.1488 | 1.1493 | 3136952.0 |
| 2005-01-05 11:55:00 | AAPL | Stock | 1.1493 | 1.1518 | 1.1491 | 1.1505 | 3240664.0 |
| 2005-01-05 12:00:00 | AAPL | Stock | 1.1507 | 1.1518 | 1.1504 | 1.1505 | 2903880.0 |
| 2005-01-05 12:05:00 | AAPL | Stock | 1.1505 | 1.1507 | 1.1498 | 1.15 | 5595632.0 |
> showing 50 of 198,905 rows — these rows as CSV