PREVIEW / stock_30min / 2005-01-28
file: by_date/stock_30min/2005/2005-01-28.parquet size: 802 KB rows: 42,997 symbols: 1,921
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-01-28 08:00:00 | AAPL | Stock | 1.2975 | 1.2975 | 1.2946 | 1.2973 | 367192.0 |
| 2005-01-28 08:30:00 | AAPL | Stock | 1.2946 | 1.2973 | 1.2946 | 1.297 | 235704.0 |
| 2005-01-28 09:00:00 | AAPL | Stock | 1.2964 | 1.3002 | 1.2946 | 1.2966 | 2005976.0 |
| 2005-01-28 09:30:00 | AAPL | Stock | 1.2968 | 1.3114 | 1.2936 | 1.3079 | 111827632.0 |
| 2005-01-28 10:00:00 | AAPL | Stock | 1.308 | 1.3111 | 1.3023 | 1.3089 | 62249488.0 |
| 2005-01-28 10:30:00 | AAPL | Stock | 1.3089 | 1.3143 | 1.3046 | 1.3061 | 67846184.0 |
| 2005-01-28 11:00:00 | AAPL | Stock | 1.3057 | 1.3059 | 1.2955 | 1.2991 | 95966528.0 |
| 2005-01-28 11:30:00 | AAPL | Stock | 1.2991 | 1.3036 | 1.298 | 1.3025 | 39356912.0 |
| 2005-01-28 12:00:00 | AAPL | Stock | 1.3025 | 1.3036 | 1.2968 | 1.298 | 24348800.0 |
| 2005-01-28 12:30:00 | AAPL | Stock | 1.2979 | 1.3 | 1.297 | 1.2975 | 17562328.0 |
| 2005-01-28 13:00:00 | AAPL | Stock | 1.2975 | 1.3086 | 1.2952 | 1.3059 | 44862272.0 |
| 2005-01-28 13:30:00 | AAPL | Stock | 1.3057 | 1.3102 | 1.3038 | 1.3057 | 43919176.0 |
| 2005-01-28 14:00:00 | AAPL | Stock | 1.3057 | 1.3086 | 1.3002 | 1.3068 | 33652584.0 |
| 2005-01-28 14:30:00 | AAPL | Stock | 1.3066 | 1.3134 | 1.3046 | 1.3129 | 55178704.0 |
| 2005-01-28 15:00:00 | AAPL | Stock | 1.3129 | 1.3168 | 1.3081 | 1.3098 | 78813392.0 |
| 2005-01-28 15:30:00 | AAPL | Stock | 1.3098 | 1.3209 | 1.308 | 1.3209 | 100611616.0 |
| 2005-01-28 16:00:00 | AAPL | Stock | 1.3195 | 1.3268 | 1.3163 | 1.3257 | 7045024.0 |
| 2005-01-28 16:30:00 | AAPL | Stock | 1.3259 | 1.3259 | 1.3211 | 1.3243 | 1522024.0 |
| 2005-01-28 17:00:00 | AAPL | Stock | 1.3243 | 1.3259 | 1.3236 | 1.3259 | 417872.0 |
| 2005-01-28 17:30:00 | AAPL | Stock | 1.325 | 1.3266 | 1.3238 | 1.3239 | 204288.0 |
| 2005-01-28 18:00:00 | AAPL | Stock | 1.3232 | 1.3232 | 1.3232 | 1.3232 | 151200.0 |
| 2005-01-28 08:00:00 | MSFT | Stock | 26.7 | 26.8 | 26.63 | 26.65 | 655955.0 |
| 2005-01-28 08:30:00 | MSFT | Stock | 26.66 | 26.69 | 26.63 | 26.63 | 1208541.0 |
| 2005-01-28 09:00:00 | MSFT | Stock | 26.64 | 26.65 | 26.16 | 26.54 | 1494550.0 |
| 2005-01-28 09:30:00 | MSFT | Stock | 26.54 | 26.65 | 26.39 | 26.41 | 23492841.0 |
| 2005-01-28 10:00:00 | MSFT | Stock | 26.41 | 26.49 | 26.36 | 26.44 | 11704554.0 |
| 2005-01-28 10:30:00 | MSFT | Stock | 26.44 | 26.47 | 26.24 | 26.26 | 10175537.0 |
| 2005-01-28 11:00:00 | MSFT | Stock | 26.26 | 26.26 | 25.96 | 26.09 | 12603215.0 |
| 2005-01-28 11:30:00 | MSFT | Stock | 26.09 | 26.17 | 26.05 | 26.12 | 6738109.0 |
| 2005-01-28 12:00:00 | MSFT | Stock | 26.11 | 26.553 | 26.06 | 26.07 | 3312972.0 |
| 2005-01-28 12:30:00 | MSFT | Stock | 26.07 | 26.111 | 26.03 | 26.09 | 2923920.0 |
| 2005-01-28 13:00:00 | MSFT | Stock | 26.1 | 26.17 | 26.08 | 26.15 | 4408133.0 |
| 2005-01-28 13:30:00 | MSFT | Stock | 26.15 | 26.2 | 26.12 | 26.16 | 4127552.0 |
| 2005-01-28 14:00:00 | MSFT | Stock | 26.16 | 26.17 | 26.09 | 26.12 | 3500277.0 |
| 2005-01-28 14:30:00 | MSFT | Stock | 26.12 | 26.17 | 26.1 | 26.129 | 4733239.0 |
| 2005-01-28 15:00:00 | MSFT | Stock | 26.13 | 26.15 | 26.09 | 26.13 | 4459223.0 |
| 2005-01-28 15:30:00 | MSFT | Stock | 26.14 | 26.251 | 26.1 | 26.19 | 11302422.0 |
| 2005-01-28 16:00:00 | MSFT | Stock | 26.19 | 26.22 | 26.15 | 26.21 | 1040648.0 |
| 2005-01-28 16:30:00 | MSFT | Stock | 26.21 | 26.21 | 26.2 | 26.2 | 120487.0 |
| 2005-01-28 17:00:00 | MSFT | Stock | 26.2 | 26.21 | 26.19 | 26.19 | 28822.0 |
| 2005-01-28 17:30:00 | MSFT | Stock | 26.2 | 26.21 | 26.2 | 26.21 | 7968.0 |
| 2005-01-28 18:00:00 | MSFT | Stock | 26.22 | 26.24 | 26.2 | 26.21 | 9743.0 |
| 2005-01-28 08:30:00 | NVDA | Stock | 0.1917 | 0.1921 | 0.1917 | 0.1921 | 120000.0 |
| 2005-01-28 09:00:00 | NVDA | Stock | 0.1917 | 0.1919 | 0.19 | 0.1915 | 15483840.0 |
| 2005-01-28 09:30:00 | NVDA | Stock | 0.1917 | 0.1924 | 0.1889 | 0.1911 | 116127240.0 |
| 2005-01-28 10:00:00 | NVDA | Stock | 0.191 | 0.1919 | 0.1904 | 0.1912 | 63558720.0 |
| 2005-01-28 10:30:00 | NVDA | Stock | 0.1912 | 0.1914 | 0.1901 | 0.1901 | 45967320.0 |
| 2005-01-28 11:00:00 | NVDA | Stock | 0.1901 | 0.1905 | 0.1886 | 0.1897 | 117409680.0 |
| 2005-01-28 11:30:00 | NVDA | Stock | 0.1894 | 0.1906 | 0.1884 | 0.1897 | 75281880.0 |
| 2005-01-28 12:00:00 | NVDA | Stock | 0.1897 | 0.1899 | 0.1892 | 0.1896 | 22848480.0 |
> showing 50 of 42,997 rows — these rows as CSV