PREVIEW / stock_30min / 2005-08-22
file: by_date/stock_30min/2005/2005-08-22.parquet size: 835 KB rows: 45,496 symbols: 2,076
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-08-22 08:00:00 | AAPL | Stock | 1.6582 | 1.6582 | 1.6439 | 1.65 | 260400.0 |
| 2005-08-22 08:30:00 | AAPL | Stock | 1.6493 | 1.6496 | 1.6446 | 1.6464 | 115304.0 |
| 2005-08-22 09:00:00 | AAPL | Stock | 1.6464 | 1.6496 | 1.6429 | 1.6482 | 500752.0 |
| 2005-08-22 09:30:00 | AAPL | Stock | 1.6482 | 1.6654 | 1.6464 | 1.6614 | 60393032.0 |
| 2005-08-22 10:00:00 | AAPL | Stock | 1.6618 | 1.6696 | 1.6604 | 1.665 | 36979096.0 |
| 2005-08-22 10:30:00 | AAPL | Stock | 1.665 | 1.6686 | 1.6596 | 1.6629 | 22446116.0 |
| 2005-08-22 11:00:00 | AAPL | Stock | 1.6623 | 1.6636 | 1.6504 | 1.6536 | 27248480.0 |
| 2005-08-22 11:30:00 | AAPL | Stock | 1.6536 | 1.6568 | 1.6446 | 1.6461 | 18427528.0 |
| 2005-08-22 12:00:00 | AAPL | Stock | 1.6457 | 1.6486 | 1.6375 | 1.6396 | 27927060.0 |
| 2005-08-22 12:30:00 | AAPL | Stock | 1.6396 | 1.6471 | 1.6214 | 1.6282 | 45154032.0 |
| 2005-08-22 13:00:00 | AAPL | Stock | 1.6279 | 1.6286 | 1.6164 | 1.6271 | 29904140.0 |
| 2005-08-22 13:30:00 | AAPL | Stock | 1.6271 | 1.64 | 1.625 | 1.6375 | 22614620.0 |
| 2005-08-22 14:00:00 | AAPL | Stock | 1.6379 | 1.6379 | 1.6264 | 1.6296 | 15732948.0 |
| 2005-08-22 14:30:00 | AAPL | Stock | 1.6296 | 1.6325 | 1.6264 | 1.6293 | 11584972.0 |
| 2005-08-22 15:00:00 | AAPL | Stock | 1.6293 | 1.6371 | 1.6271 | 1.6318 | 24677968.0 |
| 2005-08-22 15:30:00 | AAPL | Stock | 1.6318 | 1.6393 | 1.6314 | 1.6379 | 37201836.0 |
| 2005-08-22 16:00:00 | AAPL | Stock | 1.6382 | 1.645 | 1.6375 | 1.6414 | 1708952.0 |
| 2005-08-22 16:30:00 | AAPL | Stock | 1.6418 | 1.6429 | 1.6414 | 1.6429 | 113204.0 |
| 2005-08-22 17:00:00 | AAPL | Stock | 1.6432 | 1.6432 | 1.6382 | 1.6382 | 167608.0 |
| 2005-08-22 17:30:00 | AAPL | Stock | 1.6418 | 1.6636 | 1.6375 | 1.6636 | 282128.0 |
| 2005-08-22 18:00:00 | AAPL | Stock | 1.6411 | 1.6425 | 1.6411 | 1.6425 | 28000.0 |
| 2005-08-22 08:00:00 | MSFT | Stock | 26.75 | 26.85 | 26.52 | 26.85 | 2700.0 |
| 2005-08-22 08:30:00 | MSFT | Stock | 26.81 | 26.82 | 26.78 | 26.8 | 6650.0 |
| 2005-08-22 09:00:00 | MSFT | Stock | 26.8 | 26.81 | 26.73 | 26.79 | 34351.0 |
| 2005-08-22 09:30:00 | MSFT | Stock | 26.79 | 27.02 | 26.77 | 26.99 | 5623624.0 |
| 2005-08-22 10:00:00 | MSFT | Stock | 27.0 | 27.14 | 26.99 | 27.12 | 4331949.0 |
| 2005-08-22 10:30:00 | MSFT | Stock | 27.12 | 27.17 | 27.1 | 27.11 | 2983808.0 |
| 2005-08-22 11:00:00 | MSFT | Stock | 27.12 | 27.13 | 26.99 | 27.01 | 3856753.0 |
| 2005-08-22 11:30:00 | MSFT | Stock | 27.002 | 27.05 | 26.92 | 26.97 | 2783377.0 |
| 2005-08-22 12:00:00 | MSFT | Stock | 26.97 | 26.98 | 26.9 | 26.91 | 2511030.0 |
| 2005-08-22 12:30:00 | MSFT | Stock | 26.91 | 26.91 | 26.8 | 26.87 | 4050448.0 |
| 2005-08-22 13:00:00 | MSFT | Stock | 26.86 | 26.88 | 26.79 | 26.85 | 1867456.0 |
| 2005-08-22 13:30:00 | MSFT | Stock | 26.85 | 26.93 | 26.822 | 26.93 | 1766295.0 |
| 2005-08-22 14:00:00 | MSFT | Stock | 26.93 | 26.94 | 26.8 | 26.87 | 2641254.0 |
| 2005-08-22 14:30:00 | MSFT | Stock | 26.86 | 26.89 | 26.82 | 26.88 | 2147029.0 |
| 2005-08-22 15:00:00 | MSFT | Stock | 26.878 | 26.88 | 26.79 | 26.8 | 2246313.0 |
| 2005-08-22 15:30:00 | MSFT | Stock | 26.81 | 26.92 | 26.81 | 26.89 | 3556511.0 |
| 2005-08-22 16:00:00 | MSFT | Stock | 26.88 | 26.934 | 26.869 | 26.93 | 481379.0 |
| 2005-08-22 16:30:00 | MSFT | Stock | 26.92 | 26.92 | 26.91 | 26.92 | 517.0 |
| 2005-08-22 17:00:00 | MSFT | Stock | 26.91 | 26.947 | 26.9 | 26.947 | 14947.0 |
| 2005-08-22 17:30:00 | MSFT | Stock | 26.92 | 27.12 | 26.9 | 27.12 | 37309.0 |
| 2005-08-22 18:00:00 | MSFT | Stock | 26.91 | 26.91 | 26.91 | 26.91 | 100.0 |
| 2005-08-22 08:00:00 | NVDA | Stock | 0.2433 | 0.2434 | 0.2417 | 0.2434 | 147360.0 |
| 2005-08-22 08:30:00 | NVDA | Stock | 0.2433 | 0.2433 | 0.2433 | 0.2433 | 12000.0 |
| 2005-08-22 09:00:00 | NVDA | Stock | 0.2433 | 0.2433 | 0.2433 | 0.2433 | 92640.0 |
| 2005-08-22 09:30:00 | NVDA | Stock | 0.2429 | 0.2451 | 0.2429 | 0.2446 | 91376880.0 |
| 2005-08-22 10:00:00 | NVDA | Stock | 0.2446 | 0.2458 | 0.2443 | 0.2457 | 51004680.0 |
| 2005-08-22 10:30:00 | NVDA | Stock | 0.2457 | 0.2468 | 0.2443 | 0.2452 | 42676200.0 |
| 2005-08-22 11:00:00 | NVDA | Stock | 0.2452 | 0.2453 | 0.2425 | 0.2438 | 41416680.0 |
| 2005-08-22 11:30:00 | NVDA | Stock | 0.2438 | 0.244 | 0.2412 | 0.2414 | 22724880.0 |
> showing 50 of 45,496 rows — these rows as CSV