PREVIEW / stock_30min / 2006-02-27
file: by_date/stock_30min/2006/2006-02-27.parquet size: 899 KB rows: 48,395 symbols: 2,199
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-02-27 04:00:00 | AAPL | Stock | 2.5589 | 2.5589 | 2.5589 | 2.5589 | 2800.0 |
| 2006-02-27 06:00:00 | AAPL | Stock | 2.5696 | 2.5696 | 2.5696 | 2.5696 | 14000.0 |
| 2006-02-27 07:00:00 | AAPL | Stock | 2.5625 | 2.5625 | 2.5554 | 2.5554 | 109200.0 |
| 2006-02-27 07:30:00 | AAPL | Stock | 2.5575 | 2.5625 | 2.5575 | 2.5625 | 92400.0 |
| 2006-02-27 08:00:00 | AAPL | Stock | 2.5589 | 2.5786 | 2.5589 | 2.5721 | 2060968.0 |
| 2006-02-27 08:30:00 | AAPL | Stock | 2.5718 | 2.5736 | 2.5521 | 2.5725 | 1466808.0 |
| 2006-02-27 09:00:00 | AAPL | Stock | 2.5732 | 2.5771 | 2.5643 | 2.5725 | 5044592.0 |
| 2006-02-27 09:30:00 | AAPL | Stock | 2.5711 | 2.5757 | 2.5304 | 2.5586 | 152920348.0 |
| 2006-02-27 10:00:00 | AAPL | Stock | 2.5589 | 2.5643 | 2.5232 | 2.5361 | 97313188.0 |
| 2006-02-27 10:30:00 | AAPL | Stock | 2.5361 | 2.5411 | 2.5271 | 2.5282 | 43239028.0 |
| 2006-02-27 11:00:00 | AAPL | Stock | 2.5286 | 2.5707 | 2.5264 | 2.5679 | 87831576.0 |
| 2006-02-27 11:30:00 | AAPL | Stock | 2.5686 | 2.5746 | 2.5596 | 2.5646 | 56533316.0 |
| 2006-02-27 12:00:00 | AAPL | Stock | 2.5646 | 2.5696 | 2.5425 | 2.5429 | 48329148.0 |
| 2006-02-27 12:30:00 | AAPL | Stock | 2.5425 | 2.5432 | 2.5329 | 2.5332 | 55068524.0 |
| 2006-02-27 13:00:00 | AAPL | Stock | 2.5332 | 2.5475 | 2.5332 | 2.5425 | 44945432.0 |
| 2006-02-27 13:30:00 | AAPL | Stock | 2.5425 | 2.55 | 2.5425 | 2.5475 | 25344088.0 |
| 2006-02-27 14:00:00 | AAPL | Stock | 2.5475 | 2.555 | 2.5389 | 2.5429 | 32257260.0 |
| 2006-02-27 14:30:00 | AAPL | Stock | 2.5429 | 2.5457 | 2.5375 | 2.5407 | 24184328.0 |
| 2006-02-27 15:00:00 | AAPL | Stock | 2.5411 | 2.5479 | 2.5393 | 2.5418 | 28680596.0 |
| 2006-02-27 15:30:00 | AAPL | Stock | 2.5421 | 2.5446 | 2.5275 | 2.5336 | 67133836.0 |
| 2006-02-27 16:00:00 | AAPL | Stock | 2.5321 | 2.5346 | 2.5279 | 2.5304 | 4893616.0 |
| 2006-02-27 16:30:00 | AAPL | Stock | 2.5296 | 2.5357 | 2.5296 | 2.535 | 625016.0 |
| 2006-02-27 17:00:00 | AAPL | Stock | 2.5357 | 2.5371 | 2.5339 | 2.5364 | 447860.0 |
| 2006-02-27 17:30:00 | AAPL | Stock | 2.5364 | 2.5386 | 2.5325 | 2.5339 | 561456.0 |
| 2006-02-27 18:00:00 | AAPL | Stock | 2.5357 | 2.5364 | 2.5343 | 2.5364 | 124600.0 |
| 2006-02-27 07:00:00 | MSFT | Stock | 26.63 | 26.63 | 26.63 | 26.63 | 1000.0 |
| 2006-02-27 08:00:00 | MSFT | Stock | 26.69 | 26.7 | 26.64 | 26.68 | 14803.0 |
| 2006-02-27 08:30:00 | MSFT | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 1700.0 |
| 2006-02-27 09:00:00 | MSFT | Stock | 26.67 | 26.77 | 26.66 | 26.74 | 102801.0 |
| 2006-02-27 09:30:00 | MSFT | Stock | 26.75 | 26.89 | 26.67 | 26.88 | 4847675.0 |
| 2006-02-27 10:00:00 | MSFT | Stock | 26.88 | 26.95 | 26.82 | 26.832 | 3979708.0 |
| 2006-02-27 10:30:00 | MSFT | Stock | 26.83 | 26.93 | 26.83 | 26.89 | 2125257.0 |
| 2006-02-27 11:00:00 | MSFT | Stock | 26.89 | 27.0 | 26.87 | 26.99 | 2966977.0 |
| 2006-02-27 11:30:00 | MSFT | Stock | 26.99 | 27.001 | 26.96 | 26.98 | 2813389.0 |
| 2006-02-27 12:00:00 | MSFT | Stock | 26.98 | 27.11 | 26.98 | 27.1 | 5040978.0 |
| 2006-02-27 12:30:00 | MSFT | Stock | 27.09 | 27.1 | 27.04 | 27.07 | 1712168.0 |
| 2006-02-27 13:00:00 | MSFT | Stock | 27.07 | 27.13 | 27.069 | 27.11 | 2082514.0 |
| 2006-02-27 13:30:00 | MSFT | Stock | 27.11 | 27.19 | 27.09 | 27.15 | 2760417.0 |
| 2006-02-27 14:00:00 | MSFT | Stock | 27.16 | 27.21 | 27.11 | 27.13 | 2763782.0 |
| 2006-02-27 14:30:00 | MSFT | Stock | 27.13 | 27.14 | 27.09 | 27.132 | 3447113.0 |
| 2006-02-27 15:00:00 | MSFT | Stock | 27.13 | 27.26 | 27.12 | 27.17 | 5970246.0 |
| 2006-02-27 15:30:00 | MSFT | Stock | 27.18 | 27.18 | 27.03 | 27.05 | 8148500.0 |
| 2006-02-27 16:00:00 | MSFT | Stock | 27.05 | 27.15 | 27.05 | 27.06 | 328834.0 |
| 2006-02-27 16:30:00 | MSFT | Stock | 27.05 | 27.1 | 27.05 | 27.05 | 72042.0 |
| 2006-02-27 17:00:00 | MSFT | Stock | 27.11 | 27.11 | 27.05 | 27.07 | 43774.0 |
| 2006-02-27 17:30:00 | MSFT | Stock | 27.05 | 27.1 | 27.05 | 27.07 | 23677.0 |
| 2006-02-27 18:00:00 | MSFT | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 115000.0 |
| 2006-02-27 09:00:00 | NVDA | Stock | 0.3827 | 0.3832 | 0.3814 | 0.3832 | 260400.0 |
| 2006-02-27 09:30:00 | NVDA | Stock | 0.3833 | 0.3866 | 0.3827 | 0.3827 | 44201400.0 |
| 2006-02-27 10:00:00 | NVDA | Stock | 0.3827 | 0.3833 | 0.3794 | 0.3801 | 32554320.0 |
> showing 50 of 48,395 rows — these rows as CSV