PREVIEW / stock_30min / 2005-11-18
file: by_date/stock_30min/2005/2005-11-18.parquet size: 899 KB rows: 48,148 symbols: 2,116
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-18 07:30:00 | AAPL | Stock | 2.3139 | 2.3139 | 2.3139 | 2.3139 | 8400.0 |
| 2005-11-18 08:00:00 | AAPL | Stock | 2.3211 | 2.3214 | 2.3136 | 2.3179 | 697368.0 |
| 2005-11-18 08:30:00 | AAPL | Stock | 2.3193 | 2.3279 | 2.3193 | 2.3236 | 1676948.0 |
| 2005-11-18 09:00:00 | AAPL | Stock | 2.3236 | 2.3364 | 2.3193 | 2.3364 | 5832456.0 |
| 2005-11-18 09:30:00 | AAPL | Stock | 2.3325 | 2.3368 | 2.315 | 2.3211 | 108532004.0 |
| 2005-11-18 10:00:00 | AAPL | Stock | 2.3221 | 2.3293 | 2.3143 | 2.3193 | 48973316.0 |
| 2005-11-18 10:30:00 | AAPL | Stock | 2.3193 | 2.3232 | 2.3018 | 2.3064 | 53514328.0 |
| 2005-11-18 11:00:00 | AAPL | Stock | 2.3064 | 2.3157 | 2.2989 | 2.3071 | 31252508.0 |
| 2005-11-18 11:30:00 | AAPL | Stock | 2.3079 | 2.3129 | 2.3036 | 2.3125 | 26539604.0 |
| 2005-11-18 12:00:00 | AAPL | Stock | 2.3125 | 2.3207 | 2.3068 | 2.315 | 26874372.0 |
| 2005-11-18 12:30:00 | AAPL | Stock | 2.3143 | 2.3225 | 2.3104 | 2.3179 | 23281944.0 |
| 2005-11-18 13:00:00 | AAPL | Stock | 2.3179 | 2.3243 | 2.3143 | 2.3204 | 19080348.0 |
| 2005-11-18 13:30:00 | AAPL | Stock | 2.32 | 2.3264 | 2.3179 | 2.3232 | 19740812.0 |
| 2005-11-18 14:00:00 | AAPL | Stock | 2.3229 | 2.3246 | 2.3118 | 2.315 | 26115852.0 |
| 2005-11-18 14:30:00 | AAPL | Stock | 2.3146 | 2.3168 | 2.3082 | 2.3114 | 20730808.0 |
| 2005-11-18 15:00:00 | AAPL | Stock | 2.3118 | 2.315 | 2.3054 | 2.3089 | 28416780.0 |
| 2005-11-18 15:30:00 | AAPL | Stock | 2.3089 | 2.3157 | 2.3 | 2.3107 | 56672896.0 |
| 2005-11-18 16:00:00 | AAPL | Stock | 2.3057 | 2.3143 | 2.3057 | 2.3064 | 7458780.0 |
| 2005-11-18 16:30:00 | AAPL | Stock | 2.3082 | 2.3082 | 2.3064 | 2.3071 | 218148.0 |
| 2005-11-18 17:00:00 | AAPL | Stock | 2.3064 | 2.3082 | 2.3064 | 2.3075 | 166236.0 |
| 2005-11-18 17:30:00 | AAPL | Stock | 2.3036 | 2.3082 | 2.3036 | 2.3082 | 291452.0 |
| 2005-11-18 18:00:00 | AAPL | Stock | 2.3071 | 2.3107 | 2.3061 | 2.3107 | 162400.0 |
| 2005-11-18 07:00:00 | MSFT | Stock | 28.04 | 28.04 | 28.04 | 28.04 | 400.0 |
| 2005-11-18 07:30:00 | MSFT | Stock | 28.03 | 28.09 | 28.03 | 28.04 | 4250.0 |
| 2005-11-18 08:00:00 | MSFT | Stock | 27.97 | 28.09 | 27.97 | 28.05 | 46031.0 |
| 2005-11-18 08:30:00 | MSFT | Stock | 28.05 | 28.1 | 28.05 | 28.09 | 306062.0 |
| 2005-11-18 09:00:00 | MSFT | Stock | 28.09 | 28.25 | 27.97 | 28.2 | 1278143.0 |
| 2005-11-18 09:30:00 | MSFT | Stock | 28.12 | 28.25 | 27.99 | 28.02 | 21184262.0 |
| 2005-11-18 10:00:00 | MSFT | Stock | 28.02 | 28.07 | 28.0 | 28.04 | 5424534.0 |
| 2005-11-18 10:30:00 | MSFT | Stock | 28.05 | 28.06 | 27.94 | 27.95 | 6650367.0 |
| 2005-11-18 11:00:00 | MSFT | Stock | 27.96 | 28.01 | 27.9 | 27.96 | 5278321.0 |
| 2005-11-18 11:30:00 | MSFT | Stock | 27.95 | 27.99 | 27.9 | 27.98 | 3860084.0 |
| 2005-11-18 12:00:00 | MSFT | Stock | 27.98 | 28.01 | 27.96 | 27.969 | 3367555.0 |
| 2005-11-18 12:30:00 | MSFT | Stock | 27.962 | 27.99 | 27.93 | 27.97 | 2018460.0 |
| 2005-11-18 13:00:00 | MSFT | Stock | 27.97 | 28.0 | 27.95 | 27.99 | 1905806.0 |
| 2005-11-18 13:30:00 | MSFT | Stock | 27.99 | 28.01 | 27.97 | 27.998 | 3046044.0 |
| 2005-11-18 14:00:00 | MSFT | Stock | 28.0 | 28.05 | 27.98 | 27.99 | 2747906.0 |
| 2005-11-18 14:30:00 | MSFT | Stock | 27.98 | 28.01 | 27.97 | 27.97 | 2948240.0 |
| 2005-11-18 15:00:00 | MSFT | Stock | 27.98 | 28.01 | 27.97 | 27.98 | 4042648.0 |
| 2005-11-18 15:30:00 | MSFT | Stock | 27.99 | 28.14 | 27.98 | 28.05 | 8431982.0 |
| 2005-11-18 16:00:00 | MSFT | Stock | 28.06 | 28.07 | 28.008 | 28.01 | 167467.0 |
| 2005-11-18 16:30:00 | MSFT | Stock | 28.01 | 28.06 | 28.0 | 28.02 | 6190.0 |
| 2005-11-18 17:00:00 | MSFT | Stock | 28.02 | 28.07 | 28.02 | 28.02 | 552059.0 |
| 2005-11-18 17:30:00 | MSFT | Stock | 28.02 | 28.05 | 27.98 | 28.05 | 29780.0 |
| 2005-11-18 18:00:00 | MSFT | Stock | 28.05 | 28.07 | 28.01 | 28.01 | 7384.0 |
| 2005-11-18 08:00:00 | NVDA | Stock | 0.3038 | 0.3044 | 0.3038 | 0.3044 | 192000.0 |
| 2005-11-18 08:30:00 | NVDA | Stock | 0.3044 | 0.3046 | 0.3044 | 0.3046 | 146400.0 |
| 2005-11-18 09:00:00 | NVDA | Stock | 0.3038 | 0.305 | 0.3022 | 0.3042 | 1659600.0 |
| 2005-11-18 09:30:00 | NVDA | Stock | 0.3031 | 0.3057 | 0.3008 | 0.3052 | 91826760.0 |
| 2005-11-18 10:00:00 | NVDA | Stock | 0.3052 | 0.3057 | 0.3 | 0.3001 | 56667960.0 |
> showing 50 of 48,148 rows — these rows as CSV