PREVIEW / stock_30min / 2006-06-28
file: by_date/stock_30min/2006/2006-06-28.parquet size: 887 KB rows: 48,667 symbols: 2,286
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-06-28 07:30:00 | AAPL | Stock | 2.0482 | 2.0571 | 2.0464 | 2.0464 | 96600.0 |
| 2006-06-28 08:00:00 | AAPL | Stock | 2.0589 | 2.0589 | 2.0446 | 2.0464 | 1409044.0 |
| 2006-06-28 08:30:00 | AAPL | Stock | 2.0482 | 2.0514 | 2.04 | 2.0464 | 2266572.0 |
| 2006-06-28 09:00:00 | AAPL | Stock | 2.0454 | 2.0468 | 2.0393 | 2.0461 | 2783060.0 |
| 2006-06-28 09:30:00 | AAPL | Stock | 2.0461 | 2.0464 | 1.9957 | 2.0011 | 172617368.0 |
| 2006-06-28 10:00:00 | AAPL | Stock | 2.0011 | 2.0161 | 1.9971 | 2.0 | 93528428.0 |
| 2006-06-28 10:30:00 | AAPL | Stock | 2.0004 | 2.0089 | 1.9943 | 2.0044 | 71356236.0 |
| 2006-06-28 11:00:00 | AAPL | Stock | 2.0046 | 2.0064 | 1.9961 | 1.9971 | 53050032.0 |
| 2006-06-28 11:30:00 | AAPL | Stock | 1.9975 | 1.9979 | 1.9789 | 1.9882 | 86666636.0 |
| 2006-06-28 12:00:00 | AAPL | Stock | 1.9882 | 1.9964 | 1.9854 | 1.9943 | 39804016.0 |
| 2006-06-28 12:30:00 | AAPL | Stock | 1.9938 | 1.9939 | 1.9871 | 1.9889 | 27062868.0 |
| 2006-06-28 13:00:00 | AAPL | Stock | 1.9893 | 1.99 | 1.9825 | 1.9836 | 32531604.0 |
| 2006-06-28 13:30:00 | AAPL | Stock | 1.9832 | 1.9907 | 1.9804 | 1.9904 | 36198820.0 |
| 2006-06-28 14:00:00 | AAPL | Stock | 1.9904 | 1.9989 | 1.9879 | 1.9982 | 45301312.0 |
| 2006-06-28 14:30:00 | AAPL | Stock | 1.9986 | 2.005 | 1.9914 | 1.9932 | 61497436.0 |
| 2006-06-28 15:00:00 | AAPL | Stock | 1.9932 | 1.9993 | 1.9904 | 1.9961 | 44222668.0 |
| 2006-06-28 15:30:00 | AAPL | Stock | 1.9961 | 2.0018 | 1.9939 | 2.0014 | 67365620.0 |
| 2006-06-28 16:00:00 | AAPL | Stock | 2.0014 | 2.0018 | 1.9971 | 1.9971 | 1191148.0 |
| 2006-06-28 16:30:00 | AAPL | Stock | 1.9968 | 1.9982 | 1.9929 | 1.9936 | 768600.0 |
| 2006-06-28 17:00:00 | AAPL | Stock | 1.9946 | 1.9982 | 1.9932 | 1.9954 | 219520.0 |
| 2006-06-28 17:30:00 | AAPL | Stock | 1.9954 | 1.9993 | 1.995 | 1.9993 | 225680.0 |
| 2006-06-28 18:00:00 | AAPL | Stock | 1.9993 | 2.0014 | 1.9993 | 2.0014 | 367080.0 |
| 2006-06-28 08:00:00 | MSFT | Stock | 22.99 | 23.06 | 22.95 | 23.05 | 44942.0 |
| 2006-06-28 08:30:00 | MSFT | Stock | 23.05 | 23.05 | 23.0 | 23.0 | 3485.0 |
| 2006-06-28 09:00:00 | MSFT | Stock | 23.0 | 23.03 | 22.92 | 22.96 | 161054.0 |
| 2006-06-28 09:30:00 | MSFT | Stock | 22.96 | 23.2 | 22.91 | 23.12 | 8957854.0 |
| 2006-06-28 10:00:00 | MSFT | Stock | 23.12 | 23.14 | 23.03 | 23.09 | 6174104.0 |
| 2006-06-28 10:30:00 | MSFT | Stock | 23.1 | 23.1 | 23.02 | 23.07 | 4310590.0 |
| 2006-06-28 11:00:00 | MSFT | Stock | 23.07 | 23.08 | 23.02 | 23.05 | 2384002.0 |
| 2006-06-28 11:30:00 | MSFT | Stock | 23.05 | 23.08 | 23.02 | 23.072 | 3201473.0 |
| 2006-06-28 12:00:00 | MSFT | Stock | 23.08 | 23.09 | 23.03 | 23.07 | 3784050.0 |
| 2006-06-28 12:30:00 | MSFT | Stock | 23.08 | 23.09 | 23.05 | 23.07 | 2624818.0 |
| 2006-06-28 13:00:00 | MSFT | Stock | 23.06 | 23.08 | 23.06 | 23.07 | 1733708.0 |
| 2006-06-28 13:30:00 | MSFT | Stock | 23.07 | 23.08 | 23.06 | 23.07 | 1932584.0 |
| 2006-06-28 14:00:00 | MSFT | Stock | 23.07 | 23.13 | 23.06 | 23.12 | 5311123.0 |
| 2006-06-28 14:30:00 | MSFT | Stock | 23.12 | 23.2 | 23.1 | 23.16 | 6284189.0 |
| 2006-06-28 15:00:00 | MSFT | Stock | 23.16 | 23.25 | 23.12 | 23.21 | 6840059.0 |
| 2006-06-28 15:30:00 | MSFT | Stock | 23.21 | 23.22 | 23.1 | 23.19 | 7636320.0 |
| 2006-06-28 16:00:00 | MSFT | Stock | 23.2 | 23.21 | 23.14 | 23.18 | 567231.0 |
| 2006-06-28 16:30:00 | MSFT | Stock | 23.16 | 23.19 | 23.15 | 23.19 | 1791.0 |
| 2006-06-28 17:00:00 | MSFT | Stock | 23.15 | 23.19 | 23.15 | 23.16 | 2200.0 |
| 2006-06-28 18:00:00 | MSFT | Stock | 23.16 | 23.16 | 23.16 | 23.16 | 19339.0 |
| 2006-06-28 08:00:00 | NVDA | Stock | 0.3248 | 0.3248 | 0.3243 | 0.3243 | 90000.0 |
| 2006-06-28 08:30:00 | NVDA | Stock | 0.3228 | 0.3228 | 0.3228 | 0.3228 | 60000.0 |
| 2006-06-28 09:00:00 | NVDA | Stock | 0.3238 | 0.3272 | 0.3238 | 0.3268 | 354000.0 |
| 2006-06-28 09:30:00 | NVDA | Stock | 0.3272 | 0.3273 | 0.3187 | 0.3222 | 42351360.0 |
| 2006-06-28 10:00:00 | NVDA | Stock | 0.3223 | 0.3278 | 0.3223 | 0.3248 | 36010620.0 |
| 2006-06-28 10:30:00 | NVDA | Stock | 0.325 | 0.328 | 0.3233 | 0.3277 | 36184980.0 |
| 2006-06-28 11:00:00 | NVDA | Stock | 0.3277 | 0.33 | 0.3262 | 0.3282 | 56008980.0 |
| 2006-06-28 11:30:00 | NVDA | Stock | 0.3282 | 0.3312 | 0.3273 | 0.3312 | 141434580.0 |
> showing 50 of 48,667 rows — these rows as CSV