PREVIEW / stock_30min / 2005-09-27
file: by_date/stock_30min/2005/2005-09-27.parquet size: 844 KB rows: 45,866 symbols: 2,084
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-27 08:00:00 | AAPL | Stock | 1.9257 | 1.9339 | 1.9254 | 1.9339 | 467908.0 |
| 2005-09-27 08:30:00 | AAPL | Stock | 1.9296 | 1.9304 | 1.9268 | 1.9289 | 228200.0 |
| 2005-09-27 09:00:00 | AAPL | Stock | 1.9289 | 1.9304 | 1.9257 | 1.9257 | 1112104.0 |
| 2005-09-27 09:30:00 | AAPL | Stock | 1.9257 | 1.9371 | 1.9193 | 1.9293 | 60394936.0 |
| 2005-09-27 10:00:00 | AAPL | Stock | 1.9282 | 1.9304 | 1.9179 | 1.9232 | 37959376.0 |
| 2005-09-27 10:30:00 | AAPL | Stock | 1.9229 | 1.9268 | 1.9154 | 1.9204 | 23790340.0 |
| 2005-09-27 11:00:00 | AAPL | Stock | 1.9207 | 1.9264 | 1.9179 | 1.9235 | 17662204.0 |
| 2005-09-27 11:30:00 | AAPL | Stock | 1.9232 | 1.9275 | 1.9189 | 1.9246 | 14301560.0 |
| 2005-09-27 12:00:00 | AAPL | Stock | 1.9246 | 1.9286 | 1.9214 | 1.9257 | 11514692.0 |
| 2005-09-27 12:30:00 | AAPL | Stock | 1.9257 | 1.9275 | 1.9229 | 1.9239 | 10434760.0 |
| 2005-09-27 13:00:00 | AAPL | Stock | 1.9246 | 1.9246 | 1.9146 | 1.9171 | 19768896.0 |
| 2005-09-27 13:30:00 | AAPL | Stock | 1.9171 | 1.9229 | 1.9161 | 1.9204 | 16835924.0 |
| 2005-09-27 14:00:00 | AAPL | Stock | 1.9211 | 1.925 | 1.9171 | 1.9196 | 22300292.0 |
| 2005-09-27 14:30:00 | AAPL | Stock | 1.9196 | 1.9254 | 1.9146 | 1.9232 | 23419536.0 |
| 2005-09-27 15:00:00 | AAPL | Stock | 1.9232 | 1.9275 | 1.9186 | 1.92 | 27157032.0 |
| 2005-09-27 15:30:00 | AAPL | Stock | 1.92 | 1.9214 | 1.9082 | 1.9082 | 46138064.0 |
| 2005-09-27 16:00:00 | AAPL | Stock | 1.9082 | 1.9132 | 1.9071 | 1.9107 | 2835084.0 |
| 2005-09-27 16:30:00 | AAPL | Stock | 1.9096 | 1.9096 | 1.9068 | 1.9071 | 285012.0 |
| 2005-09-27 17:00:00 | AAPL | Stock | 1.9079 | 1.9079 | 1.9064 | 1.9075 | 103460.0 |
| 2005-09-27 17:30:00 | AAPL | Stock | 1.9075 | 1.9093 | 1.9068 | 1.9068 | 52528.0 |
| 2005-09-27 18:00:00 | AAPL | Stock | 1.9054 | 1.9075 | 1.9054 | 1.9071 | 97412.0 |
| 2005-09-27 06:30:00 | MSFT | Stock | 25.27 | 25.27 | 25.27 | 25.27 | 1000.0 |
| 2005-09-27 08:00:00 | MSFT | Stock | 25.32 | 25.34 | 25.27 | 25.34 | 19686.0 |
| 2005-09-27 08:30:00 | MSFT | Stock | 25.34 | 25.35 | 25.33 | 25.33 | 21504.0 |
| 2005-09-27 09:00:00 | MSFT | Stock | 25.33 | 25.37 | 25.33 | 25.37 | 40274.0 |
| 2005-09-27 09:30:00 | MSFT | Stock | 25.37 | 25.4 | 25.31 | 25.351 | 5120881.0 |
| 2005-09-27 10:00:00 | MSFT | Stock | 25.35 | 25.45 | 25.3 | 25.43 | 6363279.0 |
| 2005-09-27 10:30:00 | MSFT | Stock | 25.43 | 25.44 | 25.3 | 25.35 | 3116606.0 |
| 2005-09-27 11:00:00 | MSFT | Stock | 25.34 | 25.37 | 25.32 | 25.34 | 1678878.0 |
| 2005-09-27 11:30:00 | MSFT | Stock | 25.34 | 25.39 | 25.32 | 25.37 | 2463996.0 |
| 2005-09-27 12:00:00 | MSFT | Stock | 25.38 | 25.41 | 25.35 | 25.38 | 1479573.0 |
| 2005-09-27 12:30:00 | MSFT | Stock | 25.371 | 25.42 | 25.35 | 25.39 | 2141350.0 |
| 2005-09-27 13:00:00 | MSFT | Stock | 25.39 | 25.41 | 25.34 | 25.39 | 2746443.0 |
| 2005-09-27 13:30:00 | MSFT | Stock | 25.39 | 25.43 | 25.37 | 25.41 | 3144950.0 |
| 2005-09-27 14:00:00 | MSFT | Stock | 25.408 | 25.42 | 25.33 | 25.331 | 4962764.0 |
| 2005-09-27 14:30:00 | MSFT | Stock | 25.33 | 25.41 | 25.33 | 25.39 | 4269455.0 |
| 2005-09-27 15:00:00 | MSFT | Stock | 25.39 | 25.43 | 25.37 | 25.39 | 3534748.0 |
| 2005-09-27 15:30:00 | MSFT | Stock | 25.4 | 25.4 | 25.32 | 25.34 | 5606242.0 |
| 2005-09-27 16:00:00 | MSFT | Stock | 25.35 | 25.39 | 25.34 | 25.34 | 626630.0 |
| 2005-09-27 16:30:00 | MSFT | Stock | 25.36 | 25.36 | 25.3 | 25.34 | 3850.0 |
| 2005-09-27 17:00:00 | MSFT | Stock | 25.33 | 25.36 | 25.33 | 25.33 | 2700.0 |
| 2005-09-27 17:30:00 | MSFT | Stock | 25.37 | 25.37 | 25.34 | 25.344 | 5480.0 |
| 2005-09-27 18:00:00 | MSFT | Stock | 25.369 | 25.37 | 25.36 | 25.36 | 17585.0 |
| 2005-09-27 09:00:00 | NVDA | Stock | 0.2752 | 0.276 | 0.2752 | 0.276 | 96000.0 |
| 2005-09-27 09:30:00 | NVDA | Stock | 0.276 | 0.2771 | 0.2752 | 0.2766 | 40859640.0 |
| 2005-09-27 10:00:00 | NVDA | Stock | 0.2765 | 0.2766 | 0.2742 | 0.2748 | 27273480.0 |
| 2005-09-27 10:30:00 | NVDA | Stock | 0.2749 | 0.2762 | 0.2747 | 0.2755 | 28978440.0 |
| 2005-09-27 11:00:00 | NVDA | Stock | 0.2755 | 0.2757 | 0.2748 | 0.2749 | 43062360.0 |
| 2005-09-27 11:30:00 | NVDA | Stock | 0.2748 | 0.2752 | 0.2737 | 0.2751 | 23308680.0 |
| 2005-09-27 12:00:00 | NVDA | Stock | 0.2751 | 0.2757 | 0.2746 | 0.2748 | 14765520.0 |
> showing 50 of 45,866 rows — these rows as CSV