PREVIEW / stock_30min / 2006-12-29
file: by_date/stock_30min/2006/2006-12-29.parquet size: 978 KB rows: 52,921 symbols: 2,504
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-29 06:00:00 | AAPL | Stock | 2.8925 | 2.9307 | 2.8925 | 2.9307 | 170800.0 |
| 2006-12-29 06:30:00 | AAPL | Stock | 2.9425 | 2.9714 | 2.9114 | 2.9714 | 92008.0 |
| 2006-12-29 07:00:00 | AAPL | Stock | 2.9714 | 2.9936 | 2.9661 | 2.9857 | 1674316.0 |
| 2006-12-29 07:30:00 | AAPL | Stock | 2.9875 | 3.0321 | 2.9875 | 3.0046 | 6089440.0 |
| 2006-12-29 08:00:00 | AAPL | Stock | 3.0061 | 3.0282 | 3.0 | 3.0121 | 22220996.0 |
| 2006-12-29 08:30:00 | AAPL | Stock | 3.0118 | 3.015 | 2.9968 | 3.0004 | 17981292.0 |
| 2006-12-29 09:00:00 | AAPL | Stock | 3.0014 | 3.0096 | 2.9911 | 2.9989 | 14669620.0 |
| 2006-12-29 09:30:00 | AAPL | Stock | 2.9982 | 3.0293 | 2.9771 | 3.0186 | 224327516.0 |
| 2006-12-29 10:00:00 | AAPL | Stock | 3.0189 | 3.0411 | 3.0182 | 3.0325 | 150802596.0 |
| 2006-12-29 10:30:00 | AAPL | Stock | 3.0325 | 3.05 | 3.0321 | 3.0432 | 104717844.0 |
| 2006-12-29 11:00:00 | AAPL | Stock | 3.0432 | 3.0432 | 3.0189 | 3.028 | 92456756.0 |
| 2006-12-29 11:30:00 | AAPL | Stock | 3.0279 | 3.043 | 3.025 | 3.0339 | 60561732.0 |
| 2006-12-29 12:00:00 | AAPL | Stock | 3.0339 | 3.0411 | 3.0321 | 3.0375 | 34393156.0 |
| 2006-12-29 12:30:00 | AAPL | Stock | 3.0379 | 3.0407 | 3.0286 | 3.0393 | 37502276.0 |
| 2006-12-29 13:00:00 | AAPL | Stock | 3.0393 | 3.0404 | 3.0325 | 3.0354 | 27988100.0 |
| 2006-12-29 13:30:00 | AAPL | Stock | 3.0379 | 3.0382 | 3.0304 | 3.0339 | 24193456.0 |
| 2006-12-29 14:00:00 | AAPL | Stock | 3.0339 | 3.0393 | 3.0271 | 3.0275 | 32534124.0 |
| 2006-12-29 14:30:00 | AAPL | Stock | 3.0279 | 3.0318 | 3.0218 | 3.0311 | 38133480.0 |
| 2006-12-29 15:00:00 | AAPL | Stock | 3.0311 | 3.04 | 3.0229 | 3.0239 | 65735600.0 |
| 2006-12-29 15:30:00 | AAPL | Stock | 3.0271 | 3.0339 | 3.0232 | 3.0279 | 94296048.0 |
| 2006-12-29 16:00:00 | AAPL | Stock | 3.0286 | 3.0329 | 3.0271 | 3.0296 | 3517388.0 |
| 2006-12-29 16:30:00 | AAPL | Stock | 3.03 | 3.0307 | 3.0286 | 3.0286 | 1639428.0 |
| 2006-12-29 17:00:00 | AAPL | Stock | 3.0286 | 3.0304 | 3.0279 | 3.0304 | 395304.0 |
| 2006-12-29 17:30:00 | AAPL | Stock | 3.03 | 3.0307 | 3.0257 | 3.0275 | 249676.0 |
| 2006-12-29 18:00:00 | AAPL | Stock | 3.0275 | 3.03 | 3.0268 | 3.0279 | 287840.0 |
| 2006-12-29 18:30:00 | AAPL | Stock | 3.0279 | 3.0286 | 3.0268 | 3.0268 | 59276.0 |
| 2006-12-29 19:00:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.025 | 3.0254 | 181580.0 |
| 2006-12-29 19:30:00 | AAPL | Stock | 3.0254 | 3.0286 | 3.0214 | 3.025 | 313180.0 |
| 2006-12-29 07:00:00 | MSFT | Stock | 29.78 | 29.78 | 29.77 | 29.77 | 3700.0 |
| 2006-12-29 07:30:00 | MSFT | Stock | 29.77 | 29.78 | 29.73 | 29.75 | 10900.0 |
| 2006-12-29 08:00:00 | MSFT | Stock | 29.75 | 29.91 | 29.75 | 29.9 | 22940.0 |
| 2006-12-29 08:30:00 | MSFT | Stock | 29.9 | 29.95 | 29.9 | 29.95 | 4500.0 |
| 2006-12-29 09:00:00 | MSFT | Stock | 29.95 | 29.95 | 29.84 | 29.85 | 69979.0 |
| 2006-12-29 09:30:00 | MSFT | Stock | 29.86 | 30.1 | 29.84 | 30.08 | 3131175.0 |
| 2006-12-29 10:00:00 | MSFT | Stock | 30.08 | 30.15 | 30.01 | 30.01 | 2075511.0 |
| 2006-12-29 10:30:00 | MSFT | Stock | 30.01 | 30.06 | 29.99 | 30.04 | 1671889.0 |
| 2006-12-29 11:00:00 | MSFT | Stock | 30.04 | 30.04 | 29.98 | 30.01 | 1624145.0 |
| 2006-12-29 11:30:00 | MSFT | Stock | 30.01 | 30.02 | 29.99 | 30.0 | 922366.0 |
| 2006-12-29 12:00:00 | MSFT | Stock | 30.002 | 30.01 | 30.0 | 30.0 | 525595.0 |
| 2006-12-29 12:30:00 | MSFT | Stock | 30.01 | 30.01 | 29.9 | 29.92 | 3163581.0 |
| 2006-12-29 13:00:00 | MSFT | Stock | 29.92 | 29.96 | 29.9 | 29.951 | 1383034.0 |
| 2006-12-29 13:30:00 | MSFT | Stock | 29.95 | 29.99 | 29.93 | 29.95 | 1391136.0 |
| 2006-12-29 14:00:00 | MSFT | Stock | 29.95 | 29.97 | 29.89 | 29.9 | 1467044.0 |
| 2006-12-29 14:30:00 | MSFT | Stock | 29.9 | 29.93 | 29.89 | 29.9 | 1422270.0 |
| 2006-12-29 15:00:00 | MSFT | Stock | 29.9 | 29.95 | 29.87 | 29.91 | 3399005.0 |
| 2006-12-29 15:30:00 | MSFT | Stock | 29.91 | 29.97 | 29.83 | 29.85 | 14522440.0 |
| 2006-12-29 16:00:00 | MSFT | Stock | 29.86 | 29.89 | 29.8 | 29.86 | 410415.0 |
| 2006-12-29 16:30:00 | MSFT | Stock | 29.84 | 29.84 | 29.81 | 29.81 | 1300.0 |
| 2006-12-29 17:00:00 | MSFT | Stock | 29.82 | 29.86 | 29.82 | 29.83 | 1513.0 |
| 2006-12-29 17:30:00 | MSFT | Stock | 29.86 | 29.88 | 29.86 | 29.88 | 2362.0 |
> showing 50 of 52,921 rows — these rows as CSV