PREVIEW / stock_5min / 2007-01-22
file: by_date/stock_5min/2007/2007-01-22.parquet size: 3.3 MB rows: 243,163 symbols: 2,501
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-01-22 06:05:00 | AAPL | Stock | 3.1686 | 3.1686 | 3.1686 | 3.1686 | 2800.0 |
| 2007-01-22 06:15:00 | AAPL | Stock | 3.1668 | 3.1668 | 3.1654 | 3.1654 | 19600.0 |
| 2007-01-22 06:35:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1714 | 3.1714 | 2800.0 |
| 2007-01-22 07:35:00 | AAPL | Stock | 3.175 | 3.1757 | 3.175 | 3.1757 | 42000.0 |
| 2007-01-22 07:40:00 | AAPL | Stock | 3.175 | 3.1786 | 3.175 | 3.175 | 39200.0 |
| 2007-01-22 07:45:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1739 | 3.1786 | 249200.0 |
| 2007-01-22 07:50:00 | AAPL | Stock | 3.1825 | 3.1861 | 3.1825 | 3.1839 | 53200.0 |
| 2007-01-22 07:55:00 | AAPL | Stock | 3.1846 | 3.1846 | 3.1829 | 3.1832 | 86016.0 |
| 2007-01-22 08:00:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1768 | 3.1804 | 195048.0 |
| 2007-01-22 08:05:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1679 | 3.1714 | 384048.0 |
| 2007-01-22 08:10:00 | AAPL | Stock | 3.1714 | 3.1768 | 3.1682 | 3.175 | 218400.0 |
| 2007-01-22 08:15:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1714 | 3.175 | 114716.0 |
| 2007-01-22 08:20:00 | AAPL | Stock | 3.175 | 3.1768 | 3.1682 | 3.1682 | 322028.0 |
| 2007-01-22 08:25:00 | AAPL | Stock | 3.1696 | 3.1743 | 3.1696 | 3.1696 | 102872.0 |
| 2007-01-22 08:30:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1682 | 3.1696 | 190344.0 |
| 2007-01-22 08:35:00 | AAPL | Stock | 3.1696 | 3.1743 | 3.1696 | 3.1714 | 194040.0 |
| 2007-01-22 08:40:00 | AAPL | Stock | 3.1714 | 3.1732 | 3.1714 | 3.1732 | 167020.0 |
| 2007-01-22 08:45:00 | AAPL | Stock | 3.1729 | 3.1732 | 3.1714 | 3.1732 | 214312.0 |
| 2007-01-22 08:50:00 | AAPL | Stock | 3.175 | 3.175 | 3.1732 | 3.1732 | 12600.0 |
| 2007-01-22 08:55:00 | AAPL | Stock | 3.1732 | 3.1732 | 3.1696 | 3.1732 | 132104.0 |
| 2007-01-22 09:00:00 | AAPL | Stock | 3.1743 | 3.1743 | 3.1732 | 3.1743 | 39200.0 |
| 2007-01-22 09:05:00 | AAPL | Stock | 3.1732 | 3.1754 | 3.1732 | 3.1754 | 199360.0 |
| 2007-01-22 09:10:00 | AAPL | Stock | 3.1754 | 3.1768 | 3.1754 | 3.1768 | 170632.0 |
| 2007-01-22 09:15:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1721 | 3.1721 | 246988.0 |
| 2007-01-22 09:20:00 | AAPL | Stock | 3.175 | 3.175 | 3.1714 | 3.175 | 43120.0 |
| 2007-01-22 09:25:00 | AAPL | Stock | 3.175 | 3.1836 | 3.17 | 3.1829 | 2504656.0 |
| 2007-01-22 09:30:00 | AAPL | Stock | 3.1836 | 3.1843 | 3.1625 | 3.1668 | 29905064.0 |
| 2007-01-22 09:35:00 | AAPL | Stock | 3.1661 | 3.1839 | 3.1475 | 3.1536 | 25898880.0 |
| 2007-01-22 09:40:00 | AAPL | Stock | 3.1536 | 3.1539 | 3.1386 | 3.1457 | 29805552.0 |
| 2007-01-22 09:45:00 | AAPL | Stock | 3.1461 | 3.1571 | 3.1357 | 3.15 | 22119776.0 |
| 2007-01-22 09:50:00 | AAPL | Stock | 3.1504 | 3.1507 | 3.1314 | 3.1404 | 24884636.0 |
| 2007-01-22 09:55:00 | AAPL | Stock | 3.1404 | 3.1425 | 3.1321 | 3.14 | 19844440.0 |
| 2007-01-22 10:00:00 | AAPL | Stock | 3.1404 | 3.1414 | 3.1132 | 3.1157 | 34500480.0 |
| 2007-01-22 10:05:00 | AAPL | Stock | 3.1161 | 3.1214 | 3.0711 | 3.0796 | 65278696.0 |
| 2007-01-22 10:10:00 | AAPL | Stock | 3.0796 | 3.0918 | 3.0714 | 3.0821 | 56210028.0 |
| 2007-01-22 10:15:00 | AAPL | Stock | 3.0818 | 3.1429 | 3.0768 | 3.0843 | 44966628.0 |
| 2007-01-22 10:20:00 | AAPL | Stock | 3.0843 | 3.0896 | 3.0725 | 3.0743 | 39990328.0 |
| 2007-01-22 10:25:00 | AAPL | Stock | 3.0743 | 3.0946 | 3.0729 | 3.0904 | 37579136.0 |
| 2007-01-22 10:30:00 | AAPL | Stock | 3.09 | 3.1386 | 3.0714 | 3.0721 | 33730060.0 |
| 2007-01-22 10:35:00 | AAPL | Stock | 3.0721 | 3.08 | 3.0643 | 3.0771 | 36651104.0 |
| 2007-01-22 10:40:00 | AAPL | Stock | 3.0764 | 3.0804 | 3.0607 | 3.0643 | 30643704.0 |
| 2007-01-22 10:45:00 | AAPL | Stock | 3.0643 | 3.0782 | 3.0618 | 3.0675 | 34476904.0 |
| 2007-01-22 10:50:00 | AAPL | Stock | 3.0675 | 3.0782 | 3.0654 | 3.0732 | 20881084.0 |
| 2007-01-22 10:55:00 | AAPL | Stock | 3.0739 | 3.0746 | 3.0661 | 3.0682 | 23029412.0 |
| 2007-01-22 11:00:00 | AAPL | Stock | 3.0686 | 3.0732 | 3.065 | 3.0675 | 21668752.0 |
| 2007-01-22 11:05:00 | AAPL | Stock | 3.0675 | 3.0739 | 3.0643 | 3.0707 | 20473656.0 |
| 2007-01-22 11:10:00 | AAPL | Stock | 3.0704 | 3.0779 | 3.0679 | 3.0764 | 16800532.0 |
| 2007-01-22 11:15:00 | AAPL | Stock | 3.0764 | 3.0836 | 3.0761 | 3.0786 | 19059824.0 |
| 2007-01-22 11:20:00 | AAPL | Stock | 3.0786 | 3.0807 | 3.0696 | 3.0732 | 12026700.0 |
| 2007-01-22 11:25:00 | AAPL | Stock | 3.0732 | 3.0964 | 3.0589 | 3.0675 | 26064108.0 |
> showing 50 of 243,163 rows — these rows as CSV