PREVIEW / stock_5min / 2009-02-23
file: by_date/stock_5min/2009/2009-02-23.parquet size: 4.5 MB rows: 313,985 symbols: 3,344
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-23 07:10:00 | AAPL | Stock | 3.2804 | 3.2804 | 3.2804 | 3.2804 | 12600.0 |
| 2009-02-23 07:25:00 | AAPL | Stock | 3.3071 | 3.3071 | 3.3071 | 3.3071 | 4508.0 |
| 2009-02-23 07:35:00 | AAPL | Stock | 3.2829 | 3.2907 | 3.2804 | 3.2804 | 33292.0 |
| 2009-02-23 07:45:00 | AAPL | Stock | 3.2768 | 3.2768 | 3.2768 | 3.2768 | 26544.0 |
| 2009-02-23 07:50:00 | AAPL | Stock | 3.2768 | 3.2768 | 3.2768 | 3.2768 | 2800.0 |
| 2009-02-23 08:00:00 | AAPL | Stock | 3.2679 | 3.2714 | 3.2679 | 3.2714 | 57400.0 |
| 2009-02-23 08:05:00 | AAPL | Stock | 3.2768 | 3.2768 | 3.2768 | 3.2768 | 8400.0 |
| 2009-02-23 08:10:00 | AAPL | Stock | 3.2714 | 3.2714 | 3.265 | 3.2668 | 225400.0 |
| 2009-02-23 08:15:00 | AAPL | Stock | 3.2668 | 3.2668 | 3.2668 | 3.2668 | 25200.0 |
| 2009-02-23 08:20:00 | AAPL | Stock | 3.2668 | 3.2668 | 3.2668 | 3.2668 | 30800.0 |
| 2009-02-23 08:25:00 | AAPL | Stock | 3.2604 | 3.2668 | 3.2593 | 3.2643 | 49280.0 |
| 2009-02-23 08:30:00 | AAPL | Stock | 3.2611 | 3.2625 | 3.2611 | 3.2625 | 32648.0 |
| 2009-02-23 08:35:00 | AAPL | Stock | 3.2657 | 3.2657 | 3.2643 | 3.2643 | 57176.0 |
| 2009-02-23 08:40:00 | AAPL | Stock | 3.2625 | 3.2643 | 3.2625 | 3.2643 | 67900.0 |
| 2009-02-23 08:45:00 | AAPL | Stock | 3.2643 | 3.2679 | 3.2607 | 3.2679 | 63000.0 |
| 2009-02-23 08:50:00 | AAPL | Stock | 3.2729 | 3.275 | 3.2643 | 3.275 | 433580.0 |
| 2009-02-23 08:55:00 | AAPL | Stock | 3.275 | 3.2854 | 3.275 | 3.2854 | 125020.0 |
| 2009-02-23 09:00:00 | AAPL | Stock | 3.2854 | 3.2854 | 3.2786 | 3.2846 | 79800.0 |
| 2009-02-23 09:05:00 | AAPL | Stock | 3.2846 | 3.2857 | 3.2821 | 3.2829 | 14000.0 |
| 2009-02-23 09:10:00 | AAPL | Stock | 3.2804 | 3.2804 | 3.2757 | 3.2779 | 100520.0 |
| 2009-02-23 09:15:00 | AAPL | Stock | 3.2782 | 3.2911 | 3.2782 | 3.2864 | 492968.0 |
| 2009-02-23 09:20:00 | AAPL | Stock | 3.2896 | 3.2918 | 3.2861 | 3.2907 | 75656.0 |
| 2009-02-23 09:25:00 | AAPL | Stock | 3.2907 | 3.2907 | 3.2693 | 3.2775 | 440048.0 |
| 2009-02-23 09:30:00 | AAPL | Stock | 3.2732 | 3.2857 | 3.2329 | 3.2339 | 15701924.0 |
| 2009-02-23 09:35:00 | AAPL | Stock | 3.2336 | 3.2395 | 3.2157 | 3.2279 | 16031008.0 |
| 2009-02-23 09:40:00 | AAPL | Stock | 3.2289 | 3.2303 | 3.1896 | 3.2028 | 20162072.0 |
| 2009-02-23 09:45:00 | AAPL | Stock | 3.2029 | 3.2086 | 3.1818 | 3.1854 | 16233868.0 |
| 2009-02-23 09:50:00 | AAPL | Stock | 3.1857 | 3.1964 | 3.1793 | 3.1843 | 15236396.0 |
| 2009-02-23 09:55:00 | AAPL | Stock | 3.185 | 3.19 | 3.1696 | 3.1736 | 18044572.0 |
| 2009-02-23 10:00:00 | AAPL | Stock | 3.1745 | 3.1843 | 3.1654 | 3.1686 | 13942208.0 |
| 2009-02-23 10:05:00 | AAPL | Stock | 3.1689 | 3.1743 | 3.1625 | 3.1725 | 11687592.0 |
| 2009-02-23 10:10:00 | AAPL | Stock | 3.1729 | 3.1775 | 3.1582 | 3.1707 | 13678952.0 |
| 2009-02-23 10:15:00 | AAPL | Stock | 3.1704 | 3.1761 | 3.1582 | 3.1725 | 10201380.0 |
| 2009-02-23 10:20:00 | AAPL | Stock | 3.1729 | 3.1882 | 3.1714 | 3.1879 | 14671692.0 |
| 2009-02-23 10:25:00 | AAPL | Stock | 3.1879 | 3.1882 | 3.1696 | 3.1764 | 11910668.0 |
| 2009-02-23 10:30:00 | AAPL | Stock | 3.1771 | 3.1782 | 3.1618 | 3.1618 | 7494536.0 |
| 2009-02-23 10:35:00 | AAPL | Stock | 3.1621 | 3.165 | 3.1518 | 3.1593 | 11663820.0 |
| 2009-02-23 10:40:00 | AAPL | Stock | 3.16 | 3.1618 | 3.15 | 3.16 | 8667876.0 |
| 2009-02-23 10:45:00 | AAPL | Stock | 3.1607 | 3.1732 | 3.1543 | 3.172 | 11159596.0 |
| 2009-02-23 10:50:00 | AAPL | Stock | 3.1718 | 3.175 | 3.1643 | 3.1693 | 6023388.0 |
| 2009-02-23 10:55:00 | AAPL | Stock | 3.1689 | 3.1704 | 3.1529 | 3.1554 | 7960652.0 |
| 2009-02-23 11:00:00 | AAPL | Stock | 3.1557 | 3.1627 | 3.1543 | 3.1571 | 7502320.0 |
| 2009-02-23 11:05:00 | AAPL | Stock | 3.1571 | 3.1607 | 3.1482 | 3.1575 | 7692636.0 |
| 2009-02-23 11:10:00 | AAPL | Stock | 3.1575 | 3.1732 | 3.1575 | 3.1668 | 9581152.0 |
| 2009-02-23 11:15:00 | AAPL | Stock | 3.1664 | 3.1725 | 3.1611 | 3.1621 | 9462040.0 |
| 2009-02-23 11:20:00 | AAPL | Stock | 3.1621 | 3.1714 | 3.1589 | 3.1604 | 7660128.0 |
| 2009-02-23 11:25:00 | AAPL | Stock | 3.1604 | 3.17 | 3.1589 | 3.1675 | 4647216.0 |
| 2009-02-23 11:30:00 | AAPL | Stock | 3.1671 | 3.1679 | 3.1489 | 3.1507 | 9185596.0 |
| 2009-02-23 11:35:00 | AAPL | Stock | 3.1511 | 3.1543 | 3.1482 | 3.1514 | 6454532.0 |
| 2009-02-23 11:40:00 | AAPL | Stock | 3.1514 | 3.1521 | 3.1425 | 3.1457 | 9820412.0 |
> showing 50 of 313,985 rows — these rows as CSV