PREVIEW / stock_30min / 2006-10-04
file: by_date/stock_30min/2006/2006-10-04.parquet size: 936 KB rows: 51,179 symbols: 2,397
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-04 08:00:00 | AAPL | Stock | 2.6532 | 2.6586 | 2.6493 | 2.65 | 461328.0 |
| 2006-10-04 08:30:00 | AAPL | Stock | 2.6518 | 2.6568 | 2.65 | 2.6536 | 355656.0 |
| 2006-10-04 09:00:00 | AAPL | Stock | 2.6536 | 2.6536 | 2.6386 | 2.6464 | 1107904.0 |
| 2006-10-04 09:30:00 | AAPL | Stock | 2.6464 | 2.6475 | 2.6157 | 2.6164 | 89223484.0 |
| 2006-10-04 10:00:00 | AAPL | Stock | 2.6161 | 2.6607 | 2.6129 | 2.6486 | 104783056.0 |
| 2006-10-04 10:30:00 | AAPL | Stock | 2.6489 | 2.66 | 2.6457 | 2.6568 | 62739404.0 |
| 2006-10-04 11:00:00 | AAPL | Stock | 2.6561 | 2.6868 | 2.6532 | 2.6786 | 105537628.0 |
| 2006-10-04 11:30:00 | AAPL | Stock | 2.6779 | 2.6789 | 2.665 | 2.6757 | 49027188.0 |
| 2006-10-04 12:00:00 | AAPL | Stock | 2.6754 | 2.6779 | 2.6636 | 2.6718 | 44100196.0 |
| 2006-10-04 12:30:00 | AAPL | Stock | 2.6711 | 2.6775 | 2.6693 | 2.675 | 23669408.0 |
| 2006-10-04 13:00:00 | AAPL | Stock | 2.6739 | 2.6779 | 2.6664 | 2.6773 | 25548740.0 |
| 2006-10-04 13:30:00 | AAPL | Stock | 2.6768 | 2.6796 | 2.6671 | 2.6761 | 39943120.0 |
| 2006-10-04 14:00:00 | AAPL | Stock | 2.6764 | 2.6846 | 2.6736 | 2.6804 | 50942444.0 |
| 2006-10-04 14:30:00 | AAPL | Stock | 2.68 | 2.6951 | 2.6771 | 2.6932 | 74963588.0 |
| 2006-10-04 15:00:00 | AAPL | Stock | 2.6932 | 2.6935 | 2.6771 | 2.6843 | 60742472.0 |
| 2006-10-04 15:30:00 | AAPL | Stock | 2.6843 | 2.6921 | 2.6825 | 2.6921 | 66347904.0 |
| 2006-10-04 16:00:00 | AAPL | Stock | 2.6914 | 2.6918 | 2.6871 | 2.6893 | 913864.0 |
| 2006-10-04 16:30:00 | AAPL | Stock | 2.6893 | 2.7429 | 2.6514 | 2.6571 | 7675304.0 |
| 2006-10-04 17:00:00 | AAPL | Stock | 2.6571 | 2.6911 | 2.6507 | 2.6696 | 5132736.0 |
| 2006-10-04 17:30:00 | AAPL | Stock | 2.6696 | 2.6779 | 2.665 | 2.675 | 1320340.0 |
| 2006-10-04 18:00:00 | AAPL | Stock | 2.6754 | 2.6921 | 2.6679 | 2.6696 | 9624216.0 |
| 2006-10-04 18:30:00 | AAPL | Stock | 2.6679 | 2.6736 | 2.6679 | 2.6729 | 246680.0 |
| 2006-10-04 19:00:00 | AAPL | Stock | 2.6757 | 2.6793 | 2.6714 | 2.6714 | 334292.0 |
| 2006-10-04 19:30:00 | AAPL | Stock | 2.6714 | 2.6804 | 2.6714 | 2.6714 | 64260.0 |
| 2006-10-04 06:30:00 | MSFT | Stock | 27.37 | 27.37 | 27.37 | 27.37 | 800.0 |
| 2006-10-04 07:00:00 | MSFT | Stock | 27.37 | 27.45 | 27.37 | 27.45 | 900.0 |
| 2006-10-04 07:30:00 | MSFT | Stock | 27.45 | 27.45 | 27.43 | 27.43 | 1692.0 |
| 2006-10-04 08:00:00 | MSFT | Stock | 27.43 | 27.43 | 27.37 | 27.37 | 23852.0 |
| 2006-10-04 08:30:00 | MSFT | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 845.0 |
| 2006-10-04 09:00:00 | MSFT | Stock | 27.41 | 27.42 | 27.35 | 27.4 | 162878.0 |
| 2006-10-04 09:30:00 | MSFT | Stock | 27.39 | 27.63 | 27.37 | 27.583 | 8089563.0 |
| 2006-10-04 10:00:00 | MSFT | Stock | 27.58 | 27.79 | 27.55 | 27.78 | 7466493.0 |
| 2006-10-04 10:30:00 | MSFT | Stock | 27.79 | 27.8 | 27.67 | 27.71 | 5527939.0 |
| 2006-10-04 11:00:00 | MSFT | Stock | 27.72 | 27.78 | 27.68 | 27.76 | 3973686.0 |
| 2006-10-04 11:30:00 | MSFT | Stock | 27.75 | 27.8 | 27.72 | 27.74 | 5741679.0 |
| 2006-10-04 12:00:00 | MSFT | Stock | 27.74 | 27.8 | 27.73 | 27.79 | 2979376.0 |
| 2006-10-04 12:30:00 | MSFT | Stock | 27.791 | 27.85 | 27.75 | 27.8 | 7682177.0 |
| 2006-10-04 13:00:00 | MSFT | Stock | 27.8 | 27.892 | 27.72 | 27.85 | 3465028.0 |
| 2006-10-04 13:30:00 | MSFT | Stock | 27.85 | 27.9 | 27.75 | 27.86 | 5555964.0 |
| 2006-10-04 14:00:00 | MSFT | Stock | 27.85 | 27.92 | 27.83 | 27.91 | 4986518.0 |
| 2006-10-04 14:30:00 | MSFT | Stock | 27.91 | 27.94 | 27.87 | 27.9 | 5778835.0 |
| 2006-10-04 15:00:00 | MSFT | Stock | 27.9 | 27.93 | 27.84 | 27.89 | 5759036.0 |
| 2006-10-04 15:30:00 | MSFT | Stock | 27.88 | 27.96 | 27.88 | 27.95 | 12964516.0 |
| 2006-10-04 16:00:00 | MSFT | Stock | 27.94 | 27.98 | 27.92 | 27.98 | 201334.0 |
| 2006-10-04 16:30:00 | MSFT | Stock | 27.94 | 27.96 | 27.94 | 27.94 | 62379.0 |
| 2006-10-04 17:00:00 | MSFT | Stock | 27.91 | 27.91 | 27.91 | 27.91 | 437.0 |
| 2006-10-04 17:30:00 | MSFT | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 833.0 |
| 2006-10-04 18:00:00 | MSFT | Stock | 27.92 | 27.96 | 27.91 | 27.95 | 12161.0 |
| 2006-10-04 18:30:00 | MSFT | Stock | 27.96 | 27.96 | 27.96 | 27.96 | 800.0 |
| 2006-10-04 19:30:00 | MSFT | Stock | 27.96 | 27.96 | 27.96 | 27.96 | 200.0 |
> showing 50 of 51,179 rows — these rows as CSV