PREVIEW / stock_30min / 2009-01-30
file: by_date/stock_30min/2009/2009-01-30.parquet size: 1.2 MB rows: 67,565 symbols: 3,293
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-30 07:00:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.3039 | 3.3039 | 2800.0 |
| 2009-01-30 08:00:00 | AAPL | Stock | 3.2946 | 3.2996 | 3.2786 | 3.2996 | 771820.0 |
| 2009-01-30 08:30:00 | AAPL | Stock | 3.3 | 3.3475 | 3.3 | 3.3057 | 2551864.0 |
| 2009-01-30 09:00:00 | AAPL | Stock | 3.3057 | 3.3143 | 3.2946 | 3.3061 | 868812.0 |
| 2009-01-30 09:30:00 | AAPL | Stock | 3.3061 | 3.3436 | 3.2764 | 3.2771 | 85647912.0 |
| 2009-01-30 10:00:00 | AAPL | Stock | 3.2768 | 3.2875 | 3.2589 | 3.2611 | 61832456.0 |
| 2009-01-30 10:30:00 | AAPL | Stock | 3.2607 | 3.275 | 3.2475 | 3.2632 | 46653740.0 |
| 2009-01-30 11:00:00 | AAPL | Stock | 3.2629 | 3.2764 | 3.2468 | 3.2529 | 35395780.0 |
| 2009-01-30 11:30:00 | AAPL | Stock | 3.2529 | 3.2604 | 3.2436 | 3.2539 | 24966200.0 |
| 2009-01-30 12:00:00 | AAPL | Stock | 3.2543 | 3.2575 | 3.2357 | 3.2518 | 31603936.0 |
| 2009-01-30 12:30:00 | AAPL | Stock | 3.2518 | 3.2529 | 3.2393 | 3.25 | 19319888.0 |
| 2009-01-30 13:00:00 | AAPL | Stock | 3.2496 | 3.2736 | 3.2468 | 3.2539 | 36871016.0 |
| 2009-01-30 13:30:00 | AAPL | Stock | 3.2539 | 3.2589 | 3.2368 | 3.2564 | 34091176.0 |
| 2009-01-30 14:00:00 | AAPL | Stock | 3.2564 | 3.2704 | 3.2511 | 3.2621 | 27558776.0 |
| 2009-01-30 14:30:00 | AAPL | Stock | 3.2625 | 3.2707 | 3.2439 | 3.2446 | 32228952.0 |
| 2009-01-30 15:00:00 | AAPL | Stock | 3.2443 | 3.25 | 3.2318 | 3.2336 | 49697088.0 |
| 2009-01-30 15:30:00 | AAPL | Stock | 3.2339 | 3.2354 | 3.2146 | 3.2193 | 89012644.0 |
| 2009-01-30 16:00:00 | AAPL | Stock | 3.2196 | 3.265 | 3.2179 | 3.2189 | 25386396.0 |
| 2009-01-30 16:30:00 | AAPL | Stock | 3.2189 | 3.2445 | 3.2189 | 3.2445 | 6094256.0 |
| 2009-01-30 17:00:00 | AAPL | Stock | 3.2207 | 3.2232 | 3.2143 | 3.2143 | 121912.0 |
| 2009-01-30 17:30:00 | AAPL | Stock | 3.22 | 3.22 | 3.2175 | 3.2175 | 91084.0 |
| 2009-01-30 18:00:00 | AAPL | Stock | 3.2175 | 3.225 | 3.2175 | 3.2214 | 124348.0 |
| 2009-01-30 18:30:00 | AAPL | Stock | 3.2218 | 3.2232 | 3.2196 | 3.2196 | 61208.0 |
| 2009-01-30 19:00:00 | AAPL | Stock | 3.2207 | 3.225 | 3.2189 | 3.225 | 61796.0 |
| 2009-01-30 19:30:00 | AAPL | Stock | 3.225 | 3.2268 | 3.2221 | 3.2261 | 133336.0 |
| 2009-01-30 05:30:00 | MSFT | Stock | 17.59 | 17.59 | 17.59 | 17.59 | 200.0 |
| 2009-01-30 07:00:00 | MSFT | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 100.0 |
| 2009-01-30 08:00:00 | MSFT | Stock | 17.65 | 17.75 | 17.59 | 17.65 | 1780.0 |
| 2009-01-30 08:30:00 | MSFT | Stock | 17.64 | 17.8 | 17.63 | 17.68 | 21798.0 |
| 2009-01-30 09:00:00 | MSFT | Stock | 17.72 | 17.79 | 17.7 | 17.75 | 29408.0 |
| 2009-01-30 09:30:00 | MSFT | Stock | 17.75 | 17.79 | 17.5 | 17.5 | 3862991.0 |
| 2009-01-30 10:00:00 | MSFT | Stock | 17.5 | 17.58 | 17.3 | 17.31 | 5136766.0 |
| 2009-01-30 10:30:00 | MSFT | Stock | 17.318 | 17.39 | 17.29 | 17.36 | 3037366.0 |
| 2009-01-30 11:00:00 | MSFT | Stock | 17.368 | 17.4 | 17.16 | 17.21 | 3522916.0 |
| 2009-01-30 11:30:00 | MSFT | Stock | 17.21 | 17.25 | 17.18 | 17.23 | 2733731.0 |
| 2009-01-30 12:00:00 | MSFT | Stock | 17.23 | 17.28 | 17.188 | 17.26 | 4189522.0 |
| 2009-01-30 12:30:00 | MSFT | Stock | 17.26 | 17.34 | 17.22 | 17.31 | 1903405.0 |
| 2009-01-30 13:00:00 | MSFT | Stock | 17.31 | 17.39 | 17.21 | 17.24 | 3354846.0 |
| 2009-01-30 13:30:00 | MSFT | Stock | 17.24 | 17.3 | 17.16 | 17.21 | 3918893.0 |
| 2009-01-30 14:00:00 | MSFT | Stock | 17.2 | 17.32 | 17.19 | 17.24 | 3549363.0 |
| 2009-01-30 14:30:00 | MSFT | Stock | 17.25 | 17.27 | 17.18 | 17.21 | 2495396.0 |
| 2009-01-30 15:00:00 | MSFT | Stock | 17.21 | 17.28 | 17.17 | 17.18 | 4454983.0 |
| 2009-01-30 15:30:00 | MSFT | Stock | 17.18 | 17.24 | 17.11 | 17.11 | 10141731.0 |
| 2009-01-30 16:00:00 | MSFT | Stock | 17.11 | 17.281 | 17.094 | 17.1 | 6870589.0 |
| 2009-01-30 16:30:00 | MSFT | Stock | 17.1 | 17.266 | 17.1 | 17.237 | 516799.0 |
| 2009-01-30 17:00:00 | MSFT | Stock | 17.17 | 17.266 | 17.14 | 17.16 | 18143.0 |
| 2009-01-30 17:30:00 | MSFT | Stock | 17.16 | 17.16 | 17.1 | 17.15 | 459775.0 |
| 2009-01-30 18:00:00 | MSFT | Stock | 17.16 | 17.2 | 17.16 | 17.2 | 8275.0 |
| 2009-01-30 18:30:00 | MSFT | Stock | 17.19 | 17.19 | 17.15 | 17.15 | 3418.0 |
| 2009-01-30 19:00:00 | MSFT | Stock | 17.19 | 17.19 | 17.13 | 17.13 | 5386.0 |
> showing 50 of 67,565 rows — these rows as CSV