PREVIEW / stock_30min / 2008-06-04
file: by_date/stock_30min/2008/2008-06-04.parquet size: 1.3 MB rows: 69,380 symbols: 3,308
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-06-04 06:30:00 | AAPL | Stock | 6.6179 | 6.6179 | 6.6179 | 6.6179 | 2800.0 |
| 2008-06-04 07:30:00 | AAPL | Stock | 6.5929 | 6.5943 | 6.5786 | 6.5929 | 109900.0 |
| 2008-06-04 08:00:00 | AAPL | Stock | 6.5929 | 6.6132 | 6.5729 | 6.58 | 1553524.0 |
| 2008-06-04 08:30:00 | AAPL | Stock | 6.5771 | 6.59 | 6.575 | 6.5804 | 1088724.0 |
| 2008-06-04 09:00:00 | AAPL | Stock | 6.5804 | 6.5911 | 6.5625 | 6.5732 | 2814420.0 |
| 2008-06-04 09:30:00 | AAPL | Stock | 6.5732 | 6.6107 | 6.5561 | 6.5621 | 92235248.0 |
| 2008-06-04 10:00:00 | AAPL | Stock | 6.5625 | 6.6371 | 6.5439 | 6.63 | 78762040.0 |
| 2008-06-04 10:30:00 | AAPL | Stock | 6.6296 | 6.6721 | 6.6168 | 6.665 | 73792320.0 |
| 2008-06-04 11:00:00 | AAPL | Stock | 6.6643 | 6.6818 | 6.6454 | 6.6507 | 49856380.0 |
| 2008-06-04 11:30:00 | AAPL | Stock | 6.6504 | 6.6689 | 6.6371 | 6.6372 | 29193920.0 |
| 2008-06-04 12:00:00 | AAPL | Stock | 6.6375 | 6.6739 | 6.6296 | 6.6671 | 38887100.0 |
| 2008-06-04 12:30:00 | AAPL | Stock | 6.6664 | 6.6768 | 6.6411 | 6.6411 | 39656708.0 |
| 2008-06-04 13:00:00 | AAPL | Stock | 6.6418 | 6.6532 | 6.6157 | 6.6364 | 42308476.0 |
| 2008-06-04 13:30:00 | AAPL | Stock | 6.6364 | 6.6539 | 6.6268 | 6.6468 | 30360960.0 |
| 2008-06-04 14:00:00 | AAPL | Stock | 6.6475 | 6.65 | 6.5896 | 6.5943 | 48454420.0 |
| 2008-06-04 14:30:00 | AAPL | Stock | 6.5943 | 6.6093 | 6.5511 | 6.5671 | 71696100.0 |
| 2008-06-04 15:00:00 | AAPL | Stock | 6.5668 | 6.6071 | 6.5629 | 6.5804 | 55364400.0 |
| 2008-06-04 15:30:00 | AAPL | Stock | 6.5804 | 6.6179 | 6.5725 | 6.6121 | 61163788.0 |
| 2008-06-04 16:00:00 | AAPL | Stock | 6.6139 | 6.6229 | 6.5902 | 6.6161 | 6428016.0 |
| 2008-06-04 16:30:00 | AAPL | Stock | 6.6164 | 6.6171 | 6.6139 | 6.6168 | 420616.0 |
| 2008-06-04 17:00:00 | AAPL | Stock | 6.6168 | 6.6243 | 6.615 | 6.6179 | 152656.0 |
| 2008-06-04 17:30:00 | AAPL | Stock | 6.6164 | 6.6243 | 6.6161 | 6.6182 | 147588.0 |
| 2008-06-04 18:00:00 | AAPL | Stock | 6.6229 | 6.6229 | 6.6125 | 6.6139 | 170912.0 |
| 2008-06-04 18:30:00 | AAPL | Stock | 6.6125 | 6.6171 | 6.6125 | 6.6157 | 78848.0 |
| 2008-06-04 19:00:00 | AAPL | Stock | 6.6157 | 6.6196 | 6.6157 | 6.6179 | 71652.0 |
| 2008-06-04 19:30:00 | AAPL | Stock | 6.6179 | 6.6196 | 6.6161 | 6.6196 | 126756.0 |
| 2008-06-04 20:00:00 | AAPL | Stock | 6.6354 | 6.6354 | 6.6354 | 6.6354 | 30800.0 |
| 2008-06-04 08:00:00 | MSFT | Stock | 27.3 | 27.31 | 27.25 | 27.3 | 707203.0 |
| 2008-06-04 08:30:00 | MSFT | Stock | 27.34 | 27.35 | 27.3 | 27.33 | 72550.0 |
| 2008-06-04 09:00:00 | MSFT | Stock | 27.33 | 27.35 | 27.22 | 27.23 | 87034.0 |
| 2008-06-04 09:30:00 | MSFT | Stock | 27.27 | 27.52 | 27.22 | 27.271 | 9475467.0 |
| 2008-06-04 10:00:00 | MSFT | Stock | 27.28 | 27.35 | 27.2 | 27.29 | 7321756.0 |
| 2008-06-04 10:30:00 | MSFT | Stock | 27.291 | 27.53 | 27.27 | 27.47 | 8362611.0 |
| 2008-06-04 11:00:00 | MSFT | Stock | 27.47 | 27.63 | 27.46 | 27.56 | 5681566.0 |
| 2008-06-04 11:30:00 | MSFT | Stock | 27.56 | 27.64 | 27.52 | 27.56 | 3622150.0 |
| 2008-06-04 12:00:00 | MSFT | Stock | 27.56 | 27.56 | 27.44 | 27.45 | 5013502.0 |
| 2008-06-04 12:30:00 | MSFT | Stock | 27.47 | 27.49 | 27.32 | 27.34 | 4626766.0 |
| 2008-06-04 13:00:00 | MSFT | Stock | 27.35 | 27.39 | 27.26 | 27.355 | 4560595.0 |
| 2008-06-04 13:30:00 | MSFT | Stock | 27.35 | 27.46 | 27.33 | 27.43 | 3411680.0 |
| 2008-06-04 14:00:00 | MSFT | Stock | 27.43 | 27.47 | 27.34 | 27.419 | 5158405.0 |
| 2008-06-04 14:30:00 | MSFT | Stock | 27.41 | 27.55 | 27.28 | 27.37 | 7139422.0 |
| 2008-06-04 15:00:00 | MSFT | Stock | 27.36 | 27.48 | 27.3 | 27.43 | 5580696.0 |
| 2008-06-04 15:30:00 | MSFT | Stock | 27.43 | 27.59 | 27.41 | 27.54 | 6537393.0 |
| 2008-06-04 16:00:00 | MSFT | Stock | 27.53 | 27.562 | 27.31 | 27.55 | 1169604.0 |
| 2008-06-04 16:30:00 | MSFT | Stock | 27.55 | 27.55 | 27.406 | 27.54 | 94670.0 |
| 2008-06-04 17:00:00 | MSFT | Stock | 27.52 | 27.64 | 27.52 | 27.56 | 47032.0 |
| 2008-06-04 17:30:00 | MSFT | Stock | 27.56 | 27.63 | 27.55 | 27.63 | 18894.0 |
| 2008-06-04 18:00:00 | MSFT | Stock | 27.62 | 27.62 | 27.56 | 27.56 | 10509.0 |
| 2008-06-04 18:30:00 | MSFT | Stock | 27.57 | 27.61 | 27.57 | 27.6 | 5231.0 |
| 2008-06-04 19:00:00 | MSFT | Stock | 27.61 | 27.62 | 27.6 | 27.62 | 2025.0 |
> showing 50 of 69,380 rows — these rows as CSV