PREVIEW / stock_30min / 2005-12-12
file: by_date/stock_30min/2005/2005-12-12.parquet size: 876 KB rows: 47,403 symbols: 2,142
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-12-12 05:30:00 | AAPL | Stock | 2.6679 | 2.67 | 2.6679 | 2.67 | 19600.0 |
| 2005-12-12 06:30:00 | AAPL | Stock | 2.6818 | 2.6818 | 2.6818 | 2.6818 | 2800.0 |
| 2005-12-12 07:00:00 | AAPL | Stock | 2.6829 | 2.6829 | 2.6768 | 2.6786 | 70000.0 |
| 2005-12-12 07:30:00 | AAPL | Stock | 2.6786 | 2.6818 | 2.6786 | 2.6786 | 196000.0 |
| 2005-12-12 08:00:00 | AAPL | Stock | 2.6786 | 2.6839 | 2.6696 | 2.675 | 1688176.0 |
| 2005-12-12 08:30:00 | AAPL | Stock | 2.675 | 2.6807 | 2.6718 | 2.6786 | 1809164.0 |
| 2005-12-12 09:00:00 | AAPL | Stock | 2.6786 | 2.68 | 2.6704 | 2.6711 | 1994664.0 |
| 2005-12-12 09:30:00 | AAPL | Stock | 2.6739 | 2.6875 | 2.6714 | 2.6779 | 120193164.0 |
| 2005-12-12 10:00:00 | AAPL | Stock | 2.6779 | 2.6843 | 2.6629 | 2.6807 | 58492308.0 |
| 2005-12-12 10:30:00 | AAPL | Stock | 2.6807 | 2.6857 | 2.6714 | 2.6829 | 45704960.0 |
| 2005-12-12 11:00:00 | AAPL | Stock | 2.6825 | 2.6907 | 2.68 | 2.6846 | 37821980.0 |
| 2005-12-12 11:30:00 | AAPL | Stock | 2.6846 | 2.6911 | 2.6836 | 2.6857 | 27602512.0 |
| 2005-12-12 12:00:00 | AAPL | Stock | 2.6868 | 2.6889 | 2.6761 | 2.6775 | 27186180.0 |
| 2005-12-12 12:30:00 | AAPL | Stock | 2.6775 | 2.6796 | 2.6679 | 2.6764 | 35284424.0 |
| 2005-12-12 13:00:00 | AAPL | Stock | 2.6764 | 2.6789 | 2.67 | 2.6779 | 17035928.0 |
| 2005-12-12 13:30:00 | AAPL | Stock | 2.6778 | 2.6796 | 2.6729 | 2.6754 | 19257140.0 |
| 2005-12-12 14:00:00 | AAPL | Stock | 2.6754 | 2.6839 | 2.6754 | 2.6807 | 24645684.0 |
| 2005-12-12 14:30:00 | AAPL | Stock | 2.6804 | 2.6821 | 2.6732 | 2.6736 | 23787400.0 |
| 2005-12-12 15:00:00 | AAPL | Stock | 2.6736 | 2.6786 | 2.6711 | 2.6768 | 33021352.0 |
| 2005-12-12 15:30:00 | AAPL | Stock | 2.6768 | 2.6786 | 2.6736 | 2.6754 | 32377492.0 |
| 2005-12-12 16:00:00 | AAPL | Stock | 2.6757 | 2.6804 | 2.675 | 2.6754 | 1929872.0 |
| 2005-12-12 16:30:00 | AAPL | Stock | 2.6746 | 2.6786 | 2.6746 | 2.6754 | 1883000.0 |
| 2005-12-12 17:00:00 | AAPL | Stock | 2.6775 | 2.6786 | 2.6757 | 2.6757 | 154980.0 |
| 2005-12-12 17:30:00 | AAPL | Stock | 2.6771 | 2.6771 | 2.6754 | 2.6757 | 58016.0 |
| 2005-12-12 18:00:00 | AAPL | Stock | 2.6757 | 2.6768 | 2.6754 | 2.6768 | 353612.0 |
| 2005-12-12 05:00:00 | MSFT | Stock | 27.71 | 27.75 | 27.71 | 27.75 | 2000.0 |
| 2005-12-12 06:30:00 | MSFT | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 100.0 |
| 2005-12-12 08:00:00 | MSFT | Stock | 27.75 | 27.78 | 27.75 | 27.78 | 2700.0 |
| 2005-12-12 08:30:00 | MSFT | Stock | 27.78 | 27.8 | 27.74 | 27.75 | 7150.0 |
| 2005-12-12 09:00:00 | MSFT | Stock | 27.77 | 27.77 | 27.67 | 27.7 | 95118.0 |
| 2005-12-12 09:30:00 | MSFT | Stock | 27.7 | 27.75 | 27.45 | 27.51 | 8997620.0 |
| 2005-12-12 10:00:00 | MSFT | Stock | 27.511 | 27.58 | 27.47 | 27.57 | 3647000.0 |
| 2005-12-12 10:30:00 | MSFT | Stock | 27.57 | 27.592 | 27.52 | 27.55 | 2998007.0 |
| 2005-12-12 11:00:00 | MSFT | Stock | 27.55 | 27.56 | 27.51 | 27.52 | 2516761.0 |
| 2005-12-12 11:30:00 | MSFT | Stock | 27.522 | 27.68 | 27.51 | 27.52 | 2171860.0 |
| 2005-12-12 12:00:00 | MSFT | Stock | 27.52 | 27.54 | 27.49 | 27.5 | 5306873.0 |
| 2005-12-12 12:30:00 | MSFT | Stock | 27.5 | 27.52 | 27.47 | 27.492 | 3623711.0 |
| 2005-12-12 13:00:00 | MSFT | Stock | 27.49 | 27.5 | 27.46 | 27.48 | 3415948.0 |
| 2005-12-12 13:30:00 | MSFT | Stock | 27.48 | 27.5 | 27.46 | 27.49 | 2422736.0 |
| 2005-12-12 14:00:00 | MSFT | Stock | 27.488 | 27.5 | 27.43 | 27.47 | 6239037.0 |
| 2005-12-12 14:30:00 | MSFT | Stock | 27.47 | 27.5 | 27.4 | 27.42 | 6486159.0 |
| 2005-12-12 15:00:00 | MSFT | Stock | 27.42 | 27.46 | 27.35 | 27.37 | 5615378.0 |
| 2005-12-12 15:30:00 | MSFT | Stock | 27.37 | 27.45 | 27.33 | 27.44 | 7967162.0 |
| 2005-12-12 16:00:00 | MSFT | Stock | 27.44 | 27.485 | 27.41 | 27.43 | 556386.0 |
| 2005-12-12 16:30:00 | MSFT | Stock | 27.41 | 27.45 | 27.41 | 27.41 | 42750.0 |
| 2005-12-12 17:00:00 | MSFT | Stock | 27.45 | 27.45 | 27.41 | 27.41 | 122500.0 |
| 2005-12-12 18:00:00 | MSFT | Stock | 27.41 | 27.44 | 27.41 | 27.44 | 350.0 |
| 2005-12-12 05:00:00 | NVDA | Stock | 0.307 | 0.3083 | 0.307 | 0.3083 | 108000.0 |
| 2005-12-12 05:30:00 | NVDA | Stock | 0.3062 | 0.3062 | 0.3062 | 0.3062 | 120000.0 |
| 2005-12-12 07:00:00 | NVDA | Stock | 0.3083 | 0.3083 | 0.3083 | 0.3083 | 108000.0 |
> showing 50 of 47,403 rows — these rows as CSV