PREVIEW / stock_30min / 2008-02-15
file: by_date/stock_30min/2008/2008-02-15.parquet size: 1.2 MB rows: 71,074 symbols: 3,254
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-15 07:00:00 | AAPL | Stock | 4.5386 | 4.5482 | 4.5357 | 4.5357 | 98000.0 |
| 2008-02-15 07:30:00 | AAPL | Stock | 4.5429 | 4.5429 | 4.52 | 4.52 | 70280.0 |
| 2008-02-15 08:00:00 | AAPL | Stock | 4.5336 | 4.5336 | 4.5 | 4.5146 | 1095836.0 |
| 2008-02-15 08:30:00 | AAPL | Stock | 4.5146 | 4.5146 | 4.4907 | 4.4971 | 2093364.0 |
| 2008-02-15 09:00:00 | AAPL | Stock | 4.4964 | 4.5154 | 4.4957 | 4.5104 | 3520076.0 |
| 2008-02-15 09:30:00 | AAPL | Stock | 4.5107 | 4.5386 | 4.4929 | 4.5168 | 156332764.0 |
| 2008-02-15 10:00:00 | AAPL | Stock | 4.5164 | 4.5261 | 4.4821 | 4.5104 | 80094812.0 |
| 2008-02-15 10:30:00 | AAPL | Stock | 4.5097 | 4.5325 | 4.4875 | 4.4918 | 61983208.0 |
| 2008-02-15 11:00:00 | AAPL | Stock | 4.4895 | 4.4943 | 4.4661 | 4.4689 | 54747280.0 |
| 2008-02-15 11:30:00 | AAPL | Stock | 4.4694 | 4.4718 | 4.4343 | 4.4586 | 76257020.0 |
| 2008-02-15 12:00:00 | AAPL | Stock | 4.4589 | 4.4736 | 4.4479 | 4.45 | 48545756.0 |
| 2008-02-15 12:30:00 | AAPL | Stock | 4.45 | 4.4507 | 4.4336 | 4.4479 | 53584580.0 |
| 2008-02-15 13:00:00 | AAPL | Stock | 4.4479 | 4.4496 | 4.4307 | 4.4329 | 38938256.0 |
| 2008-02-15 13:30:00 | AAPL | Stock | 4.4325 | 4.4589 | 4.4325 | 4.4482 | 40607224.0 |
| 2008-02-15 14:00:00 | AAPL | Stock | 4.4482 | 4.4514 | 4.4325 | 4.4432 | 41979056.0 |
| 2008-02-15 14:30:00 | AAPL | Stock | 4.4435 | 4.4454 | 4.4339 | 4.4425 | 36326976.0 |
| 2008-02-15 15:00:00 | AAPL | Stock | 4.4429 | 4.4589 | 4.4379 | 4.4543 | 65222500.0 |
| 2008-02-15 15:30:00 | AAPL | Stock | 4.4541 | 4.4664 | 4.4475 | 4.4511 | 117305160.0 |
| 2008-02-15 16:00:00 | AAPL | Stock | 4.4511 | 4.4729 | 4.4464 | 4.4479 | 14107044.0 |
| 2008-02-15 16:30:00 | AAPL | Stock | 4.4475 | 4.4544 | 4.445 | 4.4457 | 2368548.0 |
| 2008-02-15 17:00:00 | AAPL | Stock | 4.4454 | 4.4511 | 4.4429 | 4.4464 | 2551164.0 |
| 2008-02-15 17:30:00 | AAPL | Stock | 4.4461 | 4.4511 | 4.4446 | 4.4446 | 5146652.0 |
| 2008-02-15 18:00:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4375 | 4.4386 | 277480.0 |
| 2008-02-15 18:30:00 | AAPL | Stock | 4.4404 | 4.4429 | 4.4393 | 4.4429 | 125300.0 |
| 2008-02-15 19:00:00 | AAPL | Stock | 4.4429 | 4.4439 | 4.4393 | 4.4429 | 92344.0 |
| 2008-02-15 19:30:00 | AAPL | Stock | 4.4396 | 4.4429 | 4.4382 | 4.4429 | 112000.0 |
| 2008-02-15 08:00:00 | MSFT | Stock | 28.46 | 28.46 | 28.34 | 28.37 | 7042.0 |
| 2008-02-15 08:30:00 | MSFT | Stock | 28.35 | 28.43 | 28.32 | 28.43 | 14925.0 |
| 2008-02-15 09:00:00 | MSFT | Stock | 28.4 | 28.46 | 28.31 | 28.32 | 78672.0 |
| 2008-02-15 09:30:00 | MSFT | Stock | 28.38 | 28.5 | 28.25 | 28.46 | 13673374.0 |
| 2008-02-15 10:00:00 | MSFT | Stock | 28.45 | 28.61 | 28.44 | 28.56 | 4792138.0 |
| 2008-02-15 10:30:00 | MSFT | Stock | 28.56 | 28.64 | 28.47 | 28.49 | 4078881.0 |
| 2008-02-15 11:00:00 | MSFT | Stock | 28.49 | 28.55 | 28.48 | 28.52 | 3616675.0 |
| 2008-02-15 11:30:00 | MSFT | Stock | 28.51 | 28.52 | 28.32 | 28.39 | 5330365.0 |
| 2008-02-15 12:00:00 | MSFT | Stock | 28.39 | 28.46 | 28.33 | 28.33 | 3597328.0 |
| 2008-02-15 12:30:00 | MSFT | Stock | 28.331 | 28.39 | 28.31 | 28.39 | 3907324.0 |
| 2008-02-15 13:00:00 | MSFT | Stock | 28.381 | 28.4 | 28.34 | 28.38 | 1880007.0 |
| 2008-02-15 13:30:00 | MSFT | Stock | 28.38 | 28.55 | 28.34 | 28.38 | 3065078.0 |
| 2008-02-15 14:00:00 | MSFT | Stock | 28.37 | 28.38 | 28.31 | 28.35 | 3646015.0 |
| 2008-02-15 14:30:00 | MSFT | Stock | 28.355 | 28.38 | 28.34 | 28.35 | 4488818.0 |
| 2008-02-15 15:00:00 | MSFT | Stock | 28.34 | 28.41 | 28.31 | 28.33 | 4100331.0 |
| 2008-02-15 15:30:00 | MSFT | Stock | 28.33 | 28.44 | 28.32 | 28.42 | 6343203.0 |
| 2008-02-15 16:00:00 | MSFT | Stock | 28.41 | 28.45 | 28.355 | 28.415 | 2823929.0 |
| 2008-02-15 16:30:00 | MSFT | Stock | 28.42 | 28.45 | 28.362 | 28.43 | 807620.0 |
| 2008-02-15 17:00:00 | MSFT | Stock | 28.42 | 28.45 | 28.42 | 28.45 | 747316.0 |
| 2008-02-15 17:30:00 | MSFT | Stock | 28.42 | 28.42 | 28.42 | 28.42 | 1931048.0 |
| 2008-02-15 18:00:00 | MSFT | Stock | 28.43 | 28.46 | 28.43 | 28.43 | 2320.0 |
| 2008-02-15 18:30:00 | MSFT | Stock | 28.45 | 28.45 | 28.42 | 28.42 | 515.0 |
| 2008-02-15 19:00:00 | MSFT | Stock | 28.41 | 28.41 | 28.4 | 28.4 | 420.0 |
| 2008-02-15 19:30:00 | MSFT | Stock | 28.43 | 28.48 | 28.43 | 28.48 | 19010.0 |
> showing 50 of 71,074 rows — these rows as CSV