PREVIEW / stock_30min / 2005-10-21
file: by_date/stock_30min/2005/2005-10-21.parquet size: 872 KB rows: 46,472 symbols: 2,087
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-21 08:00:00 | AAPL | Stock | 2.025 | 2.0354 | 2.0179 | 2.0214 | 610120.0 |
| 2005-10-21 08:30:00 | AAPL | Stock | 2.0214 | 2.0286 | 2.0179 | 2.0246 | 461944.0 |
| 2005-10-21 09:00:00 | AAPL | Stock | 2.0239 | 2.0339 | 2.0143 | 2.0286 | 4784696.0 |
| 2005-10-21 09:30:00 | AAPL | Stock | 2.03 | 2.035 | 1.9968 | 2.0057 | 168960708.0 |
| 2005-10-21 10:00:00 | AAPL | Stock | 2.0057 | 2.0107 | 1.995 | 2.0064 | 73339420.0 |
| 2005-10-21 10:30:00 | AAPL | Stock | 2.0064 | 2.0089 | 1.9857 | 1.9918 | 59981544.0 |
| 2005-10-21 11:00:00 | AAPL | Stock | 1.9918 | 2.0036 | 1.9875 | 1.9929 | 45766588.0 |
| 2005-10-21 11:30:00 | AAPL | Stock | 1.9929 | 1.9936 | 1.9793 | 1.9886 | 47288248.0 |
| 2005-10-21 12:00:00 | AAPL | Stock | 1.9886 | 1.9918 | 1.9771 | 1.9889 | 53202072.0 |
| 2005-10-21 12:30:00 | AAPL | Stock | 1.9893 | 2.0036 | 1.9843 | 2.0015 | 54238716.0 |
| 2005-10-21 13:00:00 | AAPL | Stock | 2.0014 | 2.0068 | 1.9875 | 1.9932 | 58088016.0 |
| 2005-10-21 13:30:00 | AAPL | Stock | 1.9936 | 2.0036 | 1.9893 | 1.9914 | 36464960.0 |
| 2005-10-21 14:00:00 | AAPL | Stock | 1.9914 | 1.9946 | 1.9875 | 1.9893 | 33965596.0 |
| 2005-10-21 14:30:00 | AAPL | Stock | 1.9893 | 1.9921 | 1.9864 | 1.9886 | 33055512.0 |
| 2005-10-21 15:00:00 | AAPL | Stock | 1.9889 | 1.9939 | 1.9811 | 1.9871 | 43288252.0 |
| 2005-10-21 15:30:00 | AAPL | Stock | 1.9871 | 1.9929 | 1.9818 | 1.9868 | 66278072.0 |
| 2005-10-21 16:00:00 | AAPL | Stock | 1.985 | 1.9929 | 1.985 | 1.9929 | 1093596.0 |
| 2005-10-21 16:30:00 | AAPL | Stock | 1.9893 | 1.99 | 1.9889 | 1.99 | 312704.0 |
| 2005-10-21 17:00:00 | AAPL | Stock | 1.9893 | 1.9984 | 1.9875 | 1.9984 | 552384.0 |
| 2005-10-21 17:30:00 | AAPL | Stock | 1.9889 | 1.9984 | 1.9879 | 1.9879 | 2423764.0 |
| 2005-10-21 18:00:00 | AAPL | Stock | 1.9864 | 1.9868 | 1.9821 | 1.9821 | 77700.0 |
| 2005-10-21 08:00:00 | MSFT | Stock | 24.89 | 24.91 | 24.86 | 24.9 | 28107.0 |
| 2005-10-21 08:30:00 | MSFT | Stock | 24.89 | 24.9 | 24.88 | 24.9 | 41198.0 |
| 2005-10-21 09:00:00 | MSFT | Stock | 24.9 | 24.97 | 24.84 | 24.94 | 474041.0 |
| 2005-10-21 09:30:00 | MSFT | Stock | 24.91 | 25.0 | 24.8 | 24.82 | 11724170.0 |
| 2005-10-21 10:00:00 | MSFT | Stock | 24.81 | 24.85 | 24.77 | 24.818 | 6374881.0 |
| 2005-10-21 10:30:00 | MSFT | Stock | 24.818 | 24.83 | 24.63 | 24.65 | 4650449.0 |
| 2005-10-21 11:00:00 | MSFT | Stock | 24.66 | 24.73 | 24.65 | 24.7 | 3324566.0 |
| 2005-10-21 11:30:00 | MSFT | Stock | 24.7 | 24.7 | 24.58 | 24.62 | 4286368.0 |
| 2005-10-21 12:00:00 | MSFT | Stock | 24.62 | 24.69 | 24.57 | 24.68 | 2934378.0 |
| 2005-10-21 12:30:00 | MSFT | Stock | 24.69 | 24.79 | 24.67 | 24.78 | 4549422.0 |
| 2005-10-21 13:00:00 | MSFT | Stock | 24.78 | 24.88 | 24.73 | 24.88 | 5426404.0 |
| 2005-10-21 13:30:00 | MSFT | Stock | 24.88 | 24.96 | 24.86 | 24.91 | 4546346.0 |
| 2005-10-21 14:00:00 | MSFT | Stock | 24.91 | 24.91 | 24.85 | 24.87 | 2733742.0 |
| 2005-10-21 14:30:00 | MSFT | Stock | 24.87 | 24.89 | 24.77 | 24.81 | 2540576.0 |
| 2005-10-21 15:00:00 | MSFT | Stock | 24.82 | 24.83 | 24.77 | 24.81 | 2856899.0 |
| 2005-10-21 15:30:00 | MSFT | Stock | 24.81 | 24.82 | 24.73 | 24.76 | 6760594.0 |
| 2005-10-21 16:00:00 | MSFT | Stock | 24.76 | 24.8 | 24.75 | 24.77 | 2408958.0 |
| 2005-10-21 16:30:00 | MSFT | Stock | 24.78 | 24.78 | 24.75 | 24.75 | 18584.0 |
| 2005-10-21 17:00:00 | MSFT | Stock | 24.78 | 24.78 | 24.77 | 24.78 | 5894.0 |
| 2005-10-21 17:30:00 | MSFT | Stock | 24.78 | 24.8 | 24.78 | 24.8 | 931596.0 |
| 2005-10-21 18:00:00 | MSFT | Stock | 24.77 | 24.77 | 24.74 | 24.74 | 8200.0 |
| 2005-10-21 08:00:00 | NVDA | Stock | 0.2654 | 0.2654 | 0.2654 | 0.2654 | 36000.0 |
| 2005-10-21 08:30:00 | NVDA | Stock | 0.2666 | 0.2667 | 0.2666 | 0.2667 | 48000.0 |
| 2005-10-21 09:00:00 | NVDA | Stock | 0.2664 | 0.2692 | 0.2664 | 0.2692 | 1037880.0 |
| 2005-10-21 09:30:00 | NVDA | Stock | 0.2692 | 0.27 | 0.2654 | 0.2667 | 32660400.0 |
| 2005-10-21 10:00:00 | NVDA | Stock | 0.2667 | 0.2692 | 0.2659 | 0.2685 | 21116760.0 |
| 2005-10-21 10:30:00 | NVDA | Stock | 0.2686 | 0.2687 | 0.2643 | 0.2648 | 32480880.0 |
| 2005-10-21 11:00:00 | NVDA | Stock | 0.2649 | 0.267 | 0.2649 | 0.2669 | 16877280.0 |
| 2005-10-21 11:30:00 | NVDA | Stock | 0.2669 | 0.267 | 0.2653 | 0.2665 | 8087520.0 |
> showing 50 of 46,472 rows — these rows as CSV