PREVIEW / stock_1hour / 2001-10-15
file: by_date/stock_1hour/2001/2001-10-15.parquet size: 360 KB rows: 17,506 symbols: 1,344
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-15 08:00:00 | AAPL | Stock | 0.3245 | 0.3245 | 0.3214 | 0.3214 | 11200.0 |
| 2001-10-15 09:00:00 | AAPL | Stock | 0.3202 | 0.323 | 0.3134 | 0.3204 | 43965600.0 |
| 2001-10-15 10:00:00 | AAPL | Stock | 0.3207 | 0.3223 | 0.3196 | 0.3205 | 42302400.0 |
| 2001-10-15 11:00:00 | AAPL | Stock | 0.3209 | 0.3245 | 0.3207 | 0.3214 | 44990400.0 |
| 2001-10-15 12:00:00 | AAPL | Stock | 0.3214 | 0.3229 | 0.3204 | 0.3218 | 16531200.0 |
| 2001-10-15 13:00:00 | AAPL | Stock | 0.3216 | 0.3243 | 0.3209 | 0.3232 | 17203200.0 |
| 2001-10-15 14:00:00 | AAPL | Stock | 0.3232 | 0.3277 | 0.3216 | 0.3216 | 42324800.0 |
| 2001-10-15 15:00:00 | AAPL | Stock | 0.3218 | 0.3232 | 0.3205 | 0.3214 | 78500800.0 |
| 2001-10-15 16:00:00 | AAPL | Stock | 0.3214 | 0.3227 | 0.3203 | 0.3216 | 21851200.0 |
| 2001-10-15 08:00:00 | MSFT | Stock | 28.055 | 28.075 | 27.965 | 28.0 | 24000.0 |
| 2001-10-15 09:00:00 | MSFT | Stock | 27.89 | 28.1205 | 27.75 | 27.8655 | 6363000.0 |
| 2001-10-15 10:00:00 | MSFT | Stock | 27.87 | 28.275 | 27.8 | 28.1695 | 10365600.0 |
| 2001-10-15 11:00:00 | MSFT | Stock | 28.175 | 28.705 | 28.11 | 28.61 | 13009600.0 |
| 2001-10-15 12:00:00 | MSFT | Stock | 28.61 | 28.775 | 28.375 | 28.565 | 7431200.0 |
| 2001-10-15 13:00:00 | MSFT | Stock | 28.57 | 28.97 | 28.51 | 28.925 | 7494400.0 |
| 2001-10-15 14:00:00 | MSFT | Stock | 28.92 | 29.0312 | 28.675 | 28.7 | 8624200.0 |
| 2001-10-15 15:00:00 | MSFT | Stock | 28.7 | 29.25 | 28.7 | 29.025 | 10385800.0 |
| 2001-10-15 16:00:00 | MSFT | Stock | 29.03 | 29.0985 | 28.498 | 28.91 | 1564000.0 |
| 2001-10-15 17:00:00 | MSFT | Stock | 28.92 | 28.97 | 28.745 | 28.745 | 50600.0 |
| 2001-10-15 18:00:00 | MSFT | Stock | 28.795 | 28.85 | 28.795 | 28.85 | 1200.0 |
| 2001-10-15 08:00:00 | NVDA | Stock | 0.3275 | 0.33 | 0.3259 | 0.3292 | 1176000.0 |
| 2001-10-15 09:00:00 | NVDA | Stock | 0.3282 | 0.3328 | 0.3214 | 0.3238 | 134244000.0 |
| 2001-10-15 10:00:00 | NVDA | Stock | 0.3238 | 0.3292 | 0.3179 | 0.3242 | 136176000.0 |
| 2001-10-15 11:00:00 | NVDA | Stock | 0.3243 | 0.3337 | 0.3241 | 0.3292 | 107424000.0 |
| 2001-10-15 12:00:00 | NVDA | Stock | 0.3292 | 0.3332 | 0.3287 | 0.3297 | 63264000.0 |
| 2001-10-15 13:00:00 | NVDA | Stock | 0.3297 | 0.3396 | 0.3281 | 0.3394 | 107064000.0 |
| 2001-10-15 14:00:00 | NVDA | Stock | 0.3394 | 0.3437 | 0.3334 | 0.3342 | 160500000.0 |
| 2001-10-15 15:00:00 | NVDA | Stock | 0.3342 | 0.3399 | 0.3333 | 0.336 | 163884000.0 |
| 2001-10-15 16:00:00 | NVDA | Stock | 0.3358 | 0.3362 | 0.3333 | 0.3333 | 8988000.0 |
| 2001-10-15 17:00:00 | NVDA | Stock | 0.3312 | 0.3354 | 0.3304 | 0.3354 | 576000.0 |
| 2001-10-15 18:00:00 | NVDA | Stock | 0.3305 | 0.3312 | 0.3305 | 0.3312 | 240000.0 |
| 2001-10-15 08:00:00 | AMZN | Stock | 0.402 | 0.41 | 0.4 | 0.407 | 530000.0 |
| 2001-10-15 09:00:00 | AMZN | Stock | 0.405 | 0.44 | 0.405 | 0.4315 | 30222000.0 |
| 2001-10-15 10:00:00 | AMZN | Stock | 0.433 | 0.438 | 0.424 | 0.4265 | 32308000.0 |
| 2001-10-15 11:00:00 | AMZN | Stock | 0.4265 | 0.442 | 0.425 | 0.4365 | 19932000.0 |
| 2001-10-15 12:00:00 | AMZN | Stock | 0.436 | 0.44 | 0.431 | 0.433 | 10362000.0 |
| 2001-10-15 13:00:00 | AMZN | Stock | 0.432 | 0.4495 | 0.432 | 0.449 | 16968000.0 |
| 2001-10-15 14:00:00 | AMZN | Stock | 0.4485 | 0.4595 | 0.4425 | 0.4495 | 23096000.0 |
| 2001-10-15 15:00:00 | AMZN | Stock | 0.4495 | 0.4525 | 0.4425 | 0.4445 | 26586000.0 |
| 2001-10-15 16:00:00 | AMZN | Stock | 0.4445 | 0.4485 | 0.44 | 0.445 | 2136000.0 |
| 2001-10-15 17:00:00 | AMZN | Stock | 0.445 | 0.4485 | 0.4425 | 0.444 | 198000.0 |
| 2001-10-15 18:00:00 | AMZN | Stock | 0.445 | 0.4495 | 0.445 | 0.4495 | 50000.0 |
| 2001-10-15 09:00:00 | CL | Stock | 28.725 | 28.825 | 28.645 | 28.655 | 140400.0 |
| 2001-10-15 10:00:00 | CL | Stock | 28.65 | 28.725 | 28.5 | 28.505 | 197200.0 |
| 2001-10-15 11:00:00 | CL | Stock | 28.5 | 28.7 | 28.425 | 28.5 | 201600.0 |
| 2001-10-15 12:00:00 | CL | Stock | 28.475 | 28.56 | 28.375 | 28.415 | 334400.0 |
| 2001-10-15 13:00:00 | CL | Stock | 28.45 | 28.595 | 28.45 | 28.45 | 122000.0 |
| 2001-10-15 14:00:00 | CL | Stock | 28.45 | 28.535 | 28.4 | 28.415 | 369200.0 |
| 2001-10-15 15:00:00 | CL | Stock | 28.4 | 28.5 | 28.375 | 28.5 | 422600.0 |
| 2001-10-15 16:00:00 | CL | Stock | 28.5 | 28.55 | 28.5 | 28.55 | 61600.0 |
> showing 50 of 17,506 rows — these rows as CSV