PREVIEW / stock_30min / 2006-05-04
file: by_date/stock_30min/2006/2006-05-04.parquet size: 901 KB rows: 48,663 symbols: 2,261
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-05-04 08:00:00 | AAPL | Stock | 2.5393 | 2.55 | 2.5393 | 2.5468 | 576940.0 |
| 2006-05-04 08:30:00 | AAPL | Stock | 2.5468 | 2.5468 | 2.5411 | 2.5443 | 504112.0 |
| 2006-05-04 09:00:00 | AAPL | Stock | 2.5446 | 2.5464 | 2.5357 | 2.5411 | 1086260.0 |
| 2006-05-04 09:30:00 | AAPL | Stock | 2.5436 | 2.5996 | 2.5375 | 2.5979 | 169470140.0 |
| 2006-05-04 10:00:00 | AAPL | Stock | 2.5971 | 2.6032 | 2.5771 | 2.5871 | 106646960.0 |
| 2006-05-04 10:30:00 | AAPL | Stock | 2.5871 | 2.5904 | 2.5646 | 2.5657 | 58810500.0 |
| 2006-05-04 11:00:00 | AAPL | Stock | 2.5657 | 2.58 | 2.5654 | 2.5757 | 42114548.0 |
| 2006-05-04 11:30:00 | AAPL | Stock | 2.5757 | 2.5854 | 2.575 | 2.5775 | 28557172.0 |
| 2006-05-04 12:00:00 | AAPL | Stock | 2.5771 | 2.5789 | 2.5586 | 2.565 | 39165140.0 |
| 2006-05-04 12:30:00 | AAPL | Stock | 2.565 | 2.5661 | 2.5164 | 2.5371 | 118732852.0 |
| 2006-05-04 13:00:00 | AAPL | Stock | 2.5364 | 2.5557 | 2.5364 | 2.5514 | 42698096.0 |
| 2006-05-04 13:30:00 | AAPL | Stock | 2.5518 | 2.5596 | 2.5457 | 2.5561 | 30667112.0 |
| 2006-05-04 14:00:00 | AAPL | Stock | 2.5561 | 2.5639 | 2.5511 | 2.5518 | 39338908.0 |
| 2006-05-04 14:30:00 | AAPL | Stock | 2.555 | 2.5571 | 2.5407 | 2.5532 | 41630400.0 |
| 2006-05-04 15:00:00 | AAPL | Stock | 2.5532 | 2.5564 | 2.5379 | 2.5432 | 36958348.0 |
| 2006-05-04 15:30:00 | AAPL | Stock | 2.5439 | 2.5461 | 2.5339 | 2.5397 | 42896504.0 |
| 2006-05-04 16:00:00 | AAPL | Stock | 2.5411 | 2.5411 | 2.5382 | 2.5407 | 28746928.0 |
| 2006-05-04 16:30:00 | AAPL | Stock | 2.5386 | 2.5407 | 2.5386 | 2.54 | 110348.0 |
| 2006-05-04 17:00:00 | AAPL | Stock | 2.54 | 2.5411 | 2.5393 | 2.5411 | 93800.0 |
| 2006-05-04 17:30:00 | AAPL | Stock | 2.5389 | 2.5407 | 2.5382 | 2.5407 | 134960.0 |
| 2006-05-04 18:00:00 | AAPL | Stock | 2.5393 | 2.5407 | 2.5393 | 2.5407 | 63000.0 |
| 2006-05-04 06:30:00 | MSFT | Stock | 23.36 | 23.36 | 23.36 | 23.36 | 200.0 |
| 2006-05-04 07:00:00 | MSFT | Stock | 23.36 | 23.36 | 23.27 | 23.28 | 10150.0 |
| 2006-05-04 07:30:00 | MSFT | Stock | 23.3 | 23.3 | 23.3 | 23.3 | 16150.0 |
| 2006-05-04 08:00:00 | MSFT | Stock | 23.31 | 23.33 | 23.28 | 23.33 | 124620.0 |
| 2006-05-04 08:30:00 | MSFT | Stock | 23.32 | 23.37 | 23.3 | 23.35 | 315665.0 |
| 2006-05-04 09:00:00 | MSFT | Stock | 23.35 | 23.38 | 23.31 | 23.35 | 636122.0 |
| 2006-05-04 09:30:00 | MSFT | Stock | 23.35 | 23.67 | 23.14 | 23.49 | 22998777.0 |
| 2006-05-04 10:00:00 | MSFT | Stock | 23.49 | 23.55 | 23.42 | 23.448 | 14087307.0 |
| 2006-05-04 10:30:00 | MSFT | Stock | 23.45 | 23.46 | 23.26 | 23.3 | 17931646.0 |
| 2006-05-04 11:00:00 | MSFT | Stock | 23.3 | 23.34 | 23.2 | 23.23 | 11174008.0 |
| 2006-05-04 11:30:00 | MSFT | Stock | 23.23 | 23.36 | 23.22 | 23.32 | 12446456.0 |
| 2006-05-04 12:00:00 | MSFT | Stock | 23.32 | 23.39 | 23.27 | 23.35 | 10355006.0 |
| 2006-05-04 12:30:00 | MSFT | Stock | 23.35 | 23.42 | 23.31 | 23.38 | 10203726.0 |
| 2006-05-04 13:00:00 | MSFT | Stock | 23.38 | 23.48 | 23.37 | 23.48 | 5671834.0 |
| 2006-05-04 13:30:00 | MSFT | Stock | 23.48 | 23.48 | 23.35 | 23.45 | 8831790.0 |
| 2006-05-04 14:00:00 | MSFT | Stock | 23.46 | 23.55 | 23.45 | 23.49 | 13745063.0 |
| 2006-05-04 14:30:00 | MSFT | Stock | 23.49 | 23.5 | 23.42 | 23.48 | 8131180.0 |
| 2006-05-04 15:00:00 | MSFT | Stock | 23.48 | 23.51 | 23.45 | 23.45 | 8282055.0 |
| 2006-05-04 15:30:00 | MSFT | Stock | 23.46 | 23.5 | 23.42 | 23.44 | 13561038.0 |
| 2006-05-04 16:00:00 | MSFT | Stock | 23.43 | 23.5 | 23.27 | 23.48 | 8558892.0 |
| 2006-05-04 16:30:00 | MSFT | Stock | 23.49 | 23.54 | 23.403 | 23.46 | 80700.0 |
| 2006-05-04 17:00:00 | MSFT | Stock | 23.49 | 23.54 | 23.44 | 23.54 | 29933.0 |
| 2006-05-04 17:30:00 | MSFT | Stock | 23.5 | 23.56 | 23.45 | 23.55 | 31048.0 |
| 2006-05-04 18:00:00 | MSFT | Stock | 23.54 | 23.55 | 23.5 | 23.51 | 8594.0 |
| 2006-05-04 08:00:00 | NVDA | Stock | 0.5168 | 0.5168 | 0.5107 | 0.5107 | 594780.0 |
| 2006-05-04 08:30:00 | NVDA | Stock | 0.5103 | 0.511 | 0.5017 | 0.508 | 2305620.0 |
| 2006-05-04 09:00:00 | NVDA | Stock | 0.5078 | 0.5083 | 0.505 | 0.5078 | 724140.0 |
| 2006-05-04 09:30:00 | NVDA | Stock | 0.5075 | 0.5162 | 0.5048 | 0.5123 | 84150060.0 |
| 2006-05-04 10:00:00 | NVDA | Stock | 0.5123 | 0.5123 | 0.5087 | 0.5092 | 50689860.0 |
> showing 50 of 48,663 rows — these rows as CSV