PREVIEW / stock_30min / 2005-12-14
file: by_date/stock_30min/2005/2005-12-14.parquet size: 862 KB rows: 46,374 symbols: 2,155
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-12-14 04:00:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6643 | 2.6643 | 8400.0 |
| 2005-12-14 04:30:00 | AAPL | Stock | 2.6532 | 2.6532 | 2.6357 | 2.6357 | 50400.0 |
| 2005-12-14 05:00:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6143 | 2.6161 | 37548.0 |
| 2005-12-14 05:30:00 | AAPL | Stock | 2.6071 | 2.6071 | 2.6071 | 2.6071 | 14000.0 |
| 2005-12-14 06:00:00 | AAPL | Stock | 2.6161 | 2.6321 | 2.6161 | 2.6321 | 36400.0 |
| 2005-12-14 06:30:00 | AAPL | Stock | 2.6193 | 2.6286 | 2.6193 | 2.6286 | 30800.0 |
| 2005-12-14 07:00:00 | AAPL | Stock | 2.6196 | 2.6246 | 2.6068 | 2.6232 | 369628.0 |
| 2005-12-14 07:30:00 | AAPL | Stock | 2.6182 | 2.6279 | 2.6179 | 2.6186 | 859600.0 |
| 2005-12-14 08:00:00 | AAPL | Stock | 2.6211 | 2.6286 | 2.5882 | 2.6021 | 22554532.0 |
| 2005-12-14 08:30:00 | AAPL | Stock | 2.6018 | 2.6025 | 2.5911 | 2.5968 | 9632672.0 |
| 2005-12-14 09:00:00 | AAPL | Stock | 2.5971 | 2.6043 | 2.5904 | 2.5904 | 8730624.0 |
| 2005-12-14 09:30:00 | AAPL | Stock | 2.5904 | 2.6179 | 2.5793 | 2.6025 | 214394040.0 |
| 2005-12-14 10:00:00 | AAPL | Stock | 2.6025 | 2.6036 | 2.5764 | 2.5843 | 125769280.0 |
| 2005-12-14 10:30:00 | AAPL | Stock | 2.5839 | 2.5893 | 2.5486 | 2.5525 | 167391364.0 |
| 2005-12-14 11:00:00 | AAPL | Stock | 2.5514 | 2.5539 | 2.5243 | 2.5339 | 192060372.0 |
| 2005-12-14 11:30:00 | AAPL | Stock | 2.5343 | 2.5686 | 2.5096 | 2.5318 | 114987376.0 |
| 2005-12-14 12:00:00 | AAPL | Stock | 2.5318 | 2.5343 | 2.5214 | 2.5311 | 58137576.0 |
| 2005-12-14 12:30:00 | AAPL | Stock | 2.5311 | 2.6071 | 2.5293 | 2.5461 | 70004648.0 |
| 2005-12-14 13:00:00 | AAPL | Stock | 2.5461 | 2.5536 | 2.5411 | 2.5496 | 47370176.0 |
| 2005-12-14 13:30:00 | AAPL | Stock | 2.5496 | 2.5625 | 2.5496 | 2.5536 | 70698152.0 |
| 2005-12-14 14:00:00 | AAPL | Stock | 2.5536 | 2.5557 | 2.5418 | 2.5439 | 50470504.0 |
| 2005-12-14 14:30:00 | AAPL | Stock | 2.5439 | 2.5521 | 2.5375 | 2.5496 | 52456796.0 |
| 2005-12-14 15:00:00 | AAPL | Stock | 2.55 | 2.5696 | 2.5496 | 2.5657 | 82594736.0 |
| 2005-12-14 15:30:00 | AAPL | Stock | 2.565 | 2.58 | 2.5646 | 2.5725 | 145991524.0 |
| 2005-12-14 16:00:00 | AAPL | Stock | 2.5718 | 2.5761 | 2.5714 | 2.5718 | 1896160.0 |
| 2005-12-14 16:30:00 | AAPL | Stock | 2.5714 | 2.5765 | 2.5671 | 2.5718 | 662116.0 |
| 2005-12-14 17:00:00 | AAPL | Stock | 2.5711 | 2.5718 | 2.5689 | 2.5718 | 470596.0 |
| 2005-12-14 17:30:00 | AAPL | Stock | 2.5718 | 2.5764 | 2.5682 | 2.5714 | 556360.0 |
| 2005-12-14 18:00:00 | AAPL | Stock | 2.5714 | 2.5714 | 2.5643 | 2.5661 | 532644.0 |
| 2005-12-14 05:00:00 | MSFT | Stock | 27.15 | 27.15 | 27.15 | 27.15 | 100.0 |
| 2005-12-14 08:00:00 | MSFT | Stock | 27.1 | 27.12 | 27.0 | 27.08 | 28812.0 |
| 2005-12-14 08:30:00 | MSFT | Stock | 27.09 | 27.09 | 27.08 | 27.08 | 1500.0 |
| 2005-12-14 09:00:00 | MSFT | Stock | 27.08 | 27.08 | 27.0 | 27.0 | 49188.0 |
| 2005-12-14 09:30:00 | MSFT | Stock | 27.0 | 27.08 | 26.86 | 26.9 | 7206079.0 |
| 2005-12-14 10:00:00 | MSFT | Stock | 26.92 | 26.97 | 26.85 | 26.96 | 5940419.0 |
| 2005-12-14 10:30:00 | MSFT | Stock | 26.96 | 26.97 | 26.88 | 26.94 | 5508722.0 |
| 2005-12-14 11:00:00 | MSFT | Stock | 26.94 | 26.971 | 26.9 | 26.97 | 4776480.0 |
| 2005-12-14 11:30:00 | MSFT | Stock | 26.96 | 27.03 | 26.93 | 26.97 | 3396762.0 |
| 2005-12-14 12:00:00 | MSFT | Stock | 26.98 | 27.0 | 26.9 | 26.98 | 3075517.0 |
| 2005-12-14 12:30:00 | MSFT | Stock | 26.98 | 27.08 | 26.97 | 27.07 | 3288172.0 |
| 2005-12-14 13:00:00 | MSFT | Stock | 27.08 | 27.13 | 26.95 | 27.09 | 2690121.0 |
| 2005-12-14 13:30:00 | MSFT | Stock | 27.095 | 27.24 | 27.07 | 27.18 | 4646444.0 |
| 2005-12-14 14:00:00 | MSFT | Stock | 27.19 | 27.22 | 27.13 | 27.14 | 3790949.0 |
| 2005-12-14 14:30:00 | MSFT | Stock | 27.15 | 27.19 | 27.09 | 27.18 | 4213475.0 |
| 2005-12-14 15:00:00 | MSFT | Stock | 27.178 | 27.19 | 27.15 | 27.16 | 3593733.0 |
| 2005-12-14 15:30:00 | MSFT | Stock | 27.16 | 27.17 | 27.04 | 27.1 | 8562771.0 |
| 2005-12-14 16:00:00 | MSFT | Stock | 27.11 | 27.168 | 27.0 | 27.09 | 632875.0 |
| 2005-12-14 16:30:00 | MSFT | Stock | 27.1 | 27.1 | 27.09 | 27.09 | 176635.0 |
| 2005-12-14 17:00:00 | MSFT | Stock | 27.1 | 27.15 | 27.07 | 27.09 | 35620.0 |
| 2005-12-14 17:30:00 | MSFT | Stock | 27.09 | 27.1 | 27.07 | 27.08 | 5826.0 |
> showing 50 of 46,374 rows — these rows as CSV