PREVIEW / stock_30min / 2006-06-01
file: by_date/stock_30min/2006/2006-06-01.parquet size: 946 KB rows: 51,110 symbols: 2,266
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-01 07:30:00 | AAPL | Stock | 2.1286 | 2.1286 | 2.1286 | 2.1286 | 5600.0 |
| 2006-06-01 08:00:00 | AAPL | Stock | 2.1286 | 2.1339 | 2.1261 | 2.1296 | 434084.0 |
| 2006-06-01 08:30:00 | AAPL | Stock | 2.1257 | 2.1479 | 2.1254 | 2.1468 | 1898260.0 |
| 2006-06-01 09:00:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1304 | 2.1386 | 1974056.0 |
| 2006-06-01 09:30:00 | AAPL | Stock | 2.1375 | 2.1521 | 2.1257 | 2.1429 | 125852776.0 |
| 2006-06-01 10:00:00 | AAPL | Stock | 2.1436 | 2.1707 | 2.1357 | 2.1668 | 123401824.0 |
| 2006-06-01 10:30:00 | AAPL | Stock | 2.1671 | 2.1993 | 2.1671 | 2.1968 | 149910068.0 |
| 2006-06-01 11:00:00 | AAPL | Stock | 2.1971 | 2.2118 | 2.1911 | 2.205 | 86199932.0 |
| 2006-06-01 11:30:00 | AAPL | Stock | 2.205 | 2.2136 | 2.2011 | 2.2046 | 57544760.0 |
| 2006-06-01 12:00:00 | AAPL | Stock | 2.2046 | 2.2086 | 2.2011 | 2.2071 | 30145668.0 |
| 2006-06-01 12:30:00 | AAPL | Stock | 2.2071 | 2.2171 | 2.2 | 2.2007 | 47529356.0 |
| 2006-06-01 13:00:00 | AAPL | Stock | 2.2004 | 2.2139 | 2.2 | 2.2129 | 22524208.0 |
| 2006-06-01 13:30:00 | AAPL | Stock | 2.2128 | 2.2136 | 2.2064 | 2.2107 | 15946504.0 |
| 2006-06-01 14:00:00 | AAPL | Stock | 2.2107 | 2.2129 | 2.1993 | 2.2104 | 41244252.0 |
| 2006-06-01 14:30:00 | AAPL | Stock | 2.21 | 2.2207 | 2.2082 | 2.2164 | 58748536.0 |
| 2006-06-01 15:00:00 | AAPL | Stock | 2.2168 | 2.2243 | 2.2082 | 2.2218 | 59120992.0 |
| 2006-06-01 15:30:00 | AAPL | Stock | 2.2218 | 2.2225 | 2.2089 | 2.2175 | 96527172.0 |
| 2006-06-01 16:00:00 | AAPL | Stock | 2.2193 | 2.2214 | 2.2143 | 2.2196 | 2142308.0 |
| 2006-06-01 16:30:00 | AAPL | Stock | 2.2186 | 2.2211 | 2.2182 | 2.2204 | 259840.0 |
| 2006-06-01 17:00:00 | AAPL | Stock | 2.2204 | 2.2204 | 2.2179 | 2.2204 | 501984.0 |
| 2006-06-01 17:30:00 | AAPL | Stock | 2.2189 | 2.2189 | 2.2179 | 2.2186 | 110488.0 |
| 2006-06-01 18:00:00 | AAPL | Stock | 2.2186 | 2.2204 | 2.2179 | 2.2204 | 209216.0 |
| 2006-06-01 05:30:00 | MSFT | Stock | 22.68 | 22.68 | 22.68 | 22.68 | 200.0 |
| 2006-06-01 06:00:00 | MSFT | Stock | 22.65 | 22.65 | 22.65 | 22.65 | 400.0 |
| 2006-06-01 07:00:00 | MSFT | Stock | 22.64 | 22.67 | 22.64 | 22.67 | 6300.0 |
| 2006-06-01 07:30:00 | MSFT | Stock | 22.67 | 22.67 | 22.67 | 22.67 | 800.0 |
| 2006-06-01 08:00:00 | MSFT | Stock | 22.7 | 22.73 | 22.65 | 22.72 | 75821.0 |
| 2006-06-01 08:30:00 | MSFT | Stock | 22.72 | 22.74 | 22.65 | 22.74 | 100537.0 |
| 2006-06-01 09:00:00 | MSFT | Stock | 22.65 | 22.75 | 22.65 | 22.74 | 126766.0 |
| 2006-06-01 09:30:00 | MSFT | Stock | 22.74 | 22.79 | 22.67 | 22.69 | 11134877.0 |
| 2006-06-01 10:00:00 | MSFT | Stock | 22.69 | 22.79 | 22.66 | 22.69 | 5181437.0 |
| 2006-06-01 10:30:00 | MSFT | Stock | 22.69 | 22.759 | 22.68 | 22.7 | 5722505.0 |
| 2006-06-01 11:00:00 | MSFT | Stock | 22.69 | 22.75 | 22.69 | 22.7 | 5693920.0 |
| 2006-06-01 11:30:00 | MSFT | Stock | 22.71 | 22.72 | 22.65 | 22.66 | 5019615.0 |
| 2006-06-01 12:00:00 | MSFT | Stock | 22.66 | 22.68 | 22.62 | 22.67 | 4802867.0 |
| 2006-06-01 12:30:00 | MSFT | Stock | 22.67 | 22.71 | 22.65 | 22.67 | 3730205.0 |
| 2006-06-01 13:00:00 | MSFT | Stock | 22.67 | 22.67 | 22.65 | 22.66 | 1266978.0 |
| 2006-06-01 13:30:00 | MSFT | Stock | 22.65 | 22.67 | 22.649 | 22.66 | 1669608.0 |
| 2006-06-01 14:00:00 | MSFT | Stock | 22.66 | 22.72 | 22.65 | 22.7 | 4555860.0 |
| 2006-06-01 14:30:00 | MSFT | Stock | 22.7 | 22.75 | 22.69 | 22.74 | 4717639.0 |
| 2006-06-01 15:00:00 | MSFT | Stock | 22.75 | 22.77 | 22.65 | 22.69 | 8009575.0 |
| 2006-06-01 15:30:00 | MSFT | Stock | 22.7 | 22.84 | 22.69 | 22.84 | 10397334.0 |
| 2006-06-01 16:00:00 | MSFT | Stock | 22.81 | 22.83 | 22.78 | 22.81 | 122830.0 |
| 2006-06-01 16:30:00 | MSFT | Stock | 22.81 | 22.85 | 22.8 | 22.8 | 42585.0 |
| 2006-06-01 17:00:00 | MSFT | Stock | 22.8 | 22.81 | 22.8 | 22.8 | 11300.0 |
| 2006-06-01 17:30:00 | MSFT | Stock | 22.81 | 22.81 | 22.8 | 22.8 | 6425.0 |
| 2006-06-01 18:00:00 | MSFT | Stock | 22.82 | 22.829 | 22.8 | 22.82 | 8090.0 |
| 2006-06-01 08:00:00 | NVDA | Stock | 0.3808 | 0.383 | 0.3808 | 0.383 | 124200.0 |
| 2006-06-01 08:30:00 | NVDA | Stock | 0.3833 | 0.3837 | 0.3833 | 0.3837 | 24000.0 |
| 2006-06-01 09:00:00 | NVDA | Stock | 0.3827 | 0.3873 | 0.3827 | 0.3873 | 444000.0 |
> showing 50 of 51,110 rows — these rows as CSV