PREVIEW / stock_30min / 2001-03-23
file: by_date/stock_30min/2001/2001-03-23.parquet size: 522 KB rows: 26,988 symbols: 1,283
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-23 08:00:00 | AAPL | Stock | 0.3951 | 0.4018 | 0.3862 | 0.3973 | 2195200.0 |
| 2001-03-23 08:30:00 | AAPL | Stock | 0.4001 | 0.4012 | 0.3962 | 0.3962 | 1618400.0 |
| 2001-03-23 09:00:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.3929 | 0.394 | 4306400.0 |
| 2001-03-23 09:30:00 | AAPL | Stock | 0.394 | 0.4063 | 0.3929 | 0.3996 | 145700800.0 |
| 2001-03-23 10:00:00 | AAPL | Stock | 0.3984 | 0.4107 | 0.3973 | 0.404 | 96829600.0 |
| 2001-03-23 10:30:00 | AAPL | Stock | 0.404 | 0.4085 | 0.4029 | 0.4085 | 53933600.0 |
| 2001-03-23 11:00:00 | AAPL | Stock | 0.4085 | 0.4118 | 0.4029 | 0.4051 | 74732000.0 |
| 2001-03-23 11:30:00 | AAPL | Stock | 0.404 | 0.4074 | 0.4029 | 0.404 | 32922400.0 |
| 2001-03-23 12:00:00 | AAPL | Stock | 0.404 | 0.4051 | 0.3962 | 0.3973 | 45740800.0 |
| 2001-03-23 12:30:00 | AAPL | Stock | 0.3973 | 0.4018 | 0.394 | 0.3996 | 41451200.0 |
| 2001-03-23 13:00:00 | AAPL | Stock | 0.3984 | 0.404 | 0.3984 | 0.4007 | 28722400.0 |
| 2001-03-23 13:30:00 | AAPL | Stock | 0.4007 | 0.4063 | 0.3973 | 0.3996 | 16380000.0 |
| 2001-03-23 14:00:00 | AAPL | Stock | 0.4007 | 0.4029 | 0.3996 | 0.4029 | 19902400.0 |
| 2001-03-23 14:30:00 | AAPL | Stock | 0.4018 | 0.4196 | 0.4007 | 0.4141 | 100990400.0 |
| 2001-03-23 15:00:00 | AAPL | Stock | 0.4152 | 0.4208 | 0.4096 | 0.4196 | 120534400.0 |
| 2001-03-23 15:30:00 | AAPL | Stock | 0.4185 | 0.4196 | 0.4074 | 0.4096 | 93206400.0 |
| 2001-03-23 16:00:00 | AAPL | Stock | 0.4096 | 0.4107 | 0.4063 | 0.4074 | 18048800.0 |
| 2001-03-23 16:30:00 | AAPL | Stock | 0.4074 | 0.4107 | 0.4074 | 0.4085 | 179200.0 |
| 2001-03-23 17:00:00 | AAPL | Stock | 0.4096 | 0.4096 | 0.4096 | 0.4096 | 67200.0 |
| 2001-03-23 17:30:00 | AAPL | Stock | 0.4096 | 0.4096 | 0.4096 | 0.4096 | 11200.0 |
| 2001-03-23 18:00:00 | AAPL | Stock | 0.4074 | 0.4074 | 0.4074 | 0.4074 | 56000.0 |
| 2001-03-23 08:00:00 | MSFT | Stock | 27.2812 | 27.3125 | 26.9531 | 27.1875 | 240600.0 |
| 2001-03-23 08:30:00 | MSFT | Stock | 27.25 | 27.4375 | 27.1875 | 27.375 | 97400.0 |
| 2001-03-23 09:00:00 | MSFT | Stock | 27.4375 | 27.5625 | 26.9688 | 27.4688 | 964400.0 |
| 2001-03-23 09:30:00 | MSFT | Stock | 27.4688 | 27.75 | 27.1875 | 27.3125 | 15916400.0 |
| 2001-03-23 10:00:00 | MSFT | Stock | 27.2969 | 27.9375 | 27.2812 | 27.6562 | 9171200.0 |
| 2001-03-23 10:30:00 | MSFT | Stock | 27.6875 | 27.9062 | 27.5938 | 27.9062 | 7675800.0 |
| 2001-03-23 11:00:00 | MSFT | Stock | 27.9062 | 28.1562 | 27.8125 | 27.9688 | 6749400.0 |
| 2001-03-23 11:30:00 | MSFT | Stock | 27.9375 | 28.0625 | 27.6562 | 27.8125 | 5682000.0 |
| 2001-03-23 12:00:00 | MSFT | Stock | 27.7812 | 27.8125 | 27.5 | 27.5938 | 5642200.0 |
| 2001-03-23 12:30:00 | MSFT | Stock | 27.5625 | 27.625 | 27.25 | 27.5312 | 5115400.0 |
| 2001-03-23 13:00:00 | MSFT | Stock | 27.5 | 27.8438 | 27.5 | 27.7812 | 3647000.0 |
| 2001-03-23 13:30:00 | MSFT | Stock | 27.7812 | 27.9375 | 27.5312 | 27.6562 | 2976600.0 |
| 2001-03-23 14:00:00 | MSFT | Stock | 27.6562 | 28.0312 | 27.6562 | 28.0 | 3687000.0 |
| 2001-03-23 14:30:00 | MSFT | Stock | 28.0 | 28.375 | 27.9531 | 28.25 | 8220200.0 |
| 2001-03-23 15:00:00 | MSFT | Stock | 28.25 | 28.5 | 28.0625 | 28.4375 | 6514800.0 |
| 2001-03-23 15:30:00 | MSFT | Stock | 28.4375 | 28.5 | 28.1875 | 28.2812 | 11854200.0 |
| 2001-03-23 16:00:00 | MSFT | Stock | 28.2812 | 28.5 | 27.8438 | 28.2812 | 2410000.0 |
| 2001-03-23 16:30:00 | MSFT | Stock | 28.3125 | 28.3125 | 28.2812 | 28.2812 | 34400.0 |
| 2001-03-23 17:00:00 | MSFT | Stock | 28.2969 | 28.3125 | 28.25 | 28.2812 | 8000.0 |
| 2001-03-23 17:30:00 | MSFT | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 1000.0 |
| 2001-03-23 18:00:00 | MSFT | Stock | 28.25 | 28.2812 | 28.25 | 28.25 | 1000.0 |
| 2001-03-23 08:00:00 | NVDA | Stock | 0.2848 | 0.2848 | 0.2844 | 0.2844 | 72000.0 |
| 2001-03-23 08:30:00 | NVDA | Stock | 0.2844 | 0.2911 | 0.2836 | 0.2875 | 1464000.0 |
| 2001-03-23 09:00:00 | NVDA | Stock | 0.2875 | 0.2885 | 0.2846 | 0.2872 | 10104000.0 |
| 2001-03-23 09:30:00 | NVDA | Stock | 0.287 | 0.2922 | 0.2813 | 0.2828 | 260088000.0 |
| 2001-03-23 10:00:00 | NVDA | Stock | 0.2826 | 0.2867 | 0.2792 | 0.2831 | 140736000.0 |
| 2001-03-23 10:30:00 | NVDA | Stock | 0.2831 | 0.2853 | 0.2802 | 0.2826 | 62808000.0 |
| 2001-03-23 11:00:00 | NVDA | Stock | 0.2826 | 0.2862 | 0.2786 | 0.2799 | 82848000.0 |
| 2001-03-23 11:30:00 | NVDA | Stock | 0.2794 | 0.2802 | 0.2714 | 0.2725 | 97416000.0 |
> showing 50 of 26,988 rows — these rows as CSV