PREVIEW / stock_30min / 2004-07-01
file: by_date/stock_30min/2004/2004-07-01.parquet size: 785 KB rows: 41,886 symbols: 1,798
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-01 08:00:00 | AAPL | Stock | 0.5732 | 0.5811 | 0.5732 | 0.5811 | 196000.0 |
| 2004-07-01 08:30:00 | AAPL | Stock | 0.5789 | 0.5793 | 0.5789 | 0.5793 | 50400.0 |
| 2004-07-01 09:00:00 | AAPL | Stock | 0.5811 | 0.5811 | 0.5739 | 0.5739 | 1218448.0 |
| 2004-07-01 09:30:00 | AAPL | Stock | 0.5729 | 0.5763 | 0.5696 | 0.5736 | 59032456.0 |
| 2004-07-01 10:00:00 | AAPL | Stock | 0.5736 | 0.5789 | 0.5736 | 0.5786 | 27452040.0 |
| 2004-07-01 10:30:00 | AAPL | Stock | 0.5786 | 0.58 | 0.5775 | 0.5775 | 21872088.0 |
| 2004-07-01 11:00:00 | AAPL | Stock | 0.5775 | 0.5775 | 0.5727 | 0.5761 | 36581720.0 |
| 2004-07-01 11:30:00 | AAPL | Stock | 0.5761 | 0.5761 | 0.5714 | 0.5727 | 17201296.0 |
| 2004-07-01 12:00:00 | AAPL | Stock | 0.573 | 0.5738 | 0.572 | 0.5734 | 19054504.0 |
| 2004-07-01 12:30:00 | AAPL | Stock | 0.5734 | 0.5763 | 0.5734 | 0.5755 | 11298672.0 |
| 2004-07-01 13:00:00 | AAPL | Stock | 0.5755 | 0.5755 | 0.5732 | 0.5741 | 12091856.0 |
| 2004-07-01 13:30:00 | AAPL | Stock | 0.5738 | 0.5754 | 0.573 | 0.5739 | 10219440.0 |
| 2004-07-01 14:00:00 | AAPL | Stock | 0.5741 | 0.575 | 0.5721 | 0.5743 | 15305528.0 |
| 2004-07-01 14:30:00 | AAPL | Stock | 0.5745 | 0.5773 | 0.5739 | 0.5768 | 21219352.0 |
| 2004-07-01 15:00:00 | AAPL | Stock | 0.5768 | 0.5798 | 0.5755 | 0.5777 | 36221024.0 |
| 2004-07-01 15:30:00 | AAPL | Stock | 0.5775 | 0.5777 | 0.5754 | 0.5766 | 39277616.0 |
| 2004-07-01 16:00:00 | AAPL | Stock | 0.5768 | 0.5779 | 0.575 | 0.5768 | 3380328.0 |
| 2004-07-01 16:30:00 | AAPL | Stock | 0.5768 | 0.5768 | 0.5766 | 0.5766 | 448000.0 |
| 2004-07-01 17:00:00 | AAPL | Stock | 0.5768 | 0.5768 | 0.5625 | 0.5705 | 536760.0 |
| 2004-07-01 17:30:00 | AAPL | Stock | 0.5696 | 0.5768 | 0.5446 | 0.5446 | 3322480.0 |
| 2004-07-01 18:00:00 | AAPL | Stock | 0.5448 | 0.5448 | 0.5411 | 0.5446 | 3057600.0 |
| 2004-07-01 08:00:00 | MSFT | Stock | 28.69 | 28.73 | 28.56 | 28.7 | 92308.0 |
| 2004-07-01 08:30:00 | MSFT | Stock | 28.68 | 28.78 | 28.56 | 28.74 | 105465.0 |
| 2004-07-01 09:00:00 | MSFT | Stock | 28.7 | 28.82 | 28.56 | 28.7 | 642975.0 |
| 2004-07-01 09:30:00 | MSFT | Stock | 28.68 | 28.8 | 28.55 | 28.7 | 9571625.0 |
| 2004-07-01 10:00:00 | MSFT | Stock | 28.71 | 28.8 | 28.659 | 28.68 | 6770512.0 |
| 2004-07-01 10:30:00 | MSFT | Stock | 28.68 | 28.73 | 28.51 | 28.54 | 4738357.0 |
| 2004-07-01 11:00:00 | MSFT | Stock | 28.54 | 28.55 | 28.4 | 28.48 | 7356005.0 |
| 2004-07-01 11:30:00 | MSFT | Stock | 28.49 | 28.52 | 28.42 | 28.43 | 5982457.0 |
| 2004-07-01 12:00:00 | MSFT | Stock | 28.43 | 28.5 | 28.39 | 28.47 | 4312692.0 |
| 2004-07-01 12:30:00 | MSFT | Stock | 28.47 | 28.51 | 28.43 | 28.47 | 2396903.0 |
| 2004-07-01 13:00:00 | MSFT | Stock | 28.47 | 28.48 | 28.41 | 28.449 | 3385438.0 |
| 2004-07-01 13:30:00 | MSFT | Stock | 28.44 | 28.47 | 28.26 | 28.32 | 4298290.0 |
| 2004-07-01 14:00:00 | MSFT | Stock | 28.31 | 28.45 | 28.3 | 28.43 | 4205418.0 |
| 2004-07-01 14:30:00 | MSFT | Stock | 28.43 | 28.53 | 28.39 | 28.49 | 5725614.0 |
| 2004-07-01 15:00:00 | MSFT | Stock | 28.49 | 28.6 | 28.45 | 28.51 | 5457554.0 |
| 2004-07-01 15:30:00 | MSFT | Stock | 28.51 | 28.67 | 28.5 | 28.62 | 9249120.0 |
| 2004-07-01 16:00:00 | MSFT | Stock | 28.63 | 28.64 | 28.52 | 28.54 | 531367.0 |
| 2004-07-01 16:30:00 | MSFT | Stock | 28.54 | 28.63 | 28.54 | 28.6 | 217678.0 |
| 2004-07-01 17:00:00 | MSFT | Stock | 28.63 | 28.63 | 28.55 | 28.55 | 29888.0 |
| 2004-07-01 17:30:00 | MSFT | Stock | 28.57 | 28.74 | 28.55 | 28.6 | 528035.0 |
| 2004-07-01 18:00:00 | MSFT | Stock | 28.6 | 28.6 | 28.55 | 28.6 | 4972.0 |
| 2004-07-01 08:30:00 | NVDA | Stock | 0.1715 | 0.1715 | 0.1715 | 0.1715 | 12000.0 |
| 2004-07-01 09:00:00 | NVDA | Stock | 0.1708 | 0.1721 | 0.1708 | 0.172 | 852000.0 |
| 2004-07-01 09:30:00 | NVDA | Stock | 0.1725 | 0.1727 | 0.1667 | 0.167 | 70116240.0 |
| 2004-07-01 10:00:00 | NVDA | Stock | 0.1671 | 0.1671 | 0.1645 | 0.1647 | 61536000.0 |
| 2004-07-01 10:30:00 | NVDA | Stock | 0.1649 | 0.1659 | 0.1646 | 0.1647 | 40508640.0 |
| 2004-07-01 11:00:00 | NVDA | Stock | 0.1647 | 0.1652 | 0.163 | 0.1642 | 59912040.0 |
| 2004-07-01 11:30:00 | NVDA | Stock | 0.1642 | 0.165 | 0.1638 | 0.1643 | 21854400.0 |
| 2004-07-01 12:00:00 | NVDA | Stock | 0.1643 | 0.1646 | 0.1642 | 0.1646 | 11730840.0 |
> showing 50 of 41,886 rows — these rows as CSV