PREVIEW / stock_30min / 2007-02-26
file: by_date/stock_30min/2007/2007-02-26.parquet size: 1005 KB rows: 53,617 symbols: 2,521
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-02-26 05:30:00 | AAPL | Stock | 3.1914 | 3.1929 | 3.1914 | 3.1929 | 27328.0 |
| 2007-02-26 06:30:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1929 | 3.1929 | 20216.0 |
| 2007-02-26 07:30:00 | AAPL | Stock | 3.1961 | 3.2393 | 3.1961 | 3.2257 | 879228.0 |
| 2007-02-26 08:00:00 | AAPL | Stock | 3.2239 | 3.2268 | 3.1964 | 3.2125 | 2405816.0 |
| 2007-02-26 08:30:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2082 | 3.2086 | 681128.0 |
| 2007-02-26 09:00:00 | AAPL | Stock | 3.2086 | 3.2118 | 3.2018 | 3.2079 | 1735888.0 |
| 2007-02-26 09:30:00 | AAPL | Stock | 3.2089 | 3.2143 | 3.1643 | 3.1693 | 98881468.0 |
| 2007-02-26 10:00:00 | AAPL | Stock | 3.1686 | 3.1714 | 3.1521 | 3.1564 | 68296704.0 |
| 2007-02-26 10:30:00 | AAPL | Stock | 3.1561 | 3.1625 | 3.1375 | 3.1571 | 57151584.0 |
| 2007-02-26 11:00:00 | AAPL | Stock | 3.1571 | 3.1772 | 3.1518 | 3.1536 | 34574848.0 |
| 2007-02-26 11:30:00 | AAPL | Stock | 3.1536 | 3.2071 | 3.1468 | 3.1564 | 28129388.0 |
| 2007-02-26 12:00:00 | AAPL | Stock | 3.1561 | 3.1575 | 3.1393 | 3.1443 | 30339036.0 |
| 2007-02-26 12:30:00 | AAPL | Stock | 3.1443 | 3.1489 | 3.1293 | 3.1321 | 46241860.0 |
| 2007-02-26 13:00:00 | AAPL | Stock | 3.1318 | 3.1429 | 3.1289 | 3.1429 | 23741340.0 |
| 2007-02-26 13:30:00 | AAPL | Stock | 3.1429 | 3.1632 | 3.1421 | 3.1529 | 28690676.0 |
| 2007-02-26 14:00:00 | AAPL | Stock | 3.1525 | 3.1607 | 3.1471 | 3.1564 | 27379800.0 |
| 2007-02-26 14:30:00 | AAPL | Stock | 3.1564 | 3.1657 | 3.1536 | 3.163 | 33441240.0 |
| 2007-02-26 15:00:00 | AAPL | Stock | 3.1629 | 3.1632 | 3.1429 | 3.1557 | 22833356.0 |
| 2007-02-26 15:30:00 | AAPL | Stock | 3.1561 | 3.1643 | 3.1389 | 3.1614 | 97423116.0 |
| 2007-02-26 16:00:00 | AAPL | Stock | 3.1625 | 3.1636 | 3.1504 | 3.1607 | 4085620.0 |
| 2007-02-26 16:30:00 | AAPL | Stock | 3.1607 | 3.1611 | 3.1518 | 3.1568 | 1262576.0 |
| 2007-02-26 17:00:00 | AAPL | Stock | 3.1568 | 3.1611 | 3.1568 | 3.1611 | 439572.0 |
| 2007-02-26 17:30:00 | AAPL | Stock | 3.1571 | 3.2096 | 3.1554 | 3.1564 | 690900.0 |
| 2007-02-26 18:00:00 | AAPL | Stock | 3.1589 | 3.1643 | 3.1589 | 3.1643 | 281652.0 |
| 2007-02-26 18:30:00 | AAPL | Stock | 3.1643 | 3.165 | 3.1586 | 3.1586 | 25760.0 |
| 2007-02-26 19:00:00 | AAPL | Stock | 3.1604 | 3.1604 | 3.1604 | 3.1604 | 2800.0 |
| 2007-02-26 19:30:00 | AAPL | Stock | 3.1589 | 3.1589 | 3.1564 | 3.1586 | 45080.0 |
| 2007-02-26 05:00:00 | MSFT | Stock | 28.92 | 28.93 | 28.92 | 28.93 | 1500.0 |
| 2007-02-26 07:30:00 | MSFT | Stock | 28.92 | 28.92 | 28.92 | 28.92 | 100.0 |
| 2007-02-26 08:00:00 | MSFT | Stock | 29.65 | 31.0 | 28.9 | 28.92 | 22337.0 |
| 2007-02-26 08:30:00 | MSFT | Stock | 28.94 | 28.99 | 28.93 | 28.98 | 30070.0 |
| 2007-02-26 09:00:00 | MSFT | Stock | 28.97 | 28.97 | 28.94 | 28.95 | 62933.0 |
| 2007-02-26 09:30:00 | MSFT | Stock | 28.96 | 29.03 | 28.91 | 28.95 | 8950576.0 |
| 2007-02-26 10:00:00 | MSFT | Stock | 28.95 | 28.99 | 28.94 | 28.94 | 4240266.0 |
| 2007-02-26 10:30:00 | MSFT | Stock | 28.94 | 28.99 | 28.92 | 28.96 | 5328769.0 |
| 2007-02-26 11:00:00 | MSFT | Stock | 28.96 | 28.98 | 28.93 | 28.95 | 2114420.0 |
| 2007-02-26 11:30:00 | MSFT | Stock | 28.95 | 28.97 | 28.93 | 28.96 | 1883256.0 |
| 2007-02-26 12:00:00 | MSFT | Stock | 28.96 | 28.98 | 28.9 | 28.93 | 4070092.0 |
| 2007-02-26 12:30:00 | MSFT | Stock | 28.93 | 28.95 | 28.88 | 28.91 | 4011714.0 |
| 2007-02-26 13:00:00 | MSFT | Stock | 28.9 | 28.95 | 28.89 | 28.9 | 4777667.0 |
| 2007-02-26 13:30:00 | MSFT | Stock | 28.91 | 28.94 | 28.89 | 28.92 | 3198411.0 |
| 2007-02-26 14:00:00 | MSFT | Stock | 28.91 | 28.95 | 28.9 | 28.91 | 2982729.0 |
| 2007-02-26 14:30:00 | MSFT | Stock | 28.91 | 28.98 | 28.9 | 28.93 | 4914614.0 |
| 2007-02-26 15:00:00 | MSFT | Stock | 28.93 | 29.03 | 28.93 | 29.02 | 4080449.0 |
| 2007-02-26 15:30:00 | MSFT | Stock | 29.02 | 29.09 | 28.97 | 29.09 | 6483338.0 |
| 2007-02-26 16:00:00 | MSFT | Stock | 29.09 | 29.09 | 28.95 | 29.07 | 2140468.0 |
| 2007-02-26 16:30:00 | MSFT | Stock | 29.07 | 29.07 | 28.99 | 29.06 | 1119927.0 |
| 2007-02-26 17:00:00 | MSFT | Stock | 29.04 | 29.07 | 29.04 | 29.07 | 60103.0 |
| 2007-02-26 17:30:00 | MSFT | Stock | 29.04 | 29.04 | 29.04 | 29.04 | 1000.0 |
| 2007-02-26 18:30:00 | MSFT | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 300.0 |
> showing 50 of 53,617 rows — these rows as CSV