PREVIEW / stock_30min / 2006-07-12
file: by_date/stock_30min/2006/2006-07-12.parquet size: 904 KB rows: 49,256 symbols: 2,314
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-07-12 07:00:00 | AAPL | Stock | 1.985 | 1.985 | 1.985 | 1.985 | 28000.0 |
| 2006-07-12 08:00:00 | AAPL | Stock | 1.9786 | 1.9786 | 1.9686 | 1.9686 | 668584.0 |
| 2006-07-12 08:30:00 | AAPL | Stock | 1.9729 | 1.9746 | 1.9661 | 1.9732 | 844620.0 |
| 2006-07-12 09:00:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9696 | 1.9704 | 846776.0 |
| 2006-07-12 09:30:00 | AAPL | Stock | 1.9704 | 1.9729 | 1.9543 | 1.9564 | 92857240.0 |
| 2006-07-12 10:00:00 | AAPL | Stock | 1.9564 | 1.96 | 1.9432 | 1.9489 | 82002312.0 |
| 2006-07-12 10:30:00 | AAPL | Stock | 1.9489 | 1.9525 | 1.9354 | 1.9414 | 84348656.0 |
| 2006-07-12 11:00:00 | AAPL | Stock | 1.9411 | 1.9432 | 1.9332 | 1.9425 | 52686088.0 |
| 2006-07-12 11:30:00 | AAPL | Stock | 1.9425 | 1.9493 | 1.9414 | 1.9439 | 46495428.0 |
| 2006-07-12 12:00:00 | AAPL | Stock | 1.9441 | 1.9446 | 1.9211 | 1.9218 | 74437888.0 |
| 2006-07-12 12:30:00 | AAPL | Stock | 1.9218 | 1.9296 | 1.92 | 1.9232 | 49781620.0 |
| 2006-07-12 13:00:00 | AAPL | Stock | 1.9232 | 1.9239 | 1.9057 | 1.9089 | 72864232.0 |
| 2006-07-12 13:30:00 | AAPL | Stock | 1.9089 | 1.9143 | 1.8993 | 1.9046 | 60559464.0 |
| 2006-07-12 14:00:00 | AAPL | Stock | 1.9046 | 1.9107 | 1.8971 | 1.9082 | 55114612.0 |
| 2006-07-12 14:30:00 | AAPL | Stock | 1.9086 | 1.9132 | 1.8918 | 1.8936 | 75891200.0 |
| 2006-07-12 15:00:00 | AAPL | Stock | 1.8936 | 1.9068 | 1.8932 | 1.9007 | 63121828.0 |
| 2006-07-12 15:30:00 | AAPL | Stock | 1.9007 | 1.9071 | 1.8911 | 1.8918 | 101477460.0 |
| 2006-07-12 16:00:00 | AAPL | Stock | 1.8925 | 1.9064 | 1.8911 | 1.8911 | 2818536.0 |
| 2006-07-12 16:30:00 | AAPL | Stock | 1.8911 | 1.8979 | 1.8911 | 1.8943 | 4013548.0 |
| 2006-07-12 17:00:00 | AAPL | Stock | 1.8929 | 1.8961 | 1.8911 | 1.8911 | 326676.0 |
| 2006-07-12 17:30:00 | AAPL | Stock | 1.8914 | 1.902 | 1.8893 | 1.902 | 454216.0 |
| 2006-07-12 18:00:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8839 | 1.8854 | 358232.0 |
| 2006-07-12 08:00:00 | MSFT | Stock | 23.0 | 23.0 | 22.83 | 22.9 | 46172.0 |
| 2006-07-12 08:30:00 | MSFT | Stock | 22.89 | 22.95 | 22.85 | 22.9 | 42895.0 |
| 2006-07-12 09:00:00 | MSFT | Stock | 22.94 | 23.0 | 22.79 | 22.79 | 503912.0 |
| 2006-07-12 09:30:00 | MSFT | Stock | 22.79 | 22.85 | 22.68 | 22.73 | 12873577.0 |
| 2006-07-12 10:00:00 | MSFT | Stock | 22.71 | 22.88 | 22.71 | 22.86 | 6704366.0 |
| 2006-07-12 10:30:00 | MSFT | Stock | 22.859 | 22.88 | 22.8 | 22.83 | 4118132.0 |
| 2006-07-12 11:00:00 | MSFT | Stock | 22.82 | 22.84 | 22.79 | 22.81 | 3045336.0 |
| 2006-07-12 11:30:00 | MSFT | Stock | 22.8 | 22.85 | 22.79 | 22.85 | 2473546.0 |
| 2006-07-12 12:00:00 | MSFT | Stock | 22.85 | 22.85 | 22.75 | 22.77 | 3315823.0 |
| 2006-07-12 12:30:00 | MSFT | Stock | 22.78 | 22.78 | 22.71 | 22.74 | 5736647.0 |
| 2006-07-12 13:00:00 | MSFT | Stock | 22.74 | 22.75 | 22.62 | 22.67 | 3924015.0 |
| 2006-07-12 13:30:00 | MSFT | Stock | 22.67 | 22.72 | 22.64 | 22.702 | 3060657.0 |
| 2006-07-12 14:00:00 | MSFT | Stock | 22.702 | 22.76 | 22.69 | 22.72 | 3068229.0 |
| 2006-07-12 14:30:00 | MSFT | Stock | 22.722 | 22.76 | 22.67 | 22.68 | 4294706.0 |
| 2006-07-12 15:00:00 | MSFT | Stock | 22.68 | 22.75 | 22.67 | 22.73 | 3934394.0 |
| 2006-07-12 15:30:00 | MSFT | Stock | 22.73 | 22.75 | 22.62 | 22.64 | 10358033.0 |
| 2006-07-12 16:00:00 | MSFT | Stock | 22.65 | 22.77 | 22.64 | 22.66 | 322869.0 |
| 2006-07-12 16:30:00 | MSFT | Stock | 22.67 | 22.7 | 22.64 | 22.64 | 50741.0 |
| 2006-07-12 17:00:00 | MSFT | Stock | 22.65 | 22.7 | 22.585 | 22.68 | 59284.0 |
| 2006-07-12 17:30:00 | MSFT | Stock | 22.68 | 22.68 | 22.64 | 22.65 | 1984.0 |
| 2006-07-12 18:00:00 | MSFT | Stock | 22.68 | 22.68 | 22.68 | 22.68 | 1100.0 |
| 2006-07-12 09:00:00 | NVDA | Stock | 0.32 | 0.3233 | 0.3173 | 0.3178 | 858180.0 |
| 2006-07-12 09:30:00 | NVDA | Stock | 0.318 | 0.3217 | 0.313 | 0.3148 | 55750620.0 |
| 2006-07-12 10:00:00 | NVDA | Stock | 0.3147 | 0.3158 | 0.3115 | 0.314 | 39323040.0 |
| 2006-07-12 10:30:00 | NVDA | Stock | 0.3138 | 0.3138 | 0.3095 | 0.3102 | 25009980.0 |
| 2006-07-12 11:00:00 | NVDA | Stock | 0.3102 | 0.3123 | 0.3095 | 0.311 | 29082840.0 |
| 2006-07-12 11:30:00 | NVDA | Stock | 0.3108 | 0.3143 | 0.3103 | 0.3137 | 20945220.0 |
| 2006-07-12 12:00:00 | NVDA | Stock | 0.3137 | 0.3145 | 0.3123 | 0.3137 | 28506840.0 |
> showing 50 of 49,256 rows — these rows as CSV