PREVIEW / stock_30min / 2006-01-19
file: by_date/stock_30min/2006/2006-01-19.parquet size: 897 KB rows: 48,169 symbols: 2,175
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-19 05:30:00 | AAPL | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 2800.0 |
| 2006-01-19 06:00:00 | AAPL | Stock | 2.8518 | 2.8518 | 2.8518 | 2.8518 | 11200.0 |
| 2006-01-19 07:00:00 | AAPL | Stock | 2.8482 | 2.875 | 2.8482 | 2.8604 | 483420.0 |
| 2006-01-19 07:30:00 | AAPL | Stock | 2.8575 | 2.8918 | 2.8575 | 2.8779 | 1287020.0 |
| 2006-01-19 08:00:00 | AAPL | Stock | 2.8757 | 2.9179 | 2.8527 | 2.9179 | 33426876.0 |
| 2006-01-19 08:30:00 | AAPL | Stock | 2.9186 | 2.95 | 2.9025 | 2.9214 | 30443896.0 |
| 2006-01-19 09:00:00 | AAPL | Stock | 2.9211 | 2.9214 | 2.9007 | 2.9014 | 20995912.0 |
| 2006-01-19 09:30:00 | AAPL | Stock | 2.9018 | 2.9096 | 2.8643 | 2.8964 | 302332100.0 |
| 2006-01-19 10:00:00 | AAPL | Stock | 2.8961 | 2.9164 | 2.8768 | 2.8825 | 186533928.0 |
| 2006-01-19 10:30:00 | AAPL | Stock | 2.8825 | 2.8929 | 2.84 | 2.8554 | 236862052.0 |
| 2006-01-19 11:00:00 | AAPL | Stock | 2.8554 | 2.8561 | 2.8121 | 2.8311 | 177418696.0 |
| 2006-01-19 11:30:00 | AAPL | Stock | 2.8307 | 2.8764 | 2.8143 | 2.8375 | 101671976.0 |
| 2006-01-19 12:00:00 | AAPL | Stock | 2.8375 | 2.8621 | 2.8304 | 2.8619 | 88065432.0 |
| 2006-01-19 12:30:00 | AAPL | Stock | 2.8618 | 2.8743 | 2.8614 | 2.8689 | 76085128.0 |
| 2006-01-19 13:00:00 | AAPL | Stock | 2.8686 | 2.8739 | 2.8654 | 2.8693 | 43706656.0 |
| 2006-01-19 13:30:00 | AAPL | Stock | 2.8693 | 2.8704 | 2.8561 | 2.8571 | 66107776.0 |
| 2006-01-19 14:00:00 | AAPL | Stock | 2.8571 | 2.8586 | 2.8454 | 2.8546 | 56781144.0 |
| 2006-01-19 14:30:00 | AAPL | Stock | 2.8546 | 2.8554 | 2.8371 | 2.8375 | 60698036.0 |
| 2006-01-19 15:00:00 | AAPL | Stock | 2.8371 | 2.8468 | 2.825 | 2.8439 | 75280772.0 |
| 2006-01-19 15:30:00 | AAPL | Stock | 2.8439 | 2.8464 | 2.8214 | 2.8239 | 115093776.0 |
| 2006-01-19 16:00:00 | AAPL | Stock | 2.8239 | 2.8318 | 2.8214 | 2.825 | 3830372.0 |
| 2006-01-19 16:30:00 | AAPL | Stock | 2.8257 | 2.8364 | 2.825 | 2.8321 | 1385804.0 |
| 2006-01-19 17:00:00 | AAPL | Stock | 2.8332 | 2.8429 | 2.8246 | 2.8375 | 993048.0 |
| 2006-01-19 17:30:00 | AAPL | Stock | 2.8393 | 2.8393 | 2.8282 | 2.835 | 307160.0 |
| 2006-01-19 18:00:00 | AAPL | Stock | 2.835 | 2.8375 | 2.8336 | 2.8339 | 270676.0 |
| 2006-01-19 08:00:00 | MSFT | Stock | 27.0 | 27.0 | 26.89 | 26.89 | 3800.0 |
| 2006-01-19 08:30:00 | MSFT | Stock | 26.89 | 26.89 | 26.88 | 26.89 | 204100.0 |
| 2006-01-19 09:00:00 | MSFT | Stock | 26.89 | 26.95 | 26.83 | 26.87 | 115823.0 |
| 2006-01-19 09:30:00 | MSFT | Stock | 26.87 | 26.98 | 26.85 | 26.95 | 5443505.0 |
| 2006-01-19 10:00:00 | MSFT | Stock | 26.94 | 27.01 | 26.93 | 26.98 | 3812360.0 |
| 2006-01-19 10:30:00 | MSFT | Stock | 26.98 | 27.05 | 26.96 | 26.97 | 4249074.0 |
| 2006-01-19 11:00:00 | MSFT | Stock | 26.97 | 27.01 | 26.92 | 26.98 | 3946701.0 |
| 2006-01-19 11:30:00 | MSFT | Stock | 26.98 | 27.04 | 26.94 | 27.03 | 2622957.0 |
| 2006-01-19 12:00:00 | MSFT | Stock | 27.03 | 27.07 | 26.98 | 27.01 | 2707183.0 |
| 2006-01-19 12:30:00 | MSFT | Stock | 27.02 | 27.11 | 26.96 | 27.09 | 6262920.0 |
| 2006-01-19 13:00:00 | MSFT | Stock | 27.1 | 27.16 | 27.08 | 27.11 | 4393557.0 |
| 2006-01-19 13:30:00 | MSFT | Stock | 27.11 | 27.19 | 27.09 | 27.18 | 2817746.0 |
| 2006-01-19 14:00:00 | MSFT | Stock | 27.18 | 27.24 | 27.1 | 27.11 | 4765332.0 |
| 2006-01-19 14:30:00 | MSFT | Stock | 27.11 | 27.2 | 27.02 | 27.04 | 4212531.0 |
| 2006-01-19 15:00:00 | MSFT | Stock | 27.05 | 27.07 | 26.99 | 27.02 | 3620917.0 |
| 2006-01-19 15:30:00 | MSFT | Stock | 27.01 | 27.05 | 26.97 | 27.01 | 6692099.0 |
| 2006-01-19 16:00:00 | MSFT | Stock | 27.0 | 27.02 | 27.0 | 27.02 | 533027.0 |
| 2006-01-19 16:30:00 | MSFT | Stock | 27.0 | 27.02 | 27.0 | 27.0 | 1895097.0 |
| 2006-01-19 17:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.95 | 26.95 | 6868.0 |
| 2006-01-19 17:30:00 | MSFT | Stock | 26.95 | 27.0 | 26.95 | 27.0 | 2163.0 |
| 2006-01-19 18:00:00 | MSFT | Stock | 26.98 | 27.0 | 26.95 | 26.95 | 4850.0 |
| 2006-01-19 08:00:00 | NVDA | Stock | 0.3651 | 0.3651 | 0.3629 | 0.3629 | 84000.0 |
| 2006-01-19 08:30:00 | NVDA | Stock | 0.363 | 0.363 | 0.3608 | 0.3608 | 237000.0 |
| 2006-01-19 09:00:00 | NVDA | Stock | 0.3608 | 0.3609 | 0.3583 | 0.3606 | 1130040.0 |
| 2006-01-19 09:30:00 | NVDA | Stock | 0.3606 | 0.3699 | 0.3599 | 0.3672 | 112591080.0 |
> showing 50 of 48,169 rows — these rows as CSV