PREVIEW / stock_30min / 2005-03-23
file: by_date/stock_30min/2005/2005-03-23.parquet size: 831 KB rows: 45,230 symbols: 1,960
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-03-23 08:00:00 | AAPL | Stock | 1.5243 | 1.5243 | 1.4982 | 1.5171 | 1108044.0 |
| 2005-03-23 08:30:00 | AAPL | Stock | 1.5171 | 1.5171 | 1.5039 | 1.5143 | 2479848.0 |
| 2005-03-23 09:00:00 | AAPL | Stock | 1.5154 | 1.5239 | 1.5118 | 1.5168 | 2238432.0 |
| 2005-03-23 09:30:00 | AAPL | Stock | 1.5161 | 1.5204 | 1.5007 | 1.5086 | 106183700.0 |
| 2005-03-23 10:00:00 | AAPL | Stock | 1.5089 | 1.5268 | 1.5068 | 1.5232 | 69442016.0 |
| 2005-03-23 10:30:00 | AAPL | Stock | 1.5232 | 1.5375 | 1.5179 | 1.5375 | 52567452.0 |
| 2005-03-23 11:00:00 | AAPL | Stock | 1.5375 | 1.55 | 1.5325 | 1.5411 | 64609804.0 |
| 2005-03-23 11:30:00 | AAPL | Stock | 1.5411 | 1.5414 | 1.5257 | 1.5286 | 44494436.0 |
| 2005-03-23 12:00:00 | AAPL | Stock | 1.5282 | 1.5429 | 1.5282 | 1.5325 | 31559976.0 |
| 2005-03-23 12:30:00 | AAPL | Stock | 1.5325 | 1.5354 | 1.5282 | 1.5329 | 19115292.0 |
| 2005-03-23 13:00:00 | AAPL | Stock | 1.5332 | 1.5361 | 1.5279 | 1.5286 | 15030680.0 |
| 2005-03-23 13:30:00 | AAPL | Stock | 1.5286 | 1.535 | 1.5275 | 1.535 | 16842028.0 |
| 2005-03-23 14:00:00 | AAPL | Stock | 1.535 | 1.5396 | 1.5311 | 1.5361 | 19647908.0 |
| 2005-03-23 14:30:00 | AAPL | Stock | 1.5361 | 1.5361 | 1.5282 | 1.5304 | 20517700.0 |
| 2005-03-23 15:00:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5186 | 1.5257 | 55273428.0 |
| 2005-03-23 15:30:00 | AAPL | Stock | 1.5257 | 1.5464 | 1.5182 | 1.5186 | 74249336.0 |
| 2005-03-23 16:00:00 | AAPL | Stock | 1.5189 | 1.5214 | 1.515 | 1.5186 | 1893640.0 |
| 2005-03-23 16:30:00 | AAPL | Stock | 1.5182 | 1.5189 | 1.5182 | 1.5186 | 707784.0 |
| 2005-03-23 17:00:00 | AAPL | Stock | 1.5175 | 1.5175 | 1.5143 | 1.5143 | 383600.0 |
| 2005-03-23 17:30:00 | AAPL | Stock | 1.5143 | 1.5186 | 1.5111 | 1.5186 | 329056.0 |
| 2005-03-23 18:00:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5111 | 1.5114 | 145600.0 |
| 2005-03-23 08:00:00 | MSFT | Stock | 24.0 | 24.04 | 23.99 | 24.01 | 7400.0 |
| 2005-03-23 08:30:00 | MSFT | Stock | 24.01 | 24.01 | 23.93 | 23.96 | 46815.0 |
| 2005-03-23 09:00:00 | MSFT | Stock | 23.96 | 24.0 | 23.95 | 23.99 | 101484.0 |
| 2005-03-23 09:30:00 | MSFT | Stock | 23.99 | 24.14 | 23.96 | 24.09 | 10065652.0 |
| 2005-03-23 10:00:00 | MSFT | Stock | 24.1 | 24.305 | 24.09 | 24.2 | 10777158.0 |
| 2005-03-23 10:30:00 | MSFT | Stock | 24.22 | 24.24 | 24.158 | 24.23 | 6194210.0 |
| 2005-03-23 11:00:00 | MSFT | Stock | 24.22 | 24.27 | 24.19 | 24.26 | 4668776.0 |
| 2005-03-23 11:30:00 | MSFT | Stock | 24.26 | 24.27 | 24.21 | 24.23 | 3933839.0 |
| 2005-03-23 12:00:00 | MSFT | Stock | 24.22 | 24.35 | 24.22 | 24.3 | 4311155.0 |
| 2005-03-23 12:30:00 | MSFT | Stock | 24.31 | 24.37 | 24.28 | 24.35 | 4527981.0 |
| 2005-03-23 13:00:00 | MSFT | Stock | 24.36 | 24.39 | 24.24 | 24.24 | 4850838.0 |
| 2005-03-23 13:30:00 | MSFT | Stock | 24.24 | 24.31 | 24.24 | 24.28 | 3946091.0 |
| 2005-03-23 14:00:00 | MSFT | Stock | 24.28 | 24.33 | 24.28 | 24.312 | 3857343.0 |
| 2005-03-23 14:30:00 | MSFT | Stock | 24.32 | 24.32 | 24.219 | 24.23 | 4671095.0 |
| 2005-03-23 15:00:00 | MSFT | Stock | 24.22 | 24.31 | 24.21 | 24.29 | 7641837.0 |
| 2005-03-23 15:30:00 | MSFT | Stock | 24.29 | 24.32 | 24.17 | 24.17 | 7447816.0 |
| 2005-03-23 16:00:00 | MSFT | Stock | 24.2 | 24.22 | 24.18 | 24.2 | 314574.0 |
| 2005-03-23 16:30:00 | MSFT | Stock | 24.18 | 24.2 | 24.17 | 24.2 | 89263.0 |
| 2005-03-23 17:00:00 | MSFT | Stock | 24.17 | 24.2 | 24.16 | 24.2 | 66585.0 |
| 2005-03-23 17:30:00 | MSFT | Stock | 24.2 | 24.26 | 24.18 | 24.18 | 84120.0 |
| 2005-03-23 18:00:00 | MSFT | Stock | 24.18 | 24.21 | 24.18 | 24.21 | 6250.0 |
| 2005-03-23 08:00:00 | NVDA | Stock | 0.205 | 0.205 | 0.2042 | 0.2042 | 36000.0 |
| 2005-03-23 08:30:00 | NVDA | Stock | 0.2042 | 0.2042 | 0.2042 | 0.2042 | 3336000.0 |
| 2005-03-23 09:00:00 | NVDA | Stock | 0.2046 | 0.2046 | 0.2041 | 0.2042 | 1090800.0 |
| 2005-03-23 09:30:00 | NVDA | Stock | 0.2043 | 0.2075 | 0.2039 | 0.2062 | 84632280.0 |
| 2005-03-23 10:00:00 | NVDA | Stock | 0.2062 | 0.209 | 0.2061 | 0.2079 | 77970960.0 |
| 2005-03-23 10:30:00 | NVDA | Stock | 0.2079 | 0.2085 | 0.2074 | 0.2081 | 51874320.0 |
| 2005-03-23 11:00:00 | NVDA | Stock | 0.2079 | 0.2085 | 0.2074 | 0.2082 | 38381520.0 |
| 2005-03-23 11:30:00 | NVDA | Stock | 0.2082 | 0.2082 | 0.2071 | 0.2077 | 24440400.0 |
> showing 50 of 45,230 rows — these rows as CSV