PREVIEW / stock_30min / 2006-10-10
file: by_date/stock_30min/2006/2006-10-10.parquet size: 909 KB rows: 49,565 symbols: 2,385
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-10-10 07:30:00 | AAPL | Stock | 2.6614 | 2.6618 | 2.6614 | 2.6618 | 47600.0 |
| 2006-10-10 08:00:00 | AAPL | Stock | 2.6643 | 2.6661 | 2.6586 | 2.6586 | 325500.0 |
| 2006-10-10 08:30:00 | AAPL | Stock | 2.6625 | 2.6679 | 2.6607 | 2.6621 | 284200.0 |
| 2006-10-10 09:00:00 | AAPL | Stock | 2.6636 | 2.6668 | 2.6596 | 2.6621 | 1344840.0 |
| 2006-10-10 09:30:00 | AAPL | Stock | 2.6621 | 2.6636 | 2.6425 | 2.6471 | 82828060.0 |
| 2006-10-10 10:00:00 | AAPL | Stock | 2.6479 | 2.6621 | 2.6457 | 2.6504 | 44470580.0 |
| 2006-10-10 10:30:00 | AAPL | Stock | 2.6507 | 2.6593 | 2.6479 | 2.6525 | 28621684.0 |
| 2006-10-10 11:00:00 | AAPL | Stock | 2.6529 | 2.66 | 2.6482 | 2.6554 | 30419536.0 |
| 2006-10-10 11:30:00 | AAPL | Stock | 2.655 | 2.6561 | 2.6421 | 2.6443 | 31367476.0 |
| 2006-10-10 12:00:00 | AAPL | Stock | 2.6446 | 2.6482 | 2.6296 | 2.6329 | 51405900.0 |
| 2006-10-10 12:30:00 | AAPL | Stock | 2.6332 | 2.6429 | 2.6239 | 2.6304 | 37448264.0 |
| 2006-10-10 13:00:00 | AAPL | Stock | 2.6307 | 2.6364 | 2.6271 | 2.6279 | 24509632.0 |
| 2006-10-10 13:30:00 | AAPL | Stock | 2.6282 | 2.6289 | 2.61 | 2.6196 | 46685492.0 |
| 2006-10-10 14:00:00 | AAPL | Stock | 2.6197 | 2.6225 | 2.6104 | 2.6214 | 30928016.0 |
| 2006-10-10 14:30:00 | AAPL | Stock | 2.6214 | 2.6354 | 2.6211 | 2.6307 | 36588748.0 |
| 2006-10-10 15:00:00 | AAPL | Stock | 2.63 | 2.6332 | 2.6229 | 2.6282 | 28835940.0 |
| 2006-10-10 15:30:00 | AAPL | Stock | 2.6286 | 2.6361 | 2.6271 | 2.6354 | 43925000.0 |
| 2006-10-10 16:00:00 | AAPL | Stock | 2.6357 | 2.6393 | 2.6325 | 2.6375 | 3108924.0 |
| 2006-10-10 16:30:00 | AAPL | Stock | 2.6361 | 2.6361 | 2.6329 | 2.6339 | 301392.0 |
| 2006-10-10 17:00:00 | AAPL | Stock | 2.6332 | 2.6339 | 2.6329 | 2.6329 | 45220.0 |
| 2006-10-10 17:30:00 | AAPL | Stock | 2.6329 | 2.6329 | 2.6325 | 2.6329 | 199528.0 |
| 2006-10-10 18:00:00 | AAPL | Stock | 2.6336 | 2.6339 | 2.6325 | 2.6325 | 105420.0 |
| 2006-10-10 18:30:00 | AAPL | Stock | 2.6346 | 2.6346 | 2.6343 | 2.6343 | 18200.0 |
| 2006-10-10 19:00:00 | AAPL | Stock | 2.6343 | 2.6357 | 2.6343 | 2.6357 | 8316.0 |
| 2006-10-10 07:30:00 | MSFT | Stock | 27.69 | 27.69 | 27.69 | 27.69 | 200.0 |
| 2006-10-10 08:00:00 | MSFT | Stock | 27.72 | 27.72 | 27.65 | 27.69 | 35230.0 |
| 2006-10-10 08:30:00 | MSFT | Stock | 27.69 | 27.69 | 27.67 | 27.67 | 6530.0 |
| 2006-10-10 09:00:00 | MSFT | Stock | 27.67 | 27.7 | 27.6 | 27.69 | 82100.0 |
| 2006-10-10 09:30:00 | MSFT | Stock | 27.69 | 27.75 | 27.58 | 27.58 | 4476663.0 |
| 2006-10-10 10:00:00 | MSFT | Stock | 27.59 | 27.6 | 27.51 | 27.521 | 3532396.0 |
| 2006-10-10 10:30:00 | MSFT | Stock | 27.53 | 27.63 | 27.52 | 27.6 | 2360828.0 |
| 2006-10-10 11:00:00 | MSFT | Stock | 27.6 | 27.64 | 27.55 | 27.582 | 2893412.0 |
| 2006-10-10 11:30:00 | MSFT | Stock | 27.58 | 27.7 | 27.55 | 27.57 | 1002649.0 |
| 2006-10-10 12:00:00 | MSFT | Stock | 27.57 | 27.59 | 27.52 | 27.54 | 1278023.0 |
| 2006-10-10 12:30:00 | MSFT | Stock | 27.54 | 27.55 | 27.51 | 27.53 | 1034071.0 |
| 2006-10-10 13:00:00 | MSFT | Stock | 27.53 | 27.55 | 27.51 | 27.54 | 1253295.0 |
| 2006-10-10 13:30:00 | MSFT | Stock | 27.54 | 27.55 | 27.44 | 27.55 | 2441004.0 |
| 2006-10-10 14:00:00 | MSFT | Stock | 27.55 | 27.551 | 27.5 | 27.54 | 2156329.0 |
| 2006-10-10 14:30:00 | MSFT | Stock | 27.54 | 27.65 | 27.53 | 27.62 | 2286989.0 |
| 2006-10-10 15:00:00 | MSFT | Stock | 27.62 | 27.62 | 27.5 | 27.54 | 3078585.0 |
| 2006-10-10 15:30:00 | MSFT | Stock | 27.53 | 27.69 | 27.53 | 27.67 | 5373113.0 |
| 2006-10-10 16:00:00 | MSFT | Stock | 27.68 | 27.68 | 27.6 | 27.66 | 71380.0 |
| 2006-10-10 16:30:00 | MSFT | Stock | 27.67 | 27.67 | 27.64 | 27.64 | 13600.0 |
| 2006-10-10 17:00:00 | MSFT | Stock | 27.64 | 27.64 | 27.64 | 27.64 | 1700.0 |
| 2006-10-10 17:30:00 | MSFT | Stock | 27.65 | 27.65 | 27.64 | 27.64 | 800.0 |
| 2006-10-10 18:00:00 | MSFT | Stock | 27.67 | 27.67 | 27.64 | 27.64 | 889.0 |
| 2006-10-10 18:30:00 | MSFT | Stock | 27.64 | 27.64 | 27.64 | 27.64 | 177.0 |
| 2006-10-10 19:00:00 | MSFT | Stock | 27.65 | 27.65 | 27.65 | 27.65 | 100.0 |
| 2006-10-10 08:00:00 | NVDA | Stock | 0.5465 | 0.5577 | 0.5465 | 0.5492 | 48000.0 |
| 2006-10-10 08:30:00 | NVDA | Stock | 0.5467 | 0.547 | 0.5467 | 0.547 | 26100.0 |
> showing 50 of 49,565 rows — these rows as CSV