PREVIEW / stock_30min / 2005-03-18
file: by_date/stock_30min/2005/2005-03-18.parquet size: 869 KB rows: 45,899 symbols: 1,939
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-18 08:00:00 | AAPL | Stock | 1.5571 | 1.5675 | 1.5436 | 1.5568 | 10655260.0 |
| 2005-03-18 08:30:00 | AAPL | Stock | 1.5568 | 1.5614 | 1.5482 | 1.5543 | 4316956.0 |
| 2005-03-18 09:00:00 | AAPL | Stock | 1.5539 | 1.5571 | 1.5179 | 1.5475 | 12607896.0 |
| 2005-03-18 09:30:00 | AAPL | Stock | 1.5475 | 1.5514 | 1.5214 | 1.5279 | 216851096.0 |
| 2005-03-18 10:00:00 | AAPL | Stock | 1.5279 | 1.5375 | 1.525 | 1.5314 | 96722892.0 |
| 2005-03-18 10:30:00 | AAPL | Stock | 1.5314 | 1.5354 | 1.525 | 1.535 | 54341700.0 |
| 2005-03-18 11:00:00 | AAPL | Stock | 1.5354 | 1.5414 | 1.5318 | 1.5357 | 52369828.0 |
| 2005-03-18 11:30:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.53 | 1.5329 | 26790736.0 |
| 2005-03-18 12:00:00 | AAPL | Stock | 1.5332 | 1.5346 | 1.53 | 1.5307 | 18026372.0 |
| 2005-03-18 12:30:00 | AAPL | Stock | 1.5307 | 1.5332 | 1.5254 | 1.5264 | 20827464.0 |
| 2005-03-18 13:00:00 | AAPL | Stock | 1.5264 | 1.5304 | 1.5218 | 1.5225 | 40596892.0 |
| 2005-03-18 13:30:00 | AAPL | Stock | 1.5225 | 1.5246 | 1.5179 | 1.5225 | 38136364.0 |
| 2005-03-18 14:00:00 | AAPL | Stock | 1.5225 | 1.5268 | 1.5207 | 1.5246 | 32089764.0 |
| 2005-03-18 14:30:00 | AAPL | Stock | 1.5246 | 1.5318 | 1.52 | 1.5232 | 38722684.0 |
| 2005-03-18 15:00:00 | AAPL | Stock | 1.5236 | 1.5257 | 1.5186 | 1.5254 | 49404124.0 |
| 2005-03-18 15:30:00 | AAPL | Stock | 1.5254 | 1.5364 | 1.5225 | 1.5332 | 121705612.0 |
| 2005-03-18 16:00:00 | AAPL | Stock | 1.5325 | 1.5396 | 1.5321 | 1.5396 | 13565804.0 |
| 2005-03-18 16:30:00 | AAPL | Stock | 1.5343 | 1.5396 | 1.5337 | 1.5337 | 4338936.0 |
| 2005-03-18 17:00:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5337 | 1.5361 | 5259968.0 |
| 2005-03-18 17:30:00 | AAPL | Stock | 1.5337 | 1.5389 | 1.5337 | 1.5389 | 6534752.0 |
| 2005-03-18 18:00:00 | AAPL | Stock | 1.5389 | 1.5404 | 1.5339 | 1.5393 | 3673208.0 |
| 2005-03-18 08:00:00 | MSFT | Stock | 24.51 | 24.55 | 24.4 | 24.54 | 22440.0 |
| 2005-03-18 08:30:00 | MSFT | Stock | 24.52 | 24.54 | 24.5 | 24.53 | 22631.0 |
| 2005-03-18 09:00:00 | MSFT | Stock | 24.53 | 24.57 | 24.47 | 24.52 | 712124.0 |
| 2005-03-18 09:30:00 | MSFT | Stock | 24.53 | 24.57 | 24.45 | 24.52 | 17797327.0 |
| 2005-03-18 10:00:00 | MSFT | Stock | 24.51 | 24.68 | 24.5 | 24.62 | 6758453.0 |
| 2005-03-18 10:30:00 | MSFT | Stock | 24.62 | 24.63 | 24.5 | 24.55 | 4716632.0 |
| 2005-03-18 11:00:00 | MSFT | Stock | 24.55 | 24.67 | 24.53 | 24.66 | 4066015.0 |
| 2005-03-18 11:30:00 | MSFT | Stock | 24.65 | 24.67 | 24.589 | 24.59 | 2542971.0 |
| 2005-03-18 12:00:00 | MSFT | Stock | 24.59 | 24.6 | 24.55 | 24.55 | 1983212.0 |
| 2005-03-18 12:30:00 | MSFT | Stock | 24.55 | 24.6 | 24.45 | 24.46 | 2089142.0 |
| 2005-03-18 13:00:00 | MSFT | Stock | 24.46 | 24.49 | 24.42 | 24.44 | 3541468.0 |
| 2005-03-18 13:30:00 | MSFT | Stock | 24.43 | 24.91 | 24.37 | 24.45 | 6644665.0 |
| 2005-03-18 14:00:00 | MSFT | Stock | 24.45 | 24.46 | 24.35 | 24.43 | 4776365.0 |
| 2005-03-18 14:30:00 | MSFT | Stock | 24.43 | 24.48 | 24.369 | 24.37 | 6519308.0 |
| 2005-03-18 15:00:00 | MSFT | Stock | 24.37 | 24.42 | 24.29 | 24.401 | 8093529.0 |
| 2005-03-18 15:30:00 | MSFT | Stock | 24.4 | 24.47 | 24.28 | 24.33 | 20246233.0 |
| 2005-03-18 16:00:00 | MSFT | Stock | 24.33 | 24.37 | 24.31 | 24.33 | 7954675.0 |
| 2005-03-18 16:30:00 | MSFT | Stock | 24.31 | 24.36 | 24.305 | 24.35 | 3237298.0 |
| 2005-03-18 17:00:00 | MSFT | Stock | 24.325 | 24.38 | 24.303 | 24.38 | 3208654.0 |
| 2005-03-18 17:30:00 | MSFT | Stock | 24.38 | 24.38 | 24.32 | 24.32 | 2213606.0 |
| 2005-03-18 18:00:00 | MSFT | Stock | 24.36 | 24.36 | 24.32 | 24.36 | 1907814.0 |
| 2005-03-18 08:00:00 | NVDA | Stock | 0.2077 | 0.2077 | 0.2061 | 0.2061 | 84000.0 |
| 2005-03-18 09:00:00 | NVDA | Stock | 0.2062 | 0.2064 | 0.2052 | 0.2062 | 576000.0 |
| 2005-03-18 09:30:00 | NVDA | Stock | 0.2057 | 0.2064 | 0.2011 | 0.2015 | 113599320.0 |
| 2005-03-18 10:00:00 | NVDA | Stock | 0.2014 | 0.2037 | 0.2004 | 0.2023 | 92295360.0 |
| 2005-03-18 10:30:00 | NVDA | Stock | 0.2023 | 0.2023 | 0.2008 | 0.2009 | 47053680.0 |
| 2005-03-18 11:00:00 | NVDA | Stock | 0.2009 | 0.2034 | 0.2009 | 0.2029 | 41731440.0 |
| 2005-03-18 11:30:00 | NVDA | Stock | 0.2029 | 0.2032 | 0.2019 | 0.2019 | 23862600.0 |
| 2005-03-18 12:00:00 | NVDA | Stock | 0.2021 | 0.2027 | 0.2017 | 0.2022 | 18239280.0 |
> showing 50 of 45,899 rows — these rows as CSV