PREVIEW / stock_30min / 2005-09-30
file: by_date/stock_30min/2005/2005-09-30.parquet size: 870 KB rows: 46,779 symbols: 2,089
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-09-30 08:00:00 | AAPL | Stock | 1.8696 | 1.8711 | 1.8696 | 1.8711 | 105840.0 |
| 2005-09-30 08:30:00 | AAPL | Stock | 1.8679 | 1.8693 | 1.8639 | 1.8693 | 101444.0 |
| 2005-09-30 09:00:00 | AAPL | Stock | 1.8686 | 1.87 | 1.8668 | 1.8671 | 237440.0 |
| 2005-09-30 09:30:00 | AAPL | Stock | 1.8689 | 1.875 | 1.8529 | 1.8671 | 62411440.0 |
| 2005-09-30 10:00:00 | AAPL | Stock | 1.8671 | 1.8979 | 1.8639 | 1.8939 | 70585256.0 |
| 2005-09-30 10:30:00 | AAPL | Stock | 1.8939 | 1.9025 | 1.8893 | 1.9 | 44856028.0 |
| 2005-09-30 11:00:00 | AAPL | Stock | 1.9004 | 1.9071 | 1.8925 | 1.8942 | 39260956.0 |
| 2005-09-30 11:30:00 | AAPL | Stock | 1.8945 | 1.8989 | 1.8882 | 1.8943 | 28399980.0 |
| 2005-09-30 12:00:00 | AAPL | Stock | 1.8943 | 1.9079 | 1.8932 | 1.9039 | 31235092.0 |
| 2005-09-30 12:30:00 | AAPL | Stock | 1.9043 | 1.91 | 1.9036 | 1.9086 | 26615624.0 |
| 2005-09-30 13:00:00 | AAPL | Stock | 1.9086 | 1.9089 | 1.9007 | 1.9046 | 28375480.0 |
| 2005-09-30 13:30:00 | AAPL | Stock | 1.9046 | 1.9064 | 1.8968 | 1.8979 | 20159860.0 |
| 2005-09-30 14:00:00 | AAPL | Stock | 1.8982 | 1.9021 | 1.8971 | 1.9004 | 27892284.0 |
| 2005-09-30 14:30:00 | AAPL | Stock | 1.9007 | 1.905 | 1.8939 | 1.9 | 29042748.0 |
| 2005-09-30 15:00:00 | AAPL | Stock | 1.9004 | 1.9054 | 1.8975 | 1.9003 | 31257772.0 |
| 2005-09-30 15:30:00 | AAPL | Stock | 1.9004 | 1.9161 | 1.9004 | 1.9161 | 69299384.0 |
| 2005-09-30 16:00:00 | AAPL | Stock | 1.9146 | 1.9154 | 1.905 | 1.9143 | 2622592.0 |
| 2005-09-30 16:30:00 | AAPL | Stock | 1.9146 | 1.9161 | 1.9129 | 1.9143 | 298620.0 |
| 2005-09-30 17:00:00 | AAPL | Stock | 1.9143 | 1.9179 | 1.9129 | 1.9139 | 83636.0 |
| 2005-09-30 17:30:00 | AAPL | Stock | 1.9125 | 1.9146 | 1.9093 | 1.9125 | 246008.0 |
| 2005-09-30 18:00:00 | AAPL | Stock | 1.9146 | 1.9171 | 1.9107 | 1.9136 | 381080.0 |
| 2005-09-30 07:30:00 | MSFT | Stock | 26.08 | 26.08 | 26.08 | 26.08 | 201.0 |
| 2005-09-30 08:30:00 | MSFT | Stock | 25.92 | 25.93 | 25.91 | 25.93 | 2700.0 |
| 2005-09-30 09:00:00 | MSFT | Stock | 25.92 | 25.95 | 25.87 | 25.91 | 35243.0 |
| 2005-09-30 09:30:00 | MSFT | Stock | 25.91 | 25.93 | 25.72 | 25.81 | 7744714.0 |
| 2005-09-30 10:00:00 | MSFT | Stock | 25.82 | 25.95 | 25.8 | 25.82 | 3813635.0 |
| 2005-09-30 10:30:00 | MSFT | Stock | 25.82 | 25.89 | 25.79 | 25.81 | 2574173.0 |
| 2005-09-30 11:00:00 | MSFT | Stock | 25.82 | 25.82 | 25.72 | 25.76 | 2478856.0 |
| 2005-09-30 11:30:00 | MSFT | Stock | 25.77 | 25.79 | 25.66 | 25.67 | 2893164.0 |
| 2005-09-30 12:00:00 | MSFT | Stock | 25.674 | 25.91 | 25.65 | 25.71 | 4222259.0 |
| 2005-09-30 12:30:00 | MSFT | Stock | 25.701 | 25.71 | 25.64 | 25.652 | 2015389.0 |
| 2005-09-30 13:00:00 | MSFT | Stock | 25.659 | 25.73 | 25.62 | 25.69 | 3284139.0 |
| 2005-09-30 13:30:00 | MSFT | Stock | 25.69 | 25.75 | 25.68 | 25.688 | 1745638.0 |
| 2005-09-30 14:00:00 | MSFT | Stock | 25.68 | 25.751 | 25.67 | 25.72 | 3193282.0 |
| 2005-09-30 14:30:00 | MSFT | Stock | 25.72 | 25.81 | 25.71 | 25.74 | 4601780.0 |
| 2005-09-30 15:00:00 | MSFT | Stock | 25.74 | 25.801 | 25.61 | 25.65 | 5888190.0 |
| 2005-09-30 15:30:00 | MSFT | Stock | 25.64 | 25.75 | 25.61 | 25.72 | 8263441.0 |
| 2005-09-30 16:00:00 | MSFT | Stock | 25.72 | 25.75 | 25.685 | 25.72 | 1072746.0 |
| 2005-09-30 16:30:00 | MSFT | Stock | 25.73 | 25.74 | 25.73 | 25.73 | 5075.0 |
| 2005-09-30 17:00:00 | MSFT | Stock | 25.73 | 25.74 | 25.72 | 25.73 | 6650.0 |
| 2005-09-30 17:30:00 | MSFT | Stock | 25.73 | 25.74 | 25.72 | 25.74 | 82800.0 |
| 2005-09-30 18:00:00 | MSFT | Stock | 25.73 | 25.74 | 25.73 | 25.74 | 22668.0 |
| 2005-09-30 09:00:00 | NVDA | Stock | 0.2836 | 0.2836 | 0.2835 | 0.2836 | 60000.0 |
| 2005-09-30 09:30:00 | NVDA | Stock | 0.2833 | 0.2878 | 0.2827 | 0.2878 | 101288520.0 |
| 2005-09-30 10:00:00 | NVDA | Stock | 0.2879 | 0.2882 | 0.2857 | 0.2871 | 75298440.0 |
| 2005-09-30 10:30:00 | NVDA | Stock | 0.2871 | 0.2882 | 0.2868 | 0.288 | 26828640.0 |
| 2005-09-30 11:00:00 | NVDA | Stock | 0.288 | 0.288 | 0.2852 | 0.2859 | 29561640.0 |
| 2005-09-30 11:30:00 | NVDA | Stock | 0.286 | 0.2861 | 0.2839 | 0.2852 | 24078120.0 |
| 2005-09-30 12:00:00 | NVDA | Stock | 0.2852 | 0.2867 | 0.2849 | 0.2865 | 13934280.0 |
| 2005-09-30 12:30:00 | NVDA | Stock | 0.2866 | 0.2867 | 0.2855 | 0.2862 | 20696040.0 |
> showing 50 of 46,779 rows — these rows as CSV