PREVIEW / stock_30min / 2005-11-21
file: by_date/stock_30min/2005/2005-11-21.parquet size: 864 KB rows: 46,405 symbols: 2,126
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-21 07:30:00 | AAPL | Stock | 2.3093 | 2.3111 | 2.3093 | 2.3111 | 5600.0 |
| 2005-11-21 08:00:00 | AAPL | Stock | 2.3143 | 2.3246 | 2.3143 | 2.3214 | 686504.0 |
| 2005-11-21 08:30:00 | AAPL | Stock | 2.3207 | 2.325 | 2.3186 | 2.3189 | 559580.0 |
| 2005-11-21 09:00:00 | AAPL | Stock | 2.3186 | 2.3189 | 2.2968 | 2.3157 | 1892548.0 |
| 2005-11-21 09:30:00 | AAPL | Stock | 2.315 | 2.315 | 2.29 | 2.2936 | 81525444.0 |
| 2005-11-21 10:00:00 | AAPL | Stock | 2.2939 | 2.2979 | 2.2771 | 2.2861 | 67966332.0 |
| 2005-11-21 10:30:00 | AAPL | Stock | 2.2861 | 2.2939 | 2.2818 | 2.2914 | 46700108.0 |
| 2005-11-21 11:00:00 | AAPL | Stock | 2.2914 | 2.2921 | 2.28 | 2.285 | 28053620.0 |
| 2005-11-21 11:30:00 | AAPL | Stock | 2.285 | 2.2871 | 2.2757 | 2.2871 | 30650844.0 |
| 2005-11-21 12:00:00 | AAPL | Stock | 2.2871 | 2.3007 | 2.2845 | 2.2964 | 28003052.0 |
| 2005-11-21 12:30:00 | AAPL | Stock | 2.2964 | 2.3071 | 2.2946 | 2.3043 | 27168120.0 |
| 2005-11-21 13:00:00 | AAPL | Stock | 2.3043 | 2.3121 | 2.3 | 2.3104 | 23443280.0 |
| 2005-11-21 13:30:00 | AAPL | Stock | 2.3107 | 2.3279 | 2.3089 | 2.3225 | 39358060.0 |
| 2005-11-21 14:00:00 | AAPL | Stock | 2.3229 | 2.3236 | 2.3096 | 2.3182 | 22550332.0 |
| 2005-11-21 14:30:00 | AAPL | Stock | 2.3186 | 2.3229 | 2.3139 | 2.3175 | 17738336.0 |
| 2005-11-21 15:00:00 | AAPL | Stock | 2.3175 | 2.3254 | 2.3161 | 2.3218 | 33509616.0 |
| 2005-11-21 15:30:00 | AAPL | Stock | 2.3214 | 2.3282 | 2.3071 | 2.3179 | 53484060.0 |
| 2005-11-21 16:00:00 | AAPL | Stock | 2.32 | 2.32 | 2.2826 | 2.3168 | 2005136.0 |
| 2005-11-21 16:30:00 | AAPL | Stock | 2.3164 | 2.3196 | 2.3164 | 2.3186 | 84896.0 |
| 2005-11-21 17:00:00 | AAPL | Stock | 2.3182 | 2.3189 | 2.3179 | 2.3189 | 36400.0 |
| 2005-11-21 17:30:00 | AAPL | Stock | 2.3189 | 2.3189 | 2.3179 | 2.3179 | 59500.0 |
| 2005-11-21 18:00:00 | AAPL | Stock | 2.3189 | 2.3193 | 2.3182 | 2.3182 | 11900.0 |
| 2005-11-21 06:30:00 | MSFT | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 100.0 |
| 2005-11-21 07:00:00 | MSFT | Stock | 28.08 | 28.08 | 28.08 | 28.08 | 1000.0 |
| 2005-11-21 07:30:00 | MSFT | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 100.0 |
| 2005-11-21 08:00:00 | MSFT | Stock | 28.1 | 28.15 | 28.07 | 28.12 | 68871.0 |
| 2005-11-21 08:30:00 | MSFT | Stock | 28.12 | 28.24 | 28.09 | 28.1 | 46580.0 |
| 2005-11-21 09:00:00 | MSFT | Stock | 28.1 | 28.11 | 28.05 | 28.06 | 90012.0 |
| 2005-11-21 09:30:00 | MSFT | Stock | 28.07 | 28.135 | 27.85 | 27.87 | 8547102.0 |
| 2005-11-21 10:00:00 | MSFT | Stock | 27.87 | 27.91 | 27.84 | 27.87 | 3690833.0 |
| 2005-11-21 10:30:00 | MSFT | Stock | 27.87 | 28.07 | 27.86 | 27.95 | 4318161.0 |
| 2005-11-21 11:00:00 | MSFT | Stock | 27.95 | 28.0 | 27.922 | 27.99 | 3575880.0 |
| 2005-11-21 11:30:00 | MSFT | Stock | 28.0 | 28.07 | 27.95 | 28.06 | 4961133.0 |
| 2005-11-21 12:00:00 | MSFT | Stock | 28.06 | 28.08 | 28.01 | 28.02 | 2406122.0 |
| 2005-11-21 12:30:00 | MSFT | Stock | 28.012 | 28.06 | 27.5 | 28.02 | 2155350.0 |
| 2005-11-21 13:00:00 | MSFT | Stock | 28.01 | 28.03 | 27.93 | 28.02 | 2607427.0 |
| 2005-11-21 13:30:00 | MSFT | Stock | 28.015 | 28.08 | 27.99 | 28.05 | 2724222.0 |
| 2005-11-21 14:00:00 | MSFT | Stock | 28.05 | 28.18 | 28.0 | 28.142 | 7195936.0 |
| 2005-11-21 14:30:00 | MSFT | Stock | 28.15 | 28.16 | 28.03 | 28.09 | 3667771.0 |
| 2005-11-21 15:00:00 | MSFT | Stock | 28.091 | 28.16 | 28.0 | 28.15 | 4321447.0 |
| 2005-11-21 15:30:00 | MSFT | Stock | 28.15 | 28.24 | 28.12 | 28.16 | 10027095.0 |
| 2005-11-21 16:00:00 | MSFT | Stock | 28.17 | 28.204 | 28.026 | 28.13 | 601397.0 |
| 2005-11-21 16:30:00 | MSFT | Stock | 28.14 | 28.23 | 28.06 | 28.2 | 234226.0 |
| 2005-11-21 17:00:00 | MSFT | Stock | 28.16 | 28.21 | 28.1 | 28.19 | 333922.0 |
| 2005-11-21 17:30:00 | MSFT | Stock | 28.19 | 28.19 | 28.17 | 28.18 | 3701.0 |
| 2005-11-21 18:00:00 | MSFT | Stock | 28.19 | 28.2 | 28.16 | 28.17 | 370496.0 |
| 2005-11-21 09:00:00 | NVDA | Stock | 0.3017 | 0.3017 | 0.3017 | 0.3017 | 12000.0 |
| 2005-11-21 09:30:00 | NVDA | Stock | 0.3019 | 0.3029 | 0.2999 | 0.3005 | 41210160.0 |
| 2005-11-21 10:00:00 | NVDA | Stock | 0.3003 | 0.3057 | 0.3003 | 0.3048 | 47618400.0 |
| 2005-11-21 10:30:00 | NVDA | Stock | 0.3048 | 0.3063 | 0.3032 | 0.3041 | 50532960.0 |
> showing 50 of 46,405 rows — these rows as CSV