PREVIEW / stock_30min / 2006-09-28
file: by_date/stock_30min/2006/2006-09-28.parquet size: 920 KB rows: 50,669 symbols: 2,381
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-09-28 08:00:00 | AAPL | Stock | 2.7279 | 2.7464 | 2.7268 | 2.7414 | 1200640.0 |
| 2006-09-28 08:30:00 | AAPL | Stock | 2.74 | 2.7496 | 2.7357 | 2.7482 | 2897188.0 |
| 2006-09-28 09:00:00 | AAPL | Stock | 2.7496 | 2.7536 | 2.7457 | 2.7507 | 2260020.0 |
| 2006-09-28 09:30:00 | AAPL | Stock | 2.7507 | 2.7671 | 2.7404 | 2.7532 | 125628188.0 |
| 2006-09-28 10:00:00 | AAPL | Stock | 2.7532 | 2.7625 | 2.7439 | 2.745 | 85828260.0 |
| 2006-09-28 10:30:00 | AAPL | Stock | 2.745 | 2.7479 | 2.7221 | 2.7368 | 108090220.0 |
| 2006-09-28 11:00:00 | AAPL | Stock | 2.7368 | 2.7432 | 2.7296 | 2.7329 | 45113292.0 |
| 2006-09-28 11:30:00 | AAPL | Stock | 2.7325 | 2.7336 | 2.7171 | 2.7225 | 43581524.0 |
| 2006-09-28 12:00:00 | AAPL | Stock | 2.7225 | 2.7246 | 2.7125 | 2.7186 | 46521132.0 |
| 2006-09-28 12:30:00 | AAPL | Stock | 2.7186 | 2.7343 | 2.7157 | 2.7325 | 35531580.0 |
| 2006-09-28 13:00:00 | AAPL | Stock | 2.7321 | 2.7457 | 2.7289 | 2.7393 | 38705716.0 |
| 2006-09-28 13:30:00 | AAPL | Stock | 2.7393 | 2.7471 | 2.7336 | 2.7407 | 29410500.0 |
| 2006-09-28 14:00:00 | AAPL | Stock | 2.7407 | 2.7464 | 2.7361 | 2.7411 | 28157248.0 |
| 2006-09-28 14:30:00 | AAPL | Stock | 2.7411 | 2.7443 | 2.7314 | 2.7357 | 28071652.0 |
| 2006-09-28 15:00:00 | AAPL | Stock | 2.7354 | 2.745 | 2.7329 | 2.7414 | 36005200.0 |
| 2006-09-28 15:30:00 | AAPL | Stock | 2.7421 | 2.7525 | 2.7411 | 2.7518 | 50903860.0 |
| 2006-09-28 16:00:00 | AAPL | Stock | 2.7518 | 2.7582 | 2.7496 | 2.7518 | 1815464.0 |
| 2006-09-28 16:30:00 | AAPL | Stock | 2.7543 | 2.7543 | 2.75 | 2.7504 | 211512.0 |
| 2006-09-28 17:00:00 | AAPL | Stock | 2.7511 | 2.7554 | 2.75 | 2.7554 | 519680.0 |
| 2006-09-28 17:30:00 | AAPL | Stock | 2.7561 | 2.7604 | 2.7536 | 2.7604 | 580636.0 |
| 2006-09-28 18:00:00 | AAPL | Stock | 2.7604 | 2.7607 | 2.7524 | 2.7607 | 337148.0 |
| 2006-09-28 18:30:00 | AAPL | Stock | 2.7607 | 2.7618 | 2.7607 | 2.7611 | 101360.0 |
| 2006-09-28 19:00:00 | AAPL | Stock | 2.7639 | 2.7639 | 2.7607 | 2.7607 | 16800.0 |
| 2006-09-28 19:30:00 | AAPL | Stock | 2.7589 | 2.7625 | 2.7589 | 2.7589 | 89600.0 |
| 2006-09-28 07:30:00 | MSFT | Stock | 27.56 | 27.56 | 27.56 | 27.56 | 900.0 |
| 2006-09-28 08:00:00 | MSFT | Stock | 27.56 | 27.6 | 27.56 | 27.6 | 138362.0 |
| 2006-09-28 08:30:00 | MSFT | Stock | 27.58 | 27.58 | 27.51 | 27.53 | 36500.0 |
| 2006-09-28 09:00:00 | MSFT | Stock | 27.51 | 27.57 | 27.46 | 27.49 | 149382.0 |
| 2006-09-28 09:30:00 | MSFT | Stock | 27.47 | 27.52 | 27.39 | 27.47 | 5850917.0 |
| 2006-09-28 10:00:00 | MSFT | Stock | 27.46 | 27.5 | 27.44 | 27.49 | 3257671.0 |
| 2006-09-28 10:30:00 | MSFT | Stock | 27.49 | 27.5 | 27.4 | 27.44 | 4317450.0 |
| 2006-09-28 11:00:00 | MSFT | Stock | 27.45 | 27.5 | 27.43 | 27.48 | 4087327.0 |
| 2006-09-28 11:30:00 | MSFT | Stock | 27.48 | 27.49 | 27.42 | 27.422 | 2585706.0 |
| 2006-09-28 12:00:00 | MSFT | Stock | 27.42 | 27.5 | 27.33 | 27.42 | 3507196.0 |
| 2006-09-28 12:30:00 | MSFT | Stock | 27.42 | 27.45 | 27.36 | 27.371 | 1457524.0 |
| 2006-09-28 13:00:00 | MSFT | Stock | 27.37 | 27.44 | 27.37 | 27.41 | 1686839.0 |
| 2006-09-28 13:30:00 | MSFT | Stock | 27.4 | 27.41 | 27.34 | 27.39 | 1663373.0 |
| 2006-09-28 14:00:00 | MSFT | Stock | 27.39 | 27.39 | 27.32 | 27.35 | 2013028.0 |
| 2006-09-28 14:30:00 | MSFT | Stock | 27.352 | 27.36 | 27.26 | 27.31 | 2913050.0 |
| 2006-09-28 15:00:00 | MSFT | Stock | 27.32 | 27.38 | 27.3 | 27.37 | 2715763.0 |
| 2006-09-28 15:30:00 | MSFT | Stock | 27.37 | 27.42 | 27.35 | 27.39 | 5708572.0 |
| 2006-09-28 16:00:00 | MSFT | Stock | 27.38 | 27.43 | 27.37 | 27.384 | 63510.0 |
| 2006-09-28 16:30:00 | MSFT | Stock | 27.38 | 27.38 | 27.38 | 27.38 | 1450.0 |
| 2006-09-28 17:30:00 | MSFT | Stock | 27.4 | 27.42 | 27.37 | 27.42 | 5200.0 |
| 2006-09-28 18:00:00 | MSFT | Stock | 27.42 | 27.45 | 27.399 | 27.4 | 854963.0 |
| 2006-09-28 19:30:00 | MSFT | Stock | 27.42 | 27.42 | 27.42 | 27.42 | 334.0 |
| 2006-09-28 07:00:00 | NVDA | Stock | 0.4795 | 0.4795 | 0.4795 | 0.4795 | 6000.0 |
| 2006-09-28 08:00:00 | NVDA | Stock | 0.489 | 0.4955 | 0.4837 | 0.4887 | 3105000.0 |
| 2006-09-28 08:30:00 | NVDA | Stock | 0.4905 | 0.4912 | 0.4888 | 0.49 | 1657200.0 |
| 2006-09-28 09:00:00 | NVDA | Stock | 0.4888 | 0.49 | 0.4807 | 0.4827 | 6370140.0 |
> showing 50 of 50,669 rows — these rows as CSV