PREVIEW / stock_5min / 2007-03-07
file: by_date/stock_5min/2007/2007-03-07.parquet size: 3.6 MB rows: 258,196 symbols: 2,532
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-07 09:25:00 | AAPL | Stock | 3.1429 | 3.1464 | 3.1429 | 3.1429 | 607460.0 |
| 2007-03-07 09:30:00 | AAPL | Stock | 3.1446 | 3.1591 | 3.1393 | 3.1579 | 20010928.0 |
| 2007-03-07 09:35:00 | AAPL | Stock | 3.1579 | 3.1632 | 3.1468 | 3.1518 | 18880176.0 |
| 2007-03-07 09:40:00 | AAPL | Stock | 3.1514 | 3.1596 | 3.1496 | 3.1529 | 12358080.0 |
| 2007-03-07 09:45:00 | AAPL | Stock | 3.1528 | 3.1775 | 3.1514 | 3.1725 | 25426548.0 |
| 2007-03-07 09:50:00 | AAPL | Stock | 3.1721 | 3.1739 | 3.1611 | 3.1637 | 16278164.0 |
| 2007-03-07 09:55:00 | AAPL | Stock | 3.1611 | 3.1636 | 3.1514 | 3.1589 | 15338792.0 |
| 2007-03-07 10:00:00 | AAPL | Stock | 3.1589 | 3.1664 | 3.155 | 3.1618 | 12939388.0 |
| 2007-03-07 10:05:00 | AAPL | Stock | 3.1621 | 3.1629 | 3.1561 | 3.1586 | 9244704.0 |
| 2007-03-07 10:10:00 | AAPL | Stock | 3.1586 | 3.1654 | 3.1579 | 3.1614 | 7499380.0 |
| 2007-03-07 10:15:00 | AAPL | Stock | 3.1614 | 3.1632 | 3.1561 | 3.16 | 8177540.0 |
| 2007-03-07 10:20:00 | AAPL | Stock | 3.16 | 3.165 | 3.1568 | 3.1604 | 8389024.0 |
| 2007-03-07 10:25:00 | AAPL | Stock | 3.1604 | 3.1632 | 3.1568 | 3.16 | 6098876.0 |
| 2007-03-07 10:30:00 | AAPL | Stock | 3.1604 | 3.1679 | 3.1586 | 3.1643 | 12595212.0 |
| 2007-03-07 10:35:00 | AAPL | Stock | 3.1671 | 3.1768 | 3.1621 | 3.1668 | 7026236.0 |
| 2007-03-07 10:40:00 | AAPL | Stock | 3.1668 | 3.1671 | 3.1589 | 3.1593 | 6820688.0 |
| 2007-03-07 10:45:00 | AAPL | Stock | 3.1596 | 3.1604 | 3.1511 | 3.1564 | 11615436.0 |
| 2007-03-07 10:50:00 | AAPL | Stock | 3.1561 | 3.1643 | 3.1546 | 3.1568 | 6737752.0 |
| 2007-03-07 10:55:00 | AAPL | Stock | 3.1571 | 3.1611 | 3.1557 | 3.1571 | 7046396.0 |
| 2007-03-07 11:00:00 | AAPL | Stock | 3.1571 | 3.1575 | 3.1504 | 3.1532 | 11374692.0 |
| 2007-03-07 11:05:00 | AAPL | Stock | 3.1536 | 3.1586 | 3.1525 | 3.1543 | 8722028.0 |
| 2007-03-07 11:10:00 | AAPL | Stock | 3.1543 | 3.155 | 3.1454 | 3.15 | 15328516.0 |
| 2007-03-07 11:15:00 | AAPL | Stock | 3.1504 | 3.1568 | 3.1475 | 3.155 | 8448944.0 |
| 2007-03-07 11:20:00 | AAPL | Stock | 3.1543 | 3.1568 | 3.1493 | 3.15 | 5137916.0 |
| 2007-03-07 11:25:00 | AAPL | Stock | 3.1504 | 3.1568 | 3.1504 | 3.1543 | 4605160.0 |
| 2007-03-07 11:30:00 | AAPL | Stock | 3.1546 | 3.156 | 3.1518 | 3.1536 | 8629152.0 |
| 2007-03-07 11:35:00 | AAPL | Stock | 3.1536 | 3.1539 | 3.1493 | 3.1496 | 6410656.0 |
| 2007-03-07 11:40:00 | AAPL | Stock | 3.15 | 3.155 | 3.1468 | 3.1471 | 5643736.0 |
| 2007-03-07 11:45:00 | AAPL | Stock | 3.1471 | 3.1511 | 3.1457 | 3.1482 | 5691952.0 |
| 2007-03-07 11:50:00 | AAPL | Stock | 3.1482 | 3.1518 | 3.1464 | 3.1475 | 4228616.0 |
| 2007-03-07 11:55:00 | AAPL | Stock | 3.1475 | 3.1543 | 3.1471 | 3.1521 | 4182444.0 |
| 2007-03-07 12:00:00 | AAPL | Stock | 3.1525 | 3.1532 | 3.15 | 3.1529 | 3814580.0 |
| 2007-03-07 12:05:00 | AAPL | Stock | 3.1529 | 3.155 | 3.1486 | 3.1496 | 5819548.0 |
| 2007-03-07 12:10:00 | AAPL | Stock | 3.15 | 3.1668 | 3.15 | 3.1525 | 9095044.0 |
| 2007-03-07 12:15:00 | AAPL | Stock | 3.1525 | 3.1543 | 3.1514 | 3.1532 | 2177224.0 |
| 2007-03-07 12:20:00 | AAPL | Stock | 3.1532 | 3.1575 | 3.1529 | 3.1532 | 1670060.0 |
| 2007-03-07 12:25:00 | AAPL | Stock | 3.1532 | 3.1668 | 3.1532 | 3.1575 | 7604576.0 |
| 2007-03-07 12:30:00 | AAPL | Stock | 3.1575 | 3.1668 | 3.1571 | 3.16 | 11800908.0 |
| 2007-03-07 12:35:00 | AAPL | Stock | 3.1604 | 3.1643 | 3.1589 | 3.1624 | 13527360.0 |
| 2007-03-07 12:40:00 | AAPL | Stock | 3.1618 | 3.1629 | 3.16 | 3.1614 | 2653952.0 |
| 2007-03-07 12:45:00 | AAPL | Stock | 3.1614 | 3.1668 | 3.1614 | 3.1629 | 8296540.0 |
| 2007-03-07 12:50:00 | AAPL | Stock | 3.1629 | 3.1636 | 3.1571 | 3.16 | 3468444.0 |
| 2007-03-07 12:55:00 | AAPL | Stock | 3.16 | 3.1604 | 3.1564 | 3.1579 | 3650528.0 |
| 2007-03-07 13:00:00 | AAPL | Stock | 3.1579 | 3.1596 | 3.1543 | 3.1582 | 2811816.0 |
| 2007-03-07 13:05:00 | AAPL | Stock | 3.1586 | 3.1621 | 3.1564 | 3.1618 | 2363900.0 |
| 2007-03-07 13:10:00 | AAPL | Stock | 3.1615 | 3.165 | 3.1571 | 3.1579 | 4362204.0 |
| 2007-03-07 13:15:00 | AAPL | Stock | 3.1575 | 3.1607 | 3.1575 | 3.1604 | 2654736.0 |
| 2007-03-07 13:20:00 | AAPL | Stock | 3.1604 | 3.1643 | 3.1589 | 3.1629 | 3445120.0 |
| 2007-03-07 13:25:00 | AAPL | Stock | 3.1632 | 3.1661 | 3.16 | 3.1604 | 5738600.0 |
| 2007-03-07 13:30:00 | AAPL | Stock | 3.1596 | 3.1621 | 3.1579 | 3.1611 | 4956756.0 |
> showing 50 of 258,196 rows — these rows as CSV