PREVIEW / stock_30min / 2006-11-24
file: by_date/stock_30min/2006/2006-11-24.parquet size: 586 KB rows: 28,343 symbols: 2,368
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-11-24 05:00:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 11200.0 |
| 2006-11-24 05:30:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 72800.0 |
| 2006-11-24 06:00:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 5600.0 |
| 2006-11-24 07:00:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.2032 | 3.2032 | 5600.0 |
| 2006-11-24 07:30:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.1961 | 3.1964 | 81200.0 |
| 2006-11-24 08:00:00 | AAPL | Stock | 3.2 | 3.2182 | 3.1946 | 3.2136 | 2656668.0 |
| 2006-11-24 08:30:00 | AAPL | Stock | 3.2136 | 3.2168 | 3.2086 | 3.21 | 1409324.0 |
| 2006-11-24 09:00:00 | AAPL | Stock | 3.2114 | 3.2179 | 3.1968 | 3.1968 | 2889516.0 |
| 2006-11-24 09:30:00 | AAPL | Stock | 3.1975 | 3.2554 | 3.1964 | 3.2414 | 85053752.0 |
| 2006-11-24 10:00:00 | AAPL | Stock | 3.2407 | 3.2614 | 3.2343 | 3.2557 | 63552552.0 |
| 2006-11-24 10:30:00 | AAPL | Stock | 3.2554 | 3.2754 | 3.2532 | 3.2729 | 51378852.0 |
| 2006-11-24 11:00:00 | AAPL | Stock | 3.2729 | 3.2946 | 3.27 | 3.2871 | 61475820.0 |
| 2006-11-24 11:30:00 | AAPL | Stock | 3.2871 | 3.3079 | 3.2821 | 3.3071 | 72049908.0 |
| 2006-11-24 12:00:00 | AAPL | Stock | 3.3075 | 3.3243 | 3.3043 | 3.3136 | 76729968.0 |
| 2006-11-24 12:30:00 | AAPL | Stock | 3.3139 | 3.3139 | 3.2721 | 3.2736 | 95778060.0 |
| 2006-11-24 13:00:00 | AAPL | Stock | 3.2736 | 3.2743 | 3.2725 | 3.2725 | 1018724.0 |
| 2006-11-24 16:30:00 | AAPL | Stock | 3.2625 | 3.2625 | 3.2607 | 3.2607 | 74200.0 |
| 2006-11-24 06:00:00 | MSFT | Stock | 29.75 | 29.75 | 29.72 | 29.72 | 980.0 |
| 2006-11-24 07:00:00 | MSFT | Stock | 29.88 | 29.88 | 29.88 | 29.88 | 300.0 |
| 2006-11-24 08:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.76 | 29.76 | 1500.0 |
| 2006-11-24 08:30:00 | MSFT | Stock | 29.76 | 29.76 | 29.68 | 29.68 | 11686.0 |
| 2006-11-24 09:00:00 | MSFT | Stock | 29.7 | 29.76 | 29.65 | 29.65 | 133142.0 |
| 2006-11-24 09:30:00 | MSFT | Stock | 29.66 | 29.75 | 29.64 | 29.68 | 5144648.0 |
| 2006-11-24 10:00:00 | MSFT | Stock | 29.68 | 29.8 | 29.68 | 29.72 | 2583800.0 |
| 2006-11-24 10:30:00 | MSFT | Stock | 29.72 | 29.77 | 29.71 | 29.77 | 1530354.0 |
| 2006-11-24 11:00:00 | MSFT | Stock | 29.762 | 29.84 | 29.75 | 29.79 | 1681501.0 |
| 2006-11-24 11:30:00 | MSFT | Stock | 29.8 | 29.8 | 29.72 | 29.74 | 1507951.0 |
| 2006-11-24 12:00:00 | MSFT | Stock | 29.74 | 29.79 | 29.74 | 29.77 | 1432228.0 |
| 2006-11-24 12:30:00 | MSFT | Stock | 29.77 | 29.83 | 29.73 | 29.77 | 2792462.0 |
| 2006-11-24 13:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.76 | 29.76 | 649611.0 |
| 2006-11-24 16:00:00 | MSFT | Stock | 29.75 | 29.75 | 29.75 | 29.75 | 200.0 |
| 2006-11-24 08:00:00 | NVDA | Stock | 0.6117 | 0.6117 | 0.607 | 0.6082 | 204000.0 |
| 2006-11-24 08:30:00 | NVDA | Stock | 0.6082 | 0.6103 | 0.6082 | 0.609 | 474000.0 |
| 2006-11-24 09:00:00 | NVDA | Stock | 0.609 | 0.609 | 0.6067 | 0.6085 | 390000.0 |
| 2006-11-24 09:30:00 | NVDA | Stock | 0.6083 | 0.6093 | 0.6033 | 0.6082 | 24186600.0 |
| 2006-11-24 10:00:00 | NVDA | Stock | 0.6082 | 0.6132 | 0.6082 | 0.6128 | 16715100.0 |
| 2006-11-24 10:30:00 | NVDA | Stock | 0.613 | 0.6132 | 0.611 | 0.6125 | 12186900.0 |
| 2006-11-24 11:00:00 | NVDA | Stock | 0.6123 | 0.6175 | 0.6118 | 0.6152 | 25005360.0 |
| 2006-11-24 11:30:00 | NVDA | Stock | 0.6153 | 0.6165 | 0.6123 | 0.6133 | 17143080.0 |
| 2006-11-24 12:00:00 | NVDA | Stock | 0.6133 | 0.616 | 0.6123 | 0.616 | 10890960.0 |
| 2006-11-24 12:30:00 | NVDA | Stock | 0.616 | 0.6177 | 0.6147 | 0.6167 | 34539300.0 |
| 2006-11-24 13:00:00 | NVDA | Stock | 0.6163 | 0.6163 | 0.6163 | 0.6163 | 1142100.0 |
| 2006-11-24 08:00:00 | AMZN | Stock | 2.1465 | 2.1465 | 2.1465 | 2.1465 | 4000.0 |
| 2006-11-24 08:30:00 | AMZN | Stock | 2.1435 | 2.1435 | 2.125 | 2.125 | 93900.0 |
| 2006-11-24 09:00:00 | AMZN | Stock | 2.13 | 2.1375 | 2.127 | 2.1295 | 230640.0 |
| 2006-11-24 09:30:00 | AMZN | Stock | 2.128 | 2.14 | 2.123 | 2.1375 | 7868020.0 |
| 2006-11-24 10:00:00 | AMZN | Stock | 2.1375 | 2.147 | 2.1335 | 2.1455 | 6036040.0 |
| 2006-11-24 10:30:00 | AMZN | Stock | 2.146 | 2.146 | 2.1405 | 2.143 | 3092400.0 |
| 2006-11-24 11:00:00 | AMZN | Stock | 2.1425 | 2.144 | 2.13 | 2.1304 | 6435200.0 |
| 2006-11-24 11:30:00 | AMZN | Stock | 2.1305 | 2.132 | 2.124 | 2.1255 | 5463460.0 |
> showing 50 of 28,343 rows — these rows as CSV