PREVIEW / stock_30min / 2005-03-24
file: by_date/stock_30min/2005/2005-03-24.parquet size: 817 KB rows: 44,135 symbols: 1,950
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-24 08:00:00 | AAPL | Stock | 1.5214 | 1.5339 | 1.5214 | 1.5282 | 1830192.0 |
| 2005-03-24 08:30:00 | AAPL | Stock | 1.525 | 1.5293 | 1.525 | 1.5293 | 323036.0 |
| 2005-03-24 09:00:00 | AAPL | Stock | 1.5293 | 1.5357 | 1.5246 | 1.5336 | 1074388.0 |
| 2005-03-24 09:30:00 | AAPL | Stock | 1.5325 | 1.535 | 1.5193 | 1.5268 | 56356720.0 |
| 2005-03-24 10:00:00 | AAPL | Stock | 1.5271 | 1.5321 | 1.5254 | 1.5307 | 41859636.0 |
| 2005-03-24 10:30:00 | AAPL | Stock | 1.5311 | 1.5357 | 1.53 | 1.5329 | 37099412.0 |
| 2005-03-24 11:00:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5232 | 1.5268 | 30766764.0 |
| 2005-03-24 11:30:00 | AAPL | Stock | 1.5268 | 1.5307 | 1.5239 | 1.5293 | 14931700.0 |
| 2005-03-24 12:00:00 | AAPL | Stock | 1.5293 | 1.5311 | 1.5275 | 1.5289 | 14241332.0 |
| 2005-03-24 12:30:00 | AAPL | Stock | 1.5293 | 1.5336 | 1.5286 | 1.5314 | 18161780.0 |
| 2005-03-24 13:00:00 | AAPL | Stock | 1.5314 | 1.5321 | 1.5282 | 1.5296 | 13726552.0 |
| 2005-03-24 13:30:00 | AAPL | Stock | 1.5296 | 1.5307 | 1.5264 | 1.5271 | 15144864.0 |
| 2005-03-24 14:00:00 | AAPL | Stock | 1.5271 | 1.53 | 1.5257 | 1.5271 | 8740620.0 |
| 2005-03-24 14:30:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.525 | 1.5286 | 15215704.0 |
| 2005-03-24 15:00:00 | AAPL | Stock | 1.5282 | 1.5293 | 1.525 | 1.5261 | 22661688.0 |
| 2005-03-24 15:30:00 | AAPL | Stock | 1.5257 | 1.5282 | 1.5179 | 1.5196 | 45138072.0 |
| 2005-03-24 16:00:00 | AAPL | Stock | 1.5179 | 1.5236 | 1.5179 | 1.5225 | 5267528.0 |
| 2005-03-24 16:30:00 | AAPL | Stock | 1.5214 | 1.5243 | 1.5214 | 1.5229 | 248864.0 |
| 2005-03-24 17:00:00 | AAPL | Stock | 1.5179 | 1.5246 | 1.5179 | 1.5214 | 53060.0 |
| 2005-03-24 17:30:00 | AAPL | Stock | 1.5179 | 1.5207 | 1.5179 | 1.5207 | 97496.0 |
| 2005-03-24 18:00:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5207 | 1.5207 | 84000.0 |
| 2005-03-24 08:00:00 | MSFT | Stock | 24.3 | 24.3 | 24.27 | 24.27 | 22700.0 |
| 2005-03-24 08:30:00 | MSFT | Stock | 24.27 | 24.29 | 24.27 | 24.27 | 5806.0 |
| 2005-03-24 09:00:00 | MSFT | Stock | 24.27 | 24.3 | 24.23 | 24.24 | 161067.0 |
| 2005-03-24 09:30:00 | MSFT | Stock | 24.24 | 24.33 | 24.2 | 24.26 | 8871717.0 |
| 2005-03-24 10:00:00 | MSFT | Stock | 24.26 | 24.32 | 24.22 | 24.32 | 5843846.0 |
| 2005-03-24 10:30:00 | MSFT | Stock | 24.32 | 24.34 | 24.26 | 24.288 | 5047709.0 |
| 2005-03-24 11:00:00 | MSFT | Stock | 24.28 | 24.31 | 24.26 | 24.29 | 3788258.0 |
| 2005-03-24 11:30:00 | MSFT | Stock | 24.3 | 24.36 | 24.28 | 24.35 | 4460333.0 |
| 2005-03-24 12:00:00 | MSFT | Stock | 24.35 | 24.41 | 24.34 | 24.39 | 4225468.0 |
| 2005-03-24 12:30:00 | MSFT | Stock | 24.39 | 24.47 | 24.39 | 24.4 | 4346786.0 |
| 2005-03-24 13:00:00 | MSFT | Stock | 24.4 | 24.43 | 24.36 | 24.362 | 3758906.0 |
| 2005-03-24 13:30:00 | MSFT | Stock | 24.36 | 24.37 | 24.35 | 24.35 | 2478887.0 |
| 2005-03-24 14:00:00 | MSFT | Stock | 24.35 | 24.43 | 24.35 | 24.372 | 4275127.0 |
| 2005-03-24 14:30:00 | MSFT | Stock | 24.379 | 24.41 | 24.35 | 24.38 | 4256938.0 |
| 2005-03-24 15:00:00 | MSFT | Stock | 24.37 | 24.391 | 24.32 | 24.38 | 6406644.0 |
| 2005-03-24 15:30:00 | MSFT | Stock | 24.36 | 24.39 | 24.23 | 24.26 | 12001045.0 |
| 2005-03-24 16:00:00 | MSFT | Stock | 24.28 | 24.32 | 24.26 | 24.26 | 1387890.0 |
| 2005-03-24 16:30:00 | MSFT | Stock | 24.28 | 24.3 | 24.27 | 24.28 | 349590.0 |
| 2005-03-24 17:00:00 | MSFT | Stock | 24.28 | 24.28 | 24.27 | 24.275 | 11661.0 |
| 2005-03-24 17:30:00 | MSFT | Stock | 24.29 | 25.55 | 24.26 | 24.31 | 20912.0 |
| 2005-03-24 18:00:00 | MSFT | Stock | 24.31 | 24.31 | 24.3 | 24.3 | 600.0 |
| 2005-03-24 08:00:00 | NVDA | Stock | 0.2071 | 0.2087 | 0.2058 | 0.2062 | 900000.0 |
| 2005-03-24 08:30:00 | NVDA | Stock | 0.2083 | 0.2086 | 0.2083 | 0.2086 | 2124000.0 |
| 2005-03-24 09:00:00 | NVDA | Stock | 0.2087 | 0.2102 | 0.2085 | 0.2101 | 3696000.0 |
| 2005-03-24 09:30:00 | NVDA | Stock | 0.2096 | 0.2124 | 0.2095 | 0.2124 | 109563960.0 |
| 2005-03-24 10:00:00 | NVDA | Stock | 0.2124 | 0.2145 | 0.2122 | 0.2144 | 82851720.0 |
| 2005-03-24 10:30:00 | NVDA | Stock | 0.2144 | 0.2152 | 0.2139 | 0.2147 | 60918240.0 |
| 2005-03-24 11:00:00 | NVDA | Stock | 0.2147 | 0.2151 | 0.2128 | 0.2129 | 78151440.0 |
| 2005-03-24 11:30:00 | NVDA | Stock | 0.2128 | 0.2142 | 0.2118 | 0.2119 | 66387360.0 |
> showing 50 of 44,135 rows — these rows as CSV