PREVIEW / stock_30min / 2005-01-24
file: by_date/stock_30min/2005/2005-01-24.parquet size: 806 KB rows: 43,206 symbols: 1,914
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-01-24 08:00:00 | AAPL | Stock | 1.2727 | 1.2727 | 1.2641 | 1.2661 | 955920.0 |
| 2005-01-24 08:30:00 | AAPL | Stock | 1.2679 | 1.2741 | 1.2675 | 1.2723 | 2866752.0 |
| 2005-01-24 09:00:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2614 | 1.2684 | 3072552.0 |
| 2005-01-24 09:30:00 | AAPL | Stock | 1.2675 | 1.2777 | 1.2643 | 1.2702 | 129199000.0 |
| 2005-01-24 10:00:00 | AAPL | Stock | 1.27 | 1.2779 | 1.2679 | 1.2741 | 94244640.0 |
| 2005-01-24 10:30:00 | AAPL | Stock | 1.2741 | 1.2818 | 1.2689 | 1.2702 | 133170128.0 |
| 2005-01-24 11:00:00 | AAPL | Stock | 1.27 | 1.2757 | 1.2677 | 1.2725 | 60816056.0 |
| 2005-01-24 11:30:00 | AAPL | Stock | 1.2725 | 1.2754 | 1.2623 | 1.267 | 70207928.0 |
| 2005-01-24 12:00:00 | AAPL | Stock | 1.2673 | 1.2707 | 1.2632 | 1.2634 | 44134888.0 |
| 2005-01-24 12:30:00 | AAPL | Stock | 1.2634 | 1.267 | 1.2598 | 1.2661 | 37114168.0 |
| 2005-01-24 13:00:00 | AAPL | Stock | 1.2664 | 1.273 | 1.2664 | 1.2711 | 37298352.0 |
| 2005-01-24 13:30:00 | AAPL | Stock | 1.2711 | 1.2713 | 1.2661 | 1.2703 | 22759240.0 |
| 2005-01-24 14:00:00 | AAPL | Stock | 1.2702 | 1.2732 | 1.267 | 1.268 | 33947368.0 |
| 2005-01-24 14:30:00 | AAPL | Stock | 1.268 | 1.2741 | 1.2661 | 1.2682 | 45771488.0 |
| 2005-01-24 15:00:00 | AAPL | Stock | 1.2682 | 1.2732 | 1.2679 | 1.2718 | 41916728.0 |
| 2005-01-24 15:30:00 | AAPL | Stock | 1.2718 | 1.2736 | 1.2629 | 1.2659 | 75247480.0 |
| 2005-01-24 16:00:00 | AAPL | Stock | 1.2643 | 1.2673 | 1.2636 | 1.2671 | 4696272.0 |
| 2005-01-24 16:30:00 | AAPL | Stock | 1.2664 | 1.2675 | 1.2661 | 1.2661 | 364000.0 |
| 2005-01-24 17:00:00 | AAPL | Stock | 1.2671 | 1.2677 | 1.2636 | 1.2671 | 2529016.0 |
| 2005-01-24 17:30:00 | AAPL | Stock | 1.2671 | 1.2671 | 1.2671 | 1.2671 | 21000.0 |
| 2005-01-24 18:00:00 | AAPL | Stock | 1.2664 | 1.2673 | 1.2664 | 1.2671 | 22400.0 |
| 2005-01-24 08:00:00 | MSFT | Stock | 25.7 | 25.76 | 25.7 | 25.72 | 35609.0 |
| 2005-01-24 08:30:00 | MSFT | Stock | 25.76 | 25.8 | 25.74 | 25.8 | 63050.0 |
| 2005-01-24 09:00:00 | MSFT | Stock | 25.8 | 25.81 | 25.71 | 25.76 | 126984.0 |
| 2005-01-24 09:30:00 | MSFT | Stock | 25.76 | 25.8 | 25.66 | 25.74 | 7254714.0 |
| 2005-01-24 10:00:00 | MSFT | Stock | 25.74 | 25.9 | 25.72 | 25.84 | 6709756.0 |
| 2005-01-24 10:30:00 | MSFT | Stock | 25.84 | 25.99 | 25.82 | 25.928 | 5344267.0 |
| 2005-01-24 11:00:00 | MSFT | Stock | 25.93 | 25.96 | 25.83 | 25.89 | 5123511.0 |
| 2005-01-24 11:30:00 | MSFT | Stock | 25.89 | 25.98 | 25.87 | 25.89 | 3670412.0 |
| 2005-01-24 12:00:00 | MSFT | Stock | 25.9 | 25.98 | 25.89 | 25.912 | 3458671.0 |
| 2005-01-24 12:30:00 | MSFT | Stock | 25.92 | 25.95 | 25.85 | 25.9 | 3395927.0 |
| 2005-01-24 13:00:00 | MSFT | Stock | 25.91 | 26.0 | 25.91 | 25.96 | 3934708.0 |
| 2005-01-24 13:30:00 | MSFT | Stock | 25.95 | 25.97 | 25.85 | 25.87 | 3038402.0 |
| 2005-01-24 14:00:00 | MSFT | Stock | 25.88 | 25.94 | 25.86 | 25.862 | 2703806.0 |
| 2005-01-24 14:30:00 | MSFT | Stock | 25.87 | 25.92 | 25.76 | 25.8 | 5135133.0 |
| 2005-01-24 15:00:00 | MSFT | Stock | 25.8 | 25.87 | 25.75 | 25.84 | 6828635.0 |
| 2005-01-24 15:30:00 | MSFT | Stock | 25.84 | 25.87 | 25.64 | 25.64 | 10174096.0 |
| 2005-01-24 16:00:00 | MSFT | Stock | 25.67 | 25.72 | 25.64 | 25.71 | 689823.0 |
| 2005-01-24 16:30:00 | MSFT | Stock | 25.71 | 25.72 | 25.67 | 25.67 | 39036.0 |
| 2005-01-24 17:00:00 | MSFT | Stock | 25.97 | 25.97 | 25.65 | 25.71 | 57688.0 |
| 2005-01-24 17:30:00 | MSFT | Stock | 25.71 | 25.71 | 25.68 | 25.71 | 4650.0 |
| 2005-01-24 18:00:00 | MSFT | Stock | 25.71 | 25.72 | 25.71 | 25.72 | 2800.0 |
| 2005-01-24 08:00:00 | NVDA | Stock | 0.1782 | 0.1782 | 0.1782 | 0.1782 | 24000.0 |
| 2005-01-24 09:00:00 | NVDA | Stock | 0.1783 | 0.1783 | 0.1782 | 0.1782 | 163200.0 |
| 2005-01-24 09:30:00 | NVDA | Stock | 0.1777 | 0.1802 | 0.1752 | 0.1754 | 46448760.0 |
| 2005-01-24 10:00:00 | NVDA | Stock | 0.1753 | 0.1777 | 0.1752 | 0.1758 | 58912320.0 |
| 2005-01-24 10:30:00 | NVDA | Stock | 0.1758 | 0.1767 | 0.1737 | 0.1744 | 39360840.0 |
| 2005-01-24 11:00:00 | NVDA | Stock | 0.1744 | 0.1748 | 0.1719 | 0.1738 | 45974160.0 |
| 2005-01-24 11:30:00 | NVDA | Stock | 0.1738 | 0.1747 | 0.1724 | 0.1743 | 29876880.0 |
| 2005-01-24 12:00:00 | NVDA | Stock | 0.1743 | 0.1753 | 0.1736 | 0.1741 | 27641640.0 |
> showing 50 of 43,206 rows — these rows as CSV