PREVIEW / stock_30min / 2004-01-02
file: by_date/stock_30min/2004/2004-01-02.parquet size: 730 KB rows: 38,495 symbols: 1,707
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-02 08:00:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.3821 | 0.3821 | 56000.0 |
| 2004-01-02 09:00:00 | AAPL | Stock | 0.3816 | 0.3859 | 0.3816 | 0.3859 | 2203600.0 |
| 2004-01-02 09:30:00 | AAPL | Stock | 0.3848 | 0.3884 | 0.3816 | 0.3825 | 30935856.0 |
| 2004-01-02 10:00:00 | AAPL | Stock | 0.3823 | 0.3846 | 0.382 | 0.383 | 16471112.0 |
| 2004-01-02 10:30:00 | AAPL | Stock | 0.3825 | 0.3838 | 0.3821 | 0.3836 | 9297736.0 |
| 2004-01-02 11:00:00 | AAPL | Stock | 0.3832 | 0.3836 | 0.382 | 0.3821 | 7058856.0 |
| 2004-01-02 11:30:00 | AAPL | Stock | 0.3823 | 0.3832 | 0.382 | 0.3825 | 4283160.0 |
| 2004-01-02 12:00:00 | AAPL | Stock | 0.3825 | 0.3834 | 0.3823 | 0.3834 | 4787888.0 |
| 2004-01-02 12:30:00 | AAPL | Stock | 0.3834 | 0.3836 | 0.3819 | 0.3823 | 5789448.0 |
| 2004-01-02 13:00:00 | AAPL | Stock | 0.3825 | 0.3839 | 0.382 | 0.3834 | 4242224.0 |
| 2004-01-02 13:30:00 | AAPL | Stock | 0.3832 | 0.3833 | 0.3821 | 0.3823 | 1961512.0 |
| 2004-01-02 14:00:00 | AAPL | Stock | 0.3825 | 0.3827 | 0.3814 | 0.3818 | 7381360.0 |
| 2004-01-02 14:30:00 | AAPL | Stock | 0.3818 | 0.382 | 0.3796 | 0.3804 | 10193288.0 |
| 2004-01-02 15:00:00 | AAPL | Stock | 0.3802 | 0.3814 | 0.3784 | 0.3795 | 10228960.0 |
| 2004-01-02 15:30:00 | AAPL | Stock | 0.3793 | 0.3809 | 0.3782 | 0.3782 | 14501872.0 |
| 2004-01-02 16:00:00 | AAPL | Stock | 0.3796 | 0.3802 | 0.3782 | 0.3789 | 1367464.0 |
| 2004-01-02 16:30:00 | AAPL | Stock | 0.3795 | 0.3799 | 0.3789 | 0.3799 | 669088.0 |
| 2004-01-02 17:00:00 | AAPL | Stock | 0.3791 | 0.3791 | 0.3791 | 0.3791 | 28000.0 |
| 2004-01-02 18:00:00 | AAPL | Stock | 0.3793 | 0.3793 | 0.3793 | 0.3793 | 28000.0 |
| 2004-01-02 08:00:00 | MSFT | Stock | 27.5 | 27.55 | 27.5 | 27.55 | 19800.0 |
| 2004-01-02 08:30:00 | MSFT | Stock | 27.56 | 27.59 | 27.56 | 27.58 | 37400.0 |
| 2004-01-02 09:00:00 | MSFT | Stock | 27.58 | 27.6 | 27.52 | 27.58 | 216604.0 |
| 2004-01-02 09:30:00 | MSFT | Stock | 27.58 | 27.61 | 27.52 | 27.59 | 5227310.0 |
| 2004-01-02 10:00:00 | MSFT | Stock | 27.59 | 27.69 | 27.55 | 27.64 | 4796076.0 |
| 2004-01-02 10:30:00 | MSFT | Stock | 27.64 | 27.75 | 27.639 | 27.75 | 3812790.0 |
| 2004-01-02 11:00:00 | MSFT | Stock | 27.75 | 27.76 | 27.68 | 27.71 | 2979134.0 |
| 2004-01-02 11:30:00 | MSFT | Stock | 27.71 | 27.77 | 27.7 | 27.731 | 2681881.0 |
| 2004-01-02 12:00:00 | MSFT | Stock | 27.74 | 27.75 | 27.62 | 27.66 | 3162636.0 |
| 2004-01-02 12:30:00 | MSFT | Stock | 27.66 | 27.74 | 27.65 | 27.71 | 1571731.0 |
| 2004-01-02 13:00:00 | MSFT | Stock | 27.71 | 27.72 | 27.66 | 27.67 | 1437364.0 |
| 2004-01-02 13:30:00 | MSFT | Stock | 27.671 | 27.72 | 27.66 | 27.67 | 1473277.0 |
| 2004-01-02 14:00:00 | MSFT | Stock | 27.68 | 27.69 | 27.56 | 27.57 | 2812036.0 |
| 2004-01-02 14:30:00 | MSFT | Stock | 27.57 | 27.58 | 27.42 | 27.45 | 3996661.0 |
| 2004-01-02 15:00:00 | MSFT | Stock | 27.45 | 27.46 | 27.33 | 27.42 | 2992872.0 |
| 2004-01-02 15:30:00 | MSFT | Stock | 27.43 | 27.5 | 27.38 | 27.42 | 3876387.0 |
| 2004-01-02 16:00:00 | MSFT | Stock | 27.41 | 27.5 | 27.38 | 27.48 | 729911.0 |
| 2004-01-02 16:30:00 | MSFT | Stock | 27.39 | 27.565 | 27.39 | 27.4531 | 85003.0 |
| 2004-01-02 17:00:00 | MSFT | Stock | 27.51 | 27.51 | 27.42 | 27.42 | 258405.0 |
| 2004-01-02 17:30:00 | MSFT | Stock | 27.48 | 27.49 | 27.47 | 27.49 | 1800.0 |
| 2004-01-02 18:00:00 | MSFT | Stock | 27.48 | 27.48 | 27.48 | 27.48 | 400.0 |
| 2004-01-02 08:00:00 | NVDA | Stock | 0.1937 | 0.1937 | 0.1937 | 0.1937 | 60000.0 |
| 2004-01-02 09:00:00 | NVDA | Stock | 0.1948 | 0.1982 | 0.1948 | 0.1982 | 4876200.0 |
| 2004-01-02 09:30:00 | NVDA | Stock | 0.1964 | 0.1983 | 0.1958 | 0.1968 | 58936800.0 |
| 2004-01-02 10:00:00 | NVDA | Stock | 0.1968 | 0.1991 | 0.1964 | 0.1983 | 57683160.0 |
| 2004-01-02 10:30:00 | NVDA | Stock | 0.1983 | 0.1983 | 0.1974 | 0.1979 | 24806040.0 |
| 2004-01-02 11:00:00 | NVDA | Stock | 0.1979 | 0.1987 | 0.1969 | 0.197 | 28324920.0 |
| 2004-01-02 11:30:00 | NVDA | Stock | 0.1971 | 0.1975 | 0.1952 | 0.1953 | 43005000.0 |
| 2004-01-02 12:00:00 | NVDA | Stock | 0.1953 | 0.1958 | 0.1941 | 0.1942 | 40175040.0 |
| 2004-01-02 12:30:00 | NVDA | Stock | 0.1942 | 0.1957 | 0.1942 | 0.1956 | 17036280.0 |
| 2004-01-02 13:00:00 | NVDA | Stock | 0.1956 | 0.1958 | 0.1947 | 0.1957 | 8105760.0 |
> showing 50 of 38,495 rows — these rows as CSV