PREVIEW / stock_30min / 2006-11-02
file: by_date/stock_30min/2006/2006-11-02.parquet size: 958 KB rows: 51,998 symbols: 2,440
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-02 08:00:00 | AAPL | Stock | 2.8421 | 2.8514 | 2.8332 | 2.8418 | 1175020.0 |
| 2006-11-02 08:30:00 | AAPL | Stock | 2.8414 | 2.8414 | 2.8193 | 2.8193 | 2166836.0 |
| 2006-11-02 09:00:00 | AAPL | Stock | 2.8193 | 2.8207 | 2.8143 | 2.8207 | 1456728.0 |
| 2006-11-02 09:30:00 | AAPL | Stock | 2.8184 | 2.8304 | 2.8036 | 2.8168 | 81178244.0 |
| 2006-11-02 10:00:00 | AAPL | Stock | 2.8171 | 2.8304 | 2.8125 | 2.8275 | 48299132.0 |
| 2006-11-02 10:30:00 | AAPL | Stock | 2.8271 | 2.8296 | 2.8193 | 2.82 | 42051212.0 |
| 2006-11-02 11:00:00 | AAPL | Stock | 2.82 | 2.8329 | 2.8146 | 2.8168 | 41366696.0 |
| 2006-11-02 11:30:00 | AAPL | Stock | 2.8161 | 2.8168 | 2.8111 | 2.8136 | 30172324.0 |
| 2006-11-02 12:00:00 | AAPL | Stock | 2.8129 | 2.8193 | 2.8129 | 2.8143 | 16313472.0 |
| 2006-11-02 12:30:00 | AAPL | Stock | 2.8143 | 2.8196 | 2.8129 | 2.8189 | 24823988.0 |
| 2006-11-02 13:00:00 | AAPL | Stock | 2.8189 | 2.8207 | 2.8154 | 2.8186 | 26744424.0 |
| 2006-11-02 13:30:00 | AAPL | Stock | 2.8186 | 2.8207 | 2.8154 | 2.8182 | 15001560.0 |
| 2006-11-02 14:00:00 | AAPL | Stock | 2.8182 | 2.8286 | 2.8182 | 2.8268 | 23696988.0 |
| 2006-11-02 14:30:00 | AAPL | Stock | 2.8268 | 2.8279 | 2.8171 | 2.8171 | 27278860.0 |
| 2006-11-02 15:00:00 | AAPL | Stock | 2.8171 | 2.8204 | 2.8129 | 2.815 | 17159856.0 |
| 2006-11-02 15:30:00 | AAPL | Stock | 2.8146 | 2.8264 | 2.8143 | 2.8189 | 42158284.0 |
| 2006-11-02 16:00:00 | AAPL | Stock | 2.82 | 2.8232 | 2.8189 | 2.8207 | 1610700.0 |
| 2006-11-02 16:30:00 | AAPL | Stock | 2.8207 | 2.8211 | 2.8196 | 2.8196 | 51520.0 |
| 2006-11-02 17:00:00 | AAPL | Stock | 2.8207 | 2.8214 | 2.8186 | 2.8214 | 1002596.0 |
| 2006-11-02 18:00:00 | AAPL | Stock | 2.8214 | 2.8214 | 2.8214 | 2.8214 | 39536.0 |
| 2006-11-02 18:30:00 | AAPL | Stock | 2.8214 | 2.8214 | 2.8214 | 2.8214 | 24864.0 |
| 2006-11-02 19:30:00 | AAPL | Stock | 2.8221 | 2.8221 | 2.8221 | 2.8221 | 27664.0 |
| 2006-11-02 07:30:00 | MSFT | Stock | 28.81 | 28.81 | 28.81 | 28.81 | 1000.0 |
| 2006-11-02 08:00:00 | MSFT | Stock | 28.81 | 28.81 | 28.76 | 28.76 | 3368.0 |
| 2006-11-02 08:30:00 | MSFT | Stock | 28.76 | 28.78 | 28.67 | 28.67 | 43600.0 |
| 2006-11-02 09:00:00 | MSFT | Stock | 28.66 | 28.7 | 28.63 | 28.7 | 79256.0 |
| 2006-11-02 09:30:00 | MSFT | Stock | 28.71 | 28.8 | 28.58 | 28.75 | 7206096.0 |
| 2006-11-02 10:00:00 | MSFT | Stock | 28.76 | 28.83 | 28.74 | 28.8 | 3996506.0 |
| 2006-11-02 10:30:00 | MSFT | Stock | 28.8 | 28.81 | 28.74 | 28.76 | 3319531.0 |
| 2006-11-02 11:00:00 | MSFT | Stock | 28.76 | 28.78 | 28.74 | 28.76 | 2813419.0 |
| 2006-11-02 11:30:00 | MSFT | Stock | 28.77 | 28.86 | 28.76 | 28.79 | 7648027.0 |
| 2006-11-02 12:00:00 | MSFT | Stock | 28.8 | 28.82 | 28.78 | 28.79 | 2102047.0 |
| 2006-11-02 12:30:00 | MSFT | Stock | 28.79 | 28.81 | 28.76 | 28.79 | 2544729.0 |
| 2006-11-02 13:00:00 | MSFT | Stock | 28.8 | 28.8 | 28.68 | 28.77 | 5400116.0 |
| 2006-11-02 13:30:00 | MSFT | Stock | 28.78 | 28.79 | 28.75 | 28.76 | 1503784.0 |
| 2006-11-02 14:00:00 | MSFT | Stock | 28.76 | 28.8 | 28.73 | 28.8 | 1941541.0 |
| 2006-11-02 14:30:00 | MSFT | Stock | 28.8 | 28.82 | 28.77 | 28.79 | 2244565.0 |
| 2006-11-02 15:00:00 | MSFT | Stock | 28.8 | 28.82 | 28.77 | 28.78 | 2485710.0 |
| 2006-11-02 15:30:00 | MSFT | Stock | 28.79 | 28.81 | 28.73 | 28.75 | 3995633.0 |
| 2006-11-02 16:00:00 | MSFT | Stock | 28.76 | 28.77 | 28.73 | 28.75 | 75860.0 |
| 2006-11-02 16:30:00 | MSFT | Stock | 28.74 | 28.74 | 28.74 | 28.74 | 1500.0 |
| 2006-11-02 17:00:00 | MSFT | Stock | 28.75 | 28.78 | 28.74 | 28.78 | 293484.0 |
| 2006-11-02 17:30:00 | MSFT | Stock | 28.8 | 28.81 | 28.8 | 28.81 | 3900.0 |
| 2006-11-02 18:30:00 | MSFT | Stock | 28.79 | 28.81 | 28.79 | 28.81 | 222.0 |
| 2006-11-02 06:30:00 | NVDA | Stock | 0.5363 | 0.5363 | 0.5363 | 0.5363 | 6000.0 |
| 2006-11-02 07:30:00 | NVDA | Stock | 0.54 | 0.5442 | 0.54 | 0.5442 | 18000.0 |
| 2006-11-02 08:00:00 | NVDA | Stock | 0.5383 | 0.5435 | 0.5383 | 0.5427 | 545400.0 |
| 2006-11-02 08:30:00 | NVDA | Stock | 0.5388 | 0.54 | 0.5383 | 0.5388 | 529800.0 |
| 2006-11-02 09:00:00 | NVDA | Stock | 0.5388 | 0.5393 | 0.5347 | 0.5393 | 818640.0 |
| 2006-11-02 09:30:00 | NVDA | Stock | 0.5375 | 0.5505 | 0.5375 | 0.5503 | 142618860.0 |
> showing 50 of 51,998 rows — these rows as CSV