PREVIEW / stock_30min / 2006-08-14
file: by_date/stock_30min/2006/2006-08-14.parquet size: 884 KB rows: 48,719 symbols: 2,345
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-08-14 05:00:00 | AAPL | Stock | 2.2811 | 2.2811 | 2.2811 | 2.2811 | 2800.0 |
| 2006-08-14 08:00:00 | AAPL | Stock | 2.2786 | 2.2946 | 2.2714 | 2.2857 | 1346324.0 |
| 2006-08-14 08:30:00 | AAPL | Stock | 2.2857 | 2.2925 | 2.2857 | 2.2857 | 773164.0 |
| 2006-08-14 09:00:00 | AAPL | Stock | 2.2857 | 2.2893 | 2.2818 | 2.2857 | 2332204.0 |
| 2006-08-14 09:30:00 | AAPL | Stock | 2.2875 | 2.305 | 2.275 | 2.2857 | 119562072.0 |
| 2006-08-14 10:00:00 | AAPL | Stock | 2.2857 | 2.2882 | 2.2714 | 2.2757 | 63105980.0 |
| 2006-08-14 10:30:00 | AAPL | Stock | 2.2757 | 2.2893 | 2.2754 | 2.288 | 41416900.0 |
| 2006-08-14 11:00:00 | AAPL | Stock | 2.2879 | 2.3096 | 2.2864 | 2.3011 | 82170032.0 |
| 2006-08-14 11:30:00 | AAPL | Stock | 2.3014 | 2.3093 | 2.2964 | 2.3085 | 54058564.0 |
| 2006-08-14 12:00:00 | AAPL | Stock | 2.3086 | 2.3293 | 2.3082 | 2.3186 | 70223748.0 |
| 2006-08-14 12:30:00 | AAPL | Stock | 2.3189 | 2.3232 | 2.3114 | 2.3168 | 28068012.0 |
| 2006-08-14 13:00:00 | AAPL | Stock | 2.3171 | 2.3204 | 2.3093 | 2.3127 | 22504356.0 |
| 2006-08-14 13:30:00 | AAPL | Stock | 2.3125 | 2.3171 | 2.3071 | 2.3096 | 20544216.0 |
| 2006-08-14 14:00:00 | AAPL | Stock | 2.3096 | 2.3143 | 2.2982 | 2.3082 | 47858580.0 |
| 2006-08-14 14:30:00 | AAPL | Stock | 2.3082 | 2.3136 | 2.3 | 2.3036 | 34795712.0 |
| 2006-08-14 15:00:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.2879 | 2.2918 | 58396324.0 |
| 2006-08-14 15:30:00 | AAPL | Stock | 2.2911 | 2.2932 | 2.2804 | 2.2804 | 63842492.0 |
| 2006-08-14 16:00:00 | AAPL | Stock | 2.2825 | 2.2836 | 2.28 | 2.2836 | 816256.0 |
| 2006-08-14 16:30:00 | AAPL | Stock | 2.2846 | 2.2857 | 2.2836 | 2.2846 | 191352.0 |
| 2006-08-14 17:00:00 | AAPL | Stock | 2.2854 | 2.2854 | 2.2839 | 2.2839 | 50540.0 |
| 2006-08-14 17:30:00 | AAPL | Stock | 2.285 | 2.285 | 2.2832 | 2.2832 | 109200.0 |
| 2006-08-14 18:00:00 | AAPL | Stock | 2.2832 | 2.285 | 2.2832 | 2.285 | 42420.0 |
| 2006-08-14 07:00:00 | MSFT | Stock | 24.54 | 24.58 | 24.54 | 24.58 | 2250.0 |
| 2006-08-14 07:30:00 | MSFT | Stock | 24.54 | 24.54 | 24.54 | 24.54 | 750.0 |
| 2006-08-14 08:00:00 | MSFT | Stock | 24.5 | 24.56 | 24.43 | 24.43 | 717650.0 |
| 2006-08-14 08:30:00 | MSFT | Stock | 24.55 | 24.56 | 24.54 | 24.56 | 40150.0 |
| 2006-08-14 09:00:00 | MSFT | Stock | 24.55 | 24.57 | 24.5 | 24.52 | 46146.0 |
| 2006-08-14 09:30:00 | MSFT | Stock | 24.52 | 24.54 | 24.4 | 24.43 | 5057349.0 |
| 2006-08-14 10:00:00 | MSFT | Stock | 24.43 | 24.51 | 24.38 | 24.39 | 2816024.0 |
| 2006-08-14 10:30:00 | MSFT | Stock | 24.38 | 24.52 | 24.35 | 24.42 | 3959311.0 |
| 2006-08-14 11:00:00 | MSFT | Stock | 24.41 | 24.47 | 24.38 | 24.39 | 3841695.0 |
| 2006-08-14 11:30:00 | MSFT | Stock | 24.4 | 24.5 | 24.38 | 24.48 | 3279340.0 |
| 2006-08-14 12:00:00 | MSFT | Stock | 24.49 | 24.51 | 24.46 | 24.5 | 2613860.0 |
| 2006-08-14 12:30:00 | MSFT | Stock | 24.49 | 24.57 | 24.48 | 24.57 | 3027053.0 |
| 2006-08-14 13:00:00 | MSFT | Stock | 24.57 | 24.59 | 24.52 | 24.55 | 1769954.0 |
| 2006-08-14 13:30:00 | MSFT | Stock | 24.553 | 24.59 | 24.52 | 24.54 | 1581305.0 |
| 2006-08-14 14:00:00 | MSFT | Stock | 24.54 | 24.6 | 24.5 | 24.54 | 3257300.0 |
| 2006-08-14 14:30:00 | MSFT | Stock | 24.54 | 24.56 | 24.49 | 24.512 | 2910974.0 |
| 2006-08-14 15:00:00 | MSFT | Stock | 24.52 | 24.55 | 24.48 | 24.53 | 3926545.0 |
| 2006-08-14 15:30:00 | MSFT | Stock | 24.53 | 24.54 | 24.48 | 24.52 | 5206428.0 |
| 2006-08-14 16:00:00 | MSFT | Stock | 24.52 | 24.53 | 24.49 | 24.49 | 827967.0 |
| 2006-08-14 16:30:00 | MSFT | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 12182.0 |
| 2006-08-14 17:00:00 | MSFT | Stock | 24.5 | 24.53 | 24.5 | 24.51 | 723400.0 |
| 2006-08-14 17:30:00 | MSFT | Stock | 24.5 | 24.5 | 24.49 | 24.49 | 4630.0 |
| 2006-08-14 08:00:00 | NVDA | Stock | 0.3975 | 0.3988 | 0.3967 | 0.397 | 184200.0 |
| 2006-08-14 08:30:00 | NVDA | Stock | 0.3967 | 0.398 | 0.3948 | 0.395 | 408000.0 |
| 2006-08-14 09:00:00 | NVDA | Stock | 0.395 | 0.396 | 0.3943 | 0.396 | 649200.0 |
| 2006-08-14 09:30:00 | NVDA | Stock | 0.3948 | 0.3967 | 0.3877 | 0.3888 | 99048420.0 |
| 2006-08-14 10:00:00 | NVDA | Stock | 0.3887 | 0.3955 | 0.3862 | 0.3868 | 61205100.0 |
| 2006-08-14 10:30:00 | NVDA | Stock | 0.3868 | 0.3897 | 0.3865 | 0.389 | 41792760.0 |
> showing 50 of 48,719 rows — these rows as CSV