PREVIEW / stock_30min / 2010-12-09
file: by_date/stock_30min/2010/2010-12-09.parquet size: 1.4 MB rows: 75,300 symbols: 3,519
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-09 04:00:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4643 | 11.4643 | 5600.0 |
| 2010-12-09 04:30:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4493 | 11.4493 | 33600.0 |
| 2010-12-09 05:00:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 14000.0 |
| 2010-12-09 05:30:00 | AAPL | Stock | 11.4589 | 11.4632 | 11.4539 | 11.4607 | 49644.0 |
| 2010-12-09 06:00:00 | AAPL | Stock | 11.4679 | 11.475 | 11.4486 | 11.4554 | 128800.0 |
| 2010-12-09 06:30:00 | AAPL | Stock | 11.4675 | 11.4743 | 11.4675 | 11.4743 | 11200.0 |
| 2010-12-09 07:00:00 | AAPL | Stock | 11.4821 | 11.53 | 11.4818 | 11.5125 | 209132.0 |
| 2010-12-09 07:30:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5036 | 11.5107 | 219520.0 |
| 2010-12-09 08:00:00 | AAPL | Stock | 11.5054 | 11.5132 | 11.4964 | 11.5043 | 1779036.0 |
| 2010-12-09 08:30:00 | AAPL | Stock | 11.5071 | 11.5293 | 11.5043 | 11.5268 | 2385908.0 |
| 2010-12-09 09:00:00 | AAPL | Stock | 11.5268 | 11.5321 | 11.5039 | 11.5046 | 1854804.0 |
| 2010-12-09 09:30:00 | AAPL | Stock | 11.5061 | 11.5179 | 11.4364 | 11.465 | 53848228.0 |
| 2010-12-09 10:00:00 | AAPL | Stock | 11.465 | 11.4732 | 11.4493 | 11.4629 | 29740816.0 |
| 2010-12-09 10:30:00 | AAPL | Stock | 11.4618 | 11.4714 | 11.4132 | 11.4236 | 29651076.0 |
| 2010-12-09 11:00:00 | AAPL | Stock | 11.4239 | 11.4514 | 11.4189 | 11.4361 | 15505308.0 |
| 2010-12-09 11:30:00 | AAPL | Stock | 11.4382 | 11.4482 | 11.4054 | 11.4257 | 16894416.0 |
| 2010-12-09 12:00:00 | AAPL | Stock | 11.4261 | 11.4375 | 11.4093 | 11.4243 | 10871140.0 |
| 2010-12-09 12:30:00 | AAPL | Stock | 11.4243 | 11.4425 | 11.4182 | 11.4379 | 9439612.0 |
| 2010-12-09 13:00:00 | AAPL | Stock | 11.4371 | 11.4514 | 11.4311 | 11.4369 | 14768460.0 |
| 2010-12-09 13:30:00 | AAPL | Stock | 11.4364 | 11.4432 | 11.4289 | 11.4368 | 8320648.0 |
| 2010-12-09 14:00:00 | AAPL | Stock | 11.4368 | 11.4393 | 11.4068 | 11.4146 | 17794532.0 |
| 2010-12-09 14:30:00 | AAPL | Stock | 11.4161 | 11.4179 | 11.3936 | 11.4168 | 18953256.0 |
| 2010-12-09 15:00:00 | AAPL | Stock | 11.4168 | 11.4279 | 11.4082 | 11.4118 | 13564628.0 |
| 2010-12-09 15:30:00 | AAPL | Stock | 11.4118 | 11.4461 | 11.4032 | 11.4246 | 36518076.0 |
| 2010-12-09 16:00:00 | AAPL | Stock | 11.4268 | 11.4961 | 11.4054 | 11.4961 | 6726860.0 |
| 2010-12-09 16:30:00 | AAPL | Stock | 11.4064 | 11.4421 | 11.4064 | 11.4107 | 224308.0 |
| 2010-12-09 17:00:00 | AAPL | Stock | 11.4107 | 11.4143 | 11.4071 | 11.4071 | 123396.0 |
| 2010-12-09 17:30:00 | AAPL | Stock | 11.4179 | 11.4646 | 11.4071 | 11.4071 | 107380.0 |
| 2010-12-09 18:00:00 | AAPL | Stock | 11.4175 | 11.42 | 11.4107 | 11.4143 | 108612.0 |
| 2010-12-09 18:30:00 | AAPL | Stock | 11.4232 | 11.4257 | 11.4186 | 11.4257 | 139720.0 |
| 2010-12-09 19:00:00 | AAPL | Stock | 11.425 | 11.4282 | 11.4161 | 11.4214 | 227220.0 |
| 2010-12-09 19:30:00 | AAPL | Stock | 11.4214 | 11.4214 | 11.4161 | 11.4161 | 48048.0 |
| 2010-12-09 04:00:00 | MSFT | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 100.0 |
| 2010-12-09 05:30:00 | MSFT | Stock | 27.32 | 27.32 | 27.32 | 27.32 | 6000.0 |
| 2010-12-09 06:00:00 | MSFT | Stock | 27.32 | 27.34 | 27.32 | 27.34 | 2900.0 |
| 2010-12-09 06:30:00 | MSFT | Stock | 27.33 | 27.33 | 27.32 | 27.32 | 2000.0 |
| 2010-12-09 07:00:00 | MSFT | Stock | 27.32 | 27.32 | 27.27 | 27.32 | 3750.0 |
| 2010-12-09 07:30:00 | MSFT | Stock | 27.3 | 27.39 | 27.3 | 27.39 | 15290.0 |
| 2010-12-09 08:00:00 | MSFT | Stock | 27.37 | 27.37 | 27.31 | 27.31 | 9216.0 |
| 2010-12-09 08:30:00 | MSFT | Stock | 27.35 | 27.4 | 27.23 | 27.4 | 63999.0 |
| 2010-12-09 09:00:00 | MSFT | Stock | 27.41 | 27.41 | 27.27 | 27.29 | 135256.0 |
| 2010-12-09 09:30:00 | MSFT | Stock | 27.29 | 27.34 | 27.1 | 27.29 | 7214439.0 |
| 2010-12-09 10:00:00 | MSFT | Stock | 27.3 | 27.3 | 27.04 | 27.06 | 5231211.0 |
| 2010-12-09 10:30:00 | MSFT | Stock | 27.06 | 27.11 | 27.01 | 27.08 | 4160169.0 |
| 2010-12-09 11:00:00 | MSFT | Stock | 27.075 | 27.115 | 27.03 | 27.1 | 2780611.0 |
| 2010-12-09 11:30:00 | MSFT | Stock | 27.1 | 27.13 | 27.065 | 27.13 | 2522994.0 |
| 2010-12-09 12:00:00 | MSFT | Stock | 27.12 | 27.2 | 27.12 | 27.16 | 2295235.0 |
| 2010-12-09 12:30:00 | MSFT | Stock | 27.161 | 27.17 | 27.09 | 27.12 | 1825079.0 |
| 2010-12-09 13:00:00 | MSFT | Stock | 27.13 | 27.19 | 27.12 | 27.135 | 1681304.0 |
| 2010-12-09 13:30:00 | MSFT | Stock | 27.135 | 27.165 | 27.1 | 27.16 | 1611377.0 |
> showing 50 of 75,300 rows — these rows as CSV