PREVIEW / stock_30min / 2005-05-23
file: by_date/stock_30min/2005/2005-05-23.parquet size: 801 KB rows: 43,577 symbols: 1,981
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-05-23 07:30:00 | AAPL | Stock | 1.3464 | 1.3486 | 1.3464 | 1.3486 | 78652.0 |
| 2005-05-23 08:00:00 | AAPL | Stock | 1.3561 | 1.375 | 1.3529 | 1.3661 | 2908360.0 |
| 2005-05-23 08:30:00 | AAPL | Stock | 1.3657 | 1.3682 | 1.3575 | 1.3668 | 1360744.0 |
| 2005-05-23 09:00:00 | AAPL | Stock | 1.3668 | 1.3693 | 1.3489 | 1.3518 | 3949148.0 |
| 2005-05-23 09:30:00 | AAPL | Stock | 1.3518 | 1.3811 | 1.3518 | 1.3803 | 155178884.0 |
| 2005-05-23 10:00:00 | AAPL | Stock | 1.3804 | 1.3921 | 1.3768 | 1.3879 | 137669616.0 |
| 2005-05-23 10:30:00 | AAPL | Stock | 1.3879 | 1.3932 | 1.3843 | 1.3864 | 94576636.0 |
| 2005-05-23 11:00:00 | AAPL | Stock | 1.3861 | 1.3982 | 1.3814 | 1.3954 | 84599844.0 |
| 2005-05-23 11:30:00 | AAPL | Stock | 1.3954 | 1.4057 | 1.3882 | 1.4046 | 56406840.0 |
| 2005-05-23 12:00:00 | AAPL | Stock | 1.405 | 1.4107 | 1.4018 | 1.4089 | 51139536.0 |
| 2005-05-23 12:30:00 | AAPL | Stock | 1.4089 | 1.4182 | 1.405 | 1.4121 | 102721724.0 |
| 2005-05-23 13:00:00 | AAPL | Stock | 1.4118 | 1.4196 | 1.4086 | 1.4146 | 62697068.0 |
| 2005-05-23 13:30:00 | AAPL | Stock | 1.4146 | 1.4182 | 1.4104 | 1.4157 | 34240304.0 |
| 2005-05-23 14:00:00 | AAPL | Stock | 1.4154 | 1.4218 | 1.3875 | 1.4204 | 49683004.0 |
| 2005-05-23 14:30:00 | AAPL | Stock | 1.4204 | 1.4207 | 1.4125 | 1.4164 | 38465196.0 |
| 2005-05-23 15:00:00 | AAPL | Stock | 1.4164 | 1.4168 | 1.4071 | 1.4118 | 47715752.0 |
| 2005-05-23 15:30:00 | AAPL | Stock | 1.4118 | 1.425 | 1.4118 | 1.4186 | 105494816.0 |
| 2005-05-23 16:00:00 | AAPL | Stock | 1.4189 | 1.4214 | 1.4164 | 1.4204 | 4343612.0 |
| 2005-05-23 16:30:00 | AAPL | Stock | 1.42 | 1.4229 | 1.42 | 1.4225 | 2396408.0 |
| 2005-05-23 17:00:00 | AAPL | Stock | 1.4221 | 1.4282 | 1.4221 | 1.4254 | 528500.0 |
| 2005-05-23 17:30:00 | AAPL | Stock | 1.425 | 1.4268 | 1.425 | 1.4264 | 126000.0 |
| 2005-05-23 18:00:00 | AAPL | Stock | 1.4261 | 1.4264 | 1.425 | 1.4257 | 93632.0 |
| 2005-05-23 07:30:00 | MSFT | Stock | 25.85 | 25.9 | 25.85 | 25.9 | 14603.0 |
| 2005-05-23 08:00:00 | MSFT | Stock | 25.93 | 25.95 | 25.86 | 25.89 | 65200.0 |
| 2005-05-23 08:30:00 | MSFT | Stock | 25.87 | 25.89 | 25.86 | 25.88 | 11700.0 |
| 2005-05-23 09:00:00 | MSFT | Stock | 25.87 | 25.88 | 25.75 | 25.76 | 223365.0 |
| 2005-05-23 09:30:00 | MSFT | Stock | 25.74 | 26.07 | 25.74 | 25.97 | 13397351.0 |
| 2005-05-23 10:00:00 | MSFT | Stock | 25.97 | 26.0 | 25.85 | 25.9 | 6244065.0 |
| 2005-05-23 10:30:00 | MSFT | Stock | 25.91 | 26.0 | 25.82 | 25.86 | 7047389.0 |
| 2005-05-23 11:00:00 | MSFT | Stock | 25.87 | 26.0 | 25.82 | 25.89 | 6734521.0 |
| 2005-05-23 11:30:00 | MSFT | Stock | 25.89 | 26.0 | 25.84 | 25.88 | 4078532.0 |
| 2005-05-23 12:00:00 | MSFT | Stock | 25.89 | 25.91 | 25.82 | 25.84 | 3521058.0 |
| 2005-05-23 12:30:00 | MSFT | Stock | 25.85 | 25.89 | 25.83 | 25.85 | 3124054.0 |
| 2005-05-23 13:00:00 | MSFT | Stock | 25.84 | 25.91 | 25.83 | 25.85 | 2423332.0 |
| 2005-05-23 13:30:00 | MSFT | Stock | 25.85 | 25.88 | 25.81 | 25.84 | 3778419.0 |
| 2005-05-23 14:00:00 | MSFT | Stock | 25.84 | 25.91 | 25.81 | 25.87 | 6132940.0 |
| 2005-05-23 14:30:00 | MSFT | Stock | 25.87 | 25.92 | 25.85 | 25.87 | 4197238.0 |
| 2005-05-23 15:00:00 | MSFT | Stock | 25.86 | 25.9 | 25.84 | 25.86 | 3948441.0 |
| 2005-05-23 15:30:00 | MSFT | Stock | 25.87 | 25.92 | 25.79 | 25.86 | 8746219.0 |
| 2005-05-23 16:00:00 | MSFT | Stock | 25.86 | 25.89 | 25.84 | 25.85 | 468682.0 |
| 2005-05-23 16:30:00 | MSFT | Stock | 25.84 | 25.86 | 25.82 | 25.85 | 131420.0 |
| 2005-05-23 17:00:00 | MSFT | Stock | 25.87 | 25.89 | 25.82 | 25.86 | 2584.0 |
| 2005-05-23 17:30:00 | MSFT | Stock | 25.84 | 25.87 | 25.84 | 25.85 | 4090.0 |
| 2005-05-23 18:00:00 | MSFT | Stock | 25.88 | 25.88 | 25.84 | 25.88 | 1140.0 |
| 2005-05-23 08:00:00 | NVDA | Stock | 0.2225 | 0.2225 | 0.2221 | 0.2221 | 60000.0 |
| 2005-05-23 08:30:00 | NVDA | Stock | 0.221 | 0.221 | 0.221 | 0.221 | 72000.0 |
| 2005-05-23 09:00:00 | NVDA | Stock | 0.2217 | 0.2217 | 0.2204 | 0.2211 | 1637160.0 |
| 2005-05-23 09:30:00 | NVDA | Stock | 0.2207 | 0.2249 | 0.22 | 0.2247 | 139869360.0 |
| 2005-05-23 10:00:00 | NVDA | Stock | 0.2247 | 0.2258 | 0.224 | 0.2251 | 99433440.0 |
| 2005-05-23 10:30:00 | NVDA | Stock | 0.2252 | 0.2252 | 0.2233 | 0.2238 | 68998920.0 |
> showing 50 of 43,577 rows — these rows as CSV