PREVIEW / stock_30min / 2006-03-21
file: by_date/stock_30min/2006/2006-03-21.parquet size: 911 KB rows: 48,232 symbols: 2,207
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-21 07:30:00 | AAPL | Stock | 2.2821 | 2.2821 | 2.2821 | 2.2821 | 5600.0 |
| 2006-03-21 08:00:00 | AAPL | Stock | 2.2821 | 2.2875 | 2.2629 | 2.2775 | 465052.0 |
| 2006-03-21 08:30:00 | AAPL | Stock | 2.2775 | 2.2775 | 2.2693 | 2.2764 | 1074108.0 |
| 2006-03-21 09:00:00 | AAPL | Stock | 2.2768 | 2.2982 | 2.275 | 2.295 | 3578960.0 |
| 2006-03-21 09:30:00 | AAPL | Stock | 2.2961 | 2.2979 | 2.2564 | 2.2668 | 124213516.0 |
| 2006-03-21 10:00:00 | AAPL | Stock | 2.2668 | 2.2696 | 2.2425 | 2.2529 | 104244896.0 |
| 2006-03-21 10:30:00 | AAPL | Stock | 2.2521 | 2.2632 | 2.2486 | 2.2532 | 75937176.0 |
| 2006-03-21 11:00:00 | AAPL | Stock | 2.2532 | 2.2786 | 2.2518 | 2.2725 | 85862308.0 |
| 2006-03-21 11:30:00 | AAPL | Stock | 2.2729 | 2.2918 | 2.2655 | 2.2854 | 107038708.0 |
| 2006-03-21 12:00:00 | AAPL | Stock | 2.2854 | 2.2957 | 2.2757 | 2.2925 | 89174988.0 |
| 2006-03-21 12:30:00 | AAPL | Stock | 2.2929 | 2.2943 | 2.2689 | 2.2711 | 77042504.0 |
| 2006-03-21 13:00:00 | AAPL | Stock | 2.2711 | 2.2804 | 2.2611 | 2.2625 | 48466908.0 |
| 2006-03-21 13:30:00 | AAPL | Stock | 2.2629 | 2.2718 | 2.2529 | 2.255 | 52333344.0 |
| 2006-03-21 14:00:00 | AAPL | Stock | 2.255 | 2.2586 | 2.2357 | 2.2457 | 102176116.0 |
| 2006-03-21 14:30:00 | AAPL | Stock | 2.2461 | 2.2489 | 2.2218 | 2.2246 | 125374256.0 |
| 2006-03-21 15:00:00 | AAPL | Stock | 2.2243 | 2.2275 | 2.1925 | 2.1982 | 180165356.0 |
| 2006-03-21 15:30:00 | AAPL | Stock | 2.1982 | 2.2143 | 2.1936 | 2.2071 | 153278524.0 |
| 2006-03-21 16:00:00 | AAPL | Stock | 2.2071 | 2.2121 | 2.2036 | 2.2082 | 5077800.0 |
| 2006-03-21 16:30:00 | AAPL | Stock | 2.2089 | 2.2143 | 2.2089 | 2.2129 | 780640.0 |
| 2006-03-21 17:00:00 | AAPL | Stock | 2.2125 | 2.2154 | 2.2104 | 2.2129 | 420336.0 |
| 2006-03-21 17:30:00 | AAPL | Stock | 2.2129 | 2.2189 | 2.2079 | 2.2189 | 1293936.0 |
| 2006-03-21 18:00:00 | AAPL | Stock | 2.2179 | 2.2196 | 2.2154 | 2.2193 | 869904.0 |
| 2006-03-21 07:00:00 | MSFT | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 500.0 |
| 2006-03-21 08:00:00 | MSFT | Stock | 27.83 | 27.84 | 27.82 | 27.84 | 2700.0 |
| 2006-03-21 08:30:00 | MSFT | Stock | 27.82 | 27.85 | 27.82 | 27.83 | 26609.0 |
| 2006-03-21 09:00:00 | MSFT | Stock | 27.86 | 27.99 | 27.85 | 27.95 | 230106.0 |
| 2006-03-21 09:30:00 | MSFT | Stock | 27.95 | 27.99 | 27.83 | 27.98 | 6466904.0 |
| 2006-03-21 10:00:00 | MSFT | Stock | 27.99 | 27.99 | 27.88 | 27.93 | 4305128.0 |
| 2006-03-21 10:30:00 | MSFT | Stock | 27.93 | 28.001 | 27.93 | 27.972 | 4432245.0 |
| 2006-03-21 11:00:00 | MSFT | Stock | 27.97 | 28.05 | 27.96 | 28.02 | 8422703.0 |
| 2006-03-21 11:30:00 | MSFT | Stock | 28.02 | 28.22 | 28.01 | 28.1 | 10035043.0 |
| 2006-03-21 12:00:00 | MSFT | Stock | 28.09 | 28.11 | 28.05 | 28.07 | 2436077.0 |
| 2006-03-21 12:30:00 | MSFT | Stock | 28.08 | 28.12 | 28.06 | 28.07 | 2538448.0 |
| 2006-03-21 13:00:00 | MSFT | Stock | 28.069 | 28.09 | 28.0 | 28.06 | 2878144.0 |
| 2006-03-21 13:30:00 | MSFT | Stock | 28.06 | 28.09 | 27.94 | 27.99 | 3779960.0 |
| 2006-03-21 14:00:00 | MSFT | Stock | 27.99 | 28.01 | 27.88 | 27.91 | 4834569.0 |
| 2006-03-21 14:30:00 | MSFT | Stock | 27.92 | 27.98 | 27.749 | 27.78 | 4795519.0 |
| 2006-03-21 15:00:00 | MSFT | Stock | 27.77 | 27.8 | 27.7 | 27.74 | 5319377.0 |
| 2006-03-21 15:30:00 | MSFT | Stock | 27.74 | 27.81 | 27.68 | 27.75 | 7380055.0 |
| 2006-03-21 16:00:00 | MSFT | Stock | 27.74 | 27.95 | 27.72 | 27.75 | 692397.0 |
| 2006-03-21 16:30:00 | MSFT | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 200.0 |
| 2006-03-21 17:00:00 | MSFT | Stock | 27.74 | 27.78 | 27.74 | 27.78 | 789.0 |
| 2006-03-21 17:30:00 | MSFT | Stock | 27.78 | 27.78 | 26.79 | 27.0 | 1587531.0 |
| 2006-03-21 18:00:00 | MSFT | Stock | 27.0 | 27.18 | 26.96 | 27.05 | 1099686.0 |
| 2006-03-21 07:00:00 | NVDA | Stock | 0.4146 | 0.4146 | 0.4146 | 0.4146 | 72000.0 |
| 2006-03-21 07:30:00 | NVDA | Stock | 0.4125 | 0.4125 | 0.4115 | 0.4115 | 252000.0 |
| 2006-03-21 08:00:00 | NVDA | Stock | 0.4112 | 0.4126 | 0.4104 | 0.4121 | 2508000.0 |
| 2006-03-21 08:30:00 | NVDA | Stock | 0.4129 | 0.4148 | 0.4129 | 0.4137 | 2527200.0 |
| 2006-03-21 09:00:00 | NVDA | Stock | 0.4137 | 0.4144 | 0.412 | 0.412 | 2027040.0 |
| 2006-03-21 09:30:00 | NVDA | Stock | 0.4127 | 0.4246 | 0.4122 | 0.4238 | 227059200.0 |
> showing 50 of 48,232 rows — these rows as CSV