PREVIEW / stock_30min / 2005-10-24
file: by_date/stock_30min/2005/2005-10-24.parquet size: 862 KB rows: 46,435 symbols: 2,102
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-10-24 08:00:00 | AAPL | Stock | 1.9875 | 1.9893 | 1.9668 | 1.9821 | 604324.0 |
| 2005-10-24 08:30:00 | AAPL | Stock | 1.9821 | 1.9839 | 1.9768 | 1.9825 | 362600.0 |
| 2005-10-24 09:00:00 | AAPL | Stock | 1.9825 | 1.9907 | 1.9743 | 1.9743 | 1602020.0 |
| 2005-10-24 09:30:00 | AAPL | Stock | 1.9732 | 1.9982 | 1.9675 | 1.9939 | 91180628.0 |
| 2005-10-24 10:00:00 | AAPL | Stock | 1.9939 | 2.0107 | 1.9914 | 1.9929 | 67275516.0 |
| 2005-10-24 10:30:00 | AAPL | Stock | 1.9929 | 2.0025 | 1.9789 | 1.9868 | 58369248.0 |
| 2005-10-24 11:00:00 | AAPL | Stock | 1.9875 | 2.0021 | 1.985 | 2.0007 | 32713744.0 |
| 2005-10-24 11:30:00 | AAPL | Stock | 2.0004 | 2.0207 | 2.0 | 2.01 | 67613336.0 |
| 2005-10-24 12:00:00 | AAPL | Stock | 2.0096 | 2.0214 | 2.0096 | 2.0207 | 49536396.0 |
| 2005-10-24 12:30:00 | AAPL | Stock | 2.0207 | 2.025 | 2.0164 | 2.0193 | 37977632.0 |
| 2005-10-24 13:00:00 | AAPL | Stock | 2.0196 | 2.0204 | 2.0104 | 2.0139 | 28895468.0 |
| 2005-10-24 13:30:00 | AAPL | Stock | 2.0136 | 2.0204 | 2.0136 | 2.0179 | 22075872.0 |
| 2005-10-24 14:00:00 | AAPL | Stock | 2.0182 | 2.0196 | 2.0143 | 2.0146 | 18992904.0 |
| 2005-10-24 14:30:00 | AAPL | Stock | 2.0143 | 2.0189 | 2.0064 | 2.0071 | 25722676.0 |
| 2005-10-24 15:00:00 | AAPL | Stock | 2.0071 | 2.0161 | 2.0064 | 2.0121 | 28192360.0 |
| 2005-10-24 15:30:00 | AAPL | Stock | 2.0125 | 2.0279 | 2.0114 | 2.0246 | 68435584.0 |
| 2005-10-24 16:00:00 | AAPL | Stock | 2.0282 | 2.0321 | 2.0196 | 2.025 | 3874080.0 |
| 2005-10-24 16:30:00 | AAPL | Stock | 2.025 | 2.025 | 2.0214 | 2.025 | 145180.0 |
| 2005-10-24 17:00:00 | AAPL | Stock | 2.0268 | 2.0268 | 2.0232 | 2.0232 | 86296.0 |
| 2005-10-24 17:30:00 | AAPL | Stock | 2.0232 | 2.025 | 2.0232 | 2.0236 | 107576.0 |
| 2005-10-24 18:00:00 | AAPL | Stock | 2.0236 | 2.0236 | 2.0232 | 2.0232 | 180656.0 |
| 2005-10-24 06:30:00 | MSFT | Stock | 24.85 | 24.85 | 24.85 | 24.85 | 700.0 |
| 2005-10-24 08:00:00 | MSFT | Stock | 24.82 | 24.86 | 24.81 | 24.85 | 44165.0 |
| 2005-10-24 08:30:00 | MSFT | Stock | 24.85 | 24.85 | 24.82 | 24.84 | 5799.0 |
| 2005-10-24 09:00:00 | MSFT | Stock | 24.84 | 24.89 | 24.82 | 24.89 | 164218.0 |
| 2005-10-24 09:30:00 | MSFT | Stock | 24.89 | 24.95 | 24.82 | 24.86 | 5068117.0 |
| 2005-10-24 10:00:00 | MSFT | Stock | 24.85 | 24.9 | 24.8 | 24.8 | 2550090.0 |
| 2005-10-24 10:30:00 | MSFT | Stock | 24.81 | 24.86 | 24.68 | 24.73 | 4331623.0 |
| 2005-10-24 11:00:00 | MSFT | Stock | 24.73 | 24.91 | 24.72 | 24.85 | 4061999.0 |
| 2005-10-24 11:30:00 | MSFT | Stock | 24.84 | 24.88 | 24.799 | 24.84 | 4204709.0 |
| 2005-10-24 12:00:00 | MSFT | Stock | 24.84 | 24.99 | 24.83 | 24.98 | 4298383.0 |
| 2005-10-24 12:30:00 | MSFT | Stock | 24.99 | 25.04 | 24.94 | 25.02 | 3528929.0 |
| 2005-10-24 13:00:00 | MSFT | Stock | 25.02 | 25.02 | 24.95 | 24.96 | 2220556.0 |
| 2005-10-24 13:30:00 | MSFT | Stock | 24.95 | 24.99 | 24.87 | 24.91 | 2281132.0 |
| 2005-10-24 14:00:00 | MSFT | Stock | 24.91 | 25.02 | 24.91 | 24.952 | 1847942.0 |
| 2005-10-24 14:30:00 | MSFT | Stock | 24.95 | 24.98 | 24.92 | 24.93 | 1696495.0 |
| 2005-10-24 15:00:00 | MSFT | Stock | 24.93 | 24.99 | 24.92 | 24.97 | 3209911.0 |
| 2005-10-24 15:30:00 | MSFT | Stock | 24.97 | 25.1 | 24.95 | 25.09 | 10994002.0 |
| 2005-10-24 16:00:00 | MSFT | Stock | 25.1 | 25.13 | 25.07 | 25.08 | 387188.0 |
| 2005-10-24 16:30:00 | MSFT | Stock | 25.08 | 25.08 | 25.05 | 25.08 | 9778.0 |
| 2005-10-24 17:00:00 | MSFT | Stock | 25.07 | 25.1 | 25.05 | 25.1 | 501900.0 |
| 2005-10-24 17:30:00 | MSFT | Stock | 25.05 | 25.08 | 25.05 | 25.08 | 3500.0 |
| 2005-10-24 18:00:00 | MSFT | Stock | 25.1 | 25.1 | 25.06 | 25.08 | 1086.0 |
| 2005-10-24 09:00:00 | NVDA | Stock | 0.2689 | 0.2695 | 0.2682 | 0.2693 | 168000.0 |
| 2005-10-24 09:30:00 | NVDA | Stock | 0.2685 | 0.2717 | 0.2667 | 0.268 | 41428320.0 |
| 2005-10-24 10:00:00 | NVDA | Stock | 0.2682 | 0.2695 | 0.2673 | 0.2674 | 28604160.0 |
| 2005-10-24 10:30:00 | NVDA | Stock | 0.2674 | 0.2682 | 0.2662 | 0.2662 | 26030760.0 |
| 2005-10-24 11:00:00 | NVDA | Stock | 0.2662 | 0.2692 | 0.2661 | 0.2669 | 11919360.0 |
| 2005-10-24 11:30:00 | NVDA | Stock | 0.2671 | 0.2687 | 0.267 | 0.2686 | 10484760.0 |
| 2005-10-24 12:00:00 | NVDA | Stock | 0.2686 | 0.2705 | 0.2681 | 0.2704 | 13448280.0 |
> showing 50 of 46,435 rows — these rows as CSV