PREVIEW / stock_30min / 2006-11-27
file: by_date/stock_30min/2006/2006-11-27.parquet size: 978 KB rows: 52,273 symbols: 2,457
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-27 06:30:00 | AAPL | Stock | 3.2725 | 3.2857 | 3.2725 | 3.2857 | 87080.0 |
| 2006-11-27 07:00:00 | AAPL | Stock | 3.2857 | 3.3032 | 3.2857 | 3.2936 | 186200.0 |
| 2006-11-27 07:30:00 | AAPL | Stock | 3.2929 | 3.3039 | 3.2911 | 3.2993 | 645932.0 |
| 2006-11-27 08:00:00 | AAPL | Stock | 3.3032 | 3.3157 | 3.2971 | 3.3089 | 5927908.0 |
| 2006-11-27 08:30:00 | AAPL | Stock | 3.3071 | 3.3107 | 3.2946 | 3.3 | 4202632.0 |
| 2006-11-27 09:00:00 | AAPL | Stock | 3.3 | 3.3046 | 3.2918 | 3.3036 | 4778704.0 |
| 2006-11-27 09:30:00 | AAPL | Stock | 3.3039 | 3.3271 | 3.2968 | 3.3054 | 154356216.0 |
| 2006-11-27 10:00:00 | AAPL | Stock | 3.3061 | 3.3061 | 3.2729 | 3.2843 | 136020080.0 |
| 2006-11-27 10:30:00 | AAPL | Stock | 3.2839 | 3.2875 | 3.2554 | 3.2804 | 96515832.0 |
| 2006-11-27 11:00:00 | AAPL | Stock | 3.28 | 3.2839 | 3.25 | 3.25 | 74126388.0 |
| 2006-11-27 11:30:00 | AAPL | Stock | 3.2507 | 3.2643 | 3.2357 | 3.2393 | 75301576.0 |
| 2006-11-27 12:00:00 | AAPL | Stock | 3.2389 | 3.2514 | 3.2214 | 3.2439 | 80136924.0 |
| 2006-11-27 12:30:00 | AAPL | Stock | 3.2443 | 3.2446 | 3.2075 | 3.2096 | 65745232.0 |
| 2006-11-27 13:00:00 | AAPL | Stock | 3.2093 | 3.2182 | 3.2029 | 3.2157 | 60575984.0 |
| 2006-11-27 13:30:00 | AAPL | Stock | 3.2161 | 3.2257 | 3.2079 | 3.2221 | 53433688.0 |
| 2006-11-27 14:00:00 | AAPL | Stock | 3.2225 | 3.2304 | 3.2057 | 3.2114 | 55715212.0 |
| 2006-11-27 14:30:00 | AAPL | Stock | 3.2111 | 3.2225 | 3.2089 | 3.2114 | 46316396.0 |
| 2006-11-27 15:00:00 | AAPL | Stock | 3.2111 | 3.2161 | 3.1975 | 3.2057 | 62468868.0 |
| 2006-11-27 15:30:00 | AAPL | Stock | 3.2061 | 3.2186 | 3.1964 | 3.1964 | 82794908.0 |
| 2006-11-27 16:00:00 | AAPL | Stock | 3.1964 | 3.1975 | 3.19 | 3.1957 | 2096444.0 |
| 2006-11-27 16:30:00 | AAPL | Stock | 3.1946 | 3.1964 | 3.1929 | 3.1939 | 529536.0 |
| 2006-11-27 17:00:00 | AAPL | Stock | 3.1939 | 3.1964 | 3.1929 | 3.1961 | 220444.0 |
| 2006-11-27 17:30:00 | AAPL | Stock | 3.1932 | 3.1979 | 3.1929 | 3.1979 | 137256.0 |
| 2006-11-27 18:00:00 | AAPL | Stock | 3.1979 | 3.1996 | 3.1929 | 3.1979 | 323400.0 |
| 2006-11-27 18:30:00 | AAPL | Stock | 3.1929 | 3.1979 | 3.1929 | 3.1979 | 106848.0 |
| 2006-11-27 19:00:00 | AAPL | Stock | 3.1979 | 3.2004 | 3.1964 | 3.2004 | 142800.0 |
| 2006-11-27 19:30:00 | AAPL | Stock | 3.1996 | 3.2007 | 3.1986 | 3.2004 | 109060.0 |
| 2006-11-27 07:30:00 | MSFT | Stock | 29.7 | 29.7 | 29.7 | 29.7 | 100.0 |
| 2006-11-27 08:00:00 | MSFT | Stock | 29.7 | 29.73 | 29.68 | 29.7 | 6242.0 |
| 2006-11-27 08:30:00 | MSFT | Stock | 29.76 | 29.76 | 29.67 | 29.68 | 8800.0 |
| 2006-11-27 09:00:00 | MSFT | Stock | 29.7 | 29.7 | 29.65 | 29.69 | 56873.0 |
| 2006-11-27 09:30:00 | MSFT | Stock | 29.69 | 29.74 | 29.59 | 29.66 | 5234579.0 |
| 2006-11-27 10:00:00 | MSFT | Stock | 29.66 | 29.7 | 29.56 | 29.62 | 5386833.0 |
| 2006-11-27 10:30:00 | MSFT | Stock | 29.63 | 29.63 | 29.47 | 29.51 | 5898183.0 |
| 2006-11-27 11:00:00 | MSFT | Stock | 29.51 | 29.52 | 29.33 | 29.36 | 8988950.0 |
| 2006-11-27 11:30:00 | MSFT | Stock | 29.36 | 29.45 | 29.35 | 29.44 | 3082238.0 |
| 2006-11-27 12:00:00 | MSFT | Stock | 29.441 | 29.58 | 29.41 | 29.52 | 3886709.0 |
| 2006-11-27 12:30:00 | MSFT | Stock | 29.51 | 29.52 | 29.45 | 29.48 | 3226137.0 |
| 2006-11-27 13:00:00 | MSFT | Stock | 29.48 | 29.55 | 29.42 | 29.55 | 3723681.0 |
| 2006-11-27 13:30:00 | MSFT | Stock | 29.55 | 29.56 | 29.49 | 29.492 | 3797010.0 |
| 2006-11-27 14:00:00 | MSFT | Stock | 29.5 | 29.54 | 29.44 | 29.53 | 2695951.0 |
| 2006-11-27 14:30:00 | MSFT | Stock | 29.54 | 29.69 | 29.51 | 29.53 | 3429845.0 |
| 2006-11-27 15:00:00 | MSFT | Stock | 29.52 | 29.53 | 29.45 | 29.47 | 4860221.0 |
| 2006-11-27 15:30:00 | MSFT | Stock | 29.48 | 29.5 | 29.45 | 29.47 | 6306068.0 |
| 2006-11-27 16:00:00 | MSFT | Stock | 29.47 | 29.58 | 29.47 | 29.5 | 171811.0 |
| 2006-11-27 16:30:00 | MSFT | Stock | 29.5 | 29.51 | 29.42 | 29.43 | 26790.0 |
| 2006-11-27 17:00:00 | MSFT | Stock | 29.43 | 29.43 | 29.42 | 29.42 | 200.0 |
| 2006-11-27 17:30:00 | MSFT | Stock | 29.42 | 29.43 | 29.42 | 29.43 | 1280.0 |
| 2006-11-27 18:00:00 | MSFT | Stock | 29.44 | 29.5 | 29.44 | 29.5 | 600.0 |
| 2006-11-27 19:30:00 | MSFT | Stock | 29.47 | 29.47 | 29.44 | 29.44 | 1810.0 |
> showing 50 of 52,273 rows — these rows as CSV