PREVIEW / stock_30min / 2006-12-12
file: by_date/stock_30min/2006/2006-12-12.parquet size: 963 KB rows: 52,072 symbols: 2,462
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-12 07:00:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1768 | 3.1768 | 11200.0 |
| 2006-12-12 07:30:00 | AAPL | Stock | 3.1764 | 3.1768 | 3.1764 | 3.1768 | 22400.0 |
| 2006-12-12 08:00:00 | AAPL | Stock | 3.175 | 3.1829 | 3.1686 | 3.1725 | 1151444.0 |
| 2006-12-12 08:30:00 | AAPL | Stock | 3.1736 | 3.175 | 3.1661 | 3.1679 | 333984.0 |
| 2006-12-12 09:00:00 | AAPL | Stock | 3.1671 | 3.17 | 3.1607 | 3.165 | 2027452.0 |
| 2006-12-12 09:30:00 | AAPL | Stock | 3.1646 | 3.1729 | 3.1518 | 3.16 | 56007644.0 |
| 2006-12-12 10:00:00 | AAPL | Stock | 3.16 | 3.1629 | 3.0825 | 3.1161 | 197831956.0 |
| 2006-12-12 10:30:00 | AAPL | Stock | 3.1157 | 3.1375 | 3.1154 | 3.1268 | 75115460.0 |
| 2006-12-12 11:00:00 | AAPL | Stock | 3.1271 | 3.1286 | 3.1107 | 3.1214 | 36216824.0 |
| 2006-12-12 11:30:00 | AAPL | Stock | 3.119 | 3.1204 | 3.1043 | 3.1061 | 40047616.0 |
| 2006-12-12 12:00:00 | AAPL | Stock | 3.1061 | 3.1104 | 3.0854 | 3.0918 | 76592992.0 |
| 2006-12-12 12:30:00 | AAPL | Stock | 3.0921 | 3.1011 | 3.09 | 3.0989 | 43146292.0 |
| 2006-12-12 13:00:00 | AAPL | Stock | 3.0989 | 3.1066 | 3.0936 | 3.0999 | 25379648.0 |
| 2006-12-12 13:30:00 | AAPL | Stock | 3.0996 | 3.1068 | 3.0946 | 3.0986 | 23325148.0 |
| 2006-12-12 14:00:00 | AAPL | Stock | 3.0982 | 3.1289 | 3.0832 | 3.0904 | 97525568.0 |
| 2006-12-12 14:30:00 | AAPL | Stock | 3.0896 | 3.0996 | 3.0593 | 3.075 | 125839644.0 |
| 2006-12-12 15:00:00 | AAPL | Stock | 3.0746 | 3.0804 | 3.0546 | 3.065 | 100167312.0 |
| 2006-12-12 15:30:00 | AAPL | Stock | 3.065 | 3.0875 | 3.0625 | 3.0768 | 107628808.0 |
| 2006-12-12 16:00:00 | AAPL | Stock | 3.075 | 3.0964 | 3.07 | 3.0761 | 1490076.0 |
| 2006-12-12 16:30:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0754 | 3.0761 | 328412.0 |
| 2006-12-12 17:00:00 | AAPL | Stock | 3.0761 | 3.0764 | 3.0757 | 3.0757 | 184800.0 |
| 2006-12-12 17:30:00 | AAPL | Stock | 3.0764 | 3.0764 | 3.0725 | 3.0725 | 114240.0 |
| 2006-12-12 18:00:00 | AAPL | Stock | 3.0732 | 3.075 | 3.0714 | 3.0739 | 203196.0 |
| 2006-12-12 18:30:00 | AAPL | Stock | 3.0739 | 3.075 | 3.0714 | 3.0725 | 436632.0 |
| 2006-12-12 19:00:00 | AAPL | Stock | 3.0725 | 3.0732 | 3.0714 | 3.0714 | 79800.0 |
| 2006-12-12 19:30:00 | AAPL | Stock | 3.0732 | 3.0761 | 3.0718 | 3.0761 | 142100.0 |
| 2006-12-12 07:30:00 | MSFT | Stock | 29.54 | 29.54 | 29.54 | 29.54 | 100.0 |
| 2006-12-12 08:00:00 | MSFT | Stock | 29.54 | 29.54 | 29.53 | 29.53 | 3576.0 |
| 2006-12-12 08:30:00 | MSFT | Stock | 29.53 | 29.57 | 29.5 | 29.5 | 4262.0 |
| 2006-12-12 09:00:00 | MSFT | Stock | 29.54 | 29.57 | 29.49 | 29.57 | 59655.0 |
| 2006-12-12 09:30:00 | MSFT | Stock | 29.51 | 29.63 | 29.41 | 29.44 | 5745171.0 |
| 2006-12-12 10:00:00 | MSFT | Stock | 29.44 | 29.45 | 29.37 | 29.45 | 5259279.0 |
| 2006-12-12 10:30:00 | MSFT | Stock | 29.45 | 29.55 | 29.44 | 29.5 | 3574044.0 |
| 2006-12-12 11:00:00 | MSFT | Stock | 29.5 | 29.51 | 29.45 | 29.46 | 2973525.0 |
| 2006-12-12 11:30:00 | MSFT | Stock | 29.46 | 29.49 | 29.43 | 29.44 | 4010333.0 |
| 2006-12-12 12:00:00 | MSFT | Stock | 29.44 | 29.45 | 29.22 | 29.27 | 7662949.0 |
| 2006-12-12 12:30:00 | MSFT | Stock | 29.27 | 29.4 | 29.26 | 29.32 | 4046083.0 |
| 2006-12-12 13:00:00 | MSFT | Stock | 29.32 | 29.39 | 29.31 | 29.36 | 2837287.0 |
| 2006-12-12 13:30:00 | MSFT | Stock | 29.36 | 29.41 | 29.35 | 29.36 | 1783436.0 |
| 2006-12-12 14:00:00 | MSFT | Stock | 29.37 | 29.5 | 29.34 | 29.47 | 3918194.0 |
| 2006-12-12 14:30:00 | MSFT | Stock | 29.47 | 29.5 | 29.35 | 29.4 | 4300159.0 |
| 2006-12-12 15:00:00 | MSFT | Stock | 29.4 | 29.46 | 29.34 | 29.35 | 5537143.0 |
| 2006-12-12 15:30:00 | MSFT | Stock | 29.35 | 29.43 | 29.24 | 29.43 | 12780561.0 |
| 2006-12-12 16:00:00 | MSFT | Stock | 29.43 | 29.45 | 29.42 | 29.43 | 600155.0 |
| 2006-12-12 16:30:00 | MSFT | Stock | 29.45 | 29.45 | 29.42 | 29.42 | 1336.0 |
| 2006-12-12 17:00:00 | MSFT | Stock | 29.43 | 29.43 | 29.43 | 29.43 | 500.0 |
| 2006-12-12 17:30:00 | MSFT | Stock | 29.42 | 29.45 | 29.42 | 29.45 | 52704.0 |
| 2006-12-12 18:30:00 | MSFT | Stock | 29.43 | 29.43 | 29.43 | 29.43 | 500.0 |
| 2006-12-12 19:30:00 | MSFT | Stock | 29.45 | 29.45 | 29.43 | 29.43 | 2820.0 |
| 2006-12-12 08:00:00 | NVDA | Stock | 0.6025 | 0.6025 | 0.6025 | 0.6025 | 14760.0 |
> showing 50 of 52,072 rows — these rows as CSV