PREVIEW / stock_30min / 2005-08-04
file: by_date/stock_30min/2005/2005-08-04.parquet size: 844 KB rows: 45,846 symbols: 2,052
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-08-04 07:30:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5286 | 1.5286 | 5600.0 |
| 2005-08-04 08:00:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5357 | 1.5357 | 352800.0 |
| 2005-08-04 08:30:00 | AAPL | Stock | 1.5346 | 1.5354 | 1.5339 | 1.5339 | 138320.0 |
| 2005-08-04 09:00:00 | AAPL | Stock | 1.5354 | 1.5375 | 1.5332 | 1.5332 | 369376.0 |
| 2005-08-04 09:30:00 | AAPL | Stock | 1.5318 | 1.5357 | 1.5282 | 1.5289 | 27089524.0 |
| 2005-08-04 10:00:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5229 | 1.5286 | 28748216.0 |
| 2005-08-04 10:30:00 | AAPL | Stock | 1.5286 | 1.5318 | 1.5275 | 1.5304 | 11324096.0 |
| 2005-08-04 11:00:00 | AAPL | Stock | 1.5304 | 1.5318 | 1.5243 | 1.525 | 17105620.0 |
| 2005-08-04 11:30:00 | AAPL | Stock | 1.525 | 1.525 | 1.515 | 1.5164 | 25550784.0 |
| 2005-08-04 12:00:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5104 | 1.5143 | 18894876.0 |
| 2005-08-04 12:30:00 | AAPL | Stock | 1.5143 | 1.5179 | 1.5139 | 1.5154 | 25290524.0 |
| 2005-08-04 13:00:00 | AAPL | Stock | 1.515 | 1.5175 | 1.5143 | 1.5157 | 16174620.0 |
| 2005-08-04 13:30:00 | AAPL | Stock | 1.5154 | 1.5189 | 1.5121 | 1.5186 | 15857408.0 |
| 2005-08-04 14:00:00 | AAPL | Stock | 1.5182 | 1.5239 | 1.5179 | 1.5236 | 12816664.0 |
| 2005-08-04 14:30:00 | AAPL | Stock | 1.5236 | 1.5254 | 1.5211 | 1.5236 | 16668428.0 |
| 2005-08-04 15:00:00 | AAPL | Stock | 1.5232 | 1.5268 | 1.5218 | 1.5261 | 15770580.0 |
| 2005-08-04 15:30:00 | AAPL | Stock | 1.5261 | 1.5264 | 1.5221 | 1.5236 | 30556176.0 |
| 2005-08-04 16:00:00 | AAPL | Stock | 1.5257 | 1.5261 | 1.5232 | 1.5232 | 2276708.0 |
| 2005-08-04 16:30:00 | AAPL | Stock | 1.5232 | 1.525 | 1.5232 | 1.5236 | 476868.0 |
| 2005-08-04 17:00:00 | AAPL | Stock | 1.525 | 1.5254 | 1.5232 | 1.5254 | 2525600.0 |
| 2005-08-04 17:30:00 | AAPL | Stock | 1.5236 | 1.525 | 1.5236 | 1.525 | 44800.0 |
| 2005-08-04 18:00:00 | AAPL | Stock | 1.5232 | 1.5236 | 1.5232 | 1.5236 | 3517360.0 |
| 2005-08-04 08:00:00 | MSFT | Stock | 27.23 | 27.23 | 27.0 | 27.05 | 259224.0 |
| 2005-08-04 08:30:00 | MSFT | Stock | 27.05 | 27.16 | 27.03 | 27.12 | 87904.0 |
| 2005-08-04 09:00:00 | MSFT | Stock | 27.12 | 27.2 | 27.11 | 27.15 | 608992.0 |
| 2005-08-04 09:30:00 | MSFT | Stock | 27.16 | 27.5 | 27.13 | 27.31 | 13397318.0 |
| 2005-08-04 10:00:00 | MSFT | Stock | 27.302 | 27.39 | 27.255 | 27.39 | 8366064.0 |
| 2005-08-04 10:30:00 | MSFT | Stock | 27.38 | 27.4 | 27.24 | 27.27 | 6811050.0 |
| 2005-08-04 11:00:00 | MSFT | Stock | 27.27 | 27.33 | 27.22 | 27.29 | 6271713.0 |
| 2005-08-04 11:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.169 | 27.18 | 9105945.0 |
| 2005-08-04 12:00:00 | MSFT | Stock | 27.18 | 27.21 | 27.13 | 27.18 | 7497063.0 |
| 2005-08-04 12:30:00 | MSFT | Stock | 27.18 | 27.23 | 27.14 | 27.152 | 3263539.0 |
| 2005-08-04 13:00:00 | MSFT | Stock | 27.16 | 27.18 | 27.06 | 27.07 | 5216929.0 |
| 2005-08-04 13:30:00 | MSFT | Stock | 27.08 | 27.19 | 27.05 | 27.18 | 4619074.0 |
| 2005-08-04 14:00:00 | MSFT | Stock | 27.17 | 27.29 | 27.17 | 27.27 | 6203000.0 |
| 2005-08-04 14:30:00 | MSFT | Stock | 27.27 | 27.3 | 27.182 | 27.23 | 5004125.0 |
| 2005-08-04 15:00:00 | MSFT | Stock | 27.22 | 27.34 | 27.2 | 27.32 | 4707216.0 |
| 2005-08-04 15:30:00 | MSFT | Stock | 27.33 | 27.33 | 27.24 | 27.31 | 8289234.0 |
| 2005-08-04 16:00:00 | MSFT | Stock | 27.31 | 27.35 | 27.25 | 27.35 | 689358.0 |
| 2005-08-04 16:30:00 | MSFT | Stock | 27.35 | 27.4 | 27.32 | 27.38 | 222234.0 |
| 2005-08-04 17:00:00 | MSFT | Stock | 27.38 | 27.41 | 27.32 | 27.32 | 224300.0 |
| 2005-08-04 17:30:00 | MSFT | Stock | 27.36 | 27.36 | 27.34 | 27.36 | 15274.0 |
| 2005-08-04 18:00:00 | MSFT | Stock | 27.32 | 27.41 | 27.32 | 27.41 | 68768.0 |
| 2005-08-04 08:30:00 | NVDA | Stock | 0.23 | 0.2318 | 0.23 | 0.2301 | 624000.0 |
| 2005-08-04 09:00:00 | NVDA | Stock | 0.2315 | 0.2315 | 0.2304 | 0.2305 | 720000.0 |
| 2005-08-04 09:30:00 | NVDA | Stock | 0.2302 | 0.2311 | 0.2291 | 0.2297 | 32669640.0 |
| 2005-08-04 10:00:00 | NVDA | Stock | 0.2298 | 0.23 | 0.2292 | 0.2299 | 16934160.0 |
| 2005-08-04 10:30:00 | NVDA | Stock | 0.2298 | 0.2312 | 0.2294 | 0.2311 | 28434960.0 |
| 2005-08-04 11:00:00 | NVDA | Stock | 0.2311 | 0.2311 | 0.2296 | 0.2297 | 26420160.0 |
| 2005-08-04 11:30:00 | NVDA | Stock | 0.2298 | 0.2302 | 0.2293 | 0.2299 | 16606320.0 |
> showing 50 of 45,846 rows — these rows as CSV