PREVIEW / stock_30min / 2005-09-29
file: by_date/stock_30min/2005/2005-09-29.parquet size: 848 KB rows: 45,404 symbols: 2,079
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-29 07:00:00 | AAPL | Stock | 1.8243 | 1.8243 | 1.8243 | 1.8243 | 5600.0 |
| 2005-09-29 07:30:00 | AAPL | Stock | 1.8243 | 1.8243 | 1.8243 | 1.8243 | 2800.0 |
| 2005-09-29 08:00:00 | AAPL | Stock | 1.8268 | 1.8314 | 1.8214 | 1.8304 | 917728.0 |
| 2005-09-29 08:30:00 | AAPL | Stock | 1.8304 | 1.8314 | 1.8286 | 1.8293 | 703864.0 |
| 2005-09-29 09:00:00 | AAPL | Stock | 1.8289 | 1.8296 | 1.8268 | 1.8296 | 709660.0 |
| 2005-09-29 09:30:00 | AAPL | Stock | 1.8296 | 1.8414 | 1.8146 | 1.8364 | 108250100.0 |
| 2005-09-29 10:00:00 | AAPL | Stock | 1.8365 | 1.8657 | 1.8361 | 1.8586 | 92693300.0 |
| 2005-09-29 10:30:00 | AAPL | Stock | 1.8586 | 1.865 | 1.8443 | 1.8464 | 63034692.0 |
| 2005-09-29 11:00:00 | AAPL | Stock | 1.8464 | 1.8554 | 1.8461 | 1.8532 | 43569736.0 |
| 2005-09-29 11:30:00 | AAPL | Stock | 1.8536 | 1.8646 | 1.8493 | 1.8575 | 35967876.0 |
| 2005-09-29 12:00:00 | AAPL | Stock | 1.8575 | 1.8618 | 1.8539 | 1.8571 | 20819176.0 |
| 2005-09-29 12:30:00 | AAPL | Stock | 1.8571 | 1.8582 | 1.8532 | 1.8557 | 15172164.0 |
| 2005-09-29 13:00:00 | AAPL | Stock | 1.8557 | 1.8643 | 1.8518 | 1.8607 | 35361172.0 |
| 2005-09-29 13:30:00 | AAPL | Stock | 1.8607 | 1.8643 | 1.8546 | 1.8586 | 24794980.0 |
| 2005-09-29 14:00:00 | AAPL | Stock | 1.8586 | 1.8643 | 1.8579 | 1.8614 | 24938368.0 |
| 2005-09-29 14:30:00 | AAPL | Stock | 1.8614 | 1.8629 | 1.8546 | 1.8582 | 27336652.0 |
| 2005-09-29 15:00:00 | AAPL | Stock | 1.8582 | 1.8775 | 1.8575 | 1.8772 | 49646184.0 |
| 2005-09-29 15:30:00 | AAPL | Stock | 1.8771 | 1.8782 | 1.8614 | 1.8682 | 80990224.0 |
| 2005-09-29 16:00:00 | AAPL | Stock | 1.8693 | 1.8707 | 1.8625 | 1.8679 | 1526448.0 |
| 2005-09-29 16:30:00 | AAPL | Stock | 1.8639 | 1.8693 | 1.8636 | 1.8679 | 390908.0 |
| 2005-09-29 17:00:00 | AAPL | Stock | 1.8664 | 1.8679 | 1.8607 | 1.8679 | 403116.0 |
| 2005-09-29 17:30:00 | AAPL | Stock | 1.8679 | 1.8693 | 1.8679 | 1.8693 | 562800.0 |
| 2005-09-29 18:00:00 | AAPL | Stock | 1.8643 | 1.8689 | 1.8636 | 1.8636 | 37100.0 |
| 2005-09-29 07:30:00 | MSFT | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 235.0 |
| 2005-09-29 08:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.67 | 25.69 | 9555.0 |
| 2005-09-29 08:30:00 | MSFT | Stock | 25.68 | 25.68 | 25.67 | 25.67 | 10300.0 |
| 2005-09-29 09:00:00 | MSFT | Stock | 25.65 | 25.67 | 25.59 | 25.59 | 86958.0 |
| 2005-09-29 09:30:00 | MSFT | Stock | 25.61 | 25.78 | 25.54 | 25.54 | 6161940.0 |
| 2005-09-29 10:00:00 | MSFT | Stock | 25.53 | 25.71 | 25.515 | 25.691 | 4918162.0 |
| 2005-09-29 10:30:00 | MSFT | Stock | 25.7 | 25.7 | 25.52 | 25.54 | 3990835.0 |
| 2005-09-29 11:00:00 | MSFT | Stock | 25.54 | 25.6 | 25.5 | 25.558 | 3751864.0 |
| 2005-09-29 11:30:00 | MSFT | Stock | 25.55 | 25.74 | 25.51 | 25.7 | 5384122.0 |
| 2005-09-29 12:00:00 | MSFT | Stock | 25.7 | 25.74 | 25.66 | 25.67 | 2913035.0 |
| 2005-09-29 12:30:00 | MSFT | Stock | 25.66 | 25.67 | 25.55 | 25.58 | 2232623.0 |
| 2005-09-29 13:00:00 | MSFT | Stock | 25.58 | 25.81 | 25.57 | 25.78 | 4187494.0 |
| 2005-09-29 13:30:00 | MSFT | Stock | 25.78 | 25.82 | 25.7 | 25.71 | 3558884.0 |
| 2005-09-29 14:00:00 | MSFT | Stock | 25.71 | 25.9 | 25.7 | 25.84 | 5051928.0 |
| 2005-09-29 14:30:00 | MSFT | Stock | 25.85 | 25.93 | 25.8 | 25.87 | 3961475.0 |
| 2005-09-29 15:00:00 | MSFT | Stock | 25.87 | 26.0 | 25.85 | 25.97 | 8286719.0 |
| 2005-09-29 15:30:00 | MSFT | Stock | 25.97 | 25.98 | 25.667 | 25.95 | 9192133.0 |
| 2005-09-29 16:00:00 | MSFT | Stock | 25.94 | 26.0 | 25.92 | 25.95 | 428536.0 |
| 2005-09-29 16:30:00 | MSFT | Stock | 25.94 | 25.94 | 25.91 | 25.91 | 91952.0 |
| 2005-09-29 17:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.92 | 25.92 | 12200.0 |
| 2005-09-29 17:30:00 | MSFT | Stock | 25.92 | 25.94 | 25.92 | 25.94 | 203100.0 |
| 2005-09-29 18:00:00 | MSFT | Stock | 25.92 | 25.95 | 25.92 | 25.92 | 1800.0 |
| 2005-09-29 09:00:00 | NVDA | Stock | 0.2777 | 0.2782 | 0.2772 | 0.2776 | 528000.0 |
| 2005-09-29 09:30:00 | NVDA | Stock | 0.2775 | 0.2783 | 0.2752 | 0.2768 | 65672640.0 |
| 2005-09-29 10:00:00 | NVDA | Stock | 0.2768 | 0.2812 | 0.2767 | 0.2802 | 68215800.0 |
| 2005-09-29 10:30:00 | NVDA | Stock | 0.2803 | 0.2803 | 0.2762 | 0.2767 | 58383480.0 |
| 2005-09-29 11:00:00 | NVDA | Stock | 0.2767 | 0.2786 | 0.2762 | 0.2777 | 21032280.0 |
> showing 50 of 45,404 rows — these rows as CSV