PREVIEW / stock_30min / 2006-05-03
file: by_date/stock_30min/2006/2006-05-03.parquet size: 903 KB rows: 48,753 symbols: 2,252
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-03 04:30:00 | AAPL | Stock | 2.5579 | 2.5579 | 2.5579 | 2.5579 | 2800.0 |
| 2006-05-03 08:00:00 | AAPL | Stock | 2.5571 | 2.5714 | 2.5571 | 2.5661 | 1642508.0 |
| 2006-05-03 08:30:00 | AAPL | Stock | 2.5661 | 2.5679 | 2.5589 | 2.5661 | 1090264.0 |
| 2006-05-03 09:00:00 | AAPL | Stock | 2.5646 | 2.5732 | 2.5611 | 2.5657 | 3952228.0 |
| 2006-05-03 09:30:00 | AAPL | Stock | 2.5654 | 2.5696 | 2.5064 | 2.5139 | 153280120.0 |
| 2006-05-03 10:00:00 | AAPL | Stock | 2.5139 | 2.5329 | 2.5129 | 2.5275 | 72684892.0 |
| 2006-05-03 10:30:00 | AAPL | Stock | 2.5271 | 2.535 | 2.5154 | 2.5186 | 49833952.0 |
| 2006-05-03 11:00:00 | AAPL | Stock | 2.5189 | 2.5229 | 2.5079 | 2.5229 | 44401112.0 |
| 2006-05-03 11:30:00 | AAPL | Stock | 2.5229 | 2.53 | 2.5186 | 2.5267 | 34121024.0 |
| 2006-05-03 12:00:00 | AAPL | Stock | 2.5264 | 2.5486 | 2.5254 | 2.5411 | 59784144.0 |
| 2006-05-03 12:30:00 | AAPL | Stock | 2.541 | 2.5454 | 2.5321 | 2.5396 | 34118840.0 |
| 2006-05-03 13:00:00 | AAPL | Stock | 2.5396 | 2.5493 | 2.5361 | 2.54 | 24370808.0 |
| 2006-05-03 13:30:00 | AAPL | Stock | 2.5404 | 2.5429 | 2.525 | 2.5336 | 38232712.0 |
| 2006-05-03 14:00:00 | AAPL | Stock | 2.5336 | 2.5357 | 2.5221 | 2.5264 | 33498528.0 |
| 2006-05-03 14:30:00 | AAPL | Stock | 2.5268 | 2.5289 | 2.52 | 2.5221 | 26224856.0 |
| 2006-05-03 15:00:00 | AAPL | Stock | 2.5218 | 2.54 | 2.5211 | 2.5389 | 38500196.0 |
| 2006-05-03 15:30:00 | AAPL | Stock | 2.5389 | 2.5464 | 2.5368 | 2.5407 | 54072704.0 |
| 2006-05-03 16:00:00 | AAPL | Stock | 2.5414 | 2.5425 | 2.5393 | 2.5425 | 1083908.0 |
| 2006-05-03 16:30:00 | AAPL | Stock | 2.5421 | 2.5425 | 2.54 | 2.5407 | 5182800.0 |
| 2006-05-03 17:00:00 | AAPL | Stock | 2.5404 | 2.5425 | 2.5393 | 2.5404 | 261660.0 |
| 2006-05-03 17:30:00 | AAPL | Stock | 2.5404 | 2.5421 | 2.5404 | 2.5407 | 112000.0 |
| 2006-05-03 18:00:00 | AAPL | Stock | 2.5407 | 2.5421 | 2.54 | 2.54 | 241360.0 |
| 2006-05-03 06:30:00 | MSFT | Stock | 24.03 | 24.03 | 24.03 | 24.03 | 1000.0 |
| 2006-05-03 07:30:00 | MSFT | Stock | 24.03 | 24.03 | 24.03 | 24.03 | 100.0 |
| 2006-05-03 08:00:00 | MSFT | Stock | 24.03 | 24.06 | 23.5 | 23.92 | 245115.0 |
| 2006-05-03 08:30:00 | MSFT | Stock | 23.91 | 23.96 | 23.91 | 23.93 | 158512.0 |
| 2006-05-03 09:00:00 | MSFT | Stock | 23.94 | 24.04 | 23.94 | 23.99 | 275110.0 |
| 2006-05-03 09:30:00 | MSFT | Stock | 23.99 | 24.02 | 23.92 | 23.93 | 13391154.0 |
| 2006-05-03 10:00:00 | MSFT | Stock | 23.93 | 24.0 | 23.76 | 23.9 | 14145424.0 |
| 2006-05-03 10:30:00 | MSFT | Stock | 23.9 | 23.91 | 23.73 | 23.78 | 12174033.0 |
| 2006-05-03 11:00:00 | MSFT | Stock | 23.78 | 23.9 | 23.71 | 23.76 | 10507374.0 |
| 2006-05-03 11:30:00 | MSFT | Stock | 23.76 | 23.89 | 23.6 | 23.65 | 15014064.0 |
| 2006-05-03 12:00:00 | MSFT | Stock | 23.65 | 23.68 | 23.52 | 23.53 | 12225863.0 |
| 2006-05-03 12:30:00 | MSFT | Stock | 23.52 | 23.56 | 23.5 | 23.53 | 10562494.0 |
| 2006-05-03 13:00:00 | MSFT | Stock | 23.53 | 23.55 | 23.39 | 23.46 | 14160170.0 |
| 2006-05-03 13:30:00 | MSFT | Stock | 23.46 | 23.597 | 23.34 | 23.37 | 19840869.0 |
| 2006-05-03 14:00:00 | MSFT | Stock | 23.36 | 23.435 | 23.24 | 23.31 | 15856857.0 |
| 2006-05-03 14:30:00 | MSFT | Stock | 23.31 | 23.4 | 23.27 | 23.36 | 13454384.0 |
| 2006-05-03 15:00:00 | MSFT | Stock | 23.36 | 23.4 | 23.27 | 23.29 | 22195161.0 |
| 2006-05-03 15:30:00 | MSFT | Stock | 23.28 | 23.37 | 23.15 | 23.17 | 24694847.0 |
| 2006-05-03 16:00:00 | MSFT | Stock | 23.17 | 23.54 | 23.14 | 23.14 | 4800492.0 |
| 2006-05-03 16:30:00 | MSFT | Stock | 23.16 | 23.22 | 23.15 | 23.2 | 1050435.0 |
| 2006-05-03 17:00:00 | MSFT | Stock | 23.2 | 23.22 | 23.17 | 23.22 | 1005070.0 |
| 2006-05-03 17:30:00 | MSFT | Stock | 23.21 | 23.25 | 23.21 | 23.24 | 38968.0 |
| 2006-05-03 18:00:00 | MSFT | Stock | 23.23 | 23.25 | 23.23 | 23.23 | 16227.0 |
| 2006-05-03 08:00:00 | NVDA | Stock | 0.5167 | 0.5167 | 0.5117 | 0.5118 | 78000.0 |
| 2006-05-03 08:30:00 | NVDA | Stock | 0.5127 | 0.5127 | 0.5095 | 0.5097 | 162000.0 |
| 2006-05-03 09:00:00 | NVDA | Stock | 0.51 | 0.5115 | 0.5083 | 0.5115 | 795060.0 |
| 2006-05-03 09:30:00 | NVDA | Stock | 0.5085 | 0.523 | 0.508 | 0.523 | 55341720.0 |
| 2006-05-03 10:00:00 | NVDA | Stock | 0.5232 | 0.5233 | 0.5122 | 0.5148 | 43322880.0 |
> showing 50 of 48,753 rows — these rows as CSV