PREVIEW / stock_30min / 2000-03-20
file: by_date/stock_30min/2000/2000-03-20.parquet size: 406 KB rows: 23,731 symbols: 1,141
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-20 09:30:00 | AAPL | Stock | 1.1027 | 1.1228 | 1.1004 | 1.1044 | 18121600.0 |
| 2000-03-20 10:00:00 | AAPL | Stock | 1.1038 | 1.1094 | 1.096 | 1.1038 | 13070400.0 |
| 2000-03-20 10:30:00 | AAPL | Stock | 1.1049 | 1.1071 | 1.0971 | 1.1004 | 8008000.0 |
| 2000-03-20 11:00:00 | AAPL | Stock | 1.1004 | 1.1094 | 1.0926 | 1.1071 | 14067200.0 |
| 2000-03-20 11:30:00 | AAPL | Stock | 1.1071 | 1.1138 | 1.1066 | 1.1088 | 13148800.0 |
| 2000-03-20 12:00:00 | AAPL | Stock | 1.1083 | 1.1194 | 1.1083 | 1.1155 | 21011200.0 |
| 2000-03-20 12:30:00 | AAPL | Stock | 1.1161 | 1.1205 | 1.1144 | 1.1144 | 11513600.0 |
| 2000-03-20 13:00:00 | AAPL | Stock | 1.1144 | 1.1172 | 1.1099 | 1.1155 | 9956800.0 |
| 2000-03-20 13:30:00 | AAPL | Stock | 1.1161 | 1.1272 | 1.115 | 1.1211 | 21672000.0 |
| 2000-03-20 14:00:00 | AAPL | Stock | 1.1228 | 1.125 | 1.1172 | 1.1177 | 17651200.0 |
| 2000-03-20 14:30:00 | AAPL | Stock | 1.1172 | 1.1183 | 1.1071 | 1.1071 | 20305600.0 |
| 2000-03-20 15:00:00 | AAPL | Stock | 1.1077 | 1.113 | 1.0977 | 1.1027 | 11636800.0 |
| 2000-03-20 15:30:00 | AAPL | Stock | 1.1038 | 1.1099 | 1.0982 | 1.0988 | 11804800.0 |
| 2000-03-20 16:00:00 | AAPL | Stock | 1.0977 | 1.0988 | 1.0977 | 1.0982 | 571200.0 |
| 2000-03-20 09:30:00 | MSFT | Stock | 49.375 | 49.6875 | 49.0 | 49.3125 | 6764400.0 |
| 2000-03-20 10:00:00 | MSFT | Stock | 49.4375 | 49.875 | 49.125 | 49.3125 | 4624600.0 |
| 2000-03-20 10:30:00 | MSFT | Stock | 49.2812 | 49.6875 | 49.0625 | 49.5312 | 4044600.0 |
| 2000-03-20 11:00:00 | MSFT | Stock | 49.5 | 49.5625 | 49.25 | 49.375 | 2531800.0 |
| 2000-03-20 11:30:00 | MSFT | Stock | 49.375 | 49.6562 | 49.3125 | 49.4062 | 2665400.0 |
| 2000-03-20 12:00:00 | MSFT | Stock | 49.4688 | 49.4688 | 49.1875 | 49.375 | 1678800.0 |
| 2000-03-20 12:30:00 | MSFT | Stock | 49.4062 | 49.4062 | 49.0312 | 49.1875 | 1640600.0 |
| 2000-03-20 13:00:00 | MSFT | Stock | 49.2188 | 49.2344 | 48.75 | 48.9062 | 2186200.0 |
| 2000-03-20 13:30:00 | MSFT | Stock | 48.9062 | 49.0625 | 48.5312 | 48.5625 | 1711800.0 |
| 2000-03-20 14:00:00 | MSFT | Stock | 48.5625 | 48.75 | 48.375 | 48.6562 | 3385400.0 |
| 2000-03-20 14:30:00 | MSFT | Stock | 48.6875 | 48.875 | 48.4375 | 48.5312 | 3880200.0 |
| 2000-03-20 15:00:00 | MSFT | Stock | 48.5 | 48.625 | 48.25 | 48.4375 | 3278200.0 |
| 2000-03-20 15:30:00 | MSFT | Stock | 48.4375 | 49.0938 | 48.3438 | 48.625 | 5075400.0 |
| 2000-03-20 16:00:00 | MSFT | Stock | 48.6875 | 48.6875 | 48.6562 | 48.6875 | 79600.0 |
| 2000-03-20 09:30:00 | NVDA | Stock | 0.2163 | 0.2167 | 0.2013 | 0.2052 | 48768000.0 |
| 2000-03-20 10:00:00 | NVDA | Stock | 0.2052 | 0.2232 | 0.2031 | 0.2135 | 61200000.0 |
| 2000-03-20 10:30:00 | NVDA | Stock | 0.2125 | 0.2135 | 0.2074 | 0.2115 | 27696000.0 |
| 2000-03-20 11:00:00 | NVDA | Stock | 0.2125 | 0.2125 | 0.2076 | 0.2083 | 14016000.0 |
| 2000-03-20 11:30:00 | NVDA | Stock | 0.2081 | 0.2125 | 0.2068 | 0.2115 | 14112000.0 |
| 2000-03-20 12:00:00 | NVDA | Stock | 0.2104 | 0.2142 | 0.2104 | 0.2125 | 12048000.0 |
| 2000-03-20 12:30:00 | NVDA | Stock | 0.2135 | 0.2167 | 0.2109 | 0.2147 | 15264000.0 |
| 2000-03-20 13:00:00 | NVDA | Stock | 0.2156 | 0.2156 | 0.2104 | 0.2117 | 15552000.0 |
| 2000-03-20 13:30:00 | NVDA | Stock | 0.2118 | 0.2167 | 0.2118 | 0.2156 | 15936000.0 |
| 2000-03-20 14:00:00 | NVDA | Stock | 0.2156 | 0.2164 | 0.2122 | 0.2125 | 16848000.0 |
| 2000-03-20 14:30:00 | NVDA | Stock | 0.2125 | 0.2129 | 0.2083 | 0.2113 | 26544000.0 |
| 2000-03-20 15:00:00 | NVDA | Stock | 0.21 | 0.2133 | 0.2089 | 0.2094 | 10944000.0 |
| 2000-03-20 15:30:00 | NVDA | Stock | 0.2094 | 0.2164 | 0.2062 | 0.2083 | 30096000.0 |
| 2000-03-20 16:00:00 | NVDA | Stock | 0.2079 | 0.2087 | 0.2079 | 0.2079 | 2736000.0 |
| 2000-03-20 09:30:00 | AMZN | Stock | 3.175 | 3.2125 | 3.1188 | 3.2 | 16580000.0 |
| 2000-03-20 10:00:00 | AMZN | Stock | 3.1938 | 3.225 | 3.1875 | 3.1938 | 10376000.0 |
| 2000-03-20 10:30:00 | AMZN | Stock | 3.1938 | 3.2063 | 3.1688 | 3.1969 | 7586000.0 |
| 2000-03-20 11:00:00 | AMZN | Stock | 3.1969 | 3.2 | 3.175 | 3.1844 | 4178000.0 |
| 2000-03-20 11:30:00 | AMZN | Stock | 3.1781 | 3.1938 | 3.1625 | 3.1656 | 5974000.0 |
| 2000-03-20 12:00:00 | AMZN | Stock | 3.1688 | 3.1875 | 3.1656 | 3.175 | 4186000.0 |
| 2000-03-20 12:30:00 | AMZN | Stock | 3.1781 | 3.1781 | 3.1625 | 3.1688 | 4196000.0 |
| 2000-03-20 13:00:00 | AMZN | Stock | 3.1719 | 3.1719 | 3.1438 | 3.1469 | 7750000.0 |
> showing 50 of 23,731 rows — these rows as CSV