PREVIEW / stock_30min / 2005-07-19
file: by_date/stock_30min/2005/2005-07-19.parquet size: 840 KB rows: 45,417 symbols: 2,031
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-07-19 07:30:00 | AAPL | Stock | 1.5014 | 1.5032 | 1.4946 | 1.4946 | 50400.0 |
| 2005-07-19 08:00:00 | AAPL | Stock | 1.495 | 1.495 | 1.4907 | 1.4914 | 740068.0 |
| 2005-07-19 08:30:00 | AAPL | Stock | 1.4914 | 1.4925 | 1.4857 | 1.4904 | 389200.0 |
| 2005-07-19 09:00:00 | AAPL | Stock | 1.4904 | 1.4932 | 1.4821 | 1.4829 | 2312100.0 |
| 2005-07-19 09:30:00 | AAPL | Stock | 1.4829 | 1.4982 | 1.4668 | 1.4911 | 65809604.0 |
| 2005-07-19 10:00:00 | AAPL | Stock | 1.4914 | 1.5154 | 1.49 | 1.5132 | 83320720.0 |
| 2005-07-19 10:30:00 | AAPL | Stock | 1.5132 | 1.5232 | 1.5114 | 1.5161 | 72713928.0 |
| 2005-07-19 11:00:00 | AAPL | Stock | 1.5157 | 1.5193 | 1.5125 | 1.5164 | 33271840.0 |
| 2005-07-19 11:30:00 | AAPL | Stock | 1.5161 | 1.5196 | 1.5139 | 1.5164 | 19834668.0 |
| 2005-07-19 12:00:00 | AAPL | Stock | 1.5164 | 1.5239 | 1.5154 | 1.5229 | 27195672.0 |
| 2005-07-19 12:30:00 | AAPL | Stock | 1.5229 | 1.5296 | 1.5225 | 1.5275 | 30861488.0 |
| 2005-07-19 13:00:00 | AAPL | Stock | 1.5271 | 1.5336 | 1.5271 | 1.5304 | 40878040.0 |
| 2005-07-19 13:30:00 | AAPL | Stock | 1.5307 | 1.5314 | 1.5239 | 1.5246 | 24113544.0 |
| 2005-07-19 14:00:00 | AAPL | Stock | 1.5243 | 1.5321 | 1.5239 | 1.5318 | 25986632.0 |
| 2005-07-19 14:30:00 | AAPL | Stock | 1.5314 | 1.5371 | 1.5311 | 1.5357 | 59477740.0 |
| 2005-07-19 15:00:00 | AAPL | Stock | 1.5353 | 1.5386 | 1.5318 | 1.5332 | 51762368.0 |
| 2005-07-19 15:30:00 | AAPL | Stock | 1.5332 | 1.5439 | 1.5329 | 1.5432 | 121031876.0 |
| 2005-07-19 16:00:00 | AAPL | Stock | 1.5439 | 1.5443 | 1.5379 | 1.5382 | 2593892.0 |
| 2005-07-19 16:30:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5179 | 1.5268 | 3347344.0 |
| 2005-07-19 17:00:00 | AAPL | Stock | 1.5268 | 1.5318 | 1.5239 | 1.525 | 983640.0 |
| 2005-07-19 17:30:00 | AAPL | Stock | 1.525 | 1.5439 | 1.5232 | 1.5243 | 750400.0 |
| 2005-07-19 18:00:00 | AAPL | Stock | 1.5321 | 1.5321 | 1.5218 | 1.5218 | 497280.0 |
| 2005-07-19 08:00:00 | MSFT | Stock | 25.79 | 25.8 | 25.7 | 25.74 | 15090.0 |
| 2005-07-19 08:30:00 | MSFT | Stock | 25.72 | 25.8 | 25.71 | 25.76 | 18906.0 |
| 2005-07-19 09:00:00 | MSFT | Stock | 25.76 | 25.79 | 25.71 | 25.78 | 273972.0 |
| 2005-07-19 09:30:00 | MSFT | Stock | 25.79 | 25.97 | 25.75 | 25.962 | 13389636.0 |
| 2005-07-19 10:00:00 | MSFT | Stock | 25.96 | 26.01 | 25.89 | 25.99 | 10135348.0 |
| 2005-07-19 10:30:00 | MSFT | Stock | 25.99 | 26.05 | 25.97 | 25.98 | 9478563.0 |
| 2005-07-19 11:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.88 | 25.96 | 5800811.0 |
| 2005-07-19 11:30:00 | MSFT | Stock | 25.96 | 26.2 | 25.95 | 26.1 | 15017536.0 |
| 2005-07-19 12:00:00 | MSFT | Stock | 26.1 | 26.12 | 26.05 | 26.08 | 5299194.0 |
| 2005-07-19 12:30:00 | MSFT | Stock | 26.08 | 26.09 | 26.0 | 26.03 | 3888096.0 |
| 2005-07-19 13:00:00 | MSFT | Stock | 26.03 | 26.06 | 26.0 | 26.03 | 3632975.0 |
| 2005-07-19 13:30:00 | MSFT | Stock | 26.03 | 26.06 | 26.01 | 26.03 | 2364227.0 |
| 2005-07-19 14:00:00 | MSFT | Stock | 26.04 | 26.1 | 25.99 | 26.088 | 4780140.0 |
| 2005-07-19 14:30:00 | MSFT | Stock | 26.09 | 26.19 | 26.08 | 26.18 | 8704759.0 |
| 2005-07-19 15:00:00 | MSFT | Stock | 26.18 | 26.25 | 26.15 | 26.22 | 13164013.0 |
| 2005-07-19 15:30:00 | MSFT | Stock | 26.22 | 26.24 | 26.044 | 26.18 | 14191416.0 |
| 2005-07-19 16:00:00 | MSFT | Stock | 26.17 | 26.18 | 25.98 | 26.01 | 887490.0 |
| 2005-07-19 16:30:00 | MSFT | Stock | 25.98 | 25.99 | 25.45 | 25.9 | 329821.0 |
| 2005-07-19 17:00:00 | MSFT | Stock | 25.9 | 25.91 | 25.87 | 25.87 | 36281.0 |
| 2005-07-19 17:30:00 | MSFT | Stock | 25.88 | 26.22 | 25.85 | 25.88 | 79392.0 |
| 2005-07-19 18:00:00 | MSFT | Stock | 25.88 | 25.88 | 25.85 | 25.88 | 36551.0 |
| 2005-07-19 08:30:00 | NVDA | Stock | 0.2202 | 0.2202 | 0.2202 | 0.2202 | 12000.0 |
| 2005-07-19 09:00:00 | NVDA | Stock | 0.2192 | 0.2207 | 0.2192 | 0.2197 | 401280.0 |
| 2005-07-19 09:30:00 | NVDA | Stock | 0.2198 | 0.222 | 0.2182 | 0.2198 | 106767000.0 |
| 2005-07-19 10:00:00 | NVDA | Stock | 0.2198 | 0.2212 | 0.2187 | 0.221 | 75531240.0 |
| 2005-07-19 10:30:00 | NVDA | Stock | 0.221 | 0.2212 | 0.2201 | 0.2203 | 62844120.0 |
| 2005-07-19 11:00:00 | NVDA | Stock | 0.2202 | 0.2206 | 0.2192 | 0.22 | 28812480.0 |
| 2005-07-19 11:30:00 | NVDA | Stock | 0.22 | 0.2205 | 0.2192 | 0.2202 | 19117440.0 |
> showing 50 of 45,417 rows — these rows as CSV