PREVIEW / stock_30min / 2006-02-07
file: by_date/stock_30min/2006/2006-02-07.parquet size: 920 KB rows: 48,911 symbols: 2,188
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-07 04:30:00 | AAPL | Stock | 2.3975 | 2.3975 | 2.3971 | 2.3971 | 11200.0 |
| 2006-02-07 05:00:00 | AAPL | Stock | 2.3821 | 2.3821 | 2.3714 | 2.3732 | 53200.0 |
| 2006-02-07 05:30:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3679 | 2.3679 | 106400.0 |
| 2006-02-07 06:00:00 | AAPL | Stock | 2.3714 | 2.3786 | 2.3714 | 2.3714 | 86800.0 |
| 2006-02-07 06:30:00 | AAPL | Stock | 2.3714 | 2.3839 | 2.3714 | 2.375 | 64400.0 |
| 2006-02-07 07:00:00 | AAPL | Stock | 2.3843 | 2.3929 | 2.3821 | 2.3929 | 436408.0 |
| 2006-02-07 07:30:00 | AAPL | Stock | 2.3929 | 2.4018 | 2.3893 | 2.3964 | 200956.0 |
| 2006-02-07 08:00:00 | AAPL | Stock | 2.3954 | 2.4071 | 2.3671 | 2.3829 | 7494004.0 |
| 2006-02-07 08:30:00 | AAPL | Stock | 2.3832 | 2.46 | 2.3832 | 2.46 | 40228804.0 |
| 2006-02-07 09:00:00 | AAPL | Stock | 2.4596 | 2.46 | 2.4357 | 2.4407 | 25081756.0 |
| 2006-02-07 09:30:00 | AAPL | Stock | 2.4375 | 2.4693 | 2.4171 | 2.46 | 266868476.0 |
| 2006-02-07 10:00:00 | AAPL | Stock | 2.4596 | 2.4814 | 2.4268 | 2.4336 | 193368308.0 |
| 2006-02-07 10:30:00 | AAPL | Stock | 2.4336 | 2.4657 | 2.4229 | 2.4521 | 108446296.0 |
| 2006-02-07 11:00:00 | AAPL | Stock | 2.4521 | 2.4607 | 2.4325 | 2.4439 | 83123404.0 |
| 2006-02-07 11:30:00 | AAPL | Stock | 2.4439 | 2.4474 | 2.4254 | 2.4293 | 65929696.0 |
| 2006-02-07 12:00:00 | AAPL | Stock | 2.4286 | 2.4293 | 2.4046 | 2.4115 | 90156948.0 |
| 2006-02-07 12:30:00 | AAPL | Stock | 2.4118 | 2.4257 | 2.3814 | 2.4064 | 105432572.0 |
| 2006-02-07 13:00:00 | AAPL | Stock | 2.4049 | 2.4182 | 2.3871 | 2.4179 | 81665780.0 |
| 2006-02-07 13:30:00 | AAPL | Stock | 2.4179 | 2.4214 | 2.4046 | 2.4139 | 52068380.0 |
| 2006-02-07 14:00:00 | AAPL | Stock | 2.4136 | 2.4343 | 2.4043 | 2.4304 | 48015268.0 |
| 2006-02-07 14:30:00 | AAPL | Stock | 2.4304 | 2.4761 | 2.41 | 2.4131 | 67213188.0 |
| 2006-02-07 15:00:00 | AAPL | Stock | 2.4132 | 2.4275 | 2.4071 | 2.4154 | 59775520.0 |
| 2006-02-07 15:30:00 | AAPL | Stock | 2.4154 | 2.4189 | 2.4004 | 2.4139 | 77875896.0 |
| 2006-02-07 16:00:00 | AAPL | Stock | 2.4143 | 2.4196 | 2.4082 | 2.4171 | 2999668.0 |
| 2006-02-07 16:30:00 | AAPL | Stock | 2.4143 | 2.4243 | 2.4136 | 2.4221 | 999516.0 |
| 2006-02-07 17:00:00 | AAPL | Stock | 2.4229 | 2.4279 | 2.4182 | 2.4268 | 593488.0 |
| 2006-02-07 17:30:00 | AAPL | Stock | 2.425 | 2.425 | 2.4218 | 2.4232 | 319760.0 |
| 2006-02-07 18:00:00 | AAPL | Stock | 2.4239 | 2.4257 | 2.4142 | 2.4257 | 350056.0 |
| 2006-02-07 06:30:00 | MSFT | Stock | 26.73 | 26.73 | 26.14 | 26.14 | 2280.0 |
| 2006-02-07 07:30:00 | MSFT | Stock | 26.97 | 27.05 | 26.97 | 27.05 | 1290.0 |
| 2006-02-07 08:00:00 | MSFT | Stock | 26.98 | 27.04 | 26.97 | 27.0 | 67175.0 |
| 2006-02-07 08:30:00 | MSFT | Stock | 26.99 | 27.03 | 26.91 | 26.94 | 112620.0 |
| 2006-02-07 09:00:00 | MSFT | Stock | 26.95 | 27.17 | 26.94 | 26.95 | 112761.0 |
| 2006-02-07 09:30:00 | MSFT | Stock | 26.94 | 27.07 | 26.9 | 26.98 | 8992050.0 |
| 2006-02-07 10:00:00 | MSFT | Stock | 26.98 | 27.15 | 26.96 | 27.03 | 5773624.0 |
| 2006-02-07 10:30:00 | MSFT | Stock | 27.03 | 27.06 | 26.95 | 27.02 | 3533200.0 |
| 2006-02-07 11:00:00 | MSFT | Stock | 27.02 | 27.1 | 27.0 | 27.05 | 4200315.0 |
| 2006-02-07 11:30:00 | MSFT | Stock | 27.06 | 27.06 | 26.96 | 26.98 | 2358597.0 |
| 2006-02-07 12:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.9 | 26.93 | 3473580.0 |
| 2006-02-07 12:30:00 | MSFT | Stock | 26.93 | 27.05 | 26.9 | 26.94 | 4373870.0 |
| 2006-02-07 13:00:00 | MSFT | Stock | 26.942 | 26.97 | 26.86 | 26.96 | 4235116.0 |
| 2006-02-07 13:30:00 | MSFT | Stock | 26.96 | 26.97 | 26.9 | 26.92 | 2282671.0 |
| 2006-02-07 14:00:00 | MSFT | Stock | 26.92 | 26.93 | 26.85 | 26.9 | 3135802.0 |
| 2006-02-07 14:30:00 | MSFT | Stock | 26.9 | 26.91 | 26.81 | 26.89 | 5360205.0 |
| 2006-02-07 15:00:00 | MSFT | Stock | 26.89 | 26.95 | 26.87 | 26.92 | 3518443.0 |
| 2006-02-07 15:30:00 | MSFT | Stock | 26.92 | 26.98 | 26.9 | 26.94 | 8939107.0 |
| 2006-02-07 16:00:00 | MSFT | Stock | 26.95 | 27.04 | 26.94 | 26.94 | 6909652.0 |
| 2006-02-07 16:30:00 | MSFT | Stock | 27.0 | 27.08 | 27.0 | 27.05 | 27807.0 |
| 2006-02-07 17:00:00 | MSFT | Stock | 27.08 | 27.08 | 27.02 | 27.02 | 29000.0 |
| 2006-02-07 17:30:00 | MSFT | Stock | 27.04 | 27.04 | 27.02 | 27.03 | 13550.0 |
> showing 50 of 48,911 rows — these rows as CSV