PREVIEW / stock_30min / 2006-12-22
file: by_date/stock_30min/2006/2006-12-22.parquet size: 931 KB rows: 51,139 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-22 04:00:00 | AAPL | Stock | 2.9675 | 2.9675 | 2.9643 | 2.9643 | 19600.0 |
| 2006-12-22 07:00:00 | AAPL | Stock | 2.9614 | 2.9693 | 2.9614 | 2.9693 | 75600.0 |
| 2006-12-22 07:30:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9707 | 2.9711 | 82600.0 |
| 2006-12-22 08:00:00 | AAPL | Stock | 2.9711 | 2.9786 | 2.9643 | 2.9732 | 1017380.0 |
| 2006-12-22 08:30:00 | AAPL | Stock | 2.9732 | 2.9889 | 2.9714 | 2.9839 | 1722644.0 |
| 2006-12-22 09:00:00 | AAPL | Stock | 2.9839 | 2.9839 | 2.975 | 2.98 | 555268.0 |
| 2006-12-22 09:30:00 | AAPL | Stock | 2.9807 | 2.9864 | 2.9143 | 2.9636 | 108270176.0 |
| 2006-12-22 10:00:00 | AAPL | Stock | 2.9639 | 3.0014 | 2.9579 | 3.0 | 100282616.0 |
| 2006-12-22 10:30:00 | AAPL | Stock | 2.9996 | 3.0004 | 2.9732 | 2.9771 | 62262704.0 |
| 2006-12-22 11:00:00 | AAPL | Stock | 2.9774 | 2.9839 | 2.9518 | 2.9704 | 35259224.0 |
| 2006-12-22 11:30:00 | AAPL | Stock | 2.97 | 2.9857 | 2.9668 | 2.9682 | 35713552.0 |
| 2006-12-22 12:00:00 | AAPL | Stock | 2.9679 | 2.9732 | 2.9479 | 2.9514 | 56159992.0 |
| 2006-12-22 12:30:00 | AAPL | Stock | 2.9507 | 2.9604 | 2.9446 | 2.9521 | 31487988.0 |
| 2006-12-22 13:00:00 | AAPL | Stock | 2.9521 | 2.9525 | 2.9432 | 2.9457 | 20444900.0 |
| 2006-12-22 13:30:00 | AAPL | Stock | 2.9454 | 2.9529 | 2.9429 | 2.9464 | 22726032.0 |
| 2006-12-22 14:00:00 | AAPL | Stock | 2.9461 | 2.95 | 2.9375 | 2.946 | 24539284.0 |
| 2006-12-22 14:30:00 | AAPL | Stock | 2.9457 | 2.9514 | 2.9429 | 2.9493 | 17817520.0 |
| 2006-12-22 15:00:00 | AAPL | Stock | 2.9493 | 2.9554 | 2.9396 | 2.94 | 34952624.0 |
| 2006-12-22 15:30:00 | AAPL | Stock | 2.94 | 2.9479 | 2.9339 | 2.9357 | 49049112.0 |
| 2006-12-22 16:00:00 | AAPL | Stock | 2.9357 | 2.9364 | 2.9268 | 2.9354 | 1764476.0 |
| 2006-12-22 16:30:00 | AAPL | Stock | 2.9354 | 2.9354 | 2.9339 | 2.9343 | 81676.0 |
| 2006-12-22 17:00:00 | AAPL | Stock | 2.9343 | 2.9354 | 2.9321 | 2.9343 | 149436.0 |
| 2006-12-22 17:30:00 | AAPL | Stock | 2.9343 | 2.9375 | 2.9343 | 2.9375 | 148792.0 |
| 2006-12-22 18:00:00 | AAPL | Stock | 2.9354 | 2.9354 | 2.9354 | 2.9354 | 63000.0 |
| 2006-12-22 18:30:00 | AAPL | Stock | 2.9354 | 2.9354 | 2.9296 | 2.9296 | 150500.0 |
| 2006-12-22 19:00:00 | AAPL | Stock | 2.9296 | 2.9354 | 2.9286 | 2.9321 | 188300.0 |
| 2006-12-22 19:30:00 | AAPL | Stock | 2.9286 | 2.9339 | 2.9286 | 2.9304 | 66612.0 |
| 2006-12-22 05:00:00 | MSFT | Stock | 29.86 | 29.86 | 29.86 | 29.86 | 300.0 |
| 2006-12-22 08:00:00 | MSFT | Stock | 29.92 | 29.92 | 29.92 | 29.92 | 1400.0 |
| 2006-12-22 08:30:00 | MSFT | Stock | 29.92 | 29.98 | 29.91 | 29.95 | 4137.0 |
| 2006-12-22 09:00:00 | MSFT | Stock | 29.95 | 29.98 | 29.82 | 29.82 | 181120.0 |
| 2006-12-22 09:30:00 | MSFT | Stock | 29.825 | 29.86 | 29.63 | 29.69 | 7021133.0 |
| 2006-12-22 10:00:00 | MSFT | Stock | 29.69 | 29.81 | 29.68 | 29.81 | 3731328.0 |
| 2006-12-22 10:30:00 | MSFT | Stock | 29.81 | 29.82 | 29.72 | 29.73 | 2547609.0 |
| 2006-12-22 11:00:00 | MSFT | Stock | 29.738 | 29.75 | 29.68 | 29.72 | 2224873.0 |
| 2006-12-22 11:30:00 | MSFT | Stock | 29.72 | 29.77 | 29.69 | 29.71 | 1476698.0 |
| 2006-12-22 12:00:00 | MSFT | Stock | 29.7 | 29.75 | 29.69 | 29.738 | 2523907.0 |
| 2006-12-22 12:30:00 | MSFT | Stock | 29.73 | 29.825 | 29.73 | 29.81 | 1295363.0 |
| 2006-12-22 13:00:00 | MSFT | Stock | 29.81 | 29.81 | 29.73 | 29.73 | 1102976.0 |
| 2006-12-22 13:30:00 | MSFT | Stock | 29.74 | 29.76 | 29.71 | 29.73 | 1101185.0 |
| 2006-12-22 14:00:00 | MSFT | Stock | 29.733 | 29.74 | 29.71 | 29.73 | 751502.0 |
| 2006-12-22 14:30:00 | MSFT | Stock | 29.73 | 29.75 | 29.72 | 29.75 | 1145745.0 |
| 2006-12-22 15:00:00 | MSFT | Stock | 29.75 | 29.76 | 29.71 | 29.75 | 2335028.0 |
| 2006-12-22 15:30:00 | MSFT | Stock | 29.75 | 29.75 | 29.62 | 29.65 | 9002234.0 |
| 2006-12-22 16:00:00 | MSFT | Stock | 29.64 | 29.65 | 29.61 | 29.63 | 475299.0 |
| 2006-12-22 16:30:00 | MSFT | Stock | 29.64 | 29.64 | 29.64 | 29.64 | 3000.0 |
| 2006-12-22 17:00:00 | MSFT | Stock | 29.64 | 29.64 | 29.64 | 29.64 | 500.0 |
| 2006-12-22 18:30:00 | MSFT | Stock | 29.63 | 29.63 | 29.63 | 29.63 | 700.0 |
| 2006-12-22 19:30:00 | MSFT | Stock | 29.63 | 29.65 | 29.63 | 29.65 | 2000.0 |
| 2006-12-22 09:00:00 | NVDA | Stock | 0.6317 | 0.6332 | 0.6317 | 0.6332 | 60000.0 |
> showing 50 of 51,139 rows — these rows as CSV