PREVIEW / stock_30min / 2006-01-31
file: by_date/stock_30min/2006/2006-01-31.parquet size: 921 KB rows: 49,131 symbols: 2,193
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-01-31 06:30:00 | AAPL | Stock | 2.6875 | 2.6893 | 2.6875 | 2.6893 | 25200.0 |
| 2006-01-31 07:00:00 | AAPL | Stock | 2.6961 | 2.6961 | 2.6961 | 2.6961 | 2800.0 |
| 2006-01-31 07:30:00 | AAPL | Stock | 2.6946 | 2.7011 | 2.6789 | 2.6871 | 145600.0 |
| 2006-01-31 08:00:00 | AAPL | Stock | 2.6925 | 2.7071 | 2.6825 | 2.7068 | 1794408.0 |
| 2006-01-31 08:30:00 | AAPL | Stock | 2.7068 | 2.7139 | 2.6921 | 2.6946 | 1750672.0 |
| 2006-01-31 09:00:00 | AAPL | Stock | 2.6929 | 2.7 | 2.6875 | 2.6964 | 1568168.0 |
| 2006-01-31 09:30:00 | AAPL | Stock | 2.6964 | 2.6986 | 2.6475 | 2.6625 | 145751060.0 |
| 2006-01-31 10:00:00 | AAPL | Stock | 2.6625 | 2.6714 | 2.6361 | 2.6436 | 94051468.0 |
| 2006-01-31 10:30:00 | AAPL | Stock | 2.6436 | 2.7018 | 2.6339 | 2.6979 | 115771544.0 |
| 2006-01-31 11:00:00 | AAPL | Stock | 2.6986 | 2.6996 | 2.6786 | 2.6882 | 69069840.0 |
| 2006-01-31 11:30:00 | AAPL | Stock | 2.6886 | 2.6996 | 2.6825 | 2.6979 | 35888496.0 |
| 2006-01-31 12:00:00 | AAPL | Stock | 2.6964 | 2.7111 | 2.6854 | 2.6871 | 57763468.0 |
| 2006-01-31 12:30:00 | AAPL | Stock | 2.6871 | 2.6993 | 2.6825 | 2.6943 | 29441888.0 |
| 2006-01-31 13:00:00 | AAPL | Stock | 2.6943 | 2.7025 | 2.6896 | 2.7007 | 23419424.0 |
| 2006-01-31 13:30:00 | AAPL | Stock | 2.7007 | 2.7089 | 2.6954 | 2.7036 | 25464852.0 |
| 2006-01-31 14:00:00 | AAPL | Stock | 2.7029 | 2.7168 | 2.6807 | 2.6929 | 86784824.0 |
| 2006-01-31 14:30:00 | AAPL | Stock | 2.6943 | 2.7139 | 2.6907 | 2.7107 | 64515808.0 |
| 2006-01-31 15:00:00 | AAPL | Stock | 2.7107 | 2.7264 | 2.6957 | 2.7029 | 77502572.0 |
| 2006-01-31 15:30:00 | AAPL | Stock | 2.7029 | 2.7075 | 2.6846 | 2.6964 | 59345048.0 |
| 2006-01-31 16:00:00 | AAPL | Stock | 2.6907 | 2.6968 | 2.6607 | 2.6768 | 4462220.0 |
| 2006-01-31 16:30:00 | AAPL | Stock | 2.6754 | 2.6968 | 2.6539 | 2.6607 | 2045204.0 |
| 2006-01-31 17:00:00 | AAPL | Stock | 2.6604 | 2.6693 | 2.6557 | 2.66 | 957376.0 |
| 2006-01-31 17:30:00 | AAPL | Stock | 2.6571 | 2.6693 | 2.6554 | 2.6679 | 609420.0 |
| 2006-01-31 18:00:00 | AAPL | Stock | 2.6732 | 2.6968 | 2.6611 | 2.6696 | 438116.0 |
| 2006-01-31 06:00:00 | MSFT | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 860.0 |
| 2006-01-31 06:30:00 | MSFT | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 100.0 |
| 2006-01-31 07:30:00 | MSFT | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 2000.0 |
| 2006-01-31 08:00:00 | MSFT | Stock | 27.99 | 27.99 | 27.97 | 27.97 | 3714.0 |
| 2006-01-31 08:30:00 | MSFT | Stock | 27.95 | 27.95 | 27.92 | 27.92 | 400.0 |
| 2006-01-31 09:00:00 | MSFT | Stock | 27.96 | 28.0 | 27.88 | 27.9 | 636676.0 |
| 2006-01-31 09:30:00 | MSFT | Stock | 27.91 | 28.01 | 27.88 | 27.95 | 8231171.0 |
| 2006-01-31 10:00:00 | MSFT | Stock | 27.96 | 27.98 | 27.87 | 27.95 | 7403951.0 |
| 2006-01-31 10:30:00 | MSFT | Stock | 27.95 | 28.0 | 27.9 | 27.98 | 3895355.0 |
| 2006-01-31 11:00:00 | MSFT | Stock | 27.98 | 28.02 | 27.96 | 28.01 | 6078297.0 |
| 2006-01-31 11:30:00 | MSFT | Stock | 28.01 | 28.06 | 27.96 | 28.02 | 3758207.0 |
| 2006-01-31 12:00:00 | MSFT | Stock | 28.02 | 28.03 | 27.96 | 28.002 | 2690221.0 |
| 2006-01-31 12:30:00 | MSFT | Stock | 28.0 | 28.02 | 27.97 | 28.0 | 2963245.0 |
| 2006-01-31 13:00:00 | MSFT | Stock | 28.0 | 28.02 | 27.95 | 28.001 | 8940296.0 |
| 2006-01-31 13:30:00 | MSFT | Stock | 28.008 | 28.09 | 27.97 | 28.058 | 3593134.0 |
| 2006-01-31 14:00:00 | MSFT | Stock | 28.052 | 28.1 | 27.98 | 28.02 | 6525533.0 |
| 2006-01-31 14:30:00 | MSFT | Stock | 28.02 | 28.2 | 27.99 | 28.19 | 9406598.0 |
| 2006-01-31 15:00:00 | MSFT | Stock | 28.2 | 28.29 | 28.16 | 28.28 | 8775165.0 |
| 2006-01-31 15:30:00 | MSFT | Stock | 28.28 | 28.38 | 28.08 | 28.15 | 16369215.0 |
| 2006-01-31 16:00:00 | MSFT | Stock | 28.13 | 28.18 | 27.94 | 27.94 | 700158.0 |
| 2006-01-31 16:30:00 | MSFT | Stock | 27.95 | 28.15 | 27.88 | 27.92 | 723655.0 |
| 2006-01-31 17:00:00 | MSFT | Stock | 27.92 | 27.95 | 27.89 | 27.93 | 18851.0 |
| 2006-01-31 17:30:00 | MSFT | Stock | 27.93 | 27.99 | 27.92 | 27.96 | 17719.0 |
| 2006-01-31 18:00:00 | MSFT | Stock | 27.97 | 28.15 | 27.96 | 27.96 | 2795.0 |
| 2006-01-31 09:00:00 | NVDA | Stock | 0.3792 | 0.38 | 0.3792 | 0.3796 | 276000.0 |
| 2006-01-31 09:30:00 | NVDA | Stock | 0.3792 | 0.3812 | 0.3757 | 0.3764 | 42835920.0 |
> showing 50 of 49,131 rows — these rows as CSV