PREVIEW / stock_30min / 2005-04-21
file: by_date/stock_30min/2005/2005-04-21.parquet size: 837 KB rows: 44,769 symbols: 1,957
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-04-21 08:00:00 | AAPL | Stock | 1.2857 | 1.2964 | 1.2857 | 1.2911 | 1025080.0 |
| 2005-04-21 08:30:00 | AAPL | Stock | 1.2911 | 1.2964 | 1.29 | 1.2914 | 663600.0 |
| 2005-04-21 09:00:00 | AAPL | Stock | 1.2914 | 1.3011 | 1.2893 | 1.3011 | 3281684.0 |
| 2005-04-21 09:30:00 | AAPL | Stock | 1.3 | 1.3039 | 1.2821 | 1.2914 | 107473240.0 |
| 2005-04-21 10:00:00 | AAPL | Stock | 1.2914 | 1.2946 | 1.2839 | 1.2911 | 61581072.0 |
| 2005-04-21 10:30:00 | AAPL | Stock | 1.2914 | 1.3057 | 1.2893 | 1.3032 | 71702484.0 |
| 2005-04-21 11:00:00 | AAPL | Stock | 1.3029 | 1.3036 | 1.2889 | 1.2943 | 41824328.0 |
| 2005-04-21 11:30:00 | AAPL | Stock | 1.2943 | 1.3 | 1.2925 | 1.2964 | 33494384.0 |
| 2005-04-21 12:00:00 | AAPL | Stock | 1.2964 | 1.3107 | 1.2961 | 1.3096 | 56533372.0 |
| 2005-04-21 12:30:00 | AAPL | Stock | 1.3096 | 1.3189 | 1.3071 | 1.3107 | 54397028.0 |
| 2005-04-21 13:00:00 | AAPL | Stock | 1.3107 | 1.3154 | 1.3079 | 1.3089 | 33558700.0 |
| 2005-04-21 13:30:00 | AAPL | Stock | 1.3089 | 1.3146 | 1.3089 | 1.3136 | 37656080.0 |
| 2005-04-21 14:00:00 | AAPL | Stock | 1.3139 | 1.3279 | 1.3125 | 1.3232 | 65394616.0 |
| 2005-04-21 14:30:00 | AAPL | Stock | 1.3229 | 1.3268 | 1.3214 | 1.3229 | 43653092.0 |
| 2005-04-21 15:00:00 | AAPL | Stock | 1.3232 | 1.3246 | 1.3171 | 1.3232 | 50469440.0 |
| 2005-04-21 15:30:00 | AAPL | Stock | 1.3232 | 1.3289 | 1.3229 | 1.3282 | 77171500.0 |
| 2005-04-21 16:00:00 | AAPL | Stock | 1.3282 | 1.3304 | 1.3268 | 1.3282 | 3587612.0 |
| 2005-04-21 16:30:00 | AAPL | Stock | 1.3286 | 1.3304 | 1.3229 | 1.3257 | 1848476.0 |
| 2005-04-21 17:00:00 | AAPL | Stock | 1.3257 | 1.3279 | 1.3214 | 1.3214 | 399000.0 |
| 2005-04-21 17:30:00 | AAPL | Stock | 1.3214 | 1.3268 | 1.3168 | 1.3232 | 499800.0 |
| 2005-04-21 18:00:00 | AAPL | Stock | 1.3232 | 1.3232 | 1.3218 | 1.3218 | 179200.0 |
| 2005-04-21 07:30:00 | MSFT | Stock | 24.46 | 24.46 | 24.46 | 24.46 | 4000.0 |
| 2005-04-21 08:00:00 | MSFT | Stock | 24.4 | 24.54 | 24.4 | 24.5 | 89999.0 |
| 2005-04-21 08:30:00 | MSFT | Stock | 24.5 | 24.5 | 24.46 | 24.49 | 9562.0 |
| 2005-04-21 09:00:00 | MSFT | Stock | 24.49 | 24.61 | 24.48 | 24.48 | 105859.0 |
| 2005-04-21 09:30:00 | MSFT | Stock | 24.48 | 24.64 | 24.47 | 24.61 | 8523728.0 |
| 2005-04-21 10:00:00 | MSFT | Stock | 24.62 | 24.68 | 24.53 | 24.672 | 7864735.0 |
| 2005-04-21 10:30:00 | MSFT | Stock | 24.68 | 24.77 | 24.65 | 24.73 | 7612038.0 |
| 2005-04-21 11:00:00 | MSFT | Stock | 24.74 | 24.78 | 24.68 | 24.76 | 7838536.0 |
| 2005-04-21 11:30:00 | MSFT | Stock | 24.76 | 24.9 | 24.76 | 24.88 | 5343416.0 |
| 2005-04-21 12:00:00 | MSFT | Stock | 24.89 | 25.09 | 24.88 | 25.06 | 9325482.0 |
| 2005-04-21 12:30:00 | MSFT | Stock | 25.05 | 25.07 | 24.98 | 25.01 | 5822080.0 |
| 2005-04-21 13:00:00 | MSFT | Stock | 25.01 | 25.1 | 25.01 | 25.03 | 2716560.0 |
| 2005-04-21 13:30:00 | MSFT | Stock | 25.03 | 25.15 | 25.03 | 25.15 | 4404622.0 |
| 2005-04-21 14:00:00 | MSFT | Stock | 25.15 | 25.39 | 25.15 | 25.29 | 7657681.0 |
| 2005-04-21 14:30:00 | MSFT | Stock | 25.29 | 25.3 | 25.11 | 25.16 | 5343498.0 |
| 2005-04-21 15:00:00 | MSFT | Stock | 25.16 | 25.21 | 25.1 | 25.2 | 6327383.0 |
| 2005-04-21 15:30:00 | MSFT | Stock | 25.2 | 25.32 | 25.15 | 25.31 | 10443293.0 |
| 2005-04-21 16:00:00 | MSFT | Stock | 25.29 | 25.4 | 25.085 | 25.31 | 555860.0 |
| 2005-04-21 16:30:00 | MSFT | Stock | 25.28 | 25.312 | 25.162 | 25.31 | 350397.0 |
| 2005-04-21 17:00:00 | MSFT | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 1500.0 |
| 2005-04-21 17:30:00 | MSFT | Stock | 25.28 | 25.28 | 25.26 | 25.28 | 3050.0 |
| 2005-04-21 18:00:00 | MSFT | Stock | 25.29 | 25.29 | 25.24 | 25.25 | 21029.0 |
| 2005-04-21 08:00:00 | NVDA | Stock | 0.178 | 0.1788 | 0.178 | 0.1788 | 72000.0 |
| 2005-04-21 09:00:00 | NVDA | Stock | 0.1797 | 0.1808 | 0.1796 | 0.1805 | 1143600.0 |
| 2005-04-21 09:30:00 | NVDA | Stock | 0.1808 | 0.1822 | 0.1792 | 0.1816 | 75108960.0 |
| 2005-04-21 10:00:00 | NVDA | Stock | 0.1816 | 0.1822 | 0.181 | 0.1817 | 40505760.0 |
| 2005-04-21 10:30:00 | NVDA | Stock | 0.1816 | 0.1817 | 0.1805 | 0.1809 | 30769320.0 |
| 2005-04-21 11:00:00 | NVDA | Stock | 0.181 | 0.1811 | 0.1799 | 0.1811 | 12648240.0 |
| 2005-04-21 11:30:00 | NVDA | Stock | 0.181 | 0.1829 | 0.1803 | 0.1825 | 27370080.0 |
> showing 50 of 44,769 rows — these rows as CSV