PREVIEW / stock_30min / 2005-07-18
file: by_date/stock_30min/2005/2005-07-18.parquet size: 825 KB rows: 45,590 symbols: 2,028
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-07-18 08:00:00 | AAPL | Stock | 1.4804 | 1.4821 | 1.475 | 1.4804 | 815248.0 |
| 2005-07-18 08:30:00 | AAPL | Stock | 1.4821 | 1.4821 | 1.4786 | 1.4804 | 519036.0 |
| 2005-07-18 09:00:00 | AAPL | Stock | 1.4793 | 1.4875 | 1.4779 | 1.4793 | 2152864.0 |
| 2005-07-18 09:30:00 | AAPL | Stock | 1.4789 | 1.5036 | 1.4775 | 1.4904 | 153219752.0 |
| 2005-07-18 10:00:00 | AAPL | Stock | 1.4904 | 1.4925 | 1.4825 | 1.49 | 70142772.0 |
| 2005-07-18 10:30:00 | AAPL | Stock | 1.49 | 1.4939 | 1.4868 | 1.4904 | 42658420.0 |
| 2005-07-18 11:00:00 | AAPL | Stock | 1.4904 | 1.4993 | 1.4893 | 1.4936 | 38000396.0 |
| 2005-07-18 11:30:00 | AAPL | Stock | 1.4936 | 1.4957 | 1.4896 | 1.4896 | 26728380.0 |
| 2005-07-18 12:00:00 | AAPL | Stock | 1.49 | 1.4918 | 1.4864 | 1.4879 | 35078960.0 |
| 2005-07-18 12:30:00 | AAPL | Stock | 1.4882 | 1.4946 | 1.4861 | 1.4943 | 26318964.0 |
| 2005-07-18 13:00:00 | AAPL | Stock | 1.4943 | 1.4946 | 1.4875 | 1.4886 | 21378924.0 |
| 2005-07-18 13:30:00 | AAPL | Stock | 1.4886 | 1.4929 | 1.4882 | 1.4895 | 20760208.0 |
| 2005-07-18 14:00:00 | AAPL | Stock | 1.4893 | 1.4921 | 1.4889 | 1.4899 | 19287184.0 |
| 2005-07-18 14:30:00 | AAPL | Stock | 1.4896 | 1.4911 | 1.4843 | 1.4857 | 28546056.0 |
| 2005-07-18 15:00:00 | AAPL | Stock | 1.4857 | 1.4886 | 1.4843 | 1.4864 | 25725476.0 |
| 2005-07-18 15:30:00 | AAPL | Stock | 1.4861 | 1.4886 | 1.4793 | 1.4814 | 63127820.0 |
| 2005-07-18 16:00:00 | AAPL | Stock | 1.4814 | 1.49 | 1.48 | 1.49 | 6892480.0 |
| 2005-07-18 16:30:00 | AAPL | Stock | 1.4904 | 1.4904 | 1.4875 | 1.4896 | 226072.0 |
| 2005-07-18 17:00:00 | AAPL | Stock | 1.4896 | 1.4907 | 1.4818 | 1.4893 | 1149064.0 |
| 2005-07-18 17:30:00 | AAPL | Stock | 1.49 | 1.4907 | 1.4817 | 1.4907 | 155428.0 |
| 2005-07-18 18:00:00 | AAPL | Stock | 1.4896 | 1.4907 | 1.4893 | 1.4896 | 194152.0 |
| 2005-07-18 07:30:00 | MSFT | Stock | 25.71 | 25.71 | 25.71 | 25.71 | 1435.0 |
| 2005-07-18 08:00:00 | MSFT | Stock | 25.79 | 25.79 | 25.69 | 25.69 | 4800.0 |
| 2005-07-18 08:30:00 | MSFT | Stock | 25.69 | 25.79 | 25.69 | 25.74 | 1049406.0 |
| 2005-07-18 09:00:00 | MSFT | Stock | 25.71 | 25.77 | 25.7 | 25.72 | 20008.0 |
| 2005-07-18 09:30:00 | MSFT | Stock | 25.71 | 25.79 | 25.64 | 25.7 | 5071485.0 |
| 2005-07-18 10:00:00 | MSFT | Stock | 25.7 | 25.73 | 25.66 | 25.71 | 4267244.0 |
| 2005-07-18 10:30:00 | MSFT | Stock | 25.71 | 25.73 | 25.67 | 25.699 | 2152511.0 |
| 2005-07-18 11:00:00 | MSFT | Stock | 25.69 | 25.7 | 25.63 | 25.65 | 2763750.0 |
| 2005-07-18 11:30:00 | MSFT | Stock | 25.65 | 25.67 | 25.6 | 25.67 | 2557195.0 |
| 2005-07-18 12:00:00 | MSFT | Stock | 25.66 | 25.71 | 25.65 | 25.7 | 1759813.0 |
| 2005-07-18 12:30:00 | MSFT | Stock | 25.7 | 25.72 | 25.69 | 25.71 | 1326315.0 |
| 2005-07-18 13:00:00 | MSFT | Stock | 25.71 | 25.72 | 25.65 | 25.65 | 1569609.0 |
| 2005-07-18 13:30:00 | MSFT | Stock | 25.66 | 25.7 | 25.63 | 25.66 | 1976097.0 |
| 2005-07-18 14:00:00 | MSFT | Stock | 25.66 | 25.68 | 25.63 | 25.641 | 1722343.0 |
| 2005-07-18 14:30:00 | MSFT | Stock | 25.65 | 25.68 | 25.61 | 25.638 | 1889930.0 |
| 2005-07-18 15:00:00 | MSFT | Stock | 25.63 | 25.69 | 25.62 | 25.62 | 2094391.0 |
| 2005-07-18 15:30:00 | MSFT | Stock | 25.62 | 25.64 | 25.55 | 25.55 | 6744319.0 |
| 2005-07-18 16:00:00 | MSFT | Stock | 25.56 | 25.673 | 25.54 | 25.62 | 1253163.0 |
| 2005-07-18 16:30:00 | MSFT | Stock | 25.62 | 25.7 | 25.6 | 25.7 | 76821.0 |
| 2005-07-18 17:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.68 | 25.68 | 2735.0 |
| 2005-07-18 17:30:00 | MSFT | Stock | 25.67 | 25.68 | 25.55 | 25.67 | 16866.0 |
| 2005-07-18 18:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.67 | 25.67 | 26020.0 |
| 2005-07-18 09:00:00 | NVDA | Stock | 0.2234 | 0.2235 | 0.2234 | 0.2235 | 60000.0 |
| 2005-07-18 09:30:00 | NVDA | Stock | 0.2234 | 0.2235 | 0.2169 | 0.2186 | 186580800.0 |
| 2005-07-18 10:00:00 | NVDA | Stock | 0.2186 | 0.2187 | 0.2162 | 0.2172 | 215115840.0 |
| 2005-07-18 10:30:00 | NVDA | Stock | 0.2173 | 0.2187 | 0.2165 | 0.2167 | 109617120.0 |
| 2005-07-18 11:00:00 | NVDA | Stock | 0.2166 | 0.2202 | 0.2166 | 0.2196 | 118499040.0 |
| 2005-07-18 11:30:00 | NVDA | Stock | 0.2196 | 0.2225 | 0.2192 | 0.2198 | 71083800.0 |
| 2005-07-18 12:00:00 | NVDA | Stock | 0.2198 | 0.2198 | 0.2181 | 0.2186 | 32791080.0 |
> showing 50 of 45,590 rows — these rows as CSV