PREVIEW / stock_30min / 2008-05-19
file: by_date/stock_30min/2008/2008-05-19.parquet size: 1.3 MB rows: 70,123 symbols: 3,314
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-05-19 07:00:00 | AAPL | Stock | 6.7179 | 6.7179 | 6.6614 | 6.6786 | 336700.0 |
| 2008-05-19 07:30:00 | AAPL | Stock | 6.6689 | 6.6786 | 6.6689 | 6.6786 | 16800.0 |
| 2008-05-19 08:00:00 | AAPL | Stock | 6.6743 | 6.7179 | 6.6743 | 6.7071 | 892948.0 |
| 2008-05-19 08:30:00 | AAPL | Stock | 6.7079 | 6.715 | 6.705 | 6.7136 | 451416.0 |
| 2008-05-19 09:00:00 | AAPL | Stock | 6.7125 | 6.7132 | 6.6954 | 6.7096 | 966308.0 |
| 2008-05-19 09:30:00 | AAPL | Stock | 6.7075 | 6.7125 | 6.6464 | 6.6607 | 90068468.0 |
| 2008-05-19 10:00:00 | AAPL | Stock | 6.6611 | 6.7257 | 6.6536 | 6.6621 | 94120712.0 |
| 2008-05-19 10:30:00 | AAPL | Stock | 6.6621 | 6.6768 | 6.6439 | 6.6593 | 69627964.0 |
| 2008-05-19 11:00:00 | AAPL | Stock | 6.6593 | 6.6818 | 6.6411 | 6.6596 | 57801184.0 |
| 2008-05-19 11:30:00 | AAPL | Stock | 6.6604 | 6.6768 | 6.6457 | 6.6693 | 39010496.0 |
| 2008-05-19 12:00:00 | AAPL | Stock | 6.6693 | 6.7143 | 6.6621 | 6.7036 | 47625648.0 |
| 2008-05-19 12:30:00 | AAPL | Stock | 6.7032 | 6.71 | 6.6893 | 6.6965 | 18804072.0 |
| 2008-05-19 13:00:00 | AAPL | Stock | 6.6964 | 6.7389 | 6.6964 | 6.7346 | 46387572.0 |
| 2008-05-19 13:30:00 | AAPL | Stock | 6.7339 | 6.7357 | 6.6104 | 6.6125 | 78584772.0 |
| 2008-05-19 14:00:00 | AAPL | Stock | 6.6121 | 6.6296 | 6.5554 | 6.5646 | 105682248.0 |
| 2008-05-19 14:30:00 | AAPL | Stock | 6.5646 | 6.6114 | 6.5471 | 6.61 | 71262800.0 |
| 2008-05-19 15:00:00 | AAPL | Stock | 6.61 | 6.6143 | 6.5636 | 6.5696 | 60408012.0 |
| 2008-05-19 15:30:00 | AAPL | Stock | 6.5696 | 6.5714 | 6.475 | 6.5575 | 142338448.0 |
| 2008-05-19 16:00:00 | AAPL | Stock | 6.5568 | 6.7107 | 6.5429 | 6.5571 | 12608708.0 |
| 2008-05-19 16:30:00 | AAPL | Stock | 6.5554 | 6.5571 | 6.5536 | 6.555 | 913836.0 |
| 2008-05-19 17:00:00 | AAPL | Stock | 6.555 | 6.5571 | 6.5536 | 6.5536 | 224056.0 |
| 2008-05-19 17:30:00 | AAPL | Stock | 6.5564 | 6.5571 | 6.5529 | 6.5568 | 109788.0 |
| 2008-05-19 18:00:00 | AAPL | Stock | 6.5554 | 6.5632 | 6.5539 | 6.5632 | 209440.0 |
| 2008-05-19 18:30:00 | AAPL | Stock | 6.5607 | 6.5643 | 6.5607 | 6.5643 | 103740.0 |
| 2008-05-19 19:00:00 | AAPL | Stock | 6.5661 | 6.5661 | 6.5611 | 6.5636 | 43008.0 |
| 2008-05-19 19:30:00 | AAPL | Stock | 6.5618 | 6.5632 | 6.5579 | 6.5607 | 99008.0 |
| 2008-05-19 06:30:00 | MSFT | Stock | 29.99 | 29.99 | 29.86 | 29.86 | 3760.0 |
| 2008-05-19 07:00:00 | MSFT | Stock | 29.88 | 29.88 | 29.86 | 29.86 | 2400.0 |
| 2008-05-19 08:00:00 | MSFT | Stock | 29.95 | 30.05 | 29.95 | 30.0 | 15200.0 |
| 2008-05-19 08:30:00 | MSFT | Stock | 29.99 | 30.0 | 29.89 | 29.9 | 43285.0 |
| 2008-05-19 09:00:00 | MSFT | Stock | 29.9 | 29.96 | 29.85 | 29.87 | 61377.0 |
| 2008-05-19 09:30:00 | MSFT | Stock | 29.87 | 29.89 | 29.63 | 29.79 | 6510723.0 |
| 2008-05-19 10:00:00 | MSFT | Stock | 29.8 | 29.8 | 29.64 | 29.69 | 4364553.0 |
| 2008-05-19 10:30:00 | MSFT | Stock | 29.69 | 29.76 | 29.66 | 29.7 | 2888883.0 |
| 2008-05-19 11:00:00 | MSFT | Stock | 29.7 | 29.7 | 29.6 | 29.61 | 5732977.0 |
| 2008-05-19 11:30:00 | MSFT | Stock | 29.62 | 29.63 | 29.52 | 29.56 | 5416215.0 |
| 2008-05-19 12:00:00 | MSFT | Stock | 29.552 | 29.62 | 29.55 | 29.58 | 4305746.0 |
| 2008-05-19 12:30:00 | MSFT | Stock | 29.581 | 29.64 | 29.57 | 29.64 | 1486784.0 |
| 2008-05-19 13:00:00 | MSFT | Stock | 29.64 | 29.72 | 29.63 | 29.72 | 3131428.0 |
| 2008-05-19 13:30:00 | MSFT | Stock | 29.71 | 29.72 | 29.62 | 29.64 | 2274476.0 |
| 2008-05-19 14:00:00 | MSFT | Stock | 29.65 | 29.677 | 29.32 | 29.34 | 6866696.0 |
| 2008-05-19 14:30:00 | MSFT | Stock | 29.35 | 29.5 | 29.35 | 29.48 | 2957948.0 |
| 2008-05-19 15:00:00 | MSFT | Stock | 29.48 | 29.51 | 29.42 | 29.472 | 2829498.0 |
| 2008-05-19 15:30:00 | MSFT | Stock | 29.48 | 29.51 | 29.31 | 29.46 | 6928720.0 |
| 2008-05-19 16:00:00 | MSFT | Stock | 29.45 | 29.615 | 29.45 | 29.47 | 2163355.0 |
| 2008-05-19 16:30:00 | MSFT | Stock | 29.46 | 29.51 | 29.46 | 29.486 | 449891.0 |
| 2008-05-19 17:00:00 | MSFT | Stock | 29.5 | 29.61 | 29.46 | 29.61 | 183757.0 |
| 2008-05-19 17:30:00 | MSFT | Stock | 29.5 | 29.51 | 29.5 | 29.51 | 350.0 |
| 2008-05-19 18:00:00 | MSFT | Stock | 29.5 | 29.51 | 29.5 | 29.51 | 2000.0 |
| 2008-05-19 18:30:00 | MSFT | Stock | 29.48 | 29.48 | 29.48 | 29.48 | 650.0 |
> showing 50 of 70,123 rows — these rows as CSV