PREVIEW / stock_30min / 2006-12-26
file: by_date/stock_30min/2006/2006-12-26.parquet size: 931 KB rows: 51,585 symbols: 2,461
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-12-26 08:00:00 | AAPL | Stock | 2.9479 | 2.9479 | 2.9304 | 2.9382 | 489216.0 |
| 2006-12-26 08:30:00 | AAPL | Stock | 2.9325 | 2.9393 | 2.9325 | 2.9339 | 336000.0 |
| 2006-12-26 09:00:00 | AAPL | Stock | 2.9339 | 2.9346 | 2.9307 | 2.9343 | 720300.0 |
| 2006-12-26 09:30:00 | AAPL | Stock | 2.9339 | 2.9489 | 2.9182 | 2.9243 | 72387280.0 |
| 2006-12-26 10:00:00 | AAPL | Stock | 2.9246 | 2.9329 | 2.9125 | 2.9232 | 42883652.0 |
| 2006-12-26 10:30:00 | AAPL | Stock | 2.9232 | 2.9329 | 2.8993 | 2.9068 | 50493520.0 |
| 2006-12-26 11:00:00 | AAPL | Stock | 2.9071 | 2.9171 | 2.9041 | 2.9086 | 38650220.0 |
| 2006-12-26 11:30:00 | AAPL | Stock | 2.9086 | 2.9096 | 2.8907 | 2.8996 | 40655524.0 |
| 2006-12-26 12:00:00 | AAPL | Stock | 2.8993 | 2.9257 | 2.8889 | 2.9018 | 46376316.0 |
| 2006-12-26 12:30:00 | AAPL | Stock | 2.9018 | 2.915 | 2.9 | 2.9061 | 27448484.0 |
| 2006-12-26 13:00:00 | AAPL | Stock | 2.9061 | 2.9193 | 2.9043 | 2.9154 | 23854796.0 |
| 2006-12-26 13:30:00 | AAPL | Stock | 2.9154 | 2.9264 | 2.9121 | 2.9211 | 26796588.0 |
| 2006-12-26 14:00:00 | AAPL | Stock | 2.9207 | 2.9229 | 2.9154 | 2.9182 | 21476644.0 |
| 2006-12-26 14:30:00 | AAPL | Stock | 2.9182 | 2.9189 | 2.9032 | 2.9089 | 25013128.0 |
| 2006-12-26 15:00:00 | AAPL | Stock | 2.9086 | 2.9179 | 2.9061 | 2.9093 | 21180460.0 |
| 2006-12-26 15:30:00 | AAPL | Stock | 2.9096 | 2.915 | 2.9079 | 2.9118 | 45819256.0 |
| 2006-12-26 16:00:00 | AAPL | Stock | 2.9111 | 2.915 | 2.9107 | 2.9114 | 943488.0 |
| 2006-12-26 16:30:00 | AAPL | Stock | 2.9111 | 2.9193 | 2.9111 | 2.9193 | 249032.0 |
| 2006-12-26 17:00:00 | AAPL | Stock | 2.915 | 2.915 | 2.9136 | 2.9136 | 57680.0 |
| 2006-12-26 17:30:00 | AAPL | Stock | 2.9129 | 2.9143 | 2.9089 | 2.91 | 573832.0 |
| 2006-12-26 18:00:00 | AAPL | Stock | 2.9104 | 2.9125 | 2.9054 | 2.9054 | 131796.0 |
| 2006-12-26 18:30:00 | AAPL | Stock | 2.9089 | 2.91 | 2.9057 | 2.9075 | 67200.0 |
| 2006-12-26 19:00:00 | AAPL | Stock | 2.9071 | 2.9082 | 2.9054 | 2.9082 | 89628.0 |
| 2006-12-26 19:30:00 | AAPL | Stock | 2.9071 | 2.9086 | 2.9057 | 2.9061 | 138460.0 |
| 2006-12-26 08:00:00 | MSFT | Stock | 29.51 | 29.52 | 29.51 | 29.52 | 800.0 |
| 2006-12-26 08:30:00 | MSFT | Stock | 29.58 | 29.58 | 29.58 | 29.58 | 1100.0 |
| 2006-12-26 09:00:00 | MSFT | Stock | 29.57 | 29.59 | 29.45 | 29.5 | 119715.0 |
| 2006-12-26 09:30:00 | MSFT | Stock | 29.53 | 29.53 | 29.4 | 29.49 | 3383330.0 |
| 2006-12-26 10:00:00 | MSFT | Stock | 29.5 | 29.56 | 29.47 | 29.56 | 2290405.0 |
| 2006-12-26 10:30:00 | MSFT | Stock | 29.56 | 29.64 | 29.53 | 29.64 | 1503513.0 |
| 2006-12-26 11:00:00 | MSFT | Stock | 29.64 | 29.74 | 29.64 | 29.697 | 1906109.0 |
| 2006-12-26 11:30:00 | MSFT | Stock | 29.7 | 29.78 | 29.68 | 29.777 | 1515030.0 |
| 2006-12-26 12:00:00 | MSFT | Stock | 29.77 | 30.0 | 29.66 | 29.67 | 1238832.0 |
| 2006-12-26 12:30:00 | MSFT | Stock | 29.67 | 29.75 | 29.67 | 29.74 | 806637.0 |
| 2006-12-26 13:00:00 | MSFT | Stock | 29.75 | 29.84 | 29.74 | 29.79 | 2443662.0 |
| 2006-12-26 13:30:00 | MSFT | Stock | 29.79 | 29.89 | 29.79 | 29.88 | 2079523.0 |
| 2006-12-26 14:00:00 | MSFT | Stock | 29.88 | 29.92 | 29.82 | 29.85 | 1059005.0 |
| 2006-12-26 14:30:00 | MSFT | Stock | 29.86 | 29.95 | 29.735 | 29.9 | 2874990.0 |
| 2006-12-26 15:00:00 | MSFT | Stock | 29.9 | 29.92 | 29.89 | 29.89 | 2024030.0 |
| 2006-12-26 15:30:00 | MSFT | Stock | 29.89 | 30.0 | 29.89 | 29.99 | 8973067.0 |
| 2006-12-26 16:00:00 | MSFT | Stock | 30.0 | 30.06 | 29.95 | 29.97 | 92226.0 |
| 2006-12-26 16:30:00 | MSFT | Stock | 29.97 | 29.97 | 29.95 | 29.96 | 1479.0 |
| 2006-12-26 17:00:00 | MSFT | Stock | 29.96 | 29.96 | 29.96 | 29.96 | 1200.0 |
| 2006-12-26 17:30:00 | MSFT | Stock | 29.96 | 29.96 | 29.95 | 29.95 | 4200.0 |
| 2006-12-26 18:00:00 | MSFT | Stock | 29.94 | 29.94 | 29.94 | 29.94 | 100.0 |
| 2006-12-26 18:30:00 | MSFT | Stock | 29.95 | 29.95 | 29.95 | 29.95 | 200.0 |
| 2006-12-26 19:00:00 | MSFT | Stock | 29.94 | 29.96 | 29.94 | 29.96 | 871.0 |
| 2006-12-26 19:30:00 | MSFT | Stock | 29.94 | 29.94 | 29.94 | 29.94 | 2994.0 |
| 2006-12-26 08:00:00 | NVDA | Stock | 0.6172 | 0.6172 | 0.6172 | 0.6172 | 24000.0 |
| 2006-12-26 09:00:00 | NVDA | Stock | 0.6172 | 0.6207 | 0.6172 | 0.6207 | 152400.0 |
> showing 50 of 51,585 rows — these rows as CSV