PREVIEW / stock_30min / 2006-01-09
file: by_date/stock_30min/2006/2006-01-09.parquet size: 895 KB rows: 48,141 symbols: 2,176
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-01-09 08:00:00 | AAPL | Stock | 2.7357 | 2.7554 | 2.725 | 2.7482 | 3507364.0 |
| 2006-01-09 08:30:00 | AAPL | Stock | 2.7482 | 2.7496 | 2.7418 | 2.7471 | 1499988.0 |
| 2006-01-09 09:00:00 | AAPL | Stock | 2.7471 | 2.7504 | 2.7386 | 2.7411 | 2999920.0 |
| 2006-01-09 09:30:00 | AAPL | Stock | 2.7404 | 2.7571 | 2.7311 | 2.7379 | 113224272.0 |
| 2006-01-09 10:00:00 | AAPL | Stock | 2.7375 | 2.7446 | 2.7196 | 2.7439 | 82519500.0 |
| 2006-01-09 10:30:00 | AAPL | Stock | 2.7439 | 2.7464 | 2.7364 | 2.7407 | 47927264.0 |
| 2006-01-09 11:00:00 | AAPL | Stock | 2.7407 | 2.7418 | 2.725 | 2.7346 | 44896992.0 |
| 2006-01-09 11:30:00 | AAPL | Stock | 2.7346 | 2.7354 | 2.7257 | 2.73 | 22810200.0 |
| 2006-01-09 12:00:00 | AAPL | Stock | 2.73 | 2.7325 | 2.7189 | 2.7321 | 38588396.0 |
| 2006-01-09 12:30:00 | AAPL | Stock | 2.7321 | 2.7496 | 2.7293 | 2.7421 | 42065744.0 |
| 2006-01-09 13:00:00 | AAPL | Stock | 2.7421 | 2.7457 | 2.7371 | 2.7386 | 30394028.0 |
| 2006-01-09 13:30:00 | AAPL | Stock | 2.7389 | 2.7425 | 2.7329 | 2.7332 | 24741360.0 |
| 2006-01-09 14:00:00 | AAPL | Stock | 2.7332 | 2.7357 | 2.7196 | 2.7204 | 36142736.0 |
| 2006-01-09 14:30:00 | AAPL | Stock | 2.7207 | 2.7236 | 2.705 | 2.7118 | 64056356.0 |
| 2006-01-09 15:00:00 | AAPL | Stock | 2.7114 | 2.7196 | 2.7057 | 2.7128 | 42640780.0 |
| 2006-01-09 15:30:00 | AAPL | Stock | 2.7125 | 2.7179 | 2.7068 | 2.7154 | 62209616.0 |
| 2006-01-09 16:00:00 | AAPL | Stock | 2.7157 | 2.7171 | 2.71 | 2.7161 | 4084892.0 |
| 2006-01-09 16:30:00 | AAPL | Stock | 2.7161 | 2.7182 | 2.7154 | 2.7164 | 231616.0 |
| 2006-01-09 17:00:00 | AAPL | Stock | 2.7171 | 2.7171 | 2.7136 | 2.7136 | 200620.0 |
| 2006-01-09 17:30:00 | AAPL | Stock | 2.7161 | 2.7171 | 2.7161 | 2.7161 | 214312.0 |
| 2006-01-09 18:00:00 | AAPL | Stock | 2.7171 | 2.7171 | 2.7118 | 2.7136 | 402052.0 |
| 2006-01-09 06:30:00 | MSFT | Stock | 26.85 | 26.85 | 26.85 | 26.85 | 1000.0 |
| 2006-01-09 07:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.9 | 26.9 | 4500.0 |
| 2006-01-09 08:00:00 | MSFT | Stock | 26.99 | 27.04 | 26.91 | 27.0 | 20487.0 |
| 2006-01-09 08:30:00 | MSFT | Stock | 27.01 | 27.01 | 26.98 | 26.99 | 16448.0 |
| 2006-01-09 09:00:00 | MSFT | Stock | 26.95 | 26.96 | 26.9 | 26.93 | 3582846.0 |
| 2006-01-09 09:30:00 | MSFT | Stock | 26.93 | 26.98 | 26.82 | 26.842 | 6064061.0 |
| 2006-01-09 10:00:00 | MSFT | Stock | 26.84 | 26.96 | 26.76 | 26.91 | 5763064.0 |
| 2006-01-09 10:30:00 | MSFT | Stock | 26.91 | 26.96 | 26.9 | 26.93 | 2207084.0 |
| 2006-01-09 11:00:00 | MSFT | Stock | 26.93 | 26.96 | 26.9 | 26.93 | 2218708.0 |
| 2006-01-09 11:30:00 | MSFT | Stock | 26.93 | 27.01 | 26.9 | 27.0 | 3826346.0 |
| 2006-01-09 12:00:00 | MSFT | Stock | 27.0 | 27.07 | 26.96 | 27.06 | 4504929.0 |
| 2006-01-09 12:30:00 | MSFT | Stock | 27.05 | 27.06 | 26.99 | 27.01 | 1820471.0 |
| 2006-01-09 13:00:00 | MSFT | Stock | 27.0 | 27.02 | 26.96 | 26.98 | 2945388.0 |
| 2006-01-09 13:30:00 | MSFT | Stock | 26.98 | 27.03 | 26.96 | 26.99 | 3566214.0 |
| 2006-01-09 14:00:00 | MSFT | Stock | 26.99 | 27.02 | 26.95 | 26.96 | 3131436.0 |
| 2006-01-09 14:30:00 | MSFT | Stock | 26.95 | 26.98 | 26.91 | 26.91 | 3737599.0 |
| 2006-01-09 15:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.85 | 26.872 | 3570908.0 |
| 2006-01-09 15:30:00 | MSFT | Stock | 26.87 | 26.93 | 26.82 | 26.86 | 6068844.0 |
| 2006-01-09 16:00:00 | MSFT | Stock | 26.88 | 26.89 | 26.82 | 26.86 | 79568.0 |
| 2006-01-09 16:30:00 | MSFT | Stock | 26.86 | 26.86 | 26.85 | 26.86 | 445654.0 |
| 2006-01-09 17:00:00 | MSFT | Stock | 26.86 | 26.88 | 26.85 | 26.85 | 563.0 |
| 2006-01-09 17:30:00 | MSFT | Stock | 26.87 | 26.87 | 26.87 | 26.87 | 100.0 |
| 2006-01-09 18:00:00 | MSFT | Stock | 26.85 | 26.87 | 26.85 | 26.87 | 2790.0 |
| 2006-01-09 08:00:00 | NVDA | Stock | 0.335 | 0.3352 | 0.335 | 0.3352 | 132000.0 |
| 2006-01-09 08:30:00 | NVDA | Stock | 0.3355 | 0.3355 | 0.3355 | 0.3355 | 24000.0 |
| 2006-01-09 09:00:00 | NVDA | Stock | 0.3387 | 0.3408 | 0.3385 | 0.3408 | 520200.0 |
| 2006-01-09 09:30:00 | NVDA | Stock | 0.3402 | 0.3457 | 0.3394 | 0.3444 | 66948480.0 |
| 2006-01-09 10:00:00 | NVDA | Stock | 0.3441 | 0.347 | 0.3427 | 0.3468 | 43046760.0 |
| 2006-01-09 10:30:00 | NVDA | Stock | 0.3468 | 0.3481 | 0.3456 | 0.3475 | 41725440.0 |
> showing 50 of 48,141 rows — these rows as CSV