PREVIEW / stock_30min / 2010-12-10
file: by_date/stock_30min/2010/2010-12-10.parquet size: 1.4 MB rows: 76,286 symbols: 3,534
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-10 05:00:00 | AAPL | Stock | 11.4786 | 11.4786 | 11.4786 | 11.4786 | 2800.0 |
| 2010-12-10 06:30:00 | AAPL | Stock | 11.4779 | 11.4779 | 11.42 | 11.42 | 19600.0 |
| 2010-12-10 07:00:00 | AAPL | Stock | 11.4411 | 11.4482 | 11.4286 | 11.4286 | 28000.0 |
| 2010-12-10 07:30:00 | AAPL | Stock | 11.4286 | 11.4536 | 11.4286 | 11.4464 | 117600.0 |
| 2010-12-10 08:00:00 | AAPL | Stock | 11.4464 | 11.4518 | 11.4357 | 11.4429 | 512036.0 |
| 2010-12-10 08:30:00 | AAPL | Stock | 11.4457 | 11.4457 | 11.4061 | 11.4071 | 871836.0 |
| 2010-12-10 09:00:00 | AAPL | Stock | 11.4071 | 11.4282 | 11.3946 | 11.4143 | 522760.0 |
| 2010-12-10 09:30:00 | AAPL | Stock | 11.4143 | 11.45 | 11.3846 | 11.3957 | 38605532.0 |
| 2010-12-10 10:00:00 | AAPL | Stock | 11.3957 | 11.4315 | 11.3786 | 11.4236 | 29475488.0 |
| 2010-12-10 10:30:00 | AAPL | Stock | 11.4246 | 11.4357 | 11.4114 | 11.425 | 14021476.0 |
| 2010-12-10 11:00:00 | AAPL | Stock | 11.4243 | 11.4411 | 11.4157 | 11.4239 | 13403376.0 |
| 2010-12-10 11:30:00 | AAPL | Stock | 11.4239 | 11.4339 | 11.4179 | 11.4332 | 8600480.0 |
| 2010-12-10 12:00:00 | AAPL | Stock | 11.4329 | 11.4357 | 11.4246 | 11.4325 | 7129780.0 |
| 2010-12-10 12:30:00 | AAPL | Stock | 11.4329 | 11.4482 | 11.4268 | 11.4346 | 14649684.0 |
| 2010-12-10 13:00:00 | AAPL | Stock | 11.4343 | 11.4518 | 11.4307 | 11.4471 | 11698680.0 |
| 2010-12-10 13:30:00 | AAPL | Stock | 11.4471 | 11.4661 | 11.4436 | 11.4632 | 18845344.0 |
| 2010-12-10 14:00:00 | AAPL | Stock | 11.4621 | 11.4632 | 11.4411 | 11.4411 | 16655940.0 |
| 2010-12-10 14:30:00 | AAPL | Stock | 11.4411 | 11.4514 | 11.4382 | 11.4448 | 12424748.0 |
| 2010-12-10 15:00:00 | AAPL | Stock | 11.4457 | 11.4489 | 11.4322 | 11.4411 | 16941456.0 |
| 2010-12-10 15:30:00 | AAPL | Stock | 11.4414 | 11.4518 | 11.43 | 11.45 | 41806856.0 |
| 2010-12-10 16:00:00 | AAPL | Stock | 11.4482 | 11.4514 | 11.4069 | 11.4364 | 8202600.0 |
| 2010-12-10 16:30:00 | AAPL | Stock | 11.4404 | 11.4482 | 11.4304 | 11.4339 | 1078000.0 |
| 2010-12-10 17:00:00 | AAPL | Stock | 11.4339 | 11.4375 | 11.4339 | 11.4375 | 77000.0 |
| 2010-12-10 17:30:00 | AAPL | Stock | 11.4375 | 11.4414 | 11.4357 | 11.4411 | 80584.0 |
| 2010-12-10 18:00:00 | AAPL | Stock | 11.4393 | 11.4486 | 11.4375 | 11.4393 | 114324.0 |
| 2010-12-10 18:30:00 | AAPL | Stock | 11.4429 | 11.4429 | 11.4386 | 11.4386 | 6916.0 |
| 2010-12-10 19:00:00 | AAPL | Stock | 11.4457 | 11.4457 | 11.4454 | 11.4454 | 8400.0 |
| 2010-12-10 19:30:00 | AAPL | Stock | 11.4393 | 11.4421 | 11.4382 | 11.4421 | 47852.0 |
| 2010-12-10 04:00:00 | MSFT | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 100.0 |
| 2010-12-10 07:00:00 | MSFT | Stock | 27.08 | 27.08 | 27.08 | 27.08 | 200.0 |
| 2010-12-10 07:30:00 | MSFT | Stock | 27.09 | 27.1 | 27.0 | 27.0 | 13500.0 |
| 2010-12-10 08:00:00 | MSFT | Stock | 27.05 | 27.11 | 27.01 | 27.1 | 14366.0 |
| 2010-12-10 08:30:00 | MSFT | Stock | 27.11 | 27.14 | 27.07 | 27.08 | 5317.0 |
| 2010-12-10 09:00:00 | MSFT | Stock | 27.06 | 27.22 | 27.06 | 27.19 | 97761.0 |
| 2010-12-10 09:30:00 | MSFT | Stock | 27.18 | 27.25 | 27.11 | 27.2 | 4264684.0 |
| 2010-12-10 10:00:00 | MSFT | Stock | 27.205 | 27.29 | 27.198 | 27.23 | 3239223.0 |
| 2010-12-10 10:30:00 | MSFT | Stock | 27.235 | 27.25 | 27.21 | 27.225 | 2334435.0 |
| 2010-12-10 11:00:00 | MSFT | Stock | 27.225 | 27.26 | 27.21 | 27.26 | 2447362.0 |
| 2010-12-10 11:30:00 | MSFT | Stock | 27.26 | 27.38 | 27.25 | 27.38 | 1799506.0 |
| 2010-12-10 12:00:00 | MSFT | Stock | 27.38 | 27.38 | 27.33 | 27.36 | 1483172.0 |
| 2010-12-10 12:30:00 | MSFT | Stock | 27.362 | 27.4 | 27.34 | 27.36 | 1922493.0 |
| 2010-12-10 13:00:00 | MSFT | Stock | 27.355 | 27.36 | 27.31 | 27.33 | 1480948.0 |
| 2010-12-10 13:30:00 | MSFT | Stock | 27.33 | 27.37 | 27.32 | 27.36 | 1476542.0 |
| 2010-12-10 14:00:00 | MSFT | Stock | 27.36 | 27.38 | 27.33 | 27.35 | 1492317.0 |
| 2010-12-10 14:30:00 | MSFT | Stock | 27.35 | 27.38 | 27.345 | 27.38 | 1064585.0 |
| 2010-12-10 15:00:00 | MSFT | Stock | 27.372 | 27.38 | 27.32 | 27.35 | 3561002.0 |
| 2010-12-10 15:30:00 | MSFT | Stock | 27.358 | 27.4 | 27.32 | 27.34 | 7127029.0 |
| 2010-12-10 16:00:00 | MSFT | Stock | 27.34 | 27.44 | 27.1 | 27.42 | 2401164.0 |
| 2010-12-10 16:30:00 | MSFT | Stock | 27.41 | 27.41 | 27.34 | 27.34 | 44615.0 |
| 2010-12-10 17:00:00 | MSFT | Stock | 27.42 | 27.42 | 27.4 | 27.4 | 1250.0 |
> showing 50 of 76,286 rows — these rows as CSV