PREVIEW / stock_30min / 2004-04-20
file: by_date/stock_30min/2004/2004-04-20.parquet size: 779 KB rows: 41,918 symbols: 1,752
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-04-20 08:00:00 | AAPL | Stock | 0.5082 | 0.5082 | 0.5063 | 0.5063 | 47600.0 |
| 2004-04-20 08:30:00 | AAPL | Stock | 0.508 | 0.508 | 0.5064 | 0.5075 | 340480.0 |
| 2004-04-20 09:00:00 | AAPL | Stock | 0.5063 | 0.5088 | 0.5029 | 0.5038 | 639016.0 |
| 2004-04-20 09:30:00 | AAPL | Stock | 0.5055 | 0.5073 | 0.5038 | 0.5061 | 41248648.0 |
| 2004-04-20 10:00:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5027 | 0.5034 | 28894656.0 |
| 2004-04-20 10:30:00 | AAPL | Stock | 0.5034 | 0.5055 | 0.503 | 0.5036 | 22780800.0 |
| 2004-04-20 11:00:00 | AAPL | Stock | 0.5036 | 0.5045 | 0.4993 | 0.4996 | 46530904.0 |
| 2004-04-20 11:30:00 | AAPL | Stock | 0.4998 | 0.5023 | 0.4995 | 0.502 | 18632040.0 |
| 2004-04-20 12:00:00 | AAPL | Stock | 0.5021 | 0.5039 | 0.5011 | 0.5038 | 15442728.0 |
| 2004-04-20 12:30:00 | AAPL | Stock | 0.5039 | 0.5057 | 0.5032 | 0.5046 | 13804896.0 |
| 2004-04-20 13:00:00 | AAPL | Stock | 0.5046 | 0.5046 | 0.5027 | 0.5027 | 7957096.0 |
| 2004-04-20 13:30:00 | AAPL | Stock | 0.5027 | 0.5036 | 0.5027 | 0.5036 | 10305288.0 |
| 2004-04-20 14:00:00 | AAPL | Stock | 0.5034 | 0.5036 | 0.5025 | 0.5027 | 7470512.0 |
| 2004-04-20 14:30:00 | AAPL | Stock | 0.5025 | 0.5036 | 0.5004 | 0.5004 | 28728112.0 |
| 2004-04-20 15:00:00 | AAPL | Stock | 0.5004 | 0.5013 | 0.4984 | 0.4993 | 30955232.0 |
| 2004-04-20 15:30:00 | AAPL | Stock | 0.4991 | 0.4995 | 0.4921 | 0.4938 | 58253832.0 |
| 2004-04-20 16:00:00 | AAPL | Stock | 0.4938 | 0.4952 | 0.4929 | 0.4948 | 2376864.0 |
| 2004-04-20 16:30:00 | AAPL | Stock | 0.4946 | 0.5019 | 0.4946 | 0.5019 | 1422400.0 |
| 2004-04-20 17:00:00 | AAPL | Stock | 0.4961 | 0.4961 | 0.4961 | 0.4961 | 22400.0 |
| 2004-04-20 17:30:00 | AAPL | Stock | 0.4933 | 0.4933 | 0.493 | 0.493 | 50456.0 |
| 2004-04-20 08:00:00 | MSFT | Stock | 25.535 | 25.67 | 25.53 | 25.65 | 59062.0 |
| 2004-04-20 08:30:00 | MSFT | Stock | 25.65 | 25.65 | 25.61 | 25.65 | 24788.0 |
| 2004-04-20 09:00:00 | MSFT | Stock | 25.69 | 25.74 | 25.53 | 25.64 | 501310.0 |
| 2004-04-20 09:30:00 | MSFT | Stock | 25.64 | 25.78 | 25.61 | 25.78 | 5986190.0 |
| 2004-04-20 10:00:00 | MSFT | Stock | 25.77 | 25.81 | 25.7 | 25.72 | 3735072.0 |
| 2004-04-20 10:30:00 | MSFT | Stock | 25.729 | 25.84 | 25.7 | 25.8 | 5120081.0 |
| 2004-04-20 11:00:00 | MSFT | Stock | 25.8 | 25.81 | 25.69 | 25.759 | 4540717.0 |
| 2004-04-20 11:30:00 | MSFT | Stock | 25.76 | 25.81 | 25.72 | 25.74 | 3973275.0 |
| 2004-04-20 12:00:00 | MSFT | Stock | 25.74 | 25.8 | 25.74 | 25.8 | 2161588.0 |
| 2004-04-20 12:30:00 | MSFT | Stock | 25.8 | 25.84 | 25.78 | 25.8 | 3240704.0 |
| 2004-04-20 13:00:00 | MSFT | Stock | 25.79 | 25.82 | 25.75 | 25.77 | 2383994.0 |
| 2004-04-20 13:30:00 | MSFT | Stock | 25.77 | 25.88 | 25.75 | 25.83 | 2690723.0 |
| 2004-04-20 14:00:00 | MSFT | Stock | 25.84 | 25.841 | 25.7 | 25.71 | 3971218.0 |
| 2004-04-20 14:30:00 | MSFT | Stock | 25.71 | 25.73 | 25.56 | 25.6 | 5794359.0 |
| 2004-04-20 15:00:00 | MSFT | Stock | 25.6 | 25.67 | 25.57 | 25.59 | 4621845.0 |
| 2004-04-20 15:30:00 | MSFT | Stock | 25.59 | 25.62 | 25.31 | 25.31 | 7721911.0 |
| 2004-04-20 16:00:00 | MSFT | Stock | 25.32 | 25.45 | 25.28 | 25.38 | 724505.0 |
| 2004-04-20 16:30:00 | MSFT | Stock | 25.37 | 25.7196 | 25.37 | 25.7196 | 1040600.0 |
| 2004-04-20 17:00:00 | MSFT | Stock | 25.46 | 25.48 | 25.45 | 25.45 | 10800.0 |
| 2004-04-20 17:30:00 | MSFT | Stock | 25.43 | 25.43 | 25.3227 | 25.42 | 19016.0 |
| 2004-04-20 18:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.43 | 25.43 | 1800.0 |
| 2004-04-20 09:00:00 | NVDA | Stock | 0.1965 | 0.1971 | 0.1965 | 0.1971 | 708240.0 |
| 2004-04-20 09:30:00 | NVDA | Stock | 0.197 | 0.1987 | 0.1954 | 0.1987 | 50308440.0 |
| 2004-04-20 10:00:00 | NVDA | Stock | 0.1988 | 0.1992 | 0.1947 | 0.1958 | 69675240.0 |
| 2004-04-20 10:30:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1942 | 0.1942 | 24707880.0 |
| 2004-04-20 11:00:00 | NVDA | Stock | 0.1942 | 0.1949 | 0.1929 | 0.1929 | 35694600.0 |
| 2004-04-20 11:30:00 | NVDA | Stock | 0.1929 | 0.1937 | 0.1925 | 0.1925 | 28986120.0 |
| 2004-04-20 12:00:00 | NVDA | Stock | 0.1926 | 0.1947 | 0.1926 | 0.1942 | 20987400.0 |
| 2004-04-20 12:30:00 | NVDA | Stock | 0.1944 | 0.1947 | 0.1937 | 0.1937 | 11861880.0 |
| 2004-04-20 13:00:00 | NVDA | Stock | 0.1937 | 0.1944 | 0.1937 | 0.1937 | 37647720.0 |
> showing 50 of 41,918 rows — these rows as CSV