PREVIEW / stock_5min / 2007-03-08
file: by_date/stock_5min/2007/2007-03-08.parquet size: 3.6 MB rows: 257,992 symbols: 2,515
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-03-08 04:25:00 | AAPL | Stock | 3.1593 | 3.1593 | 3.1593 | 3.1593 | 2800.0 |
| 2007-03-08 04:45:00 | AAPL | Stock | 3.1554 | 3.1646 | 3.1554 | 3.1646 | 5600.0 |
| 2007-03-08 04:50:00 | AAPL | Stock | 3.1571 | 3.1571 | 3.1571 | 3.1571 | 5600.0 |
| 2007-03-08 06:35:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1643 | 3.1643 | 14000.0 |
| 2007-03-08 07:10:00 | AAPL | Stock | 3.1682 | 3.1682 | 3.1682 | 3.1682 | 27860.0 |
| 2007-03-08 07:15:00 | AAPL | Stock | 3.1679 | 3.1682 | 3.1679 | 3.1682 | 72800.0 |
| 2007-03-08 07:25:00 | AAPL | Stock | 3.1682 | 3.1682 | 3.1682 | 3.1682 | 8400.0 |
| 2007-03-08 07:30:00 | AAPL | Stock | 3.1682 | 3.1682 | 3.1679 | 3.1682 | 33600.0 |
| 2007-03-08 07:35:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1679 | 3.1679 | 2800.0 |
| 2007-03-08 07:45:00 | AAPL | Stock | 3.1668 | 3.1679 | 3.1646 | 3.1646 | 58800.0 |
| 2007-03-08 07:50:00 | AAPL | Stock | 3.1679 | 3.1682 | 3.1679 | 3.1682 | 11200.0 |
| 2007-03-08 07:55:00 | AAPL | Stock | 3.1682 | 3.1746 | 3.1682 | 3.1746 | 67340.0 |
| 2007-03-08 08:00:00 | AAPL | Stock | 3.1686 | 3.1736 | 3.1679 | 3.1686 | 523068.0 |
| 2007-03-08 08:05:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1661 | 3.1661 | 301000.0 |
| 2007-03-08 08:10:00 | AAPL | Stock | 3.1657 | 3.1704 | 3.1657 | 3.1696 | 261800.0 |
| 2007-03-08 08:15:00 | AAPL | Stock | 3.1679 | 3.17 | 3.1679 | 3.17 | 280700.0 |
| 2007-03-08 08:20:00 | AAPL | Stock | 3.1696 | 3.175 | 3.1686 | 3.1696 | 365120.0 |
| 2007-03-08 08:25:00 | AAPL | Stock | 3.1714 | 3.1732 | 3.1696 | 3.1696 | 198240.0 |
| 2007-03-08 08:30:00 | AAPL | Stock | 3.1696 | 3.1714 | 3.1696 | 3.1696 | 107940.0 |
| 2007-03-08 08:35:00 | AAPL | Stock | 3.1686 | 3.1686 | 3.1657 | 3.1679 | 460740.0 |
| 2007-03-08 08:40:00 | AAPL | Stock | 3.1661 | 3.1661 | 3.1646 | 3.1657 | 115556.0 |
| 2007-03-08 08:45:00 | AAPL | Stock | 3.1646 | 3.1646 | 3.1625 | 3.1625 | 340788.0 |
| 2007-03-08 08:50:00 | AAPL | Stock | 3.1625 | 3.1643 | 3.1611 | 3.1611 | 160440.0 |
| 2007-03-08 08:55:00 | AAPL | Stock | 3.1625 | 3.1643 | 3.1611 | 3.1643 | 236740.0 |
| 2007-03-08 09:00:00 | AAPL | Stock | 3.1643 | 3.1657 | 3.1643 | 3.165 | 90580.0 |
| 2007-03-08 09:05:00 | AAPL | Stock | 3.1657 | 3.1682 | 3.165 | 3.1675 | 118244.0 |
| 2007-03-08 09:10:00 | AAPL | Stock | 3.1675 | 3.1682 | 3.1671 | 3.1679 | 223160.0 |
| 2007-03-08 09:15:00 | AAPL | Stock | 3.1661 | 3.1661 | 3.1639 | 3.1643 | 362348.0 |
| 2007-03-08 09:20:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1618 | 3.1639 | 30352.0 |
| 2007-03-08 09:25:00 | AAPL | Stock | 3.1639 | 3.1654 | 3.1639 | 3.1643 | 1014300.0 |
| 2007-03-08 09:30:00 | AAPL | Stock | 3.1639 | 3.1686 | 3.1571 | 3.1586 | 18839492.0 |
| 2007-03-08 09:35:00 | AAPL | Stock | 3.1586 | 3.1671 | 3.1568 | 3.1579 | 11066692.0 |
| 2007-03-08 09:40:00 | AAPL | Stock | 3.1586 | 3.1636 | 3.1564 | 3.1579 | 12794796.0 |
| 2007-03-08 09:45:00 | AAPL | Stock | 3.1579 | 3.1579 | 3.15 | 3.1532 | 18809784.0 |
| 2007-03-08 09:50:00 | AAPL | Stock | 3.1532 | 3.1579 | 3.1507 | 3.1518 | 9866248.0 |
| 2007-03-08 09:55:00 | AAPL | Stock | 3.1518 | 3.1564 | 3.1482 | 3.15 | 10790052.0 |
| 2007-03-08 10:00:00 | AAPL | Stock | 3.1496 | 3.1557 | 3.1471 | 3.1543 | 10802428.0 |
| 2007-03-08 10:05:00 | AAPL | Stock | 3.1546 | 3.1571 | 3.1521 | 3.155 | 6337408.0 |
| 2007-03-08 10:10:00 | AAPL | Stock | 3.155 | 3.1564 | 3.1525 | 3.155 | 6639752.0 |
| 2007-03-08 10:15:00 | AAPL | Stock | 3.155 | 3.1586 | 3.1525 | 3.1586 | 8705060.0 |
| 2007-03-08 10:20:00 | AAPL | Stock | 3.1586 | 3.1593 | 3.1539 | 3.1546 | 6826008.0 |
| 2007-03-08 10:25:00 | AAPL | Stock | 3.155 | 3.1564 | 3.1525 | 3.1564 | 7095508.0 |
| 2007-03-08 10:30:00 | AAPL | Stock | 3.1561 | 3.1564 | 3.1504 | 3.1514 | 6300308.0 |
| 2007-03-08 10:35:00 | AAPL | Stock | 3.1518 | 3.1546 | 3.1489 | 3.15 | 8097432.0 |
| 2007-03-08 10:40:00 | AAPL | Stock | 3.15 | 3.1521 | 3.1454 | 3.1496 | 9900044.0 |
| 2007-03-08 10:45:00 | AAPL | Stock | 3.1496 | 3.1511 | 3.1461 | 3.1493 | 7276584.0 |
| 2007-03-08 10:50:00 | AAPL | Stock | 3.1493 | 3.15 | 3.1429 | 3.1443 | 7227416.0 |
| 2007-03-08 10:55:00 | AAPL | Stock | 3.1446 | 3.1489 | 3.1436 | 3.1479 | 6522684.0 |
| 2007-03-08 11:00:00 | AAPL | Stock | 3.1475 | 3.1496 | 3.1446 | 3.1468 | 4840220.0 |
| 2007-03-08 11:05:00 | AAPL | Stock | 3.1464 | 3.1482 | 3.1414 | 3.1436 | 5279820.0 |
> showing 50 of 257,992 rows — these rows as CSV