PREVIEW / stock_30min / 2005-11-04
file: by_date/stock_30min/2005/2005-11-04.parquet size: 853 KB rows: 45,571 symbols: 2,105
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-04 05:00:00 | AAPL | Stock | 2.175 | 2.175 | 2.175 | 2.175 | 25200.0 |
| 2005-11-04 05:30:00 | AAPL | Stock | 2.1754 | 2.1754 | 2.175 | 2.175 | 28000.0 |
| 2005-11-04 06:00:00 | AAPL | Stock | 2.1696 | 2.1696 | 2.1696 | 2.1696 | 14000.0 |
| 2005-11-04 06:30:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1607 | 2.1607 | 2800.0 |
| 2005-11-04 07:00:00 | AAPL | Stock | 2.15 | 2.1689 | 2.15 | 2.1579 | 1584772.0 |
| 2005-11-04 07:30:00 | AAPL | Stock | 2.1579 | 2.1657 | 2.1571 | 2.1657 | 325864.0 |
| 2005-11-04 08:00:00 | AAPL | Stock | 2.1629 | 2.1779 | 2.1518 | 2.1704 | 6295128.0 |
| 2005-11-04 08:30:00 | AAPL | Stock | 2.1704 | 2.1707 | 2.1618 | 2.1661 | 4307660.0 |
| 2005-11-04 09:00:00 | AAPL | Stock | 2.1668 | 2.1764 | 2.1554 | 2.1554 | 7307440.0 |
| 2005-11-04 09:30:00 | AAPL | Stock | 2.1554 | 2.1664 | 2.1293 | 2.1657 | 220038812.0 |
| 2005-11-04 10:00:00 | AAPL | Stock | 2.1657 | 2.1671 | 2.1446 | 2.1604 | 92813532.0 |
| 2005-11-04 10:30:00 | AAPL | Stock | 2.1604 | 2.1632 | 2.1479 | 2.1629 | 54692316.0 |
| 2005-11-04 11:00:00 | AAPL | Stock | 2.1625 | 2.1871 | 2.1625 | 2.1804 | 89605292.0 |
| 2005-11-04 11:30:00 | AAPL | Stock | 2.1807 | 2.1814 | 2.1696 | 2.1725 | 43428980.0 |
| 2005-11-04 12:00:00 | AAPL | Stock | 2.1729 | 2.1729 | 2.16 | 2.1603 | 47613132.0 |
| 2005-11-04 12:30:00 | AAPL | Stock | 2.16 | 2.1825 | 2.16 | 2.1707 | 30086504.0 |
| 2005-11-04 13:00:00 | AAPL | Stock | 2.1711 | 2.1714 | 2.1625 | 2.1665 | 26986092.0 |
| 2005-11-04 13:30:00 | AAPL | Stock | 2.1668 | 2.17 | 2.1636 | 2.1679 | 20376468.0 |
| 2005-11-04 14:00:00 | AAPL | Stock | 2.1679 | 2.1764 | 2.1664 | 2.1704 | 34942012.0 |
| 2005-11-04 14:30:00 | AAPL | Stock | 2.1707 | 2.1729 | 2.1657 | 2.1714 | 39759720.0 |
| 2005-11-04 15:00:00 | AAPL | Stock | 2.1711 | 2.1718 | 2.1661 | 2.1693 | 30866640.0 |
| 2005-11-04 15:30:00 | AAPL | Stock | 2.1693 | 2.1829 | 2.1689 | 2.1825 | 117778864.0 |
| 2005-11-04 16:00:00 | AAPL | Stock | 2.18 | 2.1821 | 2.164 | 2.1821 | 972300.0 |
| 2005-11-04 16:30:00 | AAPL | Stock | 2.1814 | 2.1839 | 2.1814 | 2.1839 | 379036.0 |
| 2005-11-04 17:00:00 | AAPL | Stock | 2.1832 | 2.185 | 2.1804 | 2.1836 | 159600.0 |
| 2005-11-04 17:30:00 | AAPL | Stock | 2.1836 | 2.1854 | 2.1836 | 2.1854 | 127708.0 |
| 2005-11-04 18:00:00 | AAPL | Stock | 2.1854 | 2.1875 | 2.1839 | 2.1871 | 170716.0 |
| 2005-11-04 08:00:00 | MSFT | Stock | 26.55 | 26.61 | 26.5 | 26.55 | 79546.0 |
| 2005-11-04 08:30:00 | MSFT | Stock | 26.54 | 26.57 | 26.5 | 26.54 | 22018.0 |
| 2005-11-04 09:00:00 | MSFT | Stock | 26.54 | 26.55 | 26.44 | 26.52 | 52668.0 |
| 2005-11-04 09:30:00 | MSFT | Stock | 26.53 | 26.65 | 26.5 | 26.62 | 6183633.0 |
| 2005-11-04 10:00:00 | MSFT | Stock | 26.62 | 26.631 | 26.51 | 26.58 | 4244926.0 |
| 2005-11-04 10:30:00 | MSFT | Stock | 26.58 | 26.59 | 26.45 | 26.529 | 4080159.0 |
| 2005-11-04 11:00:00 | MSFT | Stock | 26.53 | 26.6 | 26.5 | 26.5 | 2982816.0 |
| 2005-11-04 11:30:00 | MSFT | Stock | 26.501 | 26.6 | 26.5 | 26.53 | 3418860.0 |
| 2005-11-04 12:00:00 | MSFT | Stock | 26.531 | 26.59 | 26.48 | 26.56 | 7706477.0 |
| 2005-11-04 12:30:00 | MSFT | Stock | 26.56 | 26.621 | 26.54 | 26.6 | 5422997.0 |
| 2005-11-04 13:00:00 | MSFT | Stock | 26.6 | 26.62 | 26.57 | 26.59 | 3259162.0 |
| 2005-11-04 13:30:00 | MSFT | Stock | 26.59 | 26.59 | 26.53 | 26.56 | 2290799.0 |
| 2005-11-04 14:00:00 | MSFT | Stock | 26.552 | 26.61 | 26.54 | 26.61 | 3388351.0 |
| 2005-11-04 14:30:00 | MSFT | Stock | 26.61 | 26.62 | 26.55 | 26.6 | 2810285.0 |
| 2005-11-04 15:00:00 | MSFT | Stock | 26.6 | 26.62 | 26.56 | 26.61 | 2902872.0 |
| 2005-11-04 15:30:00 | MSFT | Stock | 26.6 | 26.71 | 26.57 | 26.64 | 6802408.0 |
| 2005-11-04 16:00:00 | MSFT | Stock | 26.66 | 26.68 | 26.575 | 26.66 | 217912.0 |
| 2005-11-04 16:30:00 | MSFT | Stock | 26.68 | 26.69 | 26.66 | 26.69 | 438930.0 |
| 2005-11-04 17:00:00 | MSFT | Stock | 26.68 | 26.69 | 26.569 | 26.569 | 6707.0 |
| 2005-11-04 17:30:00 | MSFT | Stock | 26.68 | 26.69 | 26.66 | 26.69 | 9773.0 |
| 2005-11-04 18:00:00 | MSFT | Stock | 26.67 | 26.69 | 26.67 | 26.69 | 310.0 |
| 2005-11-04 08:30:00 | NVDA | Stock | 0.2887 | 0.2887 | 0.2887 | 0.2887 | 36000.0 |
| 2005-11-04 09:00:00 | NVDA | Stock | 0.2887 | 0.2897 | 0.2887 | 0.2895 | 1506480.0 |
> showing 50 of 45,571 rows — these rows as CSV