PREVIEW / stock_30min / 2006-05-02
file: by_date/stock_30min/2006/2006-05-02.parquet size: 912 KB rows: 49,211 symbols: 2,255
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-05-02 06:00:00 | AAPL | Stock | 2.5071 | 2.5157 | 2.5071 | 2.5157 | 8400.0 |
| 2006-05-02 08:00:00 | AAPL | Stock | 2.5096 | 2.5179 | 2.5018 | 2.5139 | 1762180.0 |
| 2006-05-02 08:30:00 | AAPL | Stock | 2.5132 | 2.5164 | 2.5114 | 2.5136 | 1385244.0 |
| 2006-05-02 09:00:00 | AAPL | Stock | 2.5136 | 2.5175 | 2.4907 | 2.5054 | 3598532.0 |
| 2006-05-02 09:30:00 | AAPL | Stock | 2.5054 | 2.5311 | 2.5039 | 2.5271 | 94813348.0 |
| 2006-05-02 10:00:00 | AAPL | Stock | 2.5268 | 2.5646 | 2.5257 | 2.5614 | 140440048.0 |
| 2006-05-02 10:30:00 | AAPL | Stock | 2.5618 | 2.5707 | 2.5464 | 2.5607 | 86945292.0 |
| 2006-05-02 11:00:00 | AAPL | Stock | 2.5607 | 2.5625 | 2.5296 | 2.5374 | 74714612.0 |
| 2006-05-02 11:30:00 | AAPL | Stock | 2.5371 | 2.5486 | 2.5357 | 2.5468 | 45902164.0 |
| 2006-05-02 12:00:00 | AAPL | Stock | 2.5471 | 2.5532 | 2.5414 | 2.5418 | 27088572.0 |
| 2006-05-02 12:30:00 | AAPL | Stock | 2.5417 | 2.5589 | 2.5371 | 2.5532 | 37554636.0 |
| 2006-05-02 13:00:00 | AAPL | Stock | 2.5532 | 2.5571 | 2.5471 | 2.5571 | 22407728.0 |
| 2006-05-02 13:30:00 | AAPL | Stock | 2.5571 | 2.5661 | 2.5486 | 2.5517 | 26460980.0 |
| 2006-05-02 14:00:00 | AAPL | Stock | 2.5514 | 2.5571 | 2.55 | 2.5507 | 27431768.0 |
| 2006-05-02 14:30:00 | AAPL | Stock | 2.5507 | 2.5543 | 2.5432 | 2.55 | 37407412.0 |
| 2006-05-02 15:00:00 | AAPL | Stock | 2.55 | 2.5625 | 2.5468 | 2.5614 | 43838760.0 |
| 2006-05-02 15:30:00 | AAPL | Stock | 2.5618 | 2.5693 | 2.5543 | 2.5575 | 80218712.0 |
| 2006-05-02 16:00:00 | AAPL | Stock | 2.5575 | 2.5586 | 2.5554 | 2.5571 | 2112348.0 |
| 2006-05-02 16:30:00 | AAPL | Stock | 2.5579 | 2.5614 | 2.5554 | 2.5614 | 719516.0 |
| 2006-05-02 17:00:00 | AAPL | Stock | 2.5607 | 2.5618 | 2.5607 | 2.5618 | 96320.0 |
| 2006-05-02 17:30:00 | AAPL | Stock | 2.5611 | 2.5621 | 2.5593 | 2.5614 | 234444.0 |
| 2006-05-02 18:00:00 | AAPL | Stock | 2.5614 | 2.5614 | 2.5579 | 2.5589 | 311136.0 |
| 2006-05-02 04:00:00 | MSFT | Stock | 24.58 | 24.6 | 24.43 | 24.6 | 700.0 |
| 2006-05-02 04:30:00 | MSFT | Stock | 24.63 | 24.63 | 24.63 | 24.63 | 500.0 |
| 2006-05-02 05:00:00 | MSFT | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 100.0 |
| 2006-05-02 05:30:00 | MSFT | Stock | 24.65 | 24.66 | 24.65 | 24.66 | 3000.0 |
| 2006-05-02 06:00:00 | MSFT | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 100.0 |
| 2006-05-02 06:30:00 | MSFT | Stock | 24.62 | 24.62 | 24.61 | 24.61 | 6400.0 |
| 2006-05-02 07:00:00 | MSFT | Stock | 24.63 | 24.67 | 24.54 | 24.54 | 14850.0 |
| 2006-05-02 07:30:00 | MSFT | Stock | 24.52 | 24.52 | 24.5 | 24.51 | 23320.0 |
| 2006-05-02 08:00:00 | MSFT | Stock | 24.5 | 24.5 | 24.43 | 24.46 | 125185.0 |
| 2006-05-02 08:30:00 | MSFT | Stock | 24.45 | 24.48 | 24.45 | 24.47 | 134212.0 |
| 2006-05-02 09:00:00 | MSFT | Stock | 24.47 | 24.5 | 24.44 | 24.48 | 813162.0 |
| 2006-05-02 09:30:00 | MSFT | Stock | 24.49 | 25.0 | 24.31 | 24.338 | 21462560.0 |
| 2006-05-02 10:00:00 | MSFT | Stock | 24.34 | 24.36 | 24.19 | 24.239 | 16896746.0 |
| 2006-05-02 10:30:00 | MSFT | Stock | 24.24 | 24.485 | 24.15 | 24.19 | 12510755.0 |
| 2006-05-02 11:00:00 | MSFT | Stock | 24.19 | 24.24 | 24.15 | 24.17 | 11414286.0 |
| 2006-05-02 11:30:00 | MSFT | Stock | 24.17 | 24.2 | 24.05 | 24.07 | 16100546.0 |
| 2006-05-02 12:00:00 | MSFT | Stock | 24.08 | 24.13 | 24.06 | 24.07 | 9173444.0 |
| 2006-05-02 12:30:00 | MSFT | Stock | 24.08 | 24.11 | 24.0 | 24.01 | 11461659.0 |
| 2006-05-02 13:00:00 | MSFT | Stock | 24.01 | 24.11 | 23.97 | 24.06 | 16340974.0 |
| 2006-05-02 13:30:00 | MSFT | Stock | 24.06 | 24.15 | 23.91 | 24.03 | 8459941.0 |
| 2006-05-02 14:00:00 | MSFT | Stock | 24.03 | 24.15 | 23.94 | 23.94 | 14207453.0 |
| 2006-05-02 14:30:00 | MSFT | Stock | 23.95 | 24.02 | 23.9 | 23.95 | 13355730.0 |
| 2006-05-02 15:00:00 | MSFT | Stock | 23.96 | 24.04 | 23.9 | 24.02 | 16977268.0 |
| 2006-05-02 15:30:00 | MSFT | Stock | 24.02 | 24.1 | 23.96 | 24.01 | 17357396.0 |
| 2006-05-02 16:00:00 | MSFT | Stock | 24.02 | 24.04 | 23.99 | 24.01 | 354353.0 |
| 2006-05-02 16:30:00 | MSFT | Stock | 24.0 | 24.029 | 23.99 | 24.01 | 199640.0 |
| 2006-05-02 17:00:00 | MSFT | Stock | 24.01 | 24.01 | 24.0 | 24.0 | 27833.0 |
| 2006-05-02 17:30:00 | MSFT | Stock | 24.01 | 24.01 | 23.99 | 24.01 | 11998.0 |
> showing 50 of 49,211 rows — these rows as CSV