PREVIEW / stock_30min / 2006-11-28
file: by_date/stock_30min/2006/2006-11-28.parquet size: 980 KB rows: 52,594 symbols: 2,471
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-11-28 06:00:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 53200.0 |
| 2006-11-28 06:30:00 | AAPL | Stock | 3.2093 | 3.2093 | 3.2093 | 3.2093 | 2800.0 |
| 2006-11-28 07:00:00 | AAPL | Stock | 3.2186 | 3.2286 | 3.2161 | 3.2211 | 62188.0 |
| 2006-11-28 07:30:00 | AAPL | Stock | 3.2161 | 3.2321 | 3.2061 | 3.2286 | 784644.0 |
| 2006-11-28 08:00:00 | AAPL | Stock | 3.2257 | 3.2336 | 3.2221 | 3.225 | 4477592.0 |
| 2006-11-28 08:30:00 | AAPL | Stock | 3.2236 | 3.225 | 3.2054 | 3.2104 | 5520928.0 |
| 2006-11-28 09:00:00 | AAPL | Stock | 3.21 | 3.2375 | 3.2068 | 3.2279 | 7618380.0 |
| 2006-11-28 09:30:00 | AAPL | Stock | 3.2271 | 3.2471 | 3.2111 | 3.2289 | 178133676.0 |
| 2006-11-28 10:00:00 | AAPL | Stock | 3.2293 | 3.2657 | 3.2254 | 3.2657 | 137452336.0 |
| 2006-11-28 10:30:00 | AAPL | Stock | 3.265 | 3.2768 | 3.2268 | 3.2596 | 97269312.0 |
| 2006-11-28 11:00:00 | AAPL | Stock | 3.2593 | 3.2689 | 3.2521 | 3.2611 | 58914912.0 |
| 2006-11-28 11:30:00 | AAPL | Stock | 3.2618 | 3.275 | 3.2596 | 3.2679 | 54809496.0 |
| 2006-11-28 12:00:00 | AAPL | Stock | 3.2679 | 3.2839 | 3.2625 | 3.2711 | 52537240.0 |
| 2006-11-28 12:30:00 | AAPL | Stock | 3.2714 | 3.2718 | 3.22 | 3.2496 | 62716276.0 |
| 2006-11-28 13:00:00 | AAPL | Stock | 3.2496 | 3.2646 | 3.245 | 3.2504 | 46574024.0 |
| 2006-11-28 13:30:00 | AAPL | Stock | 3.25 | 3.2593 | 3.2375 | 3.2386 | 45147844.0 |
| 2006-11-28 14:00:00 | AAPL | Stock | 3.2386 | 3.2579 | 3.2271 | 3.2546 | 69145804.0 |
| 2006-11-28 14:30:00 | AAPL | Stock | 3.255 | 3.2625 | 3.2521 | 3.2557 | 44550940.0 |
| 2006-11-28 15:00:00 | AAPL | Stock | 3.2564 | 3.2661 | 3.2518 | 3.2636 | 55017760.0 |
| 2006-11-28 15:30:00 | AAPL | Stock | 3.2639 | 3.2846 | 3.2625 | 3.2768 | 106393924.0 |
| 2006-11-28 16:00:00 | AAPL | Stock | 3.2768 | 3.2786 | 3.2732 | 3.2775 | 1916292.0 |
| 2006-11-28 16:30:00 | AAPL | Stock | 3.2771 | 3.2804 | 3.2771 | 3.2804 | 516684.0 |
| 2006-11-28 17:00:00 | AAPL | Stock | 3.2807 | 3.2821 | 3.2757 | 3.2818 | 511672.0 |
| 2006-11-28 17:30:00 | AAPL | Stock | 3.2821 | 3.2821 | 3.2754 | 3.2754 | 141904.0 |
| 2006-11-28 18:00:00 | AAPL | Stock | 3.2821 | 3.2821 | 3.2763 | 3.2821 | 252812.0 |
| 2006-11-28 18:30:00 | AAPL | Stock | 3.2821 | 3.2821 | 3.2804 | 3.2804 | 97272.0 |
| 2006-11-28 19:00:00 | AAPL | Stock | 3.2821 | 3.2846 | 3.2814 | 3.2814 | 42056.0 |
| 2006-11-28 19:30:00 | AAPL | Stock | 3.2836 | 3.2836 | 3.2825 | 3.2825 | 42000.0 |
| 2006-11-28 07:00:00 | MSFT | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 500.0 |
| 2006-11-28 07:30:00 | MSFT | Stock | 29.41 | 29.41 | 29.37 | 29.37 | 800.0 |
| 2006-11-28 08:00:00 | MSFT | Stock | 29.38 | 29.4 | 29.38 | 29.4 | 3900.0 |
| 2006-11-28 08:30:00 | MSFT | Stock | 29.38 | 29.38 | 29.32 | 29.32 | 17817.0 |
| 2006-11-28 09:00:00 | MSFT | Stock | 29.32 | 29.35 | 29.26 | 29.34 | 123008.0 |
| 2006-11-28 09:30:00 | MSFT | Stock | 29.34 | 29.35 | 29.13 | 29.27 | 9413703.0 |
| 2006-11-28 10:00:00 | MSFT | Stock | 29.272 | 29.35 | 29.18 | 29.32 | 6172967.0 |
| 2006-11-28 10:30:00 | MSFT | Stock | 29.32 | 29.41 | 29.28 | 29.32 | 5277823.0 |
| 2006-11-28 11:00:00 | MSFT | Stock | 29.319 | 29.36 | 29.28 | 29.333 | 2941264.0 |
| 2006-11-28 11:30:00 | MSFT | Stock | 29.34 | 29.37 | 29.2 | 29.29 | 3360995.0 |
| 2006-11-28 12:00:00 | MSFT | Stock | 29.29 | 29.36 | 29.27 | 29.3 | 2891426.0 |
| 2006-11-28 12:30:00 | MSFT | Stock | 29.3 | 29.32 | 29.24 | 29.29 | 2134433.0 |
| 2006-11-28 13:00:00 | MSFT | Stock | 29.28 | 29.39 | 29.27 | 29.29 | 4113290.0 |
| 2006-11-28 13:30:00 | MSFT | Stock | 29.29 | 29.36 | 29.28 | 29.3 | 2067900.0 |
| 2006-11-28 14:00:00 | MSFT | Stock | 29.3 | 29.35 | 29.29 | 29.32 | 2243340.0 |
| 2006-11-28 14:30:00 | MSFT | Stock | 29.33 | 29.35 | 29.3 | 29.31 | 2035272.0 |
| 2006-11-28 15:00:00 | MSFT | Stock | 29.31 | 29.39 | 29.29 | 29.36 | 3433382.0 |
| 2006-11-28 15:30:00 | MSFT | Stock | 29.36 | 29.42 | 29.36 | 29.39 | 4509214.0 |
| 2006-11-28 16:00:00 | MSFT | Stock | 29.39 | 29.45 | 29.34 | 29.37 | 310616.0 |
| 2006-11-28 16:30:00 | MSFT | Stock | 29.353 | 29.36 | 29.31 | 29.31 | 16350.0 |
| 2006-11-28 17:00:00 | MSFT | Stock | 29.32 | 29.32 | 29.31 | 29.32 | 19900.0 |
| 2006-11-28 17:30:00 | MSFT | Stock | 29.33 | 29.33 | 29.32 | 29.32 | 400.0 |
> showing 50 of 52,594 rows — these rows as CSV