PREVIEW / stock_30min / 2006-01-20
file: by_date/stock_30min/2006/2006-01-20.parquet size: 903 KB rows: 48,192 symbols: 2,173
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-01-20 05:30:00 | AAPL | Stock | 2.8286 | 2.8286 | 2.8286 | 2.8286 | 5600.0 |
| 2006-01-20 06:00:00 | AAPL | Stock | 2.8264 | 2.8264 | 2.8264 | 2.8264 | 18788.0 |
| 2006-01-20 06:30:00 | AAPL | Stock | 2.8093 | 2.8093 | 2.8093 | 2.8093 | 13412.0 |
| 2006-01-20 07:00:00 | AAPL | Stock | 2.8089 | 2.8232 | 2.8071 | 2.8071 | 70000.0 |
| 2006-01-20 07:30:00 | AAPL | Stock | 2.8171 | 2.8214 | 2.8143 | 2.8214 | 129836.0 |
| 2006-01-20 08:00:00 | AAPL | Stock | 2.8214 | 2.8429 | 2.8175 | 2.8411 | 1527680.0 |
| 2006-01-20 08:30:00 | AAPL | Stock | 2.8411 | 2.8421 | 2.8354 | 2.8361 | 1018304.0 |
| 2006-01-20 09:00:00 | AAPL | Stock | 2.8361 | 2.8404 | 2.8311 | 2.8311 | 2947476.0 |
| 2006-01-20 09:30:00 | AAPL | Stock | 2.8314 | 2.8586 | 2.8261 | 2.8396 | 114827020.0 |
| 2006-01-20 10:00:00 | AAPL | Stock | 2.84 | 2.8557 | 2.7889 | 2.7993 | 150615444.0 |
| 2006-01-20 10:30:00 | AAPL | Stock | 2.7989 | 2.8082 | 2.77 | 2.7882 | 128306304.0 |
| 2006-01-20 11:00:00 | AAPL | Stock | 2.7882 | 2.7982 | 2.7696 | 2.7793 | 80939712.0 |
| 2006-01-20 11:30:00 | AAPL | Stock | 2.7793 | 2.78 | 2.7532 | 2.7614 | 86973152.0 |
| 2006-01-20 12:00:00 | AAPL | Stock | 2.7614 | 2.775 | 2.7536 | 2.7671 | 45995404.0 |
| 2006-01-20 12:30:00 | AAPL | Stock | 2.7671 | 2.7704 | 2.7336 | 2.7557 | 78298108.0 |
| 2006-01-20 13:00:00 | AAPL | Stock | 2.755 | 2.7604 | 2.7404 | 2.7536 | 55551944.0 |
| 2006-01-20 13:30:00 | AAPL | Stock | 2.7538 | 2.7643 | 2.7518 | 2.7557 | 51937760.0 |
| 2006-01-20 14:00:00 | AAPL | Stock | 2.7561 | 2.7564 | 2.7418 | 2.7543 | 54194980.0 |
| 2006-01-20 14:30:00 | AAPL | Stock | 2.7536 | 2.7607 | 2.7443 | 2.745 | 54936840.0 |
| 2006-01-20 15:00:00 | AAPL | Stock | 2.7454 | 2.7631 | 2.7439 | 2.7479 | 50126804.0 |
| 2006-01-20 15:30:00 | AAPL | Stock | 2.7482 | 2.7518 | 2.7082 | 2.7175 | 141663508.0 |
| 2006-01-20 16:00:00 | AAPL | Stock | 2.7161 | 2.7232 | 2.7143 | 2.7196 | 15138900.0 |
| 2006-01-20 16:30:00 | AAPL | Stock | 2.7186 | 2.7221 | 2.7164 | 2.7179 | 464156.0 |
| 2006-01-20 17:00:00 | AAPL | Stock | 2.7211 | 2.7339 | 2.7179 | 2.7268 | 637756.0 |
| 2006-01-20 17:30:00 | AAPL | Stock | 2.725 | 2.725 | 2.716 | 2.716 | 485268.0 |
| 2006-01-20 18:00:00 | AAPL | Stock | 2.725 | 2.7314 | 2.7232 | 2.73 | 407232.0 |
| 2006-01-20 04:30:00 | MSFT | Stock | 26.63 | 26.63 | 26.63 | 26.63 | 400.0 |
| 2006-01-20 08:00:00 | MSFT | Stock | 26.99 | 26.99 | 26.91 | 26.93 | 2095.0 |
| 2006-01-20 08:30:00 | MSFT | Stock | 26.93 | 26.93 | 26.93 | 26.93 | 160.0 |
| 2006-01-20 09:00:00 | MSFT | Stock | 26.95 | 27.06 | 26.93 | 27.0 | 246972.0 |
| 2006-01-20 09:30:00 | MSFT | Stock | 27.01 | 27.01 | 26.92 | 26.942 | 8154988.0 |
| 2006-01-20 10:00:00 | MSFT | Stock | 26.95 | 27.0 | 26.93 | 26.96 | 3829898.0 |
| 2006-01-20 10:30:00 | MSFT | Stock | 26.968 | 26.98 | 26.87 | 26.93 | 4228223.0 |
| 2006-01-20 11:00:00 | MSFT | Stock | 26.93 | 26.95 | 26.87 | 26.92 | 5019834.0 |
| 2006-01-20 11:30:00 | MSFT | Stock | 26.91 | 26.92 | 26.81 | 26.86 | 5205275.0 |
| 2006-01-20 12:00:00 | MSFT | Stock | 26.86 | 26.9 | 26.8 | 26.84 | 3183584.0 |
| 2006-01-20 12:30:00 | MSFT | Stock | 26.842 | 26.87 | 26.63 | 26.702 | 6786898.0 |
| 2006-01-20 13:00:00 | MSFT | Stock | 26.7 | 26.75 | 26.56 | 26.67 | 5630836.0 |
| 2006-01-20 13:30:00 | MSFT | Stock | 26.66 | 26.67 | 26.53 | 26.57 | 4110888.0 |
| 2006-01-20 14:00:00 | MSFT | Stock | 26.56 | 26.61 | 26.52 | 26.6 | 4258828.0 |
| 2006-01-20 14:30:00 | MSFT | Stock | 26.6 | 26.62 | 26.46 | 26.47 | 5857013.0 |
| 2006-01-20 15:00:00 | MSFT | Stock | 26.47 | 26.59 | 26.4 | 26.4 | 7096506.0 |
| 2006-01-20 15:30:00 | MSFT | Stock | 26.4 | 26.55 | 26.26 | 26.45 | 14026285.0 |
| 2006-01-20 16:00:00 | MSFT | Stock | 26.44 | 26.638 | 26.36 | 26.44 | 315965.0 |
| 2006-01-20 16:30:00 | MSFT | Stock | 26.44 | 26.46 | 26.44 | 26.46 | 13750.0 |
| 2006-01-20 17:00:00 | MSFT | Stock | 26.46 | 26.47 | 26.45 | 26.47 | 9000.0 |
| 2006-01-20 17:30:00 | MSFT | Stock | 26.46 | 26.51 | 26.46 | 26.46 | 12689.0 |
| 2006-01-20 18:00:00 | MSFT | Stock | 26.438 | 26.52 | 26.43 | 26.52 | 10836.0 |
| 2006-01-20 08:30:00 | NVDA | Stock | 0.3757 | 0.376 | 0.3742 | 0.3742 | 264000.0 |
| 2006-01-20 09:00:00 | NVDA | Stock | 0.3741 | 0.3762 | 0.3741 | 0.3762 | 1021200.0 |
> showing 50 of 48,192 rows — these rows as CSV